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-11-15T04:50:05.883' ,`MLSNumber` = '17687624' ,`ListAgentFullName` = 'Lois Lloyd' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770753' ,`Longitude` = '-95.315757' ,`PhotoCount` = '32' ,`PostalCode` = '77020' ,`RoomCount` = '5' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Arapahoe' ,`StreetNumber` = '5436' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1090' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location location location just a little TLC and you have the perfect spot. Cute bungalow minutes from downtown, medical center, museum district 5 major universities. Entertainment, Great dinning, all the major sport venue\'s easy access. Seller motivated not desperate all serious offers considered.' ,`Acres` = '0.0953' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 5 BUENA VISTA' ,`LotDesciption` = 'Other' ,`LotSize` = '4150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON N ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Buena Vista' ,`TaxAmount` = '2202' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1942' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527738' WHERE `Matrix_Unique_ID` = '210302312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T04:02:44.300' ,`MLSNumber` = '66095799' ,`ListAgentFullName` = 'Amy Lawrence' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.547866' ,`Longitude` = '-95.305295' ,`PhotoCount` = '23' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Mckinley' ,`StreetNumber` = '5503' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brick one story home in the heart of Pearland. This Centennial Village home has 3 bedrooms, 2 baths both updated and ready for your buyers! Kitchen completely updated with granite countertops, gorgeous backsplash, new appliances and designer wood cabinets. Neutral tones throughout, bamboo wood floors, large patio/deck in backyard. Spacious primary suite with en-suite, garden tub/shower combo, with a huge walk -n closet. Large corner lot with a fully fenced expansive backyard.' ,`Acres` = '0.2286' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CENTENNIAL VILLAGE SEC 2 (A0240 H T & B R R)(PEARLAND) BLK 2' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9958' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'H C CARLESTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Centennial Village' ,`TaxAmount` = '6026' ,`TaxRate` = '2.8052' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527738' WHERE `Matrix_Unique_ID` = '212695040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T03:50:07.503' ,`MLSNumber` = '8128330' ,`ListAgentFullName` = 'Nancy Ware' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003319' ,`Longitude` = '-95.791327' ,`PhotoCount` = '33' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Casa Linda' ,`StreetNumber` = '31646' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home ready for immediate move in. Fantastic location, only a few minutes from 99 and Hwy 290. Located on a large corner lot with full sprinklers. Inside you will find fresh, trendy colors and tons of natural light. You will love the open living area with a kitchen that boasts all stainless appliances, gas cooktop, granite countertops and new island pendant lighting. The owner\'s suite bathroom has an oversized shower and spacious closet. There are three additional bedrooms and a home office. Some recent updated include 4\' shutters and blinds, electric garage door opener, recessed lighting, entry and kitchen island lighting, as well as shrubs, crepe myrtles and full yard sprinklers. Convenient to Houston Premium Outlet mall, dining, churches and hospitals.\r\nCall agent today for private showing.' ,`Acres` = '0.1735' ,`Area` = '25' ,`BuilderName` = 'Gehan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 STONE CREEK RANCH SEC 9 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7556' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '8184' ,`TaxRate` = '3.1924' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527738' WHERE `Matrix_Unique_ID` = '213329238' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T04:43:31.040' ,`MLSNumber` = '48344896' ,`ListAgentFullName` = 'Elisa Noriega' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.348410' ,`Longitude` = '-95.533165' ,`PhotoCount` = '13' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '357990.00' ,`Status` = 'Active' ,`StreetName` = 'Westlake' ,`StreetNumber` = '462' ,`StreetSuffix` = 'Landing' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to Hills of Westlake, offering easy access to I-45, minutes from Lake Conroe, and zoned to CONROE ISD. Community offers a large SPARKLING community pool and playground. This 3 bed, 2.5 bath plus a STUDY is loaded with LUXURY features -- GRANITE ISLAND, breakfast bar, 42\" modern cabinetry, and stainless steel appliances w/ a 5-burner cooktop. White Shaker Cabinets and White Backsplash. SMART HOME PACKAGE, solid surface flooring throughout, sprinkler system, and tankless water heater. Spacious guest rooms and a HUGE primary retreat w/ dual vanities, frameless shower, and separate tub. Spacious tandem 3 CAR GARAGE and a RELAXING backyard featuring covered back Patio!!!' ,`Acres` = '0.1693' ,`Area` = '19' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - HILLS OF WESTLAKE 02, BLOCK 2, LOT 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake 02' ,`TaxAmount` = '1061' ,`TaxRate` = '2.8638' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527738' WHERE `Matrix_Unique_ID` = '213852043' --> 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','214641226','1668527739','214641226','2022-11-15T03:54:20.840','96561413','Gayla Gayden','REALM Real Estate Professional','','','30.072124','-95.720627','21','77377','13','394000.00','Active','Blossoming Buttercup','19030','Drive','Tomball','2','1','4','2696','Single-Family','Stunning New CastleRock Communities Home! Upgraded Stone & Brick Elevation! Wonderful Large Lot! Enjoy the Outstanding Large Outdoor Covered Patio! Grand Entry with High Ceilings! Wonderful Study or Home Office tucked away from all main areas! The Grand Family Area flows into the Casual Dining & Gourmet Kitchen! Upgraded Large Tile Plank Wood Floors throughout! The Gourmet Kitchen has a Huge Eat In Breakfast Bar with Gorgeous Granite Countertops, Deep Undermount Sink, Stunning Upgraded White Cabinets, Subway Glass Tile Backsplash, Stainless Steel Appliances and more! Private Owner\'s Suite with High Coffered Ceilings, French Doors opens to the Luxurious Bathroom with His & Her Private Sinks Vanity, Deep Soaker Tub, Large Shower & Massive Walk In Closet! Upstairs discover Huge Game Room, Three Large Guest Bedrooms & more! Energy Saving Rated HERS Home! Outstanding Schools! Wonderful Amenities! Conveniently located 5 min north of the Grand Pkwy (99) halfway between Highways 290 & 249','','35','Castlerock','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Tomball Southwest','Central Gas,Zoned','1','Rosehill Reserve: Lot: 7 /Block: 2','Subdivision Lot','10148','Appraisal District','','900','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','53 - Tomball','GRAND OAKS ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Builder','2','Traditional','ROSEHILL RESERVE','','','Public Sewer,Public Water,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','214719548','1668527739','214719548','2022-11-15T04:05:28.673','89528864','Gayla Gayden','REALM Real Estate Professional','','','29.737137','-96.166573','25','77474','13','289990.00','Active','Blue Finch','1223','Lane','Sealy','3','0','4','2257','Single-Family','The Mitchell Plan by D.R.Horton Brick & Stone Elevation! This 2 Story Home featuring Modern High End, Chic Styles throughout! The Owner & Guest Suite Downstairs along with Two Full Bathrooms! Wonderful Open Floor Plan boasting natural lighting & features Upgraded Carefree Vinyl Wood Floors throughout the 1st Floor! Casual Dining Area & Amazing Family Room that flows gracefully into the Chef\'s Caliber Gourmet Kitchen with Upgraded Granite Countertops, Eat-in Working Island W/Under-mount Stainless Sink, Stainless Appliances, Tall Gorgeous Shaker Cabinets & more! The Owner\'s Suite features an incredible Spa-like bath completed with Massive Shower, His & Her Undermount Sink W/Granite Counter Vanity & Walk-in Closet! Upstairs you will discover Game Room, 2 Bedrooms & 1 Full Bath! All Bathrooms Have Granite Counters & Undermount Sinks! Covered Patio! HERS Energy Rated!  \"Smart Home Automation System with Echo which allows you to control your home almost anywhere! NO FLOODING! Great Amenities','','57','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','','Central Electric,Zoned','1','Westward Pointe Lot: 9 / Block: 5','Subdivision Lot','','','','700','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Electric Range','','Composition','109 - Sealy','SELMAN ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','2','Contemporary/Modern,Traditional','WESTWARD POINTE','','3.079','Public Sewer,Public Water,Water District','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','214763846','1668527739','214763846','2022-11-15T04:54:34.180','95807088','Lizz Sansone','RE/MAX Fine Properties','','','29.810817','-95.541044','50','77080','11','589900.00','Active','Teague','2046','Road','Houston','2','1','3','1985','Single-Family','With European-inspired design elements throughout, this stunning one-of-a-kind remodeled home has been updated from the inside out. Removed & reconfigured walls showcase an open & airy floor plan with hardwoods throughout. Formal dining & study open to living room with oak beamed cathedral ceiling, 10’ sliding glass doors, wood burning fireplace with custom mantel & shiplap accent wall. The thoughtful and well-planned kitchen features an island with breakfast bar, cabinetry highlighted by Quartzite counters & back splash, floating oak shelves, farmhouse sink, S/S appliances including 4-burner range w/pot filler, custom oak vent hood & walk-in pantry w/wine chiller, microwave and plenty of storage. Owner’s suite offers private access to patio & antiqued barn doors lead to luxurious bath with dual sink vanity, walk-in shower & closet. Secondary bedrooms have access to a second full bath & reading nook. Relaxing & serene backyard w/new 23x12 patio & pergola is perfect for entertaining!','0.2412','24','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Wood Burning Fireplace','1','Spring Branch','Central Electric','0','LT 1 BLK 2O ROYAL OAKS SEC 7','Subdivision Lot,Wooded','10508','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','49 - Spring Branch','PINE SHADOWS ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING WOODS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Royal Oaks','7323','2.4415','Public Sewer,Public Water','1962','Appraisal District'); --> New record created successfully