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-24T10:13:08.883' ,`MLSNumber` = '48045127' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.527602' ,`Longitude` = '-96.823815' ,`PhotoCount` = '9' ,`PostalCode` = '75154' ,`RoomCount` = '0' ,`ListPrice` = '76400.00' ,`Status` = 'Active' ,`StreetName` = 'Moreview' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Street' ,`City` = 'Red Oak' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mobile home that needs a little bit of handy work! Located in the heart of Red Oak, TX with direct access to Highway 35E. Find plenty of dining and shopping options within a mile radius! As is!' ,`Acres` = '0.209' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 BLK 5 BECKLEY PIKE EST 0.209 AC' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9104' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'RED OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RED OAK H S' ,`SchoolMiddle` = 'RED OAK J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beckley Pike Estate' ,`TaxAmount` = '1965' ,`TaxRate` = '2.716' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702449' WHERE `Matrix_Unique_ID` = '178317540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:24:04.547' ,`MLSNumber` = '87181025' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038530' ,`Longitude` = '-93.856252' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '6' ,`ListPrice` = '248555.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1561' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DSLD Homes \"Cornel\" plan offers a 3 bedroom and 2 full bathroom open floor plan. Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702449' WHERE `Matrix_Unique_ID` = '204886926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:34:50.647' ,`MLSNumber` = '2314350' ,`ListAgentFullName` = 'Nina Wohlwend' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811533' ,`Longitude` = '-95.398120' ,`PhotoCount` = '40' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = '27th' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of two homes available. Your new home is in an unmatched location! Close to all the great resturants! This home was built to one\'s liking with its impeccable first floor living and custom features. The great room has an open floor plan with an abundance of natural light from the large picturesque windows that look out to a backyard, perfect for pets or relaxing on a nice day. Also included in the dining area is a dry bar with custom cabinets, wine fridge, and shelving. The gourmet kitchen features a large island that can be used as a breakfast bar as well as stainless steel appliances with custom vent hood. The second floor has a spacious primary suite with vaulted ceiling and elegant primary bath. Primary bath has bump out cabinets, free standing tub, large walk in shower, and skylights for natural light. Built in shelving in the primary closet with separate dressing area and vanity. Included on the second floor is a flex space that can be used as a study or media room.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Century Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 Connor Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Connor Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702449' WHERE `Matrix_Unique_ID` = '206276922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:43:27.493' ,`MLSNumber` = '93964285' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016345' ,`Longitude` = '-95.786197' ,`PhotoCount` = '7' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Cardrona Peak' ,`StreetNumber` = '31218' ,`StreetSuffix` = 'Place' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Achieve the lifestyle you’ve been dreaming of in the Surrey floor plan, which features 4 bedrooms, 3.5 bathrooms and the option to convert the upper-level game room into a fifth bedroom and an optional sixth bedroom in lieu of the open area to below. Whip up your favorite meal in the home’s spacious kitchen, which includes a large island and ample counter space for prep, and entertain friends in style in the home’s large dining and great room areas. Relish the privacy your main floor owner’s retreat will give you, and be sure to enjoy the impressive spa-like en-suite and expansive walk-in closet. A secondary bedroom is tucked away on the first floor, complete with a full bathroom and walk-in closet, offering a perfect space for guests. The\r\nSurrey floor plan is also ideal for the family who enjoy having\r\noptions, as this floor plan features a covered porch and\r\nenlarged shower in the owner’s bathroom.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Blk 4 Section 10 Dellrose' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5481' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702449' WHERE `Matrix_Unique_ID` = '206455518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:40:44.680' ,`MLSNumber` = '44897763' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016273' ,`Longitude` = '-95.784540' ,`PhotoCount` = '7' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '387000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadleaf Oak' ,`StreetNumber` = '17230' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully designed Empire home is among one of the\r\nnewest plans we offer out here in Dellrose. The Hutchinson is a\r\n2,058 sqft 2 story homes that accommodates 3 Bedrooms, 2 1/2\r\nBathrooms, a Gameroom and has a covered back patio. This\r\nhomesite backs up to no neighbors. The Owner\'s Retreat is on\r\nthe first floor and the other two bedroom are conveniently\r\nlocated right upstairs to work well for families wanting to provide\r\nindividual space for everyone. Spend time together in the\r\nspacious upstairs game room or the downstairs family room for\r\ngame night.' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 36 Blk 1 Section 10 Dellrose' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702449' WHERE `Matrix_Unique_ID` = '206619248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:59:06.800' ,`MLSNumber` = '26481077' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711008' ,`Longitude` = '-95.283958' ,`PhotoCount` = '20' ,`PostalCode` = '77012' ,`RoomCount` = '4' ,`ListPrice` = '269999.00' ,`Status` = 'Active' ,`StreetName` = 'Ilex' ,`StreetNumber` = '7619' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1769' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home is located in Southeast Houston and consists of 4 bedrooms and 2 bathrooms. Walk up the steps into a lovely patio area. As you enter the home, you are greeted by a spacious open living area that looks into the recently updated kitchen. Recessed ceiling lights are featured throughout the living areas. Both restrooms are recently updated with stunning marble designed tile. It\'s situated in a quiet neighborhood and close to H.E.B and many other shopping destinations. This property also has quick access to I-45 South and is only 15 minutes away from downtown. See it today! Give us a call right now!' ,`Acres` = '0.1331' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 5 BERKLEY PLACE SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '5800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SOUTHMAYD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Berkley Place Sec 02' ,`TaxAmount` = '3549' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702449' WHERE `Matrix_Unique_ID` = '206927188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:25:27.957' ,`MLSNumber` = '92325146' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999911' ,`Longitude` = '-93.814653' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '7' ,`ListPrice` = '270830.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1885' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DSLD Homes \"Ravenswood\" plan offers a 4 bedroom and 2 full bathroom open floor plan. Special features: Stainless appliances, 3 cm granite countertops & undermount sinks throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area & halls, ceramic tile in wet areas & carpet in bedrooms. LED lighting throughout, ceiling fans in the living area and master bedroom, Bronze plumbing fixtures, post tension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702450' WHERE `Matrix_Unique_ID` = '207009857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:44:14.493' ,`MLSNumber` = '49953484' ,`ListAgentFullName` = 'Stephanie Massey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Cynthia Kloesel' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '30.091915' ,`Longitude` = '-95.127918' ,`PhotoCount` = '50' ,`PostalCode` = '77336' ,`RoomCount` = '12' ,`ListPrice` = '715000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Commons Trail' ,`StreetNumber` = '306' ,`StreetSuffix` = 'Lane' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Feel like you are in the country without being too far from downtown Houston with this 4.166-acre equestrian facility with a one-story custom home by Vintage Builders including 4 stall Barn Master barn. This beautiful 3-bedroom home features open floor plan with home office, formal dining and a flex room with two entrances and could be a extra bedroom, game or media room. Driveway is large enough to hold cars, RV etc. Barn is set up with electric, concrete aisle, tack room, grooming area and storage space. All stalls have Nelson auto water systems and piped for fly system. Stall mats and hot wire are staying. Stalls have access to paddocks. This fully fenced property is cross fenced with a round pen, 1 pasture with run-in shed, one next to it in back right corner, and the riding arena with a pasture. Back of property, a riding trail that is one of miles of trails that welcomes horses. Amenities: 2 parks, water access, boat docks, fishing cannels, and swimming pool. \r\nNo flooding.' ,`Acres` = '4.166' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 11 &12 BLK 1 COMMONS OF LAKE HOUSTON SEC 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '181471' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Commons Lake Houston Sec 7' ,`TaxAmount` = '9270' ,`TaxRate` = '2.0463' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702450' WHERE `Matrix_Unique_ID` = '208480490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:24:43.827' ,`MLSNumber` = '88684486' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082287' ,`Longitude` = '-93.794743' ,`PhotoCount` = '6' ,`PostalCode` = '77630' ,`RoomCount` = '7' ,`ListPrice` = '275005.00' ,`Status` = 'Active' ,`StreetName` = 'Cottonwood' ,`StreetNumber` = '606' ,`StreetSuffix` = 'Drive' ,`City` = 'Orange' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and spacious \"Falkner\" model by DSLD Homes offers a 4 bedroom and 3 full bathroom open floor plan. Special features: Black appliances, 3 cm granite countertops throughout, birch cabinets throughout, Luxury Vinyl Plank flooring in living area, halls, and wet areas with carpet in bedrooms; ceiling fans in the living area and master bedroom, Bronze plumbing fixtures in the bathrooms, posttension slab, and more! Energy Efficient Features: Tankless gas water heater, low E tilt-in windows, radiant barrier roof decking, and more!' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Sec. 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '70' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702450' WHERE `Matrix_Unique_ID` = '208605324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:04:22.603' ,`MLSNumber` = '74634207' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642493' ,`Longitude` = '-95.398369' ,`PhotoCount` = '23' ,`PostalCode` = '77045' ,`RoomCount` = '12' ,`ListPrice` = '508896.00' ,`Status` = 'Active' ,`StreetName` = 'Eastgrove Park' ,`StreetNumber` = '11909' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2658' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kirby Landing is a privately gated community with easy access to HWY 288 and conveniently located only minutes from Downtown Houston and The Medical Center. Amenities include a centralized walking trail and a gated fun area for four legged friends. \r\nThe Athena II is our largest plan and offers a spacious open concept design. Grand entry that leads you into the extended foyer with a valet, home office, a bedroom and a full bath. Second floor is the living area with a gourmet kitchen that flows into the great room. Beautiful maple cabinets, quartz countertops, farmhouse sink and walk-in pantry in kitchen. 2nd floor covered patio with storage just off dining room. Third floor has the oversized owner\'s suite and walk-in closet. Dual vanity sinks, separate tub and shower in owner\'s bath. One secondary bedroom with en-suite bath also upstairs.\r\nOur interior designs have chosen the perfect colors for this plan. Lots of extra closets in this home. Offered by: K. Hovnanian Houston III, L.L.C.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/2/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2714' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Kirby Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.26' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702450' WHERE `Matrix_Unique_ID` = '208823143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:35:06.217' ,`MLSNumber` = '8164646' ,`ListAgentFullName` = 'Nina Wohlwend' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811533' ,`Longitude` = '-95.398120' ,`PhotoCount` = '40' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = '27th' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of two homes available. Your new home is in an unmatched location! Close to all the great resturants! This home was built to one\'s liking with its impeccable first floor living and custom features. The great room has an open floor plan with an abundance of natural light from the large picturesque windows that look out to a backyard, perfect for pets or relaxing on a nice day. Also included in the dining area is a dry bar with custom cabinets, wine fridge, and shelving. The gourmet kitchen features a large island that can be used as a breakfast bar as well as stainless steel appliances with custom vent hood. The second floor has a spacious primary suite with vaulted ceiling and elegant primary bath. Primary bath has bump out cabinets, free standing tub, large walk in shower, and skylights for natural light. Built in shelving in the primary closet with separate dressing area and vanity. Included on the second floor is a flex space that can be used as a study or media room.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Century Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 Connor Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Connor Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702450' WHERE `Matrix_Unique_ID` = '209042457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:50:22.797' ,`MLSNumber` = '37681810' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Marcia Soderberg' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.365570' ,`Longitude` = '-95.670728' ,`PhotoCount` = '20' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '326740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Little Rabbit Court' ,`StreetNumber` = '1622' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS NEW D. R. HORTON BUILT 4 BEDROOM!! Impressive Foyer Opens Onto Gourmet Island Kitchen with Large Corner Pantry & Abundant Cabinetry, Open Living Space, & Lovely Dining Area! Primary Suite - Lovely Garden Bath with Dual Sinks, Separate Tub & Shower, & Enormous Walk-In Closet! Spacious Second Bedrooms/Guest Suites! Covered Patio Enhances Backyard! Fantastic Community with Recreation Center, SplashPad, Playground, Pavilion, & Pickleball Courts! Wonderful MISD and zoned to Lake Creek High School! MUST SEE! Nestled in the rolling hills along FM 2854, you\'ll find FAIRWATER the NEWEST community in Montgomery, TX! Zoned to the prestigious Montgomery ISD students receive the best education in some of the HIGHEST rated schools in the state! Come see why we are the FASTEST growing community in Montgomery, TX' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Fairwater 07, BLOCK 2, Lot 43' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702450' WHERE `Matrix_Unique_ID` = '209185533' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:27:02.897' ,`MLSNumber` = '61667871' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759119' ,`Longitude` = '-95.845159' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Meeks Bay' ,`StreetNumber` = '27502' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful, spacious home situated on nearly half-acre lot, green belt, cul de sac in the heart of Firethorne! Built around grand central living space, soaring ceilings & outdoors make this home perfect for entertaining! Kitchen brings lots of storage, over-sized island, large great room, study, formal dining, butler’s pantry, guest suite downstairs, spacious master - private, large bathtub, upgraded glass shower, 2 huge closets. 3 BR & 2 baths upstairs, large game & separate media, 2 staircases. A children’s BR has a secret-access room in the closet with A/C, power, great for a child’s private reading space. Park-like backyard with an outdoor oasis pool, spa & resort-style huge rock, lighted grotto with water slide. This family home is the perfect, tranquil place to unwind, play outdoor sports, or even host large gatherings. Included is a resort-style, lighted horseshoe playing area, separate volleyball, and baseball hitting areas next to greenbelt. Zoned to Katy high school.' ,`Acres` = '0.5117' ,`Area` = '36' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE SEC 27, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '22290' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne' ,`TaxAmount` = '16719' ,`TaxRate` = '2.6945' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702450' WHERE `Matrix_Unique_ID` = '209243347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:17:22.297' ,`MLSNumber` = '92506597' ,`ListAgentFullName` = 'Colleen Sherlock' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750937' ,`Longitude` = '-95.402424' ,`PhotoCount` = '23' ,`PostalCode` = '77019' ,`RoomCount` = '14' ,`ListPrice` = '597000.00' ,`Status` = 'Active' ,`StreetName` = 'Haddon' ,`StreetNumber` = '1804' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Free-standing, Lovett home that is two blocks from River Oaks Shopping Center! This 3-bedroom, 3.1 bath home features a neutral palette and open-concept living and dining area. First floor study or bedroom plus full bath. 2nd story living showcases tall ceilings with island kitchen open to dining and living with fireplace. Primary suite located on 3rd story plus additional guest bedroom and bath. Enjoy incredible downtown views from the rooftop terrace on the 4th floor. Notable features include tall ceilings, plantation shutters, crown molding and extra room on 4th floor. Privacy fence surrounds front yard with green space plus 2-car garage and semi-private driveway in the back. NO HOA! * *=per seller' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'LOVETT' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 HADDON GARDENS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1542' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'HADDON GARDENS' ,`TaxAmount` = '11290' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702451' WHERE `Matrix_Unique_ID` = '209590193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:14:26.430' ,`MLSNumber` = '41867363' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398700' ,`Longitude` = '-95.688940' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '384995.00' ,`Status` = 'Active' ,`StreetName` = 'Little Dog' ,`StreetNumber` = '250' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2044' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one-story Juniper II home features 3 bedrooms, 2 baths and 3 car attached garage. Beautiful maple cabinets, under cabinet lighting, quartz countertops and farmhouse sink in kitchen. Convenient home office located across from great room. Cozy tile fireplace with Craftsman mantel in great room. Huge owner\'s walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Covered patio in backyard, perfect for entertaining.\r\nStudents are zoned to MISD. Take a tour and see why you\'ll love calling this community home. Town Creek Crossing is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '24/3/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702451' WHERE `Matrix_Unique_ID` = '209664186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:28:51.483' ,`MLSNumber` = '37029625' ,`ListAgentFullName` = 'Jack McLemore' ,`ListOfficeName` = 'Listing Results, LLC' ,`SellingAgentFullName` = 'Mandie McMillan' ,`SellingOfficeName` = 'RE/MAX Coastal' ,`Latitude` = '29.237635' ,`Longitude` = '-94.903852' ,`PhotoCount` = '49' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '399000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ostermeyer' ,`StreetNumber` = '11806' ,`StreetSuffix` = 'Road' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Galveston Island home on 3.5 acres, just minutes from the beach! Bring your horses and enjoy the country island life. 2 BD, 1.5 BA home with plenty of living and entertaining areas, including a screened-in back porch. Enjoy the Gulf breeze from the front porch, or the view of the barn and pasture from the back porch. Barn has covered room for your tractor, trailer, or vehicle, and two tackroom/workshop areas. Plenty of room on the back two acres to build your dream home, so many possibilities with this West End property!' ,`Acres` = '3.54' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PG 59 NW PT-LOT 207-8, 206-4, 206-5 TRIMBLE&LINDSEY' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Trimble & Lindsey Sec 2' ,`TaxAmount` = '2318' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702451' WHERE `Matrix_Unique_ID` = '210000895' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:19:30.400' ,`MLSNumber` = '85933847' ,`ListAgentFullName` = 'Libby Mitchell' ,`ListOfficeName` = 'REGENCY REAL ESTATE PROF' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999911' ,`Longitude` = '-93.814653' ,`PhotoCount` = '6' ,`PostalCode` = '77611' ,`RoomCount` = '7' ,`ListPrice` = '274665.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '212' ,`StreetSuffix` = 'Lane' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Roses IV A has an open floor plan with upgraded granite counters, luxury vinyl plank flooring added in all wet areas, framed bathroom mirrors and an additional gas line added. Special features; birch cabinets, LED lighting throughout, computer nook, formal dining room, breakfast room, 2 walk-in closets in master & more.' ,`Acres` = '' ,`Area` = '50' ,`BuilderName` = 'DSLD Homes, LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '53' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marsh Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702451' WHERE `Matrix_Unique_ID` = '210073011' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:02:39.460' ,`MLSNumber` = '29989199' ,`ListAgentFullName` = 'Fariborz Shojai' ,`ListOfficeName` = 'F S Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750238' ,`Longitude` = '-95.489049' ,`PhotoCount` = '20' ,`PostalCode` = '77057' ,`RoomCount` = '3' ,`ListPrice` = '659987.00' ,`Status` = 'Active' ,`StreetName` = 'Potomac' ,`StreetNumber` = '1628' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS PROPERTY FOR PRIMARY RESIDENCE OR INVESTMENT --- URBAN LIVING, FREE STANDING PATIO HOME, INTERIOR LOT. SHARED DRIVEWAY WITH ADJACENT PROPERTY ONLY: Location, Location, Location. Galleria area. Briargrove Elementary school. First Floor Living with OFFICE. All bedrooms located on the second floor. Custom Cabinetry & Hardwood Floors Throughout. Open Floor Plan. Gourmet Kitchen, Floor to Ceiling Cabinets W Large Island & SS KitchenAid Appliances. JELD-WEN: French Doors & Windows make this beauty well insulated. Spacious Master BR & Master Closet. Walk-in Closet in secondary bedrooms. 3rd Floor with Separate AC unit and breathtaking Loft/Game Room with full bath & Rooftop make this stunning home great for living & entertaining. Lock & leave. ACCOMPANY. SELLER/ AGENT' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'CDI' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2509' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Potomac Gardens' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702451' WHERE `Matrix_Unique_ID` = '210129299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:15:31.777' ,`MLSNumber` = '74099723' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398084' ,`Longitude` = '-95.689090' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '399995.00' ,`Status` = 'Active' ,`StreetName` = 'Little Dog' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2243' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one-story Chase home features 3 bedrooms, 2 baths and 2 car attached garage. Beautiful maple cabinets, under cabinet lighting, quartz countertops and farmhouse sink in kitchen. Cozy box mantel fireplace with tile and crown surrounds in great room. Convenient home office located off hall 2. Huge owner\'s walk-in closet, separate tub and shower in owner\'s luxury bath. Double sinks in all baths. Covered patio in backyard, perfect for entertaining.\r\nStudents are zoned to MISD. Take a tour and see why you\'ll love calling this community home. Town Creek Crossing is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '27/2/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702451' WHERE `Matrix_Unique_ID` = '210525139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:06:41.250' ,`MLSNumber` = '39063903' ,`ListAgentFullName` = 'Cristal Hill' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.278135' ,`Longitude` = '-94.231802' ,`PhotoCount` = '13' ,`PostalCode` = '77657' ,`RoomCount` = '5' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Paradise' ,`StreetNumber` = '5695' ,`StreetSuffix` = 'Drive' ,`City` = 'Lumberton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect home for first time home buyers or the perfect investment property! This lovely home offers a great open floorplan with nice size bedrooms and bathrooms. Spacious backyard, Brand new covered patio for entertaining and a huge brand-new bonus shade. Home never flooded. Schedule your showing TODAY!' ,`Acres` = '0.3283' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 33 PLEASANT BEND 1995 16X74 SILVER/RED ROOF PFS0356522 P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pleasant Bend' ,`TaxAmount` = '943' ,`TaxRate` = '1.8866' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702451' WHERE `Matrix_Unique_ID` = '210623394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:37:50.107' ,`MLSNumber` = '34423870' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943883' ,`Longitude` = '-95.198294' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '439990.00' ,`Status` = 'Active' ,`StreetName` = 'Countesswells' ,`StreetNumber` = '15654' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cherish unforgettable moments in this Lake Ridge Builders home in Balmoral. Situated on a spacious lot, this 4-sided brick home boasts 4 bed, 3.5 bathrooms, a premium elevation, no back neighbors, tile flooring, wrought iron spindles, faux wood blinds, cast stone fireplace, media room, game room, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. The spa-like primary suite features dual vanities, a 42” tub, and a separate shower. The tranquil Balmoral community includes white sand beaches, lakes, parks, an infinity pool, a recreation center, and walking trails. Located off Beltway 8 and Highway 59, commuters enjoy easy access to George Bush Intercontinental Airport and Downtown Houston. Zoned to the Humble ISD. Call now!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 61 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702452' WHERE `Matrix_Unique_ID` = '210784151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:37:22.887' ,`MLSNumber` = '74068893' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.458590' ,`Longitude` = '-95.472115' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '335990.00' ,`Status` = 'Active' ,`StreetName` = 'Upland Grove' ,`StreetNumber` = '426' ,`StreetSuffix` = 'Trail' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Feel at ease in this beautiful Pride Builders home in Huntington Place. Nestled on a spacious lot, this 3-sided brick home boasts a premium elevation, no back neighbors, tile flooring, faux wood blinds, a cast stone fireplace, and a covered patio. Master new recipes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. With dual vanities, a 36” tub, and a separate shower, the primary suite is a wonderful place to relax. Amenities of Huntington Place include a community pool, recreation center, and abundant green spaces. Residents benefit from direct access to Hwy 288 and Hwy 6, making the drive to the Texas Medical Center a quick one. Numerous outdoor adventures and nature parks surround the area, along with a variety of shops and restaurants. This is your dream home – call now to learn more!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Pride Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Place' ,`TaxAmount` = '' ,`TaxRate` = '3.25' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702452' WHERE `Matrix_Unique_ID` = '210989590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:19:22.617' ,`MLSNumber` = '2438362' ,`ListAgentFullName` = 'Luyun Chen' ,`ListOfficeName` = '31 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657825' ,`Longitude` = '-95.482056' ,`PhotoCount` = '22' ,`PostalCode` = '77035' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'W Bellfort' ,`StreetNumber` = '5482' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with spacious 3 bedroom/2 bath. close to park behind Parker El. Open kitchen with elegant granite counter top and stainless steel appliances. High quality gorgeous wood floors. Updated bathrooms! Huge back yard. Nice and cozy home to live! New AC 2018. Water heater 2020. New circular drive built in 2019. Never flooded! Foundation repaired in 2016 with life time warranty. Roof replaced 2016. No Mandatory HOA.' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 49' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11359' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 05 R/P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702452' WHERE `Matrix_Unique_ID` = '211070089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:35:25.640' ,`MLSNumber` = '5550239' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836221' ,`Longitude` = '-95.727779' ,`PhotoCount` = '39' ,`PostalCode` = '77449' ,`RoomCount` = '12' ,`ListPrice` = '457380.00' ,`Status` = 'Active' ,`StreetName` = 'Enrique' ,`StreetNumber` = '20511' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2261' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the city to this charming Postwood Homes in Westfield Ranch. Nestled on a corner lot, this 3-sided brick home boasts a stone front, tile flooring, crown molding, wrought iron spindles, faux wood blinds, cast stone fireplace, study with French doors, full gutters, a sprinkler system, and a covered patio. Whip up meals for guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. Spend evenings relaxing in the primary suite, which features dual vanities, a 42” tub, and a separate shower. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend nearby schools in the highly acclaimed Cypress-Fairbanks ISD. Call now for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Postwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702452' WHERE `Matrix_Unique_ID` = '211255716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:33:49.500' ,`MLSNumber` = '30036665' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.944408' ,`Longitude` = '-95.197950' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '14' ,`ListPrice` = '464990.00' ,`Status` = 'Active' ,`StreetName` = 'Countesswells' ,`StreetNumber` = '15674' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Feel at ease in this incredible Lake Ridge Builders home with scenic water views in Balmoral. Resting on a spacious lot, this 4-sided brick home boasts a premium elevation, no back neighbors, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, cast stone fireplace, and a covered patio. Try a new recipe in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Relax in the spa-like primary suite, featuring dual vanities, a 42” tub, and a separate shower. The tranquil Balmoral community includes white sand beaches, lakes, parks, an infinity pool, a recreation center, and walking trails. Located off Beltway 8 and Highway 59, commuters enjoy easy access to George Bush Intercontinental Airport and Downtown Houston. Zoned to the Humble ISD. Call now!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 56 Block 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.5534' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702452' WHERE `Matrix_Unique_ID` = '211260486' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:32:47.397' ,`MLSNumber` = '61285809' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495075' ,`Longitude` = '-95.810915' ,`PhotoCount` = '43' ,`PostalCode` = '77471' ,`RoomCount` = '11' ,`ListPrice` = '394855.00' ,`Status` = 'Active' ,`StreetName` = 'Owl Hollow' ,`StreetNumber` = '3303' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2126' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make new memories in this charming Lake Ridge Builders home in Briarwood Crossing. Resting on a spacious lot, this 4-sided brick home boasts tile flooring, a sprinkler system, and faux wood blinds. Prepare incredible feasts in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Complete with dual vanities, a 36” tub, and a separate shower. Community comforts include a 5-acre park, pool, recreation area with a splash pad, and walking trails. Commuters enjoy easy access to Hwy 59 and the Grand Parkway. Zoned to the highly acclaimed Lamar Consolidated ISD. Don’t wait – call now to learn more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Crossing' ,`TaxAmount` = '' ,`TaxRate` = '3.23' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702452' WHERE `Matrix_Unique_ID` = '211349078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:06:17.040' ,`MLSNumber` = '17312120' ,`ListAgentFullName` = 'Twila Bertrand' ,`ListOfficeName` = 'Century 21 Cota Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.334946' ,`Longitude` = '-94.766509' ,`PhotoCount` = '30' ,`PostalCode` = '75904' ,`RoomCount` = '9' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Berry Rd' ,`StreetNumber` = '1026' ,`StreetSuffix` = '' ,`City` = 'Lufkin' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country style home with 3 Bedrooms, 1 Bathroom, and a bonus a room that would make a great office or library. This property features custom kitchen cabinets with epoxy wood counters, gas stove top, walk in pantry, tons of storage, and a formal dining area. It has a large covered front porch and includes an attached 24 X 60 workshop and 2 additional storage buildings. This property is fenced and gated for privacy and has over 2.5 acres of land in Hudson ISD! *Primary MLS is Lufkin' ,`Acres` = '2.58' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'ABS 0700 BYNUM S., TRACT 6 - 7, ACRES 2.58' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '262 - Hudson' ,`SchoolElementary` = 'W.H. BONNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUDSON HIGH SCHOOL' ,`SchoolMiddle` = 'HUDSON MIDDLE SCHOOL (HUDSON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'none' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702452' WHERE `Matrix_Unique_ID` = '211438499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:14:56.740' ,`MLSNumber` = '13013151' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398260' ,`Longitude` = '-95.688962' ,`PhotoCount` = '7' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '414995.00' ,`Status` = 'Active' ,`StreetName` = 'Little Dog' ,`StreetNumber` = '234' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one-story Blakemore II home features 3 bedrooms, 2 baths and 2 car attached garage on a corner lot. Beautiful maple cabinets, under cabinet lighting, quartz countertops and farmhouse sink in kitchen. Convenient home office located off gallery. Huge owner\'s walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Covered patio in backyard, perfect for entertaining.\r\nStudents are zoned to MISD. Take a tour and see why you\'ll love calling this community home. Town Creek Crossing is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '28/2/1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8443' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702453' WHERE `Matrix_Unique_ID` = '211487016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T10:00:35.707' ,`MLSNumber` = '49901053' ,`ListAgentFullName` = 'Paula Mutina' ,`ListOfficeName` = 'Paula Mutina Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.186854' ,`Longitude` = '-95.423702' ,`PhotoCount` = '28' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Manor' ,`StreetNumber` = '805' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY ON MANOR! This beautiful 3/2/2 has so much charm and curb appeal, located on a tree shaded lot, bright windows throughout, split floor plan, fireplace, indoor utility room, double pane windows, spacious living area opening up to the large back yard with covered patio and shed. Super clean! Call for more details.' ,`Acres` = '0.1653' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION NORTH (ANGLETON) BLK 6 LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation North Angleton' ,`TaxAmount` = '4240' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702453' WHERE `Matrix_Unique_ID` = '211555825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:05:50.100' ,`MLSNumber` = '76534715' ,`ListAgentFullName` = 'Gary Reifel' ,`ListOfficeName` = 'Professional Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.042485' ,`Longitude` = '-95.660373' ,`PhotoCount` = '28' ,`PostalCode` = '77480' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 334' ,`StreetNumber` = '5401-5' ,`StreetSuffix` = '' ,`City` = 'Sweeny' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home home on the river. 100\' on bulkheaded river front. Home has full 1 bedroom 1 bath on first floor and 3 bedrooms 2 baths on 2nd floor. First floor all tile flooring with breakfast bar and french doors to front to the river.\r\n2nd floor is 3 bedrooms, 2 baths with wood/carpet flooring. Balcony porch for good sitting for scenery and gatherings.\r\nCome take a look for your home home on the river.' ,`Acres` = '0.327' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0057 JOHN CUMMINGS TRACT 4C3-4C2A-13-4-1G1 ACRES .327' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '14244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'John Cummings' ,`TaxAmount` = '4872' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702453' WHERE `Matrix_Unique_ID` = '211685033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:54:41.343' ,`MLSNumber` = '97673636' ,`ListAgentFullName` = 'Wendy Garcia' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.889015' ,`Longitude` = '-95.415700' ,`PhotoCount` = '42' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = 'Indian River' ,`StreetNumber` = '8919' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 4-2-2 that has been completely remodeled! Lots of natural light! New tile throughout ENTIRE home! A neutral color palette to accommodate many decor preferences. You\'ll love the backsplash and spacious workspace on the countertops in the kitchen. Window over the kitchen sink looks out into the backyard. Slow closing drawers and cabinets. New microwave, new dishwasher, recessed lighting, windows, new kitchen sinks/cabinets, hall tub/shower surround, and also all new shower in the primary bedroom. Nice size pantry, and a backyard for your barbecue-ing, gardening or just a place to enjoy after a long day at work! Super close to 45 and lots of shopping. Also, only minutes away from Downtown attractions, shopping, and points of interest! Schedule your appointment today.' ,`Acres` = '0.1667' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 959 BLK 47 HIDDEN VALLEY SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'GOODMAN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'STOVALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hidden Valley Sec 07' ,`TaxAmount` = '3181' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702453' WHERE `Matrix_Unique_ID` = '211728000' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:19:39.777' ,`MLSNumber` = '69844142' ,`ListAgentFullName` = 'Chase Robinson' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738622' ,`Longitude` = '-95.549465' ,`PhotoCount` = '31' ,`PostalCode` = '77042' ,`RoomCount` = '8' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Wickersham' ,`StreetNumber` = '10018' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on pristine tree-lined street in desirable Briargrove Park! This lovely 3/2 + Garage Apartment/ ADU 1/1 has an abundance of updates including: brand new HVAC compressor (July 2022) double paned windows, brand new flooring, paint, bathroom remodel and so much more. Kitchen boasts granite countertops, SS appliances and cozy breakfast room. Primary bath includes walk-in closet and bath with dual vanities and walk-in shower. Front yard with mature trees and covered front porch and amazing backyard space ideal for entertaining! Located in wonderful neighborhood that offers swimming pool, tennis courts, and playground.' ,`Acres` = '0.1835' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 3 BRIARGROVE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 01' ,`TaxAmount` = '11434' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702453' WHERE `Matrix_Unique_ID` = '211764767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T11:37:07.300' ,`MLSNumber` = '98991051' ,`ListAgentFullName` = 'Diane Schrakamp' ,`ListOfficeName` = 'Honeywood Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.360986' ,`Longitude` = '-95.601674' ,`PhotoCount` = '35' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Moonspinner' ,`StreetNumber` = '121' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this adorable & updated home in the gated golf course community of April Sound. This home features crown Moulding in entry/living/kitchen/dining, wood floors throughout except wet areas. Granite countertops in all bathrooms & kitchen. Undercabinet lighting & soft-close drawers & cabinets in kitchen. Quartz composite sink & upgraded glass backsplash in kitchen. Water softer & RO system. Huge walk-in closet in primary bathroom. Double sinks, Jetted tub & separate shower in master bathroom. Sellers had fiber ran to the house for the highest speed internet. Google Nest thermostat. HE Lights throughout house. Some are Hue color changing lights controlled by app or switch. Landscape lighting stays. The generator tap in the main electrical panel can run appliances w/ gas generator during a power outage. Roof 2015, HVAC 2015. 24/7 manned entry gate. NO BACK NEIGHBORS! There is a lot more to this house, it is a must see! Air BNB is allowed! NEVER FLOODED!' ,`Acres` = '0.0918' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 09, BLOCK 1, LOT 33' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '241' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'April Sound' ,`TaxAmount` = '4438' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702453' WHERE `Matrix_Unique_ID` = '211767285' --> Updated record success