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-11T09:29:55.890' ,`MLSNumber` = '59890390' ,`ListAgentFullName` = 'Joseph Peterson' ,`ListOfficeName` = 'Briko Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033692' ,`Longitude` = '-94.672500' ,`PhotoCount` = '6' ,`PostalCode` = '77535' ,`RoomCount` = '6' ,`ListPrice` = '110484.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 122' ,`StreetNumber` = '43' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ON GOING AUCTION Auction properties are sold AS IS /SIGHT UNSEEN without any guarantee or\r\nwarranty by seller. Property may be occupied.' ,`Acres` = '0.8798' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RAYWOOD, BLOCK D, LOT TR 3, ACRES .8798, MH LABEL# PFS103262' ,`LotDesciption` = 'Other' ,`LotSize` = '38324' ,`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' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Raywood' ,`TaxAmount` = '1394' ,`TaxRate` = '2.0606' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669011064' WHERE `Matrix_Unique_ID` = '200432606'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:02:09.670' ,`MLSNumber` = '74034682' ,`ListAgentFullName` = 'Lylian Alfaro' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045850' ,`Longitude` = '-95.624576' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '1900000.00' ,`Status` = 'Active' ,`StreetName` = 'Boudreaux' ,`StreetNumber` = '13845' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '. No restrictions!! Could be commercial!!plus 6250 sq. ft. External building is warehouse, office, with central AC. Commercial.Country Home set on 3 acres w/pond & big city amenities!! NO FLOODING!!Front & back covered porches. 4 bedrooms each w/private baths, open game room,  & study w/french doors or 4th bedroom. Large master bedroom downstairs w/French doors to back porch. His/Hers vanities, soaker tub, separate shower in master bath. High ceiling in living room open to 2nd story game room. Kitchen has granite tops & SS 5-burner gas range. Large utility w/built in cabinets and granite counter top. Private stairs lead to /gameroom/private office. We privet Pool The outside space is amazing & easy to maintain. Stocked pond with gazebo that has electricity & water. You even get to have chickens!!!   This is a must see if you are wanting to have country living but need to be close to the amenities of life. Tomball ISD. No mud taxes' ,`Acres` = '3.004' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1G-1 ABST 296 E GIRARD' ,`LotDesciption` = 'Other' ,`LotSize` = '130855' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Girard Emile' ,`TaxAmount` = '9648' ,`TaxRate` = '2.0264' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669011064' WHERE `Matrix_Unique_ID` = '208068912'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T08:40:46.843' ,`MLSNumber` = '83495918' ,`ListAgentFullName` = 'Latisha Bradshaw' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.496347' ,`Longitude` = '-94.930274' ,`PhotoCount` = '16' ,`PostalCode` = '77539' ,`RoomCount` = '2' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue C' ,`StreetNumber` = '1918' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no more for your own oasis in Sunny San Leon. Close  to the water where you can sit on the porch and smell the salty air. This home has Mature trees for shade on these hot Texas Days. A  beautiful  2 bedroom 1 bath  on 4 lots completely fenced in yard. The porch wraps around the whole house where you can entertain guests and enjoy the view all around.   Property also has an extra light pole for a RV hookup or possibly mobile home. Measurements are not accurate so please measure if you need exact measurements. Home is sold as is with seller not doing any repairs. Seller will pay some of buyers concessions.' ,`Acres` = '0.3076' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOT 1 TO 4 BLK 40 SAN LEON FEMA TRAILER' ,`LotDesciption` = 'Corner' ,`LotSize` = '13400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '4082' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669011064' WHERE `Matrix_Unique_ID` = '209313507'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-11T09:29:52.987' ,`MLSNumber` = '57442304' ,`ListAgentFullName` = 'Teresa Hill' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.765790' ,`Longitude` = '-95.058650' ,`PhotoCount` = '21' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '479720.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Pines' ,`City` = 'Livingston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home overlooking Lake Livingston has been designed to amplify your lake experience from each vantage point.  Granite counter tops in the Kitchen and Bathrooms, custom porcelain tile in Kitchen and Bathrooms, Vinyl (waterproof) planking throughout the home. Your new water-view home gives you unobstructed access to this scenic oasis.  Dimensions to be verified.  Upgrade options are available.  Luxury living on Lake Livingston, your piece of paradise is waiting for you.' ,`Acres` = '0.164' ,`Area` = '44' ,`BuilderName` = 'Owner/Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PINWAH PINE SECTION 1 BLK 2 LOT 24' ,`LotDesciption` = 'Cul-De-Sac,Water View' ,`LotSize` = '7372' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`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` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinwah Pine #1' ,`TaxAmount` = '142' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669011064' WHERE `Matrix_Unique_ID` = '210977754'  --> Updated record success<br />