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-09-14T00:20:40.540' ,`MLSNumber` = '59416908' ,`ListAgentFullName` = 'Maria Hernandez' ,`ListOfficeName` = 'City Insight Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708808' ,`Longitude` = '-95.166367' ,`PhotoCount` = '18' ,`PostalCode` = '77503' ,`RoomCount` = '4' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Washington' ,`StreetNumber` = '3209' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful house is in the deepwater subdivision. This property has been recently renovated with new laminate flooring, New paint inside and out, updated light fixtures, updated bathrooms and windows. This house does come with washer and dryer connections and a very large driveway, Call now to schedule your showing!' ,`Acres` = '0.1354' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 31 BLK 4 DEEPWATER TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEEPWATER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEEPWATER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Deepwater Terrace Sec 02' ,`TaxAmount` = '2489' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710301' WHERE `Matrix_Unique_ID` = '210472132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T00:20:40.447' ,`MLSNumber` = '50969603' ,`ListAgentFullName` = 'William Barrera' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Jeffrey Morrison' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.671154' ,`Longitude` = '-95.446166' ,`PhotoCount` = '31' ,`PostalCode` = '77025' ,`RoomCount` = '7' ,`ListPrice` = '310000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bassoon' ,`StreetNumber` = '10130' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1127' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled home is move-in ready! Just outside the loop and close to the Medical Center, NRG Stadium, the Galleria and Downtown. Owner renovated home for himself. Open concept. Gorgeous kitchen was completely redone with granite counters and self closing drawers and cabinet doors. Restroom was completely remodeled as well. Original wood floors have been refinished, tile in kitchen and breakfast area. No carpet! New roof 2 months ago. New double pane windows, new appliances and hood. Freshly painted inside and out, lush landscaping, new backyard fence and new French doors lead to the backyard patio. Nice size backyard. Home is ready for you to make new memories!' ,`Acres` = '0.1791' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 WESTWOOD SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Sec 05' ,`TaxAmount` = '3356' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710301' WHERE `Matrix_Unique_ID` = '211045373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T01:57:03.320' ,`MLSNumber` = '41994807' ,`ListAgentFullName` = 'Mary Markwardt' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.499673' ,`Longitude` = '-95.442193' ,`PhotoCount` = '30' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Windy Knoll' ,`StreetNumber` = '5705' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2259' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 4 bedroom one story with spacious open floor plan. Home has fresh custom interior paint throughout! No need for any touchups here. The living room, dining room and kitchen are open and flowing offering a great space for entertaining. Brand new luxury vinyl plank flooring and new carpet installed August, 2022. There is an ample sized covered back patio with an extended wooden deck which is the perfect setting for reading, cranking up the grill or even dancing! A little music and twinkle lights and you\'re set! No power lines on this lot. \r\nLakes of Savannah offers two pools, two club houses, splash pad, parks, ponds & miles of sidewalks. Located near Hwy. 6 and Hwy. 288. Just minutes to Pearland Town Center. Neighborhood did NOT lose power during the big freeze of 2021! Welcome HOME!' ,`Acres` = '0.1589' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH RIDGE SEC 1 (A0403 ACH&B), BLOCK 2, LOT 36, ACRES 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6922' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '6985' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710301' WHERE `Matrix_Unique_ID` = '211454836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T00:27:44.950' ,`MLSNumber` = '56237494' ,`ListAgentFullName` = 'Blanca Llanez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015129' ,`Longitude` = '-95.320974' ,`PhotoCount` = '23' ,`PostalCode` = '77338' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Glen' ,`StreetNumber` = '20307' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 3/2/2 one-story. Open floor plan - great for your family and guests. Move-in ready. Enjoy preparing meals in your updated, new gorgeous kitchen with granite counters, tiled backsplash, and cabinets galore. New wine-fridge. Appliances about 3 years old. Fridge stays. Hall bath room also completely remodeled with amazing new shower. A/c unit and central heat were replaced. Other new items: Sliding patio door, kitchen sink and faucet. New Roof 2019. Primary bedroom has an additional 8x10 space for study, office, nursury, etc. There\'s also a nice private patio outside the primary bedroom. All walk-in closets in bedrooms. Measurements are approximate - please verify all measurements and information. Relax and enjoy the outdoors on your huge back yard deck, great for entertaining. Located in established neighborhood. Just a few blocks to the community center. Convenient location close to Bush airport, shopping, freeways. Come see and make this your new home!' ,`Acres` = '0.1612' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 5 FOXWOOD SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '325' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood Sec 02' ,`TaxAmount` = '4377' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710301' WHERE `Matrix_Unique_ID` = '211597825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T01:41:46.143' ,`MLSNumber` = '76260263' ,`ListAgentFullName` = 'Leslee Smith' ,`ListOfficeName` = 'Jerry Fullerton Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152239' ,`Longitude` = '-95.381584' ,`PhotoCount` = '35' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Blaine Oaks' ,`StreetNumber` = '3786' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this beautifully built and well-maintained home in the desirable Falls at Imperial Oaks neighborhood! This home features high ceilings, custom interior paint, and a separate upstairs Gameroom. The wood flooring, built-in speakers, upgraded granite countertops and covered patio with retractable screens are quality upgrades that any owner would love. The energy efficient tankless water heater and insulated windows are also special features to consider. This home is move-in ready with the washer, dryer, and refrigerator all included! This property\'s ideal community includes a resort style pool, park, trails, picnic areas, tennis courts, sand volleyball courts, a club house and much more!' ,`Acres` = '0.1408' ,`Area` = '15' ,`BuilderName` = 'Ryland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504206 - FALLS AT IMPERIAL OAKS 06, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks' ,`TaxAmount` = '8408' ,`TaxRate` = '3.0687' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710301' WHERE `Matrix_Unique_ID` = '211789994' --> Updated record success