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-05T09:25:34.003' ,`MLSNumber` = '42668809' ,`ListAgentFullName` = 'Larry Jacobs' ,`ListOfficeName` = 'Jacobs Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.440894' ,`Longitude` = '-95.694833' ,`PhotoCount` = '19' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 149' ,`StreetNumber` = '17860' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Barndominium on 3 acres just north of historic Montgomery. 2 story, 1920 sq. ft, built in 2012. 3 bed, 2 bath, primary bed down. Family room includes living, dining, and kitchen. Lots of storage. 56x40 shop with 2 roll-up doors and 2 man doors under the same roof can handle four cars easily. 20 ft overhang along one entire side of the building. 9 ft wide covered porch on the front. Secluded at the end of a winding drive, tract is level with scattered hardwoods; no flood plain. Unrestricted, horses allowed! Near Sam Houston National Forest and Lake Conroe; easy to get to The Woodlands/Houston, Huntsville, or Bryan/College Station. This one won\'t last long!' ,`Acres` = '2.8' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0421 Patterson Wm, Tract 40, part' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '130680' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'None' ,`TaxAmount` = '' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694712' WHERE `Matrix_Unique_ID` = '208149786'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T09:55:31.250' ,`MLSNumber` = '26946490' ,`ListAgentFullName` = 'James Green' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.467374' ,`Longitude` = '-95.567470' ,`PhotoCount` = '42' ,`PostalCode` = '77318' ,`RoomCount` = '10' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel' ,`StreetNumber` = '15498' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home with a lot of recent updates located in Corinthian Point, just a short walk to Lake Conroe!!\r\nSituated on two lots with a drive through garage, this house has two bedrooms that can be used as the master bedroom, one downstairs and one upstairs.  Downstairs you have a nice open kitchen with granite counter tops overlooking the breakfast area, living room and dining area.   Tiled floors in the living area with sunk in seating area around the fireplace.   Secondary living area could be used as a den or home office.  Two spare bedrooms are also located downstairs.   Entering the stairs from the front hallway will lead you up to a private master suite, large walk-in shower, oversized tub with double sinks and granite counters and a walk-in closet, outside the suite you will find a large, covered balcony overlooking the back yard.   Above the downstairs master bedroom is a large 26x26 game room with half bath.  Great neighborhood with lots of amenities!!' ,`Acres` = '0.4472' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CORINTHIAN POINT 02, BLOCK 16, LOT 239 & 240' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '19481' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '81' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Corinthian Point 02' ,`TaxAmount` = '7613' ,`TaxRate` = '2.2463' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694713' WHERE `Matrix_Unique_ID` = '208246626'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T09:01:48.050' ,`MLSNumber` = '65985355' ,`ListAgentFullName` = 'Evelyn Randle' ,`ListOfficeName` = 'REMAX ASPIRE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.621252' ,`Longitude` = '-95.403913' ,`PhotoCount` = '27' ,`PostalCode` = '77047' ,`RoomCount` = '10' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Kiev Hills' ,`StreetNumber` = '12711' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Request a viewing of this gorgeous home. This home shows very well with 4 Bedrooms, 2 Full Baths, 1 Half Bath, and 2 Car Garage.  Vinyl Plank flooring throughout except for the bedrooms. Large Walk in Closets. Location is everything near, Elementary school and Parks and Walking Trails.  Large Back Yard. This home has the master downstairs.' ,`Acres` = '0.0904' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 CITY PARK WEST SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3937' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '735' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'City Park West Sec 03' ,`TaxAmount` = '7058' ,`TaxRate` = '3.0307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694713' WHERE `Matrix_Unique_ID` = '208831987'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T08:29:12.133' ,`MLSNumber` = '96843191' ,`ListAgentFullName` = '(KC) Chau Hoang' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948000' ,`Longitude` = '-95.613841' ,`PhotoCount` = '6' ,`PostalCode` = '77429' ,`RoomCount` = '5' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Tall Forest' ,`StreetNumber` = '12009' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful corner lot with matured trees.  Perfectly located to live and work from home.  All room sizes are an approximate and should be verified by buyer.  Make your dream home comes true with your personal touches.' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 TIMBERLAKE ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24263' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberlake Estates' ,`TaxAmount` = '3419' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694713' WHERE `Matrix_Unique_ID` = '209045771'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T09:36:03.723' ,`MLSNumber` = '13993508' ,`ListAgentFullName` = 'Brandon Warren' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718904' ,`Longitude` = '-95.587431' ,`PhotoCount` = '42' ,`PostalCode` = '77082' ,`RoomCount` = '9' ,`ListPrice` = '1069000.00' ,`Status` = 'Active' ,`StreetName` = 'Louvre' ,`StreetNumber` = '11910' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL Custom home on a sprawling corner cul-de-sac lot! Welcome home thru the double iron front doors, sweeping 2 story foyer with stunning iron stairway, formal living and dining areas, neutral colors, marble inlaid floors, natural light, cove lighting in the formal spaces, custom wall treatments, plantation shutters, spacious Chefs kitchen with granite countertops, abundance of prep & storage space, walk in pantry, breakfast bar, dry bar w/ wine storage, surround sound, expansive primary retreat at 2nd floor with sitting area & coffee bar, incredible bath retreat with dual vanities, generous storage & dressing space,game/media rm (currently used as an office), spacious guest rooms, whole house water filtration system, large backyard with endless design options-great for pets, a pool or a play area if desired, inviting covered patio w/ electric sun shade, beautiful landscape,3 car garage,whole home water filtration system, rare cul-de-sac lot in ROCC!' ,`Acres` = '0.2775' ,`Area` = '31' ,`BuilderName` = 'Vanguard Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 13' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12086' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '22020' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694713' WHERE `Matrix_Unique_ID` = '210813468'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T09:35:27.643' ,`MLSNumber` = '44123985' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.121680' ,`Longitude` = '-95.566950' ,`PhotoCount` = '14' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '599531.00' ,`Status` = 'Active' ,`StreetName` = 'Songlark Bend' ,`StreetNumber` = '24735' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 44123985 - Built by Toll Brothers, Inc. - Ready Now! ~ Modeled in this amazing community, the Angelo High Plains plan is a single-story home with an expanded covered patio to enjoy water views.  A stunning home with secluded office for remote working is thoughtfully placed at the front of the home.  Two large bedrooms with shared hall bath are ideal for family and friends.  A spacious kitchen with added cabinets and center island open to the great room boasting a dramatic sloped ceiling.  Find respite in the primary bedroom with ensuite featuring double sinks, separate tub and shower, and large walk-in closet.  Energy efficient HVAC, and south-facing home site.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 LAKES AT CREEKSIDE SEC 8' ,`LotDesciption` = 'Other' ,`LotSize` = '11490' ,`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` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694713' WHERE `Matrix_Unique_ID` = '210935477'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T08:26:53.563' ,`MLSNumber` = '12813457' ,`ListAgentFullName` = 'Ina Perlman' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737925' ,`Longitude` = '-95.451211' ,`PhotoCount` = '11' ,`PostalCode` = '77027' ,`RoomCount` = '6' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Alabama' ,`StreetNumber` = '4503' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'For sale at lot value and great opportunity for new construction in highly sought after inner loop neighborhood of Afton Oaks. 8440 square foot lot with beautiful mature oak trees. Walking distance to River Oaks District, Highland Village, and the Galleria. - Houston\'s finest shopping and restaurants. Easy access to Highway 610. Existing home is conveyed \"as is\". Please make appointment to walk the lot.' ,`Acres` = '0.1924' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 AFTON OAKS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Afton Oaks' ,`TaxAmount` = '14334' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694713' WHERE `Matrix_Unique_ID` = '210988225'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T09:36:03.553' ,`MLSNumber` = '71418960' ,`ListAgentFullName` = 'Charles Thigpen' ,`ListOfficeName` = 'Kingston Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.859553' ,`Longitude` = '-95.621618' ,`PhotoCount` = '41' ,`PostalCode` = '77041' ,`RoomCount` = '5' ,`ListPrice` = '317900.00' ,`Status` = 'Active' ,`StreetName` = 'Wheatbridge' ,`StreetNumber` = '13906' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOTS OF POTENTENTIAL IN THIS TWO STORY FLOOR PLAN IN CONCORD BRIDGE SEC 6 AREA * 2610 SQFT 4 BEDROOM 2.5 BATH LOCATED IN CYFAIR SCHOOL DISTRICT * CROWN MOLDING * WOOD STAIRS * MULTIPLE BAY WINDOWS * HIGH CEILINGS * GRANITE COUNTERTOPS * LARGE KITCHEN ISLAND * GAS RANGE * MASTER SUITE DOWNSTAIRS * GARDEN TUB W SEPARATE SHOWER AND DUAL SINKS * PRIVACY TOILET * LARGE GAMEROOM/MEDIA ROOM * COVERED PATIO * ROOF AROUND 3 YEARS OLD PER SELLER * CONVENIENTLY LOCATED BETWEEN 290,I10, BELTWAY AND HWY 6 * CLOSE TO ENERGY CORRIDOR * AREA POOLS, TENNIS COURTS, WALKING TRAIL AND MULTIPLE NEIGHBORHOOD PARKS * PLEASE VERIFY YOUR OWN MEASUREMENTS * PRICED TO SELL!' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 CONCORD BRIDGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'CONCORD BRIDGE' ,`TaxAmount` = '' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694713' WHERE `Matrix_Unique_ID` = '211084226'  --> Updated record success<br />