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-21T07:12:37.387' ,`MLSNumber` = '23659198' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777843' ,`Longitude` = '-95.318389' ,`PhotoCount` = '19' ,`PostalCode` = '77020' ,`RoomCount` = '4' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Hershe' ,`StreetNumber` = '5200' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW UPDATED HOUSE!!! UPDATED KITCHEN AND BATHROOMS!!!\r\nThis is a three bedroom two baths house. This home has many updates, kitchen cabinets, granite counter, appliances, lights, spotlights, carpet, vinyl laminate planks, fan, interior/exterior paint, doors, baseboards and many other. UPDATED A/C and HEATING!!!!!!! A GORGEOUS ISLAND HAS BEEN ADDED TO THE KITCHEN!!!!!!!! THIS HOUSE BOASTS A LUXURIOUS LAMINATE VINYL PLANKS. NEW ROOF was installed' ,`Acres` = '0.1274' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 10 PINECREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5550' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinecrest' ,`TaxAmount` = '2338' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093837' WHERE `Matrix_Unique_ID` = '207585563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:55:56.180' ,`MLSNumber` = '12514546' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Christine Nguyen' ,`SellingOfficeName` = 'AB Realty Corp' ,`Latitude` = '29.701848' ,`Longitude` = '-95.706490' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '338990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '6810' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home under Construction - This Harris! Stunning Entry! This lovely home you are greeted with High Ceilings, extended hallway and Beautiful Carefree Vinyl Plank Wood Flooring throughout! Luxurious Carpeting in all bedrooms! Two Full Baths plus Half Bath! The Family Room features Walls of Windows projecting abundance of natural light inside! Your Casual Dining area flows gracefully into your Gourmet Kitchen which features Quartz Counters, lots of Tall Shaker Cabinets for storage space, Stainless Appliances, Large Eat-in & Working Island with Under-mount Stainless Sink & more! Private Owner\'s Suite features Luxurious bathroom Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless Water Heater & features the \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Amenities include: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 18 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093837' WHERE `Matrix_Unique_ID` = '209646887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:59:11.677' ,`MLSNumber` = '95451201' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Diane Rendon' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '33' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '274990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cold Water' ,`StreetNumber` = '14807' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes! Ready for Move In! Located in TOP #1 School District for all ages! Beautiful Stylish Timeless Chic 1 story Ranch home features Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Amazing Open Floor Plan Features Huge Family Area that Flows into the Gourmet Kitchen With Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Beautiful Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio & Large Backyard! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING! Low, Low Tax Rates!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 34 /Block: 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093837' WHERE `Matrix_Unique_ID` = '210306412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T07:28:40.130' ,`MLSNumber` = '70178052' ,`ListAgentFullName` = 'Santiago Galindo' ,`ListOfficeName` = 'Mission Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075048' ,`Longitude` = '-94.738309' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = '-4021-A' ,`StreetNumber` = '162 R' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Inddian Ridge,Sec2,Lot12,Acres.5,MHLabel#' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093838' WHERE `Matrix_Unique_ID` = '210369508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:57:55.533' ,`MLSNumber` = '76919232' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Candace Creel' ,`SellingOfficeName` = 'Luxe Living Group, LLC' ,`Latitude` = '29.701834' ,`Longitude` = '-95.706431' ,`PhotoCount` = '23' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '319900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Telford Hollow' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Under Construction! Ultra Modern & Chic Elevation! Gorgeous Upgraded Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen with stunning Quartz Countertops, Tile Back-splash, Large Eat-in Working Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Rm with Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 with His & Her Sink Vanity, Deep Soaker Tub, Shower W/Seamless Glass Door & Walk-in Closet! Energy Efficient Home: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & More! 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 2 /Block: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093838' WHERE `Matrix_Unique_ID` = '210375191' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:52:45.273' ,`MLSNumber` = '82609877' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223119' ,`Longitude` = '-95.359625' ,`PhotoCount` = '28' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '326' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming three bedroom, two bath home is known for its intelligent use of space and now features an even more open living area. The large kitchen granite-topped island opens up to your living room to provide a cozy flow throughout the home. Your dining area features the most charming window you\'ll ever see. Featuring large walk-in closets, luxury flooring, and volume ceilings - this beauty certainly delivers when it comes to affordable luxury. Additional options include: 42\" cabinets, stainless steel appliances, additional LED recessed lighting, dual primary bathroom vanity, and painted cabinets throughout.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929602 - The Lakes At Crockett Martin 02, BLOCK 2, Lot 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes at Crockett Martin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093838' WHERE `Matrix_Unique_ID` = '214805427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:53:44.660' ,`MLSNumber` = '69047356' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223119' ,`Longitude` = '-95.359625' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '330' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1517' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The 1514 offers luxury living with three bedrooms and two baths. This beautiful home features large secondary bedrooms with walk-in closets. Open living, dining, and kitchen provides abundant space without all the cost. The primary bedroom suite is fit for a king sized bed and features a large walk-in closet. Additional options included: Stainless steel appliances, additional LED recessed lighting, dual primary bathroom vanity, and a decorative tile backsplash.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929602 - The Lakes At Crockett Martin 02, BLOCK 2, Lot 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes at Crockett Martin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093838' WHERE `Matrix_Unique_ID` = '214807127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:59:38.430' ,`MLSNumber` = '10724821' ,`ListAgentFullName` = 'Randy French' ,`ListOfficeName` = 'Stylecraft Builders, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223119' ,`Longitude` = '-95.359625' ,`PhotoCount` = '27' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '284900.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '353' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming three bedroom, two bath home is known for its intelligent use of space and now features an even more open living area. The large kitchen granite-topped island opens up to your living room to provide a cozy flow throughout the home. Your dining area features the most charming window you\'ll ever see. Featuring large walk-in closets, luxury flooring, and volume ceilings - this beauty certainly delivers when it comes to affordable luxury. Additional options include: Stainless steel appliances, additional LED recessed lighting, integral binds in rear door, dual primary bathroom vanity, quartz countertops throughout, and decorative quartz backsplash.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Stylecraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S929602 - The Lakes At Crockett Martin 02, BLOCK 1, Lot 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes at Crockett Martin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093839' WHERE `Matrix_Unique_ID` = '214889466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:57:23.507' ,`MLSNumber` = '45480882' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Rose Filler' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.701865' ,`Longitude` = '-95.706406' ,`PhotoCount` = '49' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '383990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lakeway Bluff' ,`StreetNumber` = '7306' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The New Construction-Grant Plan by D.R. Horton has everything you could ever wan! Private Cul De Sac Lot! This open floor plan features an abundance of natural light inside, high ceilings, Upgraded Vinyl Wood Plank Flooring throughout, Tile in all wet areas & Plush Carpeting in all bedrooms! Your Casual Dining area & Family Room flows gracefully into the Gourmet Kitchen w/Upgraded Quartz Counters, Beautiful Tile Back-splash, Large Eat-in & Working Island w/Under-mount Stainless Sink & plenty of room for extra seating if needed, Stainless Steel Appliances, Tall Cabinets & more! The Owner\'s Suite features Luxurious Bath w/Dual Sink Vanity, Separate Shower, Deep Soaker Tub & Walk-in Closet! HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets & more! Outstanding Smart Home Automation System allowing you to control your home from anywhere, Lights, Thermostat & more! Covered Rear Patio! NO FLOODING! Amenities include: Pool, Splash Pad & more! 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 2/Block: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093839' WHERE `Matrix_Unique_ID` = '215000029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T08:57:39.090' ,`MLSNumber` = '62824123' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Nora Weli' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.701848' ,`Longitude` = '-95.706490' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '382990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lakeway Bluff' ,`StreetNumber` = '7302' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New D. R. Horton Home under Construction - Harris! Huge Private Cul De Sac Lot! Stunning Entry! Grand Entry with High Ceilings, Beautiful Vinyl Large Plank Wood Flooring throughout! Tile in all Bathrooms & Laundry Room! Two Full Baths & a Half Bath! The Family Room features Walls of Windows looking out to your Huge Private Backyard! Family & Casual Dining Area flows into the Gourmet Kitchen W/Quartz Counters, Beautiful Tall Shaker Cabinets, Subway Tile Backsplash, Stainless Appliances, Large Eat-in & Working Island W/Under-mount Stainless Sink & more! Private Owner\'s Suite features Luxurious bathroom W/Double Sink Vanity, Soaker Tub, Large Shower & Huge Walk-in Closet. Energy Efficient Home(HERS Rated),Tankless/On-Demand H2O Heater & features the \"Smart Home Automation System\" where you are able to control your home from anywhere, Camera Doorbell, Lighting, Electric Deadbolt, Thermostat & so much more! NO FLOODING! Amenities: Pool, Splash Pad & More! Just 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 1 /Block: 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093839' WHERE `Matrix_Unique_ID` = '215000436' --> 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','215256863','1675093839','215256863','2022-12-21T08:44:47.477','96638218','Li-ching Chen','Pillar Realty & Associates','','','29.556010','-95.619900','50','77479','9','908000.00','Active','Dawnington Pl','5206','','Sugar Land','5','1','4','5168','Single-Family','A beautiful Tylor Woodrow builder\'s home with a prime lot in the prestigious community- Avalon Meadows of Avalon. This stucco home features 4-5 Beds & 5.5 Baths with many upgrades. Double entry doors leads into soaring foyer with a splendor chandelier, oversized study & additional upgraded flex room next to entry. High ceilings through out, family room opens to kitchen, granite countertops, double ovens, open sun room area adjacent to breakfast with relaxed view to spacious backyard. Mable floor, wood, and tile through out 1st floor. Duel staircases, built-in bookcases, tech-nook upstairs and spacious game room. Elegant iron fenced backyard with custom-design fountain & gazebo leads to beautiful trails. Parks, lakes, clubhouse, swimming pools are in walking distance. Great location with easy access to all HWY 59, 90, and 6. Zoned to top-rated FBISD schools, Clements HS, & Fort Settlement MS. 2020 roof with fresh paint! Full gutters and more! Never flooded! Come see and don\'t miss it.','0.2651','29','','','','','Sellers Disclosure','1','Gaslog Fireplace','1','Sugar Land South','Central Gas','1','AVALON MEADOWS OF AVALON SEC 1, BLOCK 3, LOT 2','Subdivision Lot','11546','Appraisal District','','2065','0','','2','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','COMMONWEALTH ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FORT SETTLEMENT MIDDLE SCHOOL','Supra Keybox','Seller','2','Traditional','Avalon Meadows Of Avalon Sec 1','16995','2.1244','Water District','2002','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','215669396','1675093839','215669396','2022-12-21T08:10:41.297','84909733','Jason Gracey','Great Houston Properties','','','30.248753','-95.101603','16','77372','7','380000.00','Active','County Road 3706a','140','','Splendora','3','0','4','2208','Single-Family','Over 1 acre - unrestricted - recently built open concept country home with 4 beds/3 full baths on 1.117 acres. Upon executed contract, seller will install culvert and gate into the property. Aerobic septic system with city water service & electric utilities. Home has been elevated above flood zone - elevation certificate available but no survey. Partially fenced on a large lot nestled in an unrestricted community, your versatile homestead awaits. This open concept home has a large covered front porch and beautiful real wood floors, and is ready for your personal touches to create a warm and inviting place away from city congestion. The large private lot will be perfect for a big shop, small animal barn, garden, orchard, guest cottage, pond, gym, office, outdoor kitchen, pool - whatever you like or all of the above. Build a firepit to enjoy this winter while you sit outside and consider what you will do first.','1.117','52','','','','','Sellers Disclosure','1','','0','Cleveland Area','Other Heating','0','HARVEST ACRES, SEC 1, BLOCK 1, LOT 24 TR 1, 25, ACRES 1.117','Cleared,Wooded','48657','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Aluminum','100 - Cleveland','SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Seller','1','Contemporary/Modern,Other Style','Harvest Acres-1','3837','1.6917','Aerobic,Public Water','2019','Seller'); --> 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','215702314','1675093839','215702314','2022-12-21T08:26:12.030','90592430','Wendy Dozier','RE/MAX On The Water - Bolivar','','','29.472814','-94.593459','50','77650','5','599900.00','Active','Cove','963','','Crystal Beach','3','0','3','1872','Single-Family','MUST SEE BRAND NEW beautifully designed custom beach house is ready to make it your own! *This 1,872 SF home is SPACIOUS, with an open living/kitchen area and 3 Bedrooms, 3 Bathrooms with an added bonus of a 360 SF LOFT* High vaulted ceilings, kitchen island, custom detailed finishes with lights, flooring, fixtures, appliances and refrigerator included. This beachside beauty is seconds to the beach. Easy access to the beach right down the street via golf cart ride, walking or driving. Enjoy the breeze and views of both the intracoastal/bayside and the Gulf from the front deck. Downstairs will have a garage, RV Connection & outside shower. This would make an incredible vaction rental, 2nd home or full time residence. Anticipated construction completion date is 2/28/2023. Come see it to believe it!!!','','33','Tri Contracting','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Crystal Beach','Central Electric','0','ABST 65 PAGE 11 LOT 20 BLK 4 STINGAREE COVE ADDN','Water View','4500','Appraisal District','','','1','To Be Built/Under Construction','1','Electric Oven','0','','','Electric Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Builder','1','Traditional','Stingaree Cove Addn','','','Septic Tank','2022','Builder'); --> 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','215768908','1675093839','215768908','2022-12-21T08:17:10.677','56888482','Steven Cline','CB&A, Realtors-Katy','','','30.617082','-95.033315','11','77331','1','75000.00','Active','Martinez','512','Street','Coldspring','1','0','1','576','Single-Family','LOOKING FOR A WEEKEND GETAWAY? Recently updated and fully furnished, this cozy one bedroom, one bathroom home sits between Lake Livingston and Trinity River with private boat launch access for owners. The home sits on 5 combined lots, partially fenced and over ½ an acre! Large, mature oak trees provide plenty of shade for warm summer days. Three driveways large enough to park your RV or boat. Carport and detached garage/storage. Covered patio. New vinyl plank flooring and wood trim throughout. Tankless water heater. New kitchen and bathroom cabinetry. New appliances. Move-in ready! All appliances, drapery, décor and furniture are staying! All that’s missing is you!','0.6025','64','','','','','Sellers Disclosure','0','','','Lake Livingston Area','No Heating','0','CAMILLA TWIN HARBORS #3, LOT 510 - 514, ACRES .6025','Cleared','26245','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Cooktop','','Aluminum','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Other Style','Camilla Twin Harbors #3','307','1.5516','Public Water,Septic Tank','1980','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','215774449','1675093840','215774449','2022-12-21T07:16:03.457','55814420','Sopheak Hodges','Seeto Realty','','','29.973929','-95.245273','6','77396','4','225000.00','Active','Wooded Oaks','2031','Drive','Humble','2','0','3','1406','Single-Family','Very cute 3/2 home with split floor. Family room is open to the kitchen and has plenty of room for gathering. \r\nTenant occupied till 04/23','0.101','1','','','','','Mud','','','','Humble Area East','Central Gas','1','LT 4 BLK 3 WOODLAND PINES SEC 4 AMEND','Subdivision Lot','4400','Appraisal District','','430','0','','2','','0','','','','','Composition','29 - Humble','RIVER PINES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','ROSS STERLING MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Woodland Pines Sec 4','5004','2.833','Public Sewer,Public Water','2005','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','215774752','1675093840','215774752','2022-12-21T07:29:03.077','98610457','Joe Rothchild','Keller Williams Signature','','','29.465741','-95.246895','6','77511','10','312990.00','Active','Latigo','5297','Court','Alvin','2','0','3','1837','Single-Family','1 Story, 3 Bedroom, 2 Bath, Study, Dual Vanities at Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Kitchen, Family Room, Study, Dining Room, Utility Room and all Baths, Granite Kitchen Countertops with Island, Mosaic Tile Backsplash, 42” Upper Kitchen Cabinets, Upgraded Stainless Steel Appliances, Covered Patio, Stone Accented Elevation, Full Irrigation System, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE NOW!','','5','Devon Street Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','LOT 79 BLK 1 SEC 10','Subdivision Lot','5768','Appraisal District','','600','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','MARK TWAIN ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required','Builder','1','Traditional','Kendall Lakes','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully