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` = '2022-08-28T18:50:24.867' ,`MLSNumber` = '13969201' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Venkudusamy Muthusamy' ,`SellingOfficeName` = 'Om Realty Group' ,`Latitude` = '29.734255' ,`Longitude` = '-95.865462' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '528535.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ethan Park' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to Katy ISD! PLEASE SEE ATTACHMENTS FOR OFFER INSTRUCTIONS. D.R. Horton\'s Two story Pattison model! ATTACHMENTS SHOW COLOR PACKAGE. 4 Bedrooms! 3.5 baths! Full guest room upstairs with private bath! Gorgeous Kitchen with stunning 42\" Cabinets, Silestone counters and stainless steel 5 burner range! Covered patio ready for the week-end BBQ\'s! This is a \"SMART HOME\" with camera doorbell and whole home system. Controlled from your hub or smart phone! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails all included and ready for you! Please verify with sales agent options and upgrades.**PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY***At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 116; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6967' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704155' WHERE `Matrix_Unique_ID` = '208657777'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T18:03:58.777' ,`MLSNumber` = '91351738' ,`ListAgentFullName` = 'Andrea Kitzmann' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.582962' ,`Longitude` = '-96.269324' ,`PhotoCount` = '12' ,`PostalCode` = '77845' ,`RoomCount` = '8' ,`ListPrice` = '347945.00' ,`Status` = 'Active' ,`StreetName` = 'Double Mountain' ,`StreetNumber` = '761' ,`StreetSuffix` = 'Road' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 4 bed, 3.5 bath home with gameroom and 2-car alley entry garage in Midtown Reserve from DR Horton! Beautifully constructed, the Walnut offers an open concept floor plan with a spacious living room open to the kitchen, dining area, and much more. Enjoy cooking in the gourmet kitchen featuring quartz counters, grey cabinetry, eating bar, breakfast area, pantry, and stainless appliance package. Escape to the primary suite with oversized tile shower, dual sinks, and huge walk-in closet. Smart home features include Amazon Echo Dot, 7” HD touchscreen security control panel, video doorbell, and smart lights at the front entry. Extras you don’t want to miss include vinyl plank flooring throughout common areas, soaring ceilings, covered patio, sprinklers, and so much more! Future amenities will include a neighborhood lake, dog park, playgrounds, and Town Lake Park. With an energy efficient design, this home is sure to be #1 on your list. Ready for Early 2023 Move-in!' ,`Acres` = '0.13' ,`Area` = '61' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MIDTOWN RESERVE PH 201, BLOCK 20, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5633' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SOUTHWOOD VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'A & M CONSOLIDATED MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Midtown Reserve' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704155' WHERE `Matrix_Unique_ID` = '210614792'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T18:01:09.490' ,`MLSNumber` = '88887434' ,`ListAgentFullName` = 'Natasha Hansen' ,`ListOfficeName` = 'The Golden Group Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744572' ,`Longitude` = '-95.403066' ,`PhotoCount` = '32' ,`PostalCode` = '77019' ,`RoomCount` = '3' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Park' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story in the heart of Montrose, located in a corner lot, featuring three bedrooms, two full baths, and a beautiful pool. Property has elegant finishes throughout with updated bathrooms, living area, and modernized features. This home offers a great space for entertaining with a pool view, also a tranquil space to sip coffee in the morning or late evening. Large backyard space in the city minutes from the Heights, Downtown, River Oaks Shopping Center, and the Medical Center. Spacious garage that fits two large vehicles or storage space. Call for a chance to tour...' ,`Acres` = '0.1148' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'River Oaks Shopping Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 5 HYDE PARK HEIGHTS' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hyde Park Heights' ,`TaxAmount` = '14229' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704155' WHERE `Matrix_Unique_ID` = '210653809'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T19:52:47.040' ,`MLSNumber` = '39111917' ,`ListAgentFullName` = 'Berenice Van den Bergh' ,`ListOfficeName` = 'White Line Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057696' ,`Longitude` = '-95.132844' ,`PhotoCount` = '30' ,`PostalCode` = '77336' ,`RoomCount` = '2' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Collins' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a relaxing getaway or a turnkey vacation rental? This beautiful updated home on Lake Houston could be just what you\'re looking for! Lake front, TWO lots, located on a dead end street, TWO boat lifts/slips, completely renovated in 2022, and sold FULLY furnished. This lake house is ready for move in and perfect for indoor/outdoor living with plenty of space to entertain under the house and in the yard. Updates in 2022 include: new floors, windows, kitchen, bathroom, interior & exterior paint, outdoor shower, lighting, appliances, wood patio decking, laundry room with W/D built under the house, and more! With a main floor elevation of approximately 16 feet, there is no risk of flooding. Come see this hidden gem!' ,`Acres` = '0.1054' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 11 and 12 CALVIN VILLAGE U/R R/P' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9307' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Calvin Village U/R R/P' ,`TaxAmount` = '427' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704155' WHERE `Matrix_Unique_ID` = '211805897'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T18:34:30.737' ,`MLSNumber` = '69484414' ,`ListAgentFullName` = 'Jonathan Metcalf' ,`ListOfficeName` = 'RE/MAX Prestige' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135252' ,`Longitude` = '-95.511958' ,`PhotoCount` = '37' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Evergreen Bend' ,`StreetNumber` = '25310' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Two-Story Showcase! Lennar Vista Collection (Sierra Mesa Plan) with Stone Elevation! Terrific 5-bedroom floorplan features dramatic two-story family room, formal dining, study, large game room and two bedrooms on the main floor. Features: Home Automation, Energy Star Home; 2\'\' Faux Wood Blinds; Fireplace; Landscape Pkg & more! UPRADES INCLUDE: Stainless Steel Profile Kit Appliance Pkg including gas cooktop & fridge; Granite countertops in kitchen w/Tumbled stone backsplash; Hardwood in dining, study & family rm; 18\'\' Tile in entry & wet areas on diagonal; Upgrade Carpet; Upgrade 42\'\' Kitchen Cabinets; Whirlpool tub; Crown Molding; Sprinkler Sys & more!' ,`Acres` = '0.1739' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud,Pre-Foreclosure,Sellers Disclosure,Short Sale,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 3 AUBURN LAKES PINES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7573' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Lakes Pines' ,`TaxAmount` = '10104' ,`TaxRate` = '2.914' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704155' WHERE `Matrix_Unique_ID` = '211902101'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T18:15:12.473' ,`MLSNumber` = '53096058' ,`ListAgentFullName` = 'Mohammed Ansari' ,`ListOfficeName` = 'Greenleaf Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747293' ,`Longitude` = '-95.740473' ,`PhotoCount` = '21' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Park' ,`StreetNumber` = '2314' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1966' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a very nice single-story house. Big Backyard and corner lot. Three bedroom house with large living room\r\nIt has porch on the back. Roof recently replaced. New microwave. Open floor plan. Air condition also replaced 4 months back.' ,`Acres` = '0.2315' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 3 OAK PARK TRAILS SEC 11' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '10083' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Park Trails Sec 11' ,`TaxAmount` = '5883' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704155' WHERE `Matrix_Unique_ID` = '211915984'  --> Updated record success<br />