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-22T20:07:58.273' ,`MLSNumber` = '23144985' ,`ListAgentFullName` = 'Lisa Gilbreth' ,`ListOfficeName` = 'Clark Warthen Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676595' ,`Longitude` = '-95.469768' ,`PhotoCount` = '32' ,`PostalCode` = '77096' ,`RoomCount` = '18' ,`ListPrice` = '990000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesheather' ,`StreetNumber` = '5131' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '7' ,`SqFtTotal` = '6207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this home! Seven bedrooms, six baths and two half baths. Zoned to Bellaire HS. It has a guest suite complete with kitchen, living area, bedroom and bath on the ground floor! Perfect for extended family or a nanny.\r\nThe kitchen is a dream with 48\" Bertazzoni range, separate icemaker on the wet bar, quartz countertops, carrera marble and subway tile backsplash. The flooring is wood look tile and slate throughout the downstairs living areas. Three A/Cs were replaced in 2019.\r\nThe outdoor space has a large (~37K gallon) pool with half bath, extensive patio with more yard behind the garage.\r\nThis property has one of the largest lots in the area.\r\nExclusions: washer, dryer, utility room refrigerator, freezer, suite microwave and 2 attached TVs\r\nVerify room measurements. Notice for showing is 2 hours.' ,`Acres` = '0.4051' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 25 MEYERLAND SEC 8 R/P I' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17646' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Back,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Meyerland Sec 08 R/P I' ,`TaxAmount` = '17326' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701854' WHERE `Matrix_Unique_ID` = '203669389' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T20:47:31.417' ,`MLSNumber` = '53242417' ,`ListAgentFullName` = 'Sue Cornell' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.022468' ,`Longitude` = '-95.468401' ,`PhotoCount` = '50' ,`PostalCode` = '77541' ,`RoomCount` = '6' ,`ListPrice` = '777777.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos River Road County Road' ,`StreetNumber` = '5310' ,`StreetSuffix` = 'Road' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '4306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Storage is no issue with this most stunning, impeccable home. The kitchen is a cook\'s dream with Tons of counter and storage space. The granite sparkles and the woodwork shines. This home has been so lovingly cared for; it looks brand new. There is a 20x20 storage area upstairs, a 30x40 shop/barn plus horse stalls, a four , and a possible fifth car garage. A beautiful fireplace sets the tone in the living room, and the open floorplan begs for lots of folks and lots of space for family and friends .One of the great amenities of this property is the 825 sq foot apartment that features a full kitchen, utility room, living/dining area, one bedroom and spacious bathroom. The apartment has two entries, one exterior and one access from the garage. The inviting park like back yard can be seen and enjoyed from the freshly painted screened back porch. THIS BEAUTY, ON THE BRAZOS RIVER, SITS ON NEARLY 4 ACRES!!!! COME TAKE A LOOK! It Won’t last long! Clean and neat!!!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVER ROAD ESTATES (A0020 S F AUSTIN DIV 17) lot 4A 3.907' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Road Estates' ,`TaxAmount` = '6707' ,`TaxRate` = '2.0724' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701854' WHERE `Matrix_Unique_ID` = '205153466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T20:43:34.223' ,`MLSNumber` = '7160353' ,`ListAgentFullName` = 'Misty Gustin' ,`ListOfficeName` = 'RE/MAX Crossroads Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.355166' ,`Longitude` = '-95.081566' ,`PhotoCount` = '11' ,`PostalCode` = '77510' ,`RoomCount` = '6' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'S Fm 646' ,`StreetNumber` = '6228' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So many options with this rare find! This 2+ acre cleared property has a charming 2/1 cottage and a HUGE 60x40 shop with 3 roll up doors and a living/kitchen space with a half bath. Conveniently located on FM 646 and having a separate driveway to the shop makes this a prime location for a possible home business or could easily be used for your hobbies. The property really opens up behind the shop to reveal a beautiful, cleared area. This home has so many possibilities including income producing potential. Come see this one today!' ,`Acres` = '2.135' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 48 L CRAWFORD SUR PT OF OUTLOT 215 (215-21) ALTA LOMA O' ,`LotDesciption` = 'Cleared' ,`LotSize` = '93001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '3706' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701854' WHERE `Matrix_Unique_ID` = '207804087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T20:55:05.597' ,`MLSNumber` = '15204589' ,`ListAgentFullName` = 'Anibal Alvarado' ,`ListOfficeName` = 'AAA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.371462' ,`Longitude` = '-94.972971' ,`PhotoCount` = '21' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '174900.00' ,`Status` = 'Active' ,`StreetName` = 'Hudler' ,`StreetNumber` = '817' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very Nice remodeled house, clean and ready for a new owner. LARGE BACKYARD, oversized master. Laminated flooring, new paint, New fixtures. Come and see it.' ,`Acres` = '0.2376' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR PT OF BLK 19 (1900-14) DIV E COOK & S' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cook & Stewart' ,`TaxAmount` = '2411' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701854' WHERE `Matrix_Unique_ID` = '208214586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T20:16:46.163' ,`MLSNumber` = '74044435' ,`ListAgentFullName` = 'Danny Barrett' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.686021' ,`Longitude` = '-95.166544' ,`PhotoCount` = '33' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Marina Trl' ,`StreetNumber` = '444' ,`StreetSuffix` = '' ,`City` = 'Coldspring' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '1' ,`SqFtTotal` = '3120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A unique 3,120 sf barndominium that sits on 4 lots in a peaceful lakeside community. The property has electric, public water, and its own septic system. All 4 lots are adjoining. Each are approximately 10,500 sf, equaling 41,992 sf, or .964 acres. One has a poured slab for a garage, prepped with power and ready for completion. The building has stained cement floors on the lower level, a fully decked loft overlooking the main living area, 1 bedroom with an ensuite, 2 half baths, a large kitchen and prep area with 2 sinks, covered porches on all 4 sides, and more. The subdivision offers a community center, swimming pool, boat launch and a marina. The property has tremendous potential and with your vision and creativity can be a beautiful residential property customized to your style of lake living.' ,`Acres` = '0.964' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY SHORES SUB 1, BLOCK 8, LOT 10, 11, 12 & 15 SECTION 2' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot,Water View' ,`LotSize` = '41992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'Holiday Shores Sub 1' ,`TaxAmount` = '2921' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701854' WHERE `Matrix_Unique_ID` = '208267341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T20:33:22.957' ,`MLSNumber` = '30628694' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152839' ,`Longitude` = '-95.616370' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '303173.00' ,`Status` = 'Active' ,`StreetName` = 'Barn Owl' ,`StreetNumber` = '10107' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MILL CREEK TRAILS IS NOW OPEN!! NOVEMBER 2022 MOVE-IN!!! Colina Homes believes in building your dream 1-Story w/ 4 Bedrooms + 2 Full Baths + Large Covered Patio at a price you CAN afford! Come see this NEW open-concept home with space in all the right places. This Open Kitchen features White 42” Shaker Cabinets + Luxury Granite + Arabesque Mosaic-Tile Backsplash + Floating Island + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a HUGE walk-in Closet, 36\"-High Cabinets with Double Sinks, Large 5\' shower with Glass Enclosure! 3-Sides Acme Brick, 2” Faux Wood Blinds, Garage Door Opener, 16 SEER Lennox Air System, In-Wall Pest Defense System & Much More! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 3 Sec 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701854' WHERE `Matrix_Unique_ID` = '208370972' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T21:16:04.807' ,`MLSNumber` = '70165518' ,`ListAgentFullName` = 'Danny Barrett' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.826744' ,`Longitude` = '-95.237531' ,`PhotoCount` = '31' ,`PostalCode` = '77320' ,`RoomCount` = '9' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakland Hills' ,`StreetNumber` = '24420' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled home on Waterwood National Golf Course with gorgeous, panoramic lake views. This home sits on a wooded double lot, nestled in a quiet neighborhood surrounded by nature. Updates include new flooring throughout the house, granite counter tops, and fresh paint inside and out. The island kitchen has plenty of storage and SS appliances. Primary bedroom w/ensuite, laundry room, living room, kitchen and half bath are downstairs, with 3 large bedrooms, 2 guest bathrooms and a bonus room upstairs. The living room overlooks the golf course and lake and opens out onto a large deck; perfect to sit and enjoy the beautiful views of the lake and peaceful surroundings. The property has a fire hydrant in the corner of the front yard which will lower your homeowner’s insurance. A Home Warranty transfers with the house. This home is move-in ready. Don’t wait, come see it today.' ,`Acres` = '0.6715' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WATERWOOD - LAKEVIEW ESTATES, BLOCK 1, LOT 44A' ,`LotDesciption` = 'Cleared,In Golf Course Community,On Golf Course,Subdivision Lot,Water View,Wooded' ,`LotSize` = '29251' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterwood' ,`TaxAmount` = '5546' ,`TaxRate` = '2.3654' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701854' WHERE `Matrix_Unique_ID` = '210623134' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T21:17:39.103' ,`MLSNumber` = '96100211' ,`ListAgentFullName` = 'Amy Pomerleau' ,`ListOfficeName` = 'Guillen Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830561' ,`Longitude` = '-95.551249' ,`PhotoCount` = '29' ,`PostalCode` = '77043' ,`RoomCount` = '5' ,`ListPrice` = '467900.00' ,`Status` = 'Active' ,`StreetName` = 'Quiet Courtyard' ,`StreetNumber` = '10409' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Through the gated entry of Shadowdale Terrace is a beautiful picturesque home situated on a premium interior corner lot, loaded with designer features! This 5 bedroom, 3.5 bathroom home greets you as you drive up with vibrant blue and white exterior, metal roof accents, and covered front patio with courtyard. Inside you will find an open floor plan with tile flooring, recessed lighting, and granite countertops throughout. Designed for entertaining, you will find built-in surround sound in the living room, tons of natural light pouring in & a 3 panel sliding glass back door to create an indoor/outdoor living space. Gourmet kitchen with oversize island, stainless steel appliances, pantry, and much more. 1st floor primary suite includes walk in closet and luxurious bathroom. Upstairs, you\'ll find a massive game room, nook, 4 spacious bedrooms and 2 full bathrooms. Easy access to restaurants, shopping and more. Zoned to Cypress-Fairbanks ISD. Schedule your tour today!' ,`Acres` = '0.0681' ,`Area` = '24' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 SHADOWDALE TERRACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Shadowdale Terrace' ,`TaxAmount` = '9572' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701855' WHERE `Matrix_Unique_ID` = '210928224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T21:14:24.830' ,`MLSNumber` = '21153492' ,`ListAgentFullName` = 'Mariana Alvarez' ,`ListOfficeName` = 'Texan Preferred Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130068' ,`Longitude` = '-95.601115' ,`PhotoCount` = '26' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Wilkes' ,`StreetNumber` = '25219' ,`StreetSuffix` = 'Park' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2998' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction on cul-de-sac. Spacious layout, 4 bedrooms; one with its own private bathroom. House has a home office and open floor plan with beautiful natural light. \r\nHouse is located in a forested area and has a terrace overlooking the tranquil wood of Twelve Oaks.' ,`Acres` = '0.6451' ,`Area` = '14' ,`BuilderName` = 'Wood & Smart Design' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 TWELVE OAKS SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '28101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '617' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Twelve Oaks Sec 01' ,`TaxAmount` = '2269' ,`TaxRate` = '3.2372' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701855' WHERE `Matrix_Unique_ID` = '211486020' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T21:14:20.273' ,`MLSNumber` = '76686652' ,`ListAgentFullName` = 'Adam Macey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.041126' ,`Longitude` = '-95.328048' ,`PhotoCount` = '16' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Bridgegate' ,`StreetNumber` = '6623' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden gem in established neighborhood. Come check out this great home on cul-de-sac street with large fenced yard. Wood tile throughout home, new roof, new plumbing, new electric panel. Make this your home!' ,`Acres` = '0.1446' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 27 GREENGATE PLACE SEC 5 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greengate Place Sec 05 R/P' ,`TaxAmount` = '3682' ,`TaxRate` = '2.6867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701855' WHERE `Matrix_Unique_ID` = '211661356' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T20:33:30.820' ,`MLSNumber` = '13535962' ,`ListAgentFullName` = 'Raquel Knobloch' ,`ListOfficeName` = 'Texas State Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.256859' ,`Longitude` = '-95.519760' ,`PhotoCount` = '36' ,`PostalCode` = '77384' ,`RoomCount` = '6' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Stony Gap' ,`StreetNumber` = '14013' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3 bed 2 bath w/ formal dining room and charming outdoor pergola, located in renowned Fosters Ridge! This home is better than NEW! So many upgrades! The light and bright kitchen offers gorgeous quartz countertops, stainless appliances, gas range, custom light fixtures and an open concept floorplan, perfect for entertaining. Luxury vinyl plank flooring throughout the living spaces. Formal dining room or office offers additional space. Primary retreat with double sinks and soaking tub overlooks the large backyard that features a fantastic outdoor living space. Covered back patio offers great entertaining opportunities and a stone walkway leads to the quaint pergola. Minutes to The Woodlands shopping and dining or head north, just a short drive to Lake Conroe for fishing or dinner on the lake. Exemplary Woodlands schools! Neighborhood offers state of the art pools, parks and clubhouse. Tankless hot water heater, washer/dryer and fridge included! Perfect location with NO flooding!' ,`Acres` = '0.1576' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516408 - FOSTERS RIDGE 08, BLOCK 2, LOT 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Fosters Ridge 08' ,`TaxAmount` = '6538' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701855' WHERE `Matrix_Unique_ID` = '211699207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T21:39:45.300' ,`MLSNumber` = '44633354' ,`ListAgentFullName` = 'Denise Hernandez' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785516' ,`Longitude` = '-95.183569' ,`PhotoCount` = '6' ,`PostalCode` = '77015' ,`RoomCount` = '7' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Louisville' ,`StreetNumber` = '13525' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CALLING ALL INVESTORS...If you\'re looking for a BUY and HOLD this property is for you. This property features 3 bedrooms 2.5 baths with a large fenced backyard. Upon entry is the family room with 2 bedrooms & a bathroom. Large kitchen with peninsula gives ample space to talk it while cooking up some breakfast. There is a flex room that has a half bath and the utility room is in house. At the back of the house is the primary bedroom with full bath. NEW HVAC, ROOF and Pex Plumbing in 2018. Call today for a tour!' ,`Acres` = '0.1791' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 574 BLK 20 HOME OWNED ESTATES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GREEN VALLEY ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 01' ,`TaxAmount` = '3355' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701855' WHERE `Matrix_Unique_ID` = '211710168' --> Updated record success