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-10-14T03:37:01.103' ,`MLSNumber` = '33402850' ,`ListAgentFullName` = 'Albric Rosa' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.969276' ,`Longitude` = '-95.230942' ,`PhotoCount` = '26' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Cormorant' ,`StreetNumber` = '17327' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 17327 Cormorant Court! You\'ll love all the incredible features this home has to offer, including a gorgeous primary bedroom and bathroom, spacious high ceiling living room with cozy fireplace, upstairs game/play room, good sized backyard, and so much more! Recent updates include Custom Window Frames in the Living Room, New Toilets, Brand New Carpet, New Paint, New Flooring featuring Luxurious Vinyl Plank, New Bathroom Vanity on the Upstairs Bathroom, & All Bathrooms Include Brand New Faucets Along with New Mirrors. You will also find Baseboards & Quarter Round Moldings all around the home. The Seller to be adding New Fence in the South & Eastern direction of the backyard. The Harris County Sheriff\'s Office Academy is located just .5 mile away, just another reason to feel more safe at home! Deerbrook Mall just 11 minutes away. Only 1 other family has lived here, take advantage of this opportunity, schedule your private tour today!' ,`Acres` = '0.1385' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 4 ATASCOCITA TRACE SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '366' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIVER PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Trace Sec 1' ,`TaxAmount` = '5452' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665740647' WHERE `Matrix_Unique_ID` = '211897842'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T03:18:08.210' ,`MLSNumber` = '45951982' ,`ListAgentFullName` = 'Heather Niemeyer' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806090' ,`Longitude` = '-95.575151' ,`PhotoCount` = '23' ,`PostalCode` = '77043' ,`RoomCount` = '11' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood Forest' ,`StreetNumber` = '2069' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a coveted neighborhood of sought after Spring Branch! This lovely single family residence has been meticulously maintained with many updates since it was built in 2019. Brand new hard wood floors installed. Fresh landscaping completed with raised, double layered sod, hedges, rocks and flat stones! Shutters and new hardware installed through out the entire home! New cabinetry added within the utility room. Fresh paint through out. New irrigation system installed. Some fixtures are new as well! Location is prime being that you’ll have quick access to i10 and the beltway. With City Centre, Energy Corridor, downtown Houston and more just minutes away! Schedule a tour today!' ,`Acres` = '0.0464' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 BEYOND METRONOME' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2021' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Beyond Metronome' ,`TaxAmount` = '8243' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665740647' WHERE `Matrix_Unique_ID` = '211963480'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T02:38:03.140' ,`MLSNumber` = '30140573' ,`ListAgentFullName` = 'Quinn Bui' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537658' ,`Longitude` = '-95.570125' ,`PhotoCount` = '46' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Solara Ledge' ,`StreetNumber` = '5906' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 2 Story corner lot home located in Shadow Glen at Riverstone. Open Floor Plan. 5 bedrooms, 4 full baths, 3-car garage. Hardwood floors throughout except media room. GENERAC GENERATOR! Water Softener System. Breathtaking of a heated pool with decor lights. Backyard with coved patio, outdoor kitchen. Security system camera. Garage is finished with an epoxy floor.' ,`Acres` = '0.2054' ,`Area` = '29' ,`BuilderName` = 'HIghland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW GLEN AT RIVERSTONE SEC 3 PHASE 1, BLOCK 1, LOT 13' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8946' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone' ,`TaxAmount` = '11821' ,`TaxRate` = '2.6729' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665740647' WHERE `Matrix_Unique_ID` = '212326955'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T02:45:23.053' ,`MLSNumber` = '60205541' ,`ListAgentFullName` = 'Ayo Oluwi' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548902' ,`Longitude` = '-95.799830' ,`PhotoCount` = '27' ,`PostalCode` = '77471' ,`RoomCount` = '3' ,`ListPrice` = '236000.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2601' ,`StreetSuffix` = 'Avenue' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in a great neighborhood with a private pool and fireplace.New floor, new washable paint and fittings (2022)with Quartz counter top in the kitchen.Primary bedroom is very spacious and the house layout is very welcoming.' ,`Acres` = '0.1834' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CAMBRIDGE VILLAGE SEC 1, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'RAY ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Cambridge Village Sec 1' ,`TaxAmount` = '4026' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665740647' WHERE `Matrix_Unique_ID` = '212401167'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T03:18:41.517' ,`MLSNumber` = '81963449' ,`ListAgentFullName` = 'Heather Niemeyer' ,`ListOfficeName` = 'Camelot Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783286' ,`Longitude` = '-95.433270' ,`PhotoCount` = '50' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '739000.00' ,`Status` = 'Active' ,`StreetName` = 'Kinsley Oaks' ,`StreetNumber` = '2721' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Within one of Houston\'s most historic & fastest-growing neighborhoods is the coveted Cottage Grove Lake. This gated community boasts sophistication, with beautiful landscaping & a stunning 2-acre lake surrounded by walking trails, dog park, & community pool. Enjoy the convenience of quick access to I-10, Downtown, the Galleria, Washington Corridor & Memorial Park. Situated on a large corner lot w/ spectacular lake views, this first-floor living residence comes fully loaded with innovative home features & thoughtful customizations: electric fireplace, Samsung picture frame TV, custom window treatments, integrated home automation system w/ cameras, smart lights, security system, Wi-Fi enabled RainBird irrigation system, integrated surround sound & more! With generous closet space already built-in, the 3rd-floor game/media room may be converted into a 4th bedroom/guest suite. Enjoy outdoor/indoor living w/ sliding glass doors leading out to the expansive rooftop balcony. ELEVATOR CAPABLE!' ,`Acres` = '0.058' ,`Area` = '9' ,`BuilderName` = 'In Town Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 COTTAGE GROVE LAKE PAR R/P' ,`LotDesciption` = 'Corner,Other,Patio Lot,Water View' ,`LotSize` = '2526' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1955' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Cottage Grove Lake Pt Rep' ,`TaxAmount` = '11596' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665740648' WHERE `Matrix_Unique_ID` = '213035905'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-14T02:44:44.070' ,`MLSNumber` = '53113914' ,`ListAgentFullName` = 'Ernest Chang' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.828260' ,`Longitude` = '-95.005263' ,`PhotoCount` = '22' ,`PostalCode` = '77562' ,`RoomCount` = '3' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Meredith' ,`StreetNumber` = '9019' ,`StreetSuffix` = 'Drive' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled and updated with the most luxurious of finishes sitting on over 1/2 an acre!' ,`Acres` = '0.5733' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 & TR 5A BLK 2 ORCHARD ACRES SEC 1 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24972' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Orchard Acres Sec 01 U/R' ,`TaxAmount` = '1640' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665740648' WHERE `Matrix_Unique_ID` = '213056874'  --> 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`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213614025','1665740648','213614025','2022-10-14T03:42:51.350','35616918','Ana Peternell','Keller Williams Premier RealtyKaty','','','30.434945','-95.637108','50','77356','11','524000.00','Active','Camden Hills','89','Drive','Montgomery','3','1','4','2543','Single-Family','State of the art new construction in desirable Bentwater Golf/Gated Community!  VALENCIA is a one story home with an open floor plan designed for comfort and efficiency. The elevation consists of brick, stone & stucco  to provide an elegant welcome to your home. Beautiful Floors were hand selected, beautiful QUARTZ countertops,  Gas connection for an outdoor grill. The house is equipped with 5” aluminum gutters &  sprinkler system in the house. Do you want more? There is a 220V ADAPTOR in the garage for electrical car equipment! Gas, water and sewer set up for an outdoor kitchen too. SAMSUNG Washer, dryer & fridge included in the sale. Bentwater renowned Country & Yacht club includes tennis courts, restaurant, golf course, Day Spa, Hair Salon, Fitness Center & More. This home holds the Social Membership level. Home builder & structural warranty included too.','0.1686','39','Prisco Homes/HQC','','Electric Dryer Connections,Gas Dryer Connections','','No Disclosures','1','','1','Lake Conroe Area','Central Gas','1','BENTWATER 29, BLOCK 2, LOT 1 9','In Golf Course Community,Subdivision Lot','7200','Survey','','700','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Builder','1','Traditional','Bentwater 29','402','2.1898','Water District','2022','Builder');  --> New record created successfully<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`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213653770','1665740648','213653770','2022-10-14T02:15:23.910','37604243','Martin Orellana','Connect Realty','','','29.578030','-95.574470','43','77459','10','419900.00','Active','Huckleberry','3026','Street','Missouri City','2','1','4','2805','Single-Family','This great property has a nice swimming pool, spacious kitchen, high ceiling, two nice front rooms for formal dining, office space or two offices to work from home, a spectacular back yard with super size covered patio, Tile and laminate floors all over the house, Stainless steel appliances, Mini blinds, Laundry room downstairs, the Main restroom has shower and bathtub, game room upstairs, gas water heater. fast-growing community, beautiful corner lot, surrounded by a shopping center and restaurants.','0.1867','29','','','','','Mud,Sellers Disclosure','1','','1','Missouri City Area','Central Gas','1','OYSTER CREEK PLANTATION SEC 1, BLOCK 2, LOT 15','Corner,Subdivision Lot','8134','Appraisal District','','812','0','','2','Gas Oven,Single Oven','1','In Ground','','Gas Range','','Composition','19 - Fort Bend','LEXINGTON CREEK ELEMENTARY SCHOOL','DULLES HIGH SCHOOL','DULLES MIDDLE SCHOOL','Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Oyster Creek Plantation Sec 1','7303','2.71','Water District','1996','Appraisal District');  --> New record created successfully<br />