Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:46:44.110' ,`MLSNumber` = '80330477' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.325145' ,`Longitude` = '-95.438323' ,`PhotoCount` = '35' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '308000.00' ,`Status` = 'Active' ,`StreetName` = 'Cecilia Vines' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the quiet community of Venetian Pines, this beautiful 1 story has it all! This spacious home includes 4 Bed and 2Bath and the open- concept design of the kitchen, dining and great room is ideal for hosting gatherings and entertaining family and friends. The chef of the family will adore the gourmet kitchen equipped with a walk-in pantry, ample of cabinet and counterspace and its GE stainless steel appliances. Escape to your luxury Owner’s Retreat with its spa like bathroom, complete with dual vanities, a large built in garden tub, separate stand-up shower with bench and an oversized walk-in closet.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5325' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Venetian Pines' ,`TaxAmount` = '' ,`TaxRate` = '3.1' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '199215852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:33:08.127' ,`MLSNumber` = '47136591' ,`ListAgentFullName` = 'Jonathan Denissen' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = 'Jonathan Denissen' ,`SellingOfficeName` = 'FYI Realty' ,`Latitude` = '29.890688' ,`Longitude` = '-95.740517' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '334950.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tuscan Cypress' ,`StreetNumber` = '7926' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction 2 Story Saratoga Home, the Laurel, located in the new community Cypress Oaks North. Home has 4 bedrooms, with 2 Suites both with ensuite, 3.5 Bathrooms and a 2 Car Garage. Owner Suite is located downstairs all other bedrooms are located upstairs. Large Gameroom upstairs. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Owner Suite complete with double sinks. Home to be complete in December' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Oaks North' ,`TaxAmount` = '' ,`TaxRate` = '3.516' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '199463161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:32:35.620' ,`MLSNumber` = '20609458' ,`ListAgentFullName` = 'Jonathan Denissen' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = 'Jonathan Denissen' ,`SellingOfficeName` = 'FYI Realty' ,`Latitude` = '29.890600' ,`Longitude` = '-95.740484' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '314950.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tuscan Cypress' ,`StreetNumber` = '7922' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction 2 Story Saratoga Home, The Belle Vue, located in the new community Cypress Oaks North. Home has 4 bedrooms, with 2 Primary Suites both with ensuite, 3.5 Bathrooms and a 2 Car Garage. All bedrooms are located upstairs. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Owner Suite complete with double sinks. Home to be complete in December' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Oaks North' ,`TaxAmount` = '' ,`TaxRate` = '3.516' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '199476281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:33:39.763' ,`MLSNumber` = '54468517' ,`ListAgentFullName` = 'Jonathan Denissen' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = 'Jonathan Denissen' ,`SellingOfficeName` = 'FYI Realty' ,`Latitude` = '29.890545' ,`Longitude` = '-95.740494' ,`PhotoCount` = '5' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '324950.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tuscan Cypress' ,`StreetNumber` = '7918' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Construction 2 Story Saratoga Home, The Willow, located in the new community Cypress Oaks North. Home has 4 bedrooms, with 2 Primary Suites both with ensuite, 3.5 Bathrooms and a 2 Car Garage. All bedrooms are located upstairs. Home has an open floor plan perfect for entertaining. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Owner Suite complete with double sinks. Home to be complete in December' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Oaks North' ,`TaxAmount` = '' ,`TaxRate` = '3.516' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '199477784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:34:31.667' ,`MLSNumber` = '53437253' ,`ListAgentFullName` = 'Amanda Lee' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602899' ,`Longitude` = '-95.484110' ,`PhotoCount` = '9' ,`PostalCode` = '77489' ,`RoomCount` = '3' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Ridge' ,`StreetNumber` = '6526' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with easy access to downtown Houston and Hobby airport. Oversized corner lot. Well maintained yard.' ,`Acres` = '0.163' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BRIARGATE SEC 9, BLOCK 2, LOT 36' ,`LotDesciption` = 'Corner' ,`LotSize` = '7100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargate Sec 9' ,`TaxAmount` = '3428' ,`TaxRate` = '2.2552' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '201241818' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:12:42.007' ,`MLSNumber` = '15509592' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845175' ,`Longitude` = '-95.817231' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '424995.00' ,`Status` = 'Active' ,`StreetName` = 'Dunston Manor' ,`StreetNumber` = '4602' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2478' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Incredible KB Home in Katy Manor has it all, boasting a brick front, extended entry, and open great room. Cook up new cuisines in the kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds, automatic sprinklers, and an extended covered patio. Katy Manor boasts a splash pad, park, and playground. The community is located near I-10 and the Grand Parkway, giving residents easy access to the Energy Corridor. Enjoy dining, shopping, and entertainment at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Schools are zoned to the highly-acclaimed Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '206613925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:02:20.537' ,`MLSNumber` = '38921419' ,`ListAgentFullName` = 'Judy Hudson' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.383719' ,`Longitude` = '-95.676808' ,`PhotoCount` = '32' ,`PostalCode` = '77316' ,`RoomCount` = '8' ,`ListPrice` = '549500.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2854' ,`StreetNumber` = '22530' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a ranch style home with park like setting. This is it. Enjoy evenings on the covered front and back porches. Large family room adjacent to the dining room and kitchen. Primary bedroom with primary bath with shower. Two walk-in closets. Split floor plan with secondary bedrooms and second bath. Over sized garage with large storage room off garage with access to large attic. Beautiful trees and landscaping. Big BARN for all your toys or tractor. MISD schools. Easy access to Houston or College Station. Don\'t miss this one!' ,`Acres` = '2.0239' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S573500 - HAVENSHIRE, BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '88161' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Havenshire' ,`TaxAmount` = '5338' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '207012789' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:19:23.523' ,`MLSNumber` = '82714246' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215450' ,`Longitude` = '-95.762782' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '336812.00' ,`Status` = 'Active' ,`StreetName` = 'Coyote Canyon' ,`StreetNumber` = '605' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** Find total comfort in this incredible KB Home in Mustang Ridge, boasting a brick front, wrought iron spindles, a game room, and an open great room. Create new recipes in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, 42-in. cabinets, and undercabinet lighting. The spa-like primary suite features extended dual vanities and a shower with a Moen Gibson® WaterSense Showerhead. Additional home features include cable pre-wiring and an extended patio. Community comforts include a park, playground, and pavilion. Situated near Hwy. 249, residents have quick access to major employment areas in Conroe, The Woodlands, Tomball, and Downtown Houston. Popular shopping, dining, and entertainment are a short drive away. Schools in the area are zoned to the Magnolia ISD.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mustang Ridge' ,`TaxAmount` = '' ,`TaxRate` = '3.303' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702543' WHERE `Matrix_Unique_ID` = '207376229' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:09:56.867' ,`MLSNumber` = '77532472' ,`ListAgentFullName` = 'Jessica Castillo' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727172' ,`Longitude` = '-95.326975' ,`PhotoCount` = '14' ,`PostalCode` = '77023' ,`RoomCount` = '4' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Lawson' ,`StreetNumber` = '1537' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Calling all investors! Fixer upper in EaDo for sale. Main house has 3 bedrooms 1 bathroom. High ceilings and spacious rooms. Second potential income is garage apartment with 1 bedroom and 1 bathroom. Large lot.' ,`Acres` = '0.1435' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 6 BROADMOOR' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CAGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Broadmoor' ,`TaxAmount` = '3785' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '207913661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:45:05.053' ,`MLSNumber` = '24625735' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795273' ,`Longitude` = '-96.169582' ,`PhotoCount` = '9' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '351900.00' ,`Status` = 'Active' ,`StreetName` = 'Buckhorn' ,`StreetNumber` = '522' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Craftsman 3 bedroom, 2 bath open-concept design includes a large kitchen with granite counter-tops and SS appliances. Kitchen opens onto the dining room and family room with hard-wood floors and tons of windows to let in the natural light. Spacious utility room and Mud area. The master suite includes an oversized master closet with separate master shower. The secondary bedrooms are spacious and each has its own walk-in closet. And don’t forget the large covered patio where you can relax and enjoy the fresh country breeze. ***All measurements must be verified.***' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '****' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 2, Hunters Crossing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '208264070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:34:18.640' ,`MLSNumber` = '71454207' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795273' ,`Longitude` = '-96.169582' ,`PhotoCount` = '9' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '349500.00' ,`Status` = 'Active' ,`StreetName` = 'Still Water Ridge' ,`StreetNumber` = '517' ,`StreetSuffix` = 'Lane' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely 3 bedroom, 2 bath open-concept design includes a large kitchen with granite counter-tops and SS appliances. Kitchen opens onto the dining room and family room with hard-wood floors and tons of windows to let in the natural light. Spacious utility room and Mud area. The master suite includes an oversized master closet with separate master shower. The secondary bedrooms are spacious and each has its own walk-in closet. And don’t forget the large covered patio where you can relax and enjoy the fresh country breeze. **All measurements must be verified.**' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '****' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 3 Hunters Crossing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '208266505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:48:55.583' ,`MLSNumber` = '9542577' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795818' ,`Longitude` = '-96.170042' ,`PhotoCount` = '9' ,`PostalCode` = '77474' ,`RoomCount` = '8' ,`ListPrice` = '434700.00' ,`Status` = 'Active' ,`StreetName` = 'Buckhorn' ,`StreetNumber` = '526' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Hunters Crossing! This 4 bedroom 3 1/2 bath, includes a spacious kitchen with granite counter-tops and stainless steel appliances. Wood floors in family, kitchen and dining. The master suite includes an oversized shower and master closet. Game Room and secondary bedrooms are spacious. Don\'t forget the large covered patio where you can relax and enjoy the fresh country breeze! Walking distance to Sealy Elementary School. (Room measurements to be verified by buyer.) Zoned to Sealy Elementary.' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '0000' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 2, Hunters Crossing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '208268383' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:06:09.337' ,`MLSNumber` = '72913946' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795506' ,`Longitude` = '-96.169725' ,`PhotoCount` = '11' ,`PostalCode` = '77474' ,`RoomCount` = '9' ,`ListPrice` = '454800.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Crossing' ,`StreetNumber` = '439' ,`StreetSuffix` = 'Drive' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Hunters Crossing! This brick & stone 4 bedroom, 3 1/2 bath with study and game room, includes a spacious kitchen with granite counter-tops and stainless steel appliances. Wood floors in family, kitchen and dining. Secondary bedrooms are spacious and each has its own walk-in closet. Three-car tandem garage. Don\'t forget the large covered patio where you can relax and enjoy the fresh country breeze! (Room measurements to be verified by buyer.) Zoned to Sealy Elementary.' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '*****' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '208270924' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:13:47.027' ,`MLSNumber` = '5837932' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795506' ,`Longitude` = '-96.169725' ,`PhotoCount` = '11' ,`PostalCode` = '77474' ,`RoomCount` = '9' ,`ListPrice` = '460300.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Grove' ,`StreetNumber` = '501' ,`StreetSuffix` = 'Lane' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Hunters Crossing! This fully bricked 4 bedroom, 3 1/2 bath with study and game room, includes a spacious kitchen with granite counter-tops and stainless steel appliances. Wood floors in family, kitchen and dining. Secondary bedrooms are spacious and each has its own walk-in closet. Three-car tandem garage. Don\'t forget the large covered patio where you can relax and enjoy the fresh country breeze! (Room measurements to be verified by buyer.) Zoned to Sealy Elementary.' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '*****' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18, Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '208271202' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:10:44.060' ,`MLSNumber` = '55769086' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996743' ,`Longitude` = '-95.504097' ,`PhotoCount` = '7' ,`PostalCode` = '77068' ,`RoomCount` = '12' ,`ListPrice` = '376689.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Palmetto' ,`StreetNumber` = '4014' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction** You don’t want to miss this incredible KB Home in Cypress Creek Landing, boasting a brick front, tile flooring, and an open great room. Dream up culinary masterpieces in the kitchen, boasting granite countertops, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds, full gutters, and an extended covered patio. The Cypress Creek Landing community is located near Hwy 249 and I-45, giving residents convenient access to Downtown Houston. Schools are zoned to the highly-rated Spring Independent School District.' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.459' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '208580964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:12:59.337' ,`MLSNumber` = '32657964' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946516' ,`Longitude` = '-95.179644' ,`PhotoCount` = '8' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '309995.00' ,`Status` = 'Active' ,`StreetName` = 'Birchdale' ,`StreetNumber` = '15519' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This gorgeous KB Home in the Lakewood Pines community boasts a brick front, extended entry, and open great room. Entertain guests in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel Energy Star® appliances, and 42-in. cabinets. The spa-like primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. Additional home features include faux wood blinds, full gutters, and an extended covered patio. The desirable community of Lakewood Pines offers residents access to a pool, park, and recreation center. Commuters enjoy convenient access to the Houston Ship Channel and Generation Park via the Sam Houston Tollway. Nearby schools are zoned to the highly-rated Humble ISD.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '732' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Pines' ,`TaxAmount` = '' ,`TaxRate` = '3.454' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702544' WHERE `Matrix_Unique_ID` = '208984663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:41:47.143' ,`MLSNumber` = '22449548' ,`ListAgentFullName` = 'Marisol Diaz' ,`ListOfficeName` = 'Greg Flaniken & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.075612' ,`Longitude` = '-95.415057' ,`PhotoCount` = '39' ,`PostalCode` = '77531' ,`RoomCount` = '8' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Hollychase' ,`StreetNumber` = '40' ,`StreetSuffix` = 'Street' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country feel with city access. Recently renovated 3/2 with over-sized detached garage on .689 of an acre lot. Home features granite countertops in kitchen and bathrooms, new carpet in bedrooms, new laminate flooring throughout, and freshly painted in neutral colors. There is also two sheds in the back of the property, 12x24 and 10x17 which are perfect for additional storage or crafting space. Utility room is also attached to the home with additional space and attached covered porch. The oversized garage has a workshop area in the rear with work tables and plenty of shelving. HVAC installed in 2/2022. Schedule your appointment today.' ,`Acres` = '0.689' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Richwood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SHERWOOD FOREST (A0066 J E GROCE), BLOCK 4, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Forest' ,`TaxAmount` = '2672' ,`TaxRate` = '1.9981' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702545' WHERE `Matrix_Unique_ID` = '209412268' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:10:04.013' ,`MLSNumber` = '82416167' ,`ListAgentFullName` = 'Jessica Rushing' ,`ListOfficeName` = 'Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.421487' ,`Longitude` = '-95.575255' ,`PhotoCount` = '49' ,`PostalCode` = '77318' ,`RoomCount` = '15' ,`ListPrice` = '624000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Vista' ,`StreetNumber` = '12345' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one of a kind modern 2.5 story home w/serene partial views of the lake on every level. NEW AC 8/12/22. Full sprinkler sys. This home is waiting for your family and grand entertaining w/circle drive. The garage has a 1st level flex space w/a full bathrm & kitchenette for guests or could be the workshop/studio you\'ve been hunting for. Full apartment w/partial lake views, 2 bdrms, 1 full bath & full kitchen w/electric stove hook ups above garage. Main home has an incredible first floor library/home office w/full bath, utility room, game room/2nd living room & access to back patio. 2nd floor offers high ceilings, family room, open to the updated kitchen w/2 dishwashers, island cooking & seating, covered balcony, updated bathrm, two bedrms, recent wood flooring, and paint. 3rd floor offers a dreamy true private primary suite w/a completely remodeled bathroom & walk in closet. Enjoy the view of the lake and the stars on the primary suite balcony. MORE INFO ON PHOTOS' ,`Acres` = '0.4796' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POINT AQUARIUS 07, BLOCK 3, LOT 11' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View,Wooded' ,`LotSize` = '20893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Point Aquarius' ,`TaxAmount` = '6692' ,`TaxRate` = '2.2748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702545' WHERE `Matrix_Unique_ID` = '209462910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:47:06.560' ,`MLSNumber` = '88083203' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.325145' ,`Longitude` = '-95.438323' ,`PhotoCount` = '3' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '301000.00' ,`Status` = 'Active' ,`StreetName` = 'Alex Arbor' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully designed Hansford plan is one of the newest plans we offer in Venetian Pines. This one story 1520sqft home accommodates 3 bedrooms, 2 bathrooms, a flex space and a covered back patio. Feel drawn into the Kitchen, Dining room and Great Room as the many windows illuminate this open concept area. Tucked in the back of the home is a flex space that is a perfect for an in home office, play area or an at home gym. The owners retreat accommodates queen size furniture, has dual vanity a walk in closet and a large stand up shower. Venetian Pines is a small and quite community nestled on the East side of Conroe giving you a country feel close to town.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Venetian Pines' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702545' WHERE `Matrix_Unique_ID` = '209632620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:47:24.153' ,`MLSNumber` = '83089926' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.325145' ,`Longitude` = '-95.438323' ,`PhotoCount` = '3' ,`PostalCode` = '77303' ,`RoomCount` = '9' ,`ListPrice` = '356000.00' ,`Status` = 'Active' ,`StreetName` = 'Alex Arbor' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1983' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Empire Communities welcomes you to the Glenwood plan. All within 1,983 sq ft the home includes 3 Beds, 2 1\\2 Baths, and a giant bonus room. Walking into the foyer as it introduces you to the light and bright open concept Kitchen, Dining, and Great Room. The eat-in kitchen includes an island, quartz countertops, a full backsplash, stainless steel appliances, and an abundant amount of cabinetry with a beautiful light color palette. Our spacious owner\'s retreat accommodates king-size furniture, a walk-in closet, dual vanities, and a built-in garden tub with a separate stand-up shower. The private fenced-in backyard and its large covered patio including a gas stub are perfect for entertaining. Venetian Pines is located in Conroe close to town while still offering country vibes. Come out today for a tour.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Venetian Pines' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702545' WHERE `Matrix_Unique_ID` = '209632964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:54:40.957' ,`MLSNumber` = '55472119' ,`ListAgentFullName` = 'Ashley Day' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801526' ,`Longitude` = '-95.393081' ,`PhotoCount` = '47' ,`PostalCode` = '77008' ,`RoomCount` = '10' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'Columbia' ,`StreetNumber` = '1644' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled and Expanded Historic bungalow on premier block in Houston Heights. Fabulous open floor plan downstairs features beautiful hardwood floors and gorgeous windows. Chef and entertainer\'s kitchen wows with over-sized granite island, custom cabinetry, wine fridge, and double oven. 4th Bedroom or Office downstairs features en suite Full Bath with walk in shower that also serves as powder room. Upstairs, relax in dynamite Primary Suite and Bath with his and her closets. Bonus room upstairs features wet bar. 2 Secondary Bedrooms upstairs feature natural light and walk in closets. Amazing Storage throughout. Low maintenance yard with built in summer kitchen and covered patio. Alley access to secure automated gate, leading to over-sized 2 car garage with epoxy flooring. Walkable to favorite Heights hotspots, including iconic 19th Street, Chiloso\'s, Jenni\'s Noodle House, the Jogging Trail, and Heights Hike and Bike Trail. Zoned to Field Elementary, National Blue Ribbon winner.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 113 HOUSTON HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'HOUSTON HEIGHTS' ,`TaxAmount` = '12974' ,`TaxRate` = '2.55896' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702545' WHERE `Matrix_Unique_ID` = '209865337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:30:37.187' ,`MLSNumber` = '33667033' ,`ListAgentFullName` = 'Pamela Rencurel' ,`ListOfficeName` = 'Kenyson Roane Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692109' ,`Longitude` = '-95.540263' ,`PhotoCount` = '11' ,`PostalCode` = '77036' ,`RoomCount` = '9' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Concho' ,`StreetNumber` = '8827' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing well-maintained single-story ranch in the heart of it all. Beautiful mature trees add to the character of this jewel. This four bedroom two bath with a detached garage is ready for your updates. The spacious floor plan and extra-large bedrooms and easy commute are a few of the great features. Come see it today!' ,`Acres` = '0.1916' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 58 SHARPSTOWN COUNTRY CLUB TERRACE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Sharpstown Country Club Terrac' ,`TaxAmount` = '5016' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702545' WHERE `Matrix_Unique_ID` = '209930592' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:12:22.693' ,`MLSNumber` = '72175865' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843846' ,`Longitude` = '-95.811555' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '421650.00' ,`Status` = 'Active' ,`StreetName` = 'Moreleigh' ,`StreetNumber` = '25606' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**home is under construction.** Feel at ease in this charming KB Home in Katy Manor South, boasting a brick front, vinyl plank flooring, and an open great room. Create new recipes in the kitchen, equipped with Silestone countertops, stainless steel Energy Star® appliances, 42-in. cabinets, and pendant lighting. Take a well-deserved break in the primary suite, featuring extended dual vanities and a shower with a Moen Gibson® WaterSense Showerhead. Additional home features include faux wood blinds and full gutters. The peaceful Katy Manor South community provides a splash pad, park, and playground. Situated near I-10 and the Grand Parkway, residents enjoy easy access to the Katy Mills Mall and the Energy Corridor. Zoned to the highly-acclaimed Katy ISD.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor' ,`TaxAmount` = '' ,`TaxRate` = '3.556' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702545' WHERE `Matrix_Unique_ID` = '210557207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:27:23.143' ,`MLSNumber` = '70447929' ,`ListAgentFullName` = 'Alfredo Cavazos' ,`ListOfficeName` = 'Cavazos Realty International' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.393033' ,`Longitude` = '-95.138626' ,`PhotoCount` = '15' ,`PostalCode` = '77517' ,`RoomCount` = '4' ,`ListPrice` = '175500.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Glory' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Drive' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for a spacious home with spacious land ready for immediate move-in in Santa Fe? Look no further! Come enjoy this updated beauty with recent carpet, flooring, roof and freshly paint throughout. This unique property is waiting for you to make it your home. Come relax on the large and welcoming front porch. There is also a large workshop/garage in the back with endless possibilities!' ,`Acres` = '0.4981' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 613 PAGE 6 LOT 2 MORNING GLORY UNRECORDED SUB MH MAGNOL' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '21696' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Morning Glory Unrec' ,`TaxAmount` = '659' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702546' WHERE `Matrix_Unique_ID` = '210689287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:45:42.180' ,`MLSNumber` = '3631100' ,`ListAgentFullName` = 'Sue Cornell' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.035313' ,`Longitude` = '-95.430982' ,`PhotoCount` = '14' ,`PostalCode` = '77566' ,`RoomCount` = '4' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Center Way' ,`StreetNumber` = '618' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1292' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This precious one story, one owner home offers a newly renovated kitchen with shiny new granite and beautiful white cabinets accented with brushed bronze hardware. The kitchen, which is open to the eating and den area, offers a large window that affords lots of natural light. In addition to the three bedrooms with hardwood floors, the living room could be used as a fourth bedroom if desired. There is a large, extra driveway perfect for a boat or parking. The covered porch overlooks the fenced back yard and storge area that features a canopy that\'s perfect for outdoor cookouts. Come take a look at this cutie located one street over from school.' ,`Acres` = '0.2238' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH PARKWOOD (LAKE JACKSON), BLOCK 3, LOT 9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Parkwood Lake Jackson' ,`TaxAmount` = '3239' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702546' WHERE `Matrix_Unique_ID` = '210787189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:59:57.800' ,`MLSNumber` = '5762110' ,`ListAgentFullName` = 'Kristy Salas' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Brittany Melton' ,`SellingOfficeName` = 'Home Sweet Home RE Group' ,`Latitude` = '30.034008' ,`Longitude` = '-95.796392' ,`PhotoCount` = '30' ,`PostalCode` = '77447' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Prairie Dust' ,`StreetNumber` = '24031' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1539' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new 3 bedroom, 2 bath home + study, with all the amenities you\'re looking for. This open floor plan is sure to impress the pickiest buyers. Kitchen comes equipped with upgraded granite counters, upgraded cabinetry, premium appliance package, ample storage and an island breakfast bar. 9\' ceilings make this one story feel larger than it is. Primary bedroom retreat incudes walk in closet, bathroom with dual vanities and a large primary shower. If all of this wasn\'t enough, enjoy this premium lot that\'s one of the largest in the neighborhood. The sky is the limit in the expansive backyard! Don\'t miss out on what could be your next home!' ,`Acres` = '0.1873' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 4 WINDROW SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8158' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windrow' ,`TaxAmount` = '6915' ,`TaxRate` = '3.5256' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702546' WHERE `Matrix_Unique_ID` = '210871747' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:18:08.037' ,`MLSNumber` = '68526647' ,`ListAgentFullName` = 'Christopher Phan' ,`ListOfficeName` = 'Truss Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.854241' ,`Longitude` = '-95.421025' ,`PhotoCount` = '14' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Rachel' ,`StreetNumber` = '864' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1575' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Aspire Homes unveils the Rachel Heights project located in Acres Homes, one of Houston\'s rapidly growing communities surrounding the inner loop. This is a 14 unit gated modern farmhouse community that has been professionally designed from interior to exterior. These homes are 3 bedrooms and 2.5 bath with a private balcony in the primary bedroom and also including a private backyard. The first floor is an open area concept design with a spacious quartz island countertop and wrap around kitchen that overlooks the dining and living area. The second floor features all bedrooms up with a flex loft for work or play. The primary bedroom is deluxe size with a sitting area and high ceilings. The primary ensuite comes standard with designer selections, dual sinks, frameless shower, an elegant stand alone tub with spacious walk in closet. Early buyers can choose from 2 professionally designed mood boards! Welcome home!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Aspire Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1 Rachel Heights' ,`LotDesciption` = 'Other' ,`LotSize` = '1900' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Rachel Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.52' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702546' WHERE `Matrix_Unique_ID` = '211295002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:38:02.993' ,`MLSNumber` = '96078538' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.615257' ,`Longitude` = '-95.631602' ,`PhotoCount` = '32' ,`PostalCode` = '77478' ,`RoomCount` = '6' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Venice' ,`StreetNumber` = '503' ,`StreetSuffix` = 'Street' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is a MUST-SEE! Recently COMPLETELY updated to include wood-look plank tile flooring throughout. Enjoy the open living concept. The kitchen features stainless steel appliances and Calacatta Gold Silestone countertops. Plantation shutters and roller solar screens were installed in 2019. Your primary bedroom opens to the back yard. A Rheem 5-ton A/C and furnace, roof, wood-look garage door and entire yard irrigation system were completed in 2019. The full concrete driveway was installed 2020. Recently painted (2022) interior and exterior. The yard is professionally landscaped and maintained giving this home excellent curb appeal. Enjoy your view of Oyster Creek from your Belgard paver patio with back yard mosquito system, and on those cooler nights enjoy sitting around the fire pit. Located in the heart of old Sugar Land with easy access to Highway 90a, US 59.' ,`Acres` = '0.4247' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BELKNAP S/D SEC 2, BLOCK 4, LOT 3, .450' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '18498' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Belknap Sub Sec 2' ,`TaxAmount` = '7604' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702546' WHERE `Matrix_Unique_ID` = '211300890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:58:50.890' ,`MLSNumber` = '41439744' ,`ListAgentFullName` = 'Nelson Senegal' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950185' ,`Longitude` = '-95.570076' ,`PhotoCount` = '29' ,`PostalCode` = '77070' ,`RoomCount` = '3' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress North Houston' ,`StreetNumber` = '10005' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unrestricted 1.3 acres of land with 3 bedroom home in the heart of Northwest Houston. This property features a Air Landing strip for small planes and just minutes away from Willow Brook Mall. This is a hidden gem waiting for the right buyer. Location -Location -Location !!!!' ,`Acres` = '1.3315' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 10 FLYING ACRES' ,`LotDesciption` = 'Airpark,Other,Wooded' ,`LotSize` = '58000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DANISH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Flying Acres' ,`TaxAmount` = '5493' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702546' WHERE `Matrix_Unique_ID` = '211455665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:37:15.740' ,`MLSNumber` = '92974135' ,`ListAgentFullName` = 'Nelvin Adriatico' ,`ListOfficeName` = 'Adriatico & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738350' ,`Longitude` = '-95.373075' ,`PhotoCount` = '6' ,`PostalCode` = '77004' ,`RoomCount` = '8' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Stuart Street' ,`StreetNumber` = '1505' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning contemporary architecture with amazing finishes! Steel beam construction with floor to ceiling windows. Gorgeous interiors include high ceilings, custom cabinets, quartz counters, stainless steel appliances (inclu. wine cooler and ice maker), Ecosmart fireplaces, LED lighting, hardwood floors, giant terrace with outdoor kitchen, pivot front door and frosted glass garage doors. Convenient to rail and Midtown nightlife.' ,`Acres` = '0.0491' ,`Area` = '16' ,`BuilderName` = 'Adriatico Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Midtown - Houston' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 STUART TERRACE' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2139' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGORY-LINCOLN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Stuart Terrace' ,`TaxAmount` = '7999' ,`TaxRate` = '2.5397' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702546' WHERE `Matrix_Unique_ID` = '211537984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:38:43.287' ,`MLSNumber` = '49747060' ,`ListAgentFullName` = 'Abigail Steinhagen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904260' ,`Longitude` = '-95.734118' ,`PhotoCount` = '8' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '485990.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Lake Dr' ,`StreetNumber` = '7638' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Tricoast Homes, this Lagos floor plan is a gorgeous home located in the Marvida community. This home welcomes you with trend-conscious flooring that leads you to an updated kitchen complete with granite countertops and stainless steel appliances. Relax in the tub in the master bathroom , featuring luxurious designs with modern finishes. Unwind outside on the texas-sized patio. Within each Tricoast home you will find high vaulted ceilings in the living room. Living here you can enjoy a community recreation center with community lakes and water features, a 3,000 square foot clubhouse, pool, playground, dog park, and tennis and sand volleyball courts. Contact us today for more information!**FRONT AND BACKYARD IRRIGATION!!**' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 1, Section 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702547' WHERE `Matrix_Unique_ID` = '211694024' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:30:36.660' ,`MLSNumber` = '21316173' ,`ListAgentFullName` = 'Abigail Steinhagen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904260' ,`Longitude` = '-95.734118' ,`PhotoCount` = '8' ,`PostalCode` = '77433' ,`RoomCount` = '3' ,`ListPrice` = '368990.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Lake Dr' ,`StreetNumber` = '7610' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1601' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Tricoast Homes, this Santorini floor plan is a gorgeous home located in the Marvida community. This home welcomes you with trend-conscious flooring that leads you to an updated kitchen complete with granite countertops and stainless steel appliances. Relax in the tub in the master bathroom , featuring luxurious designs with modern finishes. Unwind outside on the texas-sized patio. Within each Tricoast home you will find high vaulted ceilings in the living room. Living here you can enjoy a community recreation center with community lakes and water features, a 3,000 square foot clubhouse, pool, playground, dog park, and tennis and sand volleyball courts. Contact us today for more information!**FRONT AND BACKYARD IRRIGATION!!**' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 1, Section 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702547' WHERE `Matrix_Unique_ID` = '211701347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:28:42.017' ,`MLSNumber` = '93645070' ,`ListAgentFullName` = 'Wesley Bryant' ,`ListOfficeName` = 'Partners in Building LP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788792' ,`Longitude` = '-95.505124' ,`PhotoCount` = '6' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '1975000.00' ,`Status` = 'Active' ,`StreetName` = 'Winningham' ,`StreetNumber` = '8822' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring Valley Village' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CUSTOM HOME BY PARTNERS IN BUILDING. EARLY STAGES-STILL TIME TO TAILOR THE DESIGN FINISHES. Expansive foyer leading to the gallery. Features a quiet, private study, mud room and utility rooms on each floor. The open kitchen includes double ovens, large island and walk-in pantry. The family room welcomes entertaining with dramatic volume ceilings while hosting special occasion meals in the adjacent dining room is a delight. Huge covered patio. Four spacious bedrooms on the second floor include their own private baths. A convenient laundry room and loft round out the second floor. The luxurious owner’s suite boasts a spacious closet with an island that\'s sure to impress. Great location! Low traffic count & beautiful trees. Wonderful SBISD schools - Valley Oaks - Spring Branch Middle - Memorial Senior.' ,`Acres` = '0.2324' ,`Area` = '24' ,`BuilderName` = 'Partners in Building' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 SPRING VALLEY SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'VALLEY OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Spring Valley Sec 04' ,`TaxAmount` = '12220' ,`TaxRate` = '2.3056' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702547' WHERE `Matrix_Unique_ID` = '211703473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:27:14.537' ,`MLSNumber` = '43677906' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226369' ,`Longitude` = '-95.239454' ,`PhotoCount` = '22' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '286141.00' ,`Status` = 'Active' ,`StreetName` = 'White Moss' ,`StreetNumber` = '15250' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The open-concept Aquila plan offers three large bedrooms, two full bathrooms, and a home office!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 33, Block 2, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6138' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '756' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.562' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702547' WHERE `Matrix_Unique_ID` = '211784075' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:04:16.690' ,`MLSNumber` = '17767896' ,`ListAgentFullName` = 'Maria Giovinale' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161733' ,`Longitude` = '-95.151492' ,`PhotoCount` = '4' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Galaxy' ,`StreetNumber` = '19243' ,`StreetSuffix` = 'Boulevard' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 19253 Galaxy Blvd!! This gorgeous new construction home is surrounded by beautiful green scenarios and located inside a very peaceful and quiet neighborhood. The house has 10’ ceilings in the kitchen and living areas and an open concept floorplan which integrates perfectly all the common areas making it perfect for entertaining. The kitchen is equipped with 42” upper cabinets, a large functional kitchen island and granite countertops. The bedrooms have large and spacious walk-in closets. It comes with the Samsung Stainless Steel package including easy clean top range with electric oven, 3 racks dishwasher and microwave. Buyer will obtain 1 year warranty on appliances from Samsung. Come and see this beautiful home!' ,`Acres` = '0.51' ,`Area` = '40' ,`BuilderName` = 'Starter Homes of TX' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KINGS COLONY 01, BLOCK 2, LOT 29, ACRES 0.510' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '22215' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Colony 01' ,`TaxAmount` = '22' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702547' WHERE `Matrix_Unique_ID` = '211784979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T16:24:06.653' ,`MLSNumber` = '49784981' ,`ListAgentFullName` = 'Steven Girgenti' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835369' ,`Longitude` = '-95.467639' ,`PhotoCount` = '33' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Verdome' ,`StreetNumber` = '5105' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this darling 1 story home located in Oak Forest YOURS! This move-in ready charmer offers 3 spacious bedrooms, 1.5 bathrooms & a fully converted garage. Stunning curb appeal with red brick and freshly painted siding, expertly manicured yard & carport. Enter the home to find gorgeous wood floors, neutral paint & ceiling fans throughout. The home chef will love the granite countertops, upper and lower cabinetry, bright white cabinets & coordinating tile backsplash. The garage has been converted into an expansive second living space complete with massive stone fireplace surround, built in shelving & sprawling cased windows. The living space opens to a fully enclosed sun room with wall-to-wall windows, PERFECT for a hot Houston summer! Step outside to enjoy your fenced in back yard with plenty of space for all of your outdoor entertainment needs. Storage shed, sprinkler system and mature tree are all added bonuses! Zoned to HISD. Excellent location with easy access to HWY-290 & I-610.' ,`Acres` = '0.1584' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 8 OAK FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '4660' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702547' WHERE `Matrix_Unique_ID` = '211785634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T17:49:07.733' ,`MLSNumber` = '95358146' ,`ListAgentFullName` = 'Kimberly Price' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.154046' ,`Longitude` = '-94.186918' ,`PhotoCount` = '13' ,`PostalCode` = '77708' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'San Diego' ,`StreetNumber` = '8235' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and affordable new construction by Price Homes. This home features grand entry, high ceilings and pretty light fixtures. Neutral colors throughout to go with your decor. Open concept plan makes it ideal for entertaining. Quartz countertops, carpet and tile throughout. Schedule your viewing today!' ,`Acres` = '0.1722' ,`Area` = '51' ,`BuilderName` = 'CMP 3 Enterprises' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BEL AIR L 14 B 13' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'GUESS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'VINCENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bel Air' ,`TaxAmount` = '2041' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702548' WHERE `Matrix_Unique_ID` = '211790237' --> Updated record success