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-07T19:43:53.187' ,`MLSNumber` = '41981853' ,`ListAgentFullName` = 'Fabiola Oropeza' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538784' ,`Longitude` = '-95.035201' ,`PhotoCount` = '35' ,`PostalCode` = '77565' ,`RoomCount` = '3' ,`ListPrice` = '217500.00' ,`Status` = 'Active' ,`StreetName` = 'Esther' ,`StreetNumber` = '1217' ,`StreetSuffix` = 'Street' ,`City` = 'Kemah' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled 3 bed 1.5 bath home located in Laguna Vista Estates. New flooring, New paint throughout, updated bright white kitchen, and bathroom. All appliances included. Schedule your Your today!' ,`Acres` = '0.1756' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR PT OF LOTS 12,13 & 14 (13-0) LAGUNA VI' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Laguna Vista Estates' ,`TaxAmount` = '2843' ,`TaxRate` = '1.8341' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707939' WHERE `Matrix_Unique_ID` = '204072895' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:41:08.937' ,`MLSNumber` = '51193379' ,`ListAgentFullName` = 'Fabiola Oropeza' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505155' ,`Longitude` = '-95.094153' ,`PhotoCount` = '15' ,`PostalCode` = '77573' ,`RoomCount` = '2' ,`ListPrice` = '169000.00' ,`Status` = 'Active' ,`StreetName` = 'Saunders' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bed 1 bath in quiet neighborhood. Great schools! Close to Space Center, Kemah, Galveston, dining, and shopping.' ,`Acres` = '0.1343' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 3 S F AUSTIN SUR LOT 31 PATTON SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'RALPH PARR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Patton 1' ,`TaxAmount` = '2543' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707939' WHERE `Matrix_Unique_ID` = '205497093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:42:37.260' ,`MLSNumber` = '7028794' ,`ListAgentFullName` = 'Fabiola Oropeza' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681469' ,`Longitude` = '-95.340986' ,`PhotoCount` = '22' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '179500.00' ,`Status` = 'Active' ,`StreetName` = 'Rapido' ,`StreetNumber` = '5206' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Renovated 3 bed 1 bath. Located near the Medical Center, NRG, shopping, and restaurants. Schedule your showing today!' ,`Acres` = '0.1371' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 14 SOUTH PARK SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5974' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'South Park Sec 02' ,`TaxAmount` = '2018' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707940' WHERE `Matrix_Unique_ID` = '206894327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T18:32:15.713' ,`MLSNumber` = '78784720' ,`ListAgentFullName` = 'Shelly Kane' ,`ListOfficeName` = 'Martindale Real Estate' ,`SellingAgentFullName` = 'Adam Olsen' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.643554' ,`Longitude` = '-94.173714' ,`PhotoCount` = '26' ,`PostalCode` = '77660' ,`RoomCount` = '5' ,`ListPrice` = '184500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'FM 92' ,`StreetNumber` = '15775' ,`StreetSuffix` = 'Road' ,`City` = 'Spurger' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living is what it is about! This 3 bedroom 2 bath home is situated on 3.05+/- acres with FM 92 road frontage. The home features granite countertops, stainless steel appliances, lots of cabinet space in the kitchen and wood burning fireplace. The property is fenced and partially cleared with a large yard for your animals with the rest of the property being wooded. Call today to schedule a showing of this property.' ,`Acres` = '3.05' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0968 V. WIESS ACRES 1.3100' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '57064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '946 - Spurger' ,`SchoolElementary` = 'SPURGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPURGER HIGH SCHOOL' ,`SchoolMiddle` = 'SPURGER HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Other' ,`TaxAmount` = '1385' ,`TaxRate` = '2.1299' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707940' WHERE `Matrix_Unique_ID` = '207260329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:09:15.273' ,`MLSNumber` = '12591577' ,`ListAgentFullName` = 'Jose Barbosa' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775735' ,`Longitude` = '-95.350358' ,`PhotoCount` = '8' ,`PostalCode` = '77026' ,`RoomCount` = '2' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Elysian' ,`StreetNumber` = '1608' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1190' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! GREAT LOCATION, CLOSE TO NEW DEVELOPMENT AND CLOSE TO DOWNTOWN, A MUST SEE WILL NOT LAST LONG' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 83 NOBLE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Noble' ,`TaxAmount` = '3570' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707940' WHERE `Matrix_Unique_ID` = '207303947' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T18:56:47.980' ,`MLSNumber` = '84086064' ,`ListAgentFullName` = 'Patches Deshazo' ,`ListOfficeName` = '316 Realty Group' ,`SellingAgentFullName` = 'Jeremy Hoffman' ,`SellingOfficeName` = 'Peak Realty and Associates LLC' ,`Latitude` = '29.458711' ,`Longitude` = '-94.625833' ,`PhotoCount` = '21' ,`PostalCode` = '77650' ,`RoomCount` = '4' ,`ListPrice` = '359900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pond' ,`StreetNumber` = '2119' ,`StreetSuffix` = 'Street' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '1' ,`SqFtTotal` = '900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This absolutely adorable, custom built, beach bungalow comes furnished and is just waiting for you to make it yours! This fantastic beach house is located in the heart of Crystal Beach (very near The Big Store and just down the street from Dannay\'s Donuts!) is an open-concept kitchen/dining/living space with many updates including a GE Cafe gas range with a convection oven, under cabinet touch lighting, dimmer-switch lighting, and a 2-car garage with 1 side that will accommodate a boat or RV with a 30amp hookup. The hot water heater is 55 gal and was installed in 2021. The a/c was replaced in 2016. Refrigerator, washer, and dryer convey with this home. This beauty is located on a corner lot and a half on a cul-de-sac road. It is a short walk to the beach so come on down, relax on the beach, and put your toes in the sand!' ,`Acres` = '0.1682' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 46 & S 1/2 OF 45 (46-1) ALBERDIE AD' ,`LotDesciption` = 'Corner,Cul-De-Sac,Water View' ,`LotSize` = '7328' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Alberdie Add 1' ,`TaxAmount` = '3876' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707940' WHERE `Matrix_Unique_ID` = '208438920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:21:23.160' ,`MLSNumber` = '41430018' ,`ListAgentFullName` = 'Carlo Mercado' ,`ListOfficeName` = 'Nest Finders' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711255' ,`Longitude` = '-95.620902' ,`PhotoCount` = '32' ,`PostalCode` = '77083' ,`RoomCount` = '5' ,`ListPrice` = '284900.00' ,`Status` = 'Active' ,`StreetName` = 'Dripping Springs' ,`StreetNumber` = '13410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeously renovated 1.5 story home nestled in the family friendly community Pheasant Run! This gem features updates such as a new roof, recent HVAC, fresh interior paint throughout, new luxury vinyl flooring, new carpet, new baseboards, new granite countertops in kitchen and baths, new light fixtures, ceiling fans and new hardware! Galley kitchen boasts new stainless steel appliances, new stainless steel single bin sink, new faucet, new herringbone subway tiled backsplash with new black hardware on cabinets! Owners retreat is spacious with a new primary bath with barn door, new framed mirror, dual vanity with vessel sinks, new stand up shower with glass sliders and beautiful tile work, new toilets throughout! Close proximity to shopping and eateries and Highway 6, Westpark Toll and Beltway 8! This home is a must see that won\'t last long!!' ,`Acres` = '0.1148' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 2 PHEASANT RUN SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MAHANAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Pheasant Run Sec 02 R/P' ,`TaxAmount` = '4179' ,`TaxRate` = '2.397' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707940' WHERE `Matrix_Unique_ID` = '208730895' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:29:02.403' ,`MLSNumber` = '21686385' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947744' ,`Longitude` = '-95.782524' ,`PhotoCount` = '33' ,`PostalCode` = '77433' ,`RoomCount` = '13' ,`ListPrice` = '935603.00' ,`Status` = 'Active' ,`StreetName` = 'Heartleaf Aster' ,`StreetNumber` = '11118' ,`StreetSuffix` = 'Way' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4305' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The magnificent MONTEREY plan for sale by Newmark Homes in Bridgeland. This top shelf 70\' floor plan offers everything the most discerning home buyers are looking for! 5 beds (2 down), 5.5 baths, living, formal dining, mud room, game room, media room, and a FOUR car garage. This is the one you\'ve heard about, modern, sleek, and elegant. Come see this home before it sells... because it will soon!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '28/01/06' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11208' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1196' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.637885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707940' WHERE `Matrix_Unique_ID` = '208776304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T18:34:29.530' ,`MLSNumber` = '28536185' ,`ListAgentFullName` = 'Nancy Wong' ,`ListOfficeName` = 'ABC Realty Advisor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874977' ,`Longitude` = '-95.680592' ,`PhotoCount` = '27' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenpatti' ,`StreetNumber` = '17807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home with 4 bedroom 2 bath rental home with vaulted ceilings and open floor plan. Backyard is spacious with covered deck so you can enjoy the outdoors with some shade. Easy access to I-10, 290, and Grand Parkway. Zoned to Cypress-Fairbanks ISD Currently tenant occupied, serious inquiries only. Priced below market value.' ,`Acres` = '0.1515' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 12 NORTHGLEN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '242' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'METCALF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Northglen Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707940' WHERE `Matrix_Unique_ID` = '208863462' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:44:29.003' ,`MLSNumber` = '67841401' ,`ListAgentFullName` = 'Fabiola Oropeza' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774793' ,`Longitude` = '-95.358068' ,`PhotoCount` = '31' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Chestnut' ,`StreetNumber` = '1612' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming Updated 3 bedroom 2 bath home. New flooring throughout, recent paint, kitchen with granite counter tops, tile back splash and a Stunning accent wall. Updated bathrooms with seamless showers and new fixtures. Cozy front Patio. Minutes from downtown. Schedule your tour today!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 18 ALLEN A C' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,English' ,`Subdivision` = 'Allen Add' ,`TaxAmount` = '7642' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1910' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707941' WHERE `Matrix_Unique_ID` = '209892085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:25:54.177' ,`MLSNumber` = '91122293' ,`ListAgentFullName` = 'Rhonda Woodard' ,`ListOfficeName` = 'Woodard Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526097' ,`Longitude` = '-95.408150' ,`PhotoCount` = '50' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Birch Knoll' ,`StreetNumber` = '4718' ,`StreetSuffix` = 'Trail' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2868' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You don\'t want to miss this beautiful home located at 4718 Birch Knoll Trail. Situated in the highly sought after community of Pomona, this stunning one story home has four bedrooms, each with it\'s own private bath. It also features a three car tandem garage with epoxy coating. This Coventry Home favorite has an open concept floor plan and is great for entertaining. Some of the features include stainless appliances, double ovens, wine cooler, walk in pantry, and lots of cabinet storage. A study sits off the living room behind elegant French doors. The floors have been upgraded to herringbone designed tile throughout, except in the bedrooms, which have been upgraded to wood. The game room leads to the large covered patio. This home is just minutes from shopping, dining, and entertainment. It offers a convenient commute to downtown Houston and the medical center area. Do not let this one slip away. Call to schedule your private tour today.' ,`Acres` = '0.1865' ,`Area` = '5' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 8 (A0298 HT&BRR & A0563 HT&BRR) BLK 1 LOT 28' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '14579' ,`TaxRate` = '3.6594' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707941' WHERE `Matrix_Unique_ID` = '209910545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T18:38:49.780' ,`MLSNumber` = '18398498' ,`ListAgentFullName` = 'Diana Wilson' ,`ListOfficeName` = 'BHGRE Gary GreeneLeague City' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295308' ,`Longitude` = '-94.913046' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '10' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'Bora Bora' ,`StreetNumber` = '215' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2341' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely renovated modern home in the architectural style of Mies van der Rohe. Stunning steel, concrete & glass home, 3 bedrooms, 3 baths, top-to-bottom renovations. Floor-to-ceiling windows wrap around the entire house providing a contemporary indoor/outdoor feel to the home. The elevated, expansive views from every room on the main level are stunning. Yet, automatic storm shutters seal off the glass for privacy and security whenever desired at the touch of a switch. All new bathrooms and kitchen are functional and beautiful and provide top of the line finishes. Renovations in 2021 include all new paint (inside and out), carpet, electrical/lighting, plumbing, tile work, quartz countertops and new appliances. This is a perfect house for entertaining - open concept, large upper deck and wrap around veranda, shaded area dockside with double boat house, outdoor kitchen and bar and inviting heated plunge pool/spa. This is an iconic property and is truly one of a kind on Tiki Island.' ,`Acres` = '0.138' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S BUNDICK SUR LOT 13 (12-1) TIKI ISLAND' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6011' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '14516' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707941' WHERE `Matrix_Unique_ID` = '210015283' --> 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','210347547','1663707941','210347547','2022-09-07T18:15:58.743','66412092','Bianca Lippert','Red Door Realty & Associates','','','30.110997','-95.558983','38','77375','9','435000.00','Active','Torrens','9003','Court','Tomball','2','2','4','2927','Single-Family','BEAUTIFUL two-story home featuring 4 Bedrooms, 2 Full Bathrooms & 2 Half Bathrooms and located on a Spacious Cul-De-Sac lot with a Backyard Oasis. The front half of the first floor showcases Updated Wood Look Porcelain Tile including the Primary Bedroom. The Primary Bedroom has a Remodeled Ensuite Shower with Separate Tub and Two Large Walk-In Closets. The Formal Living Room has a cozy Gas Burning Fireplace to enjoy the HUGE Projector Screen with Surround Sound. The French Doors to the Dining Room display the Gorgeous Crown Molding and Built ins. The Open Kitchen has a Walk in Pantry and boasts Granite Countertops, Double Ovens, Gas Range and Stainless Steel appliances. The Den at the back of the home features a Dry Bar with Wine Fridge and Extensive Built-ins. Upstairs you will find 3 Secondary Bedrooms with nice size closets, a Shared Bathroom and an Ensuite Half Bath. Outside enjoy the Sparkling Pool and Shaded Greenspace to entertain. New Roof (2022) and PEX piping (2021).','0.3214','14','','','Electric Dryer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein/Tomball','Central Gas','1','LT 23 BLK 4 017*W3470500-001-004-023 WIMBLEDON COUNTRY SEC 1','Cul-De-Sac,Subdivision Lot','14000','Appraisal District','','650','0','','2','Double Oven','1','In Ground','','Gas Cooktop','','Composition','32 - Klein','METZLER ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','HOFIUS INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Wimbledon Country','8633','2.834','Public Water','1981','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:11:32.350' ,`MLSNumber` = '68625231' ,`ListAgentFullName` = 'Korenna Higgins' ,`ListOfficeName` = 'Charger Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.557503' ,`Longitude` = '-95.105511' ,`PhotoCount` = '30' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'W Sierra Rd' ,`StreetNumber` = '300' ,`StreetSuffix` = '' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home, this 2020 Palm Harbor home is ready for your family! Located in Coldspring this lot backs up to the forest with walking trails all throughout. Ready to move in with all appliances, two sheds, and a hot tub this is the perfect place to call home! Two separate sheds make for a perfect \"man cave\" and \"she shed\", one having a built in workbench and shelves, the other with A/C and heat for all your \"she shed\" needs! All appliances stay with the home, even an extra fridge and deep freezer!' ,`Acres` = '1.9346' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Ponderosa Estates, Block 4, Lot 18-19' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ponderosa Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663707941' WHERE `Matrix_Unique_ID` = '211021752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T18:02:46.177' ,`MLSNumber` = '67532189' ,`ListAgentFullName` = 'Tonya Hutton' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Kayla Collazo' ,`SellingOfficeName` = 'Century Properties Real Estate' ,`Latitude` = '29.839208' ,`Longitude` = '-94.862982' ,`PhotoCount` = '32' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '380000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Krystine' ,`StreetNumber` = '10306' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1845' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, home in the back of Crown Colony subdivision. NO HOA! It\'s on a large .63 acres with a side driveway and plenty of room for a pool or a shop. Seller plans to leave both lawn mowers and the spreader. The kitchen is huge & has been updated with granite countertops and a new backsplash. The cabinets now have new custom pull out drawers. The primary bathroom has been updated nicely and boasts of new custom cabinetry, dual mirrors and porcelain sinks. The carpet in the living room was replaced with a high grade material and includes a top of the line stain guard. High traffic areas have vinyl plank. Home has 3 bedrooms & 2 baths. It also has an office that can easily be used a bedroom as it has a good size closet and doors that close. The solar screens on the windows help lower electricity cost and custom fit plywood and hurricane clips make preparation for a hurricane easier. Garage is also oversized. Access to city services! Great opportunity! What are you waiting for?' ,`Acres` = '0.631' ,`Area` = '53' ,`BuilderName` = 'TX Home Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 7 CROWN COLONY SEC 3 PHASE 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '27486' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crown Colony Sec 03 Ph 01' ,`TaxAmount` = '4554' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707941' WHERE `Matrix_Unique_ID` = '211263107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T19:04:34.150' ,`MLSNumber` = '29749197' ,`ListAgentFullName` = 'Jared English' ,`ListOfficeName` = 'Congress Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298268' ,`Longitude` = '-94.916265' ,`PhotoCount` = '25' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '1999995.00' ,`Status` = 'Active' ,`StreetName` = 'Coral' ,`StreetNumber` = '1330' ,`StreetSuffix` = 'Way' ,`City` = 'Tiki Island' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4362' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique waterfront, contemporary property sits on 3 landscaped lots with 4-6 bedrooms, 4 full baths, 2-half baths, GUEST HOUSE, swimming pool, 2 cabana rooms with bathrooms, elevator, boat lift, large dock, multiple balconies with numerous waterfront views from the balcony of your choice. Luxury master suite with owner’s private balcony and contemporary bathroom and closets galore. 3 garages, 2 car carport, 2 driveways, private courtyard with fishpond, full RV hookups, 2 front lawns, and MULTIPLE bonus rooms for your own in-home gym or office(s). New roof on both structures in 2019. Underwater green light ready for fishing.' ,`Acres` = '0.407' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOTS 48 THRU 50 (49-0) TIKI ISLAND SE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '17729' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Tiki Island 6' ,`TaxAmount` = '13201' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707941' WHERE `Matrix_Unique_ID` = '211601541' --> 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','211980395','1663707941','211980395','2022-09-07T19:46:03.163','21209770','Jay Thieme','RE/MAX Cinco Ranch','','','29.685837','-95.760846','22','77407','7','315000.00','Active','Castle Hawk','21907','Trail','Richmond','2','0','3','1735','Single-Family','Crisp and Clean and SO PRISTINE! Very well maintained one story home with EASY ACCESS to the Westpark Tollway AND the GRAND PARKWAY. 3 bedrooms and 2 full baths. Tile flooring in the entry, kitchen & dining area. The ISLAND Kitchen includes GRANITE COUNTERTOPS, gas cooktop & recent microwave. Open floor plan. Primary bathroom with dual sinks, separate shower & tub. DOUBLE PANE WINDOWS & TECHSHIELD. Wood trimmed windows. WASHER, DRYER & KITCHEN REFRIGERATOR ARE INCLUDED! PEX plumbing manifold. Covered back patio. Full gutters. SPRINKLER SYSTEM. Private backyard...NO BACK NEIGHBORS! Never flooded. No disappointments!','0.14','37','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Fort Bend County North/Richmond','Central Gas','1','GRAND MEADOW SEC 3, BLOCK 2, LOT 11','Subdivision Lot','6234','Appraisal District','','440','0','','2','Single Oven','0','','','Electric Cooktop','','Composition','33 - Lamar Consolidated','HUBENAK ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal','1','Ranch','Grand Meadow','5250','2.76','Water District','2012','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','212019017','1663707941','212019017','2022-09-07T18:44:28.703','64338042','Hernan Garcia','Turn Key Realty','','','29.718159','-95.753005','45','77450','10','519500.00','Active','Auburn Trace','20915','Court','Katy','2','1','5','3085','Single-Family','Stunning Home with a pool, Fresh paint Throughout the House, This 5/2.5 with 2.5 garage, second garage door in back, Features an automatic gate, front and back sprinklers & extensive landscaping! Private study, formal dinning room, gorgeous family room & chef\'s dream kitchen with island, granite counter tops, Spacious master & secondary bedrooms, upstairs game room with window seat & gleaming hardwood flooring in most of the house, Enjoy the outdoors in your private tropical paradise with family and friends, Pool plaster, pool deck and wood deck were done less than a year ago, Refrigerator, washer and dryer stay with the house, Never flooded per owner.','0.1688','36','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','2','Katy - Southeast','Central Gas','1','CINCO RANCH MEADOW PLACE SEC 5, BLOCK 1, LOT 13','Subdivision Lot','7351','Appraisal District','','1115','0','','2','Freestanding Oven,Gas Oven','1','In Ground','','Freestanding Range,Gas Range','','Composition','30 - Katy','CREECH ELEMENTARY SCHOOL','CINCO RANCH HIGH SCHOOL','BECK JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Cinco Ranch Meadow Place Sec 5','','','Public Sewer,Water District','1998','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','212179699','1663707942','212179699','2022-09-07T19:28:43.747','3121922','Andy Onder Yaltir','VITA Realty','','','29.697558','-95.436753','14','77025','9','1899000.00','Active','Aberdeen','3747','Way','Houston','4','1','4','4489','Single-Family','Another proposed new construction home from Uniform Construction / Vita Homes in Braes Heights, plans are submitted to the city. Plans include 3 car garage, 4 bedroom with 4 and half bath, primary bedroom upstairs, guest room downstairs, game room upstairs, elevator shaft, covered patio, dining room with wine room. Estimated completion is summer 2023.Buyer can select the finishes with the designer.','0.1859','17','Uniform Construction','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Freestanding,Gas Connections','1','Braeswood Place','Central Gas','0','LT 2 BLK 24 BRAES HEIGHTS SEC 6','Cleared','8098','Survey','','','1','To Be Built/Under Construction','3','Double Oven','0','','','Gas Range','','Composition','27 - Houston','TWAIN ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','No Appointment Required','Builder','2','Traditional','Braes Heights Sec 06','12516','2.3307','Public Sewer,Public Water','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','212179899','1663707942','212179899','2022-09-07T18:21:43.873','42137577','Samantha Savage','eXp Realty, LLC','','','29.880446','-94.224625','12','77705','8','265000.00','Active','Patterson','7271','Road','Beaumont','2','0','3','1791','Single-Family','Enjoy the serenity of Fannett in this beautiful 3 bed 2 bath home. Built in 2010, this 4 side brick house is nestled on over 0.58 acres. Don’t like dealing with an HOA? No problem! Here on Patterson Road, the neighbors all work together to maintain the beauty and peacefulness that Fannett has to offer. Recessed ceilings in the primary bedroom and living room bring more than a touch of elegance to this home. Primary bathroom hosts a private water closet as well as two separate walk in closets. Snuggle up this winter season by the wood burning fireplace in the oversized Living / Family room or step outside to relish in having no back neighbors and a covered porch overlooking a natural habitat of trees and greenery. If you’re looking to get away from all the noise that city life brings, look no further! This home comes practically move in ready with new appliances including refrigerator, dishwasher, washer and dryer!','0.5861','51','','','Electric Dryer Connections','','Mud,Sellers Disclosure,Tenant Occupied','1','Wood Burning Fireplace','1','','Central Electric','0','LONE STAR LANDING LOT 4 .590','Cleared','25531','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','110 - Hamshire-Fannett','HAMSHIRE-FANNETT ELEMENTARY SCHOOL','HAMSHIRE-FANNETT HIGH SCHOOL','HAMSHIRE-FANNETT MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Contemporary/Modern','Lone Star Landing','4289','2.0652','Water District','2010','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','212195759','1663707942','212195759','2022-09-07T19:09:44.337','84768683','Eneyda Diaz','JLA Realty','','','29.885520','-95.506531','36','77040','5','220000.00','Active','Woodsman','7719','Trail','Houston','2','0','3','1243','Single-Family','Don\'t miss this opportunity to own this spacious, yet cozy 3 bedroom 2 bath home! The huge backyard is breathtaking and you will enjoy the perfect setting for relaxing and entertaining. NO FLOODING! This beauty is a true gem and won\'t last long!','0.1747','11','','','','','Sellers Disclosure','1','','','Northwest Houston','Central Electric','1','LT 66 BLK 21 WOODLAND TRAILS NORTH SEC 8','Subdivision Lot','7610','Appraisal District','','150','0','','2','Convection Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','JERSEY VILLAGE HIGH SCHOOL','DEAN MIDDLE SCHOOL','Accompany,Supra Keybox','Appraisal District','1','Traditional','Woodland Trails North Sec 08','3586','2.5119','Public Sewer,Public Water','1975','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','212276127','1663707942','212276127','2022-09-07T18:53:43.183','50191560','Ngan Winston','5th Stream Realty','','','29.543697','-95.516029','38','77459','9','295000.00','Active','Darnell','3615','Court','Missouri City','2','1','4','2512','Single-Family','Welcome to this gorgeous 4bdr 2.5 home in Missouri City. The exterior of the home showcases a massive backyard area, two car garage, long driveway and beautiful landscaping. The spacious and open family room boasts a charming fireplace, huge windows and views of the kitchen and backyard. This home also has a large covered porch for cooking out and staying out of the heat. Stairs lead to a spacious primary suite with three additional bedrooms. Master bath has double vanity sinks, a separate shower and tub to relax after a long day. Large utility room located inside the home. Terrifically located on Cul-de-sac near a well maintained neighborhood park. Zoned to highly desirable schools in Fort Bend ISD. This home is conveniently located near highway 6 and the Fort Bend Tollway with easy access to Downtown and the Medical Center. Sugar Land Town Center is nearby with a large variety of dining and shopping options. Be sure to schedule your showing and make this you next home today!!','0.1515','38','','','','','Sellers Disclosure','1','','2','Missouri City Area','Central Electric','1','VICKSBURG VILLAGE OF CUMBERLAND, BLOCK 5, LOT 63','Subdivision Lot','6600','Appraisal District','','550','0','','2','','0','','','','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Vicksburg Village Of Cumberland','6497','3.18','Public Water','1985','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','212278254','1663707942','212278254','2022-09-07T19:47:27.217','86601164','Ava Gutowski','Key 2 Texas Realty','','','28.755466','-96.148240','8','77465','3','600000.00','Active','County Road 364','2301','','Palacios','2','0','3','2656','Single-Family','Farm and Ranch on 3.29 Acres Private Country Living! Workshop and 3/2','3.295','54','','','','','Sellers Disclosure','','','','','Central Electric','0','AB 0158, A FARQUHAR, TRACT 44 (PT), ACRES 3.295, 3.295 AC (3','Cleared','143530','Appraisal District','','','0','','2','','0','','','','','Composition','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Ferris & Simpsons Sub Tr 4','4056','1.9236','Septic Tank,Well','1977','Appraisal District'); --> New record created successfully