Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T15:15:09.323' ,`MLSNumber` = '73454912' ,`ListAgentFullName` = 'Julian Cortinas' ,`ListOfficeName` = 'Premier, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048096' ,`Longitude` = '-95.395484' ,`PhotoCount` = '34' ,`PostalCode` = '77373' ,`RoomCount` = '10' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayleaf' ,`StreetNumber` = '23346' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SIGNIFICANT REMODEL DOWN TO THE STUDS; NOW MODERNIZED TO A BEAUTY, ALL 2022 NEW HVAC, NEW PEX PLUMBING, NEW ELECTRIC WIRING/OUTLETS. NEW \"LOW E ARGON\" ENERGY EFFICIENT WINDOWS, NEW FIXTURES, NEW PAINT IN/OUT, NEW KITCHEN FEATURES; LIGHT & BRIGHT WINDOWS, W/CABINETRY, GRANITE COUNTERS & SINK, BACKSPLASH, CERAMIC FLOORING & LIGHT FIXTURES, NEW E-STOVE W/VENT-HOOD & SS DISHWASHER. NEW PRIMARY SUITE 1ST FLOOR BEDROOM; TWIN GRANITE SINKS W/GLASS ENCLOSED SHOWER W/TILE, FULL WALK-IN CLOSET & PRIVATE PATIO ACCESS. 1ST FLOOR ACCESS TO BACK YARD PRIVATE PATIO (12\' X 14\'), GUEST CLOSET, GUEST BATHROOM & GARAGE/UTILITY ROOM. 2ND FLOOR; BEAUTIFUL FULL BATHROOM SHOWER COMBO, W/2 BEDROOMS & LOFT AREA OPEN TO FAMILY ROOM, PERFECT SPACE FOR HOME OFFICE, DAYBED, FAMILY/GAME-ROOM. RECENT FOUNDATION REPAIRS W/TRANSFERABLE WARRANTY, +/-10 YEAR OLD ROOF.\r\nTIMBERLANE COMMUNITY FEATURES; CLUB-ROOM, WALKING TRAILS, MULTIPLE PARKS W/ POOL, SPLASH PAD, TENNIS COURT. (12 MONTH LEASE THRU 9/1/2023 6% CAP.)' ,`Acres` = '0.1846' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 8 TIMBER LANE SEC 6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane' ,`TaxAmount` = '5089' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090676' WHERE `Matrix_Unique_ID` = '208593367' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T15:40:38.140' ,`MLSNumber` = '33870266' ,`ListAgentFullName` = 'Kyle Watters' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131632' ,`Longitude` = '-95.410262' ,`PhotoCount` = '36' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Creston' ,`StreetNumber` = '1938' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Located on a corner lot in Imperial Oaks, this 3 bedroom, 2 bath has a recently updated downstairs (2021), with the garage having been built out into a fourth bedroom, den, or game room. Kitchen has been recently updated with new cabinets, floors, and countertops, along with new appliances throughout. Two bedrooms upstairs share a full bath with two balconies, one in the front and one in back of the house. 32 windows throughout this home give ample natural lighting, with plenty of privacy from the landscaping and backyard fencing. The backyard features a beautiful sparkling pool with a new pump installed in 2021. Thanks for showing!' ,`Acres` = '0.2009' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 03, BLOCK 15, LOT 37' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks 03' ,`TaxAmount` = '4780' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090676' WHERE `Matrix_Unique_ID` = '210422992' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T16:04:42.660' ,`MLSNumber` = '32075454' ,`ListAgentFullName` = 'Sharon Parker' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.567846' ,`Longitude` = '-95.771874' ,`PhotoCount` = '35' ,`PostalCode` = '77471' ,`RoomCount` = '8' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Frances' ,`StreetNumber` = '1138' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further! Meticulously maintained 3 bedroom, 2 bath, and 2,052 sqft. large corner lot home could be what you\'re looking for. Beautiful wood tile on the first-floor and granite through out the house. Kitchen open to living area that is ideal for entertaining. Primary room on first floor has great closet space and hall bath. Upstairs has 2 large bedrooms. All rooms have ceiling fans. Great backyard space for all your outdoor activities and a shed for extra storage. This little charmer is a great home with a superior location and move-in ready. Buyers are warmly welcome.' ,`Acres` = '0.2238' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LAMAR ESTATES SEC 1, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Lamar Estates Sec 1' ,`TaxAmount` = '3595' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090676' WHERE `Matrix_Unique_ID` = '212768674' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T16:46:04.140' ,`MLSNumber` = '58613660' ,`ListAgentFullName` = 'Lise Parker' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685626' ,`Longitude` = '-95.630199' ,`PhotoCount` = '25' ,`PostalCode` = '77083' ,`RoomCount` = '0' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Mapletwist' ,`StreetNumber` = '8606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride in ownership is clearly reflected in this charming home! This well-maintained 4 bedroom, 2 bathroom two story home has had only one owner. New AC unit and coils in 2021 with warranty, exterior paint 2021, Updated hardwood and tile floors throughout, upgraded bathrooms, granite countertops with new sink and garbage disposal. Enjoy a beautiful extended back patio with an outdoor bar,sink, tv, and pizza oven perfect for entertainment. Sit back and relax or bring family and friends over for gatherings and start creating beautiful memories. The list of improvements goes on with items such as a garage with A/C, backyard pergola, and many other upgrades! Give us a call and I would gladly set up a private showing.' ,`Acres` = '0.0653' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 BEECHNUT PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2845' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '89' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Beechnut Park Sec 02' ,`TaxAmount` = '3870' ,`TaxRate` = '2.557' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090676' WHERE `Matrix_Unique_ID` = '213817408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-13T15:28:28.723' ,`MLSNumber` = '69624983' ,`ListAgentFullName` = 'Robin Loner' ,`ListOfficeName` = 'Real Estate Connection Int' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.336843' ,`Longitude` = '-95.096869' ,`PhotoCount` = '20' ,`PostalCode` = '77510' ,`RoomCount` = '8' ,`ListPrice` = '599999.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue P' ,`StreetNumber` = '7327' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring your horses and livestock! Two gorgeous houses! Here is your perfect ranchette! A charming brick and hardy plank 3/2 ranch style home and a lovely 2012 Clayton 3/2 1300sqft manufactured home with custom cover patio. Completely remodeled with high end finishes in the kitchen and bath. Including quartz counters and soft close cabinets and drawers. Porcelain tile flooring in all living areas complement the deep plush carpeting in the bedrooms. Crown molding and special upgrades throughout. Backyard is completely fenced and landscaped with custom paver patio and walkway. Bring along your horses to occupy the spacious 4 stall barn and fully fenced pasture. Plenty of room for additional RV and boat parking. If that isn\'t enough, checkout the gorgeous manufactured home on the property for income producing tenant or for a Granny-pod with its own separate well and aerobic septic system.' ,`Acres` = '4.596' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 47 L CRAWFORD SUR PT OF OUTLOT 302 (302-9) ALTA LOMA OU' ,`LotDesciption` = 'Wooded' ,`LotSize` = '200202' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '5089' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675090676' WHERE `Matrix_Unique_ID` = '215113797' --> Updated record success
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','215221940','1675090677','215221940','2022-12-13T15:55:32.603','14831918','Feras Rachid','Opendoor Brokerage, LLC','','','29.893917','-95.691462','19','77433','3','280000.00','Active','Westgate Park','18759','Drive','Cypress','2','1','3','2116','Single-Family','Welcome to this fabulous area! This home has fresh interior paint and partial flooring replacement. Windows create a light filled interior with well placed neutral accents. The kitchen is ready for cooking with ample counter space and cabinets for storage. Relax in your primary suite with a walk in closet included. Extra bedrooms add nice flex space for your everyday needs. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t miss this incredible opportunity. \"This home has been virtually staged to illustrate its potential”','0.1011','25','','','','','Sellers Disclosure','1','','0','Cypress South','Central Gas','1','LT 16 BLK 5 WESTGATE SEC 15','Subdivision Lot','4404','Appraisal District','','660','0','','2','','0','','','','','Other','13 - Cypress-Fairbanks','COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS SPRINGS HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Westgate Sec 15','5773','2.671','Water District','2008','Seller'); --> New record created successfully
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','215450010','1675090677','215450010','2022-12-13T16:56:05.020','11969124','Michael Tepera','Keller Williams Realty',' Non-MLS Agent','Non-MLS ','30.494579','-96.468722','24','77879','3','249900.00','Pending Continue to Show','Rustic','160','Trace','Snook','2','0','3','1330','Single-Family','This charming three bedroom home sits on one of the larger, prime lots in Grand Lakes...only a 15 minute commute to Texas A&M\'s central campus. This house sparkles with granite countertops in the kitchen and white quartz in each bathroom plus Kent Moore cabinets throughout. Lots of add-ons, including Google Smart Home with WIFI sprinkler system & garage door, plus a hard-wired camera system. Outside there\'s ample patio space for grilling and the backyard has a broad garden area plus a custom-built 12x8 stone and plank storage shed with solar lighting. The house comes with a water filtration system and solar powered attic fan and insulated garage to help reduce summer cooling costs.','0.22','59','Simple Living Custom','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','','','Central Electric','1','S3451 GRAND LAKE OF SNOOK BLK 1 LOT 9, .22 ACRES','Corner,Subdivision Lot','9583','Appraisal District','','65','0','','2','Electric Oven','0','','','','','Composition,Wood Shingle','192 - Snook','SNOOK ELEMENTARY SCHOOL','SNOOK SECONDARY SCHOOL','SNOOK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Builder','1','Traditional','Grand Lakes of Snook','3911','2.2267','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
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','215548812','1675090677','215548812','2022-12-13T16:05:37.053','28228951','Steven Franco','Keller Williams Professionals','','','30.354790','-95.641059','7','77316','4','349900.00','Active','Mail Route','18150','Road','Montgomery','2','1','4','1994','Single-Family','10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with granite countertops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','','39','Starter Homes of TX','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Lake Conroe Area','Central Electric','0','MARVIN GARDENS 02, BLOCK 1, LOT 55','Subdivision Lot','10825','Other','','','1','To Be Built/Under Construction','2','','0','','','','','Composition','37 - Montgomery','KEENAN ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1','Traditional','Marvin Gardens 02','144','1.825','Septic Tank,Well','2023','Builder'); --> New record created successfully
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','215577145','1675090677','215577145','2022-12-13T16:07:32.180','65740747','Bradley Tiffan','Legend Home Corporation','','','30.051554','-95.360082','39','77373','6','287990.00','Active','Yellow Ginko','4811','Trail','Spring','2','1','4','2075','Single-Family','Love where you live in Cypresswood Landing in Spring, TX! Conveniently located with easy access to Grand Parkway, I-45, FM 1960, and I-69 - commuting to the Energy Corridor, The Woodlands, or Bush Intercontinental Airport is a breeze! The Aubrey floor plan is a spacious 2-story home with soaring ceilings in the entry! Complete with 4 bedrooms, 2.5 bathrooms, game room, and a 2-car garage. The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless-steel appliances! Retreat to the first-floor Owner\'s Suite featuring a beautiful bay window, double sinks, separate tub and shower, and a walk-in closet! Secondary bedrooms have walk-in closets, too! Enjoy the great outdoors with full sod and a covered patio! Don’t miss your opportunity to call Cypresswood Landing home, schedule a visit today!','','12','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Spring East','Central Gas','1','Lot 4, Blk 3','Subdivision Lot','4000','Survey','','450','1','Never Lived In','2','Freestanding Oven','0','','','Freestanding Range','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Cypresswood Landing','','2.61','Water District','2022','Builder'); --> New record created successfully