Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T12:37:33.413' ,`MLSNumber` = '9835508' ,`ListAgentFullName` = 'Jay Andampour' ,`ListOfficeName` = 'IRA Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.995137' ,`Longitude` = '-95.107214' ,`PhotoCount` = '28' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '459950.00' ,`Status` = 'Active' ,`StreetName` = 'El Matador' ,`StreetNumber` = '22135' ,`StreetSuffix` = 'Street' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this gorgeous fully upgraded 5 bed and 2 ½ bath corner lot home on a 0.75-acre land, less than a 5-minute drive from Lake Houston. Includes 2 attached garages, a beautiful iron fence, two secure remote control gated driveway entries, as well as a large concrete driveway (sufficient for a boat). Home offers an open floor plan with new tiling throughout and laminated floors in bedrooms. The kitchen, bathrooms, and kitchen island all have granite counters. Additionally, the showers have glass doors. A wood-burning granite fireplace. All kitchen appliances (double stove, cooktop, dishwasher, exhaust hood) are brand new. New air conditioning, heater, A/C dust, fans, doors, baseboards, sink & connections, and lighting fixtures. All windows are new energy-saving double glass. All the plumbing is new and electrical upgraded as needed. Freshly painted inside and outside. New Hardie siding, and new shingle roofing.' ,`Acres` = '0.7432' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 28B BLK 6 SPANISH COVE SEC 1' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '32373' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '60' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spanish Cove Sec 01' ,`TaxAmount` = '6682' ,`TaxRate` = '2.6005' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675087598' WHERE `Matrix_Unique_ID` = '208793025' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T12:40:29.577' ,`MLSNumber` = '86893775' ,`ListAgentFullName` = 'Hung Dang' ,`ListOfficeName` = 'The Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665262' ,`Longitude` = '-95.364810' ,`PhotoCount` = '19' ,`PostalCode` = '77051' ,`RoomCount` = '2' ,`ListPrice` = '164250.00' ,`Status` = 'Active' ,`StreetName` = 'Knoxville' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated residence for sale two bedroom, one bathroom. Offering granite countertops, zero carpet, and no HOA! Great location, minutes from NRG stadium, easy access 288, Beltway 8, and 610.' ,`Acres` = '0.1148' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK P SUNNYSIDE COURTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Courts' ,`TaxAmount` = '1212' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1926' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087599' WHERE `Matrix_Unique_ID` = '211454623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T11:25:58.543' ,`MLSNumber` = '72050333' ,`ListAgentFullName` = 'Reecie Meeker' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.440833' ,`Longitude` = '-94.666551' ,`PhotoCount` = '42' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacks' ,`StreetNumber` = '975' ,`StreetSuffix` = 'Road' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super cute like new 3/2 home on 2 lots in the heart of Crystal Beach. You will be impressed with the spacious feel and the amount of light in the house. A huge vaulted ceiling in the living/kitchen add to the open feel. The kitchen features granite counters with stainless appliance. The whole family will be able to gather around the breakfast bar with seating for 6. The master has an oversized closet, bath with double sinks and granite counters. Nice sized guest room and also a bunkroom for the kids. Fenced for your furry family members, and a cargo lift for heavy loads. Walk straight down the road to the beach. Never been a vacation rental. RV hookup is included for your overflow guests. Included with sale is adjacent lot. Both lots are enclosed by a fence. Tax ID for additional lot 1079-0204-0007-000. Seller has survey for lot house sits on. Buyer will need to provide survey for additional lot. Come see this little piece of paradise today.' ,`Acres` = '' ,`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 179 J SHAW SUR TR 204-3, AKA TR 5 UNREC SUB ACRES 0.084' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7318' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'J & S Beach Add #2' ,`TaxAmount` = '4661' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087599' WHERE `Matrix_Unique_ID` = '211732780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T12:19:52.860' ,`MLSNumber` = '62199150' ,`ListAgentFullName` = 'Melanie Montgomery' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.453470' ,`Longitude` = '-95.743548' ,`PhotoCount` = '38' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 1097' ,`StreetNumber` = '28102' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming three bedroom, two bath home perfectly situated on partially wooded acre of property located 15 minutes from Lake Conroe. Whether you enjoy relaxing on your porch taking in the beautiful country scenery or prefer playing on the lake on the weekends, this amazing property can accommodate whatever lifestyle you crave. This outstanding property is located in the highly sought after Montgomery ISD. It won\'t last long, so come take a look today before it\'s gone.' ,`Acres` = '1' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0604 - WOOD JOHN, TRACT 3-H, ACRES 1' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Richards' ,`TaxAmount` = '2482' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087599' WHERE `Matrix_Unique_ID` = '213366181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T11:37:11.790' ,`MLSNumber` = '35041073' ,`ListAgentFullName` = 'Jessica Paschalis' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.288375' ,`Longitude` = '-95.143896' ,`PhotoCount` = '41' ,`PostalCode` = '77328' ,`RoomCount` = '6' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Burkett' ,`StreetNumber` = '10715' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Over an acre of land and plenty of country charm included with this well maintained manufactured home! This oversized lot is nicely cleared in front with plenty of space to park. The house boasts 3 bedrooms, 2 baths with a utility room in the house, and a spacious owner\'s suite with deep soaking tub and walk-in shower. Enjoy the recently constructed approx. 16x25 covered front porch, and a 24x12 workshop wired for electricity and additional large storage shed. Lot is wooded in the back, offering privacy and room to expand; lot dimensions are approximately 106 ft x 491 ft. No flooding. Perfect for your residence and business. No restrictions and easy access to US-59 and Hwy 105.' ,`Acres` = '1.182' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Splendora Woods 03, Lot 1, ACRES 0.499' ,`LotDesciption` = 'Cleared' ,`LotSize` = '51496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'GREENLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Splendora Woods' ,`TaxAmount` = '' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675087599' WHERE `Matrix_Unique_ID` = '213548597' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T11:15:09.090' ,`MLSNumber` = '64204916' ,`ListAgentFullName` = 'Cindy Fitzgerald' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.225093' ,`Longitude` = '-95.346000' ,`PhotoCount` = '7' ,`PostalCode` = '77534' ,`RoomCount` = '5' ,`ListPrice` = '246900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '2011' ,`StreetSuffix` = '' ,`City` = 'Danbury' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Energy Efficient! New Construction- Great Kitchen with lots of cabinets, Large Island w/Granite Tops! Stainless Steel Appliances, Spacious Living Room, LED lighting, Low E Windows, Great Size Backyard! Walking Distance to School! Don\'t wait it won\'t last long.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Award Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 13 Blk 22 Danbury' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Danbury TS' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087600' WHERE `Matrix_Unique_ID` = '213770383' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T12:16:55.587' ,`MLSNumber` = '60380145' ,`ListAgentFullName` = 'Saul Silva' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804215' ,`Longitude` = '-95.147530' ,`PhotoCount` = '39' ,`PostalCode` = '77530' ,`RoomCount` = '8' ,`ListPrice` = '228990.00' ,`Status` = 'Active' ,`StreetName` = 'Leadenhall' ,`StreetNumber` = '1515' ,`StreetSuffix` = 'Circle' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to buy this large 3 bedroom house. This house house has been completly remodel. Kitchen was recently upgraded with new quartz countertops fresh coat of paint a must see!!! Hurry, perfect opportunity to move in & unpack this house needs nothing. Call today for a private showing won’t last long!' ,`Acres` = '0.14' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 7 STERLING GREEN SEC 8' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green Sec 08' ,`TaxAmount` = '3416' ,`TaxRate` = '2.7519' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087600' WHERE `Matrix_Unique_ID` = '213776194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T12:03:45.767' ,`MLSNumber` = '38202416' ,`ListAgentFullName` = 'Tory Ramirez' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819578' ,`Longitude` = '-95.397158' ,`PhotoCount` = '3' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '2000000.00' ,`Status` = 'Active' ,`StreetName` = '37th' ,`StreetNumber` = '214' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully unique new construction in Independence Heights!! This amazing home will offer luxury quality of living in a central location. 4th floor rooftop terrace with incredible view of downtown will make this home a perfect place for gatherings and entertaining your guests! You will love the large master suite and spacious game room for either entertaining or quality time with the family. Don\'t miss the opportunity to personalize finishes and customize your new home in Independence Heights!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = 'De Carlo Luxury Home' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 159 & 160 SABAYRACS' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Sabayrac' ,`TaxAmount` = '2746' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675087600' WHERE `Matrix_Unique_ID` = '213835290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T11:20:53.417' ,`MLSNumber` = '46513155' ,`ListAgentFullName` = 'Angela Heiman' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.030886' ,`Longitude` = '-95.430982' ,`PhotoCount` = '29' ,`PostalCode` = '77566' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Nasturtium' ,`StreetNumber` = '129' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this great home situated on a quarter acre lot in the heart of lake Jackson with great curb appeal. This 4 bedroom, 2 bath home has additional living space, a flex room, and a nice open concept feel. with little touches like built-ins shelves, exposed brick wall, window shutters to help with the hot summers, and a XL 2 car garage to store all your toys and cars, with space to also work on things. The back yard is oversized with a great covered patio to enjoy all the days of the year. The master bedroom is spacious and has enough space to have a nice sitting area to relax and read in. master is sperate from the other 3 bedrooms for a little privacy. Home has all new plex pipe throughout. Home has been well taken care of and is now ready for its new owners. Don\'t miss your chance to come take a tour. See it before it is gone!' ,`Acres` = '0.2943' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH PARKWOOD (LAKE JACKSON), BLOCK 12, LOT 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Parkwood Lake Jackson' ,`TaxAmount` = '4833' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087600' WHERE `Matrix_Unique_ID` = '214007193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T12:58:46.303' ,`MLSNumber` = '97250837' ,`ListAgentFullName` = 'Vanessa Sarria' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851186' ,`Longitude` = '-95.195964' ,`PhotoCount` = '20' ,`PostalCode` = '77044' ,`RoomCount` = '3' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Bamboo Forest' ,`StreetNumber` = '13135' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1620' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION!' ,`Acres` = '0.132' ,`Area` = '2' ,`BuilderName` = 'Nicolas Lopez' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 15A & 16 BLK 7 PARKWAY FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '178' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'MONAHAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Forest Sec 04 R/P' ,`TaxAmount` = '1170' ,`TaxRate` = '2.9993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087601' WHERE `Matrix_Unique_ID` = '214103587' --> 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','214222756','1675087601','214222756','2022-12-05T11:25:17.783','52580753','Fareed Zeinelabdin','Pinnacle Real Estate Holding','','','29.762717','-95.269182','20','77029','3','200000.00','Active','Josie st','8715','Street','Houston','2','0','3','1006','Single-Family','A cozy home in the quiet family oriented Pleasantville neighborhood. Totally renovated inside out. New siding, fresh exterior paint, new 30 year roof, new tile & carpet flooring, new cabinets, granite countertops and appliances in the kitchen. New water heater, updated plumbing and electrical systems. New energy efficient HVAC system.\r\nHurry and make this your new home before it\'s gone.','0.1452','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Denver Harbor','Central Gas','0','LT 440 BLK 18 PLEASANTVILLE SEC 6','Subdivision Lot','6327','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','PLEASANTVILLE ELEMENTARY SCHOOL','FURR HIGH SCHOOL','HOLLAND MIDDLE SCHOOL (HOUSTON)','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Pleasantville Sec 06','1583','2.3307','Public Sewer,Public Water','1952','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T11:24:09.660' ,`MLSNumber` = '68515399' ,`ListAgentFullName` = 'Jon Skeele' ,`ListOfficeName` = 'Bayway Homes' ,`SellingAgentFullName` = 'Kathryn Saenger' ,`SellingOfficeName` = 'RE/MAX ONE - Premier' ,`Latitude` = '29.624600' ,`Longitude` = '-95.015169' ,`PhotoCount` = '6' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '285595.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bay Oaks' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family stilted home on a very large lot, BIG ENOUGH FOR A POOL!!. 3 bedrooms 2 full baths. Primary bedroom with bath and large walk in closet. Pictures are of a model match, this home should be complete approximately February 2023. La Porte on the border of Shoreacres are small Texas towns located just south of Houston, close to where the ship channel meets Galveston Bay. Rich in history and built on community, this small town is a nice escape from the big city. However, if you need to get to downtown Houston its just a 35 minute drive. Small town living with all the same amenities found in the big city, restaurants and shopping. What else could you ask for?! Agents Please see agent remarks.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Bayway Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Bay Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675087601' WHERE `Matrix_Unique_ID` = '214412149' --> 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','214523906','1675087601','214523906','2022-12-05T11:15:27.730','78163463','Emily Dieckmann','Keller Williams Realty C. P.','','','30.500182','-98.059934','21','78645','2','1400000.00','Active','Post Oak Bend','00','Loop','Lago Vista','2','0','2','960','Single-Family','','8.671','83','','','','','Sellers Disclosure','','','','','Other Heating','0','ABS 311 SUR 4 GORHAM I ACR 8.671','Other','377709','Appraisal District','','','0','','0','','0','','','','','Aluminum','124 - Marble Falls','COLT ELEMENTARY SCHOOL','MARBLE FALLS HIGH SCHOOL','MARBLE FALLS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style','NA','7622','1.784','Septic Tank,Well','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T11:39:50.720' ,`MLSNumber` = '16714621' ,`ListAgentFullName` = 'Manuel Molina' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.262364' ,`Longitude` = '-95.522383' ,`PhotoCount` = '14' ,`PostalCode` = '77384' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Rock Island' ,`StreetNumber` = '13848' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1594' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S516415 - FOSTERS RIDGE 15, BLOCK 4, LOT 20' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6942' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fosters Ridge 15' ,`TaxAmount` = '9425' ,`TaxRate` = '3.1488' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087601' WHERE `Matrix_Unique_ID` = '214561849' --> 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','215126094','1675087601','215126094','2022-12-05T11:25:05.193','55101917','Donna Story','Keller Williams Advntge Realty','','','30.675222','-95.531870','50','77340','10','425000.00','Active','Hillcrest','630','Drive','Huntsville','5','0','4','3045','Single-Family','Picture yourself living on the LAKES course in the prestigious community of ELKINS LAKE. This home is truly made for both entertaining and everyday living, with plenty of space and fabulous views. This multi-level floorplan offers a huge family room and dining room adorned with a double-sided fireplace, wet bar, an upgraded kitchen with granite countertops, stainless steel appliances & wine refrigerator. Primary Bedroom is spacious with his/her full bathroom area. The bonus/flex room is ideal for a Gameroom or 2nd living space that joins the additional bedrooms with its own bathrooms. Heated gunite pool and hot tub with multi-tiered deck, fenced yard, circular driveway, gutters, and ample amount of storage and flexible use of space throughout this beautiful home. So many updates and upgrades to this home to enjoy either inside or outside.','0.2471','43','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Huntsville Area','Central Gas','1','ELKINS LAKE - SEC 2, BLOCK 17, LOT 84','In Golf Course Community,On Golf Course,Subdivision Lot','10764','Appraisal District','','208','0','','2','Electric Oven','1','Gunite,Heated,In Ground','','Electric Range','','Composition','64 - Huntsville','ESTELLA STEWART ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal','2','Split Level,Traditional','Elkins Lake','5227','1.8868','Public Sewer,Public Water','1979','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215163005','1675087601','215163005','2022-12-05T11:37:37.140','5263223','Derald Jackson','Core One Real Estate, L.L.C','','','29.593801','-95.509247','7','77489','5','210000.00','Active','Quail Feather','1907','Court','Missouri City','2','0','3','','Single-Family','Beautiful 1 story with updated HVAC and Roof. Well maintained property in the highly desired Missouri City Area. The property is tenant occupied! Investor Special.\r\n\r\nShowings can be scheduled for 12/6/22 from 12:00 to 2:00p.m.','','38','','','','','Mud,Sellers Disclosure,Tenant Occupied','','','','Missouri City Area','Central Gas','1','Quail Green West Sec 1, block 10, lot 9','Subdivision Lot','','','','300','0','','2','','0','','','','','Composition','19 - Fort Bend','HUNTERS GLEN ELEMENTARY SCHOOL','MARSHALL HIGH SCHOOL (FORT BEND)','MISSOURI CITY MIDDLE SCHOOL','Appointment Required,Controlled Access','','1','Traditional','Quail Green West','','','Public Sewer','1982','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','215263470','1675087601','215263470','2022-12-05T11:49:55.717','69041633','Patrick McGrath','Meritage Homes Realty','','','29.818926','-94.870929','17','77523','3','353480.00','Active','Lake Grove','8511','Lane','Baytown','2','0','3','1688','Single-Family','Brand NEW energy-efficient home ready June 2023! Stock up on everyone’s favorites with plenty of room in the walk-in pantry. The open-concept layout and covered outdoor living space are great for entertaining. A fourth bedroom is perfect for guests or larger families. Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0150 Plan 830C','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven,Electric Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','1','Contemporary/Modern,Traditional','The Heights of Barber Hills','','3.37','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215263527','1675087601','215263527','2022-12-05T11:39:59.530','75894420','Patrick McGrath','Meritage Homes Realty','','','29.819117','-94.870941','6','77523','6','434640.00','Active','Lake Grove','8515','Lane','Baytown','4','0','5','2844','Single-Family','Brand NEW energy-efficient home ready June 2023! Host a game night in the Reynolds sizeable upstairs gameroom. Your guest will enjoy their privacy in the secluded downstairs bedroom. Enjoy your morning coffee in your open concept kitchen. Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0149 Plan 890C','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','The Heights of Barber Hills','','3.37','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215263538','1675087602','215263538','2022-12-05T11:36:36.910','69598406','Patrick McGrath','Meritage Homes Realty','','','29.819364','-94.870949','6','77523','5','374990.00','Active','Lake Grove','8519','Lane','Baytown','3','0','4','2012','Single-Family','Brand NEW energy-efficient home ready June 2023! Breathe easy in this unique single story. No stress allowed in the airy great room. The island kitchen helps you conquer meals with zeal. Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0148 Plan 841B','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven,Electric Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','1','Contemporary/Modern,Traditional','The Heights of Barber Hills','','3.37','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215263617','1675087602','215263617','2022-12-05T11:30:36.607','40328014','Patrick McGrath','Meritage Homes Realty','','','29.819489','-94.870933','6','77523','7','431790.00','Active','Lake Grove','8523','Lane','Baytown','2','1','4','2585','Single-Family','Brand NEW energy-efficient home ready June 2023! Skip your commute and work from home in the quiet main level flex space. The upstairs game room makes a great media or play space. Downstairs, a large walk-in closet and bath complement the private primary suite. Heights of Barbers Hill offers access to A-rated schools and major employment centers in Baytown, Mont Belvieu, and the ship channel. Unwind at the planned community pool or exploring the miles of trails. Premier dining, shopping, and recreation are all just minutes from your front door. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','53','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Chambers County West','Central Electric','1','SF 0147 Plan 880C','Subdivision Lot','','','','900','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','No Appointment Required','Builder','2','Contemporary/Modern,Traditional','The Heights of Barber Hills','','3.37','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215286797','1675087602','215286797','2022-12-05T12:27:20.770','83693962','Juana Almeida','Juana Almeida, Broker','','','29.899557','-95.472536','49','77086','2','850000.00','Active','Breen','5403','Drive','Houston','1','0','2','1032','Single-Family','If you are looking for ample space for your business that is located on a street with great traffic - this is it! This LOT is approximately 2.4 acres with a low tax rate. No city taxes! NO HOA. Located in a no-flood zone. This LOT has multiple opportunities. It can also be used to build a dream home. The metal building is currently being leased and used as a mechanic shop, while the space where the house is is being used as a body shop. The house is fenced separately from the mechanic shop. The metal building was built in 2010! Make an appointment to tour this property today. No showings on Sundays.','2.4675','11','','','','','Sellers Disclosure','0','','','Northwest Houston','No Heating','0','LT 7 & TR 6B BLK 10 017*R1736600-002-010-006B-007 RECREATION','Cleared','107483','Appraisal District','','','0','','1','','0','','','','','Composition','32 - Klein','EILAND ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','KLEIN INTERMEDIATE SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','1','Traditional','Recreation Farms Sec 02','14054','2.1885','No Sewer,Well','1930','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','215335884','1675087602','215335884','2022-12-05T12:02:03.153','22613474','Kimberly Price','Coldwell Banker Southern Homes','','','30.043524','-94.274363','6','77713','7','297500.00','Active','Essie','5765','Lane','Beaumont','2','2','3','1750','Single-Family','Gorgeous and Affordable new construction by Price Homes in Pine Glen Addition. Open concept with large family room, high ceilings, spacious kitchen great for entertaining with lots of cabinets, large island with quartz countertops. Neutral tones throughout really make this home a great choice. Located near shopping, restaurants, and more! Come see all of the beautiful details that make this house a home.','0.165','51','CMP 3 Enterprises','','','','Other Disclosures','','','','','Central Gas','0','LOT 2 BLK 2 PINE GLEN 5TH PHASE 2 SEC 1 .165AC','Other','7187','Other','','','1','To Be Built/Under Construction','','','0','','','','','Composition','163 - Hardin-Jefferson','CHINA ELEMENTARY SCHOOL','HARDIN-JEFFERSON HIGH SCHOOL','HENDERSON MIDDLE SCHOOL','Vacant/Unoccupied','Builder','1','Traditional','Pine Glen','11','2.6134','Public Sewer,Public Water','2022','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','215340651','1675087602','215340651','2022-12-05T11:26:09.730','37511944','Melissa Alonzo','NB Elite Realty','','','28.972179','-95.972398','7','77414','2','120000.00','Active','Avenue D','3020','','Bay City','1','0','2','1224','Single-Family','','0.1492','54','','','','','Sellers Disclosure','','','','','Central Gas','0','HERMAN S/D LOT 9 BLK 1','Subdivision Lot','6500','Appraisal District','','','0','','0','','0','','','','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Herman Sub','1068','2.6704','Public Water','1940','Appraisal District'); --> New record created successfully