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-12-22T13:59:23.313' ,`MLSNumber` = '37818361' ,`ListAgentFullName` = 'Tammie Brisby' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.440090' ,`Longitude` = '-95.449096' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Shimmering Lakes' ,`StreetNumber` = '9919' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This corner lot has a huge yard. Open floor plan. Granite counter top with eat/in. Master bedroom with double sink. Separate Tub and Shower and over sized walk in closet. Main bedroom on first floor and loft/game room upstairs. Great room sizes and half way upstairs too overlook first floor.' ,`Acres` = '0.193' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 11 (A0289 HT&B) BLK 2 LOT' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot,Water View' ,`LotSize` = '8407' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '9032' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094309' WHERE `Matrix_Unique_ID` = '209196022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T13:53:10.920' ,`MLSNumber` = '55831237' ,`ListAgentFullName` = 'Arthur Confait' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726717' ,`Longitude` = '-95.935684' ,`PhotoCount` = '25' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Windy Plantation' ,`StreetNumber` = '5302' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this little piece of heaven tucked away in the desirable Vanbrooke Subdivision of Brookshire . A fully landscaped front yard adds great curb appeal as you enter into the home with 9\' - 11\' ceilings and classic tile entry flooded with natural light. The kitchen is fully equipped with 42\" dark maple cabinets, 12\" tiled back splash, stainless steel sink with vegetable sprayer, and GE appliances. This home includes brushed nickel lighting fixtures, rounded Sheetrock corners throughout, and ceramic tile flooring in wet areas. The primary bedroom and bathroom are complete with dark maple cabinets ( to match the kitchen) , glass doored shower and marble garden tub with cultured marble top. This great home is walking distance from the neighborhood amenity center that includes a splash pad, resort style pool, playground, and open air pavilion. Make your appointment today!' ,`Acres` = '0.1291' ,`Area` = '30' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 1, BLOCK 6, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke' ,`TaxAmount` = '7643' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094309' WHERE `Matrix_Unique_ID` = '213583516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T14:45:41.213' ,`MLSNumber` = '98425689' ,`ListAgentFullName` = 'Sean Namli' ,`ListOfficeName` = 'Dr. Sean Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.521998' ,`Longitude` = '-94.811336' ,`PhotoCount` = '43' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '88888.00' ,`Status` = 'Active' ,`StreetName` = 'George Jones' ,`StreetNumber` = '281' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lots 297 & 298. Almost 500sq ft, approximately 1.5 acres for less than $100K!! Manufactured home with 1 bedroom, 1 bath and living space. Private, wooded and peaceful area. Home only one year old with small lake in back Refrigerator stays. Come get this before someone else does! Punch in George Jones Road Livingston on your GPS for the directions. Do NOT put the house number in or it will bring you elsewhere.' ,`Acres` = '1.5' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WILD COUNTRY LAKES ESTATES SECTION 3 LOT 298' ,`LotDesciption` = 'Wooded' ,`LotSize` = '15235' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wild Country Lakes Estates Sec' ,`TaxAmount` = '20' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675094309' WHERE `Matrix_Unique_ID` = '214129641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T13:49:54.943' ,`MLSNumber` = '80917883' ,`ListAgentFullName` = 'Wes Stoyanov' ,`ListOfficeName` = 'Luxury Homes Realty' ,`SellingAgentFullName` = 'Wes Stoyanov' ,`SellingOfficeName` = 'Luxury Homes Realty' ,`Latitude` = '29.851496' ,`Longitude` = '-95.457171' ,`PhotoCount` = '6' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '1175000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mansfield' ,`StreetNumber` = '3322' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 ACRES GREAT FOR NEW CONSTRUCTION DEVELOPMENT - LOT IS SURROUNDED BY NEW CONSTRUCTION. CALL AGENT WITH ANY QUESTIONS. NICELY GATED PROPERTY WITH A LIVEABLE HOUSE ON SITE.' ,`Acres` = '0.7544' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 58 LT 59 BLK 23 HIGHLAND HEIGHTS ANNEX SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HARRIS ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights Anx Sec 04' ,`TaxAmount` = '5928' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094309' WHERE `Matrix_Unique_ID` = '214783174' --> 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','215506871','1675094310','215506871','2022-12-22T13:49:36.677','65962001','Valerie McKenzie','Galveston Island Real Estate','','','29.184692','-94.978992','9','77554','3','258000.00','Active','Henry Morgan','16724','Road','Jamaica Beach','1','0','1','656','Single-Family','Great corner lot in Jamaica Beach. Peak a boo view of the Gulf and Bay. Bring your imagination, for the diamond in the rough. Living, dining, kitchen combo. Selling as is. Seller will do no repairs. To schedule a showing please call Galveston Island Real Estate. No Showings until after 1 pm. Tenant doesn\'t leave until then. No showings conducted on Sunday and Monday. Tenant occupied. Room sizes are approximate, please verify. Home is not furnished. All items in house are the property of the tenant. Entire re-roof in January 2018, New interior Air Handler December 2021.','0.2076','33','','','','','Exclusions,Sellers Disclosure','1','','','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 14 BLK B JAMAICA BEACH SEC 10','Corner,Subdivision Lot','9043','Appraisal District','','25','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal','1','Other Style','Jamaica Beach 10','2480','1.7086','Public Sewer,Public Water','1965','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','215568538','1675094310','215568538','2022-12-22T13:36:47.620','38927172','Joshua Payne','Century 21 Olympian Galleria','','','29.672621','-95.346591','10','77033','3','120000.00','Active','Willow Glen','5027','Drive','Houston','1','0','3','751','Single-Family','REHABBABLE HOUSE IN 77033 RIGHT NEXT DOOR TO A NICE RECENTLY BUILT DUPLEX AND LOTS OF OTHER NEW DEVELOPMENT IN THE AREA! THIS AREA IS HOT BECAUSE OF IT\'S CLOSE PROXIMITY TO ALL THE MAJOR FREEWAYS, DOWNTOWN, MEDICAL CENTER, THE UNIVERSITIES, AND TONS OF SHOPPING AND DINING! THE HOUSE CAN BE REHABBED OR TORN DOWN FOR A NEW BUILD LIKE THE ONE NEXT DOOR! DON\'T WASTE TIME THIS ONE WON\'T LAST...LET\'S MAKE IT YOUR NEXT PROJECT!!!','0.1483','3','','','','','No Disclosures','','','','Medical Center South','No Heating','0','LT 7 BLK 4 INWOOD TERRACE SEC 1','Cleared','6460','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','BASTIAN ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Appraisal District','1','Ranch','Inwood Terrace Sec 01','2098','2.3307','Public Sewer,Public Water','1955','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','215603183','1675094310','215603183','2022-12-22T14:57:09.343','16907350','Bruce Sellers','Keller Williams Advtge Realty','','','30.433490','-95.617101','39','77356','11','799000.00','Active','Creekwood','182','','Montgomery','3','1','4','4838','Single-Family','Located in the gated country club community of Bentwater on Lake Conroe, this waterfront home sits at the end of a short, protected inlet, just a pitching wedge from open water. The interior has been recently \"freshened\" with new paint and carpet. 4 fireplaces throughout this gorgeous home with high ceilings, art niches, crown molding and wainscoting. Primary bedroom is situated on the first floor just off the family room and has direct patio access. Upstairs you have a large game room with wet bar, media room and balcony with views of the lake. There are 3 large bedrooms w/2 full baths. Two garage entries and one is a tandem with separate golf cart entry. Two garage entries and one is a tandem with separate golf cart entry. This section has lawn maintenance included in your monthly neighborhood fee. Bentwater Country Club features 36 holes of golf, 9 tennis courts, two area pools, newly expanded and renovated sports club plus both formal and casual dining. Exemplary Montgomery ISD.','0.2113','39','','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','3','Lake Conroe Area','Central Gas,Zoned','1','S261539 - BENTWATER 39, BLOCK 1, LOT 17','In Golf Course Community,Waterfront','9206','Appraisal District','','1046','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Bentwater','21968','2.1142','Water District','2007','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','215737213','1675094310','215737213','2022-12-22T14:46:07.857','5708091','Bruce Sellers','Keller Williams Advtge Realty','','','30.421067','-95.613535','44','77356','15','999999.00','Active','Promenade','83','Street','Montgomery','3','2','4','5671','Single-Family','Located in the Estates Section of the gated country club community of Bentwater on the shores of Lake Conroe, this home is uniquely situated on the golf course while also enjoying a water view. Dramatic interior colors with a downstairs layout that\'s ideal for entertaining whether for four guests of forty. Upstairs has three bedrooms, a open game area and private media room. Exterior features fully screened rear deck with (remote control screens) overlooking your pool and spa area. With the double fairway of #12 Weiskopf behind you it\'s a very private setting, perhaps 250 yards from the homes across the way. Viewing down the fairway you see the #12 green and Lake Conroe just behind it. Two two-car garages (connected) provide plenty of space for your vehicles, your golf cart and even has room for a workshop area. Back inside, the photos show you the individual rooms, but this is one of those homes you\'ll want to see in person go fully appreciate the layout. Exemplary Montgomery ISD.','0.3129','39','','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Freestanding,Gaslog Fireplace,Wood Burning Fireplace','2','Lake Conroe Area','Propane,Zoned','1','S261525 - BENTWATER 25, BLOCK 1, LOT 11','In Golf Course Community,On Golf Course,Subdivision Lot,Water View','13632','Appraisal District','','1381','0','','4','Double Oven,Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Bentwater','12348','2.1142','Water District','1996','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','215787411','1675094310','215787411','2022-12-22T14:53:32.090','51846951','Christopher Ward','Orchard Brokerage','','','29.895062','-95.572311','28','77040','15','635000.00','Active','Koester','16434','Street','Jersey Village','4','1','5','3481','Single-Family','Click the Virtual Tour link to view the 3D walkthrough. Gorgeous brick exterior awaits new owners! This 5 bed/4.5 bath home is move-in ready with plenty of space to entertain. High ceilings, natural lighting, balcony, and an ideal floor plan are just a few house highlights. Cook a meal using the granite countertops, gas cooktop, kitchen island, and ample white cabinetry. The den features built-in shelves and a desk waiting to be used. Located on the main level, the primary bedroom boasts a 5 piece en-suite bathroom with a jetted soaking tub and a large walk-in closet. Each of the remaining spacious bedrooms are located on the second floor and one bedroom has access to its own balcony. Also an additional 1100 sqft mother’s quarters/apartment located above the three-car garage. Spend the day at Jersey Meadow Golf Course or at the Jersey Village Walking and Jogging Trail. Close access to HWY-290, HWY-8, and grocery stores. This is an opportunity to not be missed. Welcome home!','0.4022','10','','','','','Mud','1','','1','Jersey Village','Central Gas','0','LT 1 BLK 51 JERSEY VILLAGE COUNTRY CLUB ESTATES SEC 4','Corner,Subdivision Lot','17520','Appraisal District','','','0','','3','Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','JERSEY VILLAGE HIGH SCHOOL','COOK MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Country Club Estates Sec 04','12663','2.7758','Public Sewer,Public Water','1995','Appraisal District'); --> New record created successfully