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-09-03T01:22:00.380' ,`MLSNumber` = '1008736' ,`ListAgentFullName` = 'Carla Guimaraes' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753247' ,`Longitude` = '-95.634345' ,`PhotoCount` = '45' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashbury Park' ,`StreetNumber` = '1707' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3087' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Back on the market**. Wonderful opportunity at Lakes of Parkway! Fantastic backyard with a great size pool and space for children to play. Well maintained home with new roof (2021), hardwood floors ands ceramic tiles throughout. Located minutes from the Energy Corridor, the Village School, the Awty International and British schools bus pic up. Lakes of Parkway is a wonderful gated community with Tennis courts, Volleyball courts, jogging trails, swimming pools and 24 hour concierge.' ,`Acres` = '0.2102' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 LAKES OF PARKWAY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9158' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Pkwy Sec 03' ,`TaxAmount` = '14981' ,`TaxRate` = '2.4594' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706139' WHERE `Matrix_Unique_ID` = '194877314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '85439554' ,`ListAgentFullName` = 'Athena O\'Gara' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730207' ,`Longitude` = '-95.618218' ,`PhotoCount` = '31' ,`PostalCode` = '77082' ,`RoomCount` = '8' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney Wood' ,`StreetNumber` = '2803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ultra modern open floor plan 2 story with a tile roof, corner lot home near Energy Corridor. Fully remodeled in 2022. Circular drive at front of home. Large master down w/easy access to pool/spa. 2 bedrooms up w/double bath & shower. \"Harry Potter\" room (not part of sq ft), could be 4th bedroom. Spacious formal living w/floor to ceiling windows at entry. Extra large den onto pool/spa. Premium items in this home include oversized ceramic tiles, \"Railway staircase\", upgraded appliances, lighting, custom cabinets, granite counters, kitchen island w/cooktop, premium BOSS speakers indoors & outdoors, & more! Insulated multi car garage w/separate AC. Yard w/side garden, mature trees, & Sprinkler system with 8 zones. *Optional (not included) a premium brand Control4 Smart Home Automation that does it all with Mesh ready WIFI & 4 satellites.*Aquariums are also optional.* Additional space in attic could be 4th bedroom. Recent AC\'s and duct work within the last 4 years.' ,`Acres` = '0.1862' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 11 PARKHOLLOW PLACE SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '8110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Parkhollow Place Sec 04' ,`TaxAmount` = '6690' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '205584809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '43793128' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473161' ,`Longitude` = '-95.355675' ,`PhotoCount` = '27' ,`PostalCode` = '77578' ,`RoomCount` = '5' ,`ListPrice` = '354990.00' ,`Status` = 'Active' ,`StreetName` = 'Terra' ,`StreetNumber` = '7046' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Mahogany Floor Plan at Terra Estates! This NEW Construction Home is a 1-Story, 3 Beds, 2 Baths with Covered Patio! The Kitchen features Gloss White Kitchen Backsplash, 42\" Linen Cabinets, Gaphite Granite Countertops, Stainless Steel Undermount Kitchen Sink & Casper Tile Flooring. The Primary Suite offers Bay Window, Double Sinks, Separate Tub & Shower, Convenience Door to Utility Room & Oversized Walk-in Closet. The Home is Complete with Full Sod, Sprinkler System & Garage Door Opener! Will be Ready for a July Move-in!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.79' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '206975498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '12252460' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473161' ,`Longitude` = '-95.355675' ,`PhotoCount` = '31' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '384990.00' ,`Status` = 'Active' ,`StreetName` = 'Terra' ,`StreetNumber` = '7045' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2217' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Award Winning Oleander Floor Plan at Terra Estates! This NEW Construction Home is a 1-Story, 4 Beds, 3 Baths with Flex Room & Covered Patio! The Kitchen features Santorini Backsplash, 42\" Snowbound Cabinets, Caliza Omegastone Countertops, Stainless Steel Undermount Kitchen Sink & Iron Wood Flooring. The Primary Suite offers Double Sinks, Separate Tub & Shower & Oversized Walk-in Closet. The Home is Complete with Full Sod, Sprinkler System & Garage Door Opener! Will be Ready for July Move-in!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 32 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Other' ,`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` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '206977904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '54011872' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473161' ,`Longitude` = '-95.355675' ,`PhotoCount` = '30' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '377990.00' ,`Status` = 'Active' ,`StreetName` = 'Terra' ,`StreetNumber` = '7049' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2105' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Award Winning Laurel Floor Plan at Terra Estates! This NEW Construction Home is a 1-Story, 3 Beds, Study, Formal Dining Room, 2 Baths with Study & Covered Patio! The Kitchen features 42\" Snowbound Cabinets, Caliza Omegastone Countertops, Stainless Steel Undermount Kitchen Sink & Iron Wood Flooring. The Primary Suite offers Double Sinks, Separate Tub & Shower & Oversized Walk-in Closet. The Home is Complete with Full Sod, Sprinkler System & Garage Door Opener! Will be Ready for an August Move-in!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 33 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Other' ,`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` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Estates' ,`TaxAmount` = '' ,`TaxRate` = '3.68' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '206982505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '81789679' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877067' ,`Longitude` = '-94.886047' ,`PhotoCount` = '25' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '549990.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Winds' ,`StreetNumber` = '13519' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to St. Augustine Meadows in Mont Belvieu!! The stunning Princeton Plan has it ALL! It is a 2,996 sqft 2-story home offering 4 bedrooms, 3 baths & OVERSIZED 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! The A-frame covered back patio is breathtaking!Eagle Pointe Golf Club and Recreation Complex is located just 2 miles from the community, as well as, the Mont Belvieu City Park. Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'St. Augustine Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.23' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '207607646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '11015956' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877067' ,`Longitude` = '-94.886047' ,`PhotoCount` = '30' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '549990.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Winds' ,`StreetNumber` = '13523' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to St. Augustine Meadows in Mont Belvieu!! The stunning Villanova Plan has it ALL! It is a 2,900 sqft 1-story home offering 4 bedrooms, 3 baths, with GAMEROOM, and 3-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings, and overlooks the the family room. The owner\'s bath has an oversized tub, walk-in shower, and double sinks. Come just to see the MASSIVE owner\'s closet! The A-frame covered back patio is breathtaking! Eagle Pointe Golf Club and Recreation Complex is located just 2 miles from the community, as well as, the Mont Belvieu City Park. Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'St. Augustine Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.23' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '207608875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '44529051' ,`ListAgentFullName` = 'Angie Currie' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.403611' ,`Longitude` = '-95.584787' ,`PhotoCount` = '42' ,`PostalCode` = '75835' ,`RoomCount` = '4' ,`ListPrice` = '479999.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood Trail' ,`StreetNumber` = '322' ,`StreetSuffix` = '' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous, newly remodeled home is situated on 2.497-acres in the desirable Golden Acres Subdivision. This home has plenty of room for family and friends with four bedrooms and two and one-half baths. The interior of the home has been freshly painted, has attractive vinyl plank flooring, board and batten ceilings, and unique light fixtures throughout. The island kitchen is beautiful with butcher-block countertops, open shelving, shaker-style cabinets, farmhouse sink, and stainless appliances that will convey with the sale. The primary bedroom has a private bath with waterfall shower. Three guest bedrooms share a full bath, and the half bath serves visiting guests well. This home also has a mini-split air conditioner and tank-less on demand hot water heater. Outdoors, expect to be impressed with the in-ground salt-water pool, hot tub, treehouse for the kids, BBQ pit to cook large meals, three out buildings including a 2-car garage, greenhouse, and storage shed. Call today!' ,`Acres` = '2.497' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GOLDEN ACRES LOT 10 & 11 BLK 14' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '54537' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '61 - Latexo' ,`SchoolElementary` = 'LATEXO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LATEXO HIGH SCHOOL' ,`SchoolMiddle` = 'LATEXO HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Golden Acres Sub Sec D' ,`TaxAmount` = '3887' ,`TaxRate` = '1.8562' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '208411015' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '83798041' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876956' ,`Longitude` = '-94.886647' ,`PhotoCount` = '30' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '524990.00' ,`Status` = 'Active' ,`StreetName` = 'Sacred Oaks' ,`StreetNumber` = '13526' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come Home to St. Augustine Meadows in Mont Belvieu!! The stunning Yale floor plan is a 2,756 sqft. 1-story featuring 4 bedrooms, 3 bathrooms, and 2 car garage. This home has a gorgeous foyer with soaring ceilings, a large kitchen with oversized chef\'s island, plenty cabinet space, and an open concept kitchen/family room. The Owner\'s bath has an oversized tub, walk-in shower, double sinks and a massive walk-in closet. Enjoy the outdoors featuring a large covered patio, full sprinkler system, and landscape package. Eagle Pointe Golf Club and Recreation Complex is located 2 miles from the community, as well as, Mont Belvieu City Park. Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10403' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'St. Augustine Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.23' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706140' WHERE `Matrix_Unique_ID` = '208657907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '35588957' ,`ListAgentFullName` = 'Andrea Curran' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.844628' ,`Longitude` = '-95.680390' ,`PhotoCount` = '28' ,`PostalCode` = '77084' ,`RoomCount` = '9' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Farnsfield' ,`StreetNumber` = '18223' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 18223 Farnsfield Drive, a stately home in the Deerfield Village community. Elegant family room with dentil crown molding, hand-scraped wide plank hickory wood flooring, floor to ceiling windows flanking the cozy gas fireplace and views of the back yard. Open kitchen with stainless steel appliances, Bosch dishwasher, tons of cabinet space, granite countertops and custom travertine backsplash. Private first floor primary retreat with two vanities, soaking tub, walk-in closet and a skylight for additional natural light. Upstairs you will find three secondary bedrooms, one which has an en-suite bathroom, and a spacious game room. New carpet installed upstairs in 2022. Large backyard with plenty of space for a pool. Community boasts swimming pool, walking trails, playground, park and sports facilities. Easy access to Hwy 6, 99 and I10.' ,`Acres` = '0.2241' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 53 DEERFIELD VILLAGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '915' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village' ,`TaxAmount` = '6251' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706141' WHERE `Matrix_Unique_ID` = '208696958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '26890347' ,`ListAgentFullName` = 'Caroline Spagnola' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204457' ,`Longitude` = '-94.936695' ,`PhotoCount` = '38' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Pirates' ,`StreetNumber` = '4119' ,`StreetSuffix` = 'Alley' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2348' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4119 Pirates Alley!! This 5 bedroom well maintained home is just one block away from the Gulf of Mexico in the heart of highly sought after Pirates Beach! Enjoy sunrises with partial gulf views on the first and second wrap around deck! As you walk in you are greeted by an open concept living room, dining area, and updated kitchen ideal for entertaining featuring granite countertops and stainless steel appliances. There is two well proportioned bedrooms downstairs as well as two upstairs. Bonus bedroom is located on ground level complete with queen/twin bunk beds as well as a full bathroom; which is not included in square footage. Ground level features an outdoor shower after a day at the beach and an ample amount of space for grilling and lounging. Whether you\'re searching for a new investment property to add to your portfolio or a beach house for personal leisure; this home checks off all of the boxes! Conveys fully furnished and turn key ready!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 48 BLK 11 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`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` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach 2' ,`TaxAmount` = '13284' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706141' WHERE `Matrix_Unique_ID` = '208971276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '81647010' ,`ListAgentFullName` = 'Tyler Cooper' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.935330' ,`Longitude` = '-95.744443' ,`PhotoCount` = '41' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Lower Pecos' ,`StreetNumber` = '16159' ,`StreetSuffix` = 'Street' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner homesite. Extended entry with 11-foot coffered ceiling. Library with French doors. Kitchen features island and walk-in pantry. Open family room has ceramic tile floor and a wall of windows. Master suite features spacious bedroom and master bath that includes a garden tub, separate glass-enclosed shower and a large walk-in closet. Secondary bedrooms feature walk-in closets. Covered backyard patio. Mud room just off the two-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 1 BRIDGELAND PARKLAND VILLAGE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6811' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '10800' ,`TaxRate` = '3.4929' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706141' WHERE `Matrix_Unique_ID` = '209012267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '53635839' ,`ListAgentFullName` = 'Brian Spack' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788648' ,`Longitude` = '-95.458123' ,`PhotoCount` = '39' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Post Oak Green' ,`StreetNumber` = '6024' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hello, Gorgeous! Experience this exceptionally designed home with rare first floor living and elevator capability, which features too many updates + upgrades to list. Formal Entry leads to open concept Living with custom built-ins, mock fireplace, updated Kitchen + Astroturf Garden. Master Suite has a Sitting Room, updated Bath, and gigantic Closet. Guest Bedrooms have updated, en-suite Baths and great closet space; all of this plus a Media Room/Fourth Bedroom! Post Oak Green features: ample guest parking, a walking trail all with European ambiance. Come for the great SBISD schools, stay for the affordable luxuries! North Post Oak Estates has the Ravenna vibe with a more palatable value proposition! With easy trips to NOPO, the Heights, Uptown Park, walking distance to Awty, a bicycle ride to Memorial Park, combined with quick jaunts to Downtown, Greenway + The Energy Corridor: This home and its location are sterling!' ,`Acres` = '0.0349' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 NORTH POST OAK ESTATES AMEND' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1521' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'North Post Oak Estates' ,`TaxAmount` = '11126' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706141' WHERE `Matrix_Unique_ID` = '209017919' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '2644315' ,`ListAgentFullName` = 'Glory Crafts' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569473' ,`Longitude` = '-95.639333' ,`PhotoCount` = '39' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '1090000.00' ,`Status` = 'Active' ,`StreetName` = 'Dahlgren' ,`StreetNumber` = '3027' ,`StreetSuffix` = 'Trail' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love coming home to this Beautiful home in sought after Avalon at Telfair located on a 14,220 lot with NO BACK NEIGHBORS. The open floor plan is Graced by high ceilings and Excellent Design which makes the home feel very spacious. The two-story entry features a curved wrought iron spindle staircase that flows naturally into the two story den and kitchen so you can enjoy additional entertaining space for guests and family. The gourmet island kitchen will impress daily featuring a huge granite island, SS appliances, and gas cooktop. Imagine your family creating memories in this huge backyard. * 4 CAR GARAGE *The location is Perfect with easy access to 59. Close to parks, shopping, and restaurants. Zoned to exemplary Clements high school.' ,`Acres` = '0.3264' ,`Area` = '29' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 25B, BLOCK 1, LOT 1' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '14220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair Sec 25b' ,`TaxAmount` = '20801' ,`TaxRate` = '2.9544' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706141' WHERE `Matrix_Unique_ID` = '209249627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '6323229' ,`ListAgentFullName` = 'Nidal Bouchedid' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714631' ,`Longitude` = '-95.362272' ,`PhotoCount` = '26' ,`PostalCode` = '77004' ,`RoomCount` = '9' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'southmore east' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This must see Tudor-Style home is a piece of History. Completely renovated in 2018 and updates ongoing through Feb 2022. Features include gated driveway, two house entrances, newer roof, newer covered gutters, spacious kitchen with new counter tops and an island, new soft closing cabinets, and many more. All bedrooms are upstairs and the primary with its own balcony, jetted spa and walk in closet and shower. The fourth bedroom can be used as a Media Room. Backyard with enough parking for 12+ vehicles, all enclosed and secured.\r\nOne mile from HWY 288, minutes from Downtown, Mid-Town, UH, TSU and MED Center.\r\nThis is a must see!' ,`Acres` = '0.2112' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 14 & 15 BLK 6 SOUTHWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwood' ,`TaxAmount` = '9943' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706141' WHERE `Matrix_Unique_ID` = '209287725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '50257812' ,`ListAgentFullName` = 'Lindsey Sturrock' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138651' ,`Longitude` = '-94.407539' ,`PhotoCount` = '8' ,`PostalCode` = '77659' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Barkley' ,`StreetNumber` = '355' ,`StreetSuffix` = 'Street' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 3 bed 2 bath home located in HJISD\r\nThis home is five years old, and barely lived in, beautiful floors throughout the home with an eat in kitchen that also features an island. Your primary bedroom is located in the back of the home with an ensuite bath. Your secondary bedrooms are located in the front of the home with a full bath adjacent to the bedrooms. 355 W Barkley is located on a quiet street in Sour Lake and is in walking distance to Lions Club Park and local library.' ,`Acres` = '0.1148' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8 BLK 5 ELECTRIC ADDN P# HJ11-5-2-A I# 2017-76902 08/22/' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sour Lake' ,`TaxAmount` = '2346' ,`TaxRate` = '2.2858' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706141' WHERE `Matrix_Unique_ID` = '209386573' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T00:20:30.053' ,`MLSNumber` = '96752474' ,`ListAgentFullName` = 'Dakar Gibbs' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849981' ,`Longitude` = '-95.418344' ,`PhotoCount` = '20' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '532944.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '807' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paul Quinn Place features 4 individually gated single family contemporary homes with remote gate access and guest parking. 807 Paul Quinn features the 2,264SF Oleander floor plan with 3 BR, 3.5 BTH, game room and massive 3rd floor patio/outdoor kitchen. Front elevation features 21” of beautiful stone and 4x8 hardie! Porcelain, quartz and glass in bathrooms! Soft close cabinets! 10’ ceilings on 1st and 2nd floors! 9’ ceiling on 3rd floor! Large bedrooms/closets! Tall ceilings! Custom doors! Plenty of natural light! Custom glass balcony rails! Smart wired including garage! Lots of storage space! Great finishes! Plenty of amenities within 3 miles or less (Memorial Hermann Greater Heights, Starbucks, BofA, Chase, BBVA, Home Depot, Lowe’s, HEB, Kroger, Berryhill, Five Guys, Walking Stick, Oak Forest Public Library, I-45, and 610) No HOA dues! Centrally located 8 miles from downtown! Ask about appliance package if you close by September 2nd! Custom Urban Living! Schedule showing today!' ,`Acres` = '0' ,`Area` = '9' ,`BuilderName` = '44 Builders LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 PAUL QUINN PLACE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '1991' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS ANNEX' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706142' WHERE `Matrix_Unique_ID` = '209533973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '34257066' ,`ListAgentFullName` = 'Claudia Salinas' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750281' ,`Longitude` = '-95.874236' ,`PhotoCount` = '33' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '614000.00' ,`Status` = 'Active' ,`StreetName` = 'AUBURN GLADE' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely one and a half story home located on a quiet cul-de-sac in the highly desired community of Firethorne. It has 4 bedrooms, along with 3 1/2 baths, an office room, media room, and formal dinning room. Along, with a beautiful open concept kitchen. The house has both wooden and tile floors. Ready to move in, with lots of upgrades and an adorable extended covered backyard, and includes a 3 car attached garage. Utility room has added sink. The community offers multiple pools, tennis courts, walking trails and wonderful lakes to enjoy and relax.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 10, BLOCK 4, LOT 9' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'FIRETHORNE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706142' WHERE `Matrix_Unique_ID` = '209599411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '28639646' ,`ListAgentFullName` = 'Servando Perez' ,`ListOfficeName` = 'Sapphire Homes Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784913' ,`Longitude` = '-95.040813' ,`PhotoCount` = '46' ,`PostalCode` = '77520' ,`RoomCount` = '8' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon' ,`StreetNumber` = '122' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautiful gated community of LAKEWOOD ESTATES 122 PERSIMMON DRIVE is ready for its new homeowners. This charming 2016 build features 4 bedrooms, 2.5 baths, 3 car garage. Impressive floor plan, multiple windows through out for natural light, high ceiling foyer, spacious dining area, beautiful kitchen with breakfast area, covered back porch with fans, plenty of room in the back yard, extra storage room in back yard, Energy Efficiency includes, Carrier 14 SEER HVAC System, Radiant Barrier, Double Pane LOW-E Windows for added Comfort and Savings, Programable Thermostat, INSULATION- BLOWN R-30 in flat areas, R-22 Batts in slopes, R-13 Batts in walls, Electric and gas dryer connections, Pex-Manabloc Water system, just a few attractive highpoints of this incredible home. Excellent location with convenient access to major freeways. MUST SEE!' ,`Acres` = '0.1653' ,`Area` = '2' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 LAKEWOOD ESTATES SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Estates Sec 3' ,`TaxAmount` = '7622' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706142' WHERE `Matrix_Unique_ID` = '209651956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '92168680' ,`ListAgentFullName` = 'Pamela Jones' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719653' ,`Longitude` = '-95.797823' ,`PhotoCount` = '44' ,`PostalCode` = '77494' ,`RoomCount` = '8' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Lacey Oak Meadow' ,`StreetNumber` = '5202' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3269' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with great flow, incredible storage and huge rooms. This 3 bedroom 3 bath, one and half story has an office, game room and media room. Relax or entertain while enjoying your cozy stone fireplace in the family room open to the kitchen/ breakfast areas. Gourmet kitchen offers lots of granite countertops and cabinet space with like new stainless steel appliances. Huge walk in pantry and a Butler\'s pantry between kitchen and formal dining area. Natural light beams thru out the home. Formal dining has beautiful \r\nwains coating trim and laminate luxury flooring. Office has glass doors and could easily be converted to another bedroom. Large primary bedroom with walk in closets with bath that has a soaking tub and separate shower. Upstairs you have a game room and a media room. Media room includes projector, screen, and nine reclining theatre chairs. Attic has walk area perfect for extra storage. Beautiful shaded yard ,no back neighbors,koi pond and garden shed included. KISD' ,`Acres` = '0.2089' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEVEN MEADOWS SEC 14, BLOCK 2, LOT 17' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9099' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Seven Meadows Sec 14' ,`TaxAmount` = '7938' ,`TaxRate` = '2.3145' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706142' WHERE `Matrix_Unique_ID` = '209682180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '1022449' ,`ListAgentFullName` = 'Mary Wise' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.151779' ,`Longitude` = '-95.026579' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '15' ,`ListPrice` = '1765000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewing Teal' ,`StreetNumber` = '4114' ,`StreetSuffix` = 'Court' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3027' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coastal living at its finest in the gated Sunset Cove community on Galveston\'s west end! This nearly new custom design with beautiful landscaping boasts 5 bedrooms, 4 full & 2 half baths, & an exquisite open concept with wood look tile floors, recessed lighting, & custom window shades throughout. The oversized island kitchen showcases white quartz counters, custom ceiling height cabinetry with lighting, & top-notch Viking appliances. Additionally, on this level, you\'ll find a bedroom with ensuite bath, an oversized utility room, & convenient half bath. Upstairs, find 3 additional bedrooms with ensuite baths, a built-in bunk room, & a game room. Enjoy the sunrise or sunset off your bi-level east & west-facing decks with endless views of the beach, bay, & canal. Entertain outdoors with numerous covered sitting areas, an outdoor kitchen, bath, & shower, a 2-level composite decked boathouse with a 23\'x10\' slip, boat lift, & green lights, & a fully fenced backyard with sprinkler system.' ,`Acres` = '0.2141' ,`Area` = '33' ,`BuilderName` = 'Bay Point Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNSET COVE (2005), ABST 121, BLOCK F, LOT 3, ACRES 0.214' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '9327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Cove 2005' ,`TaxAmount` = '29714' ,`TaxRate` = '2.2124' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706142' WHERE `Matrix_Unique_ID` = '209924920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T00:12:08.550' ,`MLSNumber` = '83418216' ,`ListAgentFullName` = 'Mahsa Monshizadegan' ,`ListOfficeName` = 'R. Alexa Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848552' ,`Longitude` = '-95.721165' ,`PhotoCount` = '44' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Mountain Forest' ,`StreetNumber` = '5422' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 2-story home! 3 cars garage and a great neighborhood. The home is ready for your family to move in.\r\nLook for the updates list on file.' ,`Acres` = '0.2218' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 WESTFIELD PINES SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '9660' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'EMERY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Westfield Pines Sec 02' ,`TaxAmount` = '5967' ,`TaxRate` = '2.821' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706142' WHERE `Matrix_Unique_ID` = '209966377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '53072131' ,`ListAgentFullName` = 'Domingo Ruiz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084137' ,`Longitude` = '-95.494868' ,`PhotoCount` = '37' ,`PostalCode` = '77389' ,`RoomCount` = '5' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Flashing Ridge' ,`StreetNumber` = '22002' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great property in the Cul-De-Sac. This Beautiful home has a big kitchen with granite countertop, 42-inch cabinet space, large walk-in pantry, amazing family room, and game-room upstairs pre-wired for surround sound. Main bedroom Suit along with a Secondary guest suite both on the first floor. Along with three other bedrooms upstairs with an open concept game room. The Property includes a “Home automated system for lights, 2-Hyper-filter systems, an auto-Alarm system, Intercom system, and a 6 Video camera monitoring system. This house has a brand new 30-year roof with a warranty and seamless gutters all around.' ,`Acres` = '0.1703' ,`Area` = '14' ,`BuilderName` = 'Mertiage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 4 SAWMILL RANCH SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7418' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sawmill Ranch Sec 1' ,`TaxAmount` = '10806' ,`TaxRate` = '3.0041' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706142' WHERE `Matrix_Unique_ID` = '210032586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '51735158' ,`ListAgentFullName` = 'David Vallejo' ,`ListOfficeName` = 'Brent Allen Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833150' ,`Longitude` = '-95.476865' ,`PhotoCount` = '20' ,`PostalCode` = '77092' ,`RoomCount` = '5' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = '43rd' ,`StreetNumber` = '5722' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing traditional style Oak Forest home! Recently remodeled 4 bedroom, 2.5 baths, that features an open kitchen and living combo! New flooring throughout the entire home. An additional family room that can double as a work from home space! The bathrooms have also been fully renovated. An attached two car garage and a covered patio in your fully fenced in backyard! Located minutes away from Downtown, The Galleria, The heights and Energy Corridor!' ,`Acres` = '0.1802' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 2 OAK FOREST SEC 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7848' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 17' ,`TaxAmount` = '4640' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706143' WHERE `Matrix_Unique_ID` = '210066809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '70769749' ,`ListAgentFullName` = 'Elizabeth Smith' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710829' ,`Longitude` = '-95.423363' ,`PhotoCount` = '30' ,`PostalCode` = '77005' ,`RoomCount` = '13' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'Brompton' ,`StreetNumber` = '6504' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately custom-built home on oversized corner lot in prime West U location. Gorgeous entry with sweeping circular staircase. Perfectly designed for entertaining with expansive rooms and lots of windows with natural light. Lovely wood-paneled study. Hardwoods, handsome wood trim, and molding throughout the first floor. Cook’s kitchen with oversized island opens to family room with beautiful built-ins. Primary suite and three secondary bedrooms plus playroom on second floor. Third floor could be a guest suite with full bath or secondary workspace or playroom. Recent roof, fence, HVAC, and hot water heaters. Incredible opportunity to acquire this gracious West U masterpiece.' ,`Acres` = '0.1837' ,`Area` = '17' ,`BuilderName` = 'Heritage Home Builde' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 6 BLK 9 WEST UNIVERSITY PLACE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'West University Place Sec 01' ,`TaxAmount` = '37070' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706143' WHERE `Matrix_Unique_ID` = '210067173' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '82085228' ,`ListAgentFullName` = 'James Skelton' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687930' ,`Longitude` = '-95.830784' ,`PhotoCount` = '43' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Dellrose Crossing Dr' ,`StreetNumber` = '11035' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this 4 bedroom, 2.5 bath home. Located in the quiet community of Westheimer Lakes. The open floor plan, with high ceilings and abundance of windows highlight the natural beauty of the home. The kitchen offers plenty of counter & cabinet space. The home has an open living area with views of the backyard. The spacious primary suite features a walk-in CLOSET. The home is located on a large lot. Westheimer Lakes is a master planned community with easy access to Westpark Tollway/1093, Grand Pkwy/99, shopping, and entertainment. Community features: pool, splash pad, clubhouse, playground, walking trails, basketball pavilion, volleyball and tennis courts. Low tax rate! A MUST See!!!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Villas At Westheimer Lakes Sec 1, Block 2, Lot 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '855' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villas At Westheimer Lakes' ,`TaxAmount` = '5159' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706143' WHERE `Matrix_Unique_ID` = '210150655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '49971081' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.371844' ,`Longitude` = '-95.497947' ,`PhotoCount` = '33' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Thunderbird' ,`StreetNumber` = '144' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2-story 4 bed 2.5 bath home situated on 0.34 acres in the highly sought after Panorama Village subdivision of Conroe! This home features an open concept with an oversized family room that flaunts hardwood floors, beamed ceilings, and effortlessly transitions into the kitchen/dining area. In the kitchen you\'ll find SS appliances, a gas cooktop, large island, and an abundance of cabinetry and counter space with an adjacent breakfast room. The primary bedroom is located downstairs with an en-suite bath and a massive walk-in closet. Upstairs is the game room, and 3 additional bedrooms + a full bath with a walk-in shower. Additionally, one of the bedrooms upstairs allows access to the patio. Exterior features include a large back deck, fenced in backyard, and 0.34 acres partially wooded. This home is priced to sell and won\'t last long. Schedule a private tour today!' ,`Acres` = '0.3444' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'S774000 - PANORAMA-THUNDERBIRD, LOT 144, 145' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Panorama-Thunderbird' ,`TaxAmount` = '5080' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706143' WHERE `Matrix_Unique_ID` = '210212054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '77142762' ,`ListAgentFullName` = 'Luis Cortes' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741354' ,`Longitude` = '-95.636279' ,`PhotoCount` = '32' ,`PostalCode` = '77077' ,`RoomCount` = '9' ,`ListPrice` = '347000.00' ,`Status` = 'Active' ,`StreetName` = 'Briarcrest' ,`StreetNumber` = '2007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION!!!! Welcome to your new beautiful Home in the Energy Corridor. Located minutes away from Westpark Tollway, Beltway 8, I-10,Hw-6, and City Center. Shopping and restaurants also minutes away. All brick one story with beautiful large pool and hot tub to enjoy in Summer with family and friends. Roof was replaced in 2021. Dishwasher and Oven replaced June 2019, cooktop replaced 2019, water heater replaced 2019, titchen was remodeled 2019. New Flooring August 2019, Windows replaced 2017, NEVER FLOODED,' ,`Acres` = '0.1956' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 17 BRIAR VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '570' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Village Sec 02' ,`TaxAmount` = '5925' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706143' WHERE `Matrix_Unique_ID` = '210234158' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '53721762' ,`ListAgentFullName` = 'Robert (Bob) Murdock' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986300' ,`Longitude` = '-95.188725' ,`PhotoCount` = '35' ,`PostalCode` = '77346' ,`RoomCount` = '16' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Breaks' ,`StreetNumber` = '12443' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dramatic 2 story porch entry & leaded glass front door opens to the 2 story foyer. Foyer is flanked by the formal dining to one side & a study with French doors to the other. Primary bedroom & second bedroom both on the ground floor.Secondary bedroom w/direct access to a full bath.Family room is open to the large island kitchen. Fireplace is on an interior wall so unobstructed views provided out the windows to the back yard.Spacious primary bedroom also w/views to the back yard has a large bath w/whirlpool tub & separate shower.Entire first floor is either tile or engineered wood,even includes wood on the stairs to the second floor.Highly desirable quiet cul-de-sac location,yet quick access to all of the arterial streets for shopping & restaurants.Upstairs starts w/a large game room.Game room is flanked by the 3 additional bedrooms.One pair has a jack & jill bath between them & the 4th bath completes the 2nd floor.Seller leaving the washer/dryer, refrigerator & free standing freezer.' ,`Acres` = '0.1971' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 EAGLE SPRINGS SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8584' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '10436' ,`TaxRate` = '2.9726' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706143' WHERE `Matrix_Unique_ID` = '210264572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '81171195' ,`ListAgentFullName` = 'Monica Brashear' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054963' ,`Longitude` = '-95.723545' ,`PhotoCount` = '18' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '334999.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Lariat' ,`StreetNumber` = '19426' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 19426 Golden Lariat in the popular development of Amira, featuring a quaint brick exterior complemented by cedar shake shingle accents, decorative shutters and beautiful framed glass entry! This charming one story boasts an open floor plan and a stylish on-trend color palette and finishes. An enormous kitchen island is the focal point of the crisp white culinary space. It also doubles as a breakfast bar. Wood-look tile flows throughout the main living areas, creating a desirable neutral background. Numerous windows create a light, open and airy feel. The home features four bedrooms and two full baths, which provide flexibility. Any of the secondary bedrooms could easily be utilized as an office or playroom. Just inside the attached garage is a convenient MUD area. This is an energy star certified home and boasts a tankless water heater as well. Enjoy all Amira has to offer as well as being conveniently located right off of 99!' ,`Acres` = '0.1622' ,`Area` = '35' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 38 BLOCK 2 AMIRA SECTION 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7065' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '9371' ,`TaxRate` = '3.4925387' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706143' WHERE `Matrix_Unique_ID` = '210268302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '10697288' ,`ListAgentFullName` = 'Haydee Casco' ,`ListOfficeName` = 'Thompson & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894193' ,`Longitude` = '-95.222118' ,`PhotoCount` = '12' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Greencanyon' ,`StreetNumber` = '11954' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This gorgeous house features updates throughout. As you enter you notice the open concept between the kitchen and living area, to the right you have an updated kitchen with a large island and to the left a spacious Livingroom. Down the hall you will find an updated full bathroom and 3 bedrooms. The primary bedroom offers a full private bathroom with a large stand-up shower. The secondary rooms are spacious and have their own closets. Don\'t wait, schedule a private tour today!' ,`Acres` = '0.101' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 6 GREENSBROOK SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greensbrook Sec 01 Rep' ,`TaxAmount` = '3301' ,`TaxRate` = '3.1593' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706144' WHERE `Matrix_Unique_ID` = '210310867' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '2843786' ,`ListAgentFullName` = 'Dehong Marchtaler' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802844' ,`Longitude` = '-94.822354' ,`PhotoCount` = '44' ,`PostalCode` = '77523' ,`RoomCount` = '0' ,`ListPrice` = '426000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Isle' ,`StreetNumber` = '6211' ,`StreetSuffix` = 'Lane' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a rare find! Brand new 3 bd, 2ba house on half acre at highly acclaimed Barbers Hill school district. This beautiful one-story home boasts a spacious open concept floor plan, quartz countertop, brand-new stainless-steel appliances, brand new cabinets, brand new double stainless-steel sink, beautiful tile throughout living room, kitchen, laundry room, his and her closet at primary bathroom. Private master bathroom features new glass barn door shower and built-in cabinets for clothes, and a side door to the outside. 5-ton Tran AC system, brand new aerobic system. New plumbing, new electrical wiring, and a mother-in-law suite /extra living quarter for anyone who needs a project to do. A little bit of elbow grease or sweat can turn it to a beautiful man cave or guest house. Also, this new build has a covered rear patio, back patio, and side patio. Long double wide driveway for your RV and boat parking. Low tax! Come see this well-done new build and make it your next dream home!' ,`Acres` = '0.548' ,`Area` = '53' ,`BuilderName` = 'Colmex Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 71 THE SOUTHERN PLANTATION SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '23871' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Plantation Sec 2' ,`TaxAmount` = '667' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706144' WHERE `Matrix_Unique_ID` = '210326581' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','210328070','1663706144','210328070','2022-09-03T00:20:32.097','70287985','Kristi Henry','Galveston Vacation Real Estate','','','29.535745','-95.170485','0','77546','7','326000.00','Active','Raven Falls','2618','Lane','Friendswood','2','0','3','1956','Single-Family','Just what you\'ve been waiting for! Fall in love with the open floor plan of this 3 bedroom, 2 bath home, nestled away in the quiet subdivision of Heritage Park Village. Centrally located close to I 45 access makes commuting very convenient! You are always just minutes away from restaurants, shopping, malls, medical centers and much more! Everything at your fingertips! Zoned to some of the most highly sought after and top rated schools in the Clear Creek district. Home has just been recently refreshed with interior paint throughout along with several updates and custom upgrades! This home won\'t last long! It\'s waiting for you to come add your personal touch and make it your own. Call today for details! Don\'t miss another opportunity!','0.151','7','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Friendswood','Central Gas','1','LT 3 BLK 2 HERITAGE PARK SEC 25','Cleared,Cul-De-Sac','6578','Appraisal District','','360','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','9 - Clear Creek','GREENE ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','BROOKSIDE INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Temporarily No Showings','Appraisal District','1','Contemporary/Modern,Traditional','Heritage Park Sec 25','5064','2.166','Public Sewer,Public Water','2000','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '2847346' ,`ListAgentFullName` = 'Pamela Rencurel' ,`ListOfficeName` = 'Kenyson Roane Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.640171' ,`Longitude` = '-95.795047' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '11' ,`ListPrice` = '960000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '5318' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5049' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful custom home sits on 1.6 acres in coveted Woods Edge. this masterpiece hosts 5 bedrooms, all with en-suite baths, and 2 bedrooms down, 2 primary bedrooms, one is up, impressive curved stone fireplace in the family room. Pool area has half bath and outdoor shower.' ,`Acres` = '1.616' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WOODS EDGE SEC 2, LOT 151, ACRES 1.616' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '70393' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woods Edge Sec 2' ,`TaxAmount` = '11809' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706144' WHERE `Matrix_Unique_ID` = '210391339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '69977063' ,`ListAgentFullName` = 'Katy Walston' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805127' ,`Longitude` = '-95.415994' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = '21st' ,`StreetNumber` = '933' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, Well-appointed, Spanish Inspired 3-bedroom/3.5-bathroom Home minutes away from countless Houston Hot Spots. Some Upgrades & Features include; Stained Concrete Floors, Ext Beautiful Hardwood floors, NO Carpet, Formal 3 Story Entryway, Dramatic Staircase w/wrought iron balusters, Spacious Open Family Room w/Built in Office Area, Chef\'s Kitchen w/Granite Counters, Breakfast Bar, Under Cabinet Lighting, Oversized Dining Room perfect for entertaining, French Doors leading to 2nd floor Balcony perfect for grilling or enjoying your morning coffee, Generously sized Primary Suite w/vaulted ceiling, walk-in closets & spa-like bathroom, Large secondary bedrooms w/en-suite baths, Storage Galore, Recent Neutral Interior Paint, Updated Fixtures and Finishes throughout, Gated Entry w/Turf Side Yard, plus much, much more! Just a quick walk to some of Houston\'s favorite restaurants, parks, coffee shops and night life.' ,`Acres` = '0.0427' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 COSTA DEL SOL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1862' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Shady Acres' ,`TaxAmount` = '9940' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706144' WHERE `Matrix_Unique_ID` = '210408715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '25923307' ,`ListAgentFullName` = 'Michelle Pena' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005369' ,`Longitude` = '-95.433594' ,`PhotoCount` = '23' ,`PostalCode` = '77090' ,`RoomCount` = '3' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Skywood' ,`StreetNumber` = '426' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your newly remodeled home in the charming North Forest Community located in a great location for easy commute, this beautiful home is right off a corner lot with offering 8,000 sq ft of the lot itself located just around the corner from Meyer Elementary School. This home features three bedrooms with two full baths and a spacious backyard with a covered porch. The living room is open to the breakfast area as well as the kitchen providing the perfect place to entertain friends and family. Schedule your appointment today!' ,`Acres` = '0.202' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 6 NORTH FOREST SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MEYER ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Forest Sec 01' ,`TaxAmount` = '3518' ,`TaxRate` = '2.6492' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706144' WHERE `Matrix_Unique_ID` = '210411754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '18731057' ,`ListAgentFullName` = 'Kelly Kelley' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.196199' ,`Longitude` = '-94.983153' ,`PhotoCount` = '44' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1149000.00' ,`Status` = 'Active' ,`StreetName` = 'Karankawa' ,`StreetNumber` = '4308' ,`StreetSuffix` = 'Way' ,`City` = 'Jamaica Beach' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Income-producing, newer construction, east-facing canal home with immediate access to the bay in Jamaica Beach! This home is complete with a 14’ vaulted ceiling in the living room, shiplap accent walls, an open floorplan, well-appointed kitchen, vinyl plank flooring, quartz countertops, tankless water heater, spray foam insulation, cargo lift, over 700 sq. ft. of composite decking, covered patio space, and tiki bar. The first floor consists of the primary retreat, 2 guest bedrooms, a guest bathroom, and the utility room. 2 additional bedrooms each featuring an en-suite bath are upstairs. The home conveys furnished with a few exclusions, and is set up to accommodate 19 guests. Jamaica Beach community has a boat ramp, beach access, their own city services, restaurants, and a pool (separate fee to use). Why not have a 2nd home that can also earn you money? Schedule to see this home today.' ,`Acres` = '0.1537' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 44 JAMAICA BEACH SEC 26' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6695' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Jamaica Beach' ,`TaxAmount` = '13417' ,`TaxRate` = '1.7044' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706144' WHERE `Matrix_Unique_ID` = '210558233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '92966090' ,`ListAgentFullName` = 'Janice Williams' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505602' ,`Longitude` = '-95.080865' ,`PhotoCount` = '27' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '308000.00' ,`Status` = 'Active' ,`StreetName` = 'Illinois' ,`StreetNumber` = '819' ,`StreetSuffix` = 'Avenue' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2310' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom-built 1-owner home with flexible floor plan-large lot and NO HOA. The split floor plan has 2 bedrooms and 2 baths on the 1st floor. A large kitchen with lots of storage opens to the breakfast area. Notice the separate entrance originally designed as a home office can be used as mother-in-law quarters, teen bedroom, or a game room you decide!2 large bedrooms with 3rd bath in the middle upstairs. Fenced back yard with a patio & storage/workshop bldg. Wide concrete drive for multiple cars/boats or RV parking. Country living/ lower tax rate /never flooded per seller. New Paint & Carpet just for you! Call your favorite Realtor today for a private showing.' ,`Acres` = '0.268' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 PAGE 3/15 PT OF LOT 31 (31-2) DIV B LEAGUE CITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11674' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'League City Div B' ,`TaxAmount` = '2776' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706144' WHERE `Matrix_Unique_ID` = '210604225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '21306530' ,`ListAgentFullName` = 'Sandra Tsui' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671719' ,`Longitude` = '-95.485179' ,`PhotoCount` = '38' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Valkeith' ,`StreetNumber` = '5643' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic ranch-style all-brick home in Meyerland area, never flooded, brand new updates. Move-in ready open floor plan, ceiling fan in every room, no carpet, spacious patio off back door toward large backyard with sprinkler system. New updates in 2022: roof (30 years shingles), AC system, nice and bright remodeled kitchen with granite counter tops, double sinks, faucets, disposal, dishwasher, flat top electric range oven, vent hood in kitchen; primary bath boasts new granite counter tops with duo sinks, cabinets, faucets; replaced granite counter tops, faucets in hall bath. Lovely extra touches - built-in bookshelf, tray ceiling, fireplace in living room. Additional insulation in attic and water heater replaced in 2021; sewer pipes replaced in 2020, foundation repairs in 2017 with life time warranty. Fantastic neighborhood with easy access to to Galleria & medical center, Brays Bayou walk-and-bike trail, ERJCC, Meyerland Plaza and more!' ,`Acres` = '0.2011' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 7 BARKLEY SQUARE SOUTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkley Square South Sec 02' ,`TaxAmount` = '7027' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706145' WHERE `Matrix_Unique_ID` = '210637341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '59428788' ,`ListAgentFullName` = 'Sheri Petersen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018558' ,`Longitude` = '-95.179322' ,`PhotoCount` = '27' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Shoreview' ,`StreetNumber` = '6307' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3167' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Market adjustment has been made to this stately two story home on tree shaded cul de sac in the sought after Kings River Village subdivision. Home highlights are travertine tile, wood floor, stacked stone fireplace, granite counters in kitchen and primary bath. The updates are extensive! Newer roof, ACcs hot water heater, carpet upstairs. Close proximity to Lake View Park on Lake Houston. HOME NEVER FLOODED. Easy access to IAH, Lake Houston, waterfront restaurants and walking trails.' ,`Acres` = '0.1948' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 KINGS RIVER VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Village' ,`TaxAmount` = '7569' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706145' WHERE `Matrix_Unique_ID` = '210699723' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '66015561' ,`ListAgentFullName` = 'Misti Bruton' ,`ListOfficeName` = 'AVO Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659958' ,`Longitude` = '-98.828517' ,`PhotoCount` = '28' ,`PostalCode` = '78023' ,`RoomCount` = '7' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon' ,`StreetNumber` = '451' ,`StreetSuffix` = 'Forest' ,`City` = 'Helotes' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a piece of Texas Hill Country in this gorgeous property on 6.5 acres of land! Vaulted ceilings, open floor plan, large glass windows to let lots of natural light in and a fully remodeled farm-type kitchen. Primary bedroom has an en-suite toilet and bath and double sinks. Enjoy breathtaking views from the outside, lots of trees and room to grow. All this while only 13 miles from San Antonio. Come see this gem and schedule your showing today!' ,`Acres` = '6.51' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON CREEK PRESERVE PHASE 5 BLOCK B LOT 6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '283576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '247 - Northside (Bexar)' ,`SchoolElementary` = 'LOS REYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'O\'CONNOR HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (NORTHSIDE)' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Creek Preserve Ph 5' ,`TaxAmount` = '7822' ,`TaxRate` = '1.9806' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706145' WHERE `Matrix_Unique_ID` = '210772915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '83282114' ,`ListAgentFullName` = 'Sharla Cole' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985934' ,`Longitude` = '-95.119361' ,`PhotoCount` = '44' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '394999.00' ,`Status` = 'Active' ,`StreetName` = 'Black Bear' ,`StreetNumber` = '1823' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction home located a block away from Lake Houston! This brand new modern home is stunning and energy-efficient. The outside of the home is pre-wired for security cameras. The oversized 2-car garage is 8ft tall and has a nook for extra storage. Enter through the front door and be welcomed by the living room and kitchen. The floors throughout the main areas are concrete with an epoxy metallic finish. The kitchen features an electric stovetop, pot filler, and brand new dishwasher, microwave and oven. The kitchen has an abundance of cabinetry and a walk-in pantry. The oversized primary suite has dual vanities, a large soaking tub, a walk-in shower, and an oversized walk-in closet with great shelving. Head up the stairs to the spacious bonus room and half bath. A perfect space to be used as a game room or play room! Community features a clubhouse, park and boat ramp for residents and their guests.' ,`Acres` = '0.287' ,`Area` = '1' ,`BuilderName` = 'Werkz of Art LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 291 HAPPY HIDE A WAY SEC 3 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Happy Hide A Way Sec 03 U/R' ,`TaxAmount` = '475' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706145' WHERE `Matrix_Unique_ID` = '210829863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '2474001' ,`ListAgentFullName` = 'Ashley Ruby' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.543542' ,`Longitude` = '-95.200045' ,`PhotoCount` = '34' ,`PostalCode` = '77546' ,`RoomCount` = '15' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Tall Timbers' ,`StreetNumber` = '611' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home on a quiet street lined with mature green trees awaiting your arrival, 4 Bedrooms 3 full bath and 2 1/2 baths on a huge lot, .78 acres! A brand new fence lines the oversized backyard. All new stainless steel appliances with a double oven and a gas cooktop in the Kitchen, and a waterfall Island of beautiful white quartz. New Flooring throughout and lots of windows for natural light! This home has a spacious first floor with a double fireplace for the enjoyment of all. The Primary Bedroom is downstairs and the bathroom is beautiful with a soaking tub, a large shower and a double vanity.\r\nOPEN HOUSE Saturday August 6, 12-5pm' ,`Acres` = '0.6978' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE FOREST SEC 3 (2000) ABST 20, BLOCK 1, LOT 17, ACRES 0.69' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Forest Sec 3 2000' ,`TaxAmount` = '16548' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706145' WHERE `Matrix_Unique_ID` = '210839275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '5001305' ,`ListAgentFullName` = 'Lynda Beck' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.912701' ,`Longitude` = '-95.722702' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '484600.00' ,`Status` = 'Active' ,`StreetName` = 'Fossil Valley' ,`StreetNumber` = '20335' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home is located in the award winning Cy-Fair ISD. Large lot on cul de sac street. Spacious throughout. Featuring a chefs kitchen with all stainless steel appliances, beautiful backsplash, butlers pantry, large walk in pantry and under cabinet lighting and island. Original owners. Close to schools, Towne Lake Boardwalk, movies, etc. Easy access to 290 and 99. In addition to Miramesa\'s on-site recreation center, residents also have full access to the Bridge Creek & Canyon Lakes West family of amenities.' ,`Acres` = '0.1973' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 MIRABELLA SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mirabella Sec 7' ,`TaxAmount` = '10295' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706145' WHERE `Matrix_Unique_ID` = '210872878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '35114588' ,`ListAgentFullName` = 'Cynthia Ramos' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804292' ,`Longitude` = '-94.893909' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '5' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Euros' ,`StreetNumber` = '7623' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning home has a bright, open floor plan.The kitchen is stylish and functional, looking out over a spacious but cozy dining/living area. Natural light beams through the large windows featured in both the dining and living room. Perfect for entertaining, your loved ones will gather around the island and make memories! The floor plan features 4 spacious bedrooms and 2 full baths.The primary bathroom has a luxurious stand alone shower, while the secondary bathroom has a tub/shower combo.The backyard offers a covered patio that is perfect for relaxing outside at any time of the day.The front yard has easy access to shared mailboxes and a 2 car garage. This home also has Solar Panels to cut energy costs, which in this Texas heat is a plus! The community amenities include a walking trail, a unique playground, and picnic table seating. Also in construction, is a community pool with a relaxing walkable trail to access it. Schedule a showing today…. and don\'t let this one slip away!' ,`Acres` = '0.1492' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BLK 2 LOT 16 SOUTHWINDS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds Sec 1' ,`TaxAmount` = '6641' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706145' WHERE `Matrix_Unique_ID` = '210965346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '30969104' ,`ListAgentFullName` = 'Maria Moore' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216129' ,`Longitude` = '-95.633016' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '1475000.00' ,`Status` = 'Active' ,`StreetName` = 'Crestwater' ,`StreetNumber` = '10906' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5293' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RICH HOME SEEKING SMART OWNER! For the discerning Buyer who appreciates quality and value, this spectacular home is the perfect fit. Situated on 4.3 wooded acres in the heart of the most sought-after community in Magnolia, this stunning automated home boasts too many upgrades and amenities to list. If self-sufficient living appeals to you, then the deep water well, 34kW liquid-cooled generator and large, smart-controlled greenhouse will impress. Additionally, the 3,000 SF, clear-span, fully insulated shop with a 1,000 SF man cave complete with a full bath and kitchenette is the envy of the neighborhood as it\'s the largest outbuilding approved by the community POA. Lake Windcrest arguably offers the best community amenities in the area including a 100+ acre ski & recreational lake, several other community fishing lakes, golf, horse riding trails and parks, and this amazing home offers the very best in luxury, convenience, functionality and lifestyle!' ,`Acres` = '4.35' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE WINDCREST 04, BLOCK 1, LOT 18,19, 50.000000% UDI' ,`LotDesciption` = 'Corner,In Golf Course Community,Water View,Wooded' ,`LotSize` = '189486' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Windcrest' ,`TaxAmount` = '8977' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706146' WHERE `Matrix_Unique_ID` = '210987215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '27456668' ,`ListAgentFullName` = 'Brittany McKinney' ,`ListOfficeName` = 'Thompson & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511874' ,`Longitude` = '-95.437388' ,`PhotoCount` = '19' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Madera Bend' ,`StreetNumber` = '13826' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two-story home situated in desirable Lakes of Savannah. Beautiful entryway and high ceilings. A private flex room can be used as a home office/study/studio space. The family room has huge windows with lots of natural light. The gourmet kitchen features granite countertops, stainless steel appliances, bar seating & tons of storage space. Adjacent to the kitchen is a spacious dining area. The primary bedroom is located downstairs with natural light, huge walk-in closet. The primary bath includes Jack and Jill vanities, separate shower and soaking tub. Upstairs, you\'ll find a game room or media room. A large, covered patio overlooks the backyard. Community amenities include splash pad, pool, playground, walking trails, pet friendly, and more.' ,`Acres` = '0.1462' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STEWART HEIGHTS SEC 1 (A0403 ACH&B) BLK 2 LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stewart Heights Sec 1 A0403 A' ,`TaxAmount` = '10425' ,`TaxRate` = '3.3694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706146' WHERE `Matrix_Unique_ID` = '210988302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '485048' ,`ListAgentFullName` = 'Luis Zelaya' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793520' ,`Longitude` = '-95.537608' ,`PhotoCount` = '50' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Centennial' ,`StreetNumber` = '1325' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION!! Close to Memorial Mall, Memorial Hermann, Downtown and all amenities that it offers! Remarkable single-level home is now on the market! Offering attractive curb appeal w/lush green landscape, several shade trees, carport space, extended driveway, & RV gate. Discover a welcoming interior filled w/so much natural light, real wood flooring, a soothing palette, & a mirror wall in the dining area. Continue onto the well-maintained eat-in kitchen to find built-in 6 mos. old stainless steel appliances, tile flooring, oak cabinets, tile backsplash, a pantry, & plenty of counter space. The primary bedroom has a sliding-door closet & private half bathroom for added comfort. Host fun gatherings in this spacious grassy backyard w/huge covered patio, storage shed, & sports court. Don\'t let this incredible opportunity pass you by! Schedule your showing today!' ,`Acres` = '0.3535' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK A CENTURY OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Century Oaks' ,`TaxAmount` = '7671' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706146' WHERE `Matrix_Unique_ID` = '210994733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '18841367' ,`ListAgentFullName` = 'Allison Salas' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.262427' ,`Longitude` = '-95.870607' ,`PhotoCount` = '48' ,`PostalCode` = '77363' ,`RoomCount` = '3' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '8516' ,`StreetSuffix` = 'Road' ,`City` = 'Plantersville' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to acreage in peace and serenity. Perfect for a vacation rental or weekend retreat, Hickory Road will be your escape from the hustle and bustle of city life. If you are seeking a more permanent, calmer pace of life, Plantersville welcomes you. Enjoy the 2 acres worth of gorgeous scenery from any of the three attached porches to the main house. There are also plenty of entertaining opportunities in your outbuilding featuring a built-in bar and half bath, plus the charming gazebo located between the outbuilding and the main house is a great gathering area for family and friends, or another opportunity to unwind. Enjoy cooling off in these hot Texas summers in the 25\' pool located on the side of the main house. The pool comes with a custom deck and additional storage shed in rear of pool. The guest house offers additional housing or storage as well. \r\nMost special of all, the property is located minutes from The Renaissance Festival Campgrounds where your adventure awaits!' ,`Acres` = '2' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W MAGNOLIA FRST SEC 17, LOT 16-6, ACRES 2.00' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'W Magnolia Forest Sec 17' ,`TaxAmount` = '3357' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706146' WHERE `Matrix_Unique_ID` = '211007322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '89829634' ,`ListAgentFullName` = 'Heather Trocmet' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877913' ,`Longitude` = '-95.294906' ,`PhotoCount` = '19' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Mohawk' ,`StreetNumber` = '6319' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One-story 3 bedroom / 2 bath home with tons of potential for you to add your own personal touch and make it your own, would also make a great investment property! The home was remodeled in 2009 and offers a spacious living room, a kitchen with an eat-in breakfast area, 2 full baths, and 3 generous-sized bedrooms. The extra-large backyard space is fenced in and has tons of room for gardening and family fun. You must see for yourself to realize the potential!' ,`Acres` = '0.1446' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 32 NORTHWOOD MANOR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Manor Sec 02' ,`TaxAmount` = '2820' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706146' WHERE `Matrix_Unique_ID` = '211014203' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '48737008' ,`ListAgentFullName` = 'Jackie Colvin - Welch' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705151' ,`Longitude` = '-95.839208' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Prescott Run' ,`StreetNumber` = '6003' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3857' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!! Gorgeous well maintained 6/4/2 2 story in the sought-after community of Westheimer Lakes. Boasts a Grand Entry Foyer with Soaring High Ceilings and Grand Wrought iron Staircase and Catwalk. Spacious Family Room Showcase a Wall of Windows with fireplace. Open to Kitchen/Stainless Appliances & Breakfast Bar with Huge Island. Master Suite Down features Jetted tub & Separate Shower, His & Hers Vanities with Walk-in Closet. Also this home offers another bedroom downstairs!! Perfect Mother-inlaw/with full bath accross hall. The Grand Staircase Leads upstairs to Huge Gameroom with built-in bookcase/ Plus 4-additional bedrooms...One bedroom that has interior access door to full bath with shower. This home include a Jack & Jill bath Perfect for kiddo\'s or Teens!! The Garage has tons of built in cabinets and storage space. Zoned to the Acclaimed KATY ISD schools. Conveniently close to Westpark Toll, TX-99, I-10, and just minutes away from all of your shopping and dining needs.' ,`Acres` = '0.1612' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTHEIMER LAKES NORTH SEC 4, BLOCK 3, LOT 40' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '855' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SHAFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westheimer Lakes North Sec 4' ,`TaxAmount` = '9414' ,`TaxRate` = '2.6345' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706146' WHERE `Matrix_Unique_ID` = '211016311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '70249995' ,`ListAgentFullName` = 'Jimmy Simien' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.651894' ,`Longitude` = '-95.173681' ,`PhotoCount` = '16' ,`PostalCode` = '77504' ,`RoomCount` = '7' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Bolivia' ,`StreetNumber` = '3931' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home with an open floor plan located in the Vista Villas neighborhood. This home has it all! Features include: pool, screened backyard, courtyard on the side of the home, three car garage + a craft room, 3-4 bedrooms, 2.5 bathrooms, granite countertops in the kitchen, stainless steel appliances, soft closing cabinets and drawers, kitchen island and breakfast bar overlooking the large living area. Primary bedroom includes a fireplace, en suite with a large walk-in shower, and walk in closet! Close to shopping and restaurants. Call for your private showing today!' ,`Acres` = '0.2439' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 4 VISTA VILLAS SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'JENSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vista Villas' ,`TaxAmount` = '9431' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706146' WHERE `Matrix_Unique_ID` = '211054746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '48204855' ,`ListAgentFullName` = 'Christopher Johns' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.573896' ,`Longitude` = '-95.686896' ,`PhotoCount` = '34' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Linden Grove' ,`StreetNumber` = '5410' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built to entertain! Be the host with the most by calling this stunning 4 bedroom, 3 bath Sugar Land home your own! Filled with natural light and elegance throughout! The formal living room and dining room sit at the heart of the home and features crown molding, designer lighting, and large windows. Inviting family room with a stately fireplace and access to the backyard opens to the eat-in kitchen. The spacious kitchen boasts a breakfast bar, built-in appliances, a pantry, tiled backsplash, ample prep space, and a bright breakfast nook. The peaceful second-floor primary suite with a soaring ceiling, crown molding, dual sinks, a separate shower, a soaking tub, and a walk-in closet. The second floor is also shared by a game room and secondary bedrooms. Don\'t miss the bedroom and bath on the first floor that is great for guests or as a home office! The private backyard with a patio provides additional outdoor living and entertaining space! 3D tour online!' ,`Acres` = '0.1577' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK SEC 7, BLOCK 1, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6868' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '845' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark' ,`TaxAmount` = '6975' ,`TaxRate` = '2.6977' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706147' WHERE `Matrix_Unique_ID` = '211070466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '51301025' ,`ListAgentFullName` = 'Fabiola Duenas' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875886' ,`Longitude` = '-95.933964' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '12' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallard' ,`StreetNumber` = '32636' ,`StreetSuffix` = 'Street' ,`City` = 'Brookshire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom home on 1.2 acres, country life near suburbs/city! Minimal HOA restricts commercial cattle+18whlrs for clean country blend. Enjoy personal farm animals, horses & sprawling land fenced w iron automatic gate. Stone+brick facade welcome into soaring foyer, flows to dining room w matching chandeliers ready to host. Living room opens to chefs kitchen w real wood 42\' cabinets, under lights, thick granite in entire hm, SS appl, ample counter space & brkfst area. 2 majestic primary bedrooms, 1 down & larger 1 up, both have seating areas, separate his/her vanities+separate tub/showers & walk-in closets. 3 addntl bedrooms & extended game room complete energy efficient main hm. Garage has bed+bath, flex for post work/guests/pool. 6 beds+4 1/2 bath property & oversized 3 car garage. Texas-sized porch, beautiful maple trees & chicken coup that can stay. The land offers so much for you to enjoy! FM 529 make it super accessible:Target, Sunterra Lagoon, I10&99. Only 8 years old, priced to sell!' ,`Acres` = '1.17' ,`Area` = '26' ,`BuilderName` = 'Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S669100 PEREGRINE ESTATES 2 LOT TR 193 ACRES 1.17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '50965' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Peregrine Estates' ,`TaxAmount` = '8557' ,`TaxRate` = '2.0967' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706147' WHERE `Matrix_Unique_ID` = '211098048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '71627303' ,`ListAgentFullName` = 'Alicia Preston' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118320' ,`Longitude` = '-95.502465' ,`PhotoCount` = '17' ,`PostalCode` = '77389' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenfield Spring' ,`StreetNumber` = '5415' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! When you enter this beautiful home you are greeted by a grand entry hall with tall, recessed ceilings & arched doorways. The home-office has double doors, upgraded wood floors & overlooks the front yard. Large formal dining room has recessed ceiling & easy kitchen access through the butlers pantry. No shortage of cabinet or counter space in this fabulous kitchen! With an island in the middle, an oversized breakfast bar with plenty of room for seating, plus a skylight, this kitchen sure makes you feel like it is the heart of the home. Kitchen is open to the spacious family room with a gas fireplace. The primary suite features an oversized shower and big walk in closet. This special floor plan even has an added half bathroom! Large covered patio in backyard, 6\' extension in garage perfect for extra storage or a work space, recently painted, Klein ISD, Incredible location with easy access to 99, Hardy Toll Road, I-45. Minutes from The Woodlands, Exxon, etc.' ,`Acres` = '0.1531' ,`Area` = '14' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 HAMPTON CREEK SEC 2 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6669' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hampton Creek' ,`TaxAmount` = '8783' ,`TaxRate` = '3.304' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706147' WHERE `Matrix_Unique_ID` = '211130411' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '11591611' ,`ListAgentFullName` = 'Sharla Cole' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952859' ,`Longitude` = '-95.440197' ,`PhotoCount` = '47' ,`PostalCode` = '77067' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Chalk Rock' ,`StreetNumber` = '1318' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this well-maintained home with an excellent floor plan today! Upon entering this home you will be welcomed by a formal living/dining room combo. Just off from the living room is a home office/study. Continue past the dining room and enter the open kitchen/family room. The spacious kitchen has lots of cabinet space, a gas stove, and a spacious pantry. Enjoy 8\'-9\' ceilings throughout the home. The oversized primary bedroom has lots of space with a spacious walk-in closet. The primary suite features a separate soaking tub and walk-in shower. Secondary bathroom is just off from the secondary bedrooms and has a tub/shower combo. Laundry room is located inside the house. The seller is including the washer/dryer/refrigerator with the sale of the home. A/C and roof were updated in 2019.' ,`Acres` = '0.1326' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 67 BLK 1 GREEN OAK PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SPENCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Green Oak Park Sec 01' ,`TaxAmount` = '5157' ,`TaxRate` = '2.9908' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706147' WHERE `Matrix_Unique_ID` = '211166992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '82190244' ,`ListAgentFullName` = 'Heather Murley' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.008836' ,`Longitude` = '-95.224140' ,`PhotoCount` = '50' ,`PostalCode` = '77338' ,`RoomCount` = '14' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Riviera' ,`StreetNumber` = '3310' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome HOME to this beautifully done 5/6 bedroom home sitting on a VERY LARGE corner lot at .93 acres! Tucked away in this private and peaceful community of Belleau Woods, this home boast of updates throughout! You need to come and see! Downstairs has 2 LARGE Living areas BOTH with fireplaces, LARGE Formal Dining with cabinet/buffet built in, Sunroom, Exercise room, Bedroom w attached full bath, 1/2 Bath, Breakfast Room, LARGE Island Kitchen, and a room that could be a 6th Bedroom or Office. Upstairs, hide away in the EXTRA LARGE Primary Bedroom with fireplace and 2 full Bathrooms attached and 2 Walk-in closets and deck overlooking backyard! 3 Additional Bedrooms upstairs. LARGE multi purpose Laundry Room. TONS of closet space! You can walk across the street through a trail & go fishing or watch the sunset at the communities Private lake. Close to IAH, 59/69, 99, Shopping, Mall & Restaurants. No MUD tax.' ,`Acres` = '0.9338' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 13 14 15 & 16 & E 1/2 OF LT 12 BLK 7 BELLEAU WOODS SEC 3' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '40676' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '51' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HUMBLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'ROSS STERLING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Belleau Wood Sec 3' ,`TaxAmount` = '7028' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706147' WHERE `Matrix_Unique_ID` = '211229250' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '67123346' ,`ListAgentFullName` = 'Paul Chiorean' ,`ListOfficeName` = 'Stoneburner & Associates ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.916849' ,`Longitude` = '-95.677167' ,`PhotoCount` = '33' ,`PostalCode` = '77095' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Double Lilly' ,`StreetNumber` = '17214' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazingly updated 3/2/2 one-story home with contemporary finishes in the desirable neighborhood of Canyon Lakes at Stonegate. This home features an open concept floor plan, spacious living room with a gas log fireplace, lots of large windows throughout, a water softening system, luxury waterproof vinyl, and laminate flooring throughout the entire home. The updated kitchen features Calcutta countertops and is equipped with Samsung stainless steel appliances. The oversized primary suite comes complete with a bathroom to match, including a large garden tub, separate shower, dual sink vanity, and huge walk-in closet. The two secondary bedrooms come with walk-in closets, and the oversized bonus room can be used as an office, media room, or game room. The spacious backyard has a large wooden deck for enjoying. The community has a variety of amenities and is minutes away from Towne Lake Boardwalk shopping and restaurants. **SELLER WILLING TO SELL THE FURNITURE IN HOME**' ,`Acres` = '0.1401' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 3 CANYON LAKES AT STONEGATE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Canyon Lakes At Stonegate 05' ,`TaxAmount` = '6272' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706147' WHERE `Matrix_Unique_ID` = '211233207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '28537969' ,`ListAgentFullName` = 'Joyce Castillo' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624035' ,`Longitude` = '-95.438236' ,`PhotoCount` = '17' ,`PostalCode` = '77045' ,`RoomCount` = '5' ,`ListPrice` = '189900.00' ,`Status` = 'Active' ,`StreetName` = 'White heather' ,`StreetNumber` = '14022' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy one story home is now available and conveniently located near the NRG Stadium, the medial center, within walking distances to schools, and within a close radius to Downtown houston. This house features 3 spacious bedrooms, 1 full bathroom, tile flooring through the majority of the house and carpet in the bedrooms. The floor plan is open and accommodating and it also has a nice size room that can be used as a dining room or sitting area. The outside of the home has a long and covered driveway, lovely brick throughout, and a great size backyard, come take a look to see how you can add your special touch to this property to make it yours!' ,`Acres` = '0.1515' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'N 55 FT OF S 65 FT OF LT 19 BLK 1 SOUTHGLEN SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southglen Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706147' WHERE `Matrix_Unique_ID` = '211286896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '73872425' ,`ListAgentFullName` = 'Caileigh Thaxton' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965854' ,`Longitude` = '-95.168091' ,`PhotoCount` = '30' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Bardwall Lake' ,`StreetNumber` = '13310' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3265' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this beautiful 4 bedroom 2 1/2 bath gem your home! This home features and open floor plan with a formal dining and formal living space. The kitchen has a large island kitchen with beautiful granite countertops and backsplash along with stainless appliances. The primary bath is its own getaway for you to retreat to after a long day. It has a large garden tub with a separate shower. This stunning home is located in the highly sought-after subdivision of Waters Edge on Lake Houston! The Waters Edge subdivision is surrounded with restaurants, education opportunities, entertainment venues, shopping and more.' ,`Acres` = '0.2173' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 3 WATERS EDGE SEC 5 AMEND' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waters Edge Sec 5' ,`TaxAmount` = '10412' ,`TaxRate` = '3.1539' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706148' WHERE `Matrix_Unique_ID` = '211344134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '91184330' ,`ListAgentFullName` = 'W. Tony Chavez' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729653' ,`Longitude` = '-95.002320' ,`PhotoCount` = '34' ,`PostalCode` = '77520' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress' ,`StreetNumber` = '1300' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2022 built home on a corner lot! Take a look at this attractive modern home with a unique floorplan with 3 bedrooms and 3 full bathrooms! The Home feels comfortable with the new laminate vinyl flooring, modern white kitchen cabinets, quartz countertops, and stainless steel appliances. Relax at the back patio with plenty of space for gatherings and a double-wide driveway for easy parking.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = 'Amadeo Vasquez' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 13 AIRHART AMELIA' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Airhart Amelia' ,`TaxAmount` = '1480' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706148' WHERE `Matrix_Unique_ID` = '211414596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '75975383' ,`ListAgentFullName` = 'Andrea Sunseri' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.172837' ,`Longitude` = '-95.000244' ,`PhotoCount` = '31' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'Mitote' ,`StreetNumber` = '3903' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home was built in 2018 and has a sleek and modern look with all white cabinets, quartz countertops, and open floor plan. The high ceilings and large windows provide an abundance of light from either side of the home. The large decks provide great views of the bay. The quartz countertops and recessed lighting throughout the home that make the home feel bright and open. This home is a must see and will be sold fully furnished. Schedule a showing today!' ,`Acres` = '0.9042' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 107 BLK 3 INDIAN BEACH SEC 1' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '39385' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '393' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Beach 1' ,`TaxAmount` = '8150' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Aerobic,Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706148' WHERE `Matrix_Unique_ID` = '211432344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '32082160' ,`ListAgentFullName` = 'Marianne Cowan' ,`ListOfficeName` = 'Woodlands Realty Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209212' ,`Longitude` = '-95.341769' ,`PhotoCount` = '50' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Skies' ,`StreetNumber` = '17558' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Almost Brand New (Furniture Negotiable), 1-Story Coventry Home offers 4 beds w/ 4 FULL BATHS, 3-CAR garage, NO NEIGHBORS behind, Game Room/Media & Formal Study/Playroom conveniently located off the open-concept Gourmet Chef\'s Kitchen. Split Floor plan allows 2 beds in front, 2 beds in back. Kitchen Island is GIGANTIC with 360 degree Storage, perfect for entertaining. Home boasts HIGH CEILINGS throughout w/ UPGRADES GALORE including Double Ovens, Wine Chiller Fridge, additional Wine Racks, Stainless Steel Appliances, 36\" 5-Burner Gas Cooktop, high-end grade Wood Flooring, Marble GRANITE countertops , MODERN LIGHTING & much more. The SHOW STOPPING FEATURES are ELECTRIC SHADES & CALIFORNIA-STYLE CUSTOM CLOSET build-out!!! Located in the beautifully forested community of Artavia, near The Woodlands, Zoned to Conroe ISD, North of Grand PKWY between 45 & 59. Neighborhood Elementary under construction , Opening Soon! Watch the video & Matterport for full feature effects.' ,`Acres` = '0.1727' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S216902 - ARTAVIA 02, BLOCK 3, LOT 9' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '7522' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '996' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia 02' ,`TaxAmount` = '9928' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706148' WHERE `Matrix_Unique_ID` = '211443820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '20812539' ,`ListAgentFullName` = 'Leah Dinsmore' ,`ListOfficeName` = 'American Property Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016403' ,`Longitude` = '-95.181682' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '13' ,`ListPrice` = '870000.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Hill' ,`StreetNumber` = '6' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4141' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extraordinary estate on a cul-de-sac in the desirable Kings Lake Estates community. This neighborhood offers a 24 hour security-manned entry gate and luxury living. An outdoor entertainers dream with a spacious covered patio, built-in speakers, an extravagant outdoor kitchen, private pool, hot tub, outdoor half bath, outdoor shower, fire pit and generator hookups. Enter the homes private gym through the backyard before taking a dip in the cooling pool! Provide indoor entertainment at your home theater with luxurious seating, built-in entertainment center, projector and small fridge. Exit the upstairs game room to enjoy an expansive outdoor terrace overlooking the pool and landscaped backyard. Downstairs features the primary bedroom, mother-in-law suite and secondary bath. All upstairs bedrooms have an en-suite baths for convenience. Also, the home has NEVER FLOODED!' ,`Acres` = '0.5314' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 KINGS LAKE ESTATES SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '23147' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3327' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Lake Estates Sec 02' ,`TaxAmount` = '15412' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706148' WHERE `Matrix_Unique_ID` = '211460311' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '68559986' ,`ListAgentFullName` = 'Pearl Ngo' ,`ListOfficeName` = 'The Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656637' ,`Longitude` = '-95.694264' ,`PhotoCount` = '36' ,`PostalCode` = '77407' ,`RoomCount` = '5' ,`ListPrice` = '599995.00' ,`Status` = 'Active' ,`StreetName` = 'Netherby' ,`StreetNumber` = '17703' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional corner lot 1.5 story, 3 bedrooms 3.5 bath 3 car garage home filled with character, fine details and ambience, soaring tray ceilings, sophisticated finishes, upscale wood flooring and molding, 8 foot doors, custom oversized his and hers closet. Every bedroom has its own ensuite full bath and walk in closet. The kitchen, formal dining, and living are all open to each other, spacious open and wide hallway entrance with all rooms overlooking the enchanting patio with lush landscaping and an outdoor built- in gas grill, sprinkler system and water softener system. This beautiful home has an impressive wrought iron entrance leading to the handsome double wide front door, beautiful wood floor, plantation shutters. This home features fine details inside and outside, spectacular window views, and is located right across from the beautiful and tranquil park/lake/walking trail. Check out the virtual video tour! Contact your own trusted realtor to schedule an appointment today!' ,`Acres` = '0.1739' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 18, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7577' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana' ,`TaxAmount` = '4369' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706148' WHERE `Matrix_Unique_ID` = '211504842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '78533394' ,`ListAgentFullName` = 'LaQuana Davis' ,`ListOfficeName` = 'Brooks & Davis Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.412727' ,`Longitude` = '-95.008186' ,`PhotoCount` = '11' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Explorer' ,`StreetNumber` = '8810' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2123' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t Miss out on this beautiful home in Marlow Lake subdivision. The community is expanding why not be apart of it. This 2 story home was completed in 2020 has a very inviting foyer. It features stainless steel appliances, spacious granite countertops, 42 inch Birch cabinets, master vanity, master walk in closet, tankless water heater, best of all Energy Star rated. Call today schedule tour.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 27 MARLOW LAKE SEC 1B (2019) ABST 180' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marlow Lk-Sec 1b' ,`TaxAmount` = '7720' ,`TaxRate` = '3.3628' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706148' WHERE `Matrix_Unique_ID` = '211507736' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '35557998' ,`ListAgentFullName` = 'Keri Josephson' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855455' ,`Longitude` = '-95.678702' ,`PhotoCount` = '28' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenledi' ,`StreetNumber` = '18103' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4 bedroom, 2.5 bath home. This two-story gem features remodeled bathrooms, a spacious upstairs primary suite, formal dining room and large backyard with a pool! Updates within the last few years include, roof with thermal barrier, Pex water pipes, privacy fencing, bathrooms, microwave and new composite windows throughout. Easy access to I10 and the Energy Corridor. Schedule a tour today!' ,`Acres` = '0.1502' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 16 WINDSONG SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windsong Sec 03' ,`TaxAmount` = '5410' ,`TaxRate` = '2.5618' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706149' WHERE `Matrix_Unique_ID` = '211525115' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '45494291' ,`ListAgentFullName` = 'Christopher Johns' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.840459' ,`Longitude` = '-95.724636' ,`PhotoCount` = '50' ,`PostalCode` = '77449' ,`RoomCount` = '15' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Jarl' ,`StreetNumber` = '4830' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Picturesque 5 bedroom, 3.5 bath Ricewood Village home on a corner lot is ready for you to call your own! The welcoming covered porch and the two-story grand foyer give your new home a great first impression! Ideal floorplan for versatile living and easy entertaining. The large living room boasts a wall of windows and stately fireplace. The eat-in kitchen features built-in appliances, a breakfast bar, tiled backsplash, ample prep space, a pantry, and bright breakfast nook! Ideal downstairs primary suite with a spa-like bath and walk-in closet. Spacious secondary bedrooms and baths share the second floor with a media room and open game room! Elegant formal living room. You\'ll appreciate the ample storage space and built-in shelves throughout! Excellent private backyard oasis with a covered patio provides additional outdoor living and entertaining space. Recent updates include fresh paint, flooring, ceiling fans, and more! 3D tour is available online!' ,`Acres` = '0.1513' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 62 BLK 1 RICEWOOD VILLAGE SEC 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6590' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '478' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ricewood Village' ,`TaxAmount` = '7852' ,`TaxRate` = '3.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706149' WHERE `Matrix_Unique_ID` = '211545545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '19219891' ,`ListAgentFullName` = 'Deborah Withrow' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.076161' ,`Longitude` = '-95.131938' ,`PhotoCount` = '33' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Schooner' ,`StreetNumber` = '223' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW...check out this NEWLY renovated beach house! This home is gorgeous!! It even offers central HVAC and W/D connections. Recent upgrades include: all flooring, paint inside and out, new appliances, granite kitchen counters, backsplash, new cabinets and bath vanities, new shower tile and glass shower doors (coming soon), new doors, windows, hardware, fixtures and ceiling fans...also brand new HVAC equipment and so much more. There are 2 boat slips and a fish cleaning station. The adjacent lot can be used for many purposes...build another home for short term rental, add a pool or use the space for fun entertainment. It\'s up to you. So many possibilities.\r\nThe lot next door is also available if you want more space.' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND NO 2 (A0029 S F AUSTIN), BLOCK 3, LOT 45' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6001' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Treasure Island Sub Sec 2' ,`TaxAmount` = '6623' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706149' WHERE `Matrix_Unique_ID` = '211556584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '20984860' ,`ListAgentFullName` = 'Eric Ruple' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.481479' ,`Longitude` = '-95.528337' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '730000.00' ,`Status` = 'Active' ,`StreetName` = 'Marble Hill' ,`StreetNumber` = '2511' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Home in a prestigious community! Step past the lush landscaping & covered front porch, and enter a sprawling open floorplan graced with soaring ceilings, intricate crown molding, large windows & gorgeous floors, plus NO CARPET & 2 TANKLESS HOT WATER HEATERS! The gourmet kitchen boasts a large kitchen island with breakfast bar, glass upper cabinets for displaying your favorite treasures, a wine rack & cooler, walkin pantry, and a plethora of additional storage. Work from home in the executive home office, or entertain guests in either the game room or media room. The luxurious primary suite will keep you feeling right at home, featuring a large walk-in shower, separate tub, massive closet & a cozy bay window seating area in the bedroom. Enjoy a backyard barbecue this summer, using the large covered patio with a built-in kitchen station, or take advantage of fun community amenities like a water park & clubhouse. Builder:Coventry' ,`Acres` = '0.2393' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF DESTREHAN SEC 7B, BLOCK 5, LOT 11' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10426' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Sienna Village Of Destrehan Sec 7b' ,`TaxAmount` = '16416' ,`TaxRate` = '3.1629' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706149' WHERE `Matrix_Unique_ID` = '211590518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '18485719' ,`ListAgentFullName` = 'Michael Callihan' ,`ListOfficeName` = 'Riverway Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802764' ,`Longitude` = '-95.503116' ,`PhotoCount` = '12' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '749999.00' ,`Status` = 'Active' ,`StreetName` = 'Ojeman Creek' ,`StreetNumber` = '8704' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW First floor living with a huge yard Riverway Homes in Spring Valley Point - conveniently located minutes away from Highway I-10 and zoned to highly desirable Valley Oaks Elementary, Spring Branch Middle, and Memorial High School. This gorgeous Alisa floor-plan has an open concept floor plan with high ceilings and generously sized rooms with tons of natural light. Enjoy the contemporary designer finishes throughout; such as hard surface flooring in all of the main areas, wooden staircase treads with iron balusters, quartz countertops, modern cabinetry, upgraded light fixtures, and many more. This 4 bedroom, 3.5 bath home also includes a finished backyard with a covered patio. Built with Energy Efficient features throughout; including stainless steel kitchen appliances and a tankless water heater. Schedule your tour today!' ,`Acres` = '0.0702' ,`Area` = '24' ,`BuilderName` = 'Riverway Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 5 SPRING VALLEY POINT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Valley Point' ,`TaxAmount` = '5304' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706149' WHERE `Matrix_Unique_ID` = '211602679' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '66817872' ,`ListAgentFullName` = 'Melissa Morales' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.580364' ,`Longitude` = '-95.197193' ,`PhotoCount` = '43' ,`PostalCode` = '77089' ,`RoomCount` = '12' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Packard Bend' ,`StreetNumber` = '12402' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely home in College Park with NO BACK NEIGHBORS! This two-story home features a formal dining room with wood floors that stretch into the living room featuring a fireplace and lots of natural light. Kitchen has granite counters, plenty of cabinet and counter space, and lots of natural light! Downstairs primary bedroom showcases dual sinks and is private from the secondary bedrooms which are located upstairs. Upstairs also has a spacious game room! Two more secondary bedrooms share a bath. Gorgeous and easy to maintain wood floors throughout living areas and bedrooms - no carpet! Backyard is fully fenced with a covered patio, extended patio slab, and lots of green space. Home has no back neighbors and a walking trail starts right next to the house! Enjoy all the community amenities including a lake with a walking trail just across the street.' ,`Acres` = '0.1269' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 COLLEGE PLACE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5527' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'NORTH POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'College Place' ,`TaxAmount` = '7162' ,`TaxRate` = '2.6399' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706149' WHERE `Matrix_Unique_ID` = '211620096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '57719125' ,`ListAgentFullName` = 'Linda Coursey' ,`ListOfficeName` = 'Sky Real Estate Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019697' ,`Longitude` = '-95.628237' ,`PhotoCount` = '31' ,`PostalCode` = '77377' ,`RoomCount` = '5' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Ambrose Reach' ,`StreetNumber` = '13035' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful cul-de-sac lot. Primary suite down with three additional rooms and two FULL baths upstairs along with game room. Light and Bright with 2 \" blinds throughout. Kitchen with granite counters and tile. Large backyard with covered patio. Refrig & Washer and Dryer negoitable.' ,`Acres` = '0.1606' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Other Disclosures,Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 WILDWOOD AT NORTHPOINTE SEC 14' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood at Northpointe' ,`TaxAmount` = '9041' ,`TaxRate` = '3.0564' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706150' WHERE `Matrix_Unique_ID` = '211650834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '56232760' ,`ListAgentFullName` = 'Cody Scurlock' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688582' ,`Longitude` = '-95.148039' ,`PhotoCount` = '20' ,`PostalCode` = '77503' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'War Admiral' ,`StreetNumber` = '4123' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one-story 3-bedroom home that offers tons of room! The home offers an open floor plan with the updated custom kitchen open to the roomy living room with a fireplace. Off to the corner is a breakfast room or you can use it as a formal dining room, or office! The home also offers a roomy back yard with a large covered back porch, no back neighbors, and a storage shed! A new condenser unit was added as well. Don\'t miss out on this wonderful home!' ,`Acres` = '0.1978' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 BOWLING GREEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'CARPENTER ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bowling Green Sec 01' ,`TaxAmount` = '4994' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706150' WHERE `Matrix_Unique_ID` = '211678556' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '4068381' ,`ListAgentFullName` = 'Vivian Rodriguez' ,`ListOfficeName` = 'Texas Made Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.921334' ,`Longitude` = '-95.679309' ,`PhotoCount` = '24' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Horsetooth Canyon' ,`StreetNumber` = '17226' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in a serene gated community in Stonegate. Gated with 24 hour security. Beautiful single family home on highly sought after lakefront lot. The home has 3 bedroom 2 bathroom and 2 car garage. The primary bathroom has a therapeutic walk in tub. Freshly painted in kitchen and dinning area. This home has stunning water view from your own backyard. Community amenities galore: pool, splash pad, playground, tennis court plus Golf. This is a must see !!' ,`Acres` = '0.1515' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 75 BLK 1 CANYON LAKES AT STONEGATE SEC 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes At Stonegate 01' ,`TaxAmount` = '5397' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706150' WHERE `Matrix_Unique_ID` = '211692381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '94805148' ,`ListAgentFullName` = 'Carrie Farmer' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511596' ,`Longitude` = '-95.824610' ,`PhotoCount` = '50' ,`PostalCode` = '77471' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverhorn' ,`StreetNumber` = '2902' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 story 4 bedroom, 2.5 bath home with a large open concept kitchen and family room. The master bedroom welcomes you a large ensuite bathroom and upstairs has a large game room perfect for kids or entertaining!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Foxwood Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Fairpark Village Sec 10, BLOCK 4, Lot 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '533' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairpark Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706150' WHERE `Matrix_Unique_ID` = '211727087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '71526079' ,`ListAgentFullName` = 'Melissa Morales' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289260' ,`Longitude` = '-94.797727' ,`PhotoCount` = '29' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue P 1/2' ,`StreetNumber` = '3016' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous French-style home with charming details throughout! Fall in love with the large front porch, a perfect home for rocking chairs and a great place to enjoy morning coffee. Inside, arched doorways and crown molding throughout give warmth and charm. The front living room has a fireplace while the other front room, currently used as a dining room, would also make a great office! The kitchen has stylish shiplap walls and a spacious island with quartz counters. Vinyl plank floors throughout - NO CARPET! Downstairs utility room and full bath including a walk-in shower and glass bowl sink on the vanity. All bedrooms upstairs include 3 spacious rooms and a bath with a gorgeous custom-tiled shower! Don\'t miss the backyard with lovely mature trees, slate tile back patio, and an area with a covered pavilion and large slab, perfect for entertaining! Just minutes to the historic Pleasure Pier, shopping, dining, and, of course, the beach! Home has never flooded' ,`Acres` = '0.1179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 11 NW BLK 89 GALVESTON OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5302' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706150' WHERE `Matrix_Unique_ID` = '211771408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '75935796' ,`ListAgentFullName` = 'Ana Patricia Torres' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940695' ,`Longitude` = '-95.221387' ,`PhotoCount` = '26' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Sun River Falls' ,`StreetNumber` = '11023' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2183' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Beautiful, 2 Story Home!!!\r\nThis Home Features a 3 bedroom, 3 full bath with a study room that can be converted into a 4th bedroom on the first floor. The large family room over looks the kitchen and comfortable breakfast area. The master suite is on the second floor with a large master bath and walk in closet. The other two bedrooms share a full bath adjacent to the stair way. The utility room is conveniently located next to the master suite. call me to schedule a private Showing.' ,`Acres` = '0.1181' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 SUNSET RIDGE WEST SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5146' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Rdg West Sec 7' ,`TaxAmount` = '6651' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706150' WHERE `Matrix_Unique_ID` = '211791908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '20896023' ,`ListAgentFullName` = 'Christy Kovacs' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773228' ,`Longitude` = '-95.421231' ,`PhotoCount` = '46' ,`PostalCode` = '77007' ,`RoomCount` = '14' ,`ListPrice` = '779999.00' ,`Status` = 'Active' ,`StreetName` = 'Knox' ,`StreetNumber` = '1403' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning 4-bedroom 4 story home is located in the Rice Military area within walking distance to Washington Ave where there are tons of to do, near downtown & Galleria area. \r\nEach bedroom has its own bathroom, perfect if you are looking to split this with roommates. \r\nThere is a 2-car garage & additional parking in front of the home. \r\nSpacious floor plan with engineered wood flooring, high ceilings throughout the home. 2 different balconies that provide a beautiful view of the city. \r\nHome stands higher than the other homes around so no other home is blocking the view.\r\n1st floor has 1st bedroom. 2nd floor provides an open kitchen area that flows into the dining & living area also has a dry bar. The first balcony is next to the kitchen. 3rd floor has primary suite, another bedroom & utility room. 4th floor has another living area or game room, wet bar, office area, the 4th bedroom and a large balcony to relax on and enjoy the scenery. Bonus is this has a fully fenced backyard.' ,`Acres` = '0.0574' ,`Area` = '16' ,`BuilderName` = 'Keystone Classic Hm' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 5 WOODCREST' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern,Split Level' ,`Subdivision` = 'Woodcrest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706150' WHERE `Matrix_Unique_ID` = '211806105' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '86447099' ,`ListAgentFullName` = 'Cindy Ochsner' ,`ListOfficeName` = 'Cinderella Real Estate' ,`SellingAgentFullName` = 'Teresa Solache' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '29.889979' ,`Longitude` = '-95.698445' ,`PhotoCount` = '23' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '308000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Prairie Bluff' ,`StreetNumber` = '19031' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This fabulous home in the family friendly community of Yaupon Ranch awaits its new owners. This 4 bedroom, 2.5 bath home would be perfect for. Home features an open concept living, kitchen, & dining room; along with a huge master bedroom with ensuite bath, laundry room, half bath, and office space on the first floor. The kitchen has been updated with stainless steel appliances, quartz countertops, subway tile back splash, and new paint. Upstairs you will find 3 spacious bedrooms, a full bath with shower/tub combo, and huge game room for entertaining. Conveniently located close to premier shopping and dining including Houston Premium Outlets and the Towne Lake Boardwalk. Only a short drive to HWY 290, HWY 99, I-10. You won\'t want to miss this great opportunity to call this your new home!' ,`Acres` = '0.1272' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 3 YAUPON RANCH SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Ranch Sec 03' ,`TaxAmount` = '6890' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706151' WHERE `Matrix_Unique_ID` = '211817682' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T01:22:00.380' ,`MLSNumber` = '68815722' ,`ListAgentFullName` = 'Christa Burgess' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741637' ,`Longitude` = '-95.765144' ,`PhotoCount` = '50' ,`PostalCode` = '77450' ,`RoomCount` = '12' ,`ListPrice` = '865000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Shore' ,`StreetNumber` = '2911' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gated community, Custom home, 5 beds, 3.5 baths, 2 car garage, gated driveway, pool/spa, fitness room, media room with furniture and audio-video equipment to stay, large Gameroom, library/computer room, primary suite with study and double-sided fireplace, dual closets and sinks, separate shower and tub in primary bath. Two living areas with a double-sided gas log fireplace. Large open kitchen with double ovens, gas cooktop, lots of storage, mud room with built-in lockers, outdoor covered patio with area for dining and outdoor grill, pool and spa with fountain, volleyball net, pool basketball, storage building behind the home. LOW Taxes! No Flooding! Desirable South Lake Landing, gated community of award-winning community of Cinco Ranch. Zoned to Williams Elem/Beck Jr/Cinco Ranch HS, located on hike/bike trails, stocked ponds, tennis, golf, pools, sports fields, frisbee golf, near shopping and dining, and easy access to I-10 or Westpark Tollway and The Houston Energy Corridor.' ,`Acres` = '0.2265' ,`Area` = '36' ,`BuilderName` = 'Custom Classics' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH SOUTH LAKE VILLAGE SEC 2, BLOCK 1, LOT 45' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9867' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch' ,`TaxAmount` = '13947' ,`TaxRate` = '2.4395' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706151' WHERE `Matrix_Unique_ID` = '211842140' --> Updated record success