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` = '2023-01-07T18:21:21.997' ,`MLSNumber` = '86865846' ,`ListAgentFullName` = 'Aaron Mancilla' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794602' ,`Longitude` = '-95.363577' ,`PhotoCount` = '15' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Kennon' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor ready home, the home is priced to sale ready for your new or first-time investment home, bring all offers. The home is currently located 10 miles away from downtown, 3 miles from the heights and close to 45, Hardy toll, 610 North loop. Metro rail is just a few blocks away. Home is a 3-bedroom 1 bath, home and it also comes with a small apartment in the back perfect for extra rents or Airbnb.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'Mancilla subdivision block 1 lot 2' ,`LotDesciption` = 'Other' ,`LotSize` = '4099' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mancilla' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106130' WHERE `Matrix_Unique_ID` = '208125454' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-07T17:48:59.480' ,`MLSNumber` = '56179349' ,`ListAgentFullName` = 'Morgan Allen Neal' ,`ListOfficeName` = 'C & K Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657929' ,`Longitude` = '-95.452856' ,`PhotoCount` = '17' ,`PostalCode` = '77035' ,`RoomCount` = '10' ,`ListPrice` = '374999.00' ,`Status` = 'Active' ,`StreetName` = 'Sanford' ,`StreetNumber` = '4510' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED. Charming home in coveted Willowbend neighborhood! Rare find in this area for 4 bedrooms and 3 full baths. The island kitchen features updated cabinets with pull-out shelves, granite counters, SS appliances, slate floors, and breakfast area. Kitchen opens to den which has built-in shelves, slate floors, and doors opening out on to the large back yard with pool. Spacious formal dining room with beautiful hardwood floors. Converted garage makes for a generous primary bedroom with two closets and a remodeled ensuite bath. Laundry room conveniently located next to primary bath. One secondary bedroom has a built-in desk and bookshelves - perfect for working at home! A remodeled full bathroom in the hall services two of the secondary bedrooms, and the fourth bedroom has an ensuite bath with standup shower. Great location in close proximity to Downtown, the Galleria, and the Med Center. A must see home in Willowbend! **All Info per Seller' ,`Acres` = '0.1736' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 3 POST OAK MANOR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Oak Manor' ,`TaxAmount` = '5968' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106131' WHERE `Matrix_Unique_ID` = '212339309' --> 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','215257068','1675106131','215257068','2023-01-07T17:08:03.530','90838117','Yvette Reyes-Hall','Reyes Realty Group, LLC','','','29.478877','-95.352930','26','77578','7','479900.00','Active','Masters','6710','Road','Manvel','2','0','3','2056','Single-Family','OVER 400 FT OF FRONTAGE ON HIGHLY TRAVELED MASTERS ROAD (FM 1128)! CORNER PROPERTY! GREAT OPPORTUNITY TO OWN PRIME REAL ESTATE HERE! GREAT LOCATION! HIGH VISIBILITY & HIGH TRAFFIC! IS FENCED WITH OVER 400FT OF FRONTAGE ON FM 1128 AND 400FT+ ON TANKERSLEY ROAD! WITH MANVEL BOOMING, ON-GOING DEVELOPMENT IS THROUGHOUT THE AREA! THIS IS A SUPERIOR LOCATION FOR A BUSINESS, A HOME OR BOTH! ONLY .86 MILE DOWN FROM HWY 6! PROPERTY HAS EXISTING HOME, DETACHED GARAGE AND OTHER EXISTING STRUCTURES-ALL IN NEED OF MAJOR REPAIR (EXACT CONDITIONS ARE UNKNOWN). DON\'T MISS OUT ON THIS INCREDIBLE OPPORTUNITY WITH ENDLESS POSSIBILITIES!!','3.184','5','','','','','Estate,Sellers Disclosure','','Freestanding','1','Alvin North','Central Gas','0','MANVEL ACRES LOT 4A-5-6-7-8 MANVEL ACRES 3.184','Corner','138695','Appraisal District','','','0','','2','','0','','','','','Composition','3 - Alvin','E C MASON ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','MANVEL JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Manvel Acres','6780','2.7874','Public Water,Septic Tank','1979','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','215425828','1675106131','215425828','2023-01-07T17:52:34.033','15308530','Elisa Noriega','NB Elite Realty','','','30.322560','-95.514912','7','77304','4','340240.00','Active','Pleasant Hill','325','Way','Conroe','2','1','3','2060','Single-Family','WELCOME HOME to HILLS of WESTLAKE, one of Conroe\'s newest communities offering easy access to I-45, minutes from Lake Conroe, and zoned to CONROE ISD. Community offers a large community pool and playground. THIS NEW 3 bed, 2.5 bath w/ 3-CAR TANDEM GARAGE is loaded with LUXURY features -- GRANITE ISLAND, breakfast bar, 42\" modern white cabinetry, and stainless steel appliances w/ a 5-burner cooktop. 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. Relaxing backyard featuring covered back patio!!!','0.1475','19','DR HORTON','','Electric Dryer Connections','','Mud','1','','','Lake Conroe Area','Central Gas','1','S582102 - HILLS OF WESTLAKE 02, BLOCK 2, LOT 6','Subdivision Lot','6423','Appraisal District','','650','1','Never Lived In','3','','0','','','','','Composition','11 - Conroe','GORDON-REED ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Hills Of Westlake 02','5336','2.8638','Water District','2021','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','215914737','1675106131','215914737','2023-01-07T17:30:18.480','6865911','Feras Rachid','Opendoor Brokerage, LLC','','','29.941131','-95.711443','30','77433','4','525000.00','Active','Rockwood Park','26915','Lane','Cypress','3','1','4','3630','Single-Family','Welcome home! This home has fresh interior paint and partial flooring replacement. Discover a bright and open interior with plenty of natural light and a neutral color palette, complimented by a fireplace. You\'ll love cooking in this kitchen, complete with a spacious center island and a sleek backsplash. You won’t want to leave the serene primary suite, the perfect space to relax. Extra bedrooms add nice flex space for your everyday needs. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Step outside to your very own sparkling pool in the fenced in backyard, great for entertaining. A must see!','0.2089','25','','','','','Sellers Disclosure','1','','1','Cypress South','Central Gas','1','LT 35 BLK 1 CYPRESS CREEK LAKES SEC 4','Subdivision Lot','9100','Appraisal District','','900','0','','3','','1','In Ground','','','','Composition,Other','13 - Cypress-Fairbanks','WARNER ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Cypress Creek Lakes','10772','2.801','Water District','2005','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','215997282','1675106131','215997282','2023-01-07T18:10:27.720','71341454','William Onye','PRG, Realtors','','','30.184181','-95.148205','10','77357','8','239900.00','Active','Republic','931','Road','New Caney','2','1','4','1982','Single-Family','Opportunity awaits in Roman Forest. A 4 Bedroom 2.5 bath home an acre lot with 2 car garage detached. This investment opportunity offers a blank canvas for the buyer to paint their dream. No HOA. Surrounded by matured trees and a decent yard space. Never flooded! 10 min from shopping/dining and 15 min from Valley Ranch Town Center. This is a MUST SEE!','0.8803','40','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Porter/New Caney East','Central Electric','0','ROMAN FOREST 04, BLOCK 10, LOT 31','Subdivision Lot','38347','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Range','','Composition','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Roman Forest 04','6231','3.3492','Public Sewer,Public Water','1980','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','216053034','1675106131','216053034','2023-01-07T17:22:36.547','62074143','Traye Wise','RE/MAX Signature','','','30.218147','-95.750066','37','77354','9','265000.00','Active','Texarkana','206','Drive','Magnolia','2','0','3','1768','Single-Family','Beautiful Home was just Remodeled! Great one-story home in Windmill Estates - home features 3 bedroom, 2 bath with attached garage nestled among mature trees. Spacious Living with fireplace, Kitchen with Breakfast Area, Formal Dining, Utility Room in house, Sunroom/Gameroom, Library or Home Office space. Updates include New cabinets in Kitchen and Bathrooms with Granite counters. New SS Appliances, New Lighting and fixtures, New tile in Entry, Kitchen, Formal Dining, Breakfast, Utility, & Baths. Vinyl plank floors throughout Living & Bedrooms. PLUS Additional covered storage off right side of home perfect for a boat, trailer or possible RV. Let this be the next place you call Home!','0.2706','15','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Wood Burning Fireplace','1','Magnolia/1488 West','Central Electric','1','WINDMILL ESTATES, BLOCK F, LOT 11, ACRES 0.270','Subdivision Lot','11786','Appraisal District','','235','0','','2','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Windmill Estates','3134','2.2638','Public Sewer,Public Water','1976','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','216067385','1675106131','216067385','2023-01-07T18:24:23.200','48128845','Jared Turner','LennarVillageBldr-JaredTurner','','','30.164072','-95.190660','8','77357','8','280000.00','Active','Peppazzi','19429','Drive','New Caney','2','1','4','2211','Single-Family','NEW Gulf Coast Series \'\'Aransas II\" Elevation-A by Lennar in Gorgeous Tavola. This is a Wonderful Two Story 4 Bedroom, 2.5 Bath home. All Bedrooms Up! Features a Fantastic Kitchen with adjoining Breakfast Nook, Breakfast Bar, Designer Cabinets, Sparkling Countertops & Great Appliance Pkg! Open Concept w/ Generous Family Room and Dining Area! Master Suite w/ Tub, Separate Shower & Dual Walk-in Closets! Lovely Wood-look Hard Surface Floors and Carpet; Fully Sodded Yards; Energy Efficient 16 SEER HVAC System & More!','','40','Lennar Homes','','','','Mud,Other Disclosures','1','','','Porter/New Caney East','Central Gas','1','SEC 0044 BLK 003 LOT 015','Subdivision Lot','','','','800','1','To Be Built/Under Construction','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Tavola','','3.5826','Public Sewer,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','216157431','1675106131','216157431','2023-01-07T17:16:30.063','80613781','Dane Gates','Berkshire Hathaway HomeServices Premier Properties','','','30.080169','-95.902843','46','77484','12','1200000.00','Active','Waller Spring Creek','30611','Road','Waller','4','2','5','4159','Single-Family','Stunning custom home w/guest quarters and a workshop situated on 3 acres with beautiful mature trees. Property is fully fenced and crossed fenced w/2 separate pastures & barn. The circle driveway beautifully landscaped with tons of parking. This incredible single story home features an impressive primary suite with luxurious whirlpool bath, separate shower and walk in closet. 2nd private bedroom & bath. Two bedrooms with jack and jill bath. Impressive formal living with marble floors, wood burning fireplace, ornate trim and custom bookshelves. Island kitchen with abundant storage, site built cabinetry, stainless appliances, built in fridge, breakfast bar and pantry. Spacious Family Room with entertainment center and trey ceiling overlooking the sprawling backyard. In house utility with sink and storage. Huge covered patio! Large workshop for equipment and storage with its own bath. Low taxes and No HOA! Incredible location with easy access to 290 and 99.','3.1019','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Waller','Central Gas,Zoned','0','LT 1 BLK 1 HERNANDEZ ACRES','Cleared,Wooded','135119','Appraisal District','','','0','','2','Convection Oven,Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','55 - Waller','EVELYN TURLINGTON ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox','Appraisal District','1','Traditional','Hernandez Acres','11942','2.006','Aerobic,Well','2002','Appraisal District'); --> New record created successfully