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-21T16:02:58.490' ,`MLSNumber` = '51614752' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Jared Turner' ,`SellingOfficeName` = 'Turner Mangum,LLC' ,`Latitude` = '30.249834' ,`Longitude` = '-95.521550' ,`PhotoCount` = '10' ,`PostalCode` = '77384' ,`RoomCount` = '5' ,`ListPrice` = '422535.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tunnel Tree' ,`StreetNumber` = '14424' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New MODERN SERIES DR Horton home on an OVERSIZED CORNER LOT! Beautiful one story home with 3 car garage. This new construction home features gorgeous brick & stucco exterior and includes 4 bed/3 bath and a 2 Car Garage! Features include SS appliances w/ 5 burner gas cooktop, Quartz Countertops, and 42\" Flat Cabinets in Kitchen, Separate shower, Smart Home Package, Solid Surface Flooring throughout, Tankless Water Heater, Covered Patio, and Full Sprinkler System. Fosters Ridge offers beautiful community center, playground, and pool. Zoned to The Woodlands Schools! DR Horton is America\'s #1 Homebuilder! Come out to Fosters Ridge and make this new home yours today!' ,`Acres` = '0.296' ,`Area` = '15' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516410 - FOSTERS RIDGE 10, BLOCK 1, LOT 21' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12894' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fosters Ridge' ,`TaxAmount` = '964' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701408' WHERE `Matrix_Unique_ID` = '206936891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T16:10:51.903' ,`MLSNumber` = '2234572' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Jorge Maldonado' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '29.913546' ,`Longitude` = '-95.459600' ,`PhotoCount` = '7' ,`PostalCode` = '77038' ,`RoomCount` = '7' ,`ListPrice` = '288990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Landon Light' ,`StreetNumber` = '12603' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DYNAMITE NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Popular \"Easton\" Plan! Split Plan Layout with Private Primary Suite! Great Layout for Entertaining - Island Kitchen is Open to Large Family Room & Spacious Dining Area! Fantastic Primary Suite with Walk-In Closet & Lovely Bath with Oversized Shower! Spacious Secondary Bedrooms! Convenient Indoor Utility Room! Recessed Lighting & Home Automation System! Incredible Energy Saving Features Including Radiant Barrier, Double Pane Low-E Vinyl Windows, & Tankless Water Heater! MUST SEE! Estimated Completion - September 2022.' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 FORESTWOOD SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '290' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARTER ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Princeton' ,`TaxAmount` = '' ,`TaxRate` = '3.1336' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701408' WHERE `Matrix_Unique_ID` = '207683415' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T17:15:04.927' ,`MLSNumber` = '91736637' ,`ListAgentFullName` = 'Lorena Martinez' ,`ListOfficeName` = 'J Perez Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783315' ,`Longitude` = '-95.195297' ,`PhotoCount` = '24' ,`PostalCode` = '77015' ,`RoomCount` = '4' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Joliet' ,`StreetNumber` = '13022' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2072 BLK 72 HOME OWNED ESTATES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 05' ,`TaxAmount` = '3330' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701409' WHERE `Matrix_Unique_ID` = '208954748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T16:17:38.550' ,`MLSNumber` = '79826527' ,`ListAgentFullName` = 'Cheryl Byrne' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022065' ,`Longitude` = '-95.628648' ,`PhotoCount` = '23' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Northpointe Ridge' ,`StreetNumber` = '12327' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Meritage Home with open concept, 4 Bedrooms and 2 bathrooms downstairs. Spacious Gameroom Upstairs with half bath. Gorgeous wood floors in Foyer, Dining and Family Room. Attic has been decked for storage. Foam installation throughout. Sprinkler system, Large covered Patio in the back. Backyard is large and big enough for a pool. New Roof 2020, and Fresh paint inside.\r\nThe home is located in the Highly Acclaimed Tomball School District, and close to this home. Easy Access to 249 and The Grand Parkway, Minutes to Shopping.' ,`Acres` = '0.2173' ,`Area` = '35' ,`BuilderName` = 'Mertiage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 WILDWOOD AT NORTHPOINTE SEC 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9466' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1035' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood/Northpointe' ,`TaxAmount` = '9863' ,`TaxRate` = '3.0564' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701409' WHERE `Matrix_Unique_ID` = '209145999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T17:16:39.177' ,`MLSNumber` = '4299588' ,`ListAgentFullName` = 'Wei Zhang' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.883149' ,`Longitude` = '-95.359302' ,`PhotoCount` = '15' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '52000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodlands' ,`StreetNumber` = '238' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for your Dream House in Golf Course neighborhood also with community pool? walk to fishing, camping and hunting by the lake? Here you found the gem in the woods! This double-wide mobile home built in 1993 and with your handy-man skill and imagination to turn this house to your Dream Home! house is 2 bedrooms and 1 bath over 1000 sft2 with about 400 sft2 garage, it sits on quarter acre wooded lot with fenced backyard! House is not livable and need a lot of work, seller offer Lease Purchase program with 0 down $500 monthly at 20 years term.' ,`Acres` = '0.2626' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'TRINITY PLANTATION, BLOCK 10 LOT 17 LABEL # NO TAG' ,`LotDesciption` = 'Other' ,`LotSize` = '11440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Trinity Plantation' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701409' WHERE `Matrix_Unique_ID` = '210323182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T16:09:57.680' ,`MLSNumber` = '26711097' ,`ListAgentFullName` = 'Mary Moffett' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Rashaad Rasberry' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '29.948549' ,`Longitude` = '-95.741213' ,`PhotoCount` = '37' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '609000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Watchful Willow' ,`StreetNumber` = '19114' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A remarkable, one-story, executive home with 3br, 3.5 baths and oversized 3 car tandem garage perfectly situated on one of the largest lots in Bridgeland master planned community. This gem has over $100K in upgrades including wood like tile floors, high ceilings with crown molding, open kitchen with 2 islands, GE monogram double ovens, 36\" gas cooktop, oversized farm sink and large breakfast bar; whole house water softener system; 4\" wood plantation shutters; entire house security system with security monitor and ring doorbell plus much more! The secondary bedrooms have en-suite baths and walk in closets. Escape to your primary bathroom with its freestanding soaking tub, large shower with dual rain showerheads and oversized closet. Entertain on the extended, large, enclosed back patio with sun blocking, pet proof custom screens, outdoor grade ceiling fans, TV hookup and gas connection. The 12,014 sq ft lot can accommodate any sized pool and is covered by a 9 zone sprinkler system.' ,`Acres` = '0.2758' ,`Area` = '25' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 BRIDGELAND HIDDEN CREEK SEC 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland Hidden Creek' ,`TaxAmount` = '14098' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701409' WHERE `Matrix_Unique_ID` = '211279546' --> Updated record success