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-12-20T08:04:23.990' ,`MLSNumber` = '67826355' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Amber Wright' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.832673' ,`Longitude` = '-95.855734' ,`PhotoCount` = '20' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '357690.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1589' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM!   Incredible Features Abound: High Ceilings, Luxury Vinyl Plank Wood-Look Flooring, Stainless Appliances with 5 Burner Cooktop, Grey Quartz Countertops, White Glass Mosaic Tile  Backsplash & 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Tankless Water Heater, Oversized Covered Patio, & Full Sprinkler System! WOW! Open Concept Interior Design with Island Kitchen Open to Spacious Dining & Living Areas! Privately Located Primary Suite with Pretty Garden Bath & Walk-In Closet! Indoor Utility Room! Zoned to Katy ISD Schools! Unbelievable Community with Crystal Lagoon & Amenity Center with Clubhouse, Playground, Trails, Pool, PLUS MORE! Easy Access to the Grand Parkway! Estimated Completion - February 2023.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '23/1/15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6663' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093462' WHERE `Matrix_Unique_ID` = '211829882'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T08:44:17.273' ,`MLSNumber` = '35426322' ,`ListAgentFullName` = 'Nicole Freer' ,`ListOfficeName` = 'NICOLE FREER GROUP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.951639' ,`Longitude` = '-95.194946' ,`PhotoCount` = '22' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '324870.00' ,`Status` = 'Active' ,`StreetName` = 'Rowan Green' ,`StreetNumber` = '13142' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1545' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ASHTON WOODS NEW CONSTRUCTION - Welcome home to 13142 Rowan Green Drive located in the community of Balmoral and zoned to Humble ISD. The Franklin floorplan features 3 bedrooms, 2 full baths, 1 bath and an attached 3 car garage. This 1-story floorplan boasts an open concept, perfect for entertaining your guests and family. You don\'t want to miss all this gorgeous home has to offer! Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Ashton Woods' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Balmoral Section 26, Lot 8, Block 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093462' WHERE `Matrix_Unique_ID` = '212696132'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T08:52:56.040' ,`MLSNumber` = '59160887' ,`ListAgentFullName` = 'Leticia Sandoval' ,`ListOfficeName` = 'Spirit Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.105910' ,`Longitude` = '-94.889499' ,`PhotoCount` = '11' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 6482' ,`StreetNumber` = '113' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single wide mobile home sitting on almost an acre.  Property is complete fenced with a recently built 6 foot privacy fence.  Electric remote controled gate installed in 2022.  A/C replaced in 2021.  Whole home water filter stays with home.' ,`Acres` = '0.98' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WEST WOODLAND HILLS III, BLOCK 8, LOT 7, ACRES .98, MH LABEL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '42689' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'West Woodland Hills III' ,`TaxAmount` = '1431' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093462' WHERE `Matrix_Unique_ID` = '212738291'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T08:38:47.670' ,`MLSNumber` = '32481891' ,`ListAgentFullName` = 'Pamela Messina' ,`ListOfficeName` = 'Messina Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.000633' ,`Longitude` = '-95.676617' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '309500.00' ,`Status` = 'Active' ,`StreetName` = 'Tranquility Park' ,`StreetNumber` = '16922' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPDATED \"MOVE-IN READY\" One-Story Home with FRESH PAINT THROUGHOUT (INCLUDING DOORS AND TRIM), NEW SAMSUNG STAINLESS STEEL APPLIANCES IN KITCHEN, NEW DECOR TILE BACKSPLASH IN KITCHEN, NEW DOOR HARDWARE, NEW PLUMBING FIXTURES IN BOTH BATHS, NEW KITCHEN FAUCET, NEW VINYL-PLANK FLOORING, NEW THERMOSTAT, NEW GARAGE DOOR, COVERED PATIO, SPRINKLER SYSTEM FRONT & BACK.  PEX Plumbing Manifold in Laundry Room for Easy On/Off.  Fantastic Location in Cypress with Easy Access to 290, 99, Restaurants, Shopping, the Outlet Mall and MORE!  Great Cy-Fair Schools Near-By.' ,`Acres` = '0.132' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 PARK CREEK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'PARK CREEK' ,`TaxAmount` = '5875' ,`TaxRate` = '2.751' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093462' WHERE `Matrix_Unique_ID` = '214131534'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T08:17:16.343' ,`MLSNumber` = '47886997' ,`ListAgentFullName` = 'Pamela Berman' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806162' ,`Longitude` = '-95.841751' ,`PhotoCount` = '13' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '599995.00' ,`Status` = 'Active' ,`StreetName` = 'Country' ,`StreetNumber` = '2626' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous never lived in former Coventry model home with a significant amount of upgrades. Located in the beautiful community of Cane Island, you will fall in love with every intricate detail of this home from the moment you step foot inside. Enter through the foyer & immediately be wow-ed by the stately curved stairwell & coffered ceiling. Off the main foyer, you will discover a guest bedroom, spacious full bath as well as additional study offering the perfect space to work from home. The family room opens up to a gourmet kitchen, complete w/gas cooktop, quartz counters, walk-in pantry & oversized island. The primary suite has an upgraded shiplap wall & includes a luxurious bath w/garden tub, large shower & spacious walk-in closet. This is the perfect home for entertaining, w/smart home features, built-in surround sound, a loft-style game room & covered patio. As you enter through the 3.5 car tandem garage, you will appreciate the convenience of the mud room. This home has it all!' ,`Acres` = '0.1632' ,`Area` = '25' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S422383 CANE ISLAND SECTION 23 BLK 1 LOT 47 ACRES .1632' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7109' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island Sec 23' ,`TaxAmount` = '15744' ,`TaxRate` = '3.4077' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093463' WHERE `Matrix_Unique_ID` = '214616509'  --> 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','215178270','1675093463','215178270','2022-12-20T08:26:18.660','63429000','Vanessa King','Coldwell Banker Realty','','','29.763792','-95.719045','33','77450','17','800000.00','Active','Pebble Chase','1602','Drive','Katy','4','2','5','6223','Single-Family','TENANT OCCUPIED UNTIL JAN 31st 2024. Beautifully updated 5 bed, 4 full, 2 half bath home with sparkling pool & spa. Stunning entrance with double height ceilings, marble flooring & sweeping staircase. Updated kitchen with stainless steel appliances & island, leads to a breakfast room with built-in desk area. The family room has two living areas with fireplace. Also located on the first floor is a formal dining room, private study/home office & the primary suite with re-modeled bathroom & walk-in closets. On the second floor is an oversized game room with fireplace & wet bar. Four spacious bedrooms & three bathrooms, one bedroom can be used as a 2nd primary bed. French doors from the family room lead to a patio with pergola, perfect for outdoor entertaining. Three car garage & electric driveway gate for privacy. WATER HEATERS - 2022, HVAC up & down - 2022. Convenient access to I10, shopping & restaurants. Zoned to Katy ISD. Washer, dryer & refrigerator included.','0.2674','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure,Tenant Occupied','1','Gas Connections,Wood Burning Fireplace','2','Katy - Southeast','Central Gas','1','LT 17 BLK 8 KELLIWOOD NOTTINGHAM CTRY 2 RP','Corner,Subdivision Lot','11648','Appraisal District','','929','0','','3','Double Oven,Electric Oven','1','Gunite,In Ground','','Electric Cooktop','','Composition','30 - Katy','PATTISON ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','MCMEANS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Appraisal District','2','Traditional','Kelliwood Nottingham Country','17357','2.333','Public Sewer,Public Water,Water District','1987','Appraisal District');  --> 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','215417334','1675093463','215417334','2022-12-20T08:26:22.013','97307205','Shawn Speer','7th Generation Realty','','','30.209379','-95.750782','5','77354','6','634887.00','Active','Kimber','41034','Lane','Magnolia','3','0','4','','Single-Family',':   Welcome home to the perfect one-story home. The Lantana plan features 3 or 4 bedrooms. The 3-room version provides your personal home office. You will love walking into your grand entry with high ceilings. Beautiful open concept giving you a view from the front foyer to your large covered back patio. Your kitchen features granite countertops and has a built-in microwave, oven, dishwasher and 36” 5 burner cooktop. Painted cabinets with lots of storage and functional space.  Large Family room and open concept kitchen provides the perfect gathering space for your family and entertainment. 8’ doors throughout your new home. Your master bathroom features quartz countertops and a large freestanding tub and an incredible walk in shower, split master closets and lots of cabinet storage space. Your one car garage brings you right into your large Utility room and the 2 car garage gives you direct access to your oversized pantry.Hurry and check out this home today!Magnolia ISD and NO MUD TAX!','','15','Harrisburg Home','','','','Other Disclosures','1','','','Magnolia/1488 West','Central Gas','1','11/2','Subdivision Lot','17000','Appraisal District','','500','1','To Be Built/Under Construction','3','','0','','','','','Composition','36 - Magnolia','MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required','','1','Traditional','Mostyn Manor Reserve','','','Water District','','');  --> 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','215575252','1675093463','215575252','2022-12-20T08:22:36.443','70079579','Ronnie Matthews','D.R. Horton Homes','Cristina Velando','Coldwell Banker RealtyREALTORS','29.998036','-95.787545','9','77447','5','334990.00','Pending Continue to Show','Jordan Meadow','16119','Way','Hockley','3','0','4','2170','Single-Family','EXCEPTIONAL NEW D. R. HORTON BUILT 4 BEDROOM! MOVE-IN READY! Sought-After Interior Design with Two Bedrooms & Two Baths Downstairs! Impressive Foyer Opens to Gourmet Island Kitchen with Corner Pantry & 36\" Flat Panel Maple Cabinetry + Exotic Granite Counters! Spacious Living & Dining Areas! Privately Located First Floor Primary Suite Offers Luxurious Garden Bath with Huge Walk-In Closet! Second Bedroom/Guest Suite with Adjoining Full Bath - Also Downstairs! Oversized Indoor Utility Room! Enormous Gameroom/Media Room! Tons of Fantastic Features: Tile Wall Surrounds in Bathrooms, Smart Home System, Full Sprinklers, Front & Back Sod, Full Front Landscape, Tankless Water Heater, LED Lighting, Covered Patio, PLUS MORE! Easy Access to 290 & the Grand Parkway! HURRY!','0.1728','25','D. R. Horton','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Cypress South','Central Gas','1','LT 5 BLK 2 STONE CREEK RANCH SEC 12','Subdivision Lot','7529','Appraisal District','','700','1','Never Lived In','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','55 - Waller','ROBERTS ROAD ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','WALLER JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Stone Creek Ranch','1630','3.1924','Public Sewer,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','215735507','1675093463','215735507','2022-12-20T08:54:53.020','51169689','Scott Laird','Keller Williams Woodlands','','','30.366976','-95.307146','33','77303','8','439615.00','Active','Rockwall','16706','Street','Conroe','3','0','4','2716','Single-Family','NEW HOME OPPORTUNITY located on ALMOST 1 acre lot - Just MINUTES from Lake Conroe and upcoming HEB shopping center! Conveniently located, with EASY access to I-45 and QUICK commute to The Woodlands . This 4 bedroom, 3 bath home is a MUST SEE!! Featuring -- OPEN family room with SOARING ceilings and LUXURY vinyl plank flooring throughout! GOURMET granite kitchen with breakfast bar, stainless steel appliances, TONS of cabinet space and breakfast nook! PRIVATE downstairs primary retreat with DUAL granite vanity, separate glass shower + soaking tub and WALK-IN closet! SPACIOUS secondary bedrooms, UPSTAIRS gameroom AND formal dining!! GORGEOUS brick & stone elevation with front porch! Covered back patio with plenty of backyard space for entertaining all year round! Community features a super low TAX RATE and LOW HOA dues!','0.833','19','First America Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Conroe Northeast','Central Gas','1','Deer Pines 03, Block 02, Lot 03','Subdivision Lot','36288','Other','','450','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','AUSTIN ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','2','Traditional','Deer Pines','','1.94','Aerobic,Septic Tank','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','215750942','1675093463','215750942','2022-12-20T08:59:53.513','48868232','Jay Schulz','Zarco Properties, LLC','','','30.280121','-95.543416','34','77316','5','319900.00','Active','Lynx','229','Trail','Montgomery','2','0','3','1280','Single-Family','This elegant one story home is owned by an internationally recognized interior designer in Woodforest. The home is tucked away on a quiet street and welcomes you with a light and cheery open floor plan. The primary suite is the perfect place to unwind with a walk-in closet, private primary bath with oversized shower & private entry to the patio. Soak up the sunshine under the pergola on the back patio enjoying a cup of coffee or grilling on a Texas summer day. Plenty of amenities just a golf cart ride away, including Forest Island, Harvest Market shopping center & over 700 acres dedicated to parks & recreational spaces. Sprinkler system reaches throughout the front and backyard. Come and take a look- you will not be disappointed!','0.1381','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Conroe Southwest','Central Gas','1','S965273 - WOODFOREST 73, BLOCK 1, LOT 7','Subdivision Lot','6015','Appraisal District','','1200','0','','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Woodforest','5246','2.6888','Water District','2019','Appraisal District');  --> New record created successfully<br />