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-29T21:30:23.650' ,`MLSNumber` = '85631132' ,`ListAgentFullName` = 'Cary Stephens' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068699' ,`Longitude` = '-95.102138' ,`PhotoCount` = '32' ,`PostalCode` = '77336' ,`RoomCount` = '10' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2100' ,`StreetNumber` = '27811' ,`StreetSuffix` = 'Road' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED $155,000!! BRING US A CONTRACT!! FM 2100 is being widened making this a great commercial location! Grand Parkway is close! Great Location for Country Living & Commercial Business! 6.29 Acres fenced with 2 Street Access!! FM 2100 frontage on both sides of Road!! .03 acre tract on East Side of FM 2100, too!! Multiple Structures: 3 BR 2 bath main house with two living areas, 10 x 70 covered front porch & covered back porch!! 672 sq. ft. 1 BR 1 bath guest house with living area, kitchen & utility room! 2nd Guest house 400 sq. ft. 2 BR 1 bath with living room, kitchen and utility room! 30 x 50 insulated shop with hydraulic lift! 20 x 45 covered RV/Boat Parking! Horse barn with Tack Room, Chicken coop, 26 foot above ground pool with deck! Per Seller the main house is approximately 2,000 sq. ft. The small trailer is approximately 400 sq. ft. and the little guest cottage is 672 sq. ft. Total of everything is approximately 3,072 sq. ft. Do your own due diligence Bring us a contract!!' ,`Acres` = '6.29' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'TR 44 ABST 474 J H ISBELL' ,`LotDesciption` = 'Cleared,Other,Wooded' ,`LotSize` = '273992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'JH Isbell' ,`TaxAmount` = '2649' ,`TaxRate` = '2.0463' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704563' WHERE `Matrix_Unique_ID` = '202603780'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:19:01.850' ,`MLSNumber` = '34537860' ,`ListAgentFullName` = 'Quang Tran' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982307' ,`Longitude` = '-95.576271' ,`PhotoCount` = '33' ,`PostalCode` = '77070' ,`RoomCount` = '8' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Forest' ,`StreetNumber` = '14210' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2218' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this great Location! (Location!  Location!) home with excellent rating schools in Cypress-Fairbanks ISD. This rare find is also some of the most beautiful houses in the community. The house has 4 bedrooms, 2 bathrooms, living room, dining room, kitchen, breakfast area, covered patio, huge backyard with good maintenance, and no neighbor in the backyard. The house is completely remodeled: New paint, 2 years old air conditioner with new lineset, new electrical/water system, new kitchen cabinet and vanity cabinet, stainless steel high quality brand appliences, Quatz countertop with glass mosaic backsplash, standing shower with frameless glass and luxury faucet, huge master bedroom closet, huge new driveway, new wood fence, huge backyard => You can drive your trucks/boat trailer.  Bonus 1 workshop behind the house has also been remodeled. Especially,  Never Flooded even during Harvey and Outside of Floodzone!' ,`Acres` = '0.3903' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 CYPRESS FOREST SEC 2 U/R' ,`LotDesciption` = 'Other' ,`LotSize` = '17000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Forest Sec 02 U/R' ,`TaxAmount` = '4203' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Public Water,Septic Tank,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704563' WHERE `Matrix_Unique_ID` = '208126350'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T21:15:27.877' ,`MLSNumber` = '25887442' ,`ListAgentFullName` = 'Mazna Ayub' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686065' ,`Longitude` = '-95.356510' ,`PhotoCount` = '19' ,`PostalCode` = '77021' ,`RoomCount` = '3' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Foster' ,`StreetNumber` = '7101' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Minutes away from Medical Center, Downtown, University of Houston, Texas Southern University.\r\nMinutes away from highway 288, 610, 45 and 59/69.\r\nIdeal for students and group accommodation.\r\n3 Bed all with attached baths, closets, study area and separate/private entrance.\r\nMaster Bed with double closet, double vanity, bathtub and toilet room.\r\nFully fenced, with dusk to dawn area lights and security cameras.\r\nFully equipped with appliances and washer dryer.\r\nAmple car parking on the property.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 55 FOSTER PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'FOSTER PLACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '208644129'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:43:33.650' ,`MLSNumber` = '13355530' ,`ListAgentFullName` = 'Elissa Stone' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696486' ,`Longitude` = '-95.695193' ,`PhotoCount` = '27' ,`PostalCode` = '77407' ,`RoomCount` = '5' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Mill' ,`StreetNumber` = '7607' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 5 BEDROOM - A LOT OF UPGRADES - NICE YARD, LANDSCAPING, ON CUL-DE-SAC\r\n-Large corner lot\r\n-New roof this year\r\n-New fence\r\n-Water softener\r\n-Custom silk drapes all throughout the house\r\n-Half bath vanity upgrade\r\n-Upgraded granite kitchen countertops\r\n-Double master bedrooms and bathrooms (one downstairs and one upstairs)\r\n-Never flooded' ,`Acres` = '0.2846' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TWIN OAKS VILLAGE SEC 4, BLOCK 2, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12395' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '522' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'JORDAN ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Twin Oaks Village Sec 4' ,`TaxAmount` = '8087' ,`TaxRate` = '2.4887' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '208970873'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:44:26.437' ,`MLSNumber` = '92753665' ,`ListAgentFullName` = 'Ozzie Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.485924' ,`Longitude` = '-95.425841' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Trail' ,`StreetNumber` = '6710' ,`StreetSuffix` = 'Loop' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home is situated on an oversized lot with extra room to store your RV or boat! Walk into a charming foyer that features built-in cabinets for storage. Spacious kitchen includes a breakfast bar and large pantry! Generous-sized primary room features an open and roomy bath with double vanities and large soaking tub! Delightful front porch offers plenty of shade making it a perfect spot for relaxation. Backyard includes a 12x28 storage shed and plenty of space to add anything you\'d like! The possibilities are endless! Stop by and come see for yourself what this property has to offer!!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MOBILE HOME ONLY,SPACE S2879 COLONY TRAILS SEC 2 (A0545 HT&B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '27878' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Colony Trails' ,`TaxAmount` = '869' ,`TaxRate` = '2.1194' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '209508784'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:32:09.390' ,`MLSNumber` = '38283217' ,`ListAgentFullName` = 'Jose Perez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702881' ,`Longitude` = '-95.244600' ,`PhotoCount` = '11' ,`PostalCode` = '77017' ,`RoomCount` = '8' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Lucore' ,`StreetNumber` = '10005' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please Show this Beautiful House to your buyers completely remodeled and ready to move in. House with brand new solid wood cabinets and granite counter tops, with new stainless steel appliances,  and Brand new Flooring. Laundry room inside the main House. 30 yr composition shingles installed  2022. GUEST House completely remodeled with full bathroom and New Ductless Mini Split Cool and Heat (Additional Income). Total Living area 1,184 SF (per seller) Primary House 864 SF plus Detached Guest Room 320 SF' ,`Acres` = '0.1607' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 172 ALLENDALE TOWNSITE SEC A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RUCKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Allendale Townsite' ,`TaxAmount` = '1404' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '209514797'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:30:27.883' ,`MLSNumber` = '41143751' ,`ListAgentFullName` = 'Kari Dreymala' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = 'Victor Varela' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '30.106195' ,`Longitude` = '-95.394895' ,`PhotoCount` = '12' ,`PostalCode` = '77386' ,`RoomCount` = '4' ,`ListPrice` = '265000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sedgefield' ,`StreetNumber` = '28707' ,`StreetSuffix` = 'Street' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON THE MARKET!!! This Beautiful Home Welcomes you with a Large Driveway for Guest Parking. Walk into the Open, Light and Bright Living Room with a Brick Accent Wall. High Ceilings in this Split Floor Plan 4 Bedroom 2 Bathroom Home. Upgrades include a Spacious Island in Kitchen, a HUGE Walk-In Pantry with Extra storage, Beautiful Bathrooms with Granite Countertops and Framed Mirrors. Walk out of the French doors to a Spacious Covered Patio with Built-in Bar Height Tables for Entertaining and Beautiful Oak Trees. There is a Storage Shed in the Backyard with an Additional Covered sitting area that can also be used to store Equipment or Toys. No Back Neighbors - This lot backs up to the Wooded area on Spring Creek with a Double Gate for access to the path.' ,`Acres` = '0.1562' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FOX RUN 06, BLOCK 4, LOT 21' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6805' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'FORD ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fox Run 06' ,`TaxAmount` = '5240' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '209853909'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:33:05.800' ,`MLSNumber` = '61886222' ,`ListAgentFullName` = 'M.Cathy Finck' ,`ListOfficeName` = 'Taylor Real Estate Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.760722' ,`Longitude` = '-95.523124' ,`PhotoCount` = '47' ,`PostalCode` = '77024' ,`RoomCount` = '15' ,`ListPrice` = '3299000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunnam' ,`StreetNumber` = '4' ,`StreetSuffix` = 'Lane' ,`City` = 'Bunker Hill Village' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning residence in the heart of Bunker Hill Village has been extensively updated with extreme attention to detail.  It is the perfect combination of open concept with intimate gathering spaces for entertaining and to welcome you home.  You will not want to miss the primary bathroom downstairs, updated with designer finishes and fixtures. This home has large bedrooms, updated bathrooms and a chef\'s kitchen that flows into the expansive family room.  The backyard and pool have also been transformed making this dreamy home perfect for backyard gatherings.  It has a three-car garage and extra parking in the gated driveway and is zoned to award winning SBISD schools.' ,`Acres` = '0.4705' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 DUNNAM ESTATES' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '20493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,Traditional' ,`Subdivision` = 'Dunnam Estates' ,`TaxAmount` = '51701' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '210248749'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:09:07.647' ,`MLSNumber` = '2933716' ,`ListAgentFullName` = 'Shawn Kneale' ,`ListOfficeName` = 'Realty United' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.117436' ,`Longitude` = '-95.286275' ,`PhotoCount` = '50' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Cumbre' ,`StreetNumber` = '22876' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2859' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Mediterranean home located on an acre in Riverwalk. The home features a grand entry, high ceilings, large picture windows, Nest thermostat, camera system, tray ceilings, crown molding and wood-look tile throughout. The split floorplan includes 4 bedrooms, 3.5 baths, formal dining, a private office with French doors, a spacious kitchen overlooking the family room & a large utility room with separate sink and built-in cabinets. The primary suite is secluded and offers direct access onto the patio. The exterior includes great landscaping, a covered patio with ceiling fans, a sink bar with granite countertop & a half bath. The backyard is fenced with a double gated entrance on extended concrete. Other amenities include a water softener system, full gutters, tile roof, sprinkler system in front and back and epoxy coated floor in the garage. There\'s also a 40x30 workshop on a slab with a 12\' roll-up door and separate front and rear entry doors. Easy access to I69 and Grand Parkway.' ,`Acres` = '1.01' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWALK 02, BLOCK 3, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'SORTERS MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Riverwalk' ,`TaxAmount` = '7361' ,`TaxRate` = '2.1331' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '210518543'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T21:17:24.437' ,`MLSNumber` = '19964989' ,`ListAgentFullName` = 'Susanna Mayberry' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.305496' ,`Longitude` = '-94.781560' ,`PhotoCount` = '32' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Winnie' ,`StreetNumber` = '1301' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is located blocks from the beach and UTMB on a fenced corner lot!  Would make a great vacation rental or full time residence.  Original hardwood flooring, updated kitchen and bathroom and each bedroom has a beautiful beadboard ceiling.  Front porch and a side yard the fur babies will love!  Come and see this one!  Currently tenant occupied through Jan 2023.' ,`Acres` = '0.0573' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOT 7 (7-0) BLK 313 GALVESTON' ,`LotDesciption` = 'Corner' ,`LotSize` = '2496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '2630' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704564' WHERE `Matrix_Unique_ID` = '210695941'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:54:06.763' ,`MLSNumber` = '87345174' ,`ListAgentFullName` = 'Amanda Baker' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943853' ,`Longitude` = '-95.135637' ,`PhotoCount` = '33' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '345500.00' ,`Status` = 'Active' ,`StreetName` = 'Steele Point' ,`StreetNumber` = '18339' ,`StreetSuffix` = 'Drive' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a rare opportunity to own a stunning 4 bedroom, 3 bath, well maintained 2,798 sq. ft two story home located in Lake Shadows. Upon entering the home, you are welcomed with a large foyer with a gorgeous staircase and to your right a formal dining area that leads into the den/study room. As you continue you are greeted with an open concept Kitchen that features a breakfast bar and plenty of cabinet space that opens into the Living Room. The spacious utility room features a full bathroom that leads to the garage entryway. The second set of staircases leads straight into the Gameroom or 5th bedroom that includes a large closet and its own door for complete privacy to that room. All three bedrooms are located on the second story as well as the primary room. Lake Shadows has a boat launch with access to Lake Houston right around the corner, a pool area, tennis court, fishing pier and basketball court. This home has never flooded. Make your appointment today!' ,`Acres` = '0.2152' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 6 LAKE SHADOWS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shadows Sec 04' ,`TaxAmount` = '7325' ,`TaxRate` = '2.6843' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704565' WHERE `Matrix_Unique_ID` = '211333284'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T20:37:36.140' ,`MLSNumber` = '20823646' ,`ListAgentFullName` = 'Stacie Fontenot' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.088253' ,`Longitude` = '-94.174035' ,`PhotoCount` = '25' ,`PostalCode` = '77706' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Wilder' ,`StreetNumber` = '6575' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for 3 bedrooms, 2 bathrooms, updated in the heart of Beaumont\'s west end, look no further; this home is for you!!!! It has two living areas and two dining areas. This floor plan is great for entertaining, with the kitchen area opened to the den. The backyard is large, which is perfect for family gatherings. Call today for your private viewing. The roof will be replaced with an acceptable offer.' ,`Acres` = '0.2296' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SHERATON WOODS L21 B3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CURTIS ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheraton Woods' ,`TaxAmount` = '3822' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704565' WHERE `Matrix_Unique_ID` = '211903330'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-29T21:02:56.163' ,`MLSNumber` = '92558498' ,`ListAgentFullName` = 'Casey Waters' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.433674' ,`Longitude` = '-96.325918' ,`PhotoCount` = '29' ,`PostalCode` = '75846' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 5887d' ,`StreetNumber` = '277' ,`StreetSuffix` = '' ,`City` = 'Jewett' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This wonderful home is tucked away just off the lake under beautiful mature trees to give you plenty of shade. Located in the quiet Bishop’s Landing subdivision, this home is just across the street from Lake Limestone. A wide-open downstairs suits the relaxation of lake life and upstairs there is a bonus office space. The massive 2800 sqft shop has endless uses and plenty of storage opportunities thank to its loft and carport.  Located at the end of the cul-de-sac, the yard is open and spacious to enjoy. The boat ramp is only 200 yards away, so lake access is a breeze!' ,`Acres` = '0.72' ,`Area` = '73' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BISHOP\'S LANDING LAKE LIMESTONE, BLOCK C, LOT 001, ACRES 0.7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '31363' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '222 - Groesbeck' ,`SchoolElementary` = 'GROESBECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROESBECK HIGH SCHOOL' ,`SchoolMiddle` = 'GROESBECK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'C/The Called Bishops Lndg Sub' ,`TaxAmount` = '4222' ,`TaxRate` = '2.298' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704565' WHERE `Matrix_Unique_ID` = '211934642'  --> Updated record success<br />