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-29T10:56:31.600' ,`MLSNumber` = '85714198' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.125101' ,`Longitude` = '-94.377502' ,`PhotoCount` = '11' ,`PostalCode` = '77659' ,`RoomCount` = '8' ,`ListPrice` = '294990.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Trails' ,`StreetNumber` = '1555' ,`StreetSuffix` = '' ,`City` = 'Sour Lake' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Holly Trails! The Lakeway is a beautiful and spacious one-story home! The home has modern farmhouse, open floor plan design. The family room overlooks the covered patio. The kitchen has a large island, pantry, and is open to the breakfast area. The bedroom suite has a large walk-in closet. It also has three more bedrooms, 2 full baths, study, utility room, and a two-car garage. Modern finishes include 3 cm granite and stainless gas appliances. Smart home features are also included for added convenience and security. Book your appointment for a tour today!' ,`Acres` = '0.2798' ,`Area` = '49' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 7 BLK 2 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Holly Trails Ph 1' ,`TaxAmount` = '759' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096983' WHERE `Matrix_Unique_ID` = '206771685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T10:57:23.937' ,`MLSNumber` = '97211626' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.126690' ,`Longitude` = '-94.377023' ,`PhotoCount` = '10' ,`PostalCode` = '77659' ,`RoomCount` = '8' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '1545' ,`StreetSuffix` = 'Trail' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kingston plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room.' ,`Acres` = '0.2798' ,`Area` = '49' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BLK 2 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Trails Ph 1' ,`TaxAmount` = '759' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096983' WHERE `Matrix_Unique_ID` = '209811281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T09:53:35.377' ,`MLSNumber` = '57962337' ,`ListAgentFullName` = 'Wesley Wilson' ,`ListOfficeName` = 'Roofline Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.898064' ,`Longitude` = '-95.646128' ,`PhotoCount` = '30' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinyon Creek' ,`StreetNumber` = '15807' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This unique split-level in Copperfield Middlegate Village is ready for your personal touches. Situated on a large lot backing up to the greenbelt and creek, this home features mature trees in the front and oversized fenced backyard. You\'ll love the privacy offered by the split-level plan boasting a formal living room with fireplace and primary bedroom suite on the first floor. The main living space and enormous secondary bedrooms fill the second floor. You\'ll love the updated kitchen with custom cabinets and quartz countertops all open to the massive family room. The breakfast area opens to a balcony overlooking the giant back yard. You\'ll have room for everything with all bedrooms large enough for king sized beds and full furniture sets. Bring your own style and color pallet to make this home yours. Just steps from Middlegate Park. Labay Middle School and Fiest Elementary are right in the neighborhood!' ,`Acres` = '0.1926' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 58 COPPERFIELD MIDDLEGATE VILLAGE SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '715' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FIEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Copperfield Middlegate Village' ,`TaxAmount` = '4650' ,`TaxRate` = '2.3216' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096983' WHERE `Matrix_Unique_ID` = '210113039' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T09:33:03.790' ,`MLSNumber` = '72925642' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Verenda Hodge' ,`SellingOfficeName` = 'RE/MAX Integrity' ,`Latitude` = '29.852738' ,`Longitude` = '-95.742516' ,`PhotoCount` = '8' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '315490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bay Meadows' ,`StreetNumber` = '5107' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE NEW D. R. HORTON BUILT 4 BEDROOM! Desirable Interior Layout with Two Bedrooms & Two Baths Downstairs! Impressive Foyer Opens Onto Gourmet Island Kitchen with Cabinetry Galore, Spacious Dining Area, & Living Room! Privately Located First Floor Primary Suite Offers Lovely Bath with Large Shower & Walk-In Closet! Guest Suite/Second Bedroom Downstairs with Adjoining Full Bath! Generously Sized Indoor Utility Room! Huge Gameroom/Media Room Up! Hard Surface Flooring in Living Area! Covered Patio Overlooks Tranquil Backyard!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 JASMINE HEIGHTS SEC 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6476' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.82' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096983' WHERE `Matrix_Unique_ID` = '210422227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T09:53:49.353' ,`MLSNumber` = '27426397' ,`ListAgentFullName` = 'Allison Cornett' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988374' ,`Longitude` = '-94.010849' ,`PhotoCount` = '26' ,`PostalCode` = '77627' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Crockett' ,`StreetNumber` = '1306' ,`StreetSuffix` = '' ,`City` = 'Nederland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER! Don\'t let the outside fool you! It\'s bigger than it looks! This newly remodeled home features 4 bedrooms or 3 bedrooms and an office, large master closet and an open living/kitchen/dining area perfect for entertaining! All brand new appliances, granite countertops, tile and vinyl floors and a beautiful wood burning fireplace!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 2 Blk 14 Central Heights 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'LANGHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'WILSON MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675096984' WHERE `Matrix_Unique_ID` = '211606085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T09:24:05.217' ,`MLSNumber` = '28843461' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Veronica Mendoza' ,`SellingOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`Latitude` = '29.832921' ,`Longitude` = '-95.857725' ,`PhotoCount` = '21' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '375790.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1549' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! 3 CAR GARAGE - AND OVERSIZED HOMESITE ON CUL-DE-SAC STREET! So Many Fabulous Features: Stainless Steel Appliances with Gas Cooktop, Grey Quartz Countertops, 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Solid Surface Flooring, Tankless Water Heater, Oversized Covered Back Patio, & Full Sprinkler System! Wonderful Open Concept Design with Island Kitchen Open to Dining & Living Areas! Privately Located Primary Suite with Huge Walk-In Closet! Convenient Indoor Utility Room! Also Includes WASHER/DRYER/REFRIGERATOR and BLINDS! Zoned to Katy ISD Schools! Easy Access to the Grand Parkway! Neighborhood Amenities Include GORGEOUS Crystal Lagoon & Amenity Village with Pool, Clubhouse, Lakes, Parks, PLUS MORE! WOW! Estimated Completion - February 2023.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNTERRA 15 BLK 1 LOT 13' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10206' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.629' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096984' WHERE `Matrix_Unique_ID` = '211727494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T10:10:19.237' ,`MLSNumber` = '14118305' ,`ListAgentFullName` = 'Philip Thomas' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153470' ,`Longitude` = '-95.468996' ,`PhotoCount` = '50' ,`PostalCode` = '77380' ,`RoomCount` = '14' ,`ListPrice` = '4750000.00' ,`Status` = 'Active' ,`StreetName` = 'Doe Run' ,`StreetNumber` = '25' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '3' ,`BedsTotal` = '4' ,`SqFtTotal` = '7890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Grand yet intimate estate on rare, private & expansive lot of the TWCC East Course 12th hole. Mins to I-45 Market St shops & restaurants. Built for discerning clientele w/the finest materials. Elegant & traditional elements blending wood, brick, iron & marble. Formal reception foyer w/curvilinear staircase opens to Library & Dining Room. Sun-lit living w/French doors. Gourmet Kitchen features Thermador appliances, steam oven, 80 bottle wine fridge & catering pantry. Magnificent Owner’s Retreat w/spa Bath, custom closets and fireplaces. Large Game Room/Media w/stunning golf course views. Blissful Spa/Gym/Steam shower could be Guest Suite. 2-story Guest Quarters currently an Office. The exterior grounds are equally captivating featuring lush landscape, summer Kitchen, sport court, pool/spa, fire pit. All w/upmost privacy for entertaining. Fenced motor court for 7 cars. Other amenities include 4 car garage, 2 generators, elevator, Control 4. No detail has been spared in its creation.' ,`Acres` = '0.6496' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S972816 - WDLNDS VIL GROGANS ML 16, BLOCK 4, LOT 1' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Water View' ,`LotSize` = '28296' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial,Georgian,Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 16' ,`TaxAmount` = '46636' ,`TaxRate` = '2.0079' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675096984' WHERE `Matrix_Unique_ID` = '211988276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T10:54:45.990' ,`MLSNumber` = '57018937' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.127107' ,`Longitude` = '-94.376990' ,`PhotoCount` = '10' ,`PostalCode` = '77659' ,`RoomCount` = '7' ,`ListPrice` = '274990.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '1525' ,`StreetSuffix` = 'Trail' ,`City` = 'Sour Lake' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in Holly Trails!! The Huntsville plan by D.R. Horton is a one-story featuring 4 bedrooms, 2 baths, and 2 car garage. The foyer opens to the guest bedrooms, bath and hall linen closet. Center kitchen includes breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry and opens to family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the dining area.' ,`Acres` = '0.2798' ,`Area` = '49' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLK 2 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12188' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '163 - Hardin-Jefferson' ,`SchoolElementary` = 'SOUR LAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN-JEFFERSON HIGH SCHOOL' ,`SchoolMiddle` = 'HENDERSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holly Trails Ph 1' ,`TaxAmount` = '759' ,`TaxRate` = '1.8384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096984' WHERE `Matrix_Unique_ID` = '213658791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T10:11:52.930' ,`MLSNumber` = '10396052' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.428577' ,`Longitude` = '-95.456561' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '364990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1235' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Ozark plan is a two-story home featuring 4 bedrooms, 2.5 baths, and 2 car garage. The foyer opens to a study and powder bath with linen closet. Center kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. Open concept floorplan boasts large combined family room and dining area. Extra storage space under the stairs is a plus. The private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. Upstairs boasts open loft and three additional bedrooms and bath. The standard rear covered patio is located off the family room.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Blk 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096985' WHERE `Matrix_Unique_ID` = '214412615' --> 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','214735416','1675096985','214735416','2022-12-29T10:36:19.607','47655773','Etha Eglin','Keller Williams Metropolitan','','','30.126902','-94.377016','11','77659','7','279990.00','Active','Holly','1535','Trail','Sour Lake','2','0','4','1796','Single-Family','New Construction by D.R. Horton in Holly Trails. The Cali plan is a one-story featuring 4 bedrooms, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area.','0.2798','49','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Gas','1','LOT 9 BLK 2 HOLLY TRAILS PHASE 1 AS PER PLAT 4-209 P# HT-1-2','Subdivision Lot','12188','Appraisal District','','135','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','163 - Hardin-Jefferson','SOUR LAKE ELEMENTARY SCHOOL','HARDIN-JEFFERSON HIGH SCHOOL','HENDERSON MIDDLE SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Holly Trails Ph 1','759','1.8384','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T10:12:55.280' ,`MLSNumber` = '71912568' ,`ListAgentFullName` = 'Kristin Reed' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.356405' ,`Longitude` = '-95.607800' ,`PhotoCount` = '25' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Sioux River' ,`StreetNumber` = '510' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This \"like new\" home is just what you have been looking for! 4 bedrooms, 2.5 bathrooms, with 2 car garage. Home sits on a large lot with access to neighborhood lake. Front porch welcomes you home and makes for a relaxing sitting area. The kitchen is open to the living room and breakfast nook, with sliding doors to the backyard. Washer, dryer and refrigerator stay! Storage shed on concrete slab in the backyard is great for extra storage. Must see to truly appreciate! Schedule your showing today!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S658002 - LAKE CONROE FOREST 02, BLOCK 37, LOT 30 & 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12806' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '156' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Forest' ,`TaxAmount` = '4687' ,`TaxRate` = '2.1625' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096985' WHERE `Matrix_Unique_ID` = '214757773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T10:47:47.393' ,`MLSNumber` = '16999147' ,`ListAgentFullName` = 'Colby Walters' ,`ListOfficeName` = 'Swede\'s Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.491895' ,`Longitude` = '-94.538392' ,`PhotoCount` = '19' ,`PostalCode` = '77617' ,`RoomCount` = '3' ,`ListPrice` = '629000.00' ,`Status` = 'Active' ,`StreetName` = 'Smith' ,`StreetNumber` = '963' ,`StreetSuffix` = 'Drive' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beachfront living at an incredible price point! Panoramic views of the Gulf of Mexico from the deck. Deck also has lift installed already! Inside you will find 3 bedrooms, 2 bathrooms and an open concept living area! Downstairs features a seating area with views of the Gulf as well as a sand shower to rinse off after you complete the 10 second walk back from the beach. This home has been meticulously maintained and would make a great second home or short term rental!' ,`Acres` = '0.1548' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Caplen' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 31 R BARROW SUR LOT 3 HUGHES SUB' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Hughes Frank A Sub Of Lt 7 C' ,`TaxAmount` = '3710' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096985' WHERE `Matrix_Unique_ID` = '215067223' --> 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','215178420','1675096985','215178420','2022-12-29T10:32:28.770','57497203','Carol Cantu','Houston Preferred Properties','','','29.824588','-95.515038','39','77080','6','355000.00','Active','Theysen','9006','Drive','Houston','2','0','3','1874','Single-Family','Charming 1-story home on an huge lot for all your entertaining needs. This home features an amazing floor plan, 3 bedrooms, 2 full bath, a dining area, tile floors which run throughout the spacious living room that flows into the dining room and kitchen. The kitchen features custom cabinets with see through window panes to displace beautiful kitchenware. Cook on a brand new stove. The bedrooms feature new carpet and all interior walls are freshly painted. All windows are double-pane and double-hung with a lifetime warranty. The plumbing has been updated to PEX pipes. The exterior roof was replaced in 2020. House is centrally wired with Fiber Optic for AT&T. Both bathrooms have been recently remodeled. The 2 car garage has an additional area for a workshop. The home also comes with a tankless water heater. This home is a must see! Only minutes from Downtown Houston and the Energy Corridor District. This home is move-in-ready in the heart of Spring Branch.','','24','','','','','Sellers Disclosure','','','','Spring Branch','Central Gas','0','LT138 BLK 13','Subdivision Lot','15247','Appraisal District','','50','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','49 - Spring Branch','EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','NORTHBROOK MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Ranch','Binglewood','','','Public Sewer,Public Water','1956','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','215249685','1675096985','215249685','2022-12-29T09:18:37.140','7043584','Jamie McMartin','Compass RE Texas, LLCKaty','Holly Sincox','RE/MAX Leading Edge','29.799994','-95.834457','29','77493','12','400000.00','Pending Continue to Show','Tiger','6506','Trail','Katy','3','0','3','2145','Single-Family','Welcome Home to 6506 Tiger Trail in Cane Island! This David Weekley Home has the extras that you\'ve always wanted! A home built for entertaining that sits on an oversized, cul de sac lot with No Back Neighbors! The outdoor kitchen with built-in stainless steel grill, sink, and fridge is ready for the party! The open floor plan with chef\'s kitchen is as functional as it is stylish! Under cabinet lighting shows off the sleek granite counters and handsome cabinetry! A tv/play room is ideally situated between the secondary bedrooms to give the kids a space with easy access to the family room but separated for the toys to stay out of sight! The Owner\'s Retreat has the spa-like shower of your dreams with multiple body jets & shower heads! OVER 400 sqft of finished, AC space with full bathroom upstairs that is accessible from the garage! Not included in listing square footage. Perfect as a man cave, climate controlled storage, or home gym! Endless Possibilities! Welcome Home!','0.2084','25','David Weekley','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - Old Towne','Central Gas','1','S422322 CANE ISLAND 2 BLK 2 LOT 10','Cleared,Subdivision Lot','9078','Appraisal District','','1200','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','1','Ranch','Cane Island','10709','3.4077','Public Sewer,Public Water,Water District','2016','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','215502507','1675096985','215502507','2022-12-29T09:11:35.690','80699749','Ronnie Matthews','D.R. Horton Homes','Gustavo Andrade Fuentes','Central Metro Realty','29.851913','-95.745101','6','77449','4','310240.00','Pending Continue to Show','Bay Meadows Lane','5103','','Katy','2','0','4','1868','Single-Family','CHARMING BRAND NEW DR HORTON HOME IN THE BEST LOCATION!! Corner lot!! Perfect 1 story floor plan with everything you have been looking for!! Great open living spaces, modern finishes, designer details, lovely primary suite, and so much more!! Beautiful island kitchen! Perfect for entertaining!!Lovely outdoor space with useful covered back patio! Includes landscape package!! Don\'t miss this opportunity!! Hurry and call today! This property will sell fast!','','25','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - North','Central Gas','1','Lot 14 - Block 2 - Section 25','Corner,Subdivision Lot','','','','320','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','GOLBOW ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','MCDONALD JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Jasmine Heights','','','Water District','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','215590166','1675096985','215590166','2022-12-29T09:31:02.927','91879997','Ronnie Matthews','D.R. Horton Homes','Jojo Tharayil','Excel Realty Co','29.833329','-95.854834','11','77493','6','394390.00','Pending Continue to Show','Dawn Harbor Drive','1504','','Katy','2','1','4','2599','Single-Family','UNBELIEVABLE NEW D. R. HORTON BUILT 4 BEDROOM! Sought-After Interior Layout with Primary Bedroom & Home Office/5th Bedroom Down! Impressive Two Story Foyer with Soaring Ceilings & Beautiful Staircase with horizontal Iron Railings! Luxurious white Quartz Counters & Backsplash in Kitchen, Along with 42\" White Cabinetry with Under Cabinet Lighting & blue accent cabinets at oversized island, & Farmhouse Style Sink! Du Pure Water Filtration System & Stainless Steel Whirlpool Appliances (Including 5 Burner Gas Cooktop)! First Floor Primary Suite with Walk-In Closet & Garden Bath! Three Big Secondary Bedrooms - AND Massive Gameroom Up! Wood-Look Vinyl Plank Flooring, Fully Landscaped Front & Back Yards, Sprinkler System, Covered Patio, Tankless Water Heater by Rinnai, Smart Home Technology, PLUS MORE! Great Community with Pool, Tennis Courts, & Clubhouse! Easy Access to the Grand Parkway! Estimated Completion - June 2023.','','25','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','2/3/15','Subdivision Lot','6600','Other','','1000','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Sunterra','','','Water District','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','215757750','1675096985','215757750','2022-12-29T10:04:03.617','48182209','Gayla Gayden','REALM Real Estate Professional','Rishi Naran','Coldwell Banker Realty','29.571545','-95.518441','39','77459','11','327990.00','Pending Continue to Show','Hyde Lake','1118','Lane','Missouri City','2','0','4','2045','Single-Family','D. R. Horton New Dramatic Modern & Chic One Story Home-Brick & Stucco Elevation (Timeless)! Covered Patio with Private Texas Size Huge Backyard, fully Landscaped Front & Back. Grand Entry W/Large Tile Floors throughout! Stunning Open Floor Plan that Family Area flows into the Gourmet Kitchen & Casual Dining! Gourmet Kitchen W/Beautiful Quartz Counters, Stunning Tall Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Walk In Pantry, Eat In Working Station Island W/Undermount Sinks, Swan Pull Out Kitchen Faucet & More! Private Primary Suite W/Spa Like Bathrm W/Vanity with Gorgeous Quartz Counters, 2 Deep Undermount Sinks, Soaker Tub, Shower & Walk In Closet! 3 Guest Bedrooms & Quartz Counters in the Guest Bathrm! HERS Energy Rated with Tankless/On-Demand H2O Heater & more! Outstanding Smart Home Automation System to control your Home anywhere! Outstanding Resort Amenities! Stop the timeless Rental Cycle & Come out to Park\'s Edge and make this new home yours TODAY! No Flooding','0.17','38','D.R. Horton','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Missouri City Area','Central Gas','1','Parks Edge: Lot 42 /Block 3','Greenbelt,Subdivision Lot','7500','Survey','','900','1','Never Lived In','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','19 - Fort Bend','PALMER ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','No Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','1','Contemporary/Modern,Mediterranean,Ranch','Parks Edge','','3.240027','Public Sewer,Public Water,Water District','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','215804936','1675096986','215804936','2022-12-29T09:35:58.693','83658292','Ronnie Matthews','D.R. Horton Homes','Ranjit Jangili','eXp Realty, LLC','30.263032','-95.527683','20','77384','5','425045.00','Pending Continue to Show','Sandhill Crane','15311','Lane','Conroe','3','1','4','2808','Single-Family','NO BACK NEIGHBORS! New DR Horton home! Beautiful two story home with a 2 car garage. This new construction home features gorgeous brick and stone exterior and includes 4 bed/3 bath/ with a gameroom Features include SS Appliances a 5 burner built-in gas burner cooktop, Quartz Countertops and 42\" flat cabinets in Kitchen, Separate Shower, Built-In Home Automation, Solid Surface Flooring throughout, Tankless Water Heater, Covered Patio, and Full Sprinkler System. Fosters Ridge offers beautiful community center, playground, and pool. Zoned to The Woodlands Schools! DR Horton is America\'s #1 Homebuilder! Come out to Fosters Ridge and make this new home yours today!','0.1781','15','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Conroe Southwest','Central Gas','1','S516419 - FOSTERS RIDGE 19, BLOCK 3, LOT 18','Subdivision Lot','7760','Appraisal District','','850','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Fosters Ridge 19','','','Water District','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','215810473','1675096986','215810473','2022-12-29T09:22:11.497','53727924','Jose Cruz','Hardee & Company Real Estate','','','29.855715','-95.446611','23','77091','5','354900.00','Active','Carver Rd','6236','','Houston','2','1','3','1785','Single-Family','Welcome to 6236 Carver Rd!! This NEW CONSTRUCTION is located in EMMA NUBEN subdivision of Acres Homes & offers a 3 bedroom 2.5 bathroom/ 2- Car Garage / Detached interior Features include tile throughout the first floor. Recessed lighting and many windows to let in natural light. Kitchen will offer granite countertops with custom cabinetry w/ Designer fixtures & stainless steel appliances. Primary suite offers ceiling fan W/light & large windows, dual sinks, Soaking Tub, Separate shower walk- in closet. Upstairs offer 2 secondary bedrooms & full bathroom with shower. Backyard has plenty of room to plant a garden!! Schedule your showing Today!','','9','Alvarado Group LLC','','','','Sellers Disclosure','1','','','Northwest Houston','Central Electric','0','Lot 1 Blk 1','Subdivision Lot','3717','Survey','','','1','To Be Built/Under Construction','2','','0','','','','','Wood Shingle','1 - Aldine','HARRIS ACADEMY','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Lockbox Front','Builder','2','Contemporary/Modern','Highland Acres','','','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','215910819','1675096986','215910819','2022-12-29T10:10:10.253','65685971','Madeline Phillips','Premier Property Group','','','30.704919','-94.891131','45','77351','3','259900.00','Active','Debbie','120','Court','Livingston','2','0','3','1368','Single-Family','Rare find! This property screams potential! 3bed/2bath manufactured home nestled on 4.2175 acres just a few miles from town! This property surrounds Lake Debbie, a spring fed pond that is approximately 1.5 acres! Features include an in-ground pool, 34x19 RV storage building, 30x15 workshop/storage, 23x22 Quonset hut, 50x30 steel shop,RV pad with water and sewer, and several other outbuildings! This would make an excellent weekend retreat or forever home!','4.2175','44','','','','','Sellers Disclosure','','','','Livingston Area','Central Electric','0','CRYSTAL LAKES SECTION 2 LOT 120,121,260,261,262,263,264,267,','Wooded','40212','Appraisal District','','','0','','0','','1','Fiberglass','','','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Crystal Lakes Sec 2','159','1.8745','Public Water,Septic Tank','2003','Appraisal District'); --> New record created successfully