Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T11:33:25.567' ,`MLSNumber` = '75146220' ,`ListAgentFullName` = 'Gary Powers' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839956' ,`Longitude` = '-94.385828' ,`PhotoCount` = '13' ,`PostalCode` = '77665' ,`RoomCount` = '1' ,`ListPrice` = '95000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake' ,`StreetNumber` = '225' ,`StreetSuffix` = 'Drive' ,`City` = 'Winnie' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large, well built 30\' x 40\' building with a 2 car garage door with a plethora of additional storage. One 7.5\' x 14.5\' room that could make a small living area or the first room of a future barndominium. This would also make a great home base to be used for travelers. Enjoy the view of the neighbors pond and horses, while watching the activities of the famous Winnie Trade Days activities.' ,`Acres` = '0.2789' ,`Area` = '53' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 NORTH LAKE S/D' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '18 - East Chambers' ,`SchoolElementary` = 'EAST CHAMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EAST CHAMBERS HIGH SCHOOL' ,`SchoolMiddle` = 'EAST CHAMBERS J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'North Lake Sub' ,`TaxAmount` = '108' ,`TaxRate` = '2.1546' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974512' WHERE `Matrix_Unique_ID` = '205576988' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:27:12.600' ,`MLSNumber` = '15653041' ,`ListAgentFullName` = 'Jennifer Lerner' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666308' ,`Longitude` = '-95.451793' ,`PhotoCount` = '33' ,`PostalCode` = '77035' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tonawanda' ,`StreetNumber` = '4418' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4418 Tonawanda! The charming 4 bedroom, 2 bathroom home is located in the highly sought out Willow Meadows area, which is a short walk to Red Elementary School and the community pool, tennis courts and baseball fields. A short drive away is The Texas Medical Center, The Galleria and Downtown. Upon entering the home, is a very large living space and updated kitchen, which connects to an adorable sitting area with a wood burning fireplace. The kitchen has updated cabinetry and stainless steel appliances with stunning concrete floors. Updates include roof (2019), HVAC Unit (2016) and Water Heater (2021). All 4 bedrooms are in a separate wing of the house and each equipped with a nice sized closet. The outdoor living space is ideal for a family BBQ or entertaining space for friends. There is even on outdoor shower! NEVER FLOODED!' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 490 BLK 23 WILLOW BEND SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Willow Bend Sec 04' ,`TaxAmount` = '7186' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668974512' WHERE `Matrix_Unique_ID` = '209823413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:34:49.883' ,`MLSNumber` = '50136786' ,`ListAgentFullName` = 'Katherine McSwane' ,`ListOfficeName` = 'McSwane Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.727764' ,`Longitude` = '-96.206193' ,`PhotoCount` = '28' ,`PostalCode` = '75840' ,`RoomCount` = '3' ,`ListPrice` = '669000.00' ,`Status` = 'Active' ,`StreetName` = 'Pr 1295' ,`StreetNumber` = '117' ,`StreetSuffix` = '' ,`City` = 'Fairfield' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the city life! Custom home on 2+ acres located in private subdivision. This 3 bedroom, 2 bath home nestled among mature trees at the end of a quiet cul-de-sac offers open concept living area with high ceilings and windows which provide a picturesque view of the backyard. The spacious master suite features built-in cabinetry, large en suite bathroom, jetted garden tub with separate shower, and a 10 x 14 walk-in closet with built-ins for organized storage. The 2 secondary bedrooms are generous sizes. The backyard has a gorgeous in-ground heated pool, built-in water slide with rock waterfall, custom hot tub, and beach entry. Other features: gas log fireplace, granite counters, and fantastic scored concrete floors throughout the home. Oversized attached 2-car garage with storage closets and attic access. Detached workshop on slab foundation is plumbed and insulated with AC for projects and more storage. Sprinkler system, jetted septic system, and community water supply.' ,`Acres` = '2.41' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WILLOW CREEK FARMS LOT 12' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '104980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Creek' ,`TaxAmount` = '5972' ,`TaxRate` = '1.7349' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668974512' WHERE `Matrix_Unique_ID` = '210126429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T11:15:24.240' ,`MLSNumber` = '83069526' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.261058' ,`Longitude` = '-95.464189' ,`PhotoCount` = '29' ,`PostalCode` = '77515' ,`RoomCount` = '11' ,`ListPrice` = '778990.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Ranch' ,`StreetNumber` = '319' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Castlerock Communities highly sought-after Frisco plan is a beautiful, spacious 5 bedroom/4 bathroom, 2 story home that is situated on 1.62 acres! Your new home greets you with a 2 story grand entry that boasts a sweeping spiral staircase! Retreat into the study through 8ft double doors! The huge eat-in island kitchen features built-in stainless steel GE appliances and a large walk-in pantry! Engineered wood flooring throughout main living areas of 1st floor. Separate media and game room upstairs. Upgraded kitchen countertops, cabinets, and appliances! Upgraded 3 car garage with 8ft garage doors and a huge dedicated area for a shop or extra storage!' ,`Acres` = '1.62' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 5, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '70567' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974513' WHERE `Matrix_Unique_ID` = '210956810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T10:29:15.413' ,`MLSNumber` = '87621544' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349867' ,`Longitude` = '-95.535193' ,`PhotoCount` = '10' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '336135.00' ,`Status` = 'Active' ,`StreetName` = 'Newcomb Hollow' ,`StreetNumber` = '536' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME home to Hills of Westlake located just minutes from Lake Conroe and zoned to CONROE ISD. Enjoy easy access to I-45 and a quick commute to lots of great shopping and dining. Community offers a large community pool and playground. THIS NEW 4 bed, 2 bath home is loaded with LUXURY features -- GRANITE ISLAND, stainless steel appliances, breakfast bar, and 42\" modern cabinetry. Breakfast room off kitchen, open family room, Smart home package, & solid surface flooring throughout. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, large walk-in closet, frameless shower, and separate tub. Relaxing backyard featuring covered back patio!!! MAKE THE MOVE!!!' ,`Acres` = '0.148' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - Hills Of Westlake 02, BLOCK 1, Lot 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake' ,`TaxAmount` = '1297' ,`TaxRate` = '2.98' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668974513' WHERE `Matrix_Unique_ID` = '211054610' --> Updated record success