Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T21:05:58.573' ,`MLSNumber` = '74722269' ,`ListAgentFullName` = 'Edna Dowson' ,`ListOfficeName` = 'Royal Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.634355' ,`Longitude` = '-95.530517' ,`PhotoCount` = '36' ,`PostalCode` = '77489' ,`RoomCount` = '14' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Pipers Landing' ,`StreetNumber` = '16126' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME IS A JEWEL!!! Located in a quiet secluded neighborhood with easy access to Sam Houston Tollway South, Ft. Bend Tollway, HWY 90, and HWY 59/69 South. This beautiful 2-story home is located on a corner lot with a detached garage. Well manicured lawn with mature trees. The master suite features a jacuzzi tub with a separate shower,  double vanities, and a large walk-in closet. Huge Gameroom on 2nd level with large office/bedroom with beautiful glass French doors. 4th bedroom has his/hers closets.' ,`Acres` = '0.17' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 VILLAGE OF SAWYERS CROSSING COLONY CROSSING' ,`LotDesciption` = 'Corner' ,`LotSize` = '7406' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Colony Crossing' ,`TaxAmount` = '5893' ,`TaxRate` = '2.9379' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701093' WHERE `Matrix_Unique_ID` = '205806187'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T20:28:25.033' ,`MLSNumber` = '96744684' ,`ListAgentFullName` = 'Derek Barham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084377' ,`Longitude` = '-96.081388' ,`PhotoCount` = '19' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate and Large Homesite!  Under construction for estimated August closing.  Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Beautiful black appliance package, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFECIENT!\r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr MajorStructural components' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 Block 45' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701094' WHERE `Matrix_Unique_ID` = '208753909'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T20:29:42.283' ,`MLSNumber` = '10535463' ,`ListAgentFullName` = 'Derek Barham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102793' ,`Longitude` = '-96.089066' ,`PhotoCount` = '21' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '238' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate and Large Homesite!  Under construction for estimated August closing.   Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Beautiful black appliance package, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFECIENT!\r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr MajorStructural components' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 4 Block 45' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701094' WHERE `Matrix_Unique_ID` = '208754964'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T20:29:07.997' ,`MLSNumber` = '23135548' ,`ListAgentFullName` = 'Derek Barham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102793' ,`Longitude` = '-96.089066' ,`PhotoCount` = '19' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '228' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate and Large Homesite! Under construction for estimated August closing.  Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Beautiful black appliance package, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFECIENT!\r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr MajorStructural components' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3 Block 45' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701094' WHERE `Matrix_Unique_ID` = '208755338'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T20:15:46.383' ,`MLSNumber` = '28255585' ,`ListAgentFullName` = 'Elsa Kelleher' ,`ListOfficeName` = 'Gold Quest Realty- Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748641' ,`Longitude` = '-95.329364' ,`PhotoCount` = '11' ,`PostalCode` = '77011' ,`RoomCount` = '4' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Canal' ,`StreetNumber` = '4426' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMIN DUPLEX WITH LOTS OF POTENCIAL, NEAR DOWNTON AND MINUTE MAID PARK. THIS IS AN UPCOMING, POPULAR, AND GREAT LOCATION IN THE EAST END REVITALIZED AREA. THIS FLEXIBLE BUNGALOW COULD BECOME A CASH FLOW INCOME INVESMENT, AS A RESIDENTIAL OR COMERCIAL RENTAL. GREAT OPORTUNITY TO START A HOME OFFICE OR SMALL BUSINESS.  EXTERIOR PAINTING IN PROGRESS.\r\n(THIS PROPERTY WAS A SINGLE FAMILIY \"3 OR 4 BEDROOM,2BATH . REHABBED FROM TOP TO BOTTOM\" ON 2016)\r\nCONVERTED TO A DUPLEX ON 2017. PLEASE DO NOT DISTURB TENANTS.' ,`Acres` = '0.1475' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 & W 27 FEET LT 4 BLK 49 OAK LAWN' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '6425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Oak Lawn' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1932' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701094' WHERE `Matrix_Unique_ID` = '209413143'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T20:39:06.847' ,`MLSNumber` = '86095396' ,`ListAgentFullName` = 'Derek Barham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099257' ,`Longitude` = '-96.070466' ,`PhotoCount` = '10' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '234999.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate and Large Homesite!  Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Beautiful black appliance package, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFECIENT!\r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr MajorStructural components' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N/A' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6200' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701094' WHERE `Matrix_Unique_ID` = '210302283'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T20:38:41.153' ,`MLSNumber` = '77614662' ,`ListAgentFullName` = 'Derek Barham' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099257' ,`Longitude` = '-96.070466' ,`PhotoCount` = '10' ,`PostalCode` = '77445' ,`RoomCount` = '6' ,`ListPrice` = '234999.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '429' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Energy-efficient home with Low Tax rate and Large Homesite!  Open concept kitchen overlooking the large living-dining combo, which makes it perfect for entertaining. Beautiful black appliance package, engineered and inspected by third party engineer, 14.5 seer HVAC system, double pane insulated Low-E windows, ENERGY EFFECIENT!\r\nWarranty: 1 yr workmanship & materials, 2 yr on all systems- plumbing, electrical, HVAC & other Mechanical Systems, 10 yr MajorStructural components' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Censeo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N/A' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6200' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Town of Hempstead' ,`TaxAmount` = '' ,`TaxRate` = '2.59' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701094' WHERE `Matrix_Unique_ID` = '210302819'  --> Updated record success<br />