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-10-03T01:22:00.770' ,`MLSNumber` = '70517320' ,`ListAgentFullName` = 'Travis Edmunds' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.396189' ,`Longitude` = '-95.504494' ,`PhotoCount` = '41' ,`PostalCode` = '77318' ,`RoomCount` = '12' ,`ListPrice` = '614824.00' ,`Status` = 'Active' ,`StreetName` = 'Calmato Woods' ,`StreetNumber` = '338' ,`StreetSuffix` = 'Way' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3328' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin-Homes New Construction! Your NEW, low maintenance, energy-efficient certified home conveniently located in the newest Master-Planned Community of The Woodlands Hills! This showpiece, breathtaking and functional 1 story home w/ 3 car tandem garage has soaring Ceilings, 8ft doors, & large 7in Base Trim. The Texas-size open island kitchen features beautiful quartz countertops, stainless appliances, & quality Kentmoore cabinetry. The Family Room features a cathedral ceiling, tons of natural light, 36in gas log fireplace & adjacent Formal Dining. You\'ll love this plan & neighborhood!' ,`Acres` = '0.22' ,`Area` = '39' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'The Woodlands Hills 02, BLOCK 2, Lot 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9611' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '992' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791444' WHERE `Matrix_Unique_ID` = '200070201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '77317558' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408411' ,`Longitude` = '-95.002676' ,`PhotoCount` = '21' ,`PostalCode` = '77591' ,`RoomCount` = '7' ,`ListPrice` = '312990.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Jasper' ,`StreetNumber` = '8125' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The unique Sabine plan boasts three bedrooms with walk-in closets, two bathrooms & a private study!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 5, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791444' WHERE `Matrix_Unique_ID` = '204302166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '72421612' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408524' ,`Longitude` = '-95.003471' ,`PhotoCount` = '14' ,`PostalCode` = '77591' ,`RoomCount` = '7' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Ruby' ,`StreetNumber` = '3109' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Comal home boasts three bedrooms, two full bathrooms, a breakfast area & a study!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17, Block 1, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791444' WHERE `Matrix_Unique_ID` = '204302497' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '47463336' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409630' ,`Longitude` = '-95.001002' ,`PhotoCount` = '21' ,`PostalCode` = '77591' ,`RoomCount` = '9' ,`ListPrice` = '355990.00' ,`Status` = 'Active' ,`StreetName` = 'Amethyst' ,`StreetNumber` = '2722' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Blanco is a gorgeous home featuring four bedrooms, two-and a half bathrooms, and a gameroom!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37, Block 5, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791444' WHERE `Matrix_Unique_ID` = '204302872' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '78308744' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.407001' ,`Longitude` = '-95.001778' ,`PhotoCount` = '17' ,`PostalCode` = '77591' ,`RoomCount` = '7' ,`ListPrice` = '285990.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Quartz' ,`StreetNumber` = '2425' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Comal home boasts three bedrooms, two full bathrooms, a breakfast area & a sizeable flex space!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 2, Section *' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791444' WHERE `Matrix_Unique_ID` = '205145780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '53569730' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408916' ,`Longitude` = '-95.003425' ,`PhotoCount` = '28' ,`PostalCode` = '77591' ,`RoomCount` = '9' ,`ListPrice` = '355990.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Jasper' ,`StreetNumber` = '8129' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The impressive Trinity plan boasts four bedrooms, two-and a half bathrooms & an upstairs gameroom!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 5, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791445' WHERE `Matrix_Unique_ID` = '205779337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '63318934' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408842' ,`Longitude` = '-95.001373' ,`PhotoCount` = '15' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '275990.00' ,`Status` = 'Active' ,`StreetName` = 'Aquamarine' ,`StreetNumber` = '2614' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The charming Frio plan includes three bedrooms with two bathrooms & a massive family room!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22, Block 5, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791445' WHERE `Matrix_Unique_ID` = '205779555' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '71748746' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920930' ,`Longitude` = '-95.732768' ,`PhotoCount` = '37' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '422000.00' ,`Status` = 'Active' ,`StreetName` = 'Adventurous' ,`StreetNumber` = '18627' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle dreams with the Modern Farmhouse design of The Abney in Bridgeland\'s Parkland Row. Enjoy the peace of working from home in your own private office located off the entry. The open kitchen and family room makes family gathering casual and comfortable. The kitchen island anchors the chef\'s kitchen. You are surrounded with lots of windows making the area feel bright and airy. Enjoy the privacy of your master retreat with a spa like shower. The shaded, covered back patio is the perfect escape to enjoy your morning coffee or relaxing with friends and family. David Weekley Homes is a Diamond Level Environments for Living home builder. Heating and cooling is guaranteed for three years. Come enjoy the resort style amenities of Bridgeland, while living in a new David Weekley Home in a Traditional Neighborhood Design.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 03 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791445' WHERE `Matrix_Unique_ID` = '208966837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '27783318' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925282' ,`Longitude` = '-95.734184' ,`PhotoCount` = '41' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '542000.00' ,`Status` = 'Active' ,`StreetName` = 'Momentous' ,`StreetNumber` = '15219' ,`StreetSuffix` = 'Path' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New David Weekley Home! Guaranteed heating and cooling usage for threee years with our Enviironments for Living Program! You\'ll love the convenience of living in the beautiful master planned community of Bridgeland. The ample amenities and nearby shopping and dinning will make you wish you lived here sooner. The front foyer of the Danbridge has an elegant tray ceiling that opens to the expansive study, family room and kitchen. Design the ultimate home office, library, or craft area in the light and bright FlexSpace. The kitchen is a chef\'s dream as it is well appointed with built in oven, large pantry, enormous island for prep work that serves as a breakfast bar. Enjoy your morning coffee on the covered patio. The Owner’s Retreat features an oversized spa-rainfall shower. Bonus features include backpack area, powder room, and oversize utility room with folding table. Tile flooring throughout entry, kitchen, dining, family, utility, and baths adds to the elegance of this unique home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 06 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791445' WHERE `Matrix_Unique_ID` = '209626172' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '10909397' ,`ListAgentFullName` = 'Stephanie Childress' ,`ListOfficeName` = 'Rockin 4C Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480131' ,`Longitude` = '-95.223549' ,`PhotoCount` = '15' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Austin' ,`StreetNumber` = '2554' ,`StreetSuffix` = 'Trail' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Milano Floor plan is a 2 Story- Open Floor Plan with 4 bedrooms and 3 bathrooms. Kitchen provides a large island with Granite countertops and open to the Living room and Dining Room. Home offers stainless steel appliances, plenty of cabinets for storage. The downstair area is great for entertaining. Large Windows allow for lots of natural light. Primary suite is oversized and has an ensuite bath with separate shower and tub and a huge walk in closet. Vinyl Plank flooring throughput except in the bedrooms. Outside is a peaceful covered patio area for quite relaxing coffee or dinner. This home also includes endless hot water with a tankless water heater.' ,`Acres` = '0.2082' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 2 FRIENDSWOOD TRAILS SEC 1, 2 & COMM (2020) ABST 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9069' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Friendswood Trails' ,`TaxAmount` = '1162' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791445' WHERE `Matrix_Unique_ID` = '210549754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '27315880' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.404658' ,`Longitude` = '-95.057978' ,`PhotoCount` = '23' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Anchor Bay' ,`StreetNumber` = '13206' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Madison plan was a model home and is a two-story home featuring 5 bedrooms; one located downstairs, 3 baths, and 3 car garage. The gourmet kitchen includes silestone counter tops, stainless steel appliances, and open concept floorplan with the kitchen opening to the dining room and family room. The upstairs primary suite features an attractive primary bath and large walk-in closet. The upstairs loft is built standard and are perfect for entertaining. The rear covered patio is located off the family room and secondary bedroom. Come see the amazing 12-acre Lago Mar crystal clear lagoon that is the largest in Texas and a unique staycation destination. The lagoon features multiple beaches, a floating obstacle course, a swim-up bar, a 10,000-square-foot beach club with cabana pool and so much more. Swim, paddle, play and then end the day with drinks and dinner on our beautiful Breezeway Boardwalk. *Representational photos only, finishes may vary*' ,`Acres` = '0.1578' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 47 BLK 1 LAGO MAR POD 4 SEC 3 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6917' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar Pod 4 Sec 3' ,`TaxAmount` = '8290' ,`TaxRate` = '3.5512' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791445' WHERE `Matrix_Unique_ID` = '210638414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '38424638' ,`ListAgentFullName` = 'Elizabeth Robertson' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.335853' ,`Longitude` = '-95.057585' ,`PhotoCount` = '21' ,`PostalCode` = '77327' ,`RoomCount` = '9' ,`ListPrice` = '294990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Swinley Forest' ,`StreetNumber` = '20057' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bedroom one story home with vinyl wood plank flooring throughout. Carpet in bedrooms only and tile floor in primary bath. Open floor with oversized island kitchen and breakfast open to the family room with lots of windows! Fabulous kitchen with gorgeous Kent Moore cabinets, custom designed backsplash, Granite countertops and stainless steel appliances. Large breakfast area with access to the covered patio. Primary suite with vaulted ceiling, primary bath with double sinks w/quartz countertops, separate tub & shower with a big walk-in\r\ncloset. Secondary bedrooms feature walk-in closets. Lot has a 6\' privacy fence in the backyard.! Low taxes and easy access to Hwy 59 and only 15 minutes to the Grand Parkway! Hurry, Call Today!' ,`Acres` = '0.1437' ,`Area` = '52' ,`BuilderName` = 'Kendall Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 3, BLOCK 1, LOT 5, ACRES .1437' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve Sec 3' ,`TaxAmount` = '480' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791446' WHERE `Matrix_Unique_ID` = '211506432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '67300616' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856844' ,`Longitude` = '-95.775646' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '385875.00' ,`Status` = 'Active' ,`StreetName` = 'Undertaken Path' ,`StreetNumber` = '23002' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With 2178 square feet, the Whitney offers the following features: 2.5 CAR GARAGE, 4 Sides Brick, No Back Neighbors, Brick and Stone Elevation, Granite countertops at Kitchen and baths, 42\" White Kitchen Cabinets, Herringbone design backsplash, Stainless Steel Appliances that include Whirlpool 5 burner gas range, microwave oven that is vented outside and dishwasher, 6\"x24\" wood tile throughout except for bedrooms, Stairs and gameroom, 2\" Blinds, Elongated toilets, tankless water heater, Mahogany Full Lite front door, Garage Door Opener, Covered Patio that includes gas stub out, fan and TV outlet, freezer plug at garage, full sod front and back, Sprinkler System, Front gutters, Home automation powered by Google, and much more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8362' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791446' WHERE `Matrix_Unique_ID` = '211529670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '38421490' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856844' ,`Longitude` = '-95.775646' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '366902.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5738' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With 2178 square feet, the Whitney offers the following features: 2.5 CAR GARAGE, 4 Sides Brick, No Back Neighbors, Brick and Stone Elevation, Granite countertops at Kitchen and baths, 42\" White Kitchen Cabinets, Herringbone design backsplash, Stainless Steel Appliances that include Whirlpool 5 burner gas range, microwave oven that is vented outside and dishwasher, 6\"x24\" wood tile throughout except for bedrooms, Stairs and gameroom, 2\" Blinds, Elongated toilets, tankless water heater, Mahogany Full Lite front door, Garage Door Opener, Covered Patio that includes gas stub out, fan and TV outlet, freezer plug at garage, full sod front and back, Sprinkler System, Front gutters, Home automation powered by Google, and much more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791446' WHERE `Matrix_Unique_ID` = '211530901' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '26928280' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856547' ,`Longitude` = '-95.775989' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '380515.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Vista' ,`StreetNumber` = '5718' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Boasting a beautiful and functional single-story layout, this 2000 square foot Brazos lot welcomes you with a charming front porch entrance. Inside and beyond a welcoming foyer, you\'ll love an open-concept living area that features an inviting kitchen that features a center island and wide pantry, an elegant dining area, and a spacious great room. Additional main-floor highlights include a Owner\'s Entry off the 2-bay garage and a covered patio off the dining area.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791446' WHERE `Matrix_Unique_ID` = '211531245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '10773860' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855951' ,`Longitude` = '-95.776676' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '338990.00' ,`Status` = 'Active' ,`StreetName` = 'Undertaken Path' ,`StreetNumber` = '23026' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With over 1,600 square feet, the Hillshire boasts abundant space for private living and entertaining. This plan welcomes you with a charming front porch, leading you into an intimate foyer. Beyond the foyer, you\'ll love an open-concept living area that features an inviting kitchen with an eat-in island, an elegant dining area, and a spacious great room. Anchoring the home, a primary suite features its own en-suite 4 piece bath and an expansive walk-in closet. Additional main-floor highlights include a valet entry off the 2-bay garage and a patio off the kitchen area.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 1, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791446' WHERE `Matrix_Unique_ID` = '211537370' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '90017018' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856249' ,`Longitude` = '-95.776332' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '328580.00' ,`Status` = 'Active' ,`StreetName` = 'Undertaken Path' ,`StreetNumber` = '23018' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1521' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This storybook Fresno plan boasts a move-in-ready designed layout with plenty of entertaining and private living space. At the heart of the home, an open-concept layout includes a great room, a casual dining area and a spacious kitchen that features a lovely center island and pantry. The kitchen showcases granite countertops, 42 inch cabinets, and efficient Whirlpool® brand appliances. Off the kitchen, you’ll enjoy access to three inviting secondary bedrooms, a full hall bath and a two-bay garage. Toward the back of the home, a secluded primary suite comes with a roomy walk-in closet and private bath that includes a large walk-in shower. This home also introduces home automation powered by Google®, a tankless water heater, coach lights, and more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791446' WHERE `Matrix_Unique_ID` = '211537621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '78170815' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856249' ,`Longitude` = '-95.776504' ,`PhotoCount` = '11' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '315897.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5626' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With over 1,600 square feet, the Hillshire boasts abundant space for private living and entertaining. This plan welcomes you with a charming front porch, leading you into a welcoming foyer. Beyond the foyer, you\'ll love an open-concept living area that features an inviting kitchen with eat-in island—boasting an elegant dining area and a spacious great room. Anchoring the home, a primary suite features its own on-suite 4 piece bath and an expansive walk-in closet. Additional main-floor highlights include a valet entry off the 2-bay garage and a patio off the kitchen area.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791447' WHERE `Matrix_Unique_ID` = '211539697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '64013963' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855653' ,`Longitude` = '-95.775646' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '332950.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Vista' ,`StreetNumber` = '5714' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With over 1,500 square feet, the Barton boasts abundant space for private living and entertaining. This plan welcomes you with a charming front porch, leading you into a welcoming foyer. Beyond the foyer, you\'ll love an open-concept living area that features an inviting kitchen—boasting a center island and wide pantry—an elegant dining area, and a spacious great room. Additional main-floor highlights include an Owner\'s Entry off the 2-bay garage and a covered patio off the dining area. Elevation: D5 Interior Color Package: 3 Exterior Color Scheme: Brick - Denali + Stone - Blanco Chopped Structural Options: Rear Covered Patio, 3 Sides Brick 1st Fl, Separate Tub&Shower Lot Specifics: Close to Amenities' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 3, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791447' WHERE `Matrix_Unique_ID` = '211539928' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '46358094' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856742' ,`Longitude` = '-95.775699' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '321807.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5742' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Navarro plan is efficiently designed for your convenience and comfort. Upon entering this single-story home, you\'ll find a generous family room, flowing into an open-concept dining area and well-appointed kitchen. Additional highlights include two secondary bedrooms—sharing a full hall bath—and a spacious primary bedroom with a walk-in closet and en-suite bath, home features a covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5058' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791447' WHERE `Matrix_Unique_ID` = '211540029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '79789526' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855951' ,`Longitude` = '-95.775989' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '331265.00' ,`Status` = 'Active' ,`StreetName` = 'Undertaken Path' ,`StreetNumber` = '23022' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Navarro plan is efficiently designed for your convenience and comfort. Upon entering this single-story home, you\'ll find a generous family room, flowing into an open-concept dining area and well-appointed kitchen. Additional highlights include two secondary bedrooms—sharing a full hall bath—and a spacious primary bedroom with a walk-in closet and en-suite bath home features a covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5058' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791447' WHERE `Matrix_Unique_ID` = '211540156' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '20068918' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856844' ,`Longitude` = '-95.775989' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '310710.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5723' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1602' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With over 1,600 square feet, the Hillshire boasts abundant space for private living and entertaining. This plan welcomes you with a charming front porch, leading you into a welcoming foyer. Beyond the foyer, you\'ll love an open-concept living area that features an inviting kitchen with eat-in island—boasting an elegant dining area and a spacious great room. Anchoring the home, a primary suite features its own on-suite 4 piece bath and an expansive walk-in closet. Additional main-floor highlights include a valet entry off the 2-bay garage and a patio off the kitchen area.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5160' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791447' WHERE `Matrix_Unique_ID` = '211540522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '31052743' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855951' ,`Longitude` = '-95.776676' ,`PhotoCount` = '17' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '319200.00' ,`Status` = 'Active' ,`StreetName` = 'Undertaken Path' ,`StreetNumber` = '23014' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Navarro plan is efficiently designed for your convenience and comfort. Upon entering this single-story home, you\'ll find a generous family room, flowing into an open-concept dining area and well-appointed kitchen. Additional highlights include two secondary bedrooms—sharing a full hall bath—and a spacious primary bedroom with a walk-in closet and en-suite bath. Beautiful covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791448' WHERE `Matrix_Unique_ID` = '211540849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '9624518' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856100' ,`Longitude` = '-95.775646' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '288932.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5630' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offering comfort and livability, the Huxley maximizes space in every room to best suit your needs. This single-story floor plan is anchored by a spacious open-concept living room, adjacent to a well-appointed kitchen and dining area. Secluded at the back of the home, the primary suite boasts a walk-in-closet and attached bath. And toward the front of the home, two secondary bedrooms share access to a full hall bath. Options may include a kitchen island and double sinks in the primary bath.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22, Block 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791448' WHERE `Matrix_Unique_ID` = '211540996' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '23081956' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855013' ,`Longitude` = '-95.776783' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '273885.00' ,`Status` = 'Active' ,`StreetName` = 'True Fortune' ,`StreetNumber` = '23114' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With 1205 square feet, the Huxley includes the following features: 3 sides brick, granite countertops at Kitchen and baths, 42\" Light Gray Kitchen Cabinets, Stainless Steel Appliances that include Whirlpool 5 burner gas range, microwave oven that is vented outside and dishwasher, 13\"x13\" Tile throughout except for bedrooms, 2\" Blinds, Elongated toilets, tankless water heater, Mahogany Full Lite front door, Garage Door Opener, Covered Patio, full sod front and back, Sprinkler System, Front gutters, Home automation powered by Google, and more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5199' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791448' WHERE `Matrix_Unique_ID` = '211541564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '30224601' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.855951' ,`Longitude` = '-95.775989' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '284040.00' ,`Status` = 'Active' ,`StreetName` = 'Tabula Rasa' ,`StreetNumber` = '5606' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offering comfort and livability, the Huxley maximizes space in every room to best suit your needs. This single-story floor plan is anchored by a spacious open-concept living room, adjacent to a well-appointed kitchen and dining area. Secluded at the back of the home, the primary suite boasts a walk-in-closet and attached bath. And toward the front of the home, two secondary bedrooms share access to a full hall bath. Options may include a kitchen island and double sinks in the primary bath.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5460' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791448' WHERE `Matrix_Unique_ID` = '211541734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '54920614' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.854761' ,`Longitude` = '-95.775243' ,`PhotoCount` = '14' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '281150.00' ,`Status` = 'Active' ,`StreetName` = 'True Fortune' ,`StreetNumber` = '23039' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With 1205 square feet, the Huxley includes the following features: 3 sides brick, granite countertops at Kitchen and baths, 42\" Light Gray Kitchen Cabinets, Stainless Steel Appliances that include Whirlpool 5 burner gas range, microwave oven that is vented outside and dishwasher, 13\"x13\" Tile throughout except for bedrooms, 2\" Blinds, Elongated toilets, tankless water heater, Mahogany Full Lite front door, Garage Door Opener, Covered Patio, full sod front and back, Sprinkler System, Front gutters, Home automation powered by Google, and more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Block 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5201' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791448' WHERE `Matrix_Unique_ID` = '211541844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '89429724' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.409058' ,`Longitude` = '-95.002381' ,`PhotoCount` = '18' ,`PostalCode` = '77591' ,`RoomCount` = '9' ,`ListPrice` = '342990.00' ,`Status` = 'Active' ,`StreetName` = 'Ocean Jasper' ,`StreetNumber` = '8114' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The popular Rio Grande boasts four bedrooms, two-and a half bathrooms & an upstairs gameroom!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 4, Section 8' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791448' WHERE `Matrix_Unique_ID` = '211681511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '44063349' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408742' ,`Longitude` = '-95.001044' ,`PhotoCount` = '22' ,`PostalCode` = '77591' ,`RoomCount` = '6' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Aquamarine' ,`StreetNumber` = '2610' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The attractive Pedernales plan holds four large bedrooms, two full bathrooms & an oversized pantry!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21, Block 5, Section 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791449' WHERE `Matrix_Unique_ID` = '211683990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T00:26:45.167' ,`MLSNumber` = '16505084' ,`ListAgentFullName` = 'Kate Powell' ,`ListOfficeName` = 'Pam Westlake Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.282981' ,`Longitude` = '-95.617672' ,`PhotoCount` = '35' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Queen Elizabeth' ,`StreetNumber` = '15517' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional 1-story brick/stone home on 1+ ac w/4-car garage & sparkling pool/spa! Home has split plan+study w/closet, formal dining, updated woodgrain tile flooring, granite counters, light neutral paint, travertine/stacked stone fireplace, new HVAC, upgrades. Kitchen has enormous island, storage, veggie sink, cabinetry w/drawers, stainless appliances, oil-rubbed bronze fixtures, bar seating, breakfast space. Giant primary suite has room for workout equipment & sitting area. Primary bath: 2 sinks, vanity, lovely tile floor, walk-in shower, whirlpool tub, huge walk-in closet (about 11\'x14\') w/built ins. Extra bedrooms share tub/toilet w/separate sinks & walk-in closets. Massive covered back patio has outdoor kitchen; newer pool/spa, waterfalls, extra sun deck. Enjoy landscaped back yard, lighting & screened/fenced garden/greenhouse w/ 4\'x20\' beds, paver walkways! Also custom gate w/RV/Boat pad behind. Water softener. On cul-de-sac street. MISD schools, 2 parks/lakes, gated community.' ,`Acres` = '1.007' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CROWN OAKS 04, BLOCK 1, LOT 77' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '43865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Oaks 04' ,`TaxAmount` = '6982' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791449' WHERE `Matrix_Unique_ID` = '211912482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '16368080' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408373' ,`Longitude` = '-95.001565' ,`PhotoCount` = '17' ,`PostalCode` = '77591' ,`RoomCount` = '7' ,`ListPrice` = '275990.00' ,`Status` = 'Active' ,`StreetName` = 'Aquamarine' ,`StreetNumber` = '8016' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Comal home boasts three bedrooms, two full bathrooms, a breakfast area & a sizeable flex space!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 5, Section 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791449' WHERE `Matrix_Unique_ID` = '212064112' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '57377077' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408009' ,`Longitude` = '-95.003707' ,`PhotoCount` = '19' ,`PostalCode` = '77591' ,`RoomCount` = '7' ,`ListPrice` = '332990.00' ,`Status` = 'Active' ,`StreetName` = 'Rose Quartz' ,`StreetNumber` = '2504' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1915' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The unique Sabine plan boasts three bedrooms with walk-in closets, two bathrooms & a private study!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 1, Section 8' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791449' WHERE `Matrix_Unique_ID` = '212064670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '5528723' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408331' ,`Longitude` = '-95.001712' ,`PhotoCount` = '21' ,`PostalCode` = '77591' ,`RoomCount` = '9' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Aquamarine' ,`StreetNumber` = '8020' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The impressive Trinity plan boasts four bedrooms, two-and a half bathrooms & an upstairs gameroom!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11, Block 5, Section 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791449' WHERE `Matrix_Unique_ID` = '212065183' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '28998117' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923422' ,`Longitude` = '-95.732607' ,`PhotoCount` = '35' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Marvelous' ,`StreetNumber` = '18674' ,`StreetSuffix` = 'Place' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2451' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the classic comfort and modern design combination of The Ziegler. Each upstairs bedroom provides a great place to grow and a big closet. The sunlit open floor plan is suited for daily life and hosting special occasions and offers a beautiful backyard view. Easily prepare family meals and party spreads in the streamlined kitchen. Enjoy the outdoors from the comfort of your covered patio. Your owner’s bedroom suite gives you a beautiful place to begin and end every day in luxury with a deluxe bathroom and walk in closet. The upstairs retreat and downstairs study areas provide the FlexSpace? for you to design the specialty rooms you’ve been dreaming of. Build your future together in this 2-story, 3 bedroom, 2.5 bathroom David Weekley Home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791450' WHERE `Matrix_Unique_ID` = '212146538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:13:00.453' ,`MLSNumber` = '92791123' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.824355' ,`Longitude` = '-95.471470' ,`PhotoCount` = '38' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '389999.00' ,`Status` = 'Active' ,`StreetName` = 'Lamonte' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the Oak Forest Area in Magnum Manor renovated in 2022: kitchen\'s chic custom white cabinetry, w/satin nickel pulls; salt & pepper granite counters & subway tile backsplash. The energy efficient Frigidaire stainless steel dishwasher, microwave and \"wonder stove\" with gas range and convection oven/ Air Fryer and Fridge. Interior: S.W. repurpose grey , with 2\" white blinds compliments the white baseboards framing gray Ash laminate floors throughout the design scheme. The bedrooms with fresh carpet & ceiling fans led lights. & great closets The spa inspired bathrooms: granite counter tops, shaker cabinetry, subway tile backsplash and porcelain tile. The electrical panel grounding, & components, LED recessed lighting, digital thermostats, insulated doors and Low E windows. Don\'t forget the exterior details fresh paint and Hardi and trim & Doors, 2 car garage floor sealed & painted, Back Covered deck. & entry covered porch! Home warranty included!!' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 11 MANGUM MANOR SEC 2 R/P' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mangum Manor Sec 02 R/P' ,`TaxAmount` = '5649' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791450' WHERE `Matrix_Unique_ID` = '212151244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '94653703' ,`ListAgentFullName` = 'Stephanie Childress' ,`ListOfficeName` = 'Rockin 4C Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.479934' ,`Longitude` = '-95.224492' ,`PhotoCount` = '7' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '514999.00' ,`Status` = 'Active' ,`StreetName` = 'Dorado' ,`StreetNumber` = '127' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Terrell Floor plan is a 1 Story- Open Floor Plan with 4 bedrooms and 3 bathrooms. Kitchen provides a large island with Granite countertops and open to the Living room and Dining Room. Home offers stainless steel appliances, plenty of cabinets for storage, double ovens with a gas cooktop. A fireplace is perfect to cozy up to in the cooler months. Large Windows allow for lots of natural light. Primary suite is oversized and has an ensuite bath with separate shower and tub and a huge walk in closet. Vinyl Plank flooring throughput except in the bedrooms. Outside is a peaceful covered patio area for quite relaxing coffee or dinner. This home also includes endless hot water with a tankless water heater. Home is currently under construction.' ,`Acres` = '0.3289' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 3 FRIENDSWOOD TRAILS SEC 1, 2 & COMM (2020) ABST 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '14327' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Friendswood Trails' ,`TaxAmount` = '1374' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791450' WHERE `Matrix_Unique_ID` = '212181990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T00:27:45.570' ,`MLSNumber` = '30625601' ,`ListAgentFullName` = 'Quynh Luong' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831317' ,`Longitude` = '-95.469405' ,`PhotoCount` = '29' ,`PostalCode` = '77092' ,`RoomCount` = '5' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Nina Lee' ,`StreetNumber` = '5223' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this modern ranch-style home located in the desired neighborhood of Oak Forest. Complete remodel 1-story featuring 4 beds, 3 full baths & a 2-car garage. Upgrades include: All new AC & duct, soft closed shaker cabinets & vanities, LED lighting throughout. Updated electrical & PEX plumbing. SMART Home features NEST thermostat & garage door opener. Open living concept. The kitchen features a quartz countertop, a waterfall island, stainless steel appliances & a touchless faucet. Large laundry room w a utility sink. Expansive master suite w/lavish bath, spacious walk-in shower w/a rain shower head & a walk-in closet.  4th bedroom has an en-suite full bath. New insulations for better energy saving. New energy-efficient double pane windows. Spacious backyard with new sod. Low maintenance landscaping. Minutes to T.C. Jester Park, hike & bike trails, local eateries, coffee shops, all major freeways.' ,`Acres` = '0.1677' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 & TR 4A BLK 22 OAK FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7303' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '5049' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791450' WHERE `Matrix_Unique_ID` = '212274071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '37848003' ,`ListAgentFullName` = 'Mario Negron' ,`ListOfficeName` = 'Century Communities Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856547' ,`Longitude` = '-95.775646' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '369445.00' ,`Status` = 'Active' ,`StreetName` = 'Embracement' ,`StreetNumber` = '5714' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2012' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Boasting a beautiful and functional single-story layout, the Brazos plan welcomes you with a charming front porch entrance. Inside, the home is anchored by an open-concept living area, with a spacious great room that flows into a versatile dining area and a well-appointed kitchen with a center island. Toward the front of the home, the foyer leads to three secondary bedrooms—two that flank a full bath and one with an attached full bath and walk-in closet. Located on the other side of the home for added privacy, the primary suite features an attached bath and a generous walk-in closet. A laundry room is also accessible through the primary suite. Personalization options may include a study in lieu of a bedroom, a grand primary bath—featuring a separate tub and shower—and a covered patio off the great room.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, Block 2, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8140' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '3.536' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791450' WHERE `Matrix_Unique_ID` = '212344908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:11:16.170' ,`MLSNumber` = '81098418' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582149' ,`Longitude` = '-95.061603' ,`PhotoCount` = '45' ,`PostalCode` = '77586' ,`RoomCount` = '11' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Crownwood' ,`StreetNumber` = '4239' ,`StreetSuffix` = 'Drive' ,`City` = 'Taylor Lake Village' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another beautifully renovation by Texas Home Buyers, 25 years bringing quality homes. Modern ranch: 4 b/ 2.1B/2C/ Sunroom in the fabulous community in Clear Lake Forest with amenities 3 Pools, Tennis Courts, Greenspace, Dock & Swim team, and renowned Women\'s Club. Design scheme inspired by Coastal Living. Exterior: New trim, Freshly painted grey-green- beige accent the multi tone Sandstone hues brick, light fixtures, New insulated entry with inset TEXAS STAR glass panel and landscaping. Clean and Crips home interior freshly painted modern greige walls & crisp white trim & cabinetry & ergonomic flooring & Salt and Pepper Granite Counters & Gallery Frigidaire appliance package & Subway Tile backsplash & cedar closet & NEW Spa inspired Primary bath w/ rain shower seamless Glass enclosed& porcelain tile floor & double vanity & shaker cabinetry & Primary wrap around closet & New Guest BATH & LED lighting & Ceiling fans & 2\" blinds & Revamped Sunroom. Home warranty included!' ,`Acres` = '0.2626' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 & TR 9 BLK 22 CLEAR LAKE FOREST SEC 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clear Lake Forest Sec 05' ,`TaxAmount` = '6919' ,`TaxRate` = '2.279' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791451' WHERE `Matrix_Unique_ID` = '212385389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '85287747' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924482' ,`Longitude` = '-95.732779' ,`PhotoCount` = '19' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '532000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkland Row' ,`StreetNumber` = '18630' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this spacious McClaren, a 2-story home located in a Bridgeland’s Parkland Row; a David Weekley Homes exclusive section offering Modern Farmhouse and Modern Prairie homes in a Traditional Neighborhood Design. This is a 4 bedroom, 3 bath home with two bedrooms located on the first floor, and two-bedrooms and a gameroom located on the second floor. The Owner’s Retreat awaits you on the first floor with a Texas sized super shower. You’ll love entertaining with this gourmet kitchen that opens up to the dining room and family room.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.65' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791451' WHERE `Matrix_Unique_ID` = '212385719' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '41050244' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924198' ,`Longitude` = '-95.733669' ,`PhotoCount` = '44' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Courteous' ,`StreetNumber` = '18647' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fulfill your lifestyle dreams with the Modern Farmhouse design of The Enterprise in Bridgeland\'s Parkland Row. The open kitchen and family room makes family gathering casual and comfortable. The kitchen island anchors the chef\'s kitchen. You are surrounded with lots of windows making the area feel bright and airy. Enjoy the privacy of your owners retreat. The back patio is the perfect escape to enjoy your morning coffee or relaxing with friends and family. David Weekley Homes is a Diamond Level Environments for Living home builder. Heating and cooling is guaranteed for three years. Come enjoy the resort style amenities of Bridgeland, while living in a new David Weekley Home in a Traditional Neighborhood Design.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791451' WHERE `Matrix_Unique_ID` = '212386708' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212411117','1664791451','212411117','2022-10-03T00:20:05.047','96936962','Victor Correa','HomeSmart','','','30.040930','-95.432373','0','77388','4','289999.00','Active','North Hill','203','Drive','Spring','3','0','4','2562','Single-Family','Welcome home! 4 bedroom 3 full bath completely redone! Grand gated front court yard entry!','0.294','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding','1','Spring/Klein','Central Gas','1','LT 157 BLK 7 017*E5332900-001-007-157 ENCHANTED OAKS SEC 1','Subdivision Lot','12807','Appraisal District','','250','0','','2','','0','','','','','Composition','32 - Klein','LEMM ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Enchanted Oaks Sec 01','5574','2.484','Public Sewer,Public Water','1967','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '19298537' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923700' ,`Longitude` = '-95.733500' ,`PhotoCount` = '18' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '412000.00' ,`Status` = 'Active' ,`StreetName` = 'Adventurous' ,`StreetNumber` = '18631' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ate the lifestyle of your dreams with the bold, effortless luxury of this new construction home in Bridgeland. Begin and end each day in the spacious Owner\'s Retreat that features a pamper-ready bathroom and a sprawling walk-in closet. Enjoy a book and your favorite beverage from the comfort of your classic porch or covered back patio. Your open floor plan provides a beautiful expanse for you to fill with decorative flair and lifelong memories. The epicurean kitchen supports your culinary adventures and includes a corner pantry and a full-function island. The spare bedrooms each offer a unique space and endless personalization potential. Create an organized home office, family movie theater, or an inventive specialty room in the versatile study. Storage abounds in the oversized garage with room for a gym or workshop.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791451' WHERE `Matrix_Unique_ID` = '212468005' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '64426539' ,`ListAgentFullName` = 'Rachel May' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292675' ,`Longitude` = '-95.558795' ,`PhotoCount` = '32' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '524999.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Heights' ,`StreetNumber` = '140' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2638' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning property is better than new! Many upgrades and well maintained! This barely lived in Highland home is what dreams are made of! Soaring ceilings and beautiful finishes throughout the home are sure to catch your eye. Sellers have added many things in their short time here, including a whole home dehumidifier, full home gutters, extended concrete patio, pergola, and a gorgeous 8-person spa. Additional features of the home include plugs with USB ports in many areas of the home, \"smart home\" (smart appliances, lock, and thermostats), open second story balcony with iron balusters, walk in attic with flooring for storage, accent paint in main area, upgraded light fixtures, stand-alone tub in primary bath, garage door is tall enough to fit a golf cart or SUV... the list goes on and on! The home has remaining transferable warranty (per seller).' ,`Acres` = '0.126' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965289 - WOODFOREST 89, BLOCK 1, LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 89' ,`TaxAmount` = '' ,`TaxRate` = '2.8388' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791451' WHERE `Matrix_Unique_ID` = '212580548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T00:35:25.920' ,`MLSNumber` = '70396097' ,`ListAgentFullName` = 'Drew Platt' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809594' ,`Longitude` = '-95.396408' ,`PhotoCount` = '22' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Cortlandt' ,`StreetNumber` = '2517' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Darling Sunset Heights bungalow that\'s ideally situated on a corner lot within a few blocks of 19th St. shopping & dining, the Heights Hike & Bike Trail, H-E-B, the Houston Farmers Market, and all the local Heights favorites along N. Shepherd. This wonderful home boasts a great outdoor entertaining space, complete with a pool with water feature, a recently added deck, ample fenced greenspace, an inviting patio, and beautiful landscaping. The home itself features a charming and efficient floor plan. A bright living room and dining room welcome you home, while the island kitchen with utility area provides plenty of storage. Detached two-car garage is accessible from both the backyard and the double-wide driveway. All dimensions approximate, please verify.' ,`Acres` = '0.1322' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 7 (AKA LTS 4 & 5 BLK 53 SUNSET HEIGHTS) MILROY PLA' ,`LotDesciption` = 'Corner' ,`LotSize` = '5760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '10395' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791451' WHERE `Matrix_Unique_ID` = '212606572' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '91090214' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925282' ,`Longitude` = '-95.734184' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '578313.00' ,`Status` = 'Active' ,`StreetName` = 'Momentous' ,`StreetNumber` = '15223' ,`StreetSuffix` = 'Path' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love the convenience of living in the beautiful master planned community of Bridgeland. The ample amenities and nearby shopping and dinning will make you wish you lived here sooner. Sophisticated design and easy elegance combine in The Edgeport new home plan. Enjoy the exquisite sanctuary of your Owner\'s Retreat, which features a splendid en suite bathroom and a walk-in closet. The kitchen island and open dining area offer a streamlined variety of mealtime settings. Flex your interior design skills in the limitless lifestyle potential of the upstairs retreat, the welcoming living area, and the deluxe family room. Everyday refinements include David Weekley Homes guarantees heating and cooling usage for 3 years thought the Environments For Living® program.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 05 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791452' WHERE `Matrix_Unique_ID` = '212661848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '40766523' ,`ListAgentFullName` = 'Abigail Steinhagen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406122' ,`Longitude` = '-95.060331' ,`PhotoCount` = '18' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '370990.00' ,`Status` = 'Active' ,`StreetName` = 'Diamond Reef Ln' ,`StreetNumber` = '13332' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Tricoast Homes, this Clearwater floor plan is a gorgeous home located in the Lago Mar 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 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. Located in Lago Mar, dive in to the heart of the most exciting entertainment district in Texas. The 12-acre Lago Mar crystal clear lagoon is the largest in Texas and will be your very own tropical staycation. Bay Area breezes will caress you while you lounge on white-sand beaches, swim in azure waters or dine lagoon-side on our beach boardwalk. Contact us today for more information!**FRONT AND BACKYARD IRRIGATION!!**' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24, Block 2, Pod 3, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791452' WHERE `Matrix_Unique_ID` = '212684805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T01:22:00.770' ,`MLSNumber` = '16248674' ,`ListAgentFullName` = 'Abigail Steinhagen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405939' ,`Longitude` = '-95.061839' ,`PhotoCount` = '19' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '450990.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Egret' ,`StreetNumber` = '13400' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Tricoast Homes, this Coronado floor plan is a gorgeous home located in the Lago Mar 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 master bathroom, featuring luxurious designs with modern finishes. Unwind outside on the extended texas-sized patio. Within each Tricoast home you will find high vaulted ceilings in the living room. Located in Lago Mar, dive in to the heart of the most exciting entertainment district in Texas. The 12-acre Lago Mar crystal clear lagoon is the largest in Texas and will be your very own tropical staycation. Bay Area breezes will caress you while you lounge on white-sand beaches, swim in azure waters or dine lagoon-side on our beach boardwalk. Contact us today for more information!**FRONT AND BACKYARD IRRIGATION!!**' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 2, Section 2, Pod 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791452' WHERE `Matrix_Unique_ID` = '212684958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T00:57:51.017' ,`MLSNumber` = '64535945' ,`ListAgentFullName` = 'Greg Bennett' ,`ListOfficeName` = 'Greg Bennett Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.611256' ,`Longitude` = '-95.586565' ,`PhotoCount` = '40' ,`PostalCode` = '77478' ,`RoomCount` = '10' ,`ListPrice` = '647500.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway' ,`StreetNumber` = '3006' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3214' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 1, BLOCK 4, LOT 25, R/P' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Water View' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Sugar Creek' ,`TaxAmount` = '8219' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791452' WHERE `Matrix_Unique_ID` = '212890368' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212961565','1664791452','212961565','2022-10-03T00:06:54.247','80831728','Sue Ellen Rangel','JLA Realty','','','30.368664','-95.597692','43','77356','8','375000.00','Active','Park','117','Drive','Conroe','2','1','4','2261','Single-Family','Welcome to tranquil living in your beautiful new home in the lake front resort community of April Sound. Your home sits on a large peaceful lot with lots of trees and a large covered front porch right across from a nature reserve. Your home is a 4 bedroom 2.5 bath with a private study/home office. The owners retreat is on the first floor with updated en suite. The bright sunny kitchen breakfast/dining combo features newer appliances and granite counter tops. A/C and water heater replaced 2019. \r\nApril Sound is a gated community with 24 hour security. Close to all the restaurants and attractions on Lake Conroe. Once you are home you can take advantage of the many amenities your new community has to offer. April Sound Country Club has dining and many events where you can get out and meet your new neighbors. Your new community also offers 27 holes of golf (membership required), tennis, swimming pools, pickle ball, fitness center, boat lauches and so much more. Room sizes are approximate.','0.224','39','','','','','Mud,Reports Available,Sellers Disclosure','1','','','Lake Conroe Area','Central Electric','1','APRIL SOUND 04, BLOCK 4, LOT 48','Cul-De-Sac,In Golf Course Community,Subdivision Lot','9756','Appraisal District','','234','0','','2','','0','','','','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Accompany,Controlled Access,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','April Sound 04','5093','2.2625','Other Water/Sewer','1992','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T00:36:42.390' ,`MLSNumber` = '4284193' ,`ListAgentFullName` = 'Quynh Luong' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.865921' ,`Longitude` = '-95.633973' ,`PhotoCount` = '25' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '283000.00' ,`Status` = 'Active' ,`StreetName` = 'Tinker' ,`StreetNumber` = '15019' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1816' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for move-in one-story traditional home with a beautiful pool in the back yard. This home has an inviting entry leading into a high ceiling open concept living room looking out to a luscious pool. Large spacious rooms with lots of light. High ceiling throughout. Spacious Den leads to a remodeled Kitchen with a new stove and dishwasher. Detached garage with a long driveway; perfect for a great family. There is a half bath outside the pool area; new paint and light fixtures throughout the house. The property is located in proximity to major shopping centers and schools.' ,`Acres` = '0.1848' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 7 Concord Colony' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Concord Colony' ,`TaxAmount` = '4288' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791452' WHERE `Matrix_Unique_ID` = '213019189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T00:28:58.373' ,`MLSNumber` = '31044928' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = 'Alexia Sims' ,`SellingOfficeName` = 'The Rogers Group Realty' ,`Latitude` = '30.226006' ,`Longitude` = '-95.239377' ,`PhotoCount` = '10' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '403572.00' ,`Status` = 'Option Pending' ,`StreetName` = 'New Proper' ,`StreetNumber` = '20902' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2817' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Every square foot of this home is maximized. This 5 bedroom home offers space, flexibility, and comfort. Entering your new home, you are met with a foyer leading to a 1st-floor bedroom. Continuing past the utility room and half bath leads you into the heart of the home - the open-concept, two-story family room adjoined by the oversized kitchen and breakfast area. The kitchen accommodates sleek granite countertops, plentiful cabinets, quartz countertops, and an island for additional cabinet space. Finally, the first floor holds your private master suite with an elegant master bathroom. The master bathroom holds cultured marble countertops, dual vanities, a separate shower, large soaking tub, and walk-in closet! Roam up the stairs to the second floor which is filled with three additional bedrooms, two full bathrooms, and an oversized game room perfect for game nights. No need to sacrifice your space or comfort. A short walk to community amenities.' ,`Acres` = '0.2425' ,`Area` = '40' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S573302 - HARRINGTON TRAILS 02, BLOCK 2, LOT 31' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10565' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`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` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '663' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664791453' WHERE `Matrix_Unique_ID` = '213049785' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213082824','1664791453','213082824','2022-10-03T00:27:40.157','73350604','Dody Burrow','PRG, Realtors','','','30.321198','-95.492504','1','77304','3','200000.00','Active','Woodhaven','307','Lane','Conroe','2','0','3','1996','Single-Family','LOCATION LOCATION LOCATION! Home is nestled in highly sought after Forest Estates Subdivision off Hwy 105 W in Conroe, TX . Minutes from I45 offering a short commute to Houston and located in the center of Conroe near Dining, Shopping , Schools and Entertainment. One Story home featuring 3 Bedrooms and 2 Full Baths as well as Formal Living and Dining, Fireplace and Detached Garage. Home is being Sold AS Is. \r\n\r\nNo Showings until Saturday 10/08/22.','0.2296','19','','','','','Sellers Disclosure','','','1','Lake Conroe Area','Central Electric','0','FOREST ESTATES 02, BLOCK 5, LOT 3','Subdivision Lot','10000','Appraisal District','','75','0','','2','','0','','','','','Composition','11 - Conroe','GIESINGER ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Forest Estates','3195','2.1863','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-03T00:20:04.813' ,`MLSNumber` = '77219830' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '322990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10610' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Texas Cali plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/5/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664791453' WHERE `Matrix_Unique_ID` = '213120287' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213228712','1664791453','213228712','2022-10-03T00:23:39.480','17125705','Luyun Chen','31 Realty','','','29.737112','-95.828811','21','77494','9','460000.00','Active','Creston Cliff','26319','Court','Katy','3','1','5','3064','Single-Family','Come and see this beautiful 2 story house located in the Great Katy community. Hardwood floors in the living/office, iron spindles, granite countertops, beautiful paint throughout, stainless appliances, and a large covered patio! Sprinkler system included! All 5 spacious bedrooms. Huge pantry wraps around the kitchen. Awesome school zone with two neighborhood pools and a park. Located on a nice and quiet cul-de-sac street.','0.179','36','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - Southwest','Central Gas','1','SILVER RANCH SEC 5, BLOCK 1, LOT 48','Corner,Subdivision Lot','7774','Appraisal District','','600','0','','2','','0','','','','','Wood Shingle','30 - Katy','WOODCREEK ELEMENTARY SCHOOL','TOMPKINS HIGH SCHOOL','TAYS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Silver Ranch Sec 5','8078','2.7545','Public Sewer,Public Water','2012','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213228953','1664791453','213228953','2022-10-03T00:40:01.787','85527242','Angela Zapata','NB Elite Realty','','','29.764205','-95.208502','38','77015','4','210000.00','Active','Powell','12706','Lane','Houston','2','0','4','1403','Single-Family','This professional turnkey renovated home shows beautifully. Upgrades include new tile flooring, new wood trim, doors, baseboards and cabinets. New granite countertops, appliances and bathroom vanities. Plumbing and electrical fixtures are new, HVCA system was replaced. Fresh paint inside and outside the house. One year home warranty included, unrestricted area, no home owner association fees.\r\nEasy access to I-10, minutes away from San Jacinto College North Campus and Port of Houston.','0.2094','2','','','','','Sellers Disclosure','1','','','North Channel','Central Gas','0','LT 9 BLK 5 WOODLAND ACRES ANNEX SEC 1','Subdivision Lot','9120','Appraisal District','','','0','','1','','0','','','','','Composition','21 - Galena Park','WOODLAND ACRES ELEMENTARY SCHOOL','GALENA PARK HIGH SCHOOL','WOODLAND ACRES MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Traditional','Woodland Acres Annex','2703','2.7702','Public Sewer,Public Water','1943','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213229877','1664791453','213229877','2022-10-03T00:03:17.797','94369866','Karina Taylor','REALM Real Estate Professional','','','30.049130','-95.395055','26','77373','5','255000.00','Active','Earlmist','23410','Drive','Spring','2','1','3','1754','Single-Family','Charming Home located in Spring, TX! Upon entry you have a formal dining room to your left and to your right you have a large living room with a fireplace. Recessed lighting throughout the living room. Enjoy a cup of coffee with a view of your backyard from the breakfast area and the living room. All new backsplash in the kitchen. New vinyl wood flooring on the first floor. All new paint throughout the property. All bedrooms are located on the second floor. The primary bedroom is spacious with a walk-in closet. Windows are only five years old, all new light fixtures throughout the property. The backyard has space for lounging and activities. Large spacious garage with an added shed behind it. This property did not flood.','0.1653','12','','','','','Mud,Sellers Disclosure','','','1','Spring East','Central Gas','1','LT 18 BLK 49 TIMBER LANE SEC 6','Cleared','7200','Appraisal District','','400','0','','1','','0','','','','','Composition','48 - Spring','PEARL M HIRSCH ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','TWIN CREEKS MIDDLE SCHOOL','Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Traditional','Timber Lane Sec D6','4740','3.0268','Water District','1977','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213230175','1664791453','213230175','2022-10-03T00:08:50.870','37926599','Feras Rachid','Opendoor Brokerage, LLC','','','29.396624','-94.899837','31','77590','4','193000.00','Active','12th','402','Avenue','Texas City','1','1','4','1384','Single-Family','This Texas City one-story corner home offers granite countertops, and a two-car garage.','0.2152','33','','','','','Sellers Disclosure','1','','0','Texas City','Central Gas','0','ABST 205 PAGE 5 LOTS 14 THRU 16 BLK 303 TEXAS CITY','Corner,Subdivision Lot','9374','Appraisal District','','','0','','2','','0','','','','','Composition','52 - Texas City','ROOSEVELT-WILSON ELEMENTARY SCHOOL','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Seller','1','Traditional','Texas City','4279','2.5335','Public Water','1967','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213230225','1664791453','213230225','2022-10-03T00:11:14.217','88798101','Feras Rachid','Opendoor Brokerage, LLC','','','30.016660','-95.302781','34','77338','3','240000.00','Active','Gastonbury','20903','Lane','Humble','2','1','3','1993','Single-Family','This Humble two-story home offers a one-car garage.','0.1921','12','','','','','Sellers Disclosure','1','','0','Humble Area West','Central Gas','1','LT 16 BLK 2 KENSWICK FOREST SEC 3','Subdivision Lot','8368','Appraisal District','','300','0','','1','','0','','','','','Other','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,No Supra Keybox','Seller','2','Traditional','Kenswick Forest Sec 03','4218','2.7433','Water District','2007','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213230467','1664791453','213230467','2022-10-03T00:17:49.950','68686432','Feras Rachid','Opendoor Brokerage, LLC','','','30.003075','-95.150129','35','77346','4','301000.00','Active','Pines Place','8406','Drive','Humble','3','0','4','2705','Single-Family','This Humble two-story cul-de-sac home offers granite countertops, and a two-car garage.','0.1952','1','','','','','Sellers Disclosure','1','','1','Atascocita South','Central Gas','1','LT 32 BLK 4 PINES OF ATASCOCITA SEC 2','Cul-De-Sac,Subdivision Lot','8503','Appraisal District','','649','0','','2','','0','','','','','Other','29 - Humble','PINEFOREST ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Pines Atascocita Sec 02','4737','2.216','Water District','1982','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213230529','1664791453','213230529','2022-10-03T00:20:05.840','53600359','Feras Rachid','Opendoor Brokerage, LLC','','','29.962561','-95.430020','33','77067','3','225000.00','Active','Green Pines','823','Forest','Houston','2','1','3','1604','Single-Family','This Houston two-story home offers a patio, granite countertops, and a two-car garage.','0.0877','13','','','','','Sellers Disclosure','1','','0','1960/Cypress Creek South','Central Gas','1','LT 6 BLK 1 NORTHBOROUGH VILLAGE SEC 1','Subdivision Lot','3820','Appraisal District','','363','0','','2','','0','','','','','Other','48 - Spring','HERITAGE ELEMENTARY SCHOOL (SPRING)','ANDY DEKANEY H S','STELLE CLAUGHTON MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Northborough Village Sec 01','4163','2.7252','Public Water','2003','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213230624','1664791453','213230624','2022-10-03T00:23:13.337','72550502','Feras Rachid','Opendoor Brokerage, LLC','','','30.124671','-95.552580','36','77389','4','333000.00','Active','Barmby','25114','Drive','Spring','2','1','4','2376','Single-Family','This Spring two-story home offers granite countertops, and a two-car garage.','0.4545','14','','','','','Sellers Disclosure','1','','1','Spring/Klein','Central Gas','1','LT 6 BLK 2 017*35911553-001-002-005B-006A LONDONDERRY R/P','Subdivision Lot','19798','Appraisal District','','400','0','','2','','0','','','','','Other','32 - Klein','METZLER ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Londonderry Sec Once Rep','7480','2.834','Water District','2000','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213230736','1664791453','213230736','2022-10-03T00:26:56.897','94886584','Feras Rachid','Opendoor Brokerage, LLC','','','29.825233','-95.733294','29','77449','4','355000.00','Active','Alexander Arbor','3714','Drive','Katy','2','1','4','2665','Single-Family','Built in 2016, this Katy two-story home offers granite countertops, and a two-car garage.','0.1411','25','','','','','Sellers Disclosure','1','','0','Katy - North','Central Gas','1','LT 35 BLK 1 RAINTREE VILLAGE SEC 11','Subdivision Lot','6146','Appraisal District','','436','0','','2','','0','','','','','Other','30 - Katy','MCROBERTS ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','MCDONALD JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox','Seller','2','Traditional','Raintree Village Sec 11','6832','2.5633','Water District','2016','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213230781','1664791453','213230781','2022-10-03T00:31:28.240','35271619','Feras Rachid','Opendoor Brokerage, LLC','','','30.012085','-95.193034','33','77346','4','233000.00','Active','Quail Tree','5419','Lane','Humble','2','0','4','1678','Single-Family','This Humble one-story home offers granite countertops, and a two-car garage.','0.173','1','','','','','Sellers Disclosure','1','','1','Atascocita North','Central Gas','1','LT 21 BLK 4 ATASCOCITA NORTH SEC 1','Subdivision Lot','7535','Appraisal District','','264','0','','2','','0','','','','','Other','29 - Humble','OAKS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','TIMBERWOOD MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Seller','1','Traditional','Atascocita North Sec 01','4045','2.613','Water District','1979','Seller'); --> New record created successfully