Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T09:17:37.747' ,`MLSNumber` = '52520055' ,`ListAgentFullName` = 'Rosalva Cardenas' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.449837' ,`Longitude` = '-95.322382' ,`PhotoCount` = '26' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '700000.00' ,`Status` = 'Active' ,`StreetName` = 'Bissell' ,`StreetNumber` = '9500' ,`StreetSuffix` = 'Road' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Ranch style house On two acres with a pond. It can be used as a Possibly Commercial as well check with city. No restrictions. Very private, Very peaceful.\r\nTwo primary bedrooms, plus a mother in law or guest apartment.\r\n FOR SALE Property is being leased month to month.' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Stove' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Butane' ,`HOAMandatory` = '0' ,`Legal` = 'A0231 H T & B R R TRACT 7A1 ACRES 9.973' ,`LotDesciption` = 'Cleared,Other,Water View,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '10049' ,`TaxRate` = '2.219' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095756' WHERE `Matrix_Unique_ID` = '194469238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T10:54:10.863' ,`MLSNumber` = '23511550' ,`ListAgentFullName` = 'Mary Beth Hrabina' ,`ListOfficeName` = 'Hrabina Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785178' ,`Longitude` = '-94.914499' ,`PhotoCount` = '43' ,`PostalCode` = '77521' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Bend' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2199' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dreaming of a 4 bedroom home with No City Taxes. Located off Hwy 146 in Chambers County on Horsepen Gully. Completely remodeled in 2017/2018 after Harvey Flood. Per Owner- House taken down to studs. Remodel included: Roof, HVAC, windows, sheetrock, trim, doors, cabinetry, flooring, appliances, solar panels. Open concept living area w/fireplace. Property includes 5 lots for approximately 1.75 acres. Buyer to purchase survey. Fence line on West side of property is an estimate of where property line is. Schedule your appointment today.' ,`Acres` = '1.75' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '15, 16, 17, 18, 19 BAYOU BEND' ,`LotDesciption` = 'Subdivision Lot,Waterfront,Wooded' ,`LotSize` = '76230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bayou Bend' ,`TaxAmount` = '5421' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095756' WHERE `Matrix_Unique_ID` = '210000809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T10:02:18.703' ,`MLSNumber` = '57747733' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = 'LaSamuel Clewis' ,`SellingOfficeName` = 'Exit Realty 360' ,`Latitude` = '29.469928' ,`Longitude` = '-95.463559' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '249990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Serena Park' ,`StreetNumber` = '338' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Ashburn Plan with Elevation N, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\"\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\"\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'DR HORTON, INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675095757' WHERE `Matrix_Unique_ID` = '210871379' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T10:45:00.340' ,`MLSNumber` = '98226828' ,`ListAgentFullName` = 'Jaime Hinson' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.943710' ,`Longitude` = '-95.330961' ,`PhotoCount` = '50' ,`PostalCode` = '75862' ,`RoomCount` = '13' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry' ,`StreetNumber` = '45' ,`StreetSuffix` = 'Hills' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM RANCH STYLE GORGEOUS HOME on THREE LOTS on the GOLF COURSE GREEN in the Master Community on the LAKE in WESTWOOD SHORES! This is a rare opportunity of bustling new construction and original homes. What this home offers over the others is the connected 3 lot build which includes a golf cart garage, Craft/workshop/office separate across a covered breezeway, covered walkways, oversized tandem garage fits multiple vehicles/boats, garage half bath, built out stairs to attic above garage, hot tub, sunroom with waterfall, new deck, new roof, invisible fencing between home and golf course green, great if you have pets that need fencing but also keep the amazing views. Escape here full time with a short golf cart ride to lake, fitness center, tennis courts, pool, clubhouse, boat dock, lake side put put golf, convenience store by lake, boat dock, guest RV Camping, full time manned gate and patrol, and MORE! P.S. Deer gaze freely as neighbors.' ,`Acres` = '0.4701' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 07, BLOCK 75 LOT 15,16,17' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '20477' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '178' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Photos/No Videos,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westwood Shores Sec 7' ,`TaxAmount` = '6566' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095757' WHERE `Matrix_Unique_ID` = '212372807' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T10:27:49.973' ,`MLSNumber` = '45982607' ,`ListAgentFullName` = 'Jill Evans' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743353' ,`Longitude` = '-95.733298' ,`PhotoCount` = '48' ,`PostalCode` = '77450' ,`RoomCount` = '13' ,`ListPrice` = '749500.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Shore' ,`StreetNumber` = '2618' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE!! Immaculately maintained, elegant Kickerillo home in Kelliwood Lakes. Home is nestled in this beautiful gated community in the sought after Katy ISD school zone. Lake view from your front door; scenic views from the back; enjoy your upper level balcony/patio with no rear neighbors! Stunning formal living room with soaring ceilings, gas fireplace and large windows for ample natural light. Sunken white marble wet bar between the formal living room and dining room - ideal for entertaining and family gatherings! Massive upper gameroom is complete with a wet bar and upper patio access. Country kitchen opens to spacious den with brick fireplace and built-in shelving. Huge primary suite on first floor, with private patio entrance; soaker tub and separate stand up shower in primary bath. Escape to the quiet study on the first floor with its own fireplace. HVAC replaced in 2017 - Roof in 2015 no storm damage. *Grand Piano and Pool Table can be included in sale* Don\'t miss this one!!' ,`Acres` = '0.3557' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 3 KELLIWOOD LAKES SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3087' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Lakes Sec 01 Prcl R/' ,`TaxAmount` = '14176' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095757' WHERE `Matrix_Unique_ID` = '212697598' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T10:07:40.820' ,`MLSNumber` = '23397692' ,`ListAgentFullName` = 'Booker Morris' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811667' ,`Longitude` = '-95.020583' ,`PhotoCount` = '22' ,`PostalCode` = '77562' ,`RoomCount` = '9' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Tracy' ,`StreetNumber` = '2623' ,`StreetSuffix` = 'Lane' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price Reduction! This well maintained and recently built 4 bed/ 2.5 bath home located in the Nowlingshire Estates neighborhood. Say goodbye to paying for electricity with these high end solar panels. Additional amenities include an open floor plan, abundance of natural light, high ceilings, spacious rooms, game room, Epoxy garage flooring, ample storage, and spacious back yard.' ,`Acres` = '0.1286' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 1 NOWLINGSHIRE ESTATES PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '290' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Nowlingshire Estates Pt Repl' ,`TaxAmount` = '4625' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095757' WHERE `Matrix_Unique_ID` = '213816786' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T09:52:31.183' ,`MLSNumber` = '48692885' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655458' ,`Longitude` = '-95.053224' ,`PhotoCount` = '37' ,`PostalCode` = '77571' ,`RoomCount` = '11' ,`ListPrice` = '440397.00' ,`Status` = 'Active' ,`StreetName` = 'Vanessa Cay' ,`StreetNumber` = '2342' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#48692885 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, April 2023 Completion! The Jasmine in Morgan’s Landing has spacious living areas, attractive touches, and upgrades throughout! The kitchen features an island that overlooks the dining and family room - ideal for entertaining! Enjoy the views to the covered outdoor patio while preparing meals. The owner’s suite offers a peaceful spot for unwinding in the evening with a soaking tub and walk-in shower. The private study is great for a home office or workout room. A private guest bedroom and shared full bath is near the owner’s entry from the 2-car garage. The remaining 2 bedrooms are upstairs along with a game room and media room – perfect for family fun nights! Design upgrades include: built-in kitchen appliances, kitchen pendant lights, and blinds. Structural options include: media room, additional bedroom downstairs, slide-in tube at owner’s bath, open railing, and study.' ,`Acres` = '0.146' ,`Area` = '7' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1 of Morgan\'s Landing Section 14' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '6361' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing 45\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675095757' WHERE `Matrix_Unique_ID` = '214505657' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215460612','1675095758','215460612','2022-12-26T09:09:40.213','81652033','Zonia Alvarez','Coldwell Banker RealtyThe Willis Office','','','29.863603','-95.599441','36','77041','10','390000.00','Active','Summerwood','12715','Glen','Houston','2','1','4','2399','Single-Family','Lovely and spacious in the beautiful community of Villages of Lakepointe! Situated in a cul-de-sac on over a 1/4 of an acre this beauty is ready for immediate move in and features 4 bedrooms, 2.5 baths, 3 car garage, formal dining plus a study.This home offers amazing features, an abundance of natural lighting and an open concept floor plan ideal for entertaining family and friends. HUGE owners retreat provides enough room for a sitting area and the ensuite bath is equipped with dual sinks, separate shower and jetted garden tub. OVERSIZED fully fenced backyard with sprinkler system is large enough for the kids, pets and all of your gardening needs. New carpet in living area and bedrooms. Community amenities within walking distance include a pool, playground and clubhouse. Zoned to highly acclaimed Cy-Fair ISD. Conveniently located to shopping, dining and within minutes of Hwy 290, Beltway 8, I-10 and Hwy 6.','0.2667','8','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Eldridge North','Central Gas','1','LT 50 BLK 1 VILLAGES AT LAKEPOINTE SEC 2','Cul-De-Sac','11616','Appraisal District','','1006','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Builder','2','Traditional','Villages At Lakepointe','7040','2.431','Public Sewer,Water District','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215610189','1675095758','215610189','2022-12-26T10:00:56.010','32384194','Boching Wang','FCI Properties','','','29.647330','-95.592300','32','77477','10','339000.00','Active','Meadow Bend','12211','Court','Meadows Place','2','1','4','2457','Single-Family','Ready to move in. New concrete driveway. In the Cul-de-sac, 2-story property with recent paint, tile from front door through the whole first floor, laminate in stair and the 2nd floor. 4 bedrooms plus game room, all bedrooms have ceiling fans, walk-in closets, master bathroom has double sinks, tub and separate shower. The family room with fireplace. Easy access to W Airport, Hwy 59, Hwy 90 and Sam Houston Parkway. A Must-See','0.1893','29','','','Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Stafford Area','Central Gas','0','MEADOWGLEN SEC 3, BLOCK 2, LOT 74','Subdivision Lot','8247','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','MEADOWS ELEMENTARY SCHOOL (FORT BEND)','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Meadowglen','7758','2.4949','Public Sewer,Public Water','1996','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215759401','1675095758','215759401','2022-12-26T09:30:20.253','69501165','Rayanna Eury','Gulf Coast Star Realty, LLC','','','28.775271','-95.631307','16','77414','5','240000.00','Active','County Road 209','255','','Sargent','1','0','2','1418','Single-Family','READY TO FINISH A REMODEL? Sitting on 2 Canal lots. Beautiful views and a home that is in the middle of a complete remodel? They have started the remodel: 11 engineered pilings have been replaced, a new roof with a WPI8 certificate and one room was replaced due to structural issues. Amazing views of Old Caney and the new bridge. You can watch the barges go down the ICW from this location. All the structural work has been done and engineered with a foundation plan! Come and see if this is the place for you!','0.2181','54','','','','','Mud','','','','','No Heating','1','DOWNEY CANEY CREEK SEC 2, BLOCK 4, LOT 68-69, ACRES .2181','Water View,Waterfront','9500','Appraisal District','','40','0','','0','','0','','','','','Composition','134 - Van Vleck','VAN VLECK ELEMENTARY SCHOOL','VAN VLECK HIGH SCHOOL','O H HERMAN MIDDLE SCHOOL','Appointment Required,Lockbox Right Side','Appraisal District','1','Other Style','Downey Caney Creek Sec 2','4414','2.325','Public Sewer,Public Water','1965','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215841425','1675095758','215841425','2022-12-26T10:39:28.007','31749604','Gayle Kennedy','Keller Williams Metropolitan','','','29.714362','-95.352826','0','77004','7','295000.00','Active','Rosedale','3837','Street','Houston','2','0','3','1342','Single-Family','Just minutes to Downtown, the Med Center, U of H, TSU, Hermann Park and more. Bright, open floorplan with no carpet. This home was taken to the studs and fully renovated in 2018 and 2019. The foundation was leveled, plumbing replaced, electrical replaced, new double pane vinyl windows, roof replaced, new flooring and new driveway. The kitchen includes a generous pantry, granite counters, recent cabinets and stainless steel appliances - refrigerator included. Just beautiful and waiting for you! The HVAC is a 16 SEER rated Carrier system to help lower the electrical bills. There are generous closets in each bedroom and the utility room is in the house with washer and dryer included in the sale. Come take a look today!','0.1543','4','','','Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','University Area','Central Gas','0','LT 25 BLK 5 OAK MANOR SEC 1','Subdivision Lot','6720','Appraisal District','','','0','','0','Single Oven','0','','','Gas Range','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Traditional','Oak Manor 1','3035','2.6454','Public Sewer,Public Water','1951','Appraisal District'); --> New record created successfully