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-03T21:07:12.950' ,`MLSNumber` = '11327972' ,`ListAgentFullName` = 'Desmond Hong' ,`ListOfficeName` = 'Newfoundland Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682738' ,`Longitude` = '-95.597224' ,`PhotoCount` = '15' ,`PostalCode` = '77099' ,`RoomCount` = '8' ,`ListPrice` = '288000.00' ,`Status` = 'Active' ,`StreetName` = 'Bexley' ,`StreetNumber` = '12314' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well kept 3-2-2 in this nice neighborhood, lots of up-grades, close to major shopping centers, schools, and freeway system. Excellent for first time buyer and investor.' ,`Acres` = '0.1641' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 16 BROOKFIELD SEC 1 R/P A & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '218' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookfield Sec 01 R/P A & Ext' ,`TaxAmount` = '3708' ,`TaxRate` = '2.4711' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973918' WHERE `Matrix_Unique_ID` = '196015256'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T21:08:14.383' ,`MLSNumber` = '59304850' ,`ListAgentFullName` = 'Desmond Hong' ,`ListOfficeName` = 'Newfoundland Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682718' ,`Longitude` = '-95.597846' ,`PhotoCount` = '16' ,`PostalCode` = '77099' ,`RoomCount` = '8' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Bexley' ,`StreetNumber` = '12326' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well kept 3-2-2 in this quite community, lots of up-grades, hardiprank  siding, new electric box, cast iron bath tub in each bathroom, cover patio, and a lot more. Close to school, retail centers, and easy access to high way 6, belt way 8. Excellent for investment and first time buyer.' ,`Acres` = '0.1641' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 16 BROOKFIELD SEC 1 R/P A & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '218' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookfield Sec 01 R/P A & Ext' ,`TaxAmount` = '3594' ,`TaxRate` = '2.4711' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973918' WHERE `Matrix_Unique_ID` = '197813184'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T21:08:41.417' ,`MLSNumber` = '52972816' ,`ListAgentFullName` = 'Desmond Hong' ,`ListOfficeName` = 'Newfoundland Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682082' ,`Longitude` = '-95.600959' ,`PhotoCount` = '16' ,`PostalCode` = '77099' ,`RoomCount` = '8' ,`ListPrice` = '291000.00' ,`Status` = 'Active' ,`StreetName` = 'Shannon Hills' ,`StreetNumber` = '12510' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 3-2-2 ready for move-in, house is completely remodeled, new lightings, new heater, new electric panel box, GFIC outlet, new plumbing system with prex water line, new paint , new hardy panel sidings for the whole house. House is ready for summer heat and winter storm. Close to major freeway , school and shopping center.' ,`Acres` = '0.1667' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 13 BROOKFIELD SEC 1 R/P A & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '218' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookfield Sec 01 R/P A & Ext' ,`TaxAmount` = '3716' ,`TaxRate` = '2.4711' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973919' WHERE `Matrix_Unique_ID` = '199277364'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T21:47:05.560' ,`MLSNumber` = '66883771' ,`ListAgentFullName` = 'Oscar Cruz' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147001' ,`Longitude` = '-95.717913' ,`PhotoCount` = '7' ,`PostalCode` = '77355' ,`RoomCount` = '6' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'WAGON WHEEL RD' ,`StreetNumber` = '16401' ,`StreetSuffix` = '' ,`City` = 'Stagecoach' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2757' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new custom home under construction. Conveniently located close to Tomball, Magnolia and the Woodlands. Nestled in Stagecoach Farms, a serene restricted neighborhood filled with wildlife, trees, parks and picturesque lakes. 4 large bedrooms, 2 full baths, 2 half baths, Game room, Family area. On a 15,000SQFT lot high and dry.' ,`Acres` = '0.3444' ,`Area` = '15' ,`BuilderName` = 'NEH BUILDER LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'STAGECOACH FARMS 09, LOT 357, ACRES 0.340' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'J.L. LYON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Stagecoach Farms 09' ,`TaxAmount` = '396' ,`TaxRate` = '2.2954' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668973919' WHERE `Matrix_Unique_ID` = '205893362'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T21:14:20.777' ,`MLSNumber` = '35539753' ,`ListAgentFullName` = 'Walter Serna' ,`ListOfficeName` = 'W & G Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795675' ,`Longitude` = '-95.156563' ,`PhotoCount` = '8' ,`PostalCode` = '77530' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunster' ,`StreetNumber` = '14910' ,`StreetSuffix` = 'Lane' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully landscaped 2 story home in Channelview. Open concept living great for gatherings features large backyard w plenty of shade perfect for entertaining or outdoor activities. Soaring ceilings in the entry w tons of natural light. Eat in kitchen boast ample Calcutta marble slab laminate counters, ss appliances & plenty of cabinet storage space. Large living room features wood burning fireplace & wood flooring. Spacious master suite offers plush carpet, upgraded master bath & wood look tile flooring. This home features 3 bedrooms and 2 full baths & spacious flex room perfect for 4th bedroom or game room. This home has easy access to Beltway 8 & updated with wood flooring throughout the entire home. This home is a must see! Schedule your showing today!! NO FLOODING!!! Roof replaced 5years ago!' ,`Acres` = '0.11' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 59 BLK 1 STERLING GREEN SOUTH SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'HAMBLEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Sterling Green South Sec 01 R/' ,`TaxAmount` = '5264' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973919' WHERE `Matrix_Unique_ID` = '208883551'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T20:18:57.433' ,`MLSNumber` = '23938833' ,`ListAgentFullName` = 'Mya Carroll' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.110211' ,`Longitude` = '-93.734841' ,`PhotoCount` = '6' ,`PostalCode` = '77630' ,`RoomCount` = '9' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = '5th' ,`StreetNumber` = '2017' ,`StreetSuffix` = 'Street' ,`City` = 'Orange' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home is located in Orange County on a large cul-de-sac lot with a cozy porch and huge back yard, extended driveway on the side of garage. Beautiful country style kitchen with tiled floors and new counter tops. Wood floors throughout the remainder of the house. Spacious bedrooms with walk-in closets.\r\n\r\nConveniently located near Interstate-10 (I-10), 30 minutes from Louisiana and Casinos.\r\n\r\nThis home has a lot of interests. Make an appointment today!' ,`Acres` = '0.313' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 6 BLK 1 JEFFREY OAKS' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '13634' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '270 - West Orange-Cove Consolidated' ,`SchoolElementary` = 'WEST ORANGE-STARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST ORANGE-STARK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST ORANGE-STARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jeffery Oaks' ,`TaxAmount` = '3410' ,`TaxRate` = '2.779' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973919' WHERE `Matrix_Unique_ID` = '210506677'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T21:10:55.717' ,`MLSNumber` = '784879' ,`ListAgentFullName` = 'Obed Romero' ,`ListOfficeName` = '2M Realty Advisors, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080643' ,`Longitude` = '-95.457575' ,`PhotoCount` = '35' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Hannover Valley' ,`StreetNumber` = '2415' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home on Hannover Village Subdivision close to The Gran Parkway and I-45 Zoned to Klein ISD and close to plenty shopping, dining and entertainment\r\nThis home offer open concept living room-upgraded kitchen with Granite countertops and stainless-Steel appliances\r\n perfect for entertaining, formal dining and office.\r\nUpstairs you will find a large game room with four bedroom and two full bathrooms. The inviting backyard offer covered patio and full landscaping with sprinkler system. Home never flooded.' ,`Acres` = '0.1452' ,`Area` = '14' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 HANNOVER VILLAGE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hannover Village Sec 03' ,`TaxAmount` = '6736' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973919' WHERE `Matrix_Unique_ID` = '210816096'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T20:44:54.250' ,`MLSNumber` = '4412040' ,`ListAgentFullName` = 'Naila Duran' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880021' ,`Longitude` = '-95.320244' ,`PhotoCount` = '6' ,`PostalCode` = '77093' ,`RoomCount` = '3' ,`ListPrice` = '199990.00' ,`Status` = 'Active' ,`StreetName` = 'Hopper' ,`StreetNumber` = '4529' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION!! Great investment property for residential or commercial use. No restrictions!! Includes home & workshop needing remodel or rebuild. With easy access to Highway 59 & approximately 15 min from Downtown Houston. Fully fenced with no back neighbors!! Schedule your showing today!!' ,`Acres` = '0.2107' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 1 INWOOD PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '9180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ESCAMILLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'HAMBRICK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Inwood Place' ,`TaxAmount` = '619' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973920' WHERE `Matrix_Unique_ID` = '211020196'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T20:56:44.573' ,`MLSNumber` = '92840489' ,`ListAgentFullName` = 'Delilah McKenna' ,`ListOfficeName` = 'McKenna Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.720465' ,`Longitude` = '-95.443258' ,`PhotoCount` = '24' ,`PostalCode` = '77005' ,`RoomCount` = '3' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Judson' ,`StreetNumber` = '4102' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great contemporary home. Zoned to sought after West U Elementary. New roof, new exterior paint, updates to the kitchen. Split level floor plan with primary bedroom suite downstairs. Large open living area, formal dining area and guest bath are on the first floor. Upper level has a second living area/den, two roomy bedrooms and full bath. Tall ceilings in the living areas. Large covered patio in the back. Easy care garden. Available now. (please verify schools and room dimensions).' ,`Acres` = '0.1295' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 22 COLLEGE COURT PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'College Court Place' ,`TaxAmount` = '12128' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973920' WHERE `Matrix_Unique_ID` = '211021920'  --> Updated record success<br />