Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T08:41:33.410' ,`MLSNumber` = '15152299' ,`ListAgentFullName` = 'Tammy Locke' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.845401' ,`Longitude` = '-95.978702' ,`PhotoCount` = '32' ,`PostalCode` = '77831' ,`RoomCount` = '6' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Stone' ,`StreetNumber` = '1465' ,`StreetSuffix` = 'Street' ,`City` = 'Bedias' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T MISS THIS PIECE OF HEAVEN! Ranch home offers a 1200 sq ft covered porch. Three bedrooms and one oversized bathroom. Property acreage is 17.619 acres. The open floorplan offers a great entertainment space. If you love to cook, Your dream kitchen is in this home. Custom Oak cabinets, 32 drawers, wine rack and granite counter tops. Outside there is a 32x24 ft attached carport, a shed with 220 amp power, 2 story barn, greenhouse, pole barn and chicken coop. Three and half acres of the property is fenced around the house. To the right of the property is another shed with a rv hook up and second septic. This property has community water. Bring your dreams and farm animals. This property is a dream come true if your looking for a quite place to call home.' ,`Acres` = '17.619' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bedias/Roans Prairie Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SHANNON PLACE ESTATES, BLOCK 8, LOT 80-82, ACRES 17.619' ,`LotDesciption` = 'Cleared' ,`LotSize` = '767483' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Shannon Place Estates' ,`TaxAmount` = '1737' ,`TaxRate` = '1.7056' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216104' WHERE `Matrix_Unique_ID` = '206552160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T07:39:14.337' ,`MLSNumber` = '83999153' ,`ListAgentFullName` = 'Alexandra Berry' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560674' ,`Longitude` = '-95.718084' ,`PhotoCount` = '28' ,`PostalCode` = '77469' ,`RoomCount` = '8' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Field' ,`StreetNumber` = '1911' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately two story home with two-story entry that will draw you into the fantastic open layout. The large kitchen in a cooks dream with abundant cabinets and a center island. Room to roam with five bedrooms. The private primary suite is located downstairs. The additional four bedrooms are upstairs along with a bonus room and study nook. Neutral colors allow you to make this home your own. Spend time outdoors in this spacious and welcoming backyard, and don\'t forget to check out the oversized garage. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.2057' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK WEST SEC 1, BLOCK 1, LOT 8' ,`LotDesciption` = 'Other' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverpark West Sec 1' ,`TaxAmount` = '7527' ,`TaxRate` = '2.8748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216104' WHERE `Matrix_Unique_ID` = '208979021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T08:54:22.127' ,`MLSNumber` = '34632089' ,`ListAgentFullName` = 'Alex Lyon' ,`ListOfficeName` = 'Full Circle Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.550163' ,`Longitude` = '-95.034614' ,`PhotoCount` = '50' ,`PostalCode` = '77565' ,`RoomCount` = '7' ,`ListPrice` = '1495000.00' ,`Status` = 'Active' ,`StreetName` = 'Shore' ,`StreetNumber` = '1203' ,`StreetSuffix` = 'Drive' ,`City` = 'Clear Lake Shores' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive waterfront retreat offering spectacular views of Clear Lake from every angle! Enjoy fishing & swimming from the 100 ft. dock. Cruising to local entertainment or a day on the lake is convenient with your personal boatlift steps away. 3 stories of covered patios for outdoor entertaining & watching unforgettable sunsets. Inside provides an open concept great room with gourmet kitchen & dining area all with views that will captivate your attention. The generously sized primary suite on the main level won\'t disappoint. Huge space on the ground level with full kitchen & bathroom perfect for guest quarters, multigenerational living, studious office or another entertaining room. The views continue up in a massive media/game room & 2 additional bedrooms. CLS offers golf cart friendly streets, scenic parks, community pool, pavilion & boat launch. Minutes from marinas, shopping & restaurants. CCISD, low taxes & no HOA! Be sure to read more on the Property Features List in attachments.' ,`Acres` = '0.1571' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOTS 2232 THRU 2235 & PT OF LOTS 2230,' ,`LotDesciption` = 'Corner,Subdivision Lot,Waterfront' ,`LotSize` = '6842' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Craftsman' ,`Subdivision` = 'Clear Lake Shores' ,`TaxAmount` = '15485' ,`TaxRate` = '1.8341' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675216104' WHERE `Matrix_Unique_ID` = '210303976' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T07:47:51.057' ,`MLSNumber` = '69649691' ,`ListAgentFullName` = 'Darian Candler' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505968' ,`Longitude` = '-95.509007' ,`PhotoCount` = '28' ,`PostalCode` = '77459' ,`RoomCount` = '5' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Dell' ,`StreetNumber` = '4042' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home with fantastic functional layout. Spacious cooks\' kitchen with abundant storage and center island overlooking the living room. Neutral colors and wood look floors will allow you to make this home your own. Book a tour with your real estate agent today and feel right at home!' ,`Acres` = '0.1527' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA STEEP BANK VILLAGE SEC 9, BLOCK 1, LOT 21' ,`LotDesciption` = 'Other' ,`LotSize` = '6651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Steep Bank Village Sec 9' ,`TaxAmount` = '6047' ,`TaxRate` = '2.5729' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216104' WHERE `Matrix_Unique_ID` = '210393222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T07:51:34.473' ,`MLSNumber` = '9269579' ,`ListAgentFullName` = 'Alexandra Berry' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507598' ,`Longitude` = '-95.081509' ,`PhotoCount` = '28' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Courtland' ,`StreetNumber` = '803' ,`StreetSuffix` = 'View' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exciting 3 bedroom, 2 ½ bath, two car garage, brick and hardy exterior home! Vaulted ceilings in the family room two-story entry. Primary bedroom and bath on the main level as is the laundry. Two additional bedrooms and bathroom upstairs. Fireplace in the family room. Laminate flooring first floor, carpeting on stairs, laminate flooring second floor. Covered back porch with ceiling fan and shed in backyard.' ,`Acres` = '0.1741' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAKCREST MANOR SEC 1 (98), BLOCK 1, LOT 2, ACRES .174' ,`LotDesciption` = 'Other' ,`LotSize` = '7582' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakcrest Manor Sec 1 98' ,`TaxAmount` = '4992' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216105' WHERE `Matrix_Unique_ID` = '213925586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T07:21:15.193' ,`MLSNumber` = '42996427' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.199086' ,`Longitude` = '-96.021480' ,`PhotoCount` = '25' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '304480.00' ,`Status` = 'Active' ,`StreetName` = 'Pin Oak' ,`StreetNumber` = '26595' ,`StreetSuffix` = 'Drive' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1772' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW, one story, 3 bedroom, 2 bath, 1772 square foot home on A QUARTER ACRE LOT! This home features an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. Large windows for abundant natural light throughout. 3 car garage! Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living.' ,`Acres` = '0.24' ,`Area` = '26' ,`BuilderName` = 'Freedom Star' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S455200 DEERWOOD LAKES 2 LOT 225' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Deerwood Lakes 2' ,`TaxAmount` = '307' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675216105' WHERE `Matrix_Unique_ID` = '214073878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T08:04:34.000' ,`MLSNumber` = '95418598' ,`ListAgentFullName` = 'Patricia McCulley' ,`ListOfficeName` = 'Country World Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.804378' ,`Longitude` = '-95.118239' ,`PhotoCount` = '21' ,`PostalCode` = '77360' ,`RoomCount` = '6' ,`ListPrice` = '189000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '199' ,`StreetSuffix` = 'Avenue' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2017 Manufactured home offers three bedrooms and two baths, along with spacious utility room and pantry.\r\nThis home offers a split floor plan, kitchen with breakfast bar and dining area.\r\nSituated on 1.947 acres with pond, pole barn, storage building and shed.\r\n\r\nLocated in City of Onalaska just minutes from Lake Livingston.' ,`Acres` = '1.9469' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Onalaska OT BLK 26 LOT #1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '84810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'NA' ,`TaxAmount` = '2615' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216105' WHERE `Matrix_Unique_ID` = '214081472' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T08:47:42.870' ,`MLSNumber` = '82967901' ,`ListAgentFullName` = 'Zbigniew Korfel' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.883570' ,`Longitude` = '-95.445331' ,`PhotoCount` = '36' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '322000.00' ,`Status` = 'Active' ,`StreetName` = 'wavell' ,`StreetNumber` = '2213' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL open floor designed 3 Bedrooms NEW HOME. Large CUSTOM built solid wood KITCHEN CABINETS with GRANITE counter tops, Exquisite Mosaic tile BACKSPLASH. Spacious ISLAND open to the Dinning and Family room creating a LARGE LIVING SPACE. Nice comfortable size MASTER BEDROOM open to an elegant doble sink VANITY, next to a FRAMELESS GLASS DOOR walking shower all cover with exquisite tile. High QUALITY tile on the first floor and Vinyl on the entire second floor. BRICK ALL AROUND the house on the first floor, TANKLESS WATER HEATER, Complete FENCED with a Metal gate for extra PRIVACY. High quality construction with attention to details, makes this house a great place to call HOME. Very quiet NEIGHBORHOOD CLOSE to DOWNTOWN Houston, Intercontinental Airport, Shopping and Entertainment . Property located OUTSIDE FLOOD ZONE. No HOA' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'Cuellar Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot1, Block 1, Wavell Homes Subdivision' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3550' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Wavell Homes Subdivision' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216105' WHERE `Matrix_Unique_ID` = '214241645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T08:36:57.250' ,`MLSNumber` = '94389813' ,`ListAgentFullName` = 'Heather Lange' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.285154' ,`Longitude` = '-94.176515' ,`PhotoCount` = '30' ,`PostalCode` = '77656' ,`RoomCount` = '8' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Massey Lake' ,`StreetNumber` = '8726' ,`StreetSuffix` = 'Road' ,`City` = 'Silsbee' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1715' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home in Silsbee sitting on 1.87 acres. Open-concept den/kitchen/dining. Luxury vinyl plank flooring and crown molding throughout. Kitchen with breakfast bar, granite countertops & breakfast combo. Primary bedroom with en-suite bath. Additional boat storage and green house.' ,`Acres` = '1.87' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 39 D C Montgomery P# 39-24-k, I# 2019-93995, 4/11/2019' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '252 - Silsbee' ,`SchoolElementary` = 'SILSBEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SILSBEE HIGH SCHOOL' ,`SchoolMiddle` = 'EDWARDS-JOHNSON MEMORIAL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = '0' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216106' WHERE `Matrix_Unique_ID` = '214282927' --> 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','214821480','1675216106','214821480','2023-01-19T08:32:50.140','38429921','Claudia Navarro','HomeSmart','','','29.861910','-95.299644','7','77016','3','160000.00','Active','Kelburn','10321','Drive','Houston','1','0','3','1254','Single-Family','Property has fire damage and is being sold AS IS-Property needs remodeling and is ready for a new owner- Nice 3 bedroom, 1 bath with a large lot. Conveniently located near schools, 59 North and Intercontinental Airport. \r\nThe property is also minutes away from the Scenic Woods Regional Library and Houston Community College. \r\nThis is a rehab project that has been priced to sell.\r\n\r\nSeller will not consider contracts with assumptions or letters of intent.','0.1652','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Seller may be subject to foreign tax and Buyer withholding per IRS','0','','','Northeast Houston','Central Gas','0','LT 6 BLK 42 SCENIC WOODS','Subdivision Lot','7198','Appraisal District','','','0','','1','','0','','','','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','No Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Scenic Woods','2419','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','215448912','1675216106','215448912','2023-01-19T08:16:57.787','36317193','Michelle Munoz','JLA Realty','','','29.928372','-93.917553','17','77619','3','179900.00','Active','Royal','2727','Avenue','Groves','2','0','3','1400','Single-Family','Welcome Home! This Beautiful Updated home has 3 Bedrooms and 2 full bath. Some of the updates done on this gorgeous home include a New Roof, kitchen with quartz countertops, new microwave, new stove, new laminate flooring, new paint, new cabinets, new windows, new doors and much more!! When entering this home you will appreciate the open concept and natural lighting coming into the living room from the double doors that lead to the backyard. This stunning home also has a second drive way that leads to the backyard for extra parking perfect for any large gathering!','0.3214','51','','','','','Sellers Disclosure','','','','','Central Gas','0','FAIRHAVEN LOT 16 & LT 17 BLK 3','Other','14000','Appraisal District','','','0','','1','','0','','','','','Other','236 - Port Arthur','ADAMS ELEMENTARY SCHOOL (PORT ARTHUR)','MEMORIAL HIGH SCHOOL (PORT ARTHUR)','JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)','Lockbox Back','Appraisal District','1','Traditional','Fairhaven','2793','3.1203','Public Water','1962','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','215452122','1675216106','215452122','2023-01-19T08:51:30.983','67137266','Esmeralda Cortes','Fathom Realty','','','28.975496','-95.262788','19','77541','5','355000.00','Active','Bay','326','Avenue','Surfside Beach','1','0','2','713','Single-Family','PROPERTY COMES WITH THREE ADDITIONAL LOTS! Great beach home located in the Village of Surfside; just a short walk to the beach and amazing views of the water from the huge wrap around deck making this house perfect for entertaining. The house also has a palapa and sand volleyball court. The inside of the home is open concept living and kitchen, two bedrooms and one full bathroom. Storage shed on property. Outdoor enclosed shower located downstairs. Home comes fully furnished. Perfect home for permanent residence, vacation home, or vacation rental. \r\n\r\nHouse located on lot 7. Lots 5, 6, and 8 will be conveyed with the house.','0.0932','5','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','0','','0','Surfside','Other Heating','0','BAYVIEW (A0009 B T ARCHER DIV 1 (B C I C)), LOT 7 SEC 1, SUR','Water View','4060','Appraisal District','','','0','','0','Electric Oven','0','','','Freestanding Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Other Style','Bayview','2455','2.333','Septic Tank','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','215478469','1675216106','215478469','2023-01-19T08:58:16.087','73063550','Shanea Massengale','RE/MAX ONE - Premier','','','29.867127','-94.845157','16','77523','0','1500000.00','Active','Fm 565','4319','Road','Mont Belvieu','1','1','0','3200','Single-Family','Welcome to 4319! A place where your vision can become a reality in Mont Belvieu, Tx. This ‘unique property’ is the only one of its kind. The spacious 2.9 acres with unrestricted access to make anything happen. Formerly a boutique & restaurant,there is so much to offer here. The 3,000 square foot building is large enough to house any business. The building features an open concept design, 1.5 bathrooms, & a full service kitchen. There is also a private space upstairs that can be used for an office or ample storage.The grounds of 4319 are breathtaking and pristinely wooded.The back has a mature, 100 year old oak tree that is the heart of this land surrounded by beautiful updated landscaping. A functional building w/electrical and water sits adjacent to the tree, along with a texas size barn. The property line is fully fenced & perfect to house any livestock you would want. \r\nOpen your own store,restaurant,small wedding venue,or anything you are dreaming of. Make 4319 your next adventure!','2.9','53','','','','','Sellers Disclosure','','','','Chambers County West','Propane','0','12 TR 277-1 H GRIFFITH','Other','','','','','0','','0','Electric Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL NORTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL NORTH MIDDLE SCHOOL','Appointment Required','Seller','1.5','Traditional','Henry Griffith League A-12','2122','1.656','Septic Tank,Well','1946','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','215538557','1675216106','215538557','2023-01-19T08:51:08.177','55485497','Ronnie Matthews','RE/MAX Legends','Vanessa Ruiz','Keller Williams Platinum','29.493326','-95.219515','25','77546','8','265000.00','Pending Continue to Show','Castle Harbour','638','Drive','Friendswood','2','0','3','1918','Single-Family','INCREDIBLE 1 STORY - MOVE-IN READY! Versatile Interior Design + Lots of Incredible Updates! Recent Luxury Vinyl Plank Flooring, A/C, Interior & Exterior Paint, Water Heater, PLUS MORE! Wonderful Kitchen: Abundant White Cabinetry, Updated Stainless Dishwasher & Smoothtop Range, & Double Ovens! Refrigerator Included! Light & Bright Breakfast Area! Supersized Family Room - Majestic Brick Hearth Fireplace + French Doors to Backyard! Incredible Master Suite with Built-In Shelving - Lovely Adjoining Bath with Dual Sinks! Spacious Secondary Bedrooms - One with Direct Access to Full Bath! Convenient Indoor Utilities! Tranquil Park-Like Backyard - Mature Landscaping & Soaring Trees - PLUS Nice Patio Area! Sought-After Detached Garage! Desirable Community with No MUD Tax & Low HOA Fees! Easy Access to I-45! FANTASTIC OPPORTUNITY - WON\'T LAST LONG!','0.2094','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Friendswood','Central Electric','1','ABST 184 PAGE 1 LOT 24 BLK 9 SUNMEADOW SEC 2','Subdivision Lot','9120','Appraisal District','','100','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','20 - Friendswood','CLINE ELEMENTARY SCHOOL','FRIENDSWOOD HIGH SCHOOL','FRIENDSWOOD JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Sunmeadow','4908','2.2025','Public Sewer,Public Water','1976','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215591119','1675216106','215591119','2023-01-19T08:35:08.320','35991905','Joe Rosa','RE/MAX Fine Properties','Rosemarie Torti','Coldwell Banker Realty','30.191200','-95.580491','49','77382','16','995000.00','Pending Continue to Show','Midday Sun','39','Place','Spring','3','1','4','4183','Single-Family','Impeccably maintained Tommy Bailey custom home w/4 BR\'s, 3.5 baths, formals, den, study, game room, amazing kitchen, gorgeous back yard w/pool, spa + 3 car garage w/epoxy flooring & workshop. This gorgeous home has elegant double door entry & travertine floors! Study w/built-ins, wood shutters & sculptured carpeting, spacious formal dining, butler pantry, den w/views of the pool & back yard. Stunning remodeled kitchen opens to den-great entertaining space. 2 gas log FP\'s, central vac & wood shutters throughout! Kitchen w/Thermador & Bosch appliances, breakfast bar, double ovens, 5 burner gas cooktop, custom cabinetry, large L-shaped pantry & bonus room off kitchen serves as a bar w/wine fridge & tons of storage. Spacious primary BR w/wide plank wood floors + huge bathroom! Upstairs: 3 LARGE BR\'s, 2 baths & game/media room. Stunning back yard w/resort style heated pool w/waterfall & spa. Lush landscaping, summer kitchen w/sink, fridge & gas grill + fire pit & bath access off of pool.','0.2657','15','Tommy Bailey','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','2','The Woodlands','Central Gas,Zoned','0','WDLNDS VIL STERLING RIDGE 16, BLOCK 1, LOT 25','Subdivision Lot','11575','Appraisal District','','','0','','3','Convection Oven,Double Oven,Electric Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','11 - Conroe','DERETCHIN ELEMENTARY SCHOOL','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Wdlnds Village Sterling Ridge 16','18200','2.1816','Water District','2004','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','215729724','1675216106','215729724','2023-01-19T07:50:49.673','59038703','Melissa Pompa','Vive Realty LLC','','','29.655052','-95.190000','49','77504','4','380000.00','Active','Cadena','3620','Drive','Pasadena','2','1','3','2162','Single-Family','Beautiful one-story, 3 bedroom, 2.5 bathroom home built in 2019! As soon as you walk in you will have your great size office room to the right that can be turned into a 4th bedroom! You will also have a spacious living room that is open to the kitchen area! The kitchen features white cabinets, stainless steel appliances, an island, & a gas cooktop. All bedrooms are spacious with walk-in closets! This house also has an extra closet in the hallway where all your shoes/handbags can be organized! Also has beautiful tile flooring throughout, no carpet! Recessed lighting throughout home! Huge backyard perfect for family gatherings! Brick all around! This home has it all!! Beautiful inside and out! Come check it out in person! You will fall in love!','0.2007','6','','','','','Sellers Disclosure','','','','Pasadena','Central Gas','0','LT 1 BLK 1 SOUTH HOUSTON GARDENS SEC 2 5TH PAR R/P','Subdivision Lot','8742','Appraisal District','','','0','','2','','0','','','','','Composition','41 - Pasadena','JENSEN ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PASADENA)','PARKVIEW INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','SOUTH HOUSTON GARDENS SEC 2 5TH','7159','2.6514','Public Sewer,Public Water'