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-19T20:07:13.560' ,`MLSNumber` = '87415336' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672531' ,`Longitude` = '-95.465761' ,`PhotoCount` = '44' ,`PostalCode` = '77096' ,`RoomCount` = '13' ,`ListPrice` = '1399990.00' ,`Status` = 'Active' ,`StreetName` = 'Yarwell' ,`StreetNumber` = '5003' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Custom Modern Farmhouse with vintage touches by CastleRock Communities is absolutely stunning! This popular custom Laguna plan is currently under construction, being built upon pier and beam out of the flood zone, and will be ready for a new family before the end of the year. You will fall in love with this dramatic open concept home, it features custom cabinets in the kitchen that go to 10\' and open to a 2-story family room, built-ins, balanced out with a modern linear fireplace. The home is located minutes from the Galleria, Medical Center, parks and is conveniently located near major highways! This beautiful home won\'t last long! Call us today for more details! All homes have a two-year builder-backed warranty!' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15, Block 4, Meyerland Section 8' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9921' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Meyerland' ,`TaxAmount` = '' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700719' WHERE `Matrix_Unique_ID` = '203556781'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T21:57:07.700' ,`MLSNumber` = '63873334' ,`ListAgentFullName` = 'Kay Tanner-Decuir' ,`ListOfficeName` = 'K Decuir Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968329' ,`Longitude` = '-94.006482' ,`PhotoCount` = '37' ,`PostalCode` = '77627' ,`RoomCount` = '12' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Helena' ,`StreetNumber` = '2704' ,`StreetSuffix` = 'Avenue' ,`City` = 'Nederland' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4923' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one owner custom home features designer touches throughout. Dental molding and crown molding with special ceilings make this home a show stopper.  Located on 3/4 an acre this home offers room for continuous entertaining. You will find both formal rooms and large kitchen which will please anyone\'s appetite and a breakfast area. The coffee bar pantry and bonus walk-in pantry(5.9x4.6) with special kitchen features are just a delight. The over-sized bonus room upstairs is currently a second living area and game room. The primary bdrm. boasts a luxury bath, massive walk-in closet and primary french doors opening to the exterior gardens and pool.  All bedrooms hold large furniture and have sitting areas some with window seats and storage. There is a safe room that was designed in this home to provide shelter from any storm or can be used as a large gun safe or wine cellar.   The fenced backyard has an in-ground  pool and there are too many too many other features to list.' ,`Acres` = '0.6826' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 17 RG I TR 1 .468 AC TR 11 .418 AC PALCO' ,`LotDesciption` = 'Corner' ,`LotSize` = '29735' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HELENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'WILSON MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Palco - Ned' ,`TaxAmount` = '13078' ,`TaxRate` = '2.4292' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700719' WHERE `Matrix_Unique_ID` = '208063163'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T20:57:15.907' ,`MLSNumber` = '32804894' ,`ListAgentFullName` = 'Jesus Lopez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018606' ,`Longitude` = '-95.478548' ,`PhotoCount` = '18' ,`PostalCode` = '77068' ,`RoomCount` = '12' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Waycreek' ,`StreetNumber` = '16915' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful house on almost 3 quarters of an Acre of land. Investors special. Home is priced to sell. Home is being sold as-is. Hurry it won\'t last!!!!!' ,`Acres` = '0.8072' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 224 BAMMEL FOREST SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '35160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Forest' ,`TaxAmount` = '7697' ,`TaxRate` = '2.0892' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700719' WHERE `Matrix_Unique_ID` = '209633245'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T20:12:09.187' ,`MLSNumber` = '50780812' ,`ListAgentFullName` = 'Tommy Bowen' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.455637' ,`Longitude` = '-94.935316' ,`PhotoCount` = '27' ,`PostalCode` = '77371' ,`RoomCount` = '5' ,`ListPrice` = '169000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Ridge' ,`StreetNumber` = '100' ,`StreetSuffix` = 'Drive' ,`City` = 'Shepherd' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT INVESTMENT OPPORTUNITY...3 bedroom 2 bath home on just over an acre. Home is livable but is in need of rehab. Some remodeling has been started and it wouldn\'t take much more to make this home shine again. Also included in the sale is an additional .942 acre lot to the right of the home. Total acreage of the 2 lots is just over 2 acres. The lot is cleared. No restrictions. Use the lot to build another residence, put a few farm animals out to graze or build a good sized garden. Located in the country but conveniently located to nearby Shepherd and Cleveland. Quiet community and located in Shepherd ISD. Call today for any interests.' ,`Acres` = '2.0012' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lake Tejas, Lot 165, Acres 1.0592, Lake Tejas, Lot 166, Acre' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '130 - Shepherd' ,`SchoolElementary` = 'SHEPHERD PRIMARY SCHOOL' ,`SchoolHigh` = 'SHEPHERD HIGH SCHOOL' ,`SchoolMiddle` = 'SHEPHERD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Tejas' ,`TaxAmount` = '1859' ,`TaxRate` = '1.8509' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700719' WHERE `Matrix_Unique_ID` = '209705194'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T21:55:34.213' ,`MLSNumber` = '67967832' ,`ListAgentFullName` = 'Douglas Erdy' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.883372' ,`Longitude` = '-95.210152' ,`PhotoCount` = '0' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '1695000.00' ,`Status` = 'Active' ,`StreetName` = 'Garrett' ,`StreetNumber` = '12315' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime unrestriced \"hard corner\" with 2 single family homes located in site. 3.88 acres perfect for gas station-retail-RV park etc. New construction abundent in area' ,`Acres` = '3.89' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 15 & 16 IN LTS 32 & 33 BLK E LINCOLN PARK FARMS' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '169448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln Park Farms' ,`TaxAmount` = '5706' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700719' WHERE `Matrix_Unique_ID` = '211397539'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T20:48:15.493' ,`MLSNumber` = '6764703' ,`ListAgentFullName` = 'Michelle Goswick' ,`ListOfficeName` = 'G2 RE Resource' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.525122' ,`Longitude` = '-95.218146' ,`PhotoCount` = '33' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '1700000.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Phenomenal 2.59-acre estate home with approximately 4972 s/f of living space.  The property is gated and includes 4 bedrooms, 3 full baths & 1 half bath, media room, large game room, pool house/guest quarters, barn, storage building, circular drive, fully fenced and backyard cross-fenced, and a Generac whole-house generator.  The large family room boasts a floor-to-ceiling river rock fireplace, cathedral ceiling, and stained concrete floors.  The garage is equipped with a Nema 14/50 230 volt plug for your Tesla charging. The property contains fig, avocado, plum, peach, and olive trees.' ,`Acres` = '2.592' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 20 PAGE 3 LOT 7 RUSTIC ACRES SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '112908' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Rustic Acres 89' ,`TaxAmount` = '16103' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700720' WHERE `Matrix_Unique_ID` = '211608625'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-19T20:53:58.527' ,`MLSNumber` = '80530054' ,`ListAgentFullName` = 'Nicole Garner' ,`ListOfficeName` = 'Windsor Hill Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.911497' ,`Longitude` = '-95.294599' ,`PhotoCount` = '11' ,`PostalCode` = '75862' ,`RoomCount` = '7' ,`ListPrice` = '65000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchantment' ,`StreetNumber` = '186' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'When all you need is a small weekend getaway to be close to the lake… look no further! This country home features the perfect split floor plan to provide privacy to all occupants. The primary suite has dedicated en-suite bath, while the secondary bedroom has a large bathroom directly adjacent.  The abundance of windows allow in lots of natural light.  The mostly cleared lot has just enough trees to keep the house shaded, without taking up the entire yard.  Located only a few blocks from the lake, take advantage of the community lake access and enjoy some time on Lake Livingston.' ,`Acres` = '0.2129' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEWOOD SECTION 3, BLOCK 09 LOT 167 LABEL # NO TAG' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lakewood' ,`TaxAmount` = '390' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700720' WHERE `Matrix_Unique_ID` = '211637170'  --> Updated record success<br />