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-30T23:59:07.390' ,`MLSNumber` = '28628153' ,`ListAgentFullName` = 'Jill Hamlin' ,`ListOfficeName` = 'Keller Williams Realty Austin' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS                       ' ,`Latitude` = '30.313231' ,`Longitude` = '-97.915689' ,`PhotoCount` = '38' ,`PostalCode` = '78738' ,`RoomCount` = '4' ,`ListPrice` = '800000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Emerald Falls' ,`StreetNumber` = '11608' ,`StreetSuffix` = 'Drive' ,`City` = 'Austin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully updated 4 bedroom home is nestled among the trees in fabulous Lake Pointe. This one features hardwoods, a dedicated office, gorgeous baths, large closets and a backyard with a deck and hot tub! The kitchen is adjacent to the private living area with an island and breakfast bar. The primary suite is bright, sunny and spa like with its tasteful updates and private deck overlooking the trees. This culdesac street is within easy walking distance to the exemplary elementary school, the Lake Pointe dock on Lake Austin, Whole Foods and everything the Hill Country Galleria has to offer.' ,`Acres` = '0.1492' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 16 BLK D LAKE POINTE SEC 3 PHS 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '115 - Lake Travis' ,`SchoolElementary` = 'LAKE POINTE ELEMENTARY SCHOOL (LAKE TRAVIS)' ,`SchoolHigh` = 'LAKE TRAVIS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE TRAVIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Pointe' ,`TaxAmount` = '9278' ,`TaxRate` = '2.011' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704971' WHERE `Matrix_Unique_ID` = '206947869'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T22:14:46.937' ,`MLSNumber` = '92418767' ,`ListAgentFullName` = 'Marcey Nelson' ,`ListOfficeName` = 'Evans and Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.707532' ,`Longitude` = '-94.880503' ,`PhotoCount` = '32' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '139000.00' ,`Status` = 'Active' ,`StreetName` = 'Eastern' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful setting 3/2 like new Mobile home with rock driveway, covered front and back decks sitting on 3 lots.  Just minutes from town. Quiet and peaceful subdivision... don’t miss out on this one!  Will also make great investment property.' ,`Acres` = '0.9052' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CRYSTAL LAKES SECTION 3 LOT 68, 69 & 70' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '39432' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Crystal Lakes Sec 3' ,`TaxAmount` = '89' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704972' WHERE `Matrix_Unique_ID` = '209102046'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T22:10:04.960' ,`MLSNumber` = '33097688' ,`ListAgentFullName` = 'Alfred Rincon' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.829050' ,`Longitude` = '-95.230481' ,`PhotoCount` = '50' ,`PostalCode` = '77320' ,`RoomCount` = '10' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Beach' ,`StreetNumber` = '22505' ,`StreetSuffix` = 'Way' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful Home Has it All! Located in the Peaceful & Relaxing Waterwood Community on Lake Livingston, this home is situated on the golf course with a view of the lake, golf course, and amazing sunsets. Designed by renowned Green Building Architect, LaVerne Willliams, this home boasts exceptional high efficiency facilitated by double pane windows, a Geo-thermal heat pump, radiant barrier, and 6\" perimeter framing. Large windows across the rear of the home maximize your views and abundance of natural light into the home. This home exudes pride-of-ownership, and includes many recent upgrades including the roof in 2018, appliances in 2015, kitchen cabinets, backsplash, island and lights in 2017. The price includes the adjacent lot (Block 5 Lot 24) providing you with options for a pool, second structure, or leave wooded for additional privacy. Marina 5 Mins away. You deserve this perfect combination of golf, lake, and nature-centric lifestyle. Come see it Today!' ,`Acres` = '0.2379' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WATERWOOD - COUNTRY CLUB EST #1, BLOCK 5, LOT 23, ACRES .237' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Water View' ,`LotSize` = '10363' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '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,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Waterwood Country Club Estate #2' ,`TaxAmount` = '3916' ,`TaxRate` = '2.3654' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704972' WHERE `Matrix_Unique_ID` = '209887138'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T23:04:14.640' ,`MLSNumber` = '26488578' ,`ListAgentFullName` = 'Daniel Martinez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795913' ,`Longitude` = '-95.364528' ,`PhotoCount` = '18' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Hain' ,`StreetNumber` = '3909' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the growing Northside, this beautiful remodeled 3 bedroom, 2 bathroom home is ideally located near downtown and the light rail. Inside, you’ll find a bright and spacious floor plan. The main living area offers lots of windows, connecting to the beautiful kitchen and dining area with wood style laminate flooring throughout. The floor plan features a primary suite with a closet and an en-suite bathroom. With a second and third bedroom, a second full bathroom, and a independent second story yoga/office studio hosting a wrap around 180 degree window view. The finishes are clean, minimal, and modern. This cozy house is a must-see!' ,`Acres` = '0.0887' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 5A BLK 6 IRVINGTON COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Irvington Court Add' ,`TaxAmount` = '4559' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704972' WHERE `Matrix_Unique_ID` = '211219230'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T22:10:34.507' ,`MLSNumber` = '12793258' ,`ListAgentFullName` = 'Lina Liu' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733793' ,`Longitude` = '-95.469443' ,`PhotoCount` = '39' ,`PostalCode` = '77056' ,`RoomCount` = '7' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Lampasas' ,`StreetNumber` = '5322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom David Weekly Home in the heart of the Galleria.  This Gorgeous Mediterranean style home features 4 Bedrooms, 4 bathrooms or 3 bedrooms with a custom library, coffee station/liquor bar, cocktail pool with waterfall feature, fountains, summer kitchen, and much more.   Antique front door leads to a peaceful and inviting courtyard for your morning coffee, great open layout with picture windows that looks into the amazing backyard.  Kitchen, library and many other features of the home were beautifully renovated in 2020.   Walking distance to the Galleria and minutes from World-class restaurants and shops and highly acclaimed Mandarin Immersion School.  Schedule your private showing today!' ,`Acres` = '0.1515' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 5 LAMAR TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Lamar Terrace' ,`TaxAmount` = '22577' ,`TaxRate` = '2.4457' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704972' WHERE `Matrix_Unique_ID` = '211832776'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T23:32:47.687' ,`MLSNumber` = '97360508' ,`ListAgentFullName` = 'Ricardo Cervantes' ,`ListOfficeName` = 'TX Hacienda’s Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028595' ,`Longitude` = '-95.307575' ,`PhotoCount` = '50' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Hagilbert' ,`StreetNumber` = '21614' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Upgraded Home with a large 25,096 square feet lot, located in Oak Hill Estates. The current owner made the upgrades the year he bought the property. Upgrades include an added Media Room to the home with built in speakers and entertaining lights. In the kitchen, Quartz Countertops were added, all laminate flooring, modern gray split stone fireplace, recessed lighting thru out the home. Primary Bathroom with upgraded Tiled Shower with sliding glass doors. The house has a grand patio deck in the back connected to the home for any type of gathering event. Located near Intercontinental Airport, FM 1960, Highway 69, Deerbrook Mall and all the surrounding amenities of Humble.' ,`Acres` = '0.5761' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 OAK HILL ESTATES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '25096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Hill Estates Sec 01' ,`TaxAmount` = '2563' ,`TaxRate` = '2.0933' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704972' WHERE `Matrix_Unique_ID` = '211960086'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T23:50:10.313' ,`MLSNumber` = '95593757' ,`ListAgentFullName` = 'Fanyu Meng' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660451' ,`Longitude` = '-95.365440' ,`PhotoCount` = '15' ,`PostalCode` = '77051' ,`RoomCount` = '13' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Clover' ,`StreetNumber` = '4206' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss out on the opportunity to customize this two story new construction home to your likings! Do you want to have the freedom to select your own cabinet style, wall colors, and countertops, but don’t want the hassle and expense of building your own custom home from start to finish? Reach out to us and we can help you figure out your options! We also have 3D walkthrough virtual tour available upon request!\r\nThe home is currently under construction, and the sooner you get in on it, the more customizable options you will have!\r\nSome of the notable features include a 2nd floor work area where you can WFH with a window view; an entertainment area on the 2nd floor with lots of natural light; as well as three bedrooms that each has lots of windows and lots of natural light.' ,`Acres` = '0.0768' ,`Area` = '3' ,`BuilderName` = 'Pinewood RE LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 CLOVER STREET LANDING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3345' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Traditional' ,`Subdivision` = 'Reed Terrace' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704972' WHERE `Matrix_Unique_ID` = '211995264'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T22:56:13.707' ,`MLSNumber` = '2061765' ,`ListAgentFullName` = 'Jill Navarro' ,`ListOfficeName` = 'Navarro Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.300780' ,`Longitude` = '-94.713628' ,`PhotoCount` = '18' ,`PostalCode` = '75901' ,`RoomCount` = '3' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Hill Dr' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Drive' ,`City` = 'Lufkin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1097' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute as a bug and very well kept home in a wonderful location. The fenced yard offers your own private retreat.' ,`Acres` = '0.1598' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '6733 WHISPER CREEK SECTION 1 BLK 1 LOT 26' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = '' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Whisper Creek Sec 1' ,`TaxAmount` = '2816' ,`TaxRate` = '2.3856' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704972' WHERE `Matrix_Unique_ID` = '211998761'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T23:52:08.073' ,`MLSNumber` = '36098046' ,`ListAgentFullName` = 'Alexandra McCauley' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732777' ,`Longitude` = '-95.324457' ,`PhotoCount` = '34' ,`PostalCode` = '77023' ,`RoomCount` = '9' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Pease' ,`StreetNumber` = '5127' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5127 Pease St in the heart of EADO. FULLY remodeled property, nestled in a pocket of town w/new construction & remodeled homes on every street. Lovely sidewalks & new eateries, bars & entertainment in every direction! Just minutes from downtown, Eastwood Park & quick drive to Ninfas, El Tiempo, Nancy\'s Hustle, Truck Yard, Minute Maid Park, U of H, George R Brown Convention Center & the Med Center. Structural upgrades include: PEX plumbing, framing, sheetrock, siding, interior/exterior paint, recessed lighting, updated attic insulation, tankless H2O heater, double pane windows, updated electrical, recently installed AC & roof, landscaping & tons more! Home was designed w/current trends in mind including wide plank engineered hardwood floors throughout, custom kitchen shaker cabinets, white quartz countertops & trending backsplash. Open kitchen concept overlooks the living & dining rooms, the ideal space for entertaining. Stunning primary suite & bath. Large backyard.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 & TR 21 BLK 9 DISSEN HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dissen Heights' ,`TaxAmount` = '3152' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704973' WHERE `Matrix_Unique_ID` = '211998953'  --> Updated record success<br />