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-14T20:07:42.723' ,`MLSNumber` = '49610496' ,`ListAgentFullName` = 'Delia Medrano' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796841' ,`Longitude` = '-95.363018' ,`PhotoCount` = '38' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Edison' ,`StreetNumber` = '4007' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW BUILD FOR LEASE. CLOSE TO MAJOR FREEWAYS AND DOWNTOWN Houston. As soon as you enter the home, you\'ll notice the new paint, new fixtures, clean lines and finishes. You\'ll notice the beautiful ceiling fan in the living room to keep you cool during the summer. The floors are luxurious vinyl plank throughout the house and are waterproof. The kitchen boasts Cambia quartz countertops, a new dishwasher, and a five-gas burner ready for those home-cooked meals with custom hood vent. Backsplash is a beautiful white subway tile, and a unique island. You\'ll notice the sensor lighting in closets and recessed lighting throughout the house.  The primary bedroom/bathroom boasts a double sink with a massive tiled shower.  The secondary bathroom has a gorgeous pattern tiled floor. The front bedroom could become an office looking out through huge windows that allow natural sunlight. The front gate is electric for easy access in and out the property.' ,`Acres` = '0.1263' ,`Area` = '9' ,`BuilderName` = 'Seller choice' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 48 IRVINGTON' ,`LotDesciption` = 'Other' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Irvington' ,`TaxAmount` = '3809' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675136528' WHERE `Matrix_Unique_ID` = '210742917'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T20:20:53.420' ,`MLSNumber` = '71369894' ,`ListAgentFullName` = 'Pamela Rogers' ,`ListOfficeName` = 'Coleman & Patterson, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.030216' ,`Longitude` = '-96.118687' ,`PhotoCount` = '17' ,`PostalCode` = '77871' ,`RoomCount` = '6' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Heath' ,`StreetNumber` = '407' ,`StreetSuffix` = 'Street' ,`City` = 'Normangee' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a neat 1947 Wood Frame Country Home that sits on 2 City Lots.  Has plenty of outside space for beautiful flower beds and a good area for a garden.  The owner has lived in this home 30+ yrs. and has always had a large garden and kept the yard very neat with plenty of beautiful flowers and a nice area in the back for entertaining.\r\nThe home is located in the downtown residential area for lots of conveniences.  Roof is about 10 yrs. old with a 1 vehicle attached carport.  The 2 lots are shaded with beautiful large trees.  City of Normangee offers trash pickup.\r\nGood internet service is also available.' ,`Acres` = '0.3214' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'NORMANGEE CITY BLK 28 LT 11 & 12 0.322 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '14000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Normangee City' ,`TaxAmount` = '732' ,`TaxRate` = '2.1314' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675136528' WHERE `Matrix_Unique_ID` = '213014428'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T19:25:00.560' ,`MLSNumber` = '78193885' ,`ListAgentFullName` = 'Amber Moore' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.127427' ,`Longitude` = '-95.385314' ,`PhotoCount` = '47' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '346940.00' ,`Status` = 'Active' ,`StreetName` = 'Standing Rock' ,`StreetNumber` = '3626' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Last NEW CONSTRUCTION opportunities in the gated community of Legends Ranch are MOVE-IN READY. Exquisite designer selections throughout every inch of this 4 bedroom, 2 ½ bath, 2 car garage home. The property features an open concept floor plan with kitchen, breakfast area, large family room w/ 20\' soaring ceilings and primary suite on the first floor. Upstairs you will find 3 additional bedrooms, a loft and study niche. Features include Quartz counters, Samsung stainless steel appliances, Delta plumbing fixtures, framed bathroom mirrors, Richelieu hardware on cabinet doors and drawers, luxury vinyl plank flooring in downstairs common areas, Mohawk carpet in bedrooms, tankless hot water heater, gutters, covered back patio and NO BACKYARD NEIGHBORS! Enjoy all this community has to offer – swim, tennis, basketball, parks, trails & more. 2.56% TAX RATE and zoned to highly acclaimed CONROE ISD! Convenient access to 99, I-45 and the Hardy Toll Road and just minutes to The Woodlands. HURRY!!' ,`Acres` = '0.0784' ,`Area` = '15' ,`BuilderName` = 'CitySide Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON GATE AT LEGENDS RANCH 03, BLOCK 5, LOT 54' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3417' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Legends Ranch' ,`TaxAmount` = '338' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675136528' WHERE `Matrix_Unique_ID` = '213262114'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T19:25:44.300' ,`MLSNumber` = '64636879' ,`ListAgentFullName` = 'Amber Moore' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.127699' ,`Longitude` = '-95.384871' ,`PhotoCount` = '49' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '344990.00' ,`Status` = 'Active' ,`StreetName` = 'Standing Rock' ,`StreetNumber` = '3636' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Last NEW CONSTRUCTION opportunities in the gated community of Legends Ranch are MOVE-IN READY. Exquisite designer selections throughout every inch of this this 3 bedroom, 2 ½ bath, 2 car garage home. The property features an open concept floor plan with kitchen, dining area, large family room w/ soaring 20\' ceilings and primary suite on the first floor. Upstairs you will find 2 additional bedrooms plus an office and loft area. Features include Quartz counters, Samsung stainless steel appliances, Delta plumbing fixtures, framed bathroom mirrors, Richelieu hardware on cabinet doors and drawers, luxury vinyl plank flooring in downstairs common areas, Mohawk carpet in bedrooms, tankless hot water heater, gutters, covered back patio and NO BACKYARD NEIGHBORS! Enjoy all this community has to offer – swim, tennis, basketball, parks, trails & more. 2.56% TAX RATE and zoned to highly acclaimed CONROE ISD! Convenient access to 99, I-45 and the Hardy Toll Road and just minutes to The Woodlands.' ,`Acres` = '0.0784' ,`Area` = '15' ,`BuilderName` = 'CitySide Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON GATE AT LEGENDS RANCH 03, BLOCK 7, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3417' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Legends Ranch' ,`TaxAmount` = '614' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675136528' WHERE `Matrix_Unique_ID` = '213262439'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T20:07:54.673' ,`MLSNumber` = '31144092' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219228' ,`Longitude` = '-95.448115' ,`PhotoCount` = '49' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '524900.00' ,`Status` = 'Active' ,`StreetName` = 'April Mist' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious, Open-concept home with 3-car garage, wooded corner lot. tranquil Koi Pond. 1st floor has Bright Kitchen: quartz countertops, Island with bar, 2nd center Island; Master Suite: 2 vanities, shower, Private w/c; garden tub; Study: French doors; Library: full wall shelves; Great Rm: 10 ft tall stone fireplace & Screened Room; 2nd floor has 2nd master suite: Full Bath En-suite; Billiards Rm & Balcony; an Additional Suite adds space & privacy with 2 bedrooms, Full Split Bath with dbl Sink, Family Rm\r\nNew Adds:\r\nBlack stainless steel appliances; 2 Full HVAC Systems; Water Heater; Roof; Screened Room; Balcony; Int/Ext painted; Flooring: Wood, Carpet.  Features:\r\n3-car Garage; Large walk-in Closets; 6x8 Exterior French Doors; water purification system; Lawn Sprinkler System.\r\nAbout the Neighborhood:\r\n2 miles to The Woodlands Medical Center with 6 major hospitals; Beautiful, wooded neighborhood with hike & bike trails & Dog Parks.' ,`Acres` = '0.1868' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS HARPER\'S LND COLLEGE PK 09, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '8136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Harpers Lnd College Park' ,`TaxAmount` = '6746' ,`TaxRate` = '2.2719' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675136529' WHERE `Matrix_Unique_ID` = '213441191'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T20:02:51.823' ,`MLSNumber` = '63210910' ,`ListAgentFullName` = 'Destiny Gallion' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645555' ,`Longitude` = '-95.130187' ,`PhotoCount` = '48' ,`PostalCode` = '77505' ,`RoomCount` = '9' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Manor' ,`StreetNumber` = '4243' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on corner lot in quiet neighborhood.  Fromal living and formal dining room, spacious den with fireplace, oversized kitchen with two breakfast/dining areas.  All bedrooms up with game room.  Large primary bedroom with walk-in closet, primary bathroom with double sinks, soaking tub, and separate shower.  Lots of storage, lots of natural light, freshly painted interior, generator stays.  This is a must see!' ,`Acres` = '0.1923' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 8 VILLAGE GROVE SEC 2B R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8376' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '295' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove Sec 02b R/P' ,`TaxAmount` = '8603' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675136529' WHERE `Matrix_Unique_ID` = '214764114'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T19:23:54.650' ,`MLSNumber` = '41219142' ,`ListAgentFullName` = 'Connie Reddington' ,`ListOfficeName` = 'King & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.039182' ,`Longitude` = '-95.328427' ,`PhotoCount` = '33' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Lynngate' ,`StreetNumber` = '6602' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home on corner lot with lots of upgrades throughout home, this home features a 4 bedroom 3 bath with a huge family room, living room , home office, and a game room, large kitchen fireplace, pass through bar, new granite in kitchen , home freshly painted inside and outside , this is a must see . Outside porch covered with ceiling fans , new fence around home. Ceiling fans throughout home, laundry room in house.' ,`Acres` = '0.1607' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 35 GREENGATE PLACE SEC 5 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Greengate Place Sec 05 R/P' ,`TaxAmount` = '9924' ,`TaxRate` = '2.6867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675136529' WHERE `Matrix_Unique_ID` = '215075013'  --> 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','215877785','1675136529','215877785','2023-01-14T19:25:20.527','10950171','Amber Moore','RE/MAX Fine Properties','','','30.127601','-95.385015','49','77386','10','359990.00','Active','Standing Rock','3632','Drive','Spring','2','1','3','2138','Single-Family','Last NEW CONSTRUCTION opportunities in the gated community of Legends Ranch are MOVE-IN READY. Exquisite designer selections throughout every inch of this 3 bedroom, 2 ½ bath, 2 car garage home on a corner lot. The property features an open concept floor plan with kitchen, dining, family area and bonus Zoom room on the first floor. All bedrooms up plus a flex space. The primary suite includes two large walk-in closets. Features include Quartz counters, Samsung stainless steel appliances, Delta plumbing fixtures, framed bathroom mirrors, Richelieu hardware on cabinet doors and drawers, luxury vinyl plank flooring in downstairs common areas, Mohawk carpet in bedrooms, tankless hot water heater, gutters, covered back patio and NO BACKYARD NEIGHBORS! Enjoy all this community has to offer – swim, tennis, basketball, parks, trails & more. 2.56% TAX RATE and zoned to highly acclaimed CONROE ISD! Convenient access to 99, I-45 and the Hardy Toll Road and just minutes to The Woodlands. HURRY!!','','15','CitySide Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Spring Northeast','Central Gas','1','CANYON GATE AT LEGENDS RANCH SEC 03, BLOCK 7, LOT 22','Subdivision Lot','3771','Appraisal District','','990','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','BIRNHAM WOODS ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Canyon Gate at Legends Ranch','','','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','216405824','1675136529','216405824','2023-01-14T20:35:38.863','69741576','Jameka Johnson','GRIFFIN LOCATIONS','','','30.062520','-95.239597','35','77339','7','399000.00','Active','Trebuchet','21311','Drive','Kingwood','3','1','4','3363','Single-Family','Welcome to 21311 Trebuchet Dr. This lovely Westin Home has 4 bedrooms, 3 and a half bath, dining room, breakfast area, study, loft area, media room, backyard covered patio and more. Walking into this stone and brick home you will be greeted in a Grand Foyer seeing an incredible curved staircase. With an open concept first floor living, it is much comfort to entertain. Large primary suite includes double vanity, separate tub and shower, and walk-in closet. Located in the Kings Mill master planned community with a great deal of wooded walkways, a peaceful lake, playgrounds, recreation center and an aquatic center. Easy access to 59 and other major freeways. Schedule your private tour today!','0.1205','40','','','','','Mud','','','1','Kingwood West','Central Electric,Central Gas','1','S642407 - KINGS MILL 07, BLOCK 6, LOT 13','Subdivision Lot','5250','Appraisal District','','600','0','','2','','0','','','','','Composition','39 - New Caney','KINGS MANOR ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Contemporary/Modern,Traditional','Kings Mill 07','10308','3.1831','Public Sewer,Public Water','2015','Appraisal District');  --> New record created successfully<br />