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-10-17T03:08:48.190' ,`MLSNumber` = '10238209' ,`ListAgentFullName` = 'Khuong Do' ,`ListOfficeName` = 'AMX Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.140360' ,`Longitude` = '-95.048385' ,`PhotoCount` = '19' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Grayson' ,`StreetNumber` = '4102' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION - FULLY FURNISHED located in Sea Isle! Elegantly designed open floor plan includes island bar, state of the art kitchen, premium cabinetry, quartz counters throughout, and SS appliances! Durable wood-look Luxury Vinyl Plank flooring below and soaring 11ft vaulted ceiling above! Extra large front porch for group enjoyment with a private rear porch accessible from the master bedroom. Master en suite with oversized frameless glass shower and double vanity makes it the perfect way to wake up in paradise! High efficiency spray foam insulation, hurricane proof grade windows and doors, outdoor shower, oversized garage! Subdivision amenities include pool, boat launch, fishing pier, tennis court. *Some furniture differ from photos*' ,`Acres` = '0.1439' ,`Area` = '33' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 1545 SEA ISLE 3RD EXTENSION' ,`LotDesciption` = 'Other' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '216' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sea Isle Ext 3' ,`TaxAmount` = '1351' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666042267' WHERE `Matrix_Unique_ID` = '209984651'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T03:15:02.760' ,`MLSNumber` = '44905470' ,`ListAgentFullName` = 'Janet White' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766430' ,`Longitude` = '-94.968581' ,`PhotoCount` = '40' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Briarclift' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE, Sunday,  October 23, 1:00-5:00 pm.\r\nRecently remodeled 3-2-2 home in well established neighborhood.  Kitchen remodeled in 2021 with open concept and large walk-in pantry.  Oversized laundry room has in-the-wall ironing board and plenty of room for sewing machine or other crafts.  Cathedral ceiling in den with double french-doors gives access to covered back patio.  Primary bath has beautiful large shower complete with modern tile, bench seat and rain-shower head. Pex water lines, A/C ducts and hot water heater all replaced in 2021.  Back sidewalk and extended patio recently added and finished with stamped concrete.  Extra driveway/parking area on south side of garage provides plenty of room for all your vehicles and toys.  Outside freshly painted. Fence recently replaced beside garage with new double wide gate.  Home is complete with granite in kitchen and bathrooms.  Two attic storage areas are included, one in the house and one in the garage.  Storage building remains.' ,`Acres` = '0.1977' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 5 ALLENBROOK SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Allenbrook Sec 03' ,`TaxAmount` = '4982' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042268' WHERE `Matrix_Unique_ID` = '213042646'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213304734','1666042268','213304734','2022-10-17T02:04:31.307','39926852','Ethel Cain','Coldwell Banker Realty','','','30.127643','-95.226465','17','77357','7','360000.00','Active','Oakley','22450','Road','New Caney','2','1','3','2310','Single-Family','A Wonderful home with a great floor plan. This charming 3-bedroom 2-bath home features some recent updates that include fresh paint, granite counter tops, a metal lifetime roof, and porcelain tile thru out. The home sits on a spacious lot that has a large 1575 sq ft barn, an inground pool with a relaxing hot tub, and a turbo twist slide to enjoy endless hours of entertainment. Conveniently located near entertainment, shopping, schools, and easy access to 99.','0.49','40','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','0','','','Porter/New Caney East','Central Gas','0','OAKLEY-GILBERT WEST BK LT 20 and 22, ACRES 0.49','Subdivision Lot','21463','Other','','','0','','3','Gas Oven','1','In Ground','','Gas Range','','Aluminum','39 - New Caney','OAKLEY ELEMENTARY SCHOOL','NEW CANEY HIGH SCHOOL','NEW CANEY MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Seller','1','Contemporary/Modern','Oakley-Gilbert West','1547','2.5981','Public Sewer,Public Water','1970','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T02:21:06.120' ,`MLSNumber` = '56435170' ,`ListAgentFullName` = 'Gina Li' ,`ListOfficeName` = 'Homesource Investments Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724711' ,`Longitude` = '-95.574587' ,`PhotoCount` = '42' ,`PostalCode` = '77082' ,`RoomCount` = '13' ,`ListPrice` = '1900000.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgeberry' ,`StreetNumber` = '3215' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A luxurious Mediterranean estate nestled peacefully behind stately masonry walls & a 24H manned gate ROCC. With gorgeous bridges & tranquil waterfalls, this resort-like neighborhood is a destination home. Home has a covered/oversized flagstone patio/outdoor summer kitchen/fireplace, pool/spa, a balcony w/incredible view of the lake & fairway at the back. Fabulous double iron door/2 primary suites w/1 guest room on the 1st fl, designer interiors w/inlaid marble/wood floor/extensive crown molding/high ceilings/2 staircases that lead to the study/library /game room/media room/2nd primary suite, oversized balcony w/a million-dollar views of the backyard oasis/pool/lake/golf course. A chef’s dream kitchen w/granite counters. The master bedroom is adorned w/motorized Hunter Douglas drapes, his & her closets, while the spa-like master bath has a Jacuzzi, wet bar and seating area that can double as a private meditation/yoga/gym room. Central vacuum system, oversized 3 car garage.' ,`Acres` = '0.3023' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 2ND AMEND ROYAL OAKS COUNTRY CLUB 5' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,On Golf Course,Water View,Waterfront' ,`LotSize` = '13167' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Royal Oaks Country Club Sec 05' ,`TaxAmount` = '36859' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042268' WHERE `Matrix_Unique_ID` = '213474966'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T02:20:29.337' ,`MLSNumber` = '44346005' ,`ListAgentFullName` = 'Mary Markwardt' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.504598' ,`Longitude` = '-95.435360' ,`PhotoCount` = '44' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowpeak' ,`StreetNumber` = '5505' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VACATION in your own backyard!  This stately home is situated on a spacious cul-de-sac lot and offers 4 bedrooms, study, formal dining and a huge game room.  Primary bedroom and living room are generous as well.  Living room and formal dining have gorgeous engineered hard wood flooring.  All new carpet in Sept. of 2022.   An awesome covered back patio overlooks the pool & spa making it the perfect place to relax and unwind.  Pool is only two years old!  There is also a gas connection on the patio for those gas grills.  Lakes of Savannah is a master planned community offering two pools, two club houses, splash pad, elementary school, parks, ponds & miles of sidewalks. Located near Hwy. 6 and Hwy. 288. Just minutes to Pearland Town Center. Community did NOT lose power during the big freeze of 2021! Don\'t Dream a Dream, Buy One!' ,`Acres` = '0.2264' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH LANDING SEC 1 (A0403 A C H & B), BLOCK 2, LOT 7, AC' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9862' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes of Savannah' ,`TaxAmount` = '10265' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042268' WHERE `Matrix_Unique_ID` = '213609514'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-17T03:23:34.370' ,`MLSNumber` = '32831310' ,`ListAgentFullName` = 'Mary Frances DuMay' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736908' ,`Longitude` = '-95.409754' ,`PhotoCount` = '19' ,`PostalCode` = '77098' ,`RoomCount` = '16' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Branard' ,`StreetNumber` = '2044' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2754' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNBELIEVABLE NEW PRICE $899,900.00!!! Recently* renovated single-family home in Montrose steps to Trader Joe’s and the Upper Kirby District for fine dining and retail shopping. Circular floor plan downstairs perfect for entertaining! Living room, upgraded kitchen, dining area and the oversized utility room all feature red oak hardwood floors. Need a full bath downstairs? The laundry room could be redesigned to include a shower [request estimate]. Timeless finishes in marble and quartz complement this light-filled residence. The primary suite has lovely tree top views and a ginormous-sized closet. Two additional bedrooms plus a newly remodeled bath are upstairs. Bonus 3rd floor includes the 4th bedroom + a home office with a glimpse of downtown Houston! Lush backyard and deck. Plenty of room for a new pool! Floor-to-ceiling windows throughout. Also available for lease [minimum six months]. *Per Seller' ,`Acres` = '0.1435' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 2 DEARBORN PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dearborn Place' ,`TaxAmount` = '19271' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666042268' WHERE `Matrix_Unique_ID` = '213693544'  --> Updated record success<br />