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` = '2023-01-04T12:57:48.013' ,`MLSNumber` = '84123810' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.848270' ,`Longitude` = '-95.442594' ,`PhotoCount` = '11' ,`PostalCode` = '77367' ,`RoomCount` = '2' ,`ListPrice` = '49900.00' ,`Status` = 'Active' ,`StreetName` = 'Witchita' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Circle' ,`City` = 'Riverside' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy fishing cabin is a diamond in the rough hidden in the woods. Surrounded by the natural spoils of Caney Creek, Lake Livingston, and the Trinity River; after spending the whole day out you\'ll return to your little cabin. Be welcomed by the large wooden porch and rest on the built on bench. Freely walk through the very open floor plan. Feel the warmth and abundance of the sunlight beaming through the windows. Add a ladder inside and climb up to a small elevated space with a window. Perfect for relaxing and gazing up at the stars.' ,`Acres` = '0.3973' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'No Heating,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'REDSKIN RIDGE - SEC 2, BLOCK 1, LOT 76' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '17308' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Redskin Ridge - Sec 2' ,`TaxAmount` = '58' ,`TaxRate` = '1.776' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103228' WHERE `Matrix_Unique_ID` = '184444781'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T11:55:03.077' ,`MLSNumber` = '62023086' ,`ListAgentFullName` = 'Tyrone Hamilton' ,`ListOfficeName` = 'Hamilton Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739228' ,`Longitude` = '-95.355601' ,`PhotoCount` = '8' ,`PostalCode` = '77004' ,`RoomCount` = '2' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Gray' ,`StreetNumber` = '3016' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on a quiet street close to downtown,  The open floor concept offers lots of natural light, a large living room, a brick fireplace, and wood flooring!  The home is conveniently located next to downtown with easy access to downtown, UH, TSU, and the Medical Center.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 4 PIERCE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pierce Court' ,`TaxAmount` = '2357' ,`TaxRate` = '2.5144' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675103228' WHERE `Matrix_Unique_ID` = '200253280'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T11:43:56.040' ,`MLSNumber` = '29034348' ,`ListAgentFullName` = 'Traci Ethington' ,`ListOfficeName` = 'Covenant Properties RealEstate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.164386' ,`Longitude` = '-95.630214' ,`PhotoCount` = '47' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '316' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful new-built home has been built by a local builder. This is a 4/5 bedroom, 2 1/2 bath house with a large upstairs game room/media room with surround sound and computer/study niche off the landing area. The spacious kitchen has granite counters on custom-built cabinets with soft-close doors, and the kitchen opens to the large living area. The great room will feature surround sound speakers. All bathrooms will have granite countertops. The house has PEX plumbing and spray-foam insulation for extra insulation for the summer months. The primary bath has a jetted tub and a separate shower. The primary bedroom has 2 walk-in closets with built-ins. There is a laundry chute directly into the utility room. This house backs up to the green space which is part of the golf course so there are no back neighbors, and there is a separate garage for the golf cart. There are amenities here not found in other homes in the area. Make an appointment to see all that this house has to offer.' ,`Acres` = '0.2296' ,`Area` = '5' ,`BuilderName` = 'Randy Roberts Constr' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 4 (A0133 M VARNER) BLK 41 LOT 38' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '10001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '328' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675103229' WHERE `Matrix_Unique_ID` = '205530585'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T12:08:45.713' ,`MLSNumber` = '27027705' ,`ListAgentFullName` = 'Garrett Mohnke' ,`ListOfficeName` = 'Complete Property Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162075' ,`Longitude` = '-95.568890' ,`PhotoCount` = '46' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Oak' ,`StreetNumber` = '27514' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living close to town! Custom built home meticulously maintained and in near new condition. 14 foot cielings    and LED recessed lighting throughout. Freshly updated master bath includes premium custom built white ash finishes and over size master shower. Barn theme accents throughout. Three full baths. Premium laundry equipment. Two year old well and septic, 4 year old roof, freshly updated and painted inside & out. One of two HVAC systems just installed. Expansive decking behind home overlooking wooded area. 30x40 commercial quality workshop with dedicated power panel, high cielings, front and back over sized bay doors. Previous owner had an auto refurbishing business here. Super low taxes and great schools. Easy access to the Woodlands Parkway.' ,`Acres` = '0.931' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connec