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-24T01:22:00.290' ,`MLSNumber` = '35867634' ,`ListAgentFullName` = 'Liliana Martinez' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780658' ,`Longitude` = '-95.322767' ,`PhotoCount` = '50' ,`PostalCode` = '77020' ,`RoomCount` = '4' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'Noble' ,`StreetNumber` = '4701' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home!! LOCATION! Just minutes away from downtown & the anticipated East River Project along Buffalo Bayou.\r\nCORNER READY TO MOVE IN HOME-FIRST floor offers: Open concept KITCHEN w granite counters & Large island, dark brown Cabinets, High ceilings, recessed lighting. All Stainless Appliances Included. A nice Half bath, An office/study Room w french doors with plenty Natural Lighting. BIG 4car Garage with remote gate & Projector included. Nice size utility Room with washer/dryer connections. 4 bedrooms each with own Bathroom located in the 2nd floor. BIG Master Bedroom w/ beautiful bathroom and big walk in closet. \r\nNice size Game room to entertain.                 Bring your Offer!!            ***Motivated Seller\r\nThis is a Must-see Custom built Home. Buyer to verify Room dimensions and schools.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 91 AUGUSTA' ,`LotDesciption` = 'Corner' ,`LotSize` = '3411' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Augusta' ,`TaxAmount` = '11446' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702291' WHERE `Matrix_Unique_ID` = '208748573'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T00:20:40.767' ,`MLSNumber` = '89217012' ,`ListAgentFullName` = 'Patrick Sullivan' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032439' ,`Longitude` = '-95.566313' ,`PhotoCount` = '36' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '478900.00' ,`Status` = 'Active' ,`StreetName` = 'Bishops Place' ,`StreetNumber` = '1331' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2911' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare 1-story pool home in Gleannloch Farms. Great location, great schools, great bones, and fantastic floor plan. Neighborhood amenities include 3 pools, splash pad, tennis and volleyball courts, lakes, dog park, equestrian center, basketball pavilion, baseball/soccer fields, & 27 hole Gleannloch Pines golf course.' ,`Acres` = '0.2' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 GLEANNLOCH FARMS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms' ,`TaxAmount` = '9632' ,`TaxRate` = '2.6115' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702291' WHERE `Matrix_Unique_ID` = '209113645'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T01:22:00.290' ,`MLSNumber` = '53999544' ,`ListAgentFullName` = 'Mike Livingston' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701274' ,`Longitude` = '-95.461389' ,`PhotoCount` = '50' ,`PostalCode` = '77401' ,`RoomCount` = '19' ,`ListPrice` = '3889000.00' ,`Status` = 'Active' ,`StreetName` = 'BOLIVAR' ,`StreetNumber` = '503' ,`StreetSuffix` = '' ,`City` = 'Bellaire' ,`BathsFull` = '7' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '7471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional & elegant California modern is brought together with finely detailed custom finishes, and the premier Bellaire location. Built by well-regarded Scott Frasier Homes, it is an island of tranquility designed by the present owner with J. Marshall Porterfield Jr Architects to accommodate an active family as well as large scale entertaining (SEE the attached Floor Plan and Video). The spacious lot (22,352 per HCAD) provides a private resort setting with beautiful pool/spa, sport court and wide covered logia with summer kitchen for outdoor dining complete with a wood fired pizza oven. Over 2,300 SF measured exterior covered porch area. The Primary is downstairs with five more bedrooms upstairs. The 540 SF pool house at the back is perfect for guests or office/exercise space. The generator can power the entire house. The home is fully automated and has a state-of-the-art security system. SEE photo captions for complete details. Never flooded.' ,`Acres` = '0.5131' ,`Area` = '17' ,`BuilderName` = 'Scott Frasier Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 ROBIN OAKS' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '22352' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Robin Oaks' ,`TaxAmount` = '42538' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702291' WHERE `Matrix_Unique_ID` = '209809671'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T01:30:19.163' ,`MLSNumber` = '13570908' ,`ListAgentFullName` = 'Fatema Moqbel' ,`ListOfficeName` = 'Century 21 Olympian Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701997' ,`Longitude` = '-95.763127' ,`PhotoCount` = '40' ,`PostalCode` = '77494' ,`RoomCount` = '12' ,`ListPrice` = '660000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Prominence' ,`StreetNumber` = '6327' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS 2 story home 6 bedrooms & 4.5 bathrooms built in 2018. Located on large CUL-DE-SAC in private GATED community inside the Grand Parkway.  Katy ISD & Seven Lakes High School. Home has covered patio, fireplace, game room & media room. Open island kitchen with extra cabinets & 2 bedrooms down.  Primary bedroom is located on 1st floor with Master Bath that has deck mounted tub, mud set shower & dual sinks. Second bedroom downstairs has its own full bathroom. Great for your IN LAWS or GUESTS. Exterior features a STUNNING brick, stone, & stucco castle elevation.  UPGRADED countertops & lush carpet. Sprinkler system. No REAR neighbors. Back yard is LARGE enough to build your DREAM Swimming pool. Owners added CLOSET in the primary bedroom & another HUGE one in game room upstairs. Buyers and their agents need to verify everything & measurement.' ,`Acres` = '0.2319' ,`Area` = '36' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND Ridge CROSSING, BLOCK 1, LOT 47' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10128' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Grand Ridge Crossing' ,`TaxAmount` = '13067' ,`TaxRate` = '2.8712' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702291' WHERE `Matrix_Unique_ID` = '210799652'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T01:22:00.290' ,`MLSNumber` = '30577962' ,`ListAgentFullName` = 'Shannon Hall' ,`ListOfficeName` = 'Gulf Coast, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495696' ,`Longitude` = '-94.912064' ,`PhotoCount` = '47' ,`PostalCode` = '77539' ,`RoomCount` = '0' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue A' ,`StreetNumber` = '211' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '5200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5,200 square foot building w/ 1,600 square foot covered area, sitting on over a 1/2 acre! Amazing Galveston Bay views and just 1 block from Eagle Point boat launch. Property was built up w/ over 700 loads of dirt to meet flood grade level. 3 Phase Industrial Central Air Conditioners. Interior features commercial grade epoxy high gloss floor coating, 3 Simu operated rolling shutter doors, kitchen with two oversized bar areas, leather granite counters, double under mount sinks, stainless appliances, commercial beverage coolers, two toned shaker cabinets and gas stove. Interior is paneled with knotty pine and top level is painted black with picture windows. Easily add your second living area/loft space. Vintage Edison bulb drop lighting throughout. Large full bath features walk-in shower w/ double farm sink and tile floors. Exterior boast over 3000 sqft of concrete for parking/patio with LED lighting. Large backyard and side for addition toys or building. Fully fenced property!' ,`Acres` = '0.6233' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS SUR LOTS 17, 18, 21 THRU 26 & PT OF LOTS 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '27151' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Barndominium,Other Style' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '9957' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702291' WHERE `Matrix_Unique_ID` = '211016813'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T01:22:00.290' ,`MLSNumber` = '2146566' ,`ListAgentFullName` = 'Heidi Dugan' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717361' ,`Longitude` = '-95.444520' ,`PhotoCount` = '38' ,`PostalCode` = '77005' ,`RoomCount` = '16' ,`ListPrice` = '3399000.00' ,`Status` = 'Active' ,`StreetName` = 'Tennyson' ,`StreetNumber` = '4135' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous custom contemporary on an 8,625 sf (HCAD) pool sized lot is a true shop stopper. Rare 6 bedrooms (1 down w/ensuite) plus gameroom, qtrs & 2 studies. Dramatic entry from inviting front porch thru dbl steel doors to grand 12 ft clgs. Tons of natural light thruout. Incredible kitchen open to den w/oversized island, Italian cabinets, double fridge/freezer, 50 bottle wine fridge, convection oven plus steamer & warming drawer. Flex lvg area features spacious den w/see thru fireplace to formal lvg/2nd den. Stately steel doors to covered patio, summer kitchen, & turfed yard w/tree house. Ample mud room, porte-cochere, beautiful powder room, & dining room w/ wine closet.  Huge upstairs gameroom w/kitchenette & lovely balcony. Stunning primary w/separate study & luxurious bath w/soaking tub, dbl shower & dreamy closet. Private access to qtrs/exercise room w/full bath. Massive laundry w/adjacent Xmas/storage closet. Hunter Douglas electric shades. Elevator capable. All per Seller' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 22 & 23A BLK 21 COLONIAL TERRACE SEC C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Colonial Terrace' ,`TaxAmount` = '45984' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702292' WHERE `Matrix_Unique_ID` = '211184718'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T01:28:37.203' ,`MLSNumber` = '93359909' ,`ListAgentFullName` = 'Ethan Hong' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.527682' ,`Longitude` = '-95.176850' ,`PhotoCount` = '13' ,`PostalCode` = '77546' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Tibet' ,`StreetNumber` = '16714' ,`StreetSuffix` = 'Road' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 15 FOREST BEND SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEDGEWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Bend Sec 06' ,`TaxAmount` = '3879' ,`TaxRate` = '2.2534' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702292' WHERE `Matrix_Unique_ID` = '211751448'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T01:00:57.447' ,`MLSNumber` = '89948409' ,`ListAgentFullName` = 'Dante Cruz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144353' ,`Longitude` = '-94.898538' ,`PhotoCount` = '15' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '497000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 66111' ,`StreetNumber` = '391' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction Modern home available in The amazing Encino estates community. Option to choose colors to your satisfaction is still available. Come see this open concept Living area that opens to the beautiful unique kitchen with exceptional finishes.' ,`Acres` = '0.699' ,`Area` = '52' ,`BuilderName` = 'Empire home builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 2, BLOCK 5, LOT 9, ACRES 0.6990' ,`LotDesciption` = 'Other' ,`LotSize` = '30448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '727' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702292' WHERE `Matrix_Unique_ID` = '211752109'  --> Updated record success<br />