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-08-18T12:41:28.800' ,`MLSNumber` = '44915261' ,`ListAgentFullName` = 'Ashley Casterlin' ,`ListOfficeName` = 'Davis Commercial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732487' ,`Longitude` = '-95.392720' ,`PhotoCount` = '22' ,`PostalCode` = '77006' ,`RoomCount` = '16' ,`ListPrice` = '2395000.00' ,`Status` = 'Active' ,`StreetName` = 'Yoakum' ,`StreetNumber` = '4510' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare large tract in Montrose/Museum Distict with potential to be used commercially or residentially! This beautiful 4,500 SF home sits on a large, 18,250 SF, unrestricted lot across from the historic Governor Ross Sterling Mansion. The property has endless possibilities for updating and continuing to serve as a charming, historic home or transitioning to an office.\r\n \r\nThis tract makes for an excellent redevelopment opportunity, ideal for town homes or a mid-rise! Two properties on either side of the subject property are also available for sale, which would increase the total land size to 1.25 acres, and further increase the opportunity for development!\r\n \r\nPRICED AT LOT VALUE ONLY. AS-IS CONDITION.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 2 ROSSMOYNE' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '18250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Rossmoyne' ,`TaxAmount` = '22794' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1914' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700206' WHERE `Matrix_Unique_ID` = '197266486' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T13:54:47.807' ,`MLSNumber` = '50860034' ,`ListAgentFullName` = 'Christy Vargas' ,`ListOfficeName` = 'ABC Capital Group , LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688630' ,`Longitude` = '-95.375710' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '2' ,`ListPrice` = '129999.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Pleasant' ,`StreetNumber` = '3417' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property located near 610, 288, Medical Center, Museums, Hermann Park, New HEB, Hobby Airport and Down Town. Great opportunity for investor with new construction throughout area.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 85 SOUTH UNION SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHIDBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Union' ,`TaxAmount` = '1779' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700206' WHERE `Matrix_Unique_ID` = '198611505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T13:45:18.377' ,`MLSNumber` = '54105547' ,`ListAgentFullName` = 'Jose Delao' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.281812' ,`Longitude` = '-95.167647' ,`PhotoCount` = '8' ,`PostalCode` = '77328' ,`RoomCount` = '3' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Tupelo' ,`StreetNumber` = '25469' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED!! NEW HOME BUILTED ON 2021, 10\'\' AND 12\'\' CEILINGS, 3 BEDROOMS, 2 BATHS, EXTRA DOUBLE WIDE DRIVEWAY, BIG SHADY TRESS TO FEEL THE FRESHNESS AND TRANQUILITY AND APPRECIATE THE WONDERS OF THE MOTHER NATURE. ONE DOOR TO THE LIVING ROOM AND ANOTHER ONE TO THE MAIN BEDROOM.' ,`Acres` = '0.186' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NORTH WOODS 01, LOT 240' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'North Woods 01' ,`TaxAmount` = '1839' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700206' WHERE `Matrix_Unique_ID` = '206518228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:27:33.973' ,`MLSNumber` = '3076632' ,`ListAgentFullName` = 'Marga Haas' ,`ListOfficeName` = 'Coldwell Banker RealtyThe Willis Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.647190' ,`Longitude` = '-95.538379' ,`PhotoCount` = '9' ,`PostalCode` = '77340' ,`RoomCount` = '9' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Greentree' ,`StreetNumber` = '2124' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION IN ELKINS LAKE TO BE COMPLETED MID AUGUST 2022 See the floor plan and detailed pictures of the workmanship and styles. 3/3.5/2 Home. Metal front doors greet you and a Flex room for a study/office, huge walk-in pantry and a mud room from the garage. Note the size of the kitchen and the number of cabinets with an island breakfast bar. All the bedrooms have walk in closets and the primary closet is large. Exterior Brick and Stone and the interior flooring is all luxury vinyl planks. Many upgraded items are standard, such as a tankless water heater, plumbing fixtures. See spec sheet for specifics. Larger than standard garage is 23\'10\"x22. Massive 16x16 back Porch. If you don\'t know about Elkins Lake, there is unlimited golfing, county club & restaurant/bar, swimming pools, tennis, hiking paths & a lake. Its worth a visit!!! Contact me for details. Pics are a similar depiction and measurements are approx. Check out Elkins lake website for all its amenities.' ,`Acres` = '0.2177' ,`Area` = '43' ,`BuilderName` = 'RAAINNOVATIO' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELKINS LAKE - SEC 3A, BLOCK 32, LOT 19' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9485' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '189' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elkins Lake - Sec 3a' ,`TaxAmount` = '255' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700206' WHERE `Matrix_Unique_ID` = '208980702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:04:02.543' ,`MLSNumber` = '56238456' ,`ListAgentFullName` = 'Delia Rodriguez' ,`ListOfficeName` = 'Redding & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.950493' ,`Longitude` = '-95.959349' ,`PhotoCount` = '43' ,`PostalCode` = '77414' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '5004' ,`StreetSuffix` = 'Lane' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the most Magnificent Unique Homes located in the city limits. Situated in Country Estates, there\'s not much this GORGEOUS, 5BDRM 3.5BATH CUSTOM home doesn\'t have to offer. If you are entertaining guests out back or upstairs in the huge GameRoom/Theater Room, there\'s plenty of room for everyone. Each Bedroom is oversized with built in custom features. The Main Living Area, opens to the pool & backyard, which has built in shelves following the fireplace wall, floor to ceiling. They create a perfect spot for any avid hunter to display mounts. A Victorian touch was added to the Formal Dining room, w/Glass Chandelier, Wall Sconces, French Glass Doors and Wainscot. Additional Study or Living Area opens to the Front Foyer, which features a beautiful hardwood staircase leading to the Interior Hallway Balcony, which overlooks the Main Living Area, Backyard and Entry. Take a walk around the home by clicking on the Matterport Link & see for yourself what makes this home so special.' ,`Acres` = '0.714' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY ESTATES SEC 1 LOT 9 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '31102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Country Estates Sec 1' ,`TaxAmount` = '10436' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700207' WHERE `Matrix_Unique_ID` = '209358395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:06:57.867' ,`MLSNumber` = '77423941' ,`ListAgentFullName` = 'Ramiro Nino' ,`ListOfficeName` = 'JB Goodwin, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573336' ,`Longitude` = '-95.317677' ,`PhotoCount` = '37' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Butler' ,`StreetNumber` = '6325' ,`StreetSuffix` = 'Road' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this ranch style home located in Pearland, TX. Property sits on a large, unfenced lot and is updated throughout the home. The kitchen comes with updated cabinets and granite countertops. Wood tile runs throughout the majority of the home, including bedrooms. Bathrooms are both updated with quartz countertops. Master bathroom comes with jack and jill vanity and oversized standing shower.' ,`Acres` = '0.6467' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HICKORY CREEK PLACE (PEARLAND), BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '28170' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Hickory Creek Place Pearland' ,`TaxAmount` = '5874' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700207' WHERE `Matrix_Unique_ID` = '209565170' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:48:10.580' ,`MLSNumber` = '64245236' ,`ListAgentFullName` = 'Tiffanie Purvis' ,`ListOfficeName` = 'Texas Real Estate & Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792527' ,`Longitude` = '-95.407243' ,`PhotoCount` = '28' ,`PostalCode` = '77008' ,`RoomCount` = '10' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = '12th' ,`StreetNumber` = '1004' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2892' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic Heights location across from school, pool, and one block walk to the hottest new pocket in the heights. Restaurant row. It\'s very walkable for a residential location. Close to Heights Hike & Bike Trail. Gorgeous floorplan w 3 front porches! 8 ft iron modern glass entry door opens to a spacious foyer w wainscotting on the 1st level. Flexible 1st floor bedroom/office w attached bath. Double garage is extended on one side for storage. 2nd floor main living w large living room w coffered ceiling & fireplace, dining room, porch, upscale island kitchen, half bath, & utility room. 3rd floor offers a huge primary bedroom w designer accent wall & tray ceiling, private porch & large custom closet. Custom vanities w double sinks, stand-alone soaking tub, & separate shower in primary bath. 2nd secondary bedroom w private bath. Smart home. Wired cable, internet, sound, & alarm. Finished 4th story for media, exercise or 4th BR. No HOA dues. SEE AN EXTENSIVE LIST OF FEATURES IN DOCUMENTS!' ,`Acres` = '0.0421' ,`Area` = '9' ,`BuilderName` = 'Cabe Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 ARIEL MANOR AT HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '1833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Other Style' ,`Subdivision` = 'Ariel Manor at Heights' ,`TaxAmount` = '2777' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700207' WHERE `Matrix_Unique_ID` = '209830000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:12:11.090' ,`MLSNumber` = '10828841' ,`ListAgentFullName` = 'Maria Maldonado' ,`ListOfficeName` = 'Epique Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.230639' ,`Longitude` = '-95.240588' ,`PhotoCount` = '14' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '252900.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon Pines' ,`StreetNumber` = '14670' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCITON READY TO MOVE IN! This cozy 3 bedroom, 2 bath home offers an open concept interior, with many smart features! Spacious foyer blends into the great family room, dinning, and kitchen. Kitchen features a walk in pantry. Great master bedroom extends to a sizable bathroom and walk-in-closet. Additional features include Carrier 16 SEER air conditioning system, indoor utility room, tankless water heater, covered patio, new appliances, updated lighting/fans, sprinkler system, garage opener and MORE! Community perks include walking trails, recreational Center, SplashPad, Pool, and an Elementary School on site! This lovely home is also sitting minutes away from Texas water park, shopping centers and hwy 59! Professional Pictures coming soon but schedule your appointment today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'D.R Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S573392 - Harrington Trails SEC 5A, BLOCK 4, Lot 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700207' WHERE `Matrix_Unique_ID` = '210051502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T13:45:17.970' ,`MLSNumber` = '30654243' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.243247' ,`Longitude` = '-95.416655' ,`PhotoCount` = '22' ,`PostalCode` = '77302' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Ehlers' ,`StreetNumber` = '10627' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, clean, spacious property has been called home to it\'s current family of 50 years. It has been updated with porcelain tile \"wood grain\" flooring throughout the home. Updated \"Flex\" piping. \r\nThe kitchen with granite counter tops, over looks the front yard and offers an \'open concept\' living space. Being unrestricted has it\'s bonuses, the property has an area that could be designated for your RV. Just over half an acre allowing you room to expand. All appliances stay with the home.\r\nAll dimensions must should be verified. Home is occupied, please allow a 2 hour window for showing.' ,`Acres` = '0.67' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0070 BRYAN STEPHEN, TRACT 267 PT KROHN RANCHETTES MAP A, AC' ,`LotDesciption` = 'Other' ,`LotSize` = '29185' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Krohn Ranchettes' ,`TaxAmount` = '1127' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700207' WHERE `Matrix_Unique_ID` = '210290917' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T13:33:25.273' ,`MLSNumber` = '89698479' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.210264' ,`Longitude` = '-96.288638' ,`PhotoCount` = '28' ,`PostalCode` = '77437' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Hefner' ,`StreetNumber` = '606' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 606 Hefner Street in El Campo, Texas! This beautiful 1 story home on a massive lot is located in a quiet and established neighborhood, perfect for a first-time home buyer. Inside you will find a meticulously maintained move in ready 1,481 SqFt featuring 3 bedrooms with a Hollywood bathroom! As you enter the home you are greeted by an inviting family room filled with natural light showcased by attractive updated flooring. The kitchen opens directly to the dining room allowing for convenient family meals and great entertaining. The three bedrooms are located at the rear of the home and offer privacy and relaxation as you unwind from the long day. The highlight of this home is the gigantic fully fenced backyard (14,449 SqFt) that features a workshop, covered patio, and grand oaks trees that provide endless amounts of shade! Schedule an appointment to view this home today!' ,`Acres` = '0.3317' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TOWN & COUNTRY EST. BLOCK 4 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Town & Country Estate' ,`TaxAmount` = '3932' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700207' WHERE `Matrix_Unique_ID` = '210492705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T13:46:11.070' ,`MLSNumber` = '28029364' ,`ListAgentFullName` = 'Katherine Maher' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.388523' ,`Longitude` = '-95.599335' ,`PhotoCount` = '43' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Burning Tree' ,`StreetNumber` = '11355' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1654' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable single-story split floor plan home in the sought-out Walden subdivision 3/2/2 w/country decor & in the low MUD. Relaxing backyard w/partially covered patio & greenbelt. Tile in all wet areas & carpet in all rooms, formal dining has beautiful wood-like flooring w/column accents. Countertops are granite for easy upkeep. Open kitchen & living area w/breakfast area & breakfast bar for entertaining. Tall ceilings in the living room with a gorgeous designer brick fireplace & custom carved wooden mantle. Recessed area on the side of the fireplace, perfect for TV or bookshelf. The primary bathroom is a nice size w/double sinks & a separate tub/shower. The home is neat & taken care of. Lots of entertainment and shopping nearby, Margaritaville just right up the road, and access to all Walden amenities including an Olympic-size swimming pool, boat ramps, dog parks, and walking trails. An adjacent lot may be purchased for an additional cost. Inquire about the lot with the listing agent.' ,`Acres` = '0.1144' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 05, BLOCK 39, LOT 98' ,`LotDesciption` = 'Cleared,In Golf Course Community' ,`LotSize` = '4983' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 05' ,`TaxAmount` = '4251' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700207' WHERE `Matrix_Unique_ID` = '210566183' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T13:13:00.930' ,`MLSNumber` = '80247009' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Diane Moss' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.250722' ,`Longitude` = '-95.521035' ,`PhotoCount` = '11' ,`PostalCode` = '77384' ,`RoomCount` = '8' ,`ListPrice` = '511390.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Yellow Hawthorn' ,`StreetNumber` = '14303' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SUPER IMPRESSIVE NEW D. R. HORTON BUILT MODERN SERIES HOME ON OVERSIZED CUL-DE-SAC LOT! 3 Car Garage! Gorgeous Brick + Stucco Exterior! Versatile Interior Design with Gameroom AND Home Office/Study/5th Bedroom! Island Kitchen with Corner Walk-In Pantry - Opens Onto Supersized Living & Dining Areas! First Floor Primary Suite Boasts Huge Walk-In Closet & Lovely Garden Bath! Second Bedroom/Guest Suite with Adjoining Full Bath Also Downstairs! Study/Home Office/5th Bedroom with Walk-In Storage Closet! Two Big Secondary Bedrooms AND Huge Gameroom/Media Room Up! Stainless Appliances (Including 5 Burner Gas Cooktop), Quartz Counters, 42\" Flat Cabinetry in Kitchen, Solid Surface Flooring, PLUS MORE! Built-In Home Automation System, Full Sprinkler System, Tankless Water Heater - TOO MUCH TO LIST! Great Community with Playground, Pool, & Community Center! Zoned to The Woodlands Schools! Estimated Completion - September 2022.' ,`Acres` = '0.3685' ,`Area` = '15' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516410 - FOSTERS RIDGE 10, BLOCK 1, LOT 16' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '16053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fosters Ridge' ,`TaxAmount` = '964' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700208' WHERE `Matrix_Unique_ID` = '210990740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:28:01.227' ,`MLSNumber` = '46101445' ,`ListAgentFullName` = 'James Townsend' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.240288' ,`Longitude` = '-95.822054' ,`PhotoCount` = '20' ,`PostalCode` = '77363' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Riley' ,`StreetNumber` = '24494' ,`StreetSuffix` = 'Road' ,`City` = 'Plantersville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One and a Half Story Custom Home on 2 Acres just North of the Houston Hill Country. 3-4 bedrooms with study and 3.5 baths. Enormous game room upstairs. This is a must see seconds from FM 1774. Light restrictions and gorgeous views from back patio. Stone Elevation with Hardie Board & Batten to give that curve appeal that every owner dreams of. Pantry with storage room that every family needs. Come see!' ,`Acres` = '1.9533' ,`Area` = '26' ,`BuilderName` = 'CANDID CONSTRUCTION' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S609800 PINE LAKE ESTATES (FNA MILL CREEK EST 8) LOT 2-2 ACR' ,`LotDesciption` = 'Cleared' ,`LotSize` = '85086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Pine Lake Estates Fna Mill Cr' ,`TaxAmount` = '2471' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700208' WHERE `Matrix_Unique_ID` = '211250703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:50:23.350' ,`MLSNumber` = '97136553' ,`ListAgentFullName` = 'Gregory Blume' ,`ListOfficeName` = 'Savannah Plantation Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.355240' ,`Longitude` = '-95.328164' ,`PhotoCount` = '14' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '839990.00' ,`Status` = 'Active' ,`StreetName` = 'Nottaway' ,`StreetNumber` = '7515' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM ACREAGE HOME Featuring 6 car garage/workshop with a 3-car portico, 4 bedrooms, 3.5 baths, home office and sunroom/flex room off kitchen. Enjoy the ability to spread out on your 2 back covered patios and enjoy country living while being close to the big city. This open floor plan is the ultimate space to entertain your family and friends and gives you plenty of storage and walk in closets throughout the home. Every detail of this home has been designed to make sure the finishes stand the test of time and showcase your furnishings. High ceilings, enormous master closet, Drop Zone, and solid surface flooring throughout the whole house minus secondary bedrooms are just a few of this home\'s luxury features. Home will be ready to move in Sept 30th in time for all your Holiday celebrations. This property has room for a future added barn if desired. Few homes give you the space to work, live and make memories, do not miss this one-of-a-kind property.' ,`Acres` = '1.79' ,`Area` = '5' ,`BuilderName` = 'Stone Meadow Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH PLANTATION SEC 3 (A0100 F MOORE) BLK 2 LOT 20 ACRES' ,`LotDesciption` = 'Water View' ,`LotSize` = '77972' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Savannah Plantation Sec 2-3-4' ,`TaxAmount` = '634' ,`TaxRate` = '2.1074' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700208' WHERE `Matrix_Unique_ID` = '211562622' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T12:22:20.627' ,`MLSNumber` = '64597217' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847240' ,`Longitude` = '-95.416786' ,`PhotoCount` = '41' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'W Tidwell' ,`StreetNumber` = '778' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO-BE-BUILT! Move-in ready by SUMMER 2023! Gorgeous new construction by Disama Group. Nestled in a quite gated community within the charming historical Highland Heights, this stunning two-story home offers an open concept living area & kitchen on the first floor & three bedrooms on the second floor, private driveway and fenced backyard/patio. Upgraded modern finishes throughout including smart home system features, quartz counter tops, stainless-steel appliances, upgraded cabinets with soft close drawers. Enjoy this 19-home gated community located minutes away from Downtown Houston. Easy access to I45 and 610.\r\nPhotos from another community by the same builder - finishes and layout will vary!\r\nGPS address: 781 Davidson St. Houston TX 77091' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS VILLAS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700208' WHERE `Matrix_Unique_ID` = '211568041' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T13:30:06.177' ,`MLSNumber` = '54181082' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795804' ,`Longitude` = '-95.848912' ,`PhotoCount` = '30' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '507990.00' ,`Status` = 'Active' ,`StreetName` = 'Manderley' ,`StreetNumber` = '1719' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THE BROCTON IS A BOASTING BEAUTY! This Split Plan Single Story offers it all with 4 Bedrooms, 3 Bathrooms, a Study w/ Storage, a Central Game Room, Oversized Covered Patio + 2 Car Garage. Huge Quartz Island Kitchen w/ Adjacent Casual Dining that\'s Open to the Vaulted Ceiling Family Room which carries out to the Outdoor Living Space! Exquisite Owner\'s Retreat offering a Bay-wall of Windows overlooking the Backyard! Secondary Bedrooms offer convenience to Game Room. Private Study located off Foyer. Stainless Steel Appliances, 8\' Doors, 2\" Blinds, Upgraded Wood Tile Flooring, Security System, Sprinkler System, Fully Sodded Yard + Landscaping Pkg all included' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 11 Block: 2 Section: 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.41' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700208' WHERE `Matrix_Unique_ID` = '211572316' --> Updated record success