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'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','201024576','1663708757','201024576','2022-09-09T22:09:12.787','29219422','Chelsea Boone','Fathom Realty','','','29.584031','-95.038691','37','77586','9','1300000.00','Active','Breezeway','3905','Court','Seabrook','4','0','4','4697','Single-Family','This lovely custom-built stucco home is the one you\'ve been searching for! When you enter the home, you are instantly greeted with soaring ceilings, open floorplan, travertine flooring and windows galore that have many views of the lake! This home has a gourmet island kitchen w/ stainless steel appliances, rich cabinets and tons of natural light. Two bedrooms are located on the first floor! Spacious primary bedroom w elegant bathroom, dual vanities, jetted tub w/ separate shower. The closet also offers TONS of built-ins. Bonus mirrored exercise room is also located in the primary bathroom. On the back patio you will find a recently updated outdoor kitchen, and a large, covered lanai. Upstairs you will find additional bedrooms all with En-Suites. With an office on the second floor. Recent updates include of 2021 ALL NEW HVAC, new hot water heater, new roof, new carpet, new paint, new epoxy flooring, some new lighting, new locks, ceiling fans! Community offers boat launch and pool','0.6096','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Clear Lake Area','Central Gas,Zoned','1','LT 5 BLK 2 SEABROOK ISLAND SEC 2 PAR R/P','Cul-De-Sac,Subdivision Lot,Water View,Waterfront','26552','Appraisal District','','750','0','','3','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','ED H WHITE ELEMENTARY SCHOOL','CLEAR FALLS HIGH SCHOOL','SEABROOK INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Mediterranean','Seabrook Island Sec 02 Prcl R/','26696','2.6187','Public Sewer,Public Water,Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T23:23:23.747' ,`MLSNumber` = '12730656' ,`ListAgentFullName` = 'Cesar Estefan' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753221' ,`Longitude` = '-95.464595' ,`PhotoCount` = '28' ,`PostalCode` = '77056' ,`RoomCount` = '7' ,`ListPrice` = '1999999.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Creek' ,`StreetNumber` = '5041' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Remodeled Lovett Custom Home - Featuring Elegant Finishes & Harmonious Design. - Spacious 12 ft. Ceiling Open Floor Plan - 4 Bedrooms, Gourmet Kitchen, Marble Counters, Top of the line Cabinetry, Miele Appliances, Spacious Walk-In Pantry, Butler’s Pantry, Wet Bar & Wine Room - Gas Cook Top - White Oak Floors - Crown Molding - Magnificent Natural Stone Gas Fire Place - Built-In Book Shelves & Sound System - Large Balcony / Terrace - Energy Saving features throughout. Geothermal A/C & Heat. - Generously Spacious Primary Bedroom w. Green Views - His & Hers Master Very Large Walk-In Closets w. Pull Down Bars - Double Shower - Jacuzzi Spa – Elevator Ready - Double Garage w. Double Storage Closets – Tools & Gardening Secured Storage – Motion Detectors – Alarm System -- Luscious Landscaping. - Close to Tanglewood Blvd., Perfect to Enjoy a Delightful walk. Centrally located, Walking Distance to Post Oak Blvd. - Easy Access to Great Restaurants & Fabulous Retail stores. - NEVER FLOODED.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 CEDAR CREEK COMMONS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8846' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,English,French' ,`Subdivision` = 'Cedar Creek Commons' ,`TaxAmount` = '39805' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708757' WHERE `Matrix_Unique_ID` = '208453829' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T22:09:29.727' ,`MLSNumber` = '40001360' ,`ListAgentFullName` = 'Shirlee Northcutt' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539726' ,`Longitude` = '-95.073167' ,`PhotoCount` = '34' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Constellation Blvd' ,`StreetNumber` = '617' ,`StreetSuffix` = 'Boulevard' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MAKE THE BEAUTIFUL WATERFRONT GATED COMMUNITY OF CONSTELLATION POINT YOUR NEW HOME. THIS GORGEOUS HOME HAS CANAL VIEWS, AN OUTDOOR FIREPLACE AND OUTDOOR LIVING SPACE PERFECT FOR ENTERTAINING SITUATED ON A LARGE CORNER LOT. THIS HOME BOASTS TOP OF THE LINE FINISHES AND LARGE HIS AND HER CLOSETS. BEAUTIFUL COMMUNITY POOL OVERLOOKING WATER EQUIPPED WITH KITCHEN AND BATHROOMS. TAKE A LOVELY STROLL ON THE BOARDWALK. COMES WITH YOUR OWN PERSONAL BOAT SLIP. PLEASE CALL TO SCHEDULE A VEWING.' ,`Acres` = '0.1607' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CONSTELLATION POINTE SEC 2 (2005) ABST 18, BLOCK 1, LOT 1, A' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '6999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Controlled Access,Leave Business Card,Lockbox Back,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Constellation Pointe Sec 2' ,`TaxAmount` = '7547' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708757' WHERE `Matrix_Unique_ID` = '210434097' --> 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','211901347','1663708757','211901347','2022-09-09T22:11:26.930','83342806','Mark Weber','eXp Realty, LLC','','','29.958271','-93.926869','39','77619','3','200000.00','Active','Marion','5401','Avenue','Groves','3','0','3','1926','Single-Family','Make this your family home! Award winning Port Neches-Groves schools. Spacious floor plan includes 3 bedrooms, 2 full baths, 2 living spaces and dining area. Walking distance to Groves Middle School and Van Buren Elementary School.','0.1791','51','','','','','No Disclosures','','','','','Central Electric','0','NORTH GROVES NO 2 EXT LOT 14 BLK 7 N GROVES NO 2 EXT','Subdivision Lot','7800','Appraisal District','','','0','','2','','0','','','','','Composition','233 - Port Neches-Groves','PORT NECHES ELEMENTARY SCHOOL','PORT NECHES-GROVES HIGH SCHOOL','GROVES MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','North Groves 2 Ext','3673','2.7694','Public Sewer,Public Water','1962','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','212194328','1663708757','212194328','2022-09-09T23:07:59.160','50720689','Barbara Miller','Vista Real Estate','','','29.443687','-95.417376','38','77583','8','489000.00','Active','Carson','9631','','Iowa Colony','2','1','3','2891','Single-Family','Boasting an array of sleek finishes & a thoughtful open layout, this immaculate 3 bedroom, 2.5 bathroom, w/office, & gameroom is full of upgrades. The beautiful kitchen is the heart of the home complete w/an oversized island & stainless steel appliances. The open concept allows the chef of the family to be able to join in on conversations w/family & friends when entertaining. Exquisite details are not spared in the en-Suite bath where you can soak all your cares away in the dreamy soaking tub while relaxing. The sellers spared no expense w/upgrades including tile plank flooring, upgraded cabinets, upgraded quartz, 8\' doors, speakers in/out, & a large extended back patio w/fans where fun will be had by all. The gameroom is large & is the perfect place to hang out and/or play games. Meridiana offers a ton of amenities for every age. The buyers of this home will be able to enjoy the new Adventure Cove offering a wave pool, tidal river, fitness center & pavilion - Coming Soon!','0.21','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Alvin North','Central Gas','1','Meridiana Sec 7 Blk 2 Lot 35','Cleared,Corner,Subdivision Lot','9425','Appraisal District','','1050','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Meridiana','','','Public Sewer,Public Water,Water District','2018','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','212202586','1663708757','212202586','2022-09-09T22:45:39.867','69527147','Aamir Faridi','Texas United Realty','','','30.002314','-95.674028','23','77429','10','379900.00','Active','Mossy','15514','Park','Cypress','2','1','4','2771','Single-Family','Very well maintained 2 story former show home in sought after Cyfair ISD. Home features 4 bedrooms, 2.5 bathrooms, living room, large dining area, huge game room & media room. Primary Bedroom is on main floor. Home features many upgrades including 42\' cabinets, granite Counter-tops, arches, rounded corners, an iron spindle stair case, and covered patio. Large size backyard with fire pit. Home is energy star qualified with many energy saving features that include tech shield radiant barrier, HVAC- 13 seer, energy star appliances and more. WHOLE HOUSE WATER SOFTENER SYSTEM..... Location of home is in walking distance to neighborhood pool large playground. Never flooded. very close to main intersections Hwy 290 and Grand Parkway. Call today to book your private showing.','0.1453','35','','','Electric Dryer Connections,Gas Dryer Connections','','Mud,Sellers Disclosure','1','','','Cypress North','Central Electric,Central Gas','1','LT 45 BLK 5 PARK CREEK SEC 3','Subdivision Lot','6329','Appraisal District','','550','0','','2','Gas Oven','0','','','Gas Range','','Wood Shingle','13 - Cypress-Fairbanks','BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS WOODS HIGH SCHOOL','GOODSON MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Contemporary/Modern,Traditional','Park Crk Sec 03','7304','2.751','Public Sewer,Water District','2010','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','212218741','1663708757','212218741','2022-09-09T23:18:55.647','4820773','Jared Turner','LennarVillageBldr-JaredTurner','','','30.146364','-95.678406','8','77362','11','728116.00','Active','Lakemont Bend','1000','Lane','Pinehurst','4','0','5','3995','Single-Family','NEW!! Gorgeous Village Builders Classic Series \'\'Chopin\" Design with Elevation \'\'K\'\'. This new two-story home showcases an open layout ideal for modern family living. On the first floor, the main living space includes a covered patio for indoor-outdoor entertaining, while the owner’s suite is nearby. The front of the home features a secondary bedroom, study, formal dining room and elegant spiral staircase. The second floor hosts two secondary bedrooms and a flexible bonus room. **5th bedroom option**','','15','Village Builders','','','','Mud,Other Disclosures','','Gaslog Fireplace','1','Tomball','Central Gas','1','SEC 0010 BLK 002 LOT 010','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','3','','0','','','','','Composition','53 - Tomball','DECKER PRAIRIE ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','2','Traditional','Woodtrace','','3.3542','Water District','2022','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','212224930','1663708757','212224930','2022-09-09T22:38:58.187','55660412','Angela Elliott','RE/MAX All Stars','','','29.936853','-95.699426','49','77433','13','950000.00','Active','Timberlake Glen','19518','Trail','Cypress','4','1','5','4457','Single-Family','Why buy new when you can own this immaculate home in sought after Towne Lake? This home has ALL of the BELLS & WHISTLES! Enter to beautiful wood floors with soaring ceilings complemented by a beautiful spiral staircase. Make memories in the family room that\'s offers 19 foot ceilings that opens to a large gourmet kitchen with an oversized island, to entertain all of your guest needs. There\'s also a second bedroom downstairs with en suite bath. Step into your backyard oasis through the sliding doors to a beautiful pool/spa & outdoor kitchen that meets all of your culinary desires. So many features, please refer to upgrade list. Community offers top rated onsite elementary & middle school, resort-style waterpark with lazy river, pools, private island, parks & play grounds, tennis courts, fitness centers, hike & bike trails, community garden and onsite restaurants & shopping. All of this along with monthly resident activities make Towne Lake\'s lifestyle like no other! Hwy 99, 290 & I-10','0.2693','25','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Cypress South','Central Gas','1','LT 1 BLK 2 TOWNE LAKE SEC 35','Corner,Subdivision Lot','11730','Appraisal District','','1699','0','','3','Gas Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','RENNELL ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Towne Lake Sec 35','19285','3.471','Water District','2017','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','212254202','1663708757','212254202','2022-09-09T23:15:32.960','46450549','Jared Turner','LennarVillageBldr-JaredTurner','','','30.043004','-95.796362','10','77447','6','269990.00','Active','Steep Climb','24023','Drive','Hockley','2','0','3','1230','Single-Family','NEW! Lennar Homes Gulf Coast Series, \"Arcola II\'\' Plan with Elevation \'\'B\" in Becker Meadows! Charming One Story with 3 Beds/2 Baths/2 Car Garage! Front Porch/Entry Foyer opens to Family Room! Fantastic Kitchen has 36\'\' Designer Cabinets, Sparkling Countertops, Breakfast/Dining Area and Great Appliance Pkg! Master Bedroom has Master Bath w/ Tub & Shower Combo, Large Walk-in Closet! Walk-in Utility Room! Lovely Hard Surface Floors; Fully Sodded Yard and Landscape Pkg! Energy Efficient w/16 SEER HVAC System & MORE!','','35','Lennar','','','','Mud','','','','Hockley','Central Gas','1','SEC 0004 BLK 001 LOT 005','Subdivision Lot','','','','750','1','To Be Built/Under Construction','2','','0','','','','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Becker Meadows','','3.6','Water District','2022','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','212313487','1663708757','212313487','2022-09-09T23:45:14.397','84723774','Jodie Bente','RE/MAX 1st Choice','','','29.343202','-95.080814','50','77510','4','675000.00','Active','Fm 646','7103','Road','Santa Fe','3','0','3','3276','Single-Family','Welcome home to country living with tons of space! This home has so much to offer I cant list it all. Tons of upgrades, huge bedrooms, 3 updated full bathrooms, big mancave/extra room, lots of space to entertain inside and out , oversized in groundpool an more. Plus its all on 4 acres! Make your appointment to see the spacious beauty today','4','33','','','','','Sellers Disclosure','','','','Santa Fe','Central Gas','0','CLEMONS ADDN (2011) ABST 48, BLOCK 1, LOT 2, ACRES 4.935','Corner','174240','Other','','','0','','2','','1','In Ground','','','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Seller','1.5','Traditional','Clemons Add 2011','7362','2.3536','Septic Tank,Well','1961','Appraisal District'); --> New record created successfully