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-06T09:01:29.973' ,`MLSNumber` = '55250729' ,`ListAgentFullName` = 'Cecilia Pineda' ,`ListOfficeName` = 'CJM Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785602' ,`Longitude` = '-95.338304' ,`PhotoCount` = '14' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Des Chaumes' ,`StreetNumber` = '2622' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '7' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Houses  located in a corner lot in Downtown! Great investment property, 1 of the 3 houses has been completely remodeled, the other 2 need TLC.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 23 FOSTERS SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fosters Sec 01' ,`TaxAmount` = '2571' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695086' WHERE `Matrix_Unique_ID` = '203502186'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T09:02:10.343' ,`MLSNumber` = '24079325' ,`ListAgentFullName` = 'Dinora Flores' ,`ListOfficeName` = 'Texcom Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.922684' ,`Longitude` = '-95.304674' ,`PhotoCount` = '6' ,`PostalCode` = '77032' ,`RoomCount` = '0' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'E' ,`StreetNumber` = '14101' ,`StreetSuffix` = 'Freeway' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '0' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner lot on feeder of 59Hwy, was used as commercial. Drive by showing only, do not enter the property. Negotiable Make an offer!' ,`Acres` = '0.4098' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 258A & 259A PARKWOOD ESTATES SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '17850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JOHNSON ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'ALDINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Seller' ,`Stories` = '0' ,`Style` = 'Other Style' ,`Subdivision` = 'Parkwood Estates Sec 01' ,`TaxAmount` = '4986' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663695086' WHERE `Matrix_Unique_ID` = '207572317'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T09:55:41.103' ,`MLSNumber` = '23120319' ,`ListAgentFullName` = 'Tracy Henderson' ,`ListOfficeName` = 'The Realty Partnership, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.441824' ,`Longitude` = '-95.106874' ,`PhotoCount` = '30' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon Valley' ,`StreetNumber` = '3070' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Persimmon is associated with good luck and longevity. So come enjoy a long life in this sweet home! Well maintained Energy Star Lennar-built home with TechShield. Fabulously large backyard over 8500 sq. ft. Pool-sized and dreamscape ready! Two-story 4 bedroom and 2.5 bath home positioned with no direct backyard neighbors. Move-in ready. Granite countertops, stainless steel appliances with a refrigerator and washer and dryer.  Just minutes from local shopping and eateries! In a preferable flood zone, never flooded. Don\'t want to miss this one! Call us for a personal tour.' ,`Acres` = '0.1966' ,`Area` = '33' ,`BuilderName` = 'LennarHomes/VillageB' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ENCLAVE AT BAY COLONY WEST SEC 1 PH II (2013) ABST 19, BLOCK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8565' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave At Bay Colony West Sec' ,`TaxAmount` = '8007' ,`TaxRate` = '3.4497' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695087' WHERE `Matrix_Unique_ID` = '208995699'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T08:05:28.513' ,`MLSNumber` = '55354971' ,`ListAgentFullName` = 'Katy Pugh' ,`ListOfficeName` = 'Hodde Real Estate Company' ,`SellingAgentFullName` = 'Samantha Medve' ,`SellingOfficeName` = 'Schultz Texas Properties' ,`Latitude` = '30.151297' ,`Longitude` = '-96.374095' ,`PhotoCount` = '21' ,`PostalCode` = '77833' ,`RoomCount` = '7' ,`ListPrice` = '450000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Basin' ,`StreetNumber` = '1804' ,`StreetSuffix` = 'Trail' ,`City` = 'Brenham' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the prettiest homes in Ralston Creek!  Loaded with upgrades inside and out, the 4 sided brick/stone home offers 2350 sq/ft, 4 bedrooms, 3 bathrooms, 2 car garage  located on an oversized cul-de-sac lot with no back neighbors. Interior highlights inside include beautiful wood look tile plank flooring throughout entire home, double crown molding in main living areas, 10\' ceilings, lots of windows for great lighting, and ceiling fans throughout.  The expansive open floor plan is perfect for entertaining family and friends. The kitchen features beautiful granite, lots of storage, island with custom pot rack.  Primary bedroom is very spacious and bathroom features granite counters, double sinks, large shower, soaking tub and nice sized walk-closet.  Outside, relax on the extended covered patio while enjoying the beautiful backyard.  The 12x24\' workshop is airconditioned.  \r\nThis home is so impressive, immaculately maintained with close proximity to all that Brenham has to offer!' ,`Acres` = '0.25' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S4885 - RALSTON CREEK ESTATES, BLOCK 6, LOT 22, ACRES 0.25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ralston Creek Estates' ,`TaxAmount` = '7202' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695087' WHERE `Matrix_Unique_ID` = '209556912'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T08:06:19.693' ,`MLSNumber` = '90865689' ,`ListAgentFullName` = 'Yadira Villarreal' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.148681' ,`Longitude` = '-94.644118' ,`PhotoCount` = '8' ,`PostalCode` = '77564' ,`RoomCount` = '2' ,`ListPrice` = '74500.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2431' ,`StreetNumber` = '175' ,`StreetSuffix` = '' ,`City` = 'Hull' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR SPECIAL, HOME IS IN NEED OF REPAIRS.\r\nPROPERTY SELLING AS IS, WHERE IS.' ,`Acres` = '0.1148' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PHILLIPS, BLOCK 6, LOT 3 4, ACRES .1148' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '108 - Hull-Daisetta' ,`SchoolElementary` = 'HULL-DAISETTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HULL-DAISETTA HIGH SCHOOL' ,`SchoolMiddle` = 'HULL-DAISETTA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Phillips' ,`TaxAmount` = '1230' ,`TaxRate` = '1.8081' ,`WaterSewer` = 'Other Water/Sewer,Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695087' WHERE `Matrix_Unique_ID` = '210265947'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T08:25:57.087' ,`MLSNumber` = '14389452' ,`ListAgentFullName` = 'Zachary Davies' ,`ListOfficeName` = 'The Cox Company Real Estate Gr' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.800033' ,`Longitude` = '-95.106416' ,`PhotoCount` = '16' ,`PostalCode` = '77360' ,`RoomCount` = '1' ,`ListPrice` = '79000.00' ,`Status` = 'Active' ,`StreetName` = 'Gnu' ,`StreetNumber` = '112' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This studio style home is located in a water view subdivision with a public pool for residing residents. Open concept home with loft. Front new porch makes for a nice way to sit enjoy your day. Just down the street from the subdivision\'s waterfront park with boat ramp.' ,`Acres` = '0.0845' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 5 BLK 10 LOT 1' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '3680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Impala Woods Sec 5' ,`TaxAmount` = '488' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695087' WHERE `Matrix_Unique_ID` = '210376689'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T09:07:22.350' ,`MLSNumber` = '95583829' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.168231' ,`Longitude` = '-95.191075' ,`PhotoCount` = '10' ,`PostalCode` = '77357' ,`RoomCount` = '10' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Camellia Birch' ,`StreetNumber` = '23623' ,`StreetSuffix` = 'Court' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular NEW Lennar Homes Wildflower Series, \'\'Dewberry II\'\' Plan Elevation \'\'A\" in beautiful Tavola! Awesome 2 Story 5 bedroom 3.5 bath 2 car garage with Game Room Room up! Kitchen w/ Breakfast Area, Great Appliance Pkg, 36\'\' Designer Cabinets & Sparkling Countertops! Large Walk-in Pantry. Spacious Family Room and Study! Primary Suite down with large Walk-in Closet! Extensive Hard Surface Floors; Covered Rear Patio, Fully Sodded Yard; 16 SEER HVAC System & More!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0037 BLK 002 LOT 025' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.5826' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695087' WHERE `Matrix_Unique_ID` = '211016959'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T09:09:13.933' ,`MLSNumber` = '78861466' ,`ListAgentFullName` = 'Emily Wang' ,`ListOfficeName` = 'Intown Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816086' ,`Longitude` = '-95.507832' ,`PhotoCount` = '9' ,`PostalCode` = '77080' ,`RoomCount` = '8' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Kolbe' ,`StreetNumber` = '8720' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ELEVATOR LAKEVIEW 4 BEDROOM HOME w/ FANTASTIC VIEWS and OUTDOOR AREAS!!!  THIS is the LAST CHANCE to get a NEW CONSTRUCTION home on the SOUTHSIDE of the LAKE in KOLBE FARMS.   FENCED-IN FRONT YARD  opens to TRAILS AROUND the 3 ACRE LAKE/PARK AREA!    YOU get TWO sets of the MAGNIFICENT TRI-PANELD GLASS DOORS: 1) LAKESIDE LIVING ROOM BALCONY 2) LAKESIDE COVERED TERRACE off from GAMEROOM. 8720 OAK KOLBE is DECKED OUT: 48 INCH Gas Range, INSET+SOFT CLOSING CABINETRY, 12 FT Living Room Ceilings, SOPHISTICAED ELECTRIC FIREPLACE - You can change the FLAME COLOR, WIDE PLANK WOOD Flooring - Living Area, Stairs, First Floor Bedroom & Primary Bedroom,  FREE STANDING TUB,  DOUBLE SEATED SHOWER + so MUCH MORE!  YOU NEED TO SEE KOLBE FARMS -40 ACRE COMMUNITY; ANTI- COOKIE CUTTER - 100 FLOOR PLANS built so far.  KOLBE has Lake, Trails, Two Pools, Dog Park, Courtyards, Galvanized Bridge, Gated, Gate Station is Manned at Night!  8720 is estimated to be finished in SPRING 2023.  REMEMBER LAST CHANCE!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 4 KOLBE FARMS' ,`LotDesciption` = 'Water View' ,`LotSize` = '1950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Kolbe Farms' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695087' WHERE `Matrix_Unique_ID` = '211129496'  --> Updated record success<br />