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-05T13:45:38.617' ,`MLSNumber` = '51720676' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Tanya Coury' ,`SellingOfficeName` = 'Waller County Land Co.' ,`Latitude` = '30.085724' ,`Longitude` = '-95.951473' ,`PhotoCount` = '6' ,`PostalCode` = '77484' ,`RoomCount` = '18' ,`ListPrice` = '540000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bright Bluff' ,`StreetNumber` = '212' ,`StreetSuffix` = 'Circle' ,`City` = 'Waller' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This amazing Briarwood Home in Beacon Hill is what you’ve been looking for. This 4-sided brick home boasts a premium elevation, no back neighbors, tile flooring, wrought iron spindles, cast stone fireplace, study with French doors, media room, walk-in shower in the primary suite, and a covered patio. Create new recipes in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Community comforts include 30 acres of green recreational spaces, paved trails, and a recreation center. Situated off U.S. 290, the Northwest Freeway, between FM 362 and James Muse Parkway, residents love the easy access to a variety of restaurants, shops, and outdoor recreation areas. Nearby schools are zoned to Waller ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694774' WHERE `Matrix_Unique_ID` = '205464305'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T13:23:37.537' ,`MLSNumber` = '14436920' ,`ListAgentFullName` = 'Jennifer Dang' ,`ListOfficeName` = 'VNA Realty & Mortgage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.891698' ,`Longitude` = '-95.511316' ,`PhotoCount` = '10' ,`PostalCode` = '77040' ,`RoomCount` = '3' ,`ListPrice` = '259500.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Fern' ,`StreetNumber` = '7902' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tenant occupied . Please appointment to show after 2pm.  \r\n Great Loca6ion.3/2/2. Easy to access highway 290, Hw 249. Corner lot. Spacious family room with living area/study  room. Kitchen with breakfast area.' ,`Acres` = '0.1521' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1197 BLK 25 WOODLAND OAKS SEC 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '6626' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodland Oaks Sec 05' ,`TaxAmount` = '4050' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694774' WHERE `Matrix_Unique_ID` = '206930917'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T12:05:43.013' ,`MLSNumber` = '39094430' ,`ListAgentFullName` = 'Wanda Simons' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.849910' ,`Longitude` = '-95.443620' ,`PhotoCount` = '10' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '152500.00' ,`Status` = 'Active' ,`StreetName` = 'Fisherman\'s Trail' ,`StreetNumber` = '93' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to create a vacation rental or make it your own special getaway!  Beautiful wood paneling and floors make it a cozy cabin. Close to the Marina with access to the lake for fishing, boating, kayaking, and other water activities  This unique place includes Central A/C, energy-efficient windows and plenty of insulation.   There is also an enclosed boat shed along with a large, covered parking area that has water and electric connections perfect for parking an RV.' ,`Acres` = '0.39' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HARMON CREEK RIDGE - SEC 1, LOT 909' ,`LotDesciption` = 'Cleared' ,`LotSize` = '17070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harmon Creek Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663694774' WHERE `Matrix_Unique_ID` = '207444196'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T12:47:43.057' ,`MLSNumber` = '57751627' ,`ListAgentFullName` = 'Jamie Bechtold' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219568' ,`Longitude` = '-95.576476' ,`PhotoCount` = '25' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '399700.00' ,`Status` = 'Active' ,`StreetName` = 'Nickaburr Creek' ,`StreetNumber` = '7102' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1995' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL POOL! The cutest home is waiting for you in Westwood. This 3 bed, 2 bath home features an office that could easily be turned into a fourth bedroom. Tall ceilings make this home a timeless beauty. Out back, you are sure to fall in love with the beautiful pool! Recent upgrades to the home include fresh paint, upgraded tile, and a brand new AC (2021). Located right off of 1488, shopping, dining, and fun are never too far away. Schedule a showing with us today!' ,`Acres` = '0.4452' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 01, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '19392' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '228' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood' ,`TaxAmount` = '5128' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694774' WHERE `Matrix_Unique_ID` = '207935466'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T12:20:43.090' ,`MLSNumber` = '17143152' ,`ListAgentFullName` = 'Liliana Pena' ,`ListOfficeName` = 'Keller Williams Realty         - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710553' ,`Longitude` = '-95.166787' ,`PhotoCount` = '21' ,`PostalCode` = '77503' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Bond' ,`StreetNumber` = '3206' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just Listed! Come see this beautiful 4 bedroom 2 baths home located in a quiet neighborhood. Home has been completely renovated with modern touches, zoned to Deer Park ISD. Large backyard, double drive way, single-story house with washer and dryer connections in the inhouse utility room. Close to Highway 225 and Beltway 8 and all the industrial complexes.' ,`Acres` = '0.1607' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 DEEPWATER TERRACE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEEPWATER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEEPWATER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Deepwater Terrace Sec 01' ,`TaxAmount` = '4695' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694775' WHERE `Matrix_Unique_ID` = '208431558'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T12:56:06.110' ,`MLSNumber` = '34087808' ,`ListAgentFullName` = 'Lisa Corker' ,`ListOfficeName` = 'Hart Land Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887927' ,`Longitude` = '-96.884571' ,`PhotoCount` = '38' ,`PostalCode` = '78945' ,`RoomCount` = '8' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Hill' ,`StreetNumber` = '503' ,`StreetSuffix` = 'Drive' ,`City` = 'La Grange' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your own private resort! Modern, Mediterranean-style villa with 3 or 4 bedrooms, 3 full baths and two half baths including a pool bath. Downstairs primary suite includes an office and has a private outdoor enclosure with a shower. Dramatic architectural details like stone staircase, concrete columns, arched entryways, and walls of windows overlooking the back lanai with outdoor kitchen/living, rock waterfall, ceilings fans, wood-burning fireplace, and infinity pool with fountains. Bright and open floor plan with high ceilings, stained & scored concrete floors. Kitchen has granite and SS appliances, island, breakfast bar, wet bar, wine cooler. Great location in Frisch Auf Valley Country Club. Beautiful 1.25 acres with oak trees, elevation changes, and a ravine. Drive your golf cart to the 9-hole Frisch Valley golf course less than a mile away.' ,`Acres` = '1.25' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FRISCH AUF, SEC 3 LOT 19, SEC 10 LOT 29 & 0.423 ACRE .89 HSE' ,`LotDesciption` = 'Ravine' ,`LotSize` = '54450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '205 - La Grange' ,`SchoolElementary` = 'HERMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA GRANGE HIGH SCHOOL' ,`SchoolMiddle` = 'LA GRANGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Frisch Auf - Sec 3' ,`TaxAmount` = '11711' ,`TaxRate` = '1.8546' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694775' WHERE `Matrix_Unique_ID` = '209161751'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T13:40:50.600' ,`MLSNumber` = '44887222' ,`ListAgentFullName` = 'Debra Headrick' ,`ListOfficeName` = 'RE/MAX All Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232019' ,`Longitude` = '-94.199904' ,`PhotoCount` = '32' ,`PostalCode` = '77657' ,`RoomCount` = '9' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'El Pinto' ,`StreetNumber` = '175' ,`StreetSuffix` = 'Drive' ,`City` = 'Lumberton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a large home in Lumberton ISD? Then look no further. This home features 5 bedrooms, 3 baths, 3 car garage, and plenty of parking on the long driveway. Master bedroom is downstairs and has double sinks, jetted bathtub ,and two closets. Additional bedroom downstairs with remaining 3 bedrooms upstairs, all with new carpet along with the stairwell. Master bedroom and living area have wood floors, with tile floors in kitchen and bathrooms. Enjoy relaxing on the covered patio overlooking the large fenced in backyard! Located on a quiet dead end street with easy access to Highway 69 and Highway 96. Call today to schedule an appointment to view this home!' ,`Acres` = '0.3857' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8 EL PINO SEC 2 P# CL2-EP-8 I# 1497/150 05/04/2005' ,`LotDesciption` = 'Other' ,`LotSize` = '16801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'El Pino Sec 2' ,`TaxAmount` = '3783' ,`TaxRate` = '1.8866' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694775' WHERE `Matrix_Unique_ID` = '211099888'  --> Updated record success<br />