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-09-03T19:51:57.973' ,`MLSNumber` = '30098167' ,`ListAgentFullName` = 'Jessica Portillo' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034425' ,`Longitude` = '-95.374510' ,`PhotoCount` = '12' ,`PostalCode` = '77338' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Trails' ,`StreetNumber` = '3723' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This home is the perfect starter home,3 beds, 2 baths, Well taken cared of, Granite countertops and upgraded cabinets in kitchen! Plus spacious back yard!' ,`Acres` = '0.1287' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 1 ARBOR TRAILS SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5608' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Arbor Trls Sec 3' ,`TaxAmount` = '5671' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706420' WHERE `Matrix_Unique_ID` = '210027862' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T19:19:29.070' ,`MLSNumber` = '90764157' ,`ListAgentFullName` = 'Brandon Brewer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.160996' ,`Longitude` = '-95.203579' ,`PhotoCount` = '35' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Via Camino' ,`StreetNumber` = '23822' ,`StreetSuffix` = 'Lane' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This stunning 2020 build is in the master planned community of Tavola, home to 3800 families. The neighborhood offers a Jr Olympic sized swimming pool, walking trails, numerous playgrounds and it\'s very own elementary school! The home has been well maintained and includes solar panels already installed! Come see for yourself and fall in love with the entire community!' ,`Acres` = '0.1251' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S921128 - TAVOLA 28, BLOCK 1, LOT 9' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '6581' ,`TaxRate` = '3.4331' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706421' WHERE `Matrix_Unique_ID` = '210150327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T19:54:33.223' ,`MLSNumber` = '96262996' ,`ListAgentFullName` = 'Louise Baumann' ,`ListOfficeName` = 'Running S Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.043827' ,`Longitude` = '-95.423034' ,`PhotoCount` = '41' ,`PostalCode` = '77566' ,`RoomCount` = '9' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterlily' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly updated and renovated 4 bedroom, 2.5 bath located in prestigious neighborhood located just minutes from downtown Lake Jackson. Corner Lot located on Cul-de-sac with 3 car garage. Entire backyard has privacy fence with gate access. Mature trees, plush yard, and fully landscaped. Granite throughout the updated kitchen, large farmhouse sink, gas cooking appliances, and walk in pantry. Backyard has partially covered concrete patio with a gorgeous Oak tree inside the privacy fence. Additional concrete slab in place for hot tub or home generator.' ,`Acres` = '0.3865' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN LAKE ESTATES (LAKE JACKSON), BLOCK 5, LOT 4' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '16836' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Pecan Lake Estates Lake Jacks' ,`TaxAmount` = '5656' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706421' WHERE `Matrix_Unique_ID` = '210641619' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T18:11:03.587' ,`MLSNumber` = '27680477' ,`ListAgentFullName` = 'Carolina Sarmiento' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659299' ,`Longitude` = '-95.449708' ,`PhotoCount` = '26' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingfisher' ,`StreetNumber` = '4313' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1928' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This newly remodeled home features 3 bedrooms and 2 bathrooms and is located in the great Willowbrook Subdivision. It has a wide open living/dining area and new custom kitchen with new 3 cm quartz waterfall countertops, new soft shut cabinets, made with solid wood, new sink, new paint, new flooring throughout the entire home, porcelain tile flooring in the kitchen and bathrooms, new primary bathroom with stand alone shower with his and hers shower heads, his and hers custom soft shut vanities made with solid wood. New AC system! Come check out everything this home has to offer today!' ,`Acres` = '0.1816' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 20 WILLOWBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbrook Sec 02' ,`TaxAmount` = '6602' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706421' WHERE `Matrix_Unique_ID` = '210770494' --> 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','211283305','1663706421','211283305','2022-09-03T19:05:24.713','7127319','Melanie Dinh','Truss Real Estate','','','30.186972','-95.554246','43','77382','10','2495000.00','Active','Palmiera','66','Circle','The Woodlands','5','2','5','6467','Single-Family','Located in the prestigious Carlton Woods subdivision, The Club at Carlton Woods golf-course, this Modern Mediterranean charm offers all the bells and whistles. Tons of upgrades: SAVANT home automated system, with LUTRON switches, LED module trimmed lights (estimated around $140K). Features grand entrance, more than 23 ft height ceiling; stunning gourmet kitchen with oversized island, WOLFE oven/range, SUBZERO refrigerator, custom cabinetry, built-in microwave & ice-maker, large pantry, walk-in wine room, formal dining, breakfast room, spacious living room with fireplace. Luxurious primary suite with walk-in closet, coffee-bar with sink, his & her vanities, jetted tub, stunning tray ceiling. Separate access to Guest Casita adjacent to outdoor swimming-pool, with coffee bar & full bath. 3 secondary bedrooms are on 2nd floor, additional 2 custom built fitness rooms, with media/flex spaces, and balcony. ALL MEASUREMENTS MUST BE VERIFIED INDEPENDENTLY BY BUYERS. ASK FOR FULL UPGRADE LIST.','0.3926','15','TIPLER','','Electric Dryer Connections,Washer Connections','','Mud,Reports Available,Sellers Disclosure','1','Gaslog Fireplace','2','The Woodlands','Central Gas,Zoned','1','WDLNDS VIL OF CARLTON WOODS 14, BLOCK 1, LOT 14','In Golf Course Community','17102','Appraisal District','','4250','0','','4','Double Oven,Gas Oven','1','Gunite','','Gas Range','','Other,Tile','11 - Conroe','TOUGH ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Mediterranean,Other Style,Spanish,Traditional','Wdlnds Village Of Carlton Woods 14','40892','2.1816','Public Sewer,Water District','2013','Appraisal'); --> 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','211893098','1663706421','211893098','2022-09-03T18:42:45.017','18822249','Olga Kostenko','Walzel Properties','','','29.790477','-95.376865','32','77009','16','1195000.00','Active','Pecore','512','Street','Houston','2','1','3','3221','Single-Family','Absolutely stunning and charming Craftsman/Victorian style home in Woodland Heights. From floor to ceiling, this newly renovated home boasts 5” red oak hardwood floors and 7” classic crown molding. Your chef will feel right at home in this spacious custom-designed kitchen, featuring a commercial-grade Italian gas stove & Viking refrigerator. The incredible master suite on the first floor has a vaulted ceiling and private doorway open to the beautifully landscaped butterfly garden. A hand-made custom octagonal stained-glass window brings beautiful light into the staircase leading to the second floor. 2/3 bedrooms upstairs share a Hollywood bath with three separate marble vanities, and a work/play space with custom built-ins could be used as a third bed for weekend sleepovers. Not to be missed features include commercial-grade automated entry gate, whole house generator, security cameras, alarm system, custom built-ins and so much more.','0.1435','9','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Heights/Greater Heights','Central Gas','0','LT 4 BLK 1 BURRELL','Subdivision Lot','6250','Appraisal District','','','0','','2','Double Oven,Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','TRAVIS ELEMENTARY SCHOOL (HOUSTON)','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,Controlled Access,Leave Business Card,No Photos/No Videos,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Craftsman,Traditional','Woodland Heights','21731','2.5304','Public Water','2006','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','212031662','1663706421','212031662','2022-09-03T19:32:45.800','36474935','Claudia Briz','ELLE and CO Properties','','','30.022417','-95.306373','26','77338','4','410000.00','Active','Wickton','21231','Lane','Humble','2','1','4','3350','Single-Family','Beautiful, spacious home in a cul-de-sac mins away from the elementary schools, and Bush Airport. This owner agent home has a newly remodeled kitchen. The huge yard includes an underground pool and space big enough to build an outdoor kitchen. The master down includes large bathroom with a loft above with a separate stair case. The house is sold as is.','0.2509','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gas Connections','1','Humble Area West','Central Electric','1','LT 8 BLK 1 KENSWICK FOREST SEC 5','Cul-De-Sac','10931','Appraisal District','','','0','','2','Convection Oven','1','In Ground','','Gas Cooktop','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required','Appraisal District','2','Traditional','Kenswick Forest Sec 05','7364','2.7433','Water District','2006','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','212148054','1663706421','212148054','2022-09-03T19:14:22.300','7946751','Cathy Brown','BHGRE Gary Greene','','','30.004117','-95.164970','48','77346','12','390000.00','Active','Wood Walk','19706','Lane','Humble','3','1','4','3559','Single-Family','Spacious inside and out! This 4 Bedroom/3 1/2 Bath home offers so much room to grow! The home is on a large lot located in Pinehurst of Atascocita with close proximity to walking paths, schools, and shopping. Enter into the stunning 2-story foyer with curved staircase flanked by formal dining room and spacious home/office. The kitchen with island cooktop has plenty of counter and cabinet space and overlooks the family room which features a gas log fireplace. The owner\'s retreat is located in the back of the home on the first floor and features an ensuite bathroom and large walk in closet. A Flex room is adjacent to the owner\'s retreat. Upstairs has a gameroom, 3 generously sized bedrooms, 2 full bathrooms,and a large finished bonus space over the garage. The backyard has a raised wooden deck and plenty of backyard room for entertaining. The driveway is extended and is large enough to park multiple vehicles.','0.2286','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Atascocita North','Central Gas','1','LT 21 BLK 27 PINEHURST OF ATASCOCITA 8 AMND','Subdivision Lot','9957','Appraisal District','','649','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','29 - Humble','PINEFOREST ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Pinehurst/Atascocita Sec 8 Amd','7911','2.453','Public Sewer,Public Water','1999','Appraisal District'); --> New record created successfully