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','208145014','1675155382','208145014','2023-01-15T20:50:55.853','39945302','Assefaw Tecle','Flyers','Assefaw Tecle','Flyers','29.732823','-95.610012','8','77082','8','282000.00','Pending Continue to Show','Ashford Knoll','12715','Drive','Houston','3','1','4','1723','Single-Family','This beautiful spacious home with nice layout home, recently updated including foundation repair with transferable lifetime warranty, new sidings, fresh paint through-out, new flooring, is within five minutes from several strip malls. It sits within minutes of Bltwy 8, Westpark Tollway, Westheimer Rd. Richmond St & Hwy 6. It has laminated flooring and ceramic tile, has many windows with plenty natural lighting and new shutters, which gives each room a loftier effect. The open concept living area has a space that share a living area and a formal dining room with a ceiling fun. This home has a great fully equipped kitchen with plenty of counter tops and cabinet space. There are three bedrooms and a 4th one, a game room creatively converted to bed room, all 3 in first floor and 4th in 2nd floor, all good size with nice layout and walk in closet. All room dimensions are estimate Buyer/Tenant to verify room dimensions. Good size backyard with swimming pool and a 2 car garage','0.1149','31','','','','','Owner/Agent','','','1','Alief','Central Electric','1','LT 21 BLK 5 ASHFORD PARK SEC 6','Other','5005','Appraisal District','','170','0','','2','Electric Oven','1','Above Ground','','Electric Cooktop','','Wood Shingle','2 - Alief','HEFLIN ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Contemporary/Modern','Ashford Park Sec 06','4221','2.4411','Public Sewer,Public Water','1981','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-15T19:31:24.077' ,`MLSNumber` = '20497784' ,`ListAgentFullName` = 'Becky Ellis' ,`ListOfficeName` = 'A.M. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790352' ,`Longitude` = '-95.529490' ,`PhotoCount` = '27' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'PINE LAKE' ,`StreetNumber` = '9706' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HomePath offers you this Designer influenced remodeled home in Spring Branch! It has a charming front porch with cedar columns,designer tile & inviting upgrade front door.When you step into this home,you are greeted by real hardwood floors that have been beautifully refinished throughout the home.This home has entertaining flow from the living rm to dining & den.The dining has it\'s own serving bar.The grand den has a mega dining bar,deco fireplace with gas logs & a wall of windows overlooking the backyd,patio & the sparkling POOL.The kitchen has a view of the den & dining rm with NEW quartz counters,herringbone backsplash,stylish lighting,Shaker style soft close drawers & cabinets & new APPLIANCES! Bedrms are ample size with new fans & wood or tile floors.Both baths are delightful with NEW vanities,quartz counters,lighting,faucets & designer diagonal flooring.The primary bath has dual sinks & a mega linen closet. There is a cute workshp/storage/poolhouse in the massive backyd.' ,`Acres` = '0.1901' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 18 LONG POINT WOODS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Long Point Woods Sec 03' ,`TaxAmount` = '13382' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675155382' WHERE `Matrix_Unique_ID` = '213541619' --> 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','215553011','1675155382','215553011','2023-01-15T19:04:30.147','11660206','Valentina Marquez','eXp Realty, LLC','','','29.942191','-95.272119','22','77396','4','265000.00','Active','Audubon Forest Dr','7711','','Humble','2','0','4','1677','Single-Family','Come to see this beautiful one story move in ready home established on an extensive lot. Home offers an open floor concept with 4 bedrooms and 2 full baths. the kitchen offers granite countertops with deep sink and appliances. home has tile, laminate and vinyl Flooring (NO CARPET). The yard is one of the most spacious lots in the neighborhood.','','1','','','','','Mud,Sellers Disclosure','1','','1','Humble Area East','Central Electric','1','LT 28 BLK 8 Audubon Park Sec 1','Subdivision Lot','12540','Appraisal District','','353','0','','2','','0','','','','','Composition','29 - Humble','NORTH BELT ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Audubon Park Sec 1','','','Water District','1978','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','216185687','1675155383','216185687','2023-01-15T20:25:05.290','59354105','Wojciech Kic','HOUSEforPURCHASE.com, LLC','','','29.691870','-95.421611','15','77025','3','475000.00','Active','Ashwood','2815','','Houston','2','0','3','1669','Single-Family','A classic, one-story, three bedroom/two bath house; living, dining, hardwoods/carpet, central a/c and heat, garage, fenced back yard. Appointment with offers required.','0.2169','17','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Knollwood/Woodside Area','Central Gas','0','LT 9 & TR 10A BLK 30 KNOLLWOOD VILLAGE SEC 9','Subdivision Lot','9450','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Knollwood Village','7843','2.3307','Public Sewer,Public Water','1952','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','216330220','1675155383','216330220','2023-01-15T20:37:20.420','62275430','Nicole Nie','ECHOSTATE REALTY INC','','','29.982413','-95.462055','9','77014','6','285000.00','Active','Timber Estate','12203','Drive','Houston','2','0','3','1373','Single-Family','Gated private subdivision. If Brand New Quality Craftsmanship is what you are dreaming of in a beautiful established neighborhood, you found your next home. Echostate Solution, Inc. built this stunning one-story with constructed of the finest building materials and satisfied international Building code. With 9-foot ceiling, extended entry leads past formal living and dining to open kitchen, all with rich laminate floor and ceramic tile in wet areas, granite counter and vanity tops. The master suite has glass-enclosed shower, dual vanity sinks and walk-in closet. 2-10 Home Warranty ensures peace of mind your investment is well protected. Please add this home to your must-see list before it is too late. Count on Echostate to be your new home Solution.','0.0995','13','Echostate','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent','1','','','1960/Cypress Creek South','Central Gas','1','LT 20 BLK 1 ECHO LEAF','Corner','4334','Appraisal District','','750','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','48 - Spring','CLARK ELEMENTARY SCHOOL (SPRING)','ANDY DEKANEY H S','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Echoleaf','147','2.8867','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','216387934','1675155383','216387934','2023-01-15T19:48:28.780','92988691','Sandy Cruz','Colesio Real Estate, LLC','','','30.415586','-95.400830','20','77303','6','205000.00','Active','Royal Forest','11112','Drive','Conroe','2','0','3','1730','Single-Family','Cute and cozy brick starter home you don\'t want to miss out on! Listed at a great price, come make your home here in the peaceful woods of Conroe. Only minutes from Lake Conroe come fall in love with the wooded scenery and your own little haven. As part of Royal Forest Colony Club, this home offers a private lake with fishing/swimming piers plus more for those family and friend get togethers. This home has 3 good sized bedrooms and an extra room to use for an office, game room etc. Large living room area and utility room. Sizes of the rooms are not exact, but just an estimate. Buyer will need to verify. Come check it out! Bring your best offer.','0.3915','19','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Willis Area','Central Electric','1','S847000 - ROYAL FOREST 01, BLOCK 1, LOT 19A','Subdivision Lot','17054','Appraisal District','','170','0','','0','Freestanding Oven','0','','','','','Composition','56 - Willis','EDWARD B. CANNAN ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Royal Forest 01','4114','1.8448','Public Water,Septic Tank','1978','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','216406106','1675155383','216406106','2023-01-15T20:44:21.467','10582546','Nicole Nie','ECHOSTATE REALTY INC','','','29.982413','-95.462055','7','77014','6','291500.00','Active','Timber Estate','12207','Drive','Houston','2','0','3','1423','Single-Family','Gated private subdivision. If Brand New Quality Craftsmanship is what you are dreaming of in a beautiful established neighborhood, you found your next home. Echostate Solution, Inc. built this stunning one-story with constructed of the finest building materials and satisfied the international Building code. With a 9-foot ceiling, extended entry leads past formal living and dining to an open kitchen with big island, all with rich vinyl plank floor and ceramic tile in wet areas, granite counter and vanity tops. The master suite has glass-enclosed shower, dual vanity sinks and walk-in closet. 2-10 Home Warranty ensures peace of mind your investment is well protected. Please add this home to your must-see list before it is too late. Count on Echostate to be your new home Solution.','0.1006','13','ECHOSTATE SOLUTION','','','','Owner/Agent','1','','','1960/Cypress Creek South','Central Gas','1','LT 21 BLK 1 ECHO LEAF','Subdivision Lot','4381','Appraisal District','','750','1','To Be Built/Under Construction','2','','0','','','','','Composition','48 - Spring','CLARK ELEMENTARY SCHOOL (SPRING)','ANDY DEKANEY H S','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','ECHO LEAF','149','2.8867','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','216410871','1675155383','216410871','2023-01-15T20:21:12.327','90534590','Hamed Rauf','Samrauf Properties, Inc.','','','30.458796','-95.474081','12','77378','4','230000.00','Active','Big Spring','15136','Circle','Willis','2','1','4','1674','Single-Family','Beautiful home in a nice location.','','19','','','','','Mud,Real Estate Owned','','','','Willis Area','Central Electric','1','Arrowhead Lakes 08, Block 25, Lot 39','Subdivision Lot','','','','120','0','','2','','0','','','','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Arrowhead Lakes','3395','','Water District','2019','Appraisal District'); --> New record created successfully