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-10-27T06:57:26.697' ,`MLSNumber` = '86094189' ,`ListAgentFullName` = 'Jorge Llanas' ,`ListOfficeName` = 'David Hulsey, REALTORS ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781812' ,`Longitude` = '-95.351109' ,`PhotoCount` = '6' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property being sold for lot value only. Buyers do your own due-diligence regarding the structure on the property.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 37 LITTLE & DICKINSON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Little & Dickinson' ,`TaxAmount` = '5250' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946335' WHERE `Matrix_Unique_ID` = '201331760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:27:09.057' ,`MLSNumber` = '47925248' ,`ListAgentFullName` = 'Cheryn Reynolds' ,`ListOfficeName` = 'Ameristar, REALTORS' ,`SellingAgentFullName` = 'Julissa Alcantar-Martinez' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.932936' ,`Longitude` = '-95.514393' ,`PhotoCount` = '11' ,`PostalCode` = '77086' ,`RoomCount` = '7' ,`ListPrice` = '179900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Galena Creek' ,`StreetNumber` = '13646' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Kitchen and dining rooms are open to the living room making for a spacious living space. Covered patio just off dining area makes entertaining easy. The game room is just at the top of the stairs. The primary bedroom features an en-suite bath with beautifully tiled shower. Next door is the neighborhood park! Easy access to Beltway 8 and SH 249. This property is eligible under the First Look Initiative which expires after 20 full days on market. No investor offers until first look period expires. No offers, regardless of buyer type, will be negotiated within the first 7 days of listing. Multiple offers received.' ,`Acres` = '0.0937' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 1A & 2A BLK 1 BLUE CREEK PAR R/P' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '4080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Blue Creek' ,`TaxAmount` = '4690' ,`TaxRate` = '2.6745' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946335' WHERE `Matrix_Unique_ID` = '202849418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:55:58.173' ,`MLSNumber` = '21900477' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822799' ,`Longitude` = '-95.414835' ,`PhotoCount` = '18' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '619900.00' ,`Status` = 'Active' ,`StreetName` = 'Fisher' ,`StreetNumber` = '805-A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Independent drive, first floor living, elevator capable, backyard, chef’s kitchen, grand master suite, large closet & game room. \r\nSpacious home with timeless architecture, thoughtful design, exquisite finishes, tastefully executed intricate craftsmanship. \r\nThis home is designed to a be hardworking, functional yet elegant show home. Let it showcase your lifestyle.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'TITAN HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 8, BLK 1' ,`LotDesciption` = 'Other' ,`LotSize` = '2364' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish,Traditional' ,`Subdivision` = 'Oak Park South' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946335' WHERE `Matrix_Unique_ID` = '205309581' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:58:27.367' ,`MLSNumber` = '86364355' ,`ListAgentFullName` = 'Regina Kirk' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = 'Tammy Tinkle' ,`SellingOfficeName` = 'RE/MAX One' ,`Latitude` = '30.107533' ,`Longitude` = '-94.150457' ,`PhotoCount` = '40' ,`PostalCode` = '77706' ,`RoomCount` = '3' ,`ListPrice` = '345000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Thomas' ,`StreetNumber` = '4425' ,`StreetSuffix` = 'Lane' ,`City` = 'Beaumont' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated one-story home in The Park on Thomas Road. Open living/dining area that is great for entertaining with a gas log fireplace. Large sliding glass patio doors, skylight, and high ceilings offer great natural lighting. Updated with modern Luxury Vinyl Flooring and LED lighting. Kitchen includes Stainless Apron Sink, Butcher Block Style Countertops, Quartz waterfall breakfast bar, and Jenn Air Electric Cooktop. Primary bedroom includes 2 updated primary bathrooms (one with jetted tub, one with walk-in shower) with walk-in closets in each. Two other bedrooms are located away from primary bedroom with updated shared bathroom in between. Laundry room with 1/2 bath and ample storage. Bar area with beverage cooler. Shutters throughout the home. HOA fees provide access to pool and tennis courts. Conveniently located to shopping and Interstate 10 access. Refrigerator, washer, and dryer included.' ,`Acres` = '0.1776' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE PARK ON THOMAS ROAD-2 L2 B6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7738' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park On Thomas Road' ,`TaxAmount` = '8134' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946335' WHERE `Matrix_Unique_ID` = '206386686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:40:46.707' ,`MLSNumber` = '27686214' ,`ListAgentFullName` = 'Jeffrey Shaddix' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.774927' ,`Longitude` = '-95.631961' ,`PhotoCount` = '18' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '299997.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 201' ,`StreetNumber` = '839' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETELY REMODELED waterfront 3/2 just a very short boat ride from the ICW, Caney Creek and East Matagorda Bay! Rivals new construction! Almost everything is new in 2021/2 - roof, windows, flooring, kitchen and bath cabinets, granite countertops in kitchen and both bathrooms, glass tile backsplash in kitchen, stainless steel appliances, mini-split ACs in each bedroom and living room for efficiency and ability to zone A/C and heat where desired, sheetrock, doors, supply plumbing (Pex), water heater. LED flush ceiling lighting with dimmers in every room, interior/exterior paint, baseboards and trim, etc. Entire area below house is concrete for downstairs enjoyment. Asphalt road from highway to home and great neighbors would make this an awesome Airbnb/VRBO home! Owner/agent' ,`Acres` = '0.1263' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'DOWNEY CANEY CREEK SEC 2, BLOCK 2, LOT 79' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '12' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Downey Caney Creek Sec 2' ,`TaxAmount` = '4382' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946335' WHERE `Matrix_Unique_ID` = '207705599' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:28:21.020' ,`MLSNumber` = '50076808' ,`ListAgentFullName` = 'Grace Reutzel' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.228708' ,`Longitude` = '-95.352211' ,`PhotoCount` = '28' ,`PostalCode` = '77534' ,`RoomCount` = '4' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue I' ,`StreetNumber` = '1411' ,`StreetSuffix` = '' ,`City` = 'Danbury' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1699' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETED New Construction Home! Don\'t miss your chance to enjoy the peace of mind and energy savings a brand-new home offers! The floor plan is perfect for those who like to entertain, with a large open living and dining area that flows into the kitchen and then out to the spacious backyard. The high ceilings and large windows let in plenty of natural light. You\'ll love the convenience of the two-car garage and the extensive primary suite with two walk-in closets and a double vanity sink. Exterior features James Hardie cement board, brick, Architectural Shingles, and covered porch. The Interior features 9 ft ceilings, granite countertops, a walk-in pantry, stainless appliances, a single basin sink on the kitchen island, LED lighting throughout, and so much more. This home is move-in ready, so don\'t wait - call today, and let\'s explore what new construction living can look like for you! Be sure to tour the 3D Walkthrough Tour.' ,`Acres` = '0.1664' ,`Area` = '5' ,`BuilderName` = 'Award Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DANBURY BLK 105 LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Danbury' ,`TaxAmount` = '563' ,`TaxRate` = '2.8783' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946336' WHERE `Matrix_Unique_ID` = '209096264' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:44:38.453' ,`MLSNumber` = '39787761' ,`ListAgentFullName` = 'Pamela Hughes' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.988003' ,`Longitude` = '-95.512891' ,`PhotoCount` = '27' ,`PostalCode` = '77069' ,`RoomCount` = '10' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Erica' ,`StreetNumber` = '13606' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate home in highly sought after Huntwick Forest. Come see this four bedroom two and a half bath home that is perfect or those that like to entertain. Here you will find lofted ceilings, wood flooring, updated pex piping and a great floor plan. Step inside to the living and dining room area all adjacent to the kitchen with lots of counter space and a bright breakfast room overlooking the backyard. Entertain in the family room with its warm glowing fireplace and lofted ceilings. There is a ton of privacy in the huge downstairs game room surrounded by large windows also with lofted ceilings. A fun space to make family memories. Upstairs find four large bedrooms with tons of closet space. Outside you will find a tranquil environment with lots of privacy, NO back neighbors! Brand new HVAC installed July 2022! Don\'t forget the highly acclaimed \"A\" rated Cy-Fair ISD!' ,`Acres` = '0.2204' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 6 HUNTWICK FOREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '158' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest Sec 02' ,`TaxAmount` = '5684' ,`TaxRate` = '2.4306' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946336' WHERE `Matrix_Unique_ID` = '209255720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:35:14.680' ,`MLSNumber` = '60708703' ,`ListAgentFullName` = 'Deborah Elizondo' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668494' ,`Longitude` = '-95.146037' ,`PhotoCount` = '6' ,`PostalCode` = '77503' ,`RoomCount` = '6' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Randolph' ,`StreetNumber` = '2910' ,`StreetSuffix` = 'Road' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a great place to call home? Come check out this 4 bedroom, 2 bath home centrally located minutes away from I-45, 225 and the Beltway. This home features an open floor plan with crown molding through out , kitchen complete with solid wood cabinets, granite countertops, tiled backsplash. There is ceramic tile flooring throughout the whole house. Large oversized unrestricted lot with a shady back yard perfect for entertaining or relaxing, plenty of room for parking. No HOA. Schedule your appointment today!! \r\nAll information such as measurements, square footage and description of materials, fixtures or other components of the improvements may not be accurate and should not be relied upon. Buyer should independently verify prior to purchasing.' ,`Acres` = '0.4752' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 77 BLK 2 KINGSDALE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'GOLDEN ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'BONDY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsdale' ,`TaxAmount` = '2136' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946336' WHERE `Matrix_Unique_ID` = '209902705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:09:21.913' ,`MLSNumber` = '35711046' ,`ListAgentFullName` = 'Gwendlyn Key Willis' ,`ListOfficeName` = 'Key, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192586' ,`Longitude` = '-95.184126' ,`PhotoCount` = '16' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine' ,`StreetNumber` = '24761' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This one is for the handyman. This property flooded in Harvey and Imelda. The interior is down to the studs. Tile flooring throughout looks to be in good condition. There are utilities on in the home. There are no restrictions, No HOA. Low Tax rate.' ,`Acres` = '0.568' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PEACH CREEK COLONY, BLOCK 2, LOT 3,4 AND 20, ACRES1.285' ,`LotDesciption` = 'Corner' ,`LotSize` = '24742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Peach Creek Colony' ,`TaxAmount` = '1038' ,`TaxRate` = '2.3341' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946336' WHERE `Matrix_Unique_ID` = '210127070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:40:05.303' ,`MLSNumber` = '98276366' ,`ListAgentFullName` = 'Rachel Bolton' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659206' ,`Longitude` = '-95.689475' ,`PhotoCount` = '50' ,`PostalCode` = '77407' ,`RoomCount` = '14' ,`ListPrice` = '739000.00' ,`Status` = 'Active' ,`StreetName` = 'Bland Mills' ,`StreetNumber` = '17402' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find of a Coventry 6br/5.5bth/2 car garage on a corner lot at the award-winning Aliana community. This huge 2- story home w/brick & stone exterior, open concept, tons of storage space, spa/pool, fireplace in family room, large game room, covered balcony & a bonus of 2 bedrooms downstairs w/en-suite bathrooms. Beautiful wrought iron staircase gives your foyer the \"Wow\" factor! Dining room & living room are off the entry. A flex room behind the kitchen can also be an office. Huge family room has a high ceiling w/an open concept to your chef-style kitchen & breakfast area. Huge family room w/wall of windows for natural sunlight & gas log fireplace w/detailed wood mantle/trim. Entertaining will be so easy in this area. Your gourmet kitchen will not disappoint \r\nw/granite counters, pendant lighting over your island, walk-in pantry, tons of storage & counter space. 4 bedrooms are upstairs, the other bathrooms & spacious game room! Enjoy your backyard w/pool, spa & outdoor kitchen!' ,`Acres` = '0.2323' ,`Area` = '37' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 10, BLOCK 4, LOT 8' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana' ,`TaxAmount` = '17131' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946336' WHERE `Matrix_Unique_ID` = '210139848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:43:46.117' ,`MLSNumber` = '51205452' ,`ListAgentFullName` = 'Eduardo Garcia' ,`ListOfficeName` = 'Las Lomas Realty Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812100' ,`Longitude` = '-95.722060' ,`PhotoCount` = '19' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Sun Glen' ,`StreetNumber` = '3031' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is a 4 bedroom 2.5 bath in a corner lot nice big yard for the family. Close to shopping and major freeways very open living area. All rooms upstairs. A/C and Roof approximately 3-4 yrs old.' ,`Acres` = '0.1539' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 2 SUNDOWN GLEN SEC 6 AMEND' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6703' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'STEPHENS ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sundown Glen Sec 06 Amd' ,`TaxAmount` = '5395' ,`TaxRate` = '2.9983' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946336' WHERE `Matrix_Unique_ID` = '210352161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:03:46.163' ,`MLSNumber` = '70628796' ,`ListAgentFullName` = 'Rebecca Atkinson' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695982' ,`Longitude` = '-95.165217' ,`PhotoCount` = '27' ,`PostalCode` = '77503' ,`RoomCount` = '6' ,`ListPrice` = '237900.00' ,`Status` = 'Active' ,`StreetName` = 'Cedarcrest' ,`StreetNumber` = '3305' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Turnkey ready 4-bedroom 2 bath one story home located in Tanglebriar Subdivision. Luxury Vinyl wood flooring throughout, completely remodeled kitchen with quartz countertops, updated cabinets, stainless steel appliances and recessed lighting. Primary bath has his and her sinks, walk in closet and walk in shower. One of the secondary bedrooms is so large it could be used as a game room/study/exercise room. There is a 2-car garage which is perfect for extra storage or a place to hang out. This is a must see!! New Ac unit 9/22 and roof replaced 10/22.' ,`Acres` = '0.1808' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 9 TANGLEBRIAR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MCMASTERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SANJACINTO INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglebriar Sec 02' ,`TaxAmount` = '4460' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946337' WHERE `Matrix_Unique_ID` = '210495505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:15:10.577' ,`MLSNumber` = '79675988' ,`ListAgentFullName` = 'D\'Adrienne Truitt-Sweatt' ,`ListOfficeName` = 'Sapphire Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.023553' ,`Longitude` = '-95.605692' ,`PhotoCount` = '28' ,`PostalCode` = '77422' ,`RoomCount` = '4' ,`ListPrice` = '287000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 686' ,`StreetNumber` = '2708' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4 bedroom 2 bath home is situated on one acre in the Sweeny school district. Enjoy country living nestled in the peaceful backdrop of Brazoria. A few of the items that make this home desirable are loads of upgrades including a chef\'s kitchen, three-car garage, custom shower, large living areas, fruit and pecan trees, new roof, new siding, new fixtures throughout, and fresh paint. The rear of the property meets trails for your enjoyment. New aerobic septic systems were installed in 2012, a new ac unit in 2013, and all plumbing was replaced in 2014. Contact Sapphire Realty to set your showing appointment!' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIS S/D SE 1/2 10-11 (A0138 S M WILLIAMS), LOT 44, ACRES 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Davis Sub Se 1/2 10-11' ,`TaxAmount` = '3063' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946337' WHERE `Matrix_Unique_ID` = '211056012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:51:00.327' ,`MLSNumber` = '71880342' ,`ListAgentFullName` = 'Mary McKinney' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511116' ,`Longitude` = '-95.051124' ,`PhotoCount` = '39' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '629000.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Bay' ,`StreetNumber` = '1018' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKE LOT WITH POOL IN THE LAKES OF SOUTH SHORE...MOVE-IN READY! LIGHTEN, BRIGHTEN and ELEVATE your mood in this beautiful home! 4/3.5/2 Large Den with Picture Windows looks out on Pool/Spa/Fountains in backyard with Greenbelt access. Primary Down w/Lake View, Separate Closets. Eat-In Kitchen, Formal Dining, Formal Living/Office Area. Media & Game Rooms up with Catwalk to 3 Bedrooms. Custom Light Fixtures throughout. Lots of Closets throughout and Attic Decked for Storage. Roof replaced 2021, A/C replaced 2019. Carpet replaced with paint updates 9/2022. Pool Coping/Stones reset 8/2022. Refrigerator/Washer/Dryer remain. Must-see to experience the true beauty of this home! (Backyard Pool & Waterfalls Video in links)' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE HARBOUR' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Waterfront' ,`LotSize` = '9332' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '907' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Harbour' ,`TaxAmount` = '12382' ,`TaxRate` = '2.452' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946337' WHERE `Matrix_Unique_ID` = '211180147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:37:00.930' ,`MLSNumber` = '69327957' ,`ListAgentFullName` = 'Livee Gao' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635824' ,`Longitude` = '-95.814486' ,`PhotoCount` = '13' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '353000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Deer Lane' ,`StreetNumber` = '4927' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lowest price for a beautiful new home with water view! Large back yard. Kitchen opens to family room. Huge walk-in pantry. All big bedrooms upstairs. Lots of windows in game room. Extra storage space in garage. Garage door opener. A must see!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT4, BLK2' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Run Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.922' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946337' WHERE `Matrix_Unique_ID` = '211623785' --> 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','211683282','1666946337','211683282','2022-10-27T06:43:21.063','49012059','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518531','-95.783973','7','77471','10','410000.00','Active','Rock Ledge','3712','Drive','Rosenberg','3','1','4','2743','Single-Family','NEW! Lennar Fairway Collection \"Wakefield\" Plan with Elevation \"F\" in in Sendero! The beautiful two-story Wakefield floor plan by Lennar features an inviting front porch and entry foyer, a dining room, a kitchen with a pantry and adjoining breakfast nook that offers access to a covered rear patio, a family room and a walk-in utility room. The first floor master bedroom features an en suite master bathroom with dual sinks, stand-up shower, a private toilet enclosure, and a generous master closet. The second floor features a spacious game room, three additional secondary bedrooms, and two full bathrooms. *HOME ESTIMATED TO BE COMPLETE, AUGUST, 2022*','','30','Lennar','','','','Mud,Other Disclosures','1','','0','Fort Bend South/Richmond','Central Gas','1','SEC 0002 BLK 003 LOT 013','Subdivision Lot','','','','756','1','Never Lived In','2','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Sendero','','3.09','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:49:56.143' ,`MLSNumber` = '46073738' ,`ListAgentFullName` = 'Dulce Gonzalez' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.976502' ,`Longitude` = '-95.518196' ,`PhotoCount` = '49' ,`PostalCode` = '77066' ,`RoomCount` = '11' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Templegate' ,`StreetNumber` = '5926' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your home is waiting come see this beautiful and renovated home, this home has new AC, new roof, new wood floors, new island kitchen with granite new cabinmates and open concept to family room and dining room, natural lighting, all bathrooms had Ven remodel, beautiful front porch and a Great outdoors with your own private pool and plenty yard for the kids and entertain your family, has a new driveway with design, garage for 4 cars, in a very nice subdivision, close to shopping, medical don\'t miss this is a must see property PICTURES WILL BE UPLOODED SATURDAY' ,`Acres` = '0.2655' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 017*G6652900-001-001-007 GREENWOOD FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11566' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'GREENWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Greenwood Forest Sec 01' ,`TaxAmount` = '5311' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946338' WHERE `Matrix_Unique_ID` = '211822916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:49:39.577' ,`MLSNumber` = '6481528' ,`ListAgentFullName` = 'Christopher Case' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Sergio Guzman' ,`SellingOfficeName` = 'RE/MAX Pearland' ,`Latitude` = '29.668614' ,`Longitude` = '-95.634303' ,`PhotoCount` = '31' ,`PostalCode` = '77498' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hollow Canyon' ,`StreetNumber` = '10218' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! 3 Bedroom / 2 full bath / 2 car garage home located in Townewest Neighborhood and zoned to Fort Bend ISD. This newly renovated home features nice white kitchen cabinetry and a stove with sizeable counter space. This beautiful home has nice laminate wood flooring. The family room has a nice large window allowing the natural light to shine through. A spacious master suite and master bath that includes a new shower bath combo. The house has a new roof and a fresh coat of paint inside and out. Most electrical plugs have been replaced. Pex piping has been added to the showers and boiler. Located minutes to the major roads like Highway 6, Westpark, and 59. Excellent location close to West Oaks and First Colony Malls, excellent Fort Bend schools. Townewest amenities include a swimming pool, tennis court, and park. UPDATE Laminate wood floors in Bedrooms. Bathrooms upgraded.' ,`Acres` = '0.188' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TOWNEWEST SEC 4, BLOCK 9, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8190' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'TOWNEWEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Townewest Sec 4' ,`TaxAmount` = '3369' ,`TaxRate` = '2.3329' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946338' WHERE `Matrix_Unique_ID` = '211891634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:23:12.860' ,`MLSNumber` = '25805595' ,`ListAgentFullName` = 'David Morris' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.870066' ,`Longitude` = '-95.797257' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Blairburry' ,`StreetNumber` = '24403' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for an elegant home? Spacious enough that the whole family can enjoy? Take a look at this Sophisticated masterpiece. This gorgeous Newly Built HOME has everything you can imagine. Featuring a beautiful walk in entrance, stylish kitchen, built-in oven/ microwave, and designer light features, including. Walk-in pantry & to make it better, high-quality appliances included. Beautiful high ceilings with large windows. This beautiful home offers 5 beds, 4baths, and an entertainment media room. The main room features tons of natural light. On the second floor, you will find a large game room area, you will also find two bedrooms. A spacious backyard with a large patio cover. There is so much to this home that you have to come to see for yourself.' ,`Acres` = '0.3253' ,`Area` = '25' ,`BuilderName` = 'Castle Rock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 2 (PURE ACCT*1397770020047) KATY LAKES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14172' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Lakes Sec 1' ,`TaxAmount` = '3799' ,`TaxRate` = '3.4868' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666946338' WHERE `Matrix_Unique_ID` = '212196338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:58:46.973' ,`MLSNumber` = '90879244' ,`ListAgentFullName` = 'Maricela Olivo' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728997' ,`Longitude` = '-95.359793' ,`PhotoCount` = '7' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Sauer' ,`StreetNumber` = '3403' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1769' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0608' ,`Area` = '4' ,`BuilderName` = 'Navarro Constuction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9B & 10A BLK 4 FOREST HOME' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Home' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946338' WHERE `Matrix_Unique_ID` = '212450798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:04:24.913' ,`MLSNumber` = '25816069' ,`ListAgentFullName` = 'Waynea Sheffield' ,`ListOfficeName` = 'A Action Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.928117' ,`Longitude` = '-95.364902' ,`PhotoCount` = '6' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '194900.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Oaks' ,`StreetNumber` = '1657' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Horse heaven! Very nice 5.24 acres with small pond, stables, and barn. Over 4,000 sq ft. 6 Bedroom, 4 Baths, 2 wood burning fireplaces. Made up by connecting 2 Manufactured Homes. Possible to close off hallway to one home and rent. Has two kitchens, two living rooms, sunroom, and large covered porch. Conveniently located just a few minute drive to shopping, restaurants, and schools.' ,`Acres` = '5.24' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'TWIN OAKS, LOT 13 LABEL # RAD0955866' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '228254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Twin Oaks' ,`TaxAmount` = '4212' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946338' WHERE `Matrix_Unique_ID` = '212456729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:56:06.877' ,`MLSNumber` = '16389109' ,`ListAgentFullName` = 'Sherry Bruno' ,`ListOfficeName` = 'Lake Area Homes, Bruno Realty, LLC' ,`SellingAgentFullName` = 'Denise Crawford' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '30.801431' ,`Longitude` = '-95.178458' ,`PhotoCount` = '26' ,`PostalCode` = '77364' ,`RoomCount` = '4' ,`ListPrice` = '229900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Woodland Shores' ,`StreetNumber` = '240' ,`StreetSuffix` = 'Drive' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful New Build in Lake Front Community. Property is almost an acre of land backing up to a wooded raven for privacy. This spacious 3-bedroom 2 bath home has a metal roof, waterproof flooring, granite counter tops, large walk-in closet in master bedroom, nice size walk-in shower and double sinks in master bath. A/C Unit is a 4-ton unit. The kitchen/dining/living rooms have an open concept floorplan, island in kitchen with granite countertops. The high vaulted ceilings give this home that Hugh open feel. All bedrooms have custom coffin ceilings. Most appliances come with home. Nice private backyard. Neighborhood amenities include, pool, boat ramp, fishing pier, basketball court, over water covered fishing pavilion, park and large cover pavilion overlooking Lake Livingston. Come see this new build on Beautiful Lake Livingston!' ,`Acres` = '0.81' ,`Area` = '64' ,`BuilderName` = 'New Home Builder LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODLAND SHORES, SEC A OF HVL, LOT 326 & 327, HUD# PFS090043' ,`LotDesciption` = 'Corner,Ravine,Subdivision Lot' ,`LotSize` = '35414' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '437' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Shores, Sec A Of Hvl' ,`TaxAmount` = '1769' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946339' WHERE `Matrix_Unique_ID` = '212462322' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:52:53.627' ,`MLSNumber` = '36323555' ,`ListAgentFullName` = 'Nikki Simpson' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752847' ,`Longitude` = '-95.483152' ,`PhotoCount` = '20' ,`PostalCode` = '77057' ,`RoomCount` = '7' ,`ListPrice` = '539000.00' ,`Status` = 'Active' ,`StreetName` = 'Augusta' ,`StreetNumber` = '5811' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2 story Stucco well maintained home in the private & gated community Augusta Court near the highly coveted Post Oak, Tanglewood & Galleria areas. Soaring ceilings, Oak hardwood & Slate floors downstairs. Elegant crown molding & Plantation shutters throughout, Formal living room w/ cozy wood burning fireplace, Formal dining room, spacious kitchen w/ island & gas cooktop, breakfast bar, family room, ample storage & cabinet space, undercabinet lighting, & dedicated desk area. Lovely patio area accessed from the kitchen and family room flows for al fresco dining and entertaining. Generously appointed Primary suite upstairs with expansive His and Her closet spaces w/ built ins, double sinks, vanity area & sumptuous jetted tub + separate shower. Laundry room is conveniently located on the 2nd floor with built-in cabinets for ample storage. Large secondary bedrooms w/ walk in closets adjoined by Jack & Jill bathroom with double sinks. Never flooded!' ,`Acres` = '0.0514' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 AUGUSTA COURT' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Augusta Court' ,`TaxAmount` = '10384' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946339' WHERE `Matrix_Unique_ID` = '212860296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:54:14.163' ,`MLSNumber` = '7266636' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.387504' ,`Longitude` = '-95.312244' ,`PhotoCount` = '15' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Williams' ,`StreetNumber` = '10660' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INCREDIBLE OPPORTUNITY! SUPER PRIVATE 4.5 ACRE (per MCAD) SETTING! Unfinished 5,000 SqFt (per Builder) 1.5 Story Home - Finish to Your Specifications! Roof, Plumbing, Windows, & Septic Already in Place! Building Plans Available - 5/6 Bedrooms, 3 Full Baths, Extra Room/Play Room/Study Downstairs, & Huge Upstairs Loft/Bedroom with Adjoining Full Bath! 12\' Ceilings Downstairs, 10\' Ceilings Upstairs! Gated Entrance! Four Car Porte-Cochere! Cleared, Expansive 4.5 Acre Lot! Horses Allowed! Great Location with Easy Access to 105, I-45, & Lake Conroe! Super Low Tax Rate - No MUD Tax! No HOA Fees!' ,`Acres` = '4.5' ,`Area` = '19' ,`BuilderName` = 'G. Gagliardi' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S205700 - WESTON ESTATES, BLOCK 1, LOT 1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '196020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Weston Estates' ,`TaxAmount` = '1165' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946339' WHERE `Matrix_Unique_ID` = '212866003' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:42:42.080' ,`MLSNumber` = '13399821' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904512' ,`Longitude` = '-95.734231' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '7' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Zota' ,`StreetNumber` = '8407' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Wildflower Collection \"Brenham II\" Plan with Elevation \"B\" in Marvida! This spacious, single-story home features a large family room, a kitchen with a center island and an adjoining breakfast space that overlooks a covered patio. The owner’s suite enjoys bay windows and a private entry that leads to a second walk-in closet and a laundry room. *HOME ESTIMATED TO BE COMPLETE, NOVEMBER, 2022*' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0005 BLK 002 LOT 030' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946339' WHERE `Matrix_Unique_ID` = '212932029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:48:04.683' ,`MLSNumber` = '36505436' ,`ListAgentFullName` = 'Renee Canady' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857594' ,`Longitude` = '-95.694090' ,`PhotoCount` = '27' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Shining Leaf' ,`StreetNumber` = '6007' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous remodeled 3 bedroom 2 bathroom home. This lovely home has 2022 roof and flooring, recess lighting all throughout, 2022 stainless steel appliances, fresh interior paint and insulated garage door. Enjoy this beautiful kitchen with granite countertops, 42\' cabinets with under cabinet lightening, and custom built kitchen sink. NO flooding per seller. Primary bedroom includes his/her vanity sink with separate jetted tub and standing shower. Schedule time to see this beautiful home for yourself! :) **Ask about our washer and dryer**' ,`Acres` = '0.1205' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 2 BRENWOOD SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brenwood' ,`TaxAmount` = '4260' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946339' WHERE `Matrix_Unique_ID` = '212953965' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:43:40.500' ,`MLSNumber` = '83763856' ,`ListAgentFullName` = 'Eric Beeler' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.011975' ,`Longitude` = '-95.471203' ,`PhotoCount` = '32' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Amcreek' ,`StreetNumber` = '16314' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this fully remodeled 1 story Gem on nearly ½ acre in the established Bammel Forest. Step inside from your large front covered patio and find large windows and open space. This spacious home has 4 bedrooms, 2.5 bathrooms and a built in generator. The Kitchen is the true stand out in this home. Custom cabinets with gorgeous Granite counter tops. So much storage with space to prepare and entertain. There is an eat in area for a breakfast table as well. There is a formal living room and a family room with built in cabinets and a dining area. All bedrooms have ample closet space as well as multiple storage closets in the hall. The primary bedroom boasts an ensuite bathroom with walk in shower and huge closet. But the BEST feature is the screened in pool with covered patio, so much room for fun and family! And still so much greenspace to run and play in the yard. Outdoor mancave/workshop with a/c completes the outdoors. Come see this Beautiful Home today.' ,`Acres` = '0.5165' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BAMMEL FOREST SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '22500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PONDEROSA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bammel Forest Sec 01' ,`TaxAmount` = '3986' ,`TaxRate` = '2.0892' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946340' WHERE `Matrix_Unique_ID` = '213043033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:04:34.270' ,`MLSNumber` = '57645782' ,`ListAgentFullName` = 'Robbie Nelson' ,`ListOfficeName` = 'RE/MAX Crossroads Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402619' ,`Longitude` = '-95.144974' ,`PhotoCount` = '36' ,`PostalCode` = '77517' ,`RoomCount` = '10' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Quartermoon' ,`StreetNumber` = '3425' ,`StreetSuffix` = 'Court' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2443' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living - check; acreage - check; pool - check; large workshop and covered awning - check; great split floor plan with open living and kitchen - check; air conditioned craft room, mancave, she-shed, play room - check! If you are looking for all the checkboxes this home is absolutely amazing! Beautiful tile floors in the entry and living, wood burning fireplace for those cold nights and winters we have seen lately! Covered patio overlooking the pool, crossed fenced to keep your pets out of the pool, stocked pond, plenty of parking, access to the back workshop. This home and property will amaze you!' ,`Acres` = '2' ,`Area` = '33' ,`BuilderName` = 'Tilson' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 15 I R LEWIS SUR PT OF LOTS 4 & 5 (4-0) BLK 2 CRESENT R' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Crescent Ranch Estates Sec 1' ,`TaxAmount` = '8228' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946340' WHERE `Matrix_Unique_ID` = '213122139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:17:01.957' ,`MLSNumber` = '32069259' ,`ListAgentFullName` = 'Jeffrey Morris' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.284396' ,`Longitude` = '-95.555965' ,`PhotoCount` = '31' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Emory Birch' ,`StreetNumber` = '169' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impeccable Highland Home, on a Reserve in Woodforest with No Back Neighbors! High ceilings, beautiful wood plank tile, and an abundance of windows flow seamlessly throughout the home! Family room is open to kitchen and dining, with a large island, white subway tile backsplash, and beautiful window seat. Master suite is nestled perfectly off of the kitchen and back patio. Featuring an en-suite bathroom with separate show and tub, and large walk-in closet. Additional downstairs bedroom, near front door, has its own bathroom with large walk-in shower. Upstairs is a generously sized game room and two additional bedrooms, which share a third bathroom. Rare opportunity to own a home in Woodforest with No Backyard Neighbors, enjoy the seclusion while being so close to all the amenities!' ,`Acres` = '0.1102' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965271 - WOODFOREST 71, BLOCK 1, LOT 12' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '4799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 71' ,`TaxAmount` = '7700' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946340' WHERE `Matrix_Unique_ID` = '213152978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:51:36.293' ,`MLSNumber` = '57759152' ,`ListAgentFullName` = 'Ronda Melton' ,`ListOfficeName` = 'Ebby Halliday, REALTORS' ,`SellingAgentFullName` = 'Karen Vicknair' ,`SellingOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`Latitude` = '29.749402' ,`Longitude` = '-95.825246' ,`PhotoCount` = '40' ,`PostalCode` = '77494' ,`RoomCount` = '15' ,`ListPrice` = '649900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Silver Brook' ,`StreetNumber` = '1806' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come explore what this wonderful home has to offer in the highly sought-after community of Grayson Lakes. The corner, manicured lot offers privacy for the swimming pool, large covered patio, and outdoor kitchen where entertaining guests is a dream come true. The primary bedroom and ensuite bathroom are on the first floor along with the open-concept living room, eat-in kitchen, dual pantries, and utility room. The fresh space offers a home office, second living/formal dining, and a bonus room for play/work. Arranged on the second floor are 3 bedrooms, 2 bathrooms, and a large game/media room. There are plenty of living and storage areas in this immaculate, well-maintained, move-in-ready home!' ,`Acres` = '0.2565' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRY LAKES AT GRAYSON LAKES SEC 7, BLOCK 1, LOT 20' ,`LotDesciption` = 'Corner' ,`LotSize` = '11175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOODCREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMPKINS HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Lakes At Grayson Lakes' ,`TaxAmount` = '9119' ,`TaxRate` = '2.4245' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946340' WHERE `Matrix_Unique_ID` = '213304724' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:56:38.967' ,`MLSNumber` = '52131283' ,`ListAgentFullName` = 'Scott Key' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063203' ,`Longitude` = '-95.651998' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '14' ,`ListPrice` = '1675000.00' ,`Status` = 'Active' ,`StreetName` = 'Copper Bottom' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5246' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sprawling Stone & Stucco ,1.5 story luxury estate home sits on 1.19 acres in the Gated, Equestrian community of Willowcreek Ranch! Super Open and flowing plan with So many windows + the California doors that open up to the big, beautiful backyard! Imagine Your \"Party on the Patio\"! Grill out and watch the game!! This home was built for entertaining!! 4 bedrooms on the first floor. 3 fireplaces, birch hardwood floors, 5 car tandem garage, plenty of parking space, Covered Patio w/ outdoor kitchen, 2 lounge areas, Saltwater heated play pool w/hot tub! Upstairs features an oversized Gameroom, Media room, bedroom & full bath. This lot has plenty of room to expand if you decide to add something extra! The corner lot offers a circle drive too! Neighborhood amenities include a catch and release fishing lake, fitness center, equestrian center, riding trails, a park & the Lake House Lodge! Easy access to the Grand Parkway, 249, and 290! Close to all shopping & Restaurants!' ,`Acres` = '1.1917' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 WILLOWCREEK RANCH SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '51892' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '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,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Willowcreek Ranch' ,`TaxAmount` = '40991' ,`TaxRate` = '2.7372' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946340' WHERE `Matrix_Unique_ID` = '213322914' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:45:33.863' ,`MLSNumber` = '3088011' ,`ListAgentFullName` = 'Pamela Hughes' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984340' ,`Longitude` = '-95.515984' ,`PhotoCount` = '27' ,`PostalCode` = '77069' ,`RoomCount` = '13' ,`ListPrice` = '483550.00' ,`Status` = 'Active' ,`StreetName` = 'Olympia Fields' ,`StreetNumber` = '5431' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3899' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this Gorgeous family home in the desirable Huntwick Subdivision, and highly acclaimed \"A\" rated Cy-Fair ISD. The bright entryway leads to an oversized formal living area with separate formal dining, and also to a cozy den with brick fireplace flanked by pictured windows. The downstairs has recently updated carpet and engineered hardwood, and a first floor primary with access to a formal study. The eat-in kitchen with custom cabinets also includes solid brick accents and a double oven. Upstairs you have beautiful stained 2x6 stained pine flooring along with four spacious bedrooms all with walk in closets, custom built ins, and two Jack and Jill bathrooms. This home also boasts a private game room over the garage with a separate staircase and it\'s own bathroom. Finally a large backyard with a gorgeous pool and private gated driveway with extra space for parking. Brand new AC unit just installed!' ,`Acres` = '0.2755' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 135 & TR 134A BLK 3 HUNTWICK FOREST SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '158' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntwick Forest Sec 08' ,`TaxAmount` = '6989' ,`TaxRate` = '2.4306' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946341' WHERE `Matrix_Unique_ID` = '213329324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:58:06.857' ,`MLSNumber` = '48963084' ,`ListAgentFullName` = 'Lynette Lew' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.862817' ,`Longitude` = '-95.589008' ,`PhotoCount` = '49' ,`PostalCode` = '77041' ,`RoomCount` = '16' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = 'Indigo Cove' ,`StreetNumber` = '12015' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Resort-style living without the long commute! This 4-5 bedroom executive home has sought-after entertainment spaces with a game room, media room, card room and even a hidden bonus room! The first floor has warm hardwood and stone flooring including the stately study located off the grand two story entry. Your dining, breakfast and family rooms are perfect for gatherings; plus the kitchen has abundant storage and a deep, walk-in pantry. The decadent primary suite includes a sitting area with serene views of the sweeping backyard. The spacious primary bathroom features dual vanities and a makeup station plus a cabinet that opens to the laundry room for easy access. Two is the magic number with dual closets and dual shower heads in the massive shower. Upstairs includes the entertainment space plus a desk area, laundry chute and that fun hidden room. The backyard is pool-sized too! LOEN is a manned, gated community with bus service available to Awty, The Village School and BISH.' ,`Acres` = '0.2222' ,`Area` = '8' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Other Disclosures,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 LAKES ON ELDRIDGE NORTH SEC 17' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9677' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1854' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KIRK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes on Eldridge North' ,`TaxAmount` = '12595' ,`TaxRate` = '2.431' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946341' WHERE `Matrix_Unique_ID` = '213449283' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:48:06.887' ,`MLSNumber` = '14944752' ,`ListAgentFullName` = 'Tracy Murski' ,`ListOfficeName` = 'Southern Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780516' ,`Longitude` = '-95.634628' ,`PhotoCount` = '38' ,`PostalCode` = '77079' ,`RoomCount` = '10' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Steamboat' ,`StreetNumber` = '15706' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the highly desirable Barkers Landing community sits this beautifully updated & well maintained home. Located in the Energy Corridor & situated on a corner lot-this pristine home has it all! Chef\'s delight kitchen with granite countertops, gas range, Bosch convection wall oven, storage galore, custom cabinetry, designer finishes, tile flooring & SS appliances. Breakfast room off the kitchen leads to the cozy patio & lush backyard. Dining room with soaring ceiling, spacious & serene living room with gas log fireplace, covered patio through French doors & hand scraped hardwood flooring. Huge primary retreat with large ensuite bathroom-2 closets, large vanity, tons of storage, jetted tub & separate shower. Zoned A/C*no carpet*HardiPlank*double pane windows*large backyard French drains recessed lighting & so much more! 24/7 security patrol*pool*park*tennis courts. Close to Terry Hershey Park, restaurants, shopping & med centers. Did not flood. Zoned to Katy ISD.' ,`Acres` = '0.1318' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 BARKERS LANDING SEC 1' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot,Wooded' ,`LotSize` = '5743' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1045' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLFE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkers Landing Sec 01' ,`TaxAmount` = '7576' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946341' WHERE `Matrix_Unique_ID` = '213537841' --> 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','213541863','1666946341','213541863','2022-10-27T07:13:00.003','66414043','Kirsten Abney','BHGRE Gary Greene','','','29.787234','-95.439220','38','77008','11','525000.00','Active','Algona','825','Avenue','Houston','3','0','3','2381','Single-Family','This well-designed 3BR/3BA home, located in the gated community of The Reserve at Washington, features high ceilings, amazing natural light, spacious rooms, & many upgrades. The 1st flr offers a guest BR w/ ensuite bath, large walk-in closet, and access to a beautifully landscaped backyard. The 2nd flr open concept living space features great functionality & can accommodate multiple arrangements w/ oversized furniture + a spacious guest BR & bath. A well-appointed kitchen offers quartz counters, large island w/ built-in sink, SS appliances, & two walk-in pantries. The oversized primary retreat, located on the 3rd flr, includes a loft area. The spa-like primary bath features quartz counters, dual vanities/sinks, walk-in shower, soaking tub, private water closet, & large walk-in closet. Community amenities include an outdoor area w/ fireplace, water features, dog park, & guest parking! Located near many parks, restaurants, & breweries, this home offers amazing quality & convenience.','0.0443','9','David Weekley Homes','','','','Corporate Listing,Sellers Disclosure','1','','','Timbergrove/Lazybrook','Central Electric','1','LT 12 BLK 1 RESERVE AT WASHINGTON SEC 1','Patio Lot','1931','Appraisal District','','2500','0','','2','Gas Oven,Single Oven','0','','','Gas Cooktop','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','3','Traditional','Reserve/Washington Sec 1','10464','2.3307','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:41:20.680' ,`MLSNumber` = '59018272' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830916' ,`Longitude` = '-94.998665' ,`PhotoCount` = '6' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Zavala Mill' ,`StreetNumber` = '4139' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Cottage Collection \"Camellia\" Plan with Elevation \"C\" in Burnet Fields! This single-story home has a smart layout that is perfect in many ways. The front door leads to an open concept living area that is ideal for daily activities and entertaining guests with a modern kitchen, dining room and family room, all side by side. Three bedrooms share a hall bathroom at the front of the home, while the owner’s suite is tucked into the back with a private bathroom and large walk-in closet. *HOME ESTIMATED TO BE COMPLETE, November, 2022*' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0001 BLK 003 LOT 012' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Burnet Fields' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666946341' WHERE `Matrix_Unique_ID` = '213573045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:22:52.877' ,`MLSNumber` = '48921392' ,`ListAgentFullName` = 'Ruth Carruthers' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.285336' ,`Longitude` = '-95.563984' ,`PhotoCount` = '41' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '745000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverwolf Cove' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Place' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A breathtaking and iconic Wendell Legacy Custom home perched on a picturesque corner lot in beautiful Woodforest. You will find layers upon layers of upgrades and improvements throughout this stunning home including a full sized generator, wood accent walls, designer fixtures and sconces, in-wall speakers, plantation shutters and epoxy garage floor! This home boasts an open floor plan with tons of natural light and a huge kitchen with ample storage - an entertainer\'s dream! The primary suite includes a large walk-in closet and spa-like bathroom. In addition to 4 bedrooms, you have a large game room AND media room upstairs! The large, fully fenced backyard includes a covered patio, mature trees and beautiful views of protected green space due to the location of the lot. Don\'t miss this gem!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Wendell Legacy Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965251 - Woodforest 51, Block 1, Lot 17, 50.000000% UDI' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11636' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946341' WHERE `Matrix_Unique_ID` = '213573718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:39:04.450' ,`MLSNumber` = '58269150' ,`ListAgentFullName` = 'Valery Smith-Blank' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084401' ,`Longitude` = '-95.717896' ,`PhotoCount` = '49' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Wildrose' ,`StreetNumber` = '18919' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The best of country living & great location close to everything! 1.15 acre wooded property on a cul-de-sac makes this the perfect home. Open floor plan w/high ceilings & nicely updated! Wood floors through main living areas. Kitchen open to family & breakfast rooms & has a ctr island & counter seating, as well as large walk-in pantry. Cooktop has a gas line if you prefer to switch. Study down w/built ins. HUGE bonus room w/private bath downstairs that would make a great 2nd primary bedroom; mother-in-law suite; or amazing Media or Game Room downstairs! All of the bedrooms are extremely large-one has a \"secret\" room off of walk-in closet. All baths have granite counters. Primary bath offers oversized tub, separate shower & double sinks. Upstairs Game Room. Fresh paint. Back yard is private w/pool & spa; covered patio; chicken coop w/small barn/storage area. Driveway gate & fully fenced. New Roof 2020 & Solar Panels & other energy saving features. HVAC system-zoned upgrade. NO FLOODING!' ,`Acres` = '1.1558' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT A3 ROSEWOOD HILL SEC 2 U/R' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '50347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosewood Hill Sec 02 U/R' ,`TaxAmount` = '9696' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946342' WHERE `Matrix_Unique_ID` = '213633331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:09:05.570' ,`MLSNumber` = '67935903' ,`ListAgentFullName` = 'Nancy Ramos' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.158862' ,`Longitude` = '-95.314289' ,`PhotoCount` = '24' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Porter' ,`StreetNumber` = '17091' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home comes with a 12x12 gazebo, 15y/o hot tub and BBQ pit. It features a fully insulated double garage, double driveways and a walk in pantry. It is equipped with a water filter and washer, dryer, fridge and piano are included.' ,`Acres` = '0.7922' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LIVE OAKS EST 01, BLOCK 2, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '34508' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Live Oaks Estate 01' ,`TaxAmount` = '3496' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666946342' WHERE `Matrix_Unique_ID` = '213663299' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:18:08.440' ,`MLSNumber` = '58776002' ,`ListAgentFullName` = 'Kate Johnson' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019148' ,`Longitude` = '-95.569238' ,`PhotoCount` = '33' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Baronshire' ,`StreetNumber` = '17514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully landscaped one-story home located on a cu- de-sac in Memorial Chase! This home features 3 bedrooms, 2 baths with a split floor plan. The large family room has high ceilings and an attractive wood burning fireplace. There is a separate dining room with a breakfast bar to the kitchen. The back yard is fenced with a covered patio and includes a storage building plus a custom frame and cover for a porch swing to enjoy your outdoor space. A brand-new architectural shingle roof and double pane windows throughout the home. Excellent location, close to 249, Vintage Park, Grand Parkway, shopping and dining. Zoned to the sought-after Klein ISD! Don’t miss this one, call to schedule your private tour today!' ,`Acres` = '0.2178' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 10 017*M1875900-003-010-026 MEMORIAL CHASE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Chase Sec 03' ,`TaxAmount` = '4417' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946342' WHERE `Matrix_Unique_ID` = '213779127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:30:07.660' ,`MLSNumber` = '24565630' ,`ListAgentFullName` = 'Dawn Struss' ,`ListOfficeName` = 'Greystone Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.133057' ,`Longitude` = '-95.554647' ,`PhotoCount` = '34' ,`PostalCode` = '77375' ,`RoomCount` = '4' ,`ListPrice` = '1380000.00' ,`Status` = 'Active' ,`StreetName` = 'Haven' ,`StreetNumber` = '8514' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on market! Beat the next interest rate hike.This lovely community lake front home, awaits its’ new family. Come and relax sitting in your backyard looking at the lake it’s easy to forget that the rest of the world exist. Just intime for the Holiday’s , Bucolic Park like property, large contemporary style heated pool with spa, circular driveway w/ water fountain. Travertine floors, granite counters w/ tile back-splash, huge plate glass picturesque windows. Serene patio, balcony Master an guest bedroom down and two bedrooms upstairs media/study/game areas. 2nd floor walk in attic storage for items big and small. Large enough to expand. Secure gated community. it’s time to make the move to a nice quiet safe community of only 27 homes, where Children can ride and play with safety. Highly Motivated Seller!' ,`Acres` = '1.84' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 HAVEN LAKE ESTATES' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '80150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Haven Lake Estates' ,`TaxAmount` = '22780' ,`TaxRate` = '2.124' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946342' WHERE `Matrix_Unique_ID` = '213785412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:13:07.103' ,`MLSNumber` = '62987280' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872457' ,`Longitude` = '-95.722778' ,`PhotoCount` = '21' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Windy River' ,`StreetNumber` = '6639' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6639 Windy River. Spacious 2-story, 3-bedroom home in the community of Highland Creek Ranch. Located only minutes away from the Grand Parkway and FM 529. Move In Ready! Property features include high ceilings in your spacious living room. The kitchen is light and bright and has granite counters and SS appliances. There is tile throughout the first floor and carpet in all bedrooms. The primary bedroom is located downstairs just outside the kitchen area. The game room & secondary bedrooms are located upstairs. Perfect size backyard for the little ones and pets. Cypress-Fairbanks Independent School District. You don’t want to miss out on this home!' ,`Acres` = '0.1025' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 HIGHLAND CREEK RANCH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Creek Ranch Sec 01' ,`TaxAmount` = '4528' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946342' WHERE `Matrix_Unique_ID` = '213786118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:03:00.800' ,`MLSNumber` = '55100339' ,`ListAgentFullName` = 'Caroline Schlemmer' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798369' ,`Longitude` = '-95.403683' ,`PhotoCount` = '31' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashland' ,`StreetNumber` = '1507' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1915 Heights bungalow has been thoughtfully expanded to feature a stunning light-filled addition that lends contemporary design elements to this historic home with floor to ceiling metal windows and panoramic double sliding door that overlooks the lush 8,800 sf double lot. The renovation added an additional living area, a primary suite featuring a luxurious bath, re-imagined closet & laundry room to maximize storage and also preserved the original artwork of renowned artist Daniel Anguilu. The floor plan also includes 2 secondary bedrooms, study/formal living & formal dining. Some of the original details include: hardwood floors (refinished in 2022), transom windows, wall paneling, moldings and glass door hardware. The fully fenced outdoor space is exceptional with a front porch overlooking the yard, spacious backyard with seating areas and firepit, mosquito system, storage shed & long driveway. Located just 2 blocks from the hike/bike trail provides great walkability too!' ,`Acres` = '0.202' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 15 & 16 BLK 146 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '19543' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946343' WHERE `Matrix_Unique_ID` = '213812253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:34:36.053' ,`MLSNumber` = '21717285' ,`ListAgentFullName` = 'Terri Mund' ,`ListOfficeName` = 'Hudgins-Groover Real Estate' ,`SellingAgentFullName` = 'Terri Mund' ,`SellingOfficeName` = 'Hudgins-Groover Real Estate' ,`Latitude` = '29.384395' ,`Longitude` = '-95.833948' ,`PhotoCount` = '48' ,`PostalCode` = '77461' ,`RoomCount` = '7' ,`ListPrice` = '498345.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Steffek' ,`StreetNumber` = '14312' ,`StreetSuffix` = 'Street' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the country life in the city!! This custom 3 bedroom, 2+ bath brick home sits on 2 beautiful acres of land inside Needville City Limits. With easy access to Hwy 36 your daily commute will be a breeze. As you drive up you\'ll be greeted by \"Old Glory\" proudly flown from your front-yard flag pole inside your circle driveway. With almost 2,000 SF of living area this home is ready for you to update and make it your own. Your family & friends will enjoy time spent together in the large family room. Visit around the wood-burning fireplace or open the sliding patio doors and move the party outside to the large covered back porch. The 3-car garage boasts a good-sized workshop and plenty of space for all your tools and toys. There are 2 additional storage buildings on the property for your lawn equipment or more tools and toys. The large 2 acre yard offers awesome mature shade trees and space to breathe without neighbors too close by. Call today! You\'re going to want to see this one!' ,`Acres` = '2' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S T KNEITZ ACRES SEC 2, BLOCK 1, LOT 1 & LOT 2, ACRES 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'S T Kneitz Acres Sec 2' ,`TaxAmount` = '4924' ,`TaxRate` = '2.2544' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946343' WHERE `Matrix_Unique_ID` = '213813242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:50:51.320' ,`MLSNumber` = '55954725' ,`ListAgentFullName` = 'Dulce Gonzalez' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052589' ,`Longitude` = '-95.500089' ,`PhotoCount` = '44' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Roserock' ,`StreetNumber` = '5419' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1573' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained neat clean home, plenty storage in each bedroom, has a brick accent wall in dining room, and the breakfasts bar, with a very nice back yard for family gatherings, garage door opening, fans with lighting in all rooms\r\nMAKE YOUR APPOITMENT TODAY YOUR HOME IS WAITING, CLOSE TO SHOPPING' ,`Acres` = '0.1519' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 6 BRIDGESTONE WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial' ,`Subdivision` = 'Bridgestone West Sec 02' ,`TaxAmount` = '4595' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946343' WHERE `Matrix_Unique_ID` = '213841388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:48:55.293' ,`MLSNumber` = '30725926' ,`ListAgentFullName` = 'Judith Wood' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.793617' ,`Longitude` = '-95.069594' ,`PhotoCount` = '29' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '179900.00' ,`Status` = 'Active' ,`StreetName` = 'Loop' ,`StreetNumber` = '445' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern Ranch Home with Lake view to Lake Livingston. Open Concept Living-Dining-Kitchen. Good sized living room with view of the water. Crown molding throughout. Generous Garage, surrounded by mature trees. Easy to maintain cement board siding exterior. Good sized bedrooms and bathrooms. Nice rear concrete patio. Close to subdivision boat ramp/lake access. Convenient to Livingston groceries, shopping, and hospital. Good sized lot. Ready for full-time or weekend lake living!' ,`Acres` = '0.2583' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Forest Hills Sec 4 Lot 19' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '11250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Forest Hills Sec 4' ,`TaxAmount` = '2180' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946343' WHERE `Matrix_Unique_ID` = '213853116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:42:10.913' ,`MLSNumber` = '48894368' ,`ListAgentFullName` = 'Amanda Petree' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871313' ,`Longitude` = '-95.499691' ,`PhotoCount` = '33' ,`PostalCode` = '77040' ,`RoomCount` = '5' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodfern' ,`StreetNumber` = '7250' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Three-bedroom, two-bathroom, one-story home now available in Woodland Trails! Property features an updated kitchen, large living room with high ceilings, covered and screened-in back porch, detached 2-car garage, and a nice sized backyard. Property needs some TLC, and is ready for all of your personal touches and updates. Easy access to 290, 610, and Beltway 8, plus NO FLOODING makes this a great location to call \"Home.\"' ,`Acres` = '0.1791' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 WOODLAND TRAILS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Trails' ,`TaxAmount` = '4189' ,`TaxRate` = '2.5842' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946344' WHERE `Matrix_Unique_ID` = '213865364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:26:35.533' ,`MLSNumber` = '60691477' ,`ListAgentFullName` = 'Livee Gao' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.556901' ,`Longitude` = '-95.620393' ,`PhotoCount` = '16' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '780000.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Bend' ,`StreetNumber` = '5218' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A fabulous 5 bedrooms, 3 car garage home sits on a large corner lot. Most tile floor in living areas. Engineer wood floor in bedrooms. Huge island kitchen has granite countertop and lots of cabinets. Primary bedroom has 2 walk-in closets. 23x16 gam room. Spacious secondary bedrooms and good closet space. Covered patio and sprinkler system. Easy access to elementary, middle and high schools. Do not miss this gem.' ,`Acres` = '0.2809' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON MEADOWS OF AVALON SEC 1, BLOCK 2, LOT 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '12236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COMMONWEALTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Meadows Of Avalon Sec 1' ,`TaxAmount` = '14166' ,`TaxRate` = '2.1244' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946344' WHERE `Matrix_Unique_ID` = '213867350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:51:15.003' ,`MLSNumber` = '9023123' ,`ListAgentFullName` = 'Erica Tyrrell' ,`ListOfficeName` = 'Next Door Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538140' ,`Longitude` = '-95.165412' ,`PhotoCount` = '22' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '259999.00' ,`Status` = 'Active' ,`StreetName` = 'Colonial Ridge' ,`StreetNumber` = '2326' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable home boasts granite countertops in the kitchen, no carpet throughout the home, a large backyard, and a covered patio with fire pit for entertaining! Zoned to sought after CCISD schools! No known flood history per sellers. Garage floor is epoxied and has A/C. Schedule your showing today!\r\n\r\n*refrigerator and shed in the backyard included with home purchase*' ,`Acres` = '0.1446' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 71 BLK 6 HERITAGE PARK SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Heritage Park Sec 06' ,`TaxAmount` = '4400' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946344' WHERE `Matrix_Unique_ID` = '213915474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T06:17:00.253' ,`MLSNumber` = '74925460' ,`ListAgentFullName` = 'Jerry Flowers' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657608' ,`Longitude` = '-95.596098' ,`PhotoCount` = '0' ,`PostalCode` = '77477' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowhollow' ,`StreetNumber` = '12310' ,`StreetSuffix` = 'Drive' ,`City` = 'Meadows Place' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***MOTIVATED SELLERS*** Location! Location!! Location!!! This welcoming 4 bedroom, 2 bath, 2 car detached garage home with beautiful landscaping in Meadows Place! This home features neutral paint in most rooms. Formal living and dining rooms! Roof (2018), A/C (2018), Water Heater (2021) and foundation (2022) have all been updated within the last few years. Lifetime transferable warranty. Most of plumbing has been replaced as well. This home is a blank canvas ready for your qualified buyer to accept ownership. Floors in bedrooms have been replaced with laminate. Bring your serious buyers today!!! Fort Bend ISD. This is a must see!!' ,`Acres` = '0.1885' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'THE MEADOWS SEC 4, BLOCK 31, LOT 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8211' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MEADOWS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Meadows Sec 4' ,`TaxAmount` = '4901' ,`TaxRate` = '2.4949' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946344' WHERE `Matrix_Unique_ID` = '213924390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:38:48.757' ,`MLSNumber` = '19098374' ,`ListAgentFullName` = 'Kelly Andel' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.637667' ,`Longitude` = '-95.743094' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '434000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan Way' ,`StreetNumber` = '3111' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! BRING YOUR OFFERS! New AC SYSTEM being installed 10/23/22! This lovely cul-de-sac home is ready for new owners. Situated on the walking path and within walking distance of Belin Park and the country club. The extra long extra wide driveway provides ample parking space. The oversized brick front patio boasts charm and an opportunity to decorate for every season! The charm continues inside where you will find recent laminate flooring in the living spaces. You will love the soaring ceilings open to the upstairs. Use your formal dining room for entertaining guests as well as the game room! Work from home in your fully built out home office. The open kitchen makes this an ideal floor plan. Outside enjoy your pool and spa with family and friends! The walking path to the park is located behind the backyard fence. No back neighbors! Carpet was freshly cleaned. Bring your finishing touches and make this your new home today!' ,`Acres` = '0.228' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PECAN GROVE PLANTATION SEC 20, BLOCK 3, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PECAN GROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Grove Plantation Sec 20' ,`TaxAmount` = '7220' ,`TaxRate` = '2.2979' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946344' WHERE `Matrix_Unique_ID` = '213928625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:32:44.810' ,`MLSNumber` = '42290160' ,`ListAgentFullName` = 'Amy Larner' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.139204' ,`Longitude` = '-95.049940' ,`PhotoCount` = '47' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '887000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecos' ,`StreetNumber` = '22110' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront living with a POOL! This meticulously maintained custom home was built in 2019 and features soaring ceilings, open-concept living, and a stunning chef\'s kitchen. As you walk through the front door, your eye is drawn to all the designer touches from shiplap walls to the gorgeous beams that run throughout the main area. There are three bedrooms and two bathrooms. The beautifully designed kitchen features a large island overlooking the living and dining areas. The oversized upper deck allows for lazy days in the shade or the perfect place to soak in the sun\'s rays. Looking for more? Head to the lower level, and enjoy one of the multiple entertainment areas, including your own POOL complete with a heater and chiller! This tropical oasis is fully fenced with a cargo lift, and concrete bulkhead, complete with a boat lift, allowing easy access to Galveston Bay. Home conveys furnished with a few exclusions. This property is 100% TURNKEY, and ready for YOU!' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 94 SEA ISLE 15TH EXTENSION' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 15' ,`TaxAmount` = '15635' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946345' WHERE `Matrix_Unique_ID` = '213975487' --> 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','213997635','1666946345','213997635','2022-10-27T07:13:31.110','29967555','MariaLeticia Zamora','JLA Realty','','','29.894666','-95.225273','21','77044','3','193000.00','Active','Greenloch','11842','Lane','Houston','2','0','2','1450','Single-Family','Lovely Home with a manicured backyard. Tile throughout the entire home. This is a very well-kept home; must see to appreciate. Vaulted ceilings with a brick wood burning fireplace. Easy access to the Beltway! Call to make an appointment!','0.101','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Northeast Houston','Central Electric','1','LT 4 BLK 4 GREENSBROOK SEC 1 R/P','Subdivision Lot','4400','Appraisal District','','200','0','','1','','0','','','Electric Cooktop','','Composition','46 - Sheldon','GARRETT ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Back,Lockbox Front','Seller','1','Traditional','Greensbrook Sec 01 R/P','1813','3.1593','Public Sewer,Public Water','1983','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','214022662','1666946345','214022662','2022-10-27T07:54:37.333','62826209','Heidi Chiles-Wheeler','CB&A, Realtors','','','29.895314','-95.726690','50','77433','7','365000.00','Active','Tallow View','20830','Lane','Cypress','2','0','4','2250','Single-Family','Enjoy open concept living in this beautiful 4-bedroom one story in Pine Creek at Canyon Lakes West. The formal entry leads to the open kitchen, dining and living space featuring high ceilings, crown molding, and granite counters. Relax outdoors on your covered front porch or back patio. Conveniently close to schools, shopping and highways you will love living here! Amenities include, walking trails, playgrounds, exercise facilities and swimming pools. OPEN HOUSE Saturday, Oct. 29th and Sunday, Oct. 30th from 1 till 3 PM both days.','0.1353','25','Beazer','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress South','Central Gas','1','LT 22 BLK 2 PINE CREEK AT CANYON LAKES WEST SEC 8','Subdivision Lot','5894','Appraisal District','','1028','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','ANDRE ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Pine Creek at Canyon Lakes West','7950','3.041','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','214092700','1666946345','214092700','2022-10-27T07:17:07.607','19450067','John Martin III','Martin & Black Real Estate LLC','','','29.519470','-95.219669','48','77546','10','729900.00','Active','Pine Hollow','1008','Drive','Friendswood','2','1','4','3238','Single-Family','Fantastic FISD home on a beautiful, large, treed lot with a circular drive and extra parking in back. It is ready to host your family gatherings inside and out. Enjoy a large island kitchen with breakfast bar that opens to family room and wet bar. Work from home in the private study w/ French doors and built-ins. Home offers 4 spacious bedrooms and lots of storage space. Go relax in the primary bath\'s walk-in shower. Step outside the backdoor and see the endless possibilities for the covered patio. Perfect entertaining area with gas access point, as well as hot and cold water connections for your outdoor kitchen. The backyard has perfect play space for the kiddos and plenty of room for a sparkling pool. Call for your private viewing.','0.7461','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Friendswood','Central Gas','1','ABST 151 S MCKISSICK SUR LOT 32 BLK 2 COWARD CREEK SUB SEC 5','Subdivision Lot,Wooded','32500','Appraisal District','','50','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','20 - Friendswood','WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)','FRIENDSWOOD HIGH SCHOOL','FRIENDSWOOD JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Coward Creek','11882','2.2832','Public Sewer,Public Water','1983','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','214094782','1666946345','214094782','2022-10-27T07:19:42.073','50187174','Cody Scurlock','Keller Williams Realty - Clear Lake/ NASA','','','29.768556','-94.939782','22','77521','6','365000.00','Active','Crosby Cedar Bayou','3918','Road','Baytown','2','0','3','2497','Single-Family','Come out and see this wonderful 3-bedroom home that offers two primary bathrooms and sits on over 2+ acres of land. The home offers plenty of space, with a roomy kitchen that offers gas appliance connections and a food pantry. Come warm up in front of the fireplace on those cold days or for those extra-long days take a dip and soak in the indoor hot tub or relax in the den. Out back you\'ll find a huge backyard with a barn to build your dream oasis. There is much this home has to offer!','2.6939','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','Gaslog Fireplace','1','Baytown/Harris County','Central Gas,Other Heating','0','TRS 4C & 4L-1 ABST 69 C SMITH','Cleared,Other','117346','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)','STERLING HIGH SCHOOL (GOOSE CREEK)','CEDAR BAYOU J H','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Christian Smith Surv Abs #69','7696','2.97','Public Sewer,Well','1959','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-27T07:30:45.050' ,`MLSNumber` = '10373117' ,`ListAgentFullName` = 'Gary Barbles' ,`ListOfficeName` = 'GP Investment Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766878' ,`Longitude` = '-94.998847' ,`PhotoCount` = '6' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Club' ,`StreetNumber` = '4027' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Bellvue plan is a one-story home featuring 3 bedrooms, 2 baths, and 2 car garage. The foyer opens to the guest bedrooms w/ walk-in closets & bath with linen shelves. Kitchen includes a breakfast bar, beautiful counter tops, stainless steel appliances, corner pantry and opens to family room. The owner\'s suite has sloped ceiling and attractive master bath with dual vanities, water closet and walk-in closet. This home includes side by side refrigerator, washer, dryer, blinds, garage door opener, and tankless water heater. DR Horton builds homes that are energy efficient and offer smart features such as the Honeywell bluetooth thermostats, Sky Door Bell Cameras, wireless security on exterior door, and Amazon Echo. Be a part of the community while enjoying covered pavilion and gorgeous pool with children’s play area, playground, lakes and walking trails, and 19 acres of preserved land for recreational use and future putting green' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 GOOSE CREEK RESERVE SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Reserve' ,`TaxAmount` = '7111' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666946345' WHERE `Matrix_Unique_ID` = '214095110' --> 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','214101664','1666946345','214101664','2022-10-27T06:13:29.640','61712978','Rose Jensen','HomeSmart','','','29.451953','-95.867682','11','77461','7','239900.00','Active','Rhoda','4625','Lane','Needville','2','0','3','1216','Single-Family','Rare find !! Move in ready 3 bedroom 2 bath on 3+ Acres in cul-de-sac in Needville ISD. Open family room with Kitchen dinning combo has breakfast bar and tons of storage. Primary has walk-in closet, large tub, separate shower, and double sinks. Split floorplan with 2 bedrooms and bath on other side of home. Laminate floor through out, no carpet. Washer, Dryer and Refrigerator included. Enjoy country living on 3.057 acres of wooded land. Bring your horse or farm animals no restrictions or HOA\r\n Call your your appointment today.','3.057','30','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Electric','0','0242 H AND TC RY, TRACT 70, ACRES 3.057','Cul-De-Sac,Wooded','133163','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Other Style','H&Tc Ry','1856','1.8957','Septic Tank,Well','1997','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','214120636','1666946345','214120636','2022-10-27T07:23:38.973','34386144','Stacie Fontenot','RE/MAX One','','','30.130573','-93.749163','21','77632','7','190000.00','Active','Glenhurst','4407','Street','Orange','2','0','3','1637','Single-Family','**LITTLE CYPRESS SCHOOL DISTRICT**This home sits on a large corner lot, with a show stoping crib appeal. It has 3 bedrooms, and 2 Bathrooms, and a 2 car garage with cabinet storage space. Totally updated with beautiful flooring, a stunning floor to ceiling fire place. The gorgeous kitchen speaks for itself with wall to wall cabinets. The master Bath has a double sink and a jetted tube for realizing. Not to mention it has a new HVAC unit. Backyard has a patio that’s great for family barbecuing. This home is a must see!!! Call and schedule your appointment today!!!','0.173','50','','','','','No Disclosures','1','Gas Connections','1','','Central Electric','0','GREENWAY PARK # 1 & 2, SECTION 2, BLOCK 11, LOT 14, ACRES 0.','Corner','7536','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Other','683 - Little Cypress-Mauriceville Consolidated','LITTLE CYPRESS ELEMENTARY SCHOOL','LITTLE CYPRESS-MAURICEVILLE HIGH SCHOOL','LITTLE CYPRESS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Greenway Park # 1 & 2','3006','2.831','Public Sewer,Public Water','1960','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','214120880','1666946345','214120880','2022-10-27T07:40:40.310','5947777','Heather Coggin','Keller Williams Elite','','','29.895126','-94.612492','47','77538','3','498000.00','Active','Highway 61','8500','','Devers','2','0','3','2270','Single-Family','Beautiful unrestricted 10 acres that comes with a 3/2 home and huge horse barn/shop 50x50 concrete perimeter (Mueller 2013 Awning@ Barn) with fenced area off the Barn/shop, plus a side carport and 40’ steel storage container for plenty of storage area. \r\nSurrounded in a beautiful wooded area with wildlife including whitetail deer, 2 fig trees, Satsuma, Lemon trees, Lime trees\r\n 2 Kumquat trees, Orange trees, peach trees. Appliances stay, solid maple kitchen cabinets with Granite countertops, 5 Burner Stove, double oven. Extra large dual granite sink, plus large island on wheels with granite countertops and maple cabinets. Leaf guard 2009 Lifetime warranty gutters\r\nWindow Word 2009 Windows: lifetime double pane windows insulated;\r\nRoof 2yrs old; 3 Car Carport on Slab with lights under the carport that have capability of Bluetooth.\r\nWith easy access to I-10 and HWY 90, a short drive to Houston and Beaumont.','10','52','','','','','No Disclosures','','','','Liberty County East','Central Electric','0','000137 L BARROW, TRACT 93, ACRES 10.0','Wooded','435600','Appraisal District','','','0','','0','','0','','','','','Composition','176 - Devers','DEVERS ELEMENTARY SCHOOL','','DEVERS JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1.5','Ranch','L Barrow','3718','1.8238','Aerobic','1983','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','214120906','1666946345','214120906','2022-10-27T07:34:26.477','10668116','Stacie Fontenot','RE/MAX One','','','29.944259','-93.894350','27','77619','6','248900.00','Active','Cambria','6850','Lane','Groves','2','0','3','1536','Single-Family','This adorable home is located is a must see!!!located in PN-G school, this 3 bedrooms, 2 bathrooms with a 2 car garage has an open floor plan, perfect for family entertaining. With over 1500 Sqft. This home is updated, and also has all appliances including washer and dryer. And not to mention it also has a generic generator, water filtration system, sprinkler system, and a decked attic for extra storage, so what more do you need. It’s Move in Ready, Call today for your private showing.','0.1937','51','','','','','No Disclosures','1','','','','Central Electric','0','CAMBRIA PLACE LOT 5 NE20\' LOT 6 ALL BLK 2','Cul-De-Sac','8438','Appraisal District','','','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Other','233 - Port Neches-Groves','PORT NECHES ELEMENTARY SCHOOL','PORT NECHES-GROVES HIGH SCHOOL','GROVES MIDDLE SCHOOL','Appointment Required,Call Occupant,Lockbox Front,Request Online Appointment','Appraisal District','1','Contemporary/Modern','Cambria Place','5506','2.7694','Public Sewer,Public Water','1998','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214121076','1666946345','214121076','2022-10-27T07:17:27.027','54723805','Lyssa Lechuga','New Home Star Texas, LLC','','','29.303253','-96.071500','17','77488','3','149999.00','Active','Golf Crest','2847','Drive','El Campo','1','0','3','1040','Single-Family','New construction ready for move-in immediately - This one story Plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with white cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows. This home is situated on a quiet cul-de-sac and has convenient parking in the rear.\r\nFantastic Builder \'1-2-10\' Warranty','0.117','55','Censeo','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','','Central Electric','0','GOLF CREST EST. LOT 9','Cleared','7000','Appraisal District','','','1','Never Lived In','0','Electric Oven','0','','','','','Composition','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Golf Crest Estate','','2.4815','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','214121127','1666946345','214121127','2022-10-27T07:14:52.777','11422266','Derek Boles','Legacy Homes & Properties, LLC','','','29.670232','-95.468460','23','77096','5','575000.00','Active','Balmforth','10206','Lane','Houston','2','0','3','2674','Single-Family','Welcome to 10206 Balmforth! This completely renovated, ranch style home is nestled in the beautiful Meyerland subdivision. Upgrades galore including a beautifully tiled fireplace, new flooring, gorgeous countertops and finishes and so much more. This spacious home is perfect for entertaining with a large sunroom located right off the living area. You will also enjoy an expansive backyard situated on a 9,600 sq ft lot. Make this backyard your getaway retreat. Schedule your showing today!','0.2204','20','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Meyerland Area','Central Gas','1','LT 7 BLK 11 MEYERLAND SEC 8 R/P F','Subdivision Lot','9600','Appraisal District','','510','0','','1','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','KOLTER ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch,Traditional','Meyerland Sec 08 R/P F','10279','2.3307','Public Sewer,Public Water','1962','Appraisal'); --> 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','214121625','1666946345','214121625','2022-10-27T07:35:47.470','2067646','Derek Boles','Legacy Homes & Properties, LLC','','','29.649362','-95.484571','33','77035','4','330000.00','Active','Renwick','11914','Drive','Houston','2','0','4','1659','Single-Family','**NEW PRICE** - Stop the Car! Finally a home that has it all. This gem is nestled in a great community near local freeways on a exclusive large cul-de-sac lot. No neighbors on both sides, great for additional entertaining space. Well maintained yard as you approach this fully renovated home. New front door, new interior and exterior paint, new flooring and brand new custom kitchen. The study/bedroom off to the right is perfect for working/studying/sleeping. Large open floorplan from living room to kitchen. The primary retreat is a great size and comes with a brand new restroom with double vanity and large shower! There are too many upgrades to list. But you will love at first sight. See you soon!','0.2557','20','','','','','Sellers Disclosure','','','','Brays Oaks','Central Gas','0','LT 17 BLK 110 WESTBURY SEC 4','Subdivision Lot','11140','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','ANDERSON ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Westbury Sec 04','2314','2.3307','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully