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-28T12:13:01.653' ,`MLSNumber` = '91423183' ,`ListAgentFullName` = 'Clinton Omiwade' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.148887' ,`Longitude` = '-95.813371' ,`PhotoCount` = '42' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Robin Hood' ,`StreetNumber` = '25214' ,`StreetSuffix` = 'Court' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous single-story, 2134 sqft home in a great location ! Check out this lovely 3-bedroom, 2-bathroom home This home features beautiful tile ,and wood floors through the whole house, stunning front entry with large beautiful kitchen, and so much more! Very spacious Main Living area With great Flooring. Large Sized Kitchen with Open Concept.Large backyard. House has been extensively remodeled. Two different lots totaling 1.69 acres are included in the property. The house is situated on.69 acres, with a 1-acre adjacent vacant lot. The front patio of the house is covered and faces the circle driveway. The home is located on a cul-de-sac shared with only one neighbor. Has an additional game area that is ideal for entertaining visitors. The laundry room includes a door that leads to the screened-in backyard. The wooded 1-acre lot could be used for anything the seller desires. This property provides an abundance of options! This Gem Will Not Last Long.' ,`Acres` = '1.69' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S433900 CLEAR CREEK FOREST 9 LOT 9 & 10 ACRES 1.69' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '73616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear Creek Forest 9' ,`TaxAmount` = '4721' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096560' WHERE `Matrix_Unique_ID` = '207380652' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:06:22.493' ,`MLSNumber` = '8932797' ,`ListAgentFullName` = 'Dana Staples' ,`ListOfficeName` = 'Staples Sotheby\'sInternational' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.449636' ,`Longitude` = '-94.284825' ,`PhotoCount` = '46' ,`PostalCode` = '75672' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Blocker' ,`StreetNumber` = '2525' ,`StreetSuffix` = 'Road' ,`City` = 'Marshall' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a piece of an Historic Plantation! Cedar Grove, the Henry Ware Plantation, was originally part of a 640 acre plantation. (Some records show over 8,000 acres) The home, a two story Greek Revival is a four square floor plan with a hipped roof and double hung windows on both stories, built of locally made brick, hand-hewn timbers and square nails started in 1847 and completed in 1852. Pier and beam, the piers are reported to be 9\' deep!. Ownership of the home was kept within the Ware family descendants through June of 2019. There is a stocked spring fed lake lined with cypress trees. This home will require restoration/renovation, currently there is no kitchen (the original kitchen would have been outside the home).' ,`Acres` = '' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '15.073, Abst 722 M S Ussery, Hse' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '710 - Marshall' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (MARSHALL)' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (MARSHALL)' ,`SchoolMiddle` = 'MARSHALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'NA' ,`TaxAmount` = '2321' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1846' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096560' WHERE `Matrix_Unique_ID` = '208593975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:15:32.687' ,`MLSNumber` = '10426613' ,`ListAgentFullName` = 'Mohamad Hafez' ,`ListOfficeName` = 'CNA Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999136' ,`Longitude` = '-95.723329' ,`PhotoCount` = '45' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Geneva Fields' ,`StreetNumber` = '19902' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 2 STORY HOME ON A CORNER LAKE VIEW LOT*SHOWS LIKE A MODEL! GRANITE COUNTERS IN KITCHEN/BATHROOMS*42in CABINETS*CROWN MOLDING*2in BLINDS *OVERSIZED TANDEM GARAGE*DOUBLE OVENS*BRICK ON ALL FOUR SIDES AND BEAUTIFUL STONE * Fans IN ALL ROOMS*COMMUNITY POOL/PARK WALKING DISTANCE*CY-FAIR ISD*EXCELLENT LOCATION ONLY MINS. TO 290 AND THE OUTLET MALL*THIS IS A MUST SEE!' ,`Acres` = '0.1685' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CYPRESS LANDING EAST SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '762' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Landing' ,`TaxAmount` = '9479' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096560' WHERE `Matrix_Unique_ID` = '209311583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:23:42.357' ,`MLSNumber` = '2768002' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Jennifer Carpenter' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.066843' ,`Longitude` = '-95.724128' ,`PhotoCount` = '18' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '345360.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Little Sebastian' ,`StreetNumber` = '20815' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*home is under construction.* Be enchanted by this Beazer Home in Amira, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, a sprinkler system, an open great room, and a covered patio. Cook up new cuisines in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, and pendant lighting. Spend evenings relaxing in the primary suite, featuring a walk-in closet, dual vanities, a tub, and a separate shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are a part of the top-rated Tomball ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096560' WHERE `Matrix_Unique_ID` = '209332269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:25:04.740' ,`MLSNumber` = '52212051' ,`ListAgentFullName` = 'Estevan Mendez' ,`ListOfficeName` = 'Ameristate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801319' ,`Longitude` = '-95.470824' ,`PhotoCount` = '8' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Raton' ,`StreetNumber` = '6922' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1039' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing property in a well sought after community of Pine Terrace. Conveniently located within minutes from highway 290, I-610 and I-10. This property is livable but exploring a tear down and rebuild is definitely a possibility. MANY newly built homes in the area. This is an ideal size lot to build your dream home. Don\'t miss out on the opportunity! Schedule an appointment today.' ,`Acres` = '0.1653' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 2 PINE TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pine Terrace' ,`TaxAmount` = '5978' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096560' WHERE `Matrix_Unique_ID` = '209787648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:49:32.280' ,`MLSNumber` = '41539495' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.125101' ,`Longitude` = '-94.377502' ,`PhotoCount` = '10' ,`PostalCode` = '77659' ,`RoomCount` = '8' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '1565' ,`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 modern farmhouse 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,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 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` = '' ,`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`='1675096561' WHERE `Matrix_Unique_ID` = '209806062' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:57:49.393' ,`MLSNumber` = '46734582' ,`ListAgentFullName` = 'Barbara Towne' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770785' ,`Longitude` = '-95.459832' ,`PhotoCount` = '47' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '2650000.00' ,`Status` = 'Active' ,`StreetName` = 'Pasture View' ,`StreetNumber` = '8702' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '6704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on a corner lot behind manned gates of Stablewood, this well-maintained traditional offers an opportunity for a new owner to make it their own. The brick exterior, lush landscaping with 3-car garage & gated driveway are instant attractions. Enter the inviting foyer with generous formals on each side & grand staircase. Handsome study/library with 2 walls of built-ins is also down & has exterior door to covered patio/backyard. Graciously sized family room with wet bar & fireplace also overlooks back patio & yard. The family room continues to the breakfast & kitchen, featuring abundant storage, counterspace, double ovens, gas range & more. On the 2nd level are 4 bedrooms including the primary which features 2 full baths & fireplace. Convenient room off 1 of the primary closets is perfect for workout equipment. Above the garage, accessible by its own interior staircase, is a large guest apt with kitchenette & full bath. The property also features an elevator & generator.' ,`Acres` = '0.3532' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 4 STABLEWOOD 2ND AMEND' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15385' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '11500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stablewood' ,`TaxAmount` = '46022' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096561' WHERE `Matrix_Unique_ID` = '210551160' --> 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','212232965','1675096561','212232965','2022-12-28T12:45:52.207','53654449','Donna Dixon','Legacy Real Estate Group','','','31.062691','-95.133694','21','75845','3','169900.00','Active','5th','707','Street','Groveton','2','0','3','1312','Single-Family','3/2/1 on just over Half Acre in the City of Groveton TX. Solid Brick on Slab with Central AC and Heat. Large, fenced back yard, great spot for kids, pets, or to grow a nice garden. Inside find a large Bonus Room with a ton of windows for natural light. Use as a Den, Gameroom, or as a 4th Bedroom. Home has some great updates already done, such as French Doors on Patio, Instant Water Heater, Security Cameras, Carpets replaced less than a year ago, and Crown Molding. A must see as this home is priced to sell! Call now to book your showing.','0.55','42','','','','','Sellers Disclosure','','','','Groveton Area','Central Electric','0','GROVETON, CITY OF, BLOCK 48 LOT 2','Cleared','23958','Appraisal District','','','0','','1','','0','','','','','Composition','59 - Groveton','GROVETON ELEMENTARY SCHOOL','GROVETON J H-H S','GROVETON J H-H S','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','Groveton City Of','1868','2.4366','Public Sewer,Public Water','1959','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:19:22.157' ,`MLSNumber` = '69096365' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.847061' ,`Longitude` = '-95.815763' ,`PhotoCount` = '10' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '264412.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunway' ,`StreetNumber` = '5035' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find total comfort in this lovely Beazer Home in Marisol, which features a brick façade, no back neighbors, sloped ceilings, tile flooring, an open great room, and a covered patio. Prepare incredible feasts in the kitchen, fully equipped with granite countertops, stainless steel Whirlpool® appliances, and 42” upper cabinets. Complete with a walk-in closet, dual vanities, and a shower, the primary suite is ideal for relaxation. Residents of Marisol enjoy easy access to a variety of popular shopping and dining at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Commuters love the easy drive to Downtown Houston and the Energy Corridor via I-10 and the Grand Parkway. Community comforts include a waterfall entry, green spaces, and walking trails. Zoned to the top-rated Katy ISD. You don’t want to miss this home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marisol' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096561' WHERE `Matrix_Unique_ID` = '212314306' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:51:18.297' ,`MLSNumber` = '75731750' ,`ListAgentFullName` = 'Deairra Bass' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.408267' ,`Longitude` = '-95.050111' ,`PhotoCount` = '12' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '358900.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Rose' ,`StreetNumber` = '2801' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Model home All on one level! Open living Spacious Single Story. Kitchen 36\' Ellis white cabinets, granite counters, subway tile backsplash, and walk-in pantry include 16\' shelving with frigidaire stainless steel appliances, gas range, dishwasher, and microwave. Master suite boasts soaring ceilings, and spacious en-suite with separate tub and shower with tile surround, large walk-in closets with 16\' wood shelves, and double vanities. 4 bedrooms 3 bath Energy efficient 16 seer HVAC, OSB roof decking, programmable digital thermostat. The 12-acre Lago Mar crystal clear lagoon is the largest in Texas and a unique staycation destination. Bay Area breezes will caress you while you lounge on white-sand beaches, swim in azure waters, or dine lagoon-side on our beach boardwalk. Walking, biking and jogging trails, fitness centers, and pools are just a few amenities that Lago Mar offers its homeowners. Visit the Model home in fabulous Lago Mar!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TBD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.79' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096561' WHERE `Matrix_Unique_ID` = '212667909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:36:43.773' ,`MLSNumber` = '74722860' ,`ListAgentFullName` = 'Rachel Anderson' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.707073' ,`Longitude` = '-96.182321' ,`PhotoCount` = '29' ,`PostalCode` = '75840' ,`RoomCount` = '3' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = 'US Highway 84' ,`StreetNumber` = '1360' ,`StreetSuffix` = '' ,`City` = 'Fairfield' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What if you could find a home with incredible climate controlled space large enough for just about any project? Check out this Charming 2 bed, 2 bath with open kitchen & living in fun colors, bedrooms upstairs with large bath, tub & shower, tile surround. With approx 1,200 of living space out of the 60x100x20 total area, the Open Span Metal Building keeps your options open! Add or move walls, make it work for you! Foam Insulation, 2 huge industrial ceiling fans, 4 central units, Office, Waiting Area, 20x20 Storage with exterior garage door, IDEAL Location for any Business! High traffic area on US Hwy 84 near I-45! Combine Home & Business! , Over an Acre, plenty of parking space or room to expand building, Now being used for gymnastics & cheer, but the possibilities are endless.' ,`Acres` = '1.165' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'I H REED A-23' ,`LotDesciption` = 'Cleared' ,`LotSize` = '50747' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Barndominium' ,`Subdivision` = 'None' ,`TaxAmount` = '9245' ,`TaxRate` = '2.195' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096562' WHERE `Matrix_Unique_ID` = '212684881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:08:02.767' ,`MLSNumber` = '43535440' ,`ListAgentFullName` = 'Sadaf Moon' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.603536' ,`Longitude` = '-95.659779' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '7' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Trillium Dr' ,`StreetNumber` = '310' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate condition! High ceiling family room. Open kitchen with breakfast bar, Granite counter top, built in. Stainless appliances. Formal Dining with wood flooring. Master bathroom with separate shower Upgraded lighting. Good size game room with built in shelves. Rod iron spindles on the stair cases. Good size back yard- room for pool. Zoned to excellent schools. Community lakes/pools/Tennis courts/gym, etc..' ,`Acres` = '0.1722' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TELFAIR SEC 15-B, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'CORNERSTONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telfair' ,`TaxAmount` = '11145' ,`TaxRate` = '2.9144' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096562' WHERE `Matrix_Unique_ID` = '212930963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:52:01.087' ,`MLSNumber` = '63146946' ,`ListAgentFullName` = 'Willis Jefferys' ,`ListOfficeName` = 'AAMAX, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.145232' ,`Longitude` = '-95.567257' ,`PhotoCount` = '49' ,`PostalCode` = '77375' ,`RoomCount` = '14' ,`ListPrice` = '1849000.00' ,`Status` = 'Active' ,`StreetName` = 'Curly Willow' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Breathtaking Waterfront Home w/Gorgeous Oversized Pool and Hot Tub large enough for 10 people. This Toll Bros. Home Features 2 Separate Covered Outdoor Spaces, great for Entertaining and Dining. The home has 5 Bedrooms, 4 Full Baths, 1 Half bath, 4 Car Garage, 2 Story Ceilings in the Study with Custom Built Ins, Hardwood Floors, Large Island, 6 Burner Gas Cooktop, Double Ovens, Butlers Pantry, Formal Dining Room, Breakfast Room, Large Open Family Room with Gas Log Fireplace and Wall to Ceiling Windows Overlooking the Lake & Pool, Separate Pet Qtrs, First Floor Master Suite with a Coffee Bar, Views of the Lake, Double Doors leading to Covered Patio, Large Walk in Closets, 7\' Soaking Tub, Guest Quarters downstairs with a separate entrance and a private bathroom, 2 Sets of Stairs, 3 Bedrooms Upstairs, with a Separate Sitting Area, A Library, Media Room with Custom Built Ins, Projector Screen TV, ATMOS 7.1 Surround System. This home is a MUST SEE. It is even more stunning in person.' ,`Acres` = '0.2857' ,`Area` = '14' ,`BuilderName` = 'Toll Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 THE WOODLANDS CREEKSIDE PARK WEST SEC 15' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '12443' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Woodlands Creekside Park West Se' ,`TaxAmount` = '26965' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675096562' WHERE `Matrix_Unique_ID` = '212980300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:47:21.700' ,`MLSNumber` = '73347936' ,`ListAgentFullName` = 'Jacob Chackonal' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876887' ,`Longitude` = '-95.133911' ,`PhotoCount` = '10' ,`PostalCode` = '77044' ,`RoomCount` = '11' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Cape Rise' ,`StreetNumber` = '11014' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1188' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 SHELDON RIDGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sheldon Rdg Sec 02' ,`TaxAmount` = '8576' ,`TaxRate` = '3.6393' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096562' WHERE `Matrix_Unique_ID` = '213247414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:46:57.283' ,`MLSNumber` = '7908223' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427395' ,`Longitude` = '-95.454163' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '364990.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia Run' ,`StreetNumber` = '1602' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gated- Home READY NOVEMBER 2022. Nice size rear yard. This Colina Home is 2 stories with 3 bedrooms 2.5 baths and a gameroom. Master down with dining/study option, window coverings, tile backsplash, extensive vinyl wood plank throughout. One of the countries top 25 selling masterplan communities and also the future home of the 1.25 million SF amenity village, anchored by the crystal clear lagoon, a turquoise-blue 5 acre lake with white sand beaches, a beach front clubhouse with a restaurant and fitness center. The celebration lawn, for community events and performances, rental cabanas and a splash pad for the kids. All only 20 minutes from the medical center and only 30 minutes to Downtown Houston. Photos are representative ONLY. Appointments are not required but recommended' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Blk 3 Section 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12304' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096563' WHERE `Matrix_Unique_ID` = '213390309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:47:07.083' ,`MLSNumber` = '73021206' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401017' ,`Longitude` = '-95.668006' ,`PhotoCount` = '49' ,`PostalCode` = '77356' ,`RoomCount` = '11' ,`ListPrice` = '1170000.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Side' ,`StreetNumber` = '18984' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom Waterfront Home on Lake Conroe w/Luxurious Finishes. High ceilings/Travertine Flrs/Over $100K Exotic African Wood is featured throughout this GEM! Chef\'s dream kitchen w/high end appliances, Beautiful countertops &backsplash opens to family room w/lots windows for natural lighting. Awesome backyard features covered patio/outdoor kitchen & lush landscaping. Huge Master Suite fit for king/queen w/masterbath tastefully designed. Upstairs gameroom w/spacious secondary bedrooms w/built-ins. Waterfront home on acres! Open lot, ready for pool. Kitchen has work island & stainless steel appliances. Study is perfect for a home office or 5th bedroom. Large walk in closets in all bedrooms. Covered porch & balcony in rear with water view. Waterproof electric box rear of house for boat dock. Plumbed with water softener loop. Has Engineered/Post tension slab, parking for 3 cars & 1 R V outside garage.' ,`Acres` = '1.433' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOR SIDE 02, BLOCK 1, LOT 10' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '62421' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Harbor Side' ,`TaxAmount` = '12829' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096563' WHERE `Matrix_Unique_ID` = '213932810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:49:16.620' ,`MLSNumber` = '60968215' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048763' ,`Longitude` = '-94.082583' ,`PhotoCount` = '23' ,`PostalCode` = '77705' ,`RoomCount` = '4' ,`ListPrice` = '147500.00' ,`Status` = 'Active' ,`StreetName` = 'Reed' ,`StreetNumber` = '3935' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and see this beautiful home with so much charm! Recently fully remodeled with a fresh and open feel. This home boasts new floors, fresh paint, beautiful new quartz and backsplash in the kitchen. Lovely bathrooms with new tile & tubs and a brand-new A/C unit. Located close to Alice Keith Park with playgrounds, tennis & basketball courts. *Owner Fin. is also available* Call and schedule your appointment today!' ,`Acres` = '0.1653' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FLORENCE L3 B1 N10\' L4 B1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'PIETZSCH-MACARTHUR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Florence' ,`TaxAmount` = '1141' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096563' WHERE `Matrix_Unique_ID` = '213937475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:56:18.137' ,`MLSNumber` = '47845899' ,`ListAgentFullName` = 'Randy Durham' ,`ListOfficeName` = 'M. Moffett & Co. Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.672361' ,`Longitude` = '-94.409745' ,`PhotoCount` = '49' ,`PostalCode` = '75979' ,`RoomCount` = '14' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Shalin' ,`StreetNumber` = '184' ,`StreetSuffix` = 'Circle' ,`City` = 'Woodville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 3BR/3BA waterfront home set on two beautiful, improved cul-de-sac wooded lots (.82 ac) in the private lake side community of Ivanhoe, just 90-minutes from N. Houston! Lovely brick, 2-story 2,944sf home features downstairs master, formal living & dining rooms, kitchen opens to living room and massive 40\' long enclosed sun porch overlooking huge oaks, grassy lawn, & lake. Many custom features include beaded board cabinets & ceilings, pine flooring, bay window, double wood burning fireplace, & other custom touches. Shady lot has over 300\' of concrete bulkhead lake frontage, 2 walk-out piers over clear sandy waters, ideal for fishing or swimming! Multiple outdoor seating areas including wood gazebo and an open rear 32\'x40\' wood deck. Other improvements: RV station, greenhouse, detached 1-car garage, workshop, 2 wood equipment sheds, & numerous patios & boardwalks located throughout. An incredible, attractively improved lake front property set on a private & secluded point!' ,`Acres` = '0.86' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOTS 48 & 49, BLOCK 98, SECTION 7, Lake Charmaine' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Waterfront,Wooded' ,`LotSize` = '37461' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '12' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1012 - Warren' ,`SchoolElementary` = 'WARREN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WARREN HIGH SCHOOL (WARREN)' ,`SchoolMiddle` = 'WARREN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Charmaine' ,`TaxAmount` = '10252' ,`TaxRate` = '3.346' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096563' WHERE `Matrix_Unique_ID` = '214107806' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:04:51.720' ,`MLSNumber` = '69915112' ,`ListAgentFullName` = 'Charles Schrader' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812162' ,`Longitude` = '-95.065317' ,`PhotoCount` = '34' ,`PostalCode` = '77562' ,`RoomCount` = '7' ,`ListPrice` = '474000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue' ,`StreetNumber` = '610' ,`StreetSuffix` = '' ,`City` = 'Highlands' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home located on the San Jacinto River. Home features a double Primary Suite with a 3rd bedroom, 3 full baths, awesome stone accent walls, huge kitchen/ dinning combo , large granite counter tops , indoor utility, Generac Generator, tons of updates, and more. Outside you can sit back and relax on the back porch and watch the sunset and sunrise over the river. On the hot summer days beat the heat and mosquitos while you relax in your enclosed In Ground pool. If all that wasn’t enough then check out the amazing metal shop located just off the pool with showers and a bathroom. Endless possibilities await you and your family.' ,`Acres` = '1.48' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '2008 OAK CREEK 32X78 HUD# NTA1480058/ SERIAL# OC050916910A O' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '64609' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'J White' ,`TaxAmount` = '1712' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096563' WHERE `Matrix_Unique_ID` = '214260515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T12:35:37.007' ,`MLSNumber` = '95436462' ,`ListAgentFullName` = 'Jon Harper' ,`ListOfficeName` = 'Towne Lake Custom Sales, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.056232' ,`Longitude` = '-95.659039' ,`PhotoCount` = '39' ,`PostalCode` = '77377' ,`RoomCount` = '15' ,`ListPrice` = '4950000.00' ,`Status` = 'Active' ,`StreetName` = 'Steeldust' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '9' ,`BathsHalf` = '1' ,`BedsTotal` = '8' ,`SqFtTotal` = '12000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SJS Group, a River Oaks-area builder has outdone himself. 3 Steeldust is a spectacular estate home on a 2-acre+ lake lot in the much-sought-after neighborhood of Willowcreek Ranch. The sprawling home has over 8000 sq. ft. on the first floor and about 4000 sq. ft. upstairs. Features include: Extensive \"Savant\" home automation, large-format porcelain tile flooring throughout, Wolf and SubZero appliances, a 6-car garage, Separate guest home. two elaborate master suites on the first floor plus a luxury guest suite, a huge infinity pool, a mini Master upstairs plus 4 secondary bedroom with ensuite baths,, 4 fireplaces, outdoor living/dining/cooking with fireplace, separate large flex room with full bath down, two gorgeous curved stairways in the Grand Entry plus a back stair, Gamerooms up and down, wet bars up and down, elevator and much, much more. Room sizes are approximate. Please verify. Must have proof of qualification or funds to make an appointment.' ,`Acres` = '2.1356' ,`Area` = '35' ,`BuilderName` = 'SJS Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 & RES B4 BLK 1 WILLOWCREEK RANCH SEC 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '93027' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Spanish' ,`Subdivision` = 'Willowcreek Ranch Sec 3' ,`TaxAmount` = '73709' ,`TaxRate` = '2.7372' ,`WaterSewer` = 'Aerobic,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675096564' WHERE `Matrix_Unique_ID` = '214622405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-28T11:49:53.403' ,`MLSNumber` = '96524283' ,`ListAgentFullName` = 'Derek Boles' ,`ListOfficeName` = 'Legacy Homes & Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887575' ,`Longitude` = '-95.429740' ,`PhotoCount` = '32' ,`PostalCode` = '77088' ,`RoomCount` = '3' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = 'Winter Bay' ,`StreetNumber` = '1802' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tenant Occupied. Gorgeously renovated property in a well established community. Home boasts a grand open floorplan and brand new neutral paint. Additionally a new custom electric fireplace and beautiful new kitchen equipped with classic backsplash and countertops. Primary suite offers an enormous shower in the bathroom and double vanity. Property sits on an XL lot and is nestled on a quiet street. Very close to nearby freeways. Too many upgrades to list. This one will not disappoint. Do not disturb tenants' ,`Acres` = '0.1836' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 56 BLK 12 WILLOW RUN SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Run Sec 05' ,`TaxAmount` = '3964' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675096564' WHERE `Matrix_Unique_ID` = '214829896' --> 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','215139142','1675096564','215139142','2022-12-28T12:00:16.123','818361','Matthew Guzman','RE/MAX Universal','','','29.683942','-95.941750','6','77441','8','321990.00','Active','School Hill','32806','Road','Fulshear','2','1','4','1749','Single-Family','Fulshear Lakes NOW OPEN!!! Welcome home to your beautiful 1 Story, The Kailee Floor Plan, 4 Bedroom, 2 ½ Bath, with an attached 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study/Flex Room, and 4 spacious bedrooms. Tile and Carpet throughout. Sprinkler system & fenced backyard. COST & ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Whole House Tankless Gas Water Heater, & Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. The master-planned community will feature top amenities including front yard maintenance, walking trails, creeks, on-site is the new Fletcher Morgan Jr. Elementary school of LCISD. Easy commutes to Katy, Sugarland, & Houston.','','30','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Fulshear/South Brookshire/Simonton','Central Gas','1','NA','Subdivision Lot','','','','1100','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','MORGAN ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','1','Ranch','Fulshear Lakes','','3.2448','Public Sewer,Public Water,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','215353396','1675096564','215353396','2022-12-28T11:30:18.507','47362056','Chuck Cauthorn','Pro Realty Advisors','','','30.284053','-95.547627','24','77316','7','389500.00','Active','Elderberry Trail','170','','Montgomery','2','0','2','1619','Single-Family','This home with two bedrooms and an optional room used as a private study/guest/flex space is a unique floor plan. The entrance opens to high ceilings, crown molding and gleaming hardwoods. A wonderful open floor plan is great for entertaining. Abundant upgrades which include custom cabinetry, stainless appliances, gas cooktop and beautiful granite counters. Plentiful windows provide tons of natural light throughout the home. The private master suite includes a spa-like master bath with seamless walk-in shower and double vanities. You will love the covered back patio in the privately fenced backyard and the easy walk to the club house and athletic activities.','','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','','0','Conroe Southwest','Central Gas','1','S265900- Bonterra at Woodforest 01, Block 4, Lot 16','Subdivision Lot','5870','Appraisal District','','2675','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','No Appointment Required,Vacant/Unoccupied','Appraisal District','1','Traditional','Bonterra at Woodforest 01','','','Public Sewer,Public Water,Water District','2014','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','215412076','1675096564','215412076','2022-12-28T11:31:19.470','72712596','Cellina Stokes','Crowne Realty','','','30.788656','-95.093533','50','77360','21','2599000.00','Active','FM 3186','2073','','Onalaska','6','2','6','7200','Single-Family','Come live the dream in your Private Luxury Oasis with 233’ of resort style Waterfront on desirable Lake Livingston with 2-slip boat house & pier! 1.76acre property gated & fenced with gorgeous Lake Views. This 2015 work of art boasts a 2-story foyer with exquisite chandelier art piece, curved staircase & elevator. Primary Bdrm has elegant en-suite bathroom, 2 oversized closets & sitting area off both the Great Room & 40’ veranda that overlooks heated infinity pool/hot tub, fire cauldrons, fire pit & lake. Vast Great Room has relaxing fireplace, vaulted ceiling, wet bar & wall of windows; adjacent Media room, gourmet Kitchen & Dining room. 2 walk-in pantries, 1 study nook up. Private bathrooms for all bedrooms. Guest Qtrs w/ full kitchen & bathroom (~285sf); adjacent to Office/Bdrm & Flex Rm (can be used as 2 bdrms) over 2-car garage & climate-controlled shop. Amazing outdoor kitchen with granite bar/counter, under cabinet fridge, grill, gas fireplace, dining area & full bathroom.','1.756382','44','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','2','Lake Livingston Area','Central Electric,Other Heating','0','STANFORD SHORES LOTS 13, 14 & 15','Cleared,Water View,Waterfront','76508','Other','','','0','','2','Double Oven,Gas Oven','1','Gunite,Heated,In Ground','','Gas Range,Grill','','Tile','104 - Onalaska','ONALASKA ELEMENTARY SCHOOL','ONALASKA JR/SR HIGH SCHOOL','ONALASKA JR/SR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Seller','2','Mediterranean','Stanford Shores','39511','1.9726','Water District','2015','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','215450359','1675096564','215450359','2022-12-28T11:24:32.883','27399233','Heather Novicke','Bill Johnson & Assoc. Real Est','','','29.947911','-96.286917','26','77418','5','1749999.00','Active','S Garrett Circle','432','','Bellville','3','1','4','3560','Single-Family','New Build To Be Completed- Masterfully designed Custom home constructed by Willmark Homes. This four bedroom, 3.5 bath European-Style Farmhouse provides for a peace mode of living with exquisite interior spaces enhanced by beautiful views. Superb craftsmanship and abundant amenities combined with natural elements and modern touches such as large floor length windows allowing natural light to radiate throughout the home. The heart of the home\'s kitchen will be finished with top of the line appliances, large island, and a well-appointed pantry. The home has been designed for both easy family living and formal entertaining with an impressive entry surrounded with white oak, home office, media room, and formal dining with fireplace. The primary suite features a generous closet, a stunning bathroom w freestanding tub in shower, dual vanities. The impeccable architectural beauty of this home creates the epitome of timeless modern charm with conveniences throughout.','','57','Willmark','','','','No Disclosures','','','','','Central Electric','1','West Hills Subdivision Lot 30','Subdivision Lot','','','','','1','Never Lived In','2','','0','','','','','Composition','136 - Bellville','WEST END ELEMENTARY SCHOOL','BELLVILLE HIGH SCHOOL','BELLVILLE JUNIOR HIGH','Accompany,Appointment Required','Builder','1','Contemporary/Modern','West Hills','','','Septic Tank','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','215530294','1675096564','215530294','2022-12-28T11:18:34.563','35627673','Ina Shireman','Homes Of Huntsville, Inc','','','30.670667','-95.530490','15','77340','8','285000.00','Active','Waters Edge 18th','134','','Huntsville','2','0','2','1820','Single-Family','','0.0838','43','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Huntsville Area','Central Gas','1','ELKINS LAKE - WATERS EDGE, BLOCK 48, LOT 10','In Golf Course Community,Water View','3651','Appraisal District','','205','0','','2','Electric Oven','0','','','Electric Range','','Composition','64 - Huntsville','ESTELLA STEWART ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Elkins Lake - Waters Edge','4975','1.8868','Public Sewer,Public Water','1995','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','215699698','1675096564','215699698','2022-12-28T12:39:34.027','46205955','Benny Earp','Red Door Realty & Associates','','','30.463320','-94.847486','21','77327','3','335000.00','Active','County Road 2850','330','','Cleveland','1','0','3','1560','Single-Family','What a great place for horses, show animals or farm animals! This mini ranch with lovely rod iron entrance gate, opens up to an extended driveway leading to the middle of the property where the 1560 sq. ft. ranch house is surrounded by 6.2 acres of fenced and cross-fenced, improved land. Strategically placed, ponds, fences, gates and four small pole barns, are just right for, easy keeping, of your animals. Three outside gates make ease of access when pulling trailers or unloading.','6.2','52','','','Electric Dryer Connections,Washer Connections','','No Disclosures','','Wood Burning Fireplace','1','Liberty County East','Central Gas','0','000103 J F DERUMAYOR, TRACT 38, ACRES 6.2','Cleared,Corner','270072','Appraisal District','','','0','','0','Single Oven','0','','','','','Other','107 - Hardin','HARDIN ELEMENTARY SCHOOL','HARDIN HIGH SCHOOL','HARDIN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','1','Ranch','J F Derumayor','4051','1.5764','Septic Tank,Well','1980','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','215824200','1675096564','215824200','2022-12-28T12:19:57.990','27196466','Scott Laird','Keller Williams Woodlands','','','29.352287','-95.046083','29','77563','6','317495.00','Active','Blimp Base','6530','Road','Hitchcock','3','0','4','1871','Single-Family','NO RESTRICTIONS!! GORGEOUS First America Home -- located with easy access to Hwy 6 and a quick commute to I-45 and Galveston Island. Minutes from Hitchcock High School. This 4 bedroom, 3 bath home features -- OPEN family room with SOARING ceilings and RICH LVP flooring throughout! GOURMET GRANITE kitchen with breakfast bar and TONS of cabinet space! PRIVATE upstairs primary retreat with DUAL vanity, separate glass shower + soaking tub and WALK-IN closet! Spacious secondary bedrooms and formal dining room! RELAXING backyard, perfect for entertaining! Enjoy a low TAX RATE, NO RESTRICTIONS, and NO HOA. Call today and schedule your private tour!!!','0.23','33','First America Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Santa Fe','Central Gas','0','MECOM WAY SECTION 01, BLOCK 01, LOT 24','Subdivision Lot','10044','Other','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','2','Traditional','Mecom Way','','2.5','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','215824231','1675096565','215824231','2022-12-28T12:19:30.863','48781239','Scott Laird','Keller Williams Woodlands','','','29.352287','-95.046083','29','77563','6','316320.00','Active','Blimp Base','6538','Road','Hitchcock','3','0','4','1871','Single-Family','NO RESTRICTIONS!! GORGEOUS First America Home -- located with easy access to Hwy 6 and a quick commute to I-45 and Galveston Island. Minutes from Hitchcock High School. This 4 bedroom, 3 bath home features -- OPEN family room with SOARING ceilings and RICH LVP flooring throughout! GOURMET GRANITE kitchen with breakfast bar and TONS of cabinet space! PRIVATE upstairs primary retreat with DUAL vanity, separate glass shower + soaking tub and WALK-IN closet! Spacious secondary bedrooms and formal dining room! RELAXING backyard, perfect for entertaining! Enjoy a low TAX RATE, NO RESTRICTIONS, and NO HOA. Call today and schedule your private tour!!!','0.17','33','First America Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Santa Fe','Central Gas','0','MECOM WAY SECTION 01, BLOCK 01, LOT 22','Subdivision Lot','7595','Other','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','2','Traditional','Mecom Way','','2.5','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','215824304','1675096565','215824304','2022-12-28T12:19:08.430','19662582','Scott Laird','Keller Williams Woodlands','','','29.352287','-95.046083','29','77563','6','317008.00','Active','Blimp Base','6710','Road','Hitchcock','3','0','4','1871','Single-Family','NO RESTRICTIONS!! GORGEOUS First America Home -- located with easy access to Hwy 6 and a quick commute to I-45 and Galveston Island. Minutes from Hitchcock High School. This 4 bedroom, 3 bath home features -- OPEN family room with SOARING ceilings and RICH LVP flooring throughout! GOURMET GRANITE kitchen with breakfast bar and TONS of cabinet space! PRIVATE upstairs primary retreat with DUAL vanity, separate glass shower + soaking tub and WALK-IN closet! Spacious secondary bedrooms and formal dining room! RELAXING backyard, perfect for entertaining! Enjoy a low TAX RATE, NO RESTRICTIONS, and NO HOA. Call today and schedule your private tour!!!','0.17','33','First America Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Santa Fe','Central Gas','0','MECOM WAY SECTION 01, BLOCK 01, LOT 08','Subdivision Lot','7770','Other','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','2','Traditional','Mecom Way','','2.5','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','215825605','1675096565','215825605','2022-12-28T12:18:38.853','60704926','Scott Laird','Keller Williams Woodlands','','','29.352287','-95.046083','30','77563','6','317595.00','Active','Blimp Base','6515','Road','Hitchcock','3','0','4','1871','Single-Family','NO RESTRICTIONS!! GORGEOUS First America Home -- located with easy access to Hwy 6 and a quick commute to I-45 and Galveston Island. Minutes from Hitchcock High School. This 4 bedroom, 3 bath home features -- OPEN family room with SOARING ceilings and RICH LVP flooring throughout! GOURMET GRANITE kitchen with breakfast bar and TONS of cabinet space! PRIVATE upstairs primary retreat with DUAL vanity, separate glass shower + soaking tub and WALK-IN closet! Spacious secondary bedrooms and formal dining room! RELAXING backyard, perfect for entertaining! Enjoy a low TAX RATE, NO RESTRICTIONS, and NO HOA. Call today and schedule your private tour!!!','0.19','33','First America Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Santa Fe','Central Gas','0','MECOM WAY SECTION 01, BLOCK 01, LOT 67','Subdivision Lot','8540','Other','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','2','Traditional','Mecom Way','','2.5','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','215825629','1675096565','215825629','2022-12-28T12:18:14.987','8454096','Scott Laird','Keller Williams Woodlands','','','29.352287','-95.046083','30','77563','6','318320.00','Active','Blimp Base','6534','Road','Hitchcock','3','0','4','1871','Single-Family','NO RESTRICTIONS!! GORGEOUS First America Home -- located with easy access to Hwy 6 and a quick commute to I-45 and Galveston Island. Minutes from Hitchcock High School. This 4 bedroom, 3 bath home features -- OPEN family room with SOARING ceilings and RICH LVP flooring throughout! GOURMET GRANITE kitchen with breakfast bar and TONS of cabinet space! PRIVATE upstairs primary retreat with DUAL vanity, separate glass shower + soaking tub and WALK-IN closet! Spacious secondary bedrooms and formal dining room! RELAXING backyard, perfect for entertaining! Enjoy a low TAX RATE, NO RESTRICTIONS, and NO HOA. Call today and schedule your private tour!!!','0.17','33','First America Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Santa Fe','Central Gas','0','MECOM WAY SECTION 01, BLOCK 01, LOT 23','Subdivision Lot','7452','Other','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','2','Traditional','Mecom Way','','2.5','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','215826405','1675096565','215826405','2022-12-28T12:17:46.923','58118457','Scott Laird','Keller Williams Woodlands','','','29.352287','-95.046083','26','77563','5','302781.00','Active','Blimp Base','6531','Road','Hitchcock','2','0','3','1619','Single-Family','NO RESTRICTIONS!! GORGEOUS First America Home -- located with easy access to Hwy 6 and a quick commute to I-45 and Galveston Island. Minutes from Hitchcock High School. This 3 bedroom, 2 bath home features -- OPEN family room with HIGH ceilings and LVP flooring throughout! GOURMET GRANITE kitchen with breakfast bar and TONS of cabinet space! PRIVATE primary retreat with DUAL vanity, separate glass shower + soaking tub and WALK-IN closet! Spacious secondary bedrooms and formal dining room! RELAXING backyard, perfect for entertaining! Enjoy a low TAX RATE, NO RESTRICTIONS, and NO HOA. Call today and schedule your private tour!!!','0.262','33','First America Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Santa Fe','Central Gas','0','MECOM WAY SECTION 01, BLOCK 01, LOT 63','Subdivision Lot','11424','Other','','','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Range','','Composition','45 - Santa Fe','DAN J KUBACAK ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Mecom Way','','2.5','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','215827582','1675096565','215827582','2022-12-28T12:19:04.750','28404343','Amberly Savage','Ward Real Estate, Inc','','','28.837228','-95.930797','38','77414','3','475000.00','Active','Fm 521','20767','','Wadsworth','2','0','3','1847','Single-Family','Country living at it\'s best! This property features a 3 bed 2 bath home with a fully remodeled kitchen. Property boasts 10.73 acres, several barns, show stalls, small pond for livestock and detached garage that was recently remodeled into second living quarters with 1 bed / 1 bath at 644 sqft per CAD. Roof, septic and central HVAC have all been updated within the last 4 years and much more.','10.73','54','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Electric','0','B F JACQUES J H OTTIS PTN AB 52 PT TR 2 2.463 & 8.2670 AC','Cleared','107288','Appraisal District','','','0','','0','','0','','','Gas Cooktop','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Lockbox Left Side,Vacant/Unoccupied','Appraisal District','1','Traditional','B F Jacque Colonial Land Sub','3201','2.0354','Aerobic,Public Water','1980','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','215861423','1675096565','215861423','2022-12-28T12:43:12.140','4250095','Feras Rachid','Opendoor Brokerage, LLC','','','30.303141','-95.493431','21','77304','3','290000.00','Active','Tupelo','204','Lane','Conroe','2','0','3','1518','Single-Family','Welcome to this fabulous area! This home has fresh interior paint. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. Step into the kitchen, complete with an eye catching stylish backsplash. Relax in your primary suite with a walk in closet included. Other bedrooms provide nice flexible living space. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Step outside to the pristinely maintained fenced in backyard with pool, great for entertaining. If the shade is more your style, hang out under the covered sitting area. A must see! This home has been virtually staged to illustrate its potential.','0.3472','19','','','','','Sellers Disclosure','1','','1','Conroe Southwest','Central Gas','0','GARWOOD HILLS, LOT 37','Subdivision Lot','15126','Appraisal District','','','0','','2','','1','In Ground','','','','Wood Shingle','11 - Conroe','RICE ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','1','Traditional','Garwood Hills','3872','2.1863','Public Water','1983','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215886132','1675096565','215886132','2022-12-28T11:19:02.720','65311656','Jared Turner','Turner Mangum,LLC','','','29.864700','-95.282900','26','77016','3','249940.00','Active','Vinca Minor','10539','Lane','Houston','2','0','3','1362','Single-Family','The Mitchell floorplan showcases 3 bedrooms 2 full bathrooms and a 2 car garage! This open concept kitchen is full of high quality cabinetry, a pantry and a large eating area that is blanketed with natural lighting illuminating from the breakfast area windows. It is completed with hard surface flooring throughout the common areas. And for family fun times, it has an amazing covered front porch and back patio that comes standard with this home.','','2','Rausch Coleman Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Northeast Houston','Central Gas','1','5/3','Cul-De-Sac,Subdivision Lot','','','','375','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','SHADYDALE ELEMENTARY','NORTH FOREST HIGH SCHOOL','FOREST BROOK MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Wayside Village','','3.13','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','215886239','1675096565','215886239','2022-12-28T12:07:06.267','66734951','Isela Yilmaz','Executive Texas Realty','','','30.423286','-95.610354','41','77356','11','669000.00','Active','Edgewood','450','Drive','Montgomery','3','1','4','3492','Single-Family','This FABULOUS TWO STORY has VIEWS of Lake Conroe. The lot is set up on a hill and finds itself among many and large beautiful homes in the prestigious Bentwater Subdivision. \r\n\r\nELEGANT and COMFORTABLE enough for everyday living. This 4 BED/3.5BATH amazes with gorgeous sweeping staircase. GOURMET KITCHEN is equipped with generous ISLAND with QUARTZ countertops and opens up to the breakfast and LIVING providing a wonderful entertaining space with HIGH CEILINGS. Impressive primary bedroom and in-suite BATH offers a separate shower and soaking tub, oversized WALK-IN closet leading conveniently to the LAUNDRY room. GUEST ROOM with full bathroom on first floor for your guests and TWO secondary bedroom upstairs; GAMEROOM and MEDIA ROOM! 3-CAR GARAGE and professional landscape throughout.\r\n\r\nAside from the pools, tennis courts, GOLF courses and MARINA, you can fill your day with book clubs, bridge clubs, wine clubs, etc. Come out today to see this gorgeous property!','0.2493','39','Cubic G Homes','','','','Mud','1','','','Lake Conroe Area','Central Gas','1','S261504 - BENTWATER 04, BLOCK 2, LOT 16','In Golf Course Community,Subdivision Lot','10861','Appraisal District','','1326','1','Never Lived In','2','Electric Oven','0','','','','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Bentwater 04','595','2.1898','Public Sewer,Water District','2022','Builder'); --> New record created successfully