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` = '2023-01-31T09:10:27.683' ,`MLSNumber` = '52560806' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473810' ,`Longitude` = '-95.533076' ,`PhotoCount` = '21' ,`PostalCode` = '77459' ,`RoomCount` = '5' ,`ListPrice` = '579438.00' ,`Status` = 'Active' ,`StreetName` = 'Water Breeze' ,`StreetNumber` = '9407' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 52560806 - Built by Toll Brothers, Inc. - Ready Now! ~ The Waller High Plains features luxurious contemporary touches with it\'s welcoming covered porch entry and inviting two-story foyer with tray ceilings that flows into the impressive great room.  The well-designed gourmet kitchen is complete with a large center island with breakfast bar, ample counter and cabinet space, and roomy walk-in pantry.  The elegant primary bedroom suite is enhanced by a gigantic walk-in closet and deluxe bath with dual-sink vanity, freestanding tub and expanded shower.  Central to the loft, the secondary bedrooms feature sizeable closets, one with private bath, two with shared hall bath.  Additional highlights include a versatile office, convenient powder bath and multi-slide door at great room opening the entertaining space to the covered back patio.  A spacious backyard is large enough for all your outdoor toys or future pool!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 14 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '8080' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Sienna - Villa Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266722' WHERE `Matrix_Unique_ID` = '203011289'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T10:37:44.197' ,`MLSNumber` = '36647820' ,`ListAgentFullName` = 'Leonela Giral' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857912' ,`Longitude` = '-95.426572' ,`PhotoCount` = '41' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Couch' ,`StreetNumber` = '6502' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO HIGHGLANDS HIGHTS, Living 18 mins away from Downtown and the Heights is Ideal, free standing two story home, with double zoned A/C so you can manage the temperature on each floor.  Open floor plan on the family dining and kitchen rooms, quartz countertops with soft closed cabinets on kitchen and bathrooms the master bedroom has double sinks, walking closet and a Balcony street view. there is a powder room on first floor for your convenience .this property awaits your arrival for the new life style.' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Girey Investments' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 12 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Corner' ,`LotSize` = '3000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '577' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266723' WHERE `Matrix_Unique_ID` = '205892562'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T09:49:51.797' ,`MLSNumber` = '37537722' ,`ListAgentFullName` = 'Dana Olejniczak' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019587' ,`Longitude` = '-95.181210' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '17' ,`ListPrice` = '3399000.00' ,`Status` = 'Active' ,`StreetName` = 'Turtle Cove' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '8181' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extraordinary estate nestled on over 1.25 acres in coveted 24 hour manned gated community of Kings Lake Estates that offers an incomparable floor plan with exquisite finishes. Beauty engulfs this masterpiece at every turn. Architectural ceilings everywhere you look. An entertainers dream with an expansive outdoor terrace, fireplace, summer kitchen with a pizza oven all overlooking the stunning pool and grounds. This true chef’s kitchen is heart of the home and boast Culinary Series of Capital, 3 ovens, 2 dishwashers, ice maker and large sub zero side by side. The expansive Primary Suite is stunning with it\'s own private wing. Other unique features include a true Wine Grotto, custom office downstairs with 3 additional office spaces through the home, workout room, 2 laundry rooms, elevator and home generator. All secondary bedrooms have en-suite baths with custom closets. Designed and furnished by a professional Custom Interior Designer-Estate is offered Completely- Fully Furnished.' ,`Acres` = '1.279' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '55713' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3327' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Kings Lake Estates' ,`TaxAmount` = '45316' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266723' WHERE `Matrix_Unique_ID` = '207917294'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T09:56:47.633' ,`MLSNumber` = '91013116' ,`ListAgentFullName` = 'Chase Giles' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151269' ,`Longitude` = '-95.471637' ,`PhotoCount` = '30' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Kino' ,`StreetNumber` = '1' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location and close to EVERYTHING, I-45, Market Street, HEB & Whole Foods. Corner of a cul-de-sac opposite golf course. Updated with granite counters and \"wood-look\" tile throughout the first floor. Vaulted ceilings in the living room with a stone front fireplace, nice size closets, game room/flex space upstairs overlooking living space.' ,`Acres` = '0.1904' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML13, BLOCK 1, LOT 22' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '8295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 13' ,`TaxAmount` = '3215' ,`TaxRate` = '2.0079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266723' WHERE `Matrix_Unique_ID` = '208181246'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T09:14:10.460' ,`MLSNumber` = '8237025' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120429' ,`Longitude` = '-95.565819' ,`PhotoCount` = '8' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '449664.00' ,`Status` = 'Active' ,`StreetName` = 'Keswick Valley' ,`StreetNumber` = '24623' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 8237025 - Built by Toll Brothers, Inc. - Ready Now! ~ New Floor Plan!  The Angelo High Plains provides space and function for active lifestyles.  A versatile bedroom with closet could be used for home office or guest suite with full bath just across the hall.  The well-appointed kitchen offers a center island with breakfast bar, ample storage with the walk-in pantry, tons of counter and cabinet space.  The great room boasts dramatic sloped ceilings that carry through multi-slide doors onto the covered patio.  A spacious primary bedroom includes an en-suite with double-door entry, separate tub and shower, dual sinks and walk-in closet.  Two additional secondary bedrooms with hall bath make room for friends and family!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 17 Blk 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5376' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266723' WHERE `Matrix_Unique_ID` = '208232565'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T09:23:48.673' ,`MLSNumber` = '7723039' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.319263' ,`Longitude` = '-95.452327' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '629000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeland Circle' ,`StreetNumber` = '1514' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'tuated on a 1 acre home site, the Sausalito plan is a sophisticated design packed with unique features!  The rounded breakfast area, spiral staircase, and two story dining make an impressive statement in this stunning four bedroom plan. The master on suite features his and hers walk-in closets, dual vanities, and a large soaker tub. This home makes entertaining a breeze with a family size media and game room on the second story.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '45302' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'The Oaks at Suncreek Estates' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266724' WHERE `Matrix_Unique_ID` = '208376253'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T09:15:54.260' ,`MLSNumber` = '81867558' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118784' ,`Longitude` = '-95.565696' ,`PhotoCount` = '12' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '579803.00' ,`Status` = 'Active' ,`StreetName` = 'Blackwell Orchard' ,`StreetNumber` = '9314' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3049' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 81867558 - Built by Toll Brothers, Inc. - Ready Now! ~ Now Available!  The Angelina Traditional plan has a classic Texas brick and stone exterior with exemplary curb appeal.  With an idyllic blend of comfort and elegance, this home fits your lifestyle.  The open-concept kitchen and great room provide the perfect area for entertaining.  Embrace relaxation in the sun-filled great room that is bursting with natural light and is adjacent to the kitchen \r\nand casual dining area.  Overnight guest will enjoy the secluded bedroom with full hall bath.  Two generously sized bedrooms and full hall bath are perfectly located near the sizable loft/flex area and private media room.  Additional highlights include energy efficient appliances and HVAC system, 3-car garage, sloped ceilings, and covered patio.  Act now to claim your new home!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Blk 1 Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266724' WHERE `Matrix_Unique_ID` = '208473375'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T09:32:04.850' ,`MLSNumber` = '94677034' ,`ListAgentFullName` = 'James Monk' ,`ListOfficeName` = 'J. Frank Monk Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947931' ,`Longitude` = '-96.258777' ,`PhotoCount` = '39' ,`PostalCode` = '77418' ,`RoomCount` = '9' ,`ListPrice` = '449500.00' ,`Status` = 'Active' ,`StreetName` = 'Holland' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built on a large lot with manicured landscaping in the historic town centre of Bellville, Texas.  The well layed out generous 4 bed, 2 bath floor plan features spacious room sizes and a open living concept.  Adjoiing the living room is the stylish kitchen with granite island perfect for casual dining along with an additional dining area.  Outside the generous lot size is reflected with the 2 carports, RV/boat covered parking, seperate 45x27 ft garage/workshop, and covered patio for entertaining.  Rounding out this home is location, within walking distance of the town square lined with shops and dining as well as close to schools and lots of other local amenitites.  This home is the perfect combination of cozy and functional indoors and out.' ,`Acres` = '0.469' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A073 J NICHOLS' ,`LotDesciption` = 'Other' ,`LotSize` = '20430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '5351' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675266724' WHERE `Matrix_Unique_ID` = '208532467'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-31T09:16:42.680' ,`MLSNumber` = '50912114' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119466' ,`Longitude` = '-95.565384' ,`PhotoCount` = '10' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '529712.00' ,`Status` = 'Active' ,`StreetName` = 'Keswick Valley' ,`StreetNumber` = '24555' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 50912114 - Built by Toll Brothers, Inc. - Ready Now! ~ Modern luxury meets elegant design in this stunning Navarro Traditional plan.  Thoughtfully designed, flexible spaces are perfect for how you live.  A welcoming foyer with soaring ceilings leads to a secluded bedroom that could double as a home office, and full hall bath.  The expanded kitchen offers ample cabinets and counter space.  A center island is perfect for food prep.  The great room is perfectly designed with a cozy fireplace for cool evenings and multi-slide glass doors that lead to a covered patio expanding your living and entertaining space. Respite can be found in the primary bedroom featuring a tray ceiling and en-suite with double door entry, luxury tub and shower, double vanity and spacious walk-in closet.  Additional highlights are two spacious bedrooms full bath , loft, flex space and private media room.  This home won\'t last long, schedule your tour today.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Blk 1 Lot 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6192' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266724' WHERE `Matrix_Unique_ID` = '208535708'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Storie