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-17T06:33:55.970' ,`MLSNumber` = '85611075' ,`ListAgentFullName` = 'Darren Upp' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781212' ,`Longitude` = '-95.369568' ,`PhotoCount` = '6' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Wrightwood' ,`StreetNumber` = '1218' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom, 2 bath. Has detached 1 car garage. Close to downtown & bayou. Located in the 100 year flood plain and property has previously flooded. Serious buyers only.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 WRIGHTWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wrightwood' ,`TaxAmount` = '' ,`TaxRate` = '2.330662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1904' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663699735' WHERE `Matrix_Unique_ID` = '188979737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T07:44:59.170' ,`MLSNumber` = '5595568' ,`ListAgentFullName` = 'Clinton Butler' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858980' ,`Longitude` = '-95.420929' ,`PhotoCount` = '19' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Morrow' ,`StreetNumber` = '6819' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention Investors, Builder and Developers! Looking for a prime real estate land for new development in a great up and coming area? Home was used for a personal care physicility. Kitchen was recently updated. Verify room and lot sizes. Home has alot to offer to that special buyer.' ,`Acres` = '0.6107' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 24A & 25A BLK 29 HIGHLAND HEIGHTS ANNEX SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Highland Heights Annex Sec 06' ,`TaxAmount` = '4889' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699736' WHERE `Matrix_Unique_ID` = '208275694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T07:04:14.567' ,`MLSNumber` = '10031702' ,`ListAgentFullName` = 'Michael Cordray' ,`ListOfficeName` = 'Save 1900 Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.290346' ,`Longitude` = '-94.819539' ,`PhotoCount` = '41' ,`PostalCode` = '77551' ,`RoomCount` = '10' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Lawn' ,`StreetNumber` = '22' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built in 1939, this classic American colonial impresses at every turn; welcome to the stately 22 Cedar Lawn North. Located in one of Galveston\'s most prestigious and desired neighborhoods on a massive 17,400 sq ft lot, this home commands attention. Featuring 4 beds and 3.5 baths, this home was recently renovated including, plumbing, electrical, and HVAC among other things. The home has expansive rooms complimenting the scale of the exterior. There is a dedicated office, as well as a large den perfect for relaxing or entertaining around the well appointed wet bar. The fully built out, air conditioned attic space features a full bath and is perfect for a game room, kids, or bonus space and is not included in CAD square footage. The 720 sq ft garage apartment has also been renovated and features 2 beds, 1.5 baths and a dedicated workspace. The garage below has parking for two and ample built out storage. Both the garage and apartment can be accessed conveniently from 48th street.' ,`Acres` = '0.3994' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 52 & 53 & 8 FT OF ADJ SIDEWALK' ,`LotDesciption` = 'Cleared' ,`LotSize` = '17400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Cedar Lawn' ,`TaxAmount` = '10859' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699736' WHERE `Matrix_Unique_ID` = '210204954' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T06:58:11.800' ,`MLSNumber` = '85928230' ,`ListAgentFullName` = 'Rochelle Lauve' ,`ListOfficeName` = 'O\'Hara & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066087' ,`Longitude` = '-95.206552' ,`PhotoCount` = '15' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Spruce Glen' ,`StreetNumber` = '3811' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home on cul-de-sac lot. 4 bedroom, 2.5 bath, 2448 sq ft, two story home with two car garage. Plenty of space for second living room, study or down stairs game room. Resurfaced kitchen cabinets, granite throughout, new revamped fireplace, new laminate flooring, tile and carpet in the bedrooms. Every bathroom is renovated including the master suite with a massive walk in closet. Newer electrical panel, one year old roof with transferable warranty. Desirable schools and so convenient to shopping, 59 and Grand Parkway. Come see it today, this one won\'t last long!' ,`Acres` = '0.2324' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 37 HUNTERS RIDGE VILLAGE SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Hunters Ridge Village Sec 03' ,`TaxAmount` = '5519' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699736' WHERE `Matrix_Unique_ID` = '210716745' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T07:41:46.250' ,`MLSNumber` = '52692665' ,`ListAgentFullName` = 'Joan Imperato' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.030936' ,`Longitude` = '-95.182400' ,`PhotoCount` = '37' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'Island Green' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*HIGH AND DRY*ONLY HOME IN KINGWOOD GREENS & ON ANY GOLF COURSE IN KINGWOOD THAT DID NOT FLOOD**True pride of ownership*Ideally set at the end of a quiet cul de sac, overlooking the 7th hole of the Forest Course of the Kingwood Country Club*As you enter, enjoy the fabulous views thru the stunning dining room windows, covered patio & the second floor balcony*Oak Wood flooring from the entry, thru the hall & into the dining room &secluded study*Private primary bedroom & bath w/spacious closets, 2 vanities w/ granite counters, separate shower & jetted tub*2nd bedroom & bath down*3 bedrooms, 2 baths & GR up* Lovely mouldings & trim*Great storage*Texas basement*Extensive custom cabinetry & granite counters in the kitchen, Travertine flooring*Appliances replaced 2014*Sub-zero refrigerator*2 ovens, 2 microwaves*Solar powered fan in the attic*Insulation replaced*Plantation shutters*Roof 2018*Safe*HVAC system updated* Fabulous 3 car garage plus Tandem*Generator*By appointment*Accompanied*A GEM!' ,`Acres` = '0.382' ,`Area` = '32' ,`BuilderName` = 'Larry Jaeger' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 KINGWOOD GREENS VILLAGE SEC 4' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course' ,`LotSize` = '16640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Greens Village' ,`TaxAmount` = '18974' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699736' WHERE `Matrix_Unique_ID` = '211198246' --> Updated record success