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-11-06T12:22:00.437' ,`MLSNumber` = '83358670' ,`ListAgentFullName` = 'Natasha Simon' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858635' ,`Longitude` = '-95.249327' ,`PhotoCount` = '50' ,`PostalCode` = '77078' ,`RoomCount` = '6' ,`ListPrice` = '282490.00' ,`Status` = 'Active' ,`StreetName` = 'Kentshire' ,`StreetNumber` = '9518' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No need to pay for upgrades here! READY FOR IMMEDIATE MOVE-IN. Minutes from downtown, check out this brand new 4/2/2 open-concept 1 story over 1800 sqft with a low tax rate! Currently the front bedroom is being utilized as a study with glass doors. The kitchen is open to the family room with a beautiful kitchen island with vinyl plank wood throughout (yes carpet only in bedrooms). Primary bedroom large with massive closet along with garden tub with separate shower with two vanities. This home also features soffit lighting, soft close drawers and even the cabinet trash enclosure in the kitchen. Large backyard with huge covered patio. Stainless steel appliances (gas range, dishwasher and built-in microwave). Call/Text to schedule your tour today!' ,`Acres` = '0.1612' ,`Area` = '2' ,`BuilderName` = 'NEXT VISTA HOMES LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 317 BLK 13 KENTSHIRE PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Kentshire Place Sec 02' ,`TaxAmount` = '408' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834942' WHERE `Matrix_Unique_ID` = '208932231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:22:02.290' ,`MLSNumber` = '33512533' ,`ListAgentFullName` = 'Deborah Villarreal' ,`ListOfficeName` = 'Deborah Villarreal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680342' ,`Longitude` = '-95.212583' ,`PhotoCount` = '12' ,`PostalCode` = '77502' ,`RoomCount` = '2' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Vince' ,`StreetNumber` = '2034' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Bedroom home with a den with recent roof. House was gutted and remodeled in 2018 with new electrical update. The tenant’s lease is through May 2023.' ,`Acres` = '0.1837' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 102 VINCE HEIGHTS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH SHAVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vince Heights Sec 01' ,`TaxAmount` = '4241' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834942' WHERE `Matrix_Unique_ID` = '209095444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:46:20.443' ,`MLSNumber` = '89217012' ,`ListAgentFullName` = 'Patrick Sullivan' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032439' ,`Longitude` = '-95.566313' ,`PhotoCount` = '36' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Bishops Place' ,`StreetNumber` = '1331' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2911' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare 1-story pool home in Gleannloch Farms. Great location, great schools, great bones, and fantastic floor plan. Neighborhood amenities include 3 pools, splash pad, tennis and volleyball courts, lakes, dog park, equestrian center, basketball pavilion, baseball/soccer fields, & 27 hole Gleannloch Pines golf course.' ,`Acres` = '0.2' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 GLEANNLOCH FARMS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms' ,`TaxAmount` = '9632' ,`TaxRate` = '2.6115' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834942' WHERE `Matrix_Unique_ID` = '209113645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:40:11.513' ,`MLSNumber` = '41270729' ,`ListAgentFullName` = 'Eduardo Garza' ,`ListOfficeName` = 'GAREBA Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649301' ,`Longitude` = '-95.937493' ,`PhotoCount` = '7' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Wellborn' ,`StreetNumber` = '3607' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction! Home will greet you with massive IRON double doors, towering front porch, king size brick and wood accents on all elevations. High ceilings and wood beams will continue inside throughout the oversized hallway that provides unobstructed view of the backyard thru a wall full of sliding doors that open towards the massive and high-ceiling covered patio. Kitchen will include pot filler, floating shelves, quartz countertops, matte black hardware, designer paint/backsplash, oversized range hood and KitchenAid appliances. High ceilings with exposed beams also in primary bedroom, dining, family and foyer. You will love the owners\' ensuite, it boasts a two person walk-in shower with independent temp valves and freestanding tub. Laundry is centrally located and includes luxury pet shower and direct access to primary closet! Built-in Pest Defense system, 10 year structural warranty, gutters and sprinkler system also included. Low taxes! Request list of upgrades.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'GAREBA Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Reserve At Weston Lakes Sec 1, BLOCK 2, Lot 6' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '11339' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Reserve At Weston Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834942' WHERE `Matrix_Unique_ID` = '209133027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:28:16.353' ,`MLSNumber` = '28678420' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.898337' ,`Longitude` = '-95.739817' ,`PhotoCount` = '20' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '349990.00' ,`Status` = 'Active' ,`StreetName` = 'Costalinda' ,`StreetNumber` = '21406' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1914' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW Construction Maldives Floor Plan at Marvida! This NEW Construction Home is a 1-Story, 4 Beds, 2 Baths with Covered Patio! The Kitchen features Gloss White Kitchen Backsplash, 42\" Graphite Cabinets, Avedon Granite Countertops, Stainless Steel Undermount Kitchen Sink & Beige Tile Flooring. The Primary Suite offers Double Sinks, Walk-in Shower with Shower Seat & Oversized Walk-in Closet. The Home is Complete with Full Sod, Sprinkler System & Garage Door Opener!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Bock 1 Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5781' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834942' WHERE `Matrix_Unique_ID` = '209828352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:15:56.450' ,`MLSNumber` = '41427241' ,`ListAgentFullName` = 'Sherry Thai' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Danny Garcia' ,`SellingOfficeName` = 'Liv Texas' ,`Latitude` = '29.713197' ,`Longitude` = '-95.667706' ,`PhotoCount` = '21' ,`PostalCode` = '77082' ,`RoomCount` = '5' ,`ListPrice` = '230000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Olive Glen' ,`StreetNumber` = '16131' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute patio home features 2 bedrooms with an extra room can be use for a bedroom or office/study room. Open floor plan concept with high ceiling. Laminate woods and tile throughout. Koi fish pond will give you the serene feeling. Spacious backyard for all your gardening. Close to school, parks and shopping malls' ,`Acres` = '0.1684' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 16 WINGATE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7335' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '49' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'REES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wingate Sec 02' ,`TaxAmount` = '3251' ,`TaxRate` = '2.4927' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667834943' WHERE `Matrix_Unique_ID` = '211159667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:37:01.530' ,`MLSNumber` = '71383601' ,`ListAgentFullName` = 'Christopher Ward' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541567' ,`Longitude` = '-95.239196' ,`PhotoCount` = '35' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '519999.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Lake' ,`StreetNumber` = '1906' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 5 bedroom, 3.1 bathroom residence in the heart of Pearland exudes elegance from the moment you enter! Inside you\'ll find ample square footage bursting with natural light and all of the \"extras\"- a spacious living room with a fireplace, a game room upstairs, a finished out four-car garage that makes the perfect man-cave and an in-ground pool in the backyard! Large tile flooring throughout main living areas is a breeze to maintain. Cook meals in the gorgeous island kitchen, featuring gourmet stainless steel appliances like a double wall oven and a gas cooktop. In the primary suite you\'ll find soaring ceilings and french doors that lead to the backyard, plus an ensuite with a jetted tub and a separate shower. Water system that stabilizes the minerals located in the garage. A backyard oasis awaits you, take in the outdoors or watch the fun from the sun room featuring a pool, jacuzzi, and a spacious patio with a view of the lush lawn and no rear neighbors. Don\'t miss this rare find!' ,`Acres` = '0.3182' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WILLOW LAKE ESTATES SEC 1 (A0070 WDC HALL) (PEARLAND) BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13861' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Lake Estates Sec 1' ,`TaxAmount` = '7993' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834943' WHERE `Matrix_Unique_ID` = '211361376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:07:00.983' ,`MLSNumber` = '7859474' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816984' ,`Longitude` = '-95.339264' ,`PhotoCount` = '48' ,`PostalCode` = '77026' ,`RoomCount` = '8' ,`ListPrice` = '222897.00' ,`Status` = 'Active' ,`StreetName` = 'Melbourne' ,`StreetNumber` = '3202' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PRIVACY Fence to be installed. Renovated Chic Bungalow energy eff. windows, doors; NEW A/C unit; Freshly painted interior light modern gray w/ white baseboard & window sashes, a beautiful contrast refinished deep mahogany original hardwoods. Kitchen: Custom ceiling high white trimmed cabinetry, modern polished nickel hardware, storage a solutions: built in Lazy Susan corner, built in pot and pan extending drawer, storage under the 48\" high granite top island. Granite Counters, White Subway tile back splash, Ceramic tile floors, modern faucet\'s and fixtures. Spa inspired Bathrooms are chic. A Family room right off the kitchen and Utility room with extra storage for everyone\'s favorite activity - \"Laundry\"! The upstairs : 2 bedrooms and study / office area w/ storage closet. The home is on a large Corner lot enclosed with a fence with single car garage. In rear of garage workshop w/ sink hook ups. Exterior: new hardi, paint & freshly landscaped yard. Includes Home warranty!' ,`Acres` = '0.2016' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 25A BLK 6 HUNTINGTON PLACE EXTN' ,`LotDesciption` = 'Corner' ,`LotSize` = '8783' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PAIGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Huntington Place Ext' ,`TaxAmount` = '2529' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834943' WHERE `Matrix_Unique_ID` = '211362385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:59:12.887' ,`MLSNumber` = '82007301' ,`ListAgentFullName` = 'Moises Arteaga' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Bijou Tran' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.798463' ,`Longitude` = '-95.701135' ,`PhotoCount` = '36' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Deer Key' ,`StreetNumber` = '18818' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Do you love birds, parks, & lots of space on a cul de sac w/fabulous neighbors? Then, this house is for you! Sit outside by your own pool in morning or eve & you will see lots of Egrets, Bald Eagles, Hawks, Owls & many avian others. Home was always filled with love! Located only minutes away from the Energy Corridor & Texas & Methodist Hospitals & I-10. Uniquely custom-built to have TWO MASTER BEDROOMS & BATHROOMS with huge walk-in closets! 2 additional bedrooms w/2 separate vanities & 1 shared bathroom. Large upstairs game room. Zoned to Katy ISD. Across the street from Cullen Park w/biking & walking trails, guaranteed to keep you active. Lots of soccer & softball fields & the Alkek Velodrome which is the only facility for high-speed cycling in entire state of Texas!' ,`Acres` = '0.2773' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 PARK HARBOR ESTATES SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12081' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '333' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Harbor Estates Sec 03' ,`TaxAmount` = '5775' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834943' WHERE `Matrix_Unique_ID` = '211473833' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:57:36.233' ,`MLSNumber` = '31829108' ,`ListAgentFullName` = 'Craig Holland' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.299917' ,`Longitude` = '-94.779212' ,`PhotoCount` = '35' ,`PostalCode` = '77550' ,`RoomCount` = '2' ,`ListPrice` = '476400.00' ,`Status` = 'Active' ,`StreetName` = '13th' ,`StreetNumber` = '1314' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '953' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WITHDRAWING 11/8 42 DAY VACASA GUEST CHECKING IN-2 Blocks to Beach, Off Street Alley Driveway with gate to private oasis, 2 decks front, back of house. AirBnB or Home-Completely furnished inside and out. NEW 2021 HVAC, Appliances, Total Rehab, Furniture! The perfect choice for your home or AirBnB!\r\nInside, subtle and tasteful beach-themed décor surrounds you. Leave all of your worries behind and relax. Open floor plan with sit around for 8 quartz island, keeps everyone together. Fully-equipped kitchen with quartz tops, stainless appliances and prepare refreshing beverages and snacks. Comfortable sofas or bedrooms to watch a smart TV. LG Washer & dryer has your back so pack light. Out back the enclosed yard is the perfect relaxation spot. The private patio is stained concrete, features a convenient outdoor dining area, lounge chairs and a gas grill, the perfect cookout setting. The outdoor shower is so refreshing after a day at the beach. Owner/seller is a licensed TX Realtor.' ,`Acres` = '0.0538' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOT 13 & N 36-6 FT OF LOT 14 (' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '2343' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '3617' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834944' WHERE `Matrix_Unique_ID` = '211643564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:16:19.507' ,`MLSNumber` = '36769182' ,`ListAgentFullName` = 'Shirley Stewart' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973975' ,`Longitude` = '-97.902204' ,`PhotoCount` = '36' ,`PostalCode` = '78640' ,`RoomCount` = '12' ,`ListPrice` = '1775000.00' ,`Status` = 'Active' ,`StreetName` = 'Stageline' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Drive' ,`City` = 'Kyle' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TRANQUILITY, PEACE,SECLUSION! A very private property that evokes a calm as you enter the property. Texas Hill Country at its finest. Blanco River front with seclusion all around the property. Home has been completely updated with split floor plan. Guest suite with living, kitchen, bedroom and bath. A Gourmet kitchen with custom LaCanche range, 2 ovens, gas and convection. Custom cabinets with soft close and Sub Zero refrigerator. Geo thermal HVAC, 20,000 gallon Rainwater tank with filtration system for primary water source and a well for backup. Well water is used to water lawn and plants. Wet weather creek in back of home which is surrounded by native trees. Abundant wildlife surrounds the property plus fishing and swimming in the Blanco River. Screened porch to enjoy the outdoors. \"Almost off the the grid just add solar\". Street side of property can be sub divided and add another home. Also, property can be connected to water and sewer at street. THE VISTA\'S ARE MAGNIFICENT' ,`Acres` = '3.523' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Heat Pump,Other Heating,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0361 JOHN PHARASS SURVEY, ACRES 3.523, AND BLANCO RIVER CRO' ,`LotDesciption` = 'Greenbelt,Waterfront,Wooded' ,`LotSize` = '153462' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '121 - Hays Consolidated' ,`SchoolElementary` = 'BLANCO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAYS HIGH SCHOOL' ,`SchoolMiddle` = 'WALLACE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'ABSTRACTS IN HAYS ISD' ,`TaxAmount` = '5277' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834944' WHERE `Matrix_Unique_ID` = '211870249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:04:32.007' ,`MLSNumber` = '58931549' ,`ListAgentFullName` = 'Lisa Simpson' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332570' ,`Longitude` = '-95.459241' ,`PhotoCount` = '24' ,`PostalCode` = '77301' ,`RoomCount` = '4' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Tickner' ,`StreetNumber` = '2005' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1982' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION!!! This beautiful home is located right in the middle of Conroe making it close to everything! Shopping, schools, restaurants, medical, plus very close to I-45 for your commute. The charming home has all new lighting, hardware, fresh interior paint throughout and new carpet in bedrooms. Beautiful bookcases flank the cozy gas log fireplace in the family room, the breakfast room overlooks the private backyard and is open to the kitchen and family. The formal formal dining has rich hard wood flooring and is just off the kitchen for ease of service to your guests. This room could easily double as a study. The lovely master/primary ensuite is located on the first floor. Up the stairs are 3 bedrooms with balcony overlooking the downstairs family room. The backyard has a gorgeous custom built pergola that currently houses a hot tub, but could easily be removed for a sitting area or outdoor kitchen. Possibilities are endless!' ,`Acres` = '0.1768' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TANGLEWOOD EAST, LOT 16' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'REAVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Tanglewood East' ,`TaxAmount` = '3098' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834944' WHERE `Matrix_Unique_ID` = '211955247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:07:00.983' ,`MLSNumber` = '72923127' ,`ListAgentFullName` = 'Clarissa Woodward' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.373208' ,`Longitude` = '-95.030143' ,`PhotoCount` = '28' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '277000.00' ,`Status` = 'Active' ,`StreetName` = 'Driftwood' ,`StreetNumber` = '834' ,`StreetSuffix` = 'Lane' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fall in love with this spacious 4 Bedroom 2.5 Bathroom home located in Saltgrass Crossing with a huge back yard and no back neighbors! The first floor offers a huge open concept living area, the primary bedroom has a beautiful bay window and seating area, the en-suite has a spacious double sink vanity, soaking tub and separate shower, and all secondary bedrooms are upstairs. With no shortage of storage, everyone talks about the 9ft deep walk-in pantry, huge primary walk-in closet, and 2 of the 3 secondary bedrooms also feature walk-in closets, this home has been well maintained and has no shortage of storage or space. Comes with 1 hardwired Security Camera in the front and 1 in the back! Saltgrass Crossing is conveniently located within minutes of I45 and Galveston Island.' ,`Acres` = '0.206' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SALTGRASS CROSSING SEC 1 (2007) ABST 2, BLOCK 1, LOT 34, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Saltgrass Crossing' ,`TaxAmount` = '6604' ,`TaxRate` = '3.2275' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834944' WHERE `Matrix_Unique_ID` = '212066175' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:23:42.427' ,`MLSNumber` = '93443367' ,`ListAgentFullName` = 'Lisa Grant' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.063995' ,`Longitude` = '-95.569227' ,`PhotoCount` = '47' ,`PostalCode` = '77375' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Berrypatch' ,`StreetNumber` = '10019' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely adorable Cottage Style home located conveniently near TX -99 and close to shopping. This spacious 3 bedroom two bath home with two car garage has an excellent layout. Enjoy the openness and the nice sized bedrooms with plenty of closet space! Beautiful recently remodeled country kitchen with granite, recently installed stainless steel appliances and lovely cabinets. Plenty of cabinet space and a good sized pantry. Wonderful wood look vinyl plank flooring throughout just installed in 2019. Fresh paint throughout as of Oct. 2022! Enjoy the covered sitting area in the backyard and a nice sized storage building for all your lawn equipment.' ,`Acres` = '0.1346' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 40B & 41 BLK 17 SUGARBERRY PLACE PHASE 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BERNSHAUSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugarberry Place Ph 02' ,`TaxAmount` = '3217' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834944' WHERE `Matrix_Unique_ID` = '212309661' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:37:50.510' ,`MLSNumber` = '2133759' ,`ListAgentFullName` = 'Christina Williams' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064293' ,`Longitude` = '-94.797639' ,`PhotoCount` = '27' ,`PostalCode` = '77575' ,`RoomCount` = '6' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Travis' ,`StreetNumber` = '914' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2073' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a move in ready home with an in-ground pool? Look no further! This completely remodeled home has a beautiful color scheme consisting of grey, white, and black. It has magnificent beams on the ceiling of the living room that accent the cozy fireplace. The kitchen has plenty of cabinet space. There are even cabinets with slots specifically for the pans. The kitchen opens up to the living room and dining area with a breakfast bar. The primary bedroom has a nicely updated bathroom with a walk-in shower. Don\'t worry about parking space when hosting guests. The driveway is HUGE! Enjoy those long hot summer evenings sitting on your covered patio or sliding down the waterslide into the glistening in-ground pool.' ,`Acres` = '0.1791' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODSLAWN, BLOCK B, LOT 5, ACRES .1791' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodslawn' ,`TaxAmount` = '4293' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834945' WHERE `Matrix_Unique_ID` = '212405151' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:05:22.487' ,`MLSNumber` = '73554171' ,`ListAgentFullName` = 'Sheri Williams' ,`ListOfficeName` = 'Hometown Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.353964' ,`Longitude` = '-94.990248' ,`PhotoCount` = '39' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '435900.00' ,`Status` = 'Active' ,`StreetName` = 'Perthuis Farms' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Road' ,`City` = 'La Marque' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '3190' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this stunning contemporary home located on a tree filled lot that\'s just under an acre. Designed for entertaining and a comfortable lifestyle. All living spaces have wonderful views of the grounds and trees. The high ceilinged living room is open to the den that overlooks the courtyard. These rooms feature fireplaces for cozy evenings. Formal dining with a built in buffet. The private primary bedroom area includes a bath with double sinks, walk or roll in shower, dressing area, plus study. Secondary bedrooms are up, each have a private bath and balconies that overlook the court yard. All windows have electric roll up shutters for storm season. There is a generator for the entire home. Garage is oversized and has a half bath. This special home has not flooded and is ready for you to make it your own! Less than 5 minutes to I-45 for easy commutes to Galveston and Houston.' ,`Acres` = '0.8231' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 PAGE 12 LOT 9 PERTHIUS FARMS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '35853' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Perthius Farms' ,`TaxAmount` = '8683' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667834945' WHERE `Matrix_Unique_ID` = '212410122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:08:07.217' ,`MLSNumber` = '82597498' ,`ListAgentFullName` = 'Shirley Stewart' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437511' ,`Longitude` = '-95.099628' ,`PhotoCount` = '45' ,`PostalCode` = '77539' ,`RoomCount` = '13' ,`ListPrice` = '769000.00' ,`Status` = 'Active' ,`StreetName` = 'Lovers Lane' ,`StreetNumber` = '4017' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '5374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SECLUDED COUNTRY SETTING with mature trees and a producing pear tree. Large oak and pine trees on park like setting yet close to all the convenience of city living. Spacious home with plenty of bedrooms and baths for the family to spread out and have their own space. Updated kitchen with soft close cabinets. Room for a pool table or a place to store your wine. Baths have been updated and primary bath with spa tub. Downstairs apartment with kitchenette and bath plus exterior door for private entrance. HOME HAS NEVER FLOODED!\r\nCOME AND ENJOY THE TRANQUIL SETTING OF THIS FANTASTIC HOME.\r\n2022 TAXES ARE INCORRECT. APPRASIAL DISTRICT IN PROCESS OF CORRECTING.' ,`Acres` = '1.781' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 19 PAGE 12 PERRY & AUSTIN SUR TR 59 1.781 ACRS' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '77580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Perry & Austin Upr League #59' ,`TaxAmount` = '9624' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834945' WHERE `Matrix_Unique_ID` = '212585067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:49:23.787' ,`MLSNumber` = '13722301' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798538' ,`Longitude` = '-95.352470' ,`PhotoCount` = '24' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy' ,`StreetNumber` = '4215' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Jesselton Builder is redefining the real estate market with Design excellence, Quality construction and Affordability! Welcome to 4215 Hardy Street in the ever growing area of Northside Village! Jesselton Builder is hand crafting luxury with 3 Bedrooms, 2.5 Baths and tons of high end finishes at the most affordable price. Here in Jesselton Gardens buyers can expect soaring 10 ft ceilings throughout, Luxury Vinyl plank flooring, Calacatta Quartz with single side Waterfall on Kitchen Island and Custom European Cabinetry with under Cabinet lighting. Spacious Primary Suite with Tray Ceiling, Soaking Tub and Porcelain Flooring. Lighting is definitely not going to be understated. Modern Lighting choices reflects in the Kitchen Pendants, Dining Chandelier and Vanity Lights in Bathrooms. Location is prime with these homes! Located just 9 minutes from Greater Heights, less than 5 miles from Downtown and 11 miles from the Galleria, shopping and dining are at your fingertips!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Jesselton Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 1 Jesselton Garden' ,`LotDesciption` = 'Other' ,`LotSize` = '1875' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Jesselton Garden' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834945' WHERE `Matrix_Unique_ID` = '212701271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:04:07.220' ,`MLSNumber` = '64827733' ,`ListAgentFullName` = 'Eduardo Polack' ,`ListOfficeName` = 'Elite Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975222' ,`Longitude` = '-95.402738' ,`PhotoCount` = '22' ,`PostalCode` = '77073' ,`RoomCount` = '8' ,`ListPrice` = '234777.00' ,`Status` = 'Active' ,`StreetName` = 'Crosshill' ,`StreetNumber` = '19307' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Single Family Cottage Home built by KB Home 5 years ago. Downstairs Features: Foyer, Kitchen with Nice Cabinets, Fridge included and Pantry, Breakfast Area, Living Room, Guest Bathroom, Closet area, 2 Car Garage with Garage Door Opener and additional storage area (Attached), Fenced Patio. Upstairs Features : Principal Bedroom with excellent Walking Closet Space, Principal Bathroom with counter Space and Extra closet, Other two Bedrooms with closets share the Second Bathroom (not Connected) , Game Room area and Utility Room with Full Size Washer and Dryer set included, Cold A/C System with Digital Thermostat and Extra Ceiling Fans in all Bedrooms and Living Room. Storage area in attic Space too.' ,`Acres` = '0.0603' ,`Area` = '12' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 REMINGTON RANCH SEC 27' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2628' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HOYLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch Sec 27' ,`TaxAmount` = '4691' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834945' WHERE `Matrix_Unique_ID` = '212714918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:48:20.780' ,`MLSNumber` = '5343666' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798538' ,`Longitude` = '-95.352470' ,`PhotoCount` = '24' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy' ,`StreetNumber` = '4217' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Jesselton Builder is redefining the real estate market with Design excellence, Quality construction and Affordability! Welcome to 4217 Hardy Street in the ever growing area of Northside Village! Jesselton Builder is hand crafting luxury with 3 Bedrooms, 2.5 Baths and tons of high end finishes at the most affordable price. Here in Jesselton Gardens buyers can expect soaring 10 ft ceilings throughout, Luxury Vinyl plank flooring, Calacatta Quartz with single side Waterfall on Kitchen Island and Custom European Cabinetry with under Cabinet lighting. Spacious Primary Suite with Tray Ceiling, Soaking Tub and Porcelain Flooring. Lighting is definitely not going to be understated. Modern Lighting choices reflects in the Kitchen Pendants, Dining Chandelier and Vanity Lights in Bathrooms. Location is prime with these homes! Located just 9 minutes from Greater Heights, less than 5 miles from Downtown and 11 miles from the Galleria, shopping and dining are at your fingertips!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Jesselton Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 Block 1 Jesselton Garden' ,`LotDesciption` = 'Other' ,`LotSize` = '1875' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Jesselton Garden' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834946' WHERE `Matrix_Unique_ID` = '212715565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:47:13.937' ,`MLSNumber` = '5061800' ,`ListAgentFullName` = 'Nimesh Patel' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798864' ,`Longitude` = '-95.352493' ,`PhotoCount` = '24' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Hardy' ,`StreetNumber` = '4219' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Jesselton Builder is redefining the real estate market with Design excellence, Quality construction and Affordability! Welcome to 4219 Hardy Street in the ever growing area of Northside Village! Jesselton Builder is hand crafting luxury with 3 Bedrooms, 2.5 Baths and tons of high end finishes at the most affordable price. Here in Jesselton Gardens buyers can expect soaring 10 ft ceilings throughout, Luxury Vinyl plank flooring, Calacatta Quartz with single side Waterfall on Kitchen Island and Custom European Cabinetry with under Cabinet lighting. Spacious Primary Suite with Tray Ceiling, Soaking Tub and Porcelain Flooring. Lighting is definitely not going to be understated. Modern Lighting choices reflects in the Kitchen Pendants, Dining Chandelier and Vanity Lights in Bathrooms. Location is prime with these homes! Located just 9 minutes from Greater Heights, less than 5 miles from Downtown and 11 miles from the Galleria, shopping and dining are at your fingertips!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Jesselton Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 3 Block 1 Jesselton Garden' ,`LotDesciption` = 'Other' ,`LotSize` = '1875' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Jesselton Garden' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834946' WHERE `Matrix_Unique_ID` = '212715689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:20:55.153' ,`MLSNumber` = '9903711' ,`ListAgentFullName` = 'Loriann Silva' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825159' ,`Longitude` = '-95.532654' ,`PhotoCount` = '38' ,`PostalCode` = '77080' ,`RoomCount` = '4' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Colleen' ,`StreetNumber` = '9723' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home located in the desired neighborhood of Spring Shadows. This lovely 3 bed 2 bath single story is ready for you to call it home! This gem is nested at the end of the street before the cul-de-sac, on a beautiful size lot. The living area is equipped with a fireplace & open concept to the kitchen, and breakfast area. Enjoy the spacious backyard for perfect entertainment with your guest. Located near 290, I-10 and Beltway 8. Minutes from City Center, Memorial City Mall, Downtown, and Galleria. Never flooded per seller! A must see!' ,`Acres` = '0.168' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 58 BLK 1 SPRING SHADOWS SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 14' ,`TaxAmount` = '5533' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834946' WHERE `Matrix_Unique_ID` = '212849763' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:37:01.530' ,`MLSNumber` = '49899714' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.184621' ,`Longitude` = '-95.518504' ,`PhotoCount` = '39' ,`PostalCode` = '77381' ,`RoomCount` = '13' ,`ListPrice` = '2875000.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn' ,`StreetNumber` = '64' ,`StreetSuffix` = 'Crescent' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely remodeled home on nearly an acre lot in Hollymead! Located on a corner lot and walking distance to the Woodlands Country Club and Palmer Golf Course! Stunning curb appeal with a circular drive and covered front porch. Endless updates include a brand new roof and HVAC, Pella exterior doors and windows, Emtek door hardware, Madeval cabinetry, quartz counters, over 2,000 sf addition, pre-wired for security and surround sound, all new lighting, and much more! The sleek, open concept kitchen with all new Dacor appliances, waterfall island, vaulted beam ceiling, and under cabinet lighting, overlooks the dining and den with floor to ceiling brick fireplace; private study with built-ins; gorgeous sun room; owner\'s retreat and 2nd guest suite down; 3 bedrooms and game room up; oversized 3 car garage with epoxy floor; fabulous backyard with heated pool, spa, outdoor kitchen, and cedar pergola.' ,`Acres` = '0.8588' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'S972209 - WDLNDS VIL COCHRANS CR 09, BLOCK 4, LOT 16' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '37409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 09' ,`TaxAmount` = '25144' ,`TaxRate` = '2.2784' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834946' WHERE `Matrix_Unique_ID` = '212885333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:00:54.127' ,`MLSNumber` = '64981078' ,`ListAgentFullName` = 'Deborah Bly' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Nidia Salazar' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.808937' ,`Longitude` = '-94.994231' ,`PhotoCount` = '32' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '235000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Beaver Bend' ,`StreetNumber` = '7607' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is it!! The one you’ve been waiting for! Tastefully remodeled 4 bedroom home in Meadow Lake neighborhood on a cul-de-sac street* New kitchen cabinets * Granite Countertops * Stainless steel appliances * Luxury vinyl flooring throughout home- No carpet! * Cozy brick wood burning fireplace *Upgraded ceiling fans* Fresh Exterior paint * Fresh Interior paint * New Roof * Plumbing upgrades * Spacious fenced in backyard to let the kids and dog run around! Ready for you to move in! Schedule your tour before it’s gone!' ,`Acres` = '0.1596' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 259 BLK 8 MEADOW LAKE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6952' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'BANUELOS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Lake I Sec 01' ,`TaxAmount` = '3935' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834947' WHERE `Matrix_Unique_ID` = '213008667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:34:40.087' ,`MLSNumber` = '15209685' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119286' ,`Longitude` = '-95.638466' ,`PhotoCount` = '22' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Capella' ,`StreetNumber` = '31510' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open house for Sunday 11/6 has been cancelled due to a family emergency. CHECK OUT THE VIRTUAL TOUR ~ Charming Traditional Two Story Conveniently located in Tomball near FM 249 in quiet neighborhood on a cul-de-sac Street. This home features 3 Bedrooms, 2 1/2 Bathrooms, Game Room & Formal Dining Room with Sculpted Ceiling. The Kitchen offers Granite Countertops, 42\" Upper Cabinets, Gas Cooktop, Convection Oven, Refrigerator & Huge Walk In Pantry. On the second floor is a Large oversized Primary Suite with sitting area. Primary Bath has Dual Sinks, Whirlpool Tub, Separate Shower and Amazing Walk In Closest. Beautifully Landscaped Yard with Rain Bird Sprinkler System, Backyard with Privacy Fence. This Home offers Lots of Storage Space, Workspace & Cabinets in Garage. Walking distance to Tomball Junior High and Tomball High School. 2 Minutes from 249. HVAC system fully replaced in 2020. Low Tax Rate! Schedule your own private tour.' ,`Acres` = '0.1736' ,`Area` = '14' ,`BuilderName` = 'Norwood Homes Texas' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 4 NORTH STAR ESTATES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TOMBALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North Star Estates' ,`TaxAmount` = '6035' ,`TaxRate` = '2.3717' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834947' WHERE `Matrix_Unique_ID` = '213018121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:29:40.480' ,`MLSNumber` = '77203036' ,`ListAgentFullName` = 'Keri Holloway' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = 'Keri Holloway' ,`SellingOfficeName` = 'Ross & Marshall Realty' ,`Latitude` = '29.189291' ,`Longitude` = '-95.437235' ,`PhotoCount` = '26' ,`PostalCode` = '77515' ,`RoomCount` = '9' ,`ListPrice` = '290000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shannon' ,`StreetNumber` = '221' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATED IN THE HEART OF ANGLETON. This split floor plan features 3 bedrooms and 2 baths. OPEN KITCHEN. GRANITE COUNTERTOPS. STAINLESS STEEL MICROWAVE, STOVE, AND DISHWASHER. TILE FLOORING IN All LIVING SPACE, CARPET IN BEDROOMS, GUTTERS, CORDLESS SOLAR SHADE BLINDS THROUGHOUT and COVERED PATIO. Make an appointment today to see this beautiful home..' ,`Acres` = '0.2049' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TIGNER TERRACE (ANGLETON) BLK 2 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8925' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tigner Terrace Angleton' ,`TaxAmount` = '6290' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834947' WHERE `Matrix_Unique_ID` = '213021469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:58:54.230' ,`MLSNumber` = '84414452' ,`ListAgentFullName` = 'Elsie Yates' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.377210' ,`Longitude` = '-94.964410' ,`PhotoCount` = '13' ,`PostalCode` = '77568' ,`RoomCount` = '3' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue B' ,`StreetNumber` = '220' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investor opportunity!!! 3 Lots property! 3 bedrooms, 2 full baths with a lot of potential. Prime location.' ,`Acres` = '0.3306' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOTS 11,12 & 13 BLK 2 BOGATTOS ADDN' ,`LotDesciption` = 'Wooded' ,`LotSize` = '14400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bogatto Add' ,`TaxAmount` = '1570' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834947' WHERE `Matrix_Unique_ID` = '213021664' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:54:22.330' ,`MLSNumber` = '80972345' ,`ListAgentFullName` = 'Kristin Hampton' ,`ListOfficeName` = 'Prime Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.263632' ,`Longitude` = '-94.235523' ,`PhotoCount` = '24' ,`PostalCode` = '77657' ,`RoomCount` = '7' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Palace' ,`StreetNumber` = '6705' ,`StreetSuffix` = '' ,`City` = 'Lumberton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2703' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome friends and family into this gorgeous new construction! Open, inviting spaces are perfect for entertaining, or just settling in for a cozy night by the wood burning fireplace. Tucked away on over a half acre, this home pairs over 2700 square feet of thoughtfully constructed, modern country aesthetics with an impressively impeccable use of space. Exemplifying well-engineered construction, this home’s unifying sense of space and 15-foot vaulted ceiling are enriched with light and airy, high-end finishes. The split floor plan offers a spacious primary suite with beautiful coffered ceilings. The primary en suite bath features a gorgeous oversized soaking tub, separate tiled shower with pebble floor, and double vanity. This amazing space also boasts a walk-in closet with built-in dressers and hidden storage. Topping off the country luxe of the primary suite is a kitchen that doesn\'t miss--perfect for making memories of a lifetime.' ,`Acres` = '0.58' ,`Area` = '49' ,`BuilderName` = 'Moses Ent.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Francisco Arriola League, Abstract No. 2,Hardin County, TX' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Contemporary/Modern,Craftsman' ,`Subdivision` = 'Tranquil Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834947' WHERE `Matrix_Unique_ID` = '213053446' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:12:15.373' ,`MLSNumber` = '71753074' ,`ListAgentFullName` = 'Lina Botero' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906570' ,`Longitude` = '-95.717149' ,`PhotoCount` = '35' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '469700.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Horizon' ,`StreetNumber` = '8839' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL HOME ON EXTRA LARGE LOT OF 14,186 SQFT-MOVE IN READY HOME-Zoned to acclaimed CY-FAIR SCHOOLS & LOADED with must have UPGRADES, soaring ceilings, recess lights, engineering flooring (EVP) downstairs, Open concept kitchen; granite counter tops, designed backsplash & Island seating, dining & Family room. Primary suite down; MOTHER IN LAW SUITE, COLLEGE STUDENT OR GUESTS SUITE (Down), full bath down, wrought iron spindle, gameroom up, SUITE WITH PRIVATE BATHROOM (up). SMART LOCK, TANKLESS WATER HEATER, REVERSE OSMOSIS WATER SYSTEM, WATER SOFTENER-ALL INCLUDED, jellyfish-outdoor lighting INCLUDED, wrap around gutters, French drain, Covered patio w/ ceiling fan & extended flooring. BIG lot with enough room for a pool. -Amenities; Pool, walking trails, playground, recreation center, tennis, sand volleyball, dog park; access to Jr. Olympic Pools, basketball pavilion, exercise room, it has a lot to offer. CHECK OUT THE PHOTOS DESCRIPTION FOR ADDITIONAL INFO. Great place to call HOME.' ,`Acres` = '0.3257' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 MIRAMESA SEC 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '14186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '940' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Miramesa Sec 5' ,`TaxAmount` = '10119' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834948' WHERE `Matrix_Unique_ID` = '213084293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:48:39.453' ,`MLSNumber` = '41373423' ,`ListAgentFullName` = 'Kami Cudd' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.344959' ,`Longitude` = '-95.530910' ,`PhotoCount` = '38' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Billingsgate Chase' ,`StreetNumber` = '483' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful David weekly floor plan located on a Greenbelt and a cul-de-sac lot. Wonderfully maintained and ready for move-in. The back porch has been extended and partially screened in. Located to all major roads and highways, retail/shopping and schools. All appliances stay. ' ,`Acres` = '0.1399' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582102 - HILLS OF WESTLAKE 02, BLOCK 4, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '6095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hills Of Westlake 02' ,`TaxAmount` = '6810' ,`TaxRate` = '2.8638' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834948' WHERE `Matrix_Unique_ID` = '213113251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:07:00.983' ,`MLSNumber` = '8839890' ,`ListAgentFullName` = 'Jennifer Leteff' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294714' ,`Longitude` = '-95.412343' ,`PhotoCount` = '26' ,`PostalCode` = '77301' ,`RoomCount` = '10' ,`ListPrice` = '286000.00' ,`Status` = 'Active' ,`StreetName` = 'Tulip Poplar' ,`StreetNumber` = '3017' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1977' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story home located in the neighborhood of Barton Creek Ranch. This home features 4 bedrooms, all of which are located upstairs. There are 2 bathrooms upstairs and a half bath downstairs for your guests. Beautiful Wood Look Tile flooring in the kitchen and entryway, upgraded Granite Countertops and GE appliances. Fridge, Washer and Dryer to stay with the home. Primary bath contains dual vanity, his and her closets, separate tub and shower. Covered back patio and fenced in back yard for your pets and gatherings. This home is located on a quiet cul-de-sac street. Conveniently located near shopping, parks and schools, and provides easy access to I-45, Loop 336 and SH 105. Schedule a showing today and make this house your new HOME!' ,`Acres` = '0.1457' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S249600 - BARTON CREEK RANCH 01, BLOCK 2, LOT 26' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Creek Ranch' ,`TaxAmount` = '5667' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834948' WHERE `Matrix_Unique_ID` = '213320483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:08:14.503' ,`MLSNumber` = '47088540' ,`ListAgentFullName` = 'Adam Sanders' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674226' ,`Longitude` = '-95.181431' ,`PhotoCount` = '36' ,`PostalCode` = '77502' ,`RoomCount` = '9' ,`ListPrice` = '279500.00' ,`Status` = 'Active' ,`StreetName` = 'Fisher' ,`StreetNumber` = '2201' ,`StreetSuffix` = 'Court' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this gorgeous home in one of the most well established subdivisions in Pasadena. You will fall in love with all the gorgeous updates which include, all new laminate flooring, new granite countertops, stylish subway tile backsplash, all new paint, newly tiled primary shower. You can also be reassured that big ticket items like roof (2019), and HVAC system to include all new ductwork (2019) have been taken care of for you. Enjoy morning coffee on your covered deck, back yard oasis. Enjoy lots of additional square footage in the primary bedroom dressing area. Enjoy the small town feel as the schools are within walking distance.' ,`Acres` = '0.2075' ,`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 13 BLK 6 PARKVIEW ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FISHER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkview Estates' ,`TaxAmount` = '4941' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834948' WHERE `Matrix_Unique_ID` = '213385556' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:00:22.740' ,`MLSNumber` = '10266693' ,`ListAgentFullName` = 'Betsy Sherman' ,`ListOfficeName` = 'Lot & Block Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823536' ,`Longitude` = '-95.553141' ,`PhotoCount` = '36' ,`PostalCode` = '77043' ,`RoomCount` = '4' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Fontana' ,`StreetNumber` = '2811' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2295' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully reimagined home in desirable & convenient Spring Shadows. The soothing, neutral color palette will compliment any style. Upon entry you are greeted with engineered wood floors that carry throughout the home. An open concept allows for easy entertaining in the light filled living spaces. The study/flex space with french doors off of the dining area is ideal for working from home. Custom cabinetry & built ins create an abundance of storage in the kitchen, bathrooms & closets. Three large secondary bedrooms share a hall bath with double vanity & tub/shower combo with lighted niche! Spacious primary suite offers a space to sit & read or take in views of the large backyard. Designer touches throughout the ensuite bath make for a relaxing space to get ready for the day! Updates incl. *pex plumbing, foundation w/ warranty, new roof, water heater, HVAC & ductwork, & stainless appliances to name a few! *Per seller. Ideal location with access to Beltway 8, I-10 & 290!' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK W17 SPRING SHADOWS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 10' ,`TaxAmount` = '8985' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834948' WHERE `Matrix_Unique_ID` = '213455691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:39:35.310' ,`MLSNumber` = '33873419' ,`ListAgentFullName` = 'Eduardo Garza' ,`ListOfficeName` = 'GAREBA Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647653' ,`Longitude` = '-95.937463' ,`PhotoCount` = '6' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '790000.00' ,`Status` = 'Active' ,`StreetName` = 'Wellborn' ,`StreetNumber` = '3507' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction. Home greets you with massive IRON double doors, towering front porch, king size brick and wood accents. High ceilings and wood beams will continue inside throughout the oversized hallway that provides unobstructed view of the backyard thru a wall full of sliding doors that open towards the massive and high-ceiling covered patio. Kitchen will include pot filler, quartz countertops, matte black hardware, designer paint/backsplash, oversized range hood and KitchenAid appliances package. High ceilings with exposed beams also in primary bedroom, dining, family, game room and foyer. You will love the owners\' ensuite, it boasts a two person walk-in shower with independent temp valves and freestanding tub. Laundry is centrally located and includes luxury pet shower and direct access to primary closet! Built-in Pest Defense system, 10 year structural warranty, gutters and sprinkler system also included. Low taxes! Ask for list of upgrades!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'GAREBA Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Reserve At Weston Lakes Sec 1, BLOCK 2, Lot 13' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '11282' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Reserve at Weston Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834949' WHERE `Matrix_Unique_ID` = '213516341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:38:42.130' ,`MLSNumber` = '57442584' ,`ListAgentFullName` = 'Eduardo Garza' ,`ListOfficeName` = 'GAREBA Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648870' ,`Longitude` = '-95.935812' ,`PhotoCount` = '6' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '787500.00' ,`Status` = 'Active' ,`StreetName` = 'Waterfowl' ,`StreetNumber` = '32707' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction. Home will greet you with massive IRON double doors, towering front porch, king size brick and wood accents. High ceilings and wood beams will continue inside throughout the oversized hallway that provides unobstructed view of the backyard thru a wall full of sliding doors that open towards the massive and high-ceiling covered patio. Kitchen will include pot filler, quartz countertops, matte black hardware, designer paint/backsplash, oversized range hood and KitchenAid appliances package. High ceilings with exposed beams also in primary bedroom, dining, family, game room and foyer. High ceilings and wood accents continue in 2nd story! You will love the owners\' ensuite, it boasts a two person walk-in shower with independent temp valves and freestanding tub. Laundry is centrally located and includes luxury pet shower and direct access to primary closet! Built-in Pest Defense system, 10 year structural warranty, gutters and sprinkler system also included. Low taxes!' ,`Acres` = '0.2456' ,`Area` = '30' ,`BuilderName` = 'GAREBA Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RESERVE AT WESTON LAKES SEC 1, BLOCK 1, LOT 29' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '10700' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Reserve At Weston Lakes Sec 1' ,`TaxAmount` = '1411' ,`TaxRate` = '2.1698' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834949' WHERE `Matrix_Unique_ID` = '213517154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:54:04.377' ,`MLSNumber` = '10946295' ,`ListAgentFullName` = 'Gay Fundling' ,`ListOfficeName` = 'Galveston Island Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.074282' ,`Longitude` = '-95.126492' ,`PhotoCount` = '20' ,`PostalCode` = '77541' ,`RoomCount` = '6' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '13118' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction, with a contemporary design. Enjoy beautiful views of the Bay from the front porch. Walk in to a spacious family room with bright bamboo flooring. Open kitchen and dining area with granite counter tops. Two bedrooms on the main floor with custom tile bath and jacuzzi tub! Two spacious primary suites upstairs with private bath tiled walk in showers. Enjoy stepping out onto your own private balcony. This subdivision has a public boat ramp near by.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Steve Jones' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Treasure Island Blk 6 Lot 13' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667834949' WHERE `Matrix_Unique_ID` = '213593026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:23:44.063' ,`MLSNumber` = '13233037' ,`ListAgentFullName` = 'Mary Beth Hughes' ,`ListOfficeName` = 'Wolf Realty' ,`SellingAgentFullName` = 'Mary Beth Hughes' ,`SellingOfficeName` = 'Wolf Realty' ,`Latitude` = '29.962361' ,`Longitude` = '-95.165636' ,`PhotoCount` = '31' ,`PostalCode` = '77044' ,`RoomCount` = '12' ,`ListPrice` = '576000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sawyer Knoll' ,`StreetNumber` = '16418' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home with so many special features and upgrades. Custom pool with large hot tub & 20 ft waterfall, volleyball net holders, 4-hole putting green, 10X10 storage building & outdoor shower, all added in 2020. Huge covered patio and stone-looking tile all around the pool and decking. All brick home, low maintenance back yard, 16 SEER AC w/Puron, two water heaters replaced in 2021, extra shelving added to all closets & walk-in pantry, cedar planking in den and garage. epoxy floors in oversized garage, cedar lined walk-in closets in primary BR, all carpet replaced upstairs 9/2022, all walls painted neutral 10/2022, walk-in attic, two Texas basements (one could made into another BR, Craft room, etc) upstairs desk/nook, huge hall linen closet, granite countertops, custom entertainment center for large flat screen TV, They variety of living spaces offers a family lots of privacy and ability to have different activities in many areas. Walk to the elementary school. shopping nearby.' ,`Acres` = '0.1928' ,`Area` = '1' ,`BuilderName` = 'PERRY HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 1 LAKESHORE SEC 11' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'LAKESHORE' ,`TaxAmount` = '11426' ,`TaxRate` = '2.863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834949' WHERE `Matrix_Unique_ID` = '213604309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:58:39.020' ,`MLSNumber` = '77186661' ,`ListAgentFullName` = 'Kaleb Monroe' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.589269' ,`Longitude` = '-95.205529' ,`PhotoCount` = '41' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '252500.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Joy' ,`StreetNumber` = '11319' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1946' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this completely renovated home sitting on a 6,720 sqft lot with no back door neighbors!! You walk into a beautiful open kitchen-living room concept that includes a BRAND NEW remodeled kitchen with NEW cabinets, NEW grey granite countertops, a NEW microwave, and a NEW dishwasher! All the doors throughout the home are NEW, as well as NEW framing, and absolutely NEW tile throughout the entire home! Through the renovation, the garage was converted to a fresh NEW bedroom living space with cool tones on the walls and plenty of closet space in all bedrooms. This home is ready for its new owner, come out and check it out yourself!' ,`Acres` = '0.1543' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 37 BLK 11 WOOD MEADOWS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BURNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wood Mdw Sec 02 Reserve A' ,`TaxAmount` = '4983' ,`TaxRate` = '2.7255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834950' WHERE `Matrix_Unique_ID` = '213645162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:07:00.857' ,`MLSNumber` = '95350905' ,`ListAgentFullName` = 'Debra Bunton' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960161' ,`Longitude` = '-95.202407' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '597000.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11914' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW BUILT 3/22! **SELLER CONTRIBUTION TO CLOSING COST. Extended entry offers spacious home office and media room with French doors. Formal dining flows into open family room with wood mantel fireplace and wall of windows offering lots of natural light. Kitchen has a walk-in pantry and generous island with bar stool space. Primary suite includes entry to bath with dual vanities, garden tub, separate shower and two walk-in closets. Guest suite offers a private bath. High ceilings and abundant closet space add to this four-bedroom design. Extended covered backyard patio, sizeable backyard with trees and no back neighbors. Star Furniture in Family room includes leather sofa, 2 chairs/ottoman, 3 tables=($6.9K), stainless steel 3-door GE refrigerator=($2K) and custom remote window shades=($7K) will stay with any accepted offer. Amenities and activities abound in this neighborhood surrounded by trees, trails, parks, pool, splashpad, fishpond, pavilion, nearby schools, and so much more!' ,`Acres` = '0.1926' ,`Area` = '1' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 GROVES SEC 34' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1088' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Groves Sec 34' ,`TaxAmount` = '2339' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834950' WHERE `Matrix_Unique_ID` = '213696147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:02:30.533' ,`MLSNumber` = '68684756' ,`ListAgentFullName` = 'Justin Jaehne' ,`ListOfficeName` = 'General Property & Services' ,`SellingAgentFullName` = 'Catherine Reilly' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.817043' ,`Longitude` = '-95.701876' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '3' ,`ListPrice` = '429000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Canyon River' ,`StreetNumber` = '19014' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow check out this beautiful fully renovated home! Home fully gutted and updated with high end finishes throughout. Amazing primary suite with soaking tub, large marble shower and extensive walk-in closet. New luxury laminate flooring, Quartz countertops, appliances, retractable patio cover and much more! Excellent subdivision with tennis courts, playgrounds & pool. LOW TAXES & LOW HOA fees! Never flooded. Zoned to Katy ISD Schools. Near I-10 with quick access to Energy Corridor, West Houston Medical Centers, restaurants and more. Make your appointment soon!' ,`Acres` = '0.1681' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 BARKERS RIDGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7324' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkers Ridge Sec 04' ,`TaxAmount` = '5961' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834950' WHERE `Matrix_Unique_ID` = '213753307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:43:36.850' ,`MLSNumber` = '24193294' ,`ListAgentFullName` = 'Eliodoro Alanis Bautista' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821326' ,`Longitude` = '-95.024003' ,`PhotoCount` = '14' ,`PostalCode` = '77562' ,`RoomCount` = '4' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Fern' ,`StreetNumber` = '8611' ,`StreetSuffix` = 'Circle' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in a cul-de-sac, beautifully shaded front yard, with an oversized covered porch. Spacious living room with a built in fireplace, recessed lighting, tile throughout the home. Paved walkway from front yard to the fully fenced large backyard, with an in ground pool, & gazebo. Schedule your showing today!' ,`Acres` = '0.3122' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 52 COUNTRY TERRACE U/R' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Terrace U/R' ,`TaxAmount` = '3502' ,`TaxRate` = '2.235' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834950' WHERE `Matrix_Unique_ID` = '213758057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:50:24.470' ,`MLSNumber` = '31741828' ,`ListAgentFullName` = 'Maribel Granados' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747303' ,`Longitude` = '-95.747033' ,`PhotoCount` = '19' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '382000.00' ,`Status` = 'Active' ,`StreetName` = 'Wittman' ,`StreetNumber` = '21615' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3089' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautifully kept 4 bedroom, 2 and 1/2 bath home that features a unique entrance to the office/study, with a spacious dining room. Kitchen boast new wood look vinyl plank flooring, new dishwasher, and new gas oven. Tall ceilings in living room with a cozy fireplace. Elegant wood floor staircase leads up to a spacious gameroom for plenty of fun activities for the family. Primary bedroom and bathroom display beautiful stained glass windows. NO CARPET! Big backyard with garden area ready for your touch. Great community amenities including community pool, splash pad for the little ones, and 2 tennis courts. And last but not certainly not least the home is zoned to highly sought after Katy ISD.' ,`Acres` = '0.1873' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 OAK PARK TRAILS SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Park Trails Sec 02' ,`TaxAmount` = '6680' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834950' WHERE `Matrix_Unique_ID` = '213766245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:35:49.833' ,`MLSNumber` = '95027572' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.243018' ,`Longitude` = '-95.896447' ,`PhotoCount` = '32' ,`PostalCode` = '77484' ,`RoomCount` = '3' ,`ListPrice` = '739000.00' ,`Status` = 'Active' ,`StreetName` = 'Round Up' ,`StreetNumber` = '17752' ,`StreetSuffix` = '' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning custom built home is tucked away on 1 acre and features beautiful mature trees. A countryside residence is your escape that provides the privacy you are looking for. This one story Austin Limestone/brick home is the perfect residence for family living and/or entertainment. The home features custom-made cabinets and built ins throughout. The spacious kitchen is a dream with granite countertops, stainless steel appliances, farmhouse sinks, huge island and a double oven. Open floorplan into the the main living room with it\'s high ceiling, beautiful wood beam and fireplace. Lots of large windows/natural light looking towards backyard. Barn doors lead into the study. The very private Primary Bed/bath is AMAZING. The large walk-in shower is extraordinary as is the beautiful separate bathtub. Granite countertops and built ins in primary closet. Enjoy outdoor country living year round on large covered back patio. This residence/property in Waller, TX is one of a kind!' ,`Acres` = '' ,`Area` = '60' ,`BuilderName` = 'Rvision Homes Ltd' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S7644 - SADDLE CREEK FOREST SEC. 4, BLOCK 6, LOT 6, ACRES 1.' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'SADDLE CREEK FOREST' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667834951' WHERE `Matrix_Unique_ID` = '213793518' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:40:05.603' ,`MLSNumber` = '33916408' ,`ListAgentFullName` = 'Dawn Walther' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948330' ,`Longitude` = '-95.746149' ,`PhotoCount` = '43' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '864999.00' ,`Status` = 'Active' ,`StreetName` = 'Covey' ,`StreetNumber` = '17111' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS Brick/Stone/Stucco Elevation CUSTOM HOME with HEATED POOL, SPA AND WATERFALL, Porte Cochere, 4 Beds (2 Down) /4.5 Baths/3 Car Garage. Covered patio with travertine decking. Study with Ceiling Beams, Formal Dining Room with custom window treatments, game room & media room with double doors! Gourmet Island Kitchen w/ Amazing Glazed Cabinets, Customized window treatments and Granite Countertops with upgraded appliances! Family Room w/ High Ceilings & Corner Fireplace. Elegant 6 3/8\" Hickory Hardwood Floors in Dining/Entry/Family/Study. Fabulous Master Suite w/ Corner Tub, Separate 80\" Frameless Shower & Two Walk-in Closets. Covered Travertine Patio with sparkling PEBBLETEC HEATED POOL, SPA AND WATERFALLS (BUILT IN 2020) and putting green! Energy Efficient w/ 16 SEER HVAC System, Radiant Barrier, Three car garage with hanging garage storage and epoxy floors, built out storage off media room. Smaller separate garage area for golf cart. SOOO many upgrades this one will go quick!' ,`Acres` = '0.2489' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 BRIDGELAND HIDDEN CREEK SEC 25' ,`LotDesciption` = 'Other' ,`LotSize` = '10841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'BRIDGELAND' ,`TaxAmount` = '18775' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834951' WHERE `Matrix_Unique_ID` = '213807408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:10:45.630' ,`MLSNumber` = '69421240' ,`ListAgentFullName` = 'Brett Sims' ,`ListOfficeName` = 'Sold-It Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.199911' ,`Longitude` = '-95.219569' ,`PhotoCount` = '41' ,`PostalCode` = '77357' ,`RoomCount` = '11' ,`ListPrice` = '659900.00' ,`Status` = 'Active' ,`StreetName` = 'Northcrest' ,`StreetNumber` = '17153' ,`StreetSuffix` = 'Circle' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3023' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop the CAR!!! Location, Location, Location!!! Hard to find, beautiful home located on over 3 acres with incredible pool, oversized 3 car garage with carport, pond, RV Hookups and so much more! This amazing home boast incredible curb appeal sure to impress your friends and family! As you pull into the drive you\'ll feel right at home, what an incredible time to buy, just in time to decorate for the Holidays! If you love to cook, or entertain, this home has an oversized dream kitchen, 2 ovens, oversized cooktop, incredible island, and an abundance of counter space. With 4 Bedrooms, Game Room, and an office you\'ll have plenty of space for your friends and family! \r\n\r\nIdeal location with easy access to I-45 and I-69, hurry and schedule your showing, this home won\'t last long!\r\n\r\nOpen House 11/06 from 12-2' ,`Acres` = '3.01' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'NORTHCREST RANCH 01, BLOCK 2, LOT 17' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '131116' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northcrest Ranch 01' ,`TaxAmount` = '9033' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834951' WHERE `Matrix_Unique_ID` = '213810784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:33:13.447' ,`MLSNumber` = '56188970' ,`ListAgentFullName` = 'Victoria Harter' ,`ListOfficeName` = 'Henson Land & Ranch Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.462371' ,`Longitude` = '-96.103707' ,`PhotoCount` = '26' ,`PostalCode` = '75831' ,`RoomCount` = '8' ,`ListPrice` = '239500.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 356' ,`StreetNumber` = '18125' ,`StreetSuffix` = '' ,`City` = 'Buffalo' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this charming 3 bed 2.5 bath brick home sitting on just over 1 unrestricted acre in the highly sought-after Leon County, TX. Being halfway between Dallas and Houston this is the ideal location for those escaping the city life, those that are already local to Buffalo, or absolutely anybody looking for quiet country living. Enjoy sitting in the quaint dining area watching deer roam through the park like fenced in back yard, or watching your kids run and play outside. Both the front and back yards are spacious and boast large mature trees. The kitchen has been opened to the living area allowing family to truly enjoy their time together making memories. In addition to the square footage of the home there is also a large attached 2 car garage. The huge master bedroom allows for furniture of all sizes. Lastly, the laundry area/mud room have a half bath conveniently located at the side entrance door.\r\nAlso included is a portable building. \r\nCall for an appointment!' ,`Acres` = '1.03' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Buffalo Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR CREEK ESTATES LT 19 1.03 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '44867' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '194 - Buffalo' ,`SchoolElementary` = 'BUFFALO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUFFALO HIGH SCHOOL' ,`SchoolMiddle` = 'BUFFALO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Creek Estates' ,`TaxAmount` = '2278' ,`TaxRate` = '1.8381' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834951' WHERE `Matrix_Unique_ID` = '213857126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:49:13.147' ,`MLSNumber` = '96958772' ,`ListAgentFullName` = 'Tina Reynolds' ,`ListOfficeName` = 'Allsource Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.279884' ,`Longitude` = '-94.820542' ,`PhotoCount` = '22' ,`PostalCode` = '77551' ,`RoomCount` = '0' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue R' ,`StreetNumber` = '5109' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Per Seller the 2 lots were combined in 2014. You can potentially separate back into 2 lots. Onus is on the buyer to confirm this information. \r\n\r\nInvestor Special! Unique, double-lot property offers 3 structures: One main home, an efficiency, and a storage building. Upgrade or tear down; a discerning eye can see all possibilities. The main structure is 2 stories, not in a flood zone, and none of the property/buildings have ever flooded. Sellers have done much of the interior demo for you! House could be remodeled into an Air BNB with a 2 bedroom apt downstairs, and 2 bedrooms up (1 bath per floor). Brand new windows have been installed throughout upstairs of main building. Efficiency was built in 2019 and would be a great separate Air BNB income producer. Create your dream vacation home or rental, just a few short blocks from the beach. Lot is about 50\' wide and 120\' deep.' ,`Acres` = '0.1378' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 7 & 8 BLK 155 DENVER RESURVEY**' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'DENVER RESURVEY' ,`TaxAmount` = '2798' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834952' WHERE `Matrix_Unique_ID` = '213870644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:48:56.660' ,`MLSNumber` = '23774159' ,`ListAgentFullName` = 'Valerie Gil' ,`ListOfficeName` = 'Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.330192' ,`Longitude` = '-94.941473' ,`PhotoCount` = '43' ,`PostalCode` = '77563' ,`RoomCount` = '8' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Vista Drive' ,`StreetNumber` = '77' ,`StreetSuffix` = 'Drive' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live the dream in paradise! Enjoy fishing from your backyard and breathtaking sunsets. 4 /5 Bedrooms + Study. Step inside to find an open floor plan with fresh paint, new luxury vinyl flooring & brick fireplace. living area, study, sitting area next to dining, 2 living areas, 2 kitchens, complete w/ stainless steel appliances, quartz counters, modern black fixtures & breakfast bars with seating for a crowd. 3 baths feature custom-tiled showers with niches & glass doors. The master suite offers a dual-sink vanity & 2 walk-in closets. There’s even more room to spread out in the huge lower level, which offers a rec room, bedroom & half bath. Recently updated low e-Windows. Spectacular outdoor living, 3 covered patios w/massive deck overlooking the canal. Covered boat slip & lift! Enjoy endless summer fun year round. Lots of extra space under the house for all your outdoor gear. Located minutes from shopping + dining in Galveston. Community Park & Pool! Don\'t let this one get away!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Abst 7 S C Bundick Sur Lot 77 & NE 30ft of Lot 78 Bayou Vist' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '9539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Bayou Vista' ,`TaxAmount` = '5833' ,`TaxRate` = '2.29' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834952' WHERE `Matrix_Unique_ID` = '213943798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:43:20.143' ,`MLSNumber` = '63559474' ,`ListAgentFullName` = 'Riaz Ahmed' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037302' ,`Longitude` = '-95.523564' ,`PhotoCount` = '24' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Masters' ,`StreetNumber` = '6710' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in mature trees on a huge 20,429 sqft premium lot with lush landscaping making this home a real gem of Spring Creek Forest. The roof, siding, open floor plan, porcelain tiles (18x18 Kitchen & 12x24 in baths), 12 mm laminate floors, carpet, granite counter tops, and brand new bronze fixtures were all updated in 2018. The living room and master feature high vaulted ceilings. Kitchen is open concept with island and breakfast perfect for entertainment. Baths have double vanity, framed mirrors and shower tiles. You’ll have plenty of space for theater seating in your upstairs game room. Easy commute to The Woodlands, Tomball, Conroe & Cypress via Grand Parkway, Hwy 249, & I45. Premier shopping, dining & entertainment is a short driving distance! Klein ISD & private schools nearby. NO FLOODING.' ,`Acres` = '0.4689' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 17 017*S6353500-002-017-007 SPRING CREEK FOREST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Forest Sec 02' ,`TaxAmount` = '5608' ,`TaxRate` = '2.5315' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834952' WHERE `Matrix_Unique_ID` = '213973205' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:36:15.590' ,`MLSNumber` = '41446703' ,`ListAgentFullName` = 'Daphne Brown' ,`ListOfficeName` = 'Beyond the Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.449181' ,`Longitude` = '-95.445616' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Penfield' ,`StreetNumber` = '9203' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This beautiful one story home is situated on a corner lot in the Master Planned Community of Sterling Lakes. This home features three bedrooms, two full bathrooms, and light and bright finishes throughout! It\'s ideally located in close proximity to Sanchez Elementary School, Neighborhood HEB, and the coming soon, Crystal Lagoon Development. The kitchen features granite countertops, stainless steel appliances, & a breakfast bar. It opens to the living room to make entertaining & enjoying the house a breeze. The primary bedroom features an en-suite bath with a double vanity, and two walk in closets. Enjoy the outdoors by taking evening walks around the neighborhood, and kicking back in your very own backyard which features a beautiful and cozy covered patio, perfect for having dinner or just being outside. Residents are allowed to utilize Sierra Vista & Sterling Lakes amenities.' ,`Acres` = '0.1421' ,`Area` = '5' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 13 (A0289 HT&B) BLK 5 LOT' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sterling Lks/Iowa Colony Sec 1' ,`TaxAmount` = '7496' ,`TaxRate` = '3.5607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834952' WHERE `Matrix_Unique_ID` = '214015228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:36:30.640' ,`MLSNumber` = '28111982' ,`ListAgentFullName` = 'Marilyn Carson' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146828' ,`Longitude` = '-95.553914' ,`PhotoCount` = '50' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Twin Ponds' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Darling home located on large quiet cul-de-sac lot with no back neighbors with covered patio with fireplace! This home is move in ready and is within walking distance to Creekside Parks many amenities including Theater, HEB, restaurants, exercise, elementary and middle schools, parks, pools and more. The home features gorgeous hardwood floors throughout downstairs, high ceilings, Plantation Shutters, formal dining, mud room area, a secondary bedroom or office down with full bath, Amazing white kitchen open to family room with huge island workspace, double ovens, gas cooktop, quartz counters and walk in pantry. The primary suite features high ceilings, wall of windows, executive bath with his and hers vanities, soaking tub and walk in shower. Upstairs there are 3 large secondary beds, one with ensuite bath, two that share a bath, large game room and separate media room. There is also a 2.5 car attached garage which includes a separate storage area.' ,`Acres` = '0.2764' ,`Area` = '14' ,`BuilderName` = 'Darling' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Exclusions,Mud,Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST 10' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '12041' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Creekside Park West' ,`TaxAmount` = '11296' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834952' WHERE `Matrix_Unique_ID` = '214039038' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:23:49.417' ,`MLSNumber` = '77026405' ,`ListAgentFullName` = 'Marlynda Jennings' ,`ListOfficeName` = 'LouTex Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679169' ,`Longitude` = '-95.339134' ,`PhotoCount` = '6' ,`PostalCode` = '77033' ,`RoomCount` = '7' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Anzio' ,`StreetNumber` = '5206' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home for sale in well developed neighborhood with many new builds in the area. Five bedrooms and two bathrooms with a den. Home square footage and bedrooms is larger than tax records. Some updates have been done. With added touches this home can meet the needs of any new homeowner. Investors Welcome. PROPERTY SOLD AS-IS SELLER WILL DO NO REPAIRS. BUYER OR BUYER AGENT TO VERIFY SQUARE FOOTAGE AND ROOM DEMENSIONS.' ,`Acres` = '0.1869' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 18 SOUTH PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Park Add Sec 02' ,`TaxAmount` = '2446' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834953' WHERE `Matrix_Unique_ID` = '214056861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:08:21.413' ,`MLSNumber` = '94538345' ,`ListAgentFullName` = 'Mariana Urdaibay' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051368' ,`Longitude` = '-95.355690' ,`PhotoCount` = '31' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Goodfellow' ,`StreetNumber` = '23402' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1134' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning cozy home ready for a buyer to move in. Some many details and love were put into every corner of this fully remodeled home that will surprise you as you cross the front door. \r\nThree bedroom, two bath; open floor plan, lots of light and a very nice backyard with a cover terrace to enjoy your evenings and entertain.' ,`Acres` = '0.1389' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 12 FAIRFAX SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfax Sec 02' ,`TaxAmount` = '2702' ,`TaxRate` = '2.9367' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834953' WHERE `Matrix_Unique_ID` = '214067430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:13:10.973' ,`MLSNumber` = '38556546' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.198881' ,`Longitude` = '-96.021892' ,`PhotoCount` = '30' ,`PostalCode` = '77445' ,`RoomCount` = '4' ,`ListPrice` = '328460.00' ,`Status` = 'Active' ,`StreetName` = 'Pin Oak' ,`StreetNumber` = '26565' ,`StreetSuffix` = 'Drive' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful NEW, 4 bedroom, 2,206 square foot home in the gated Deerwood Lakes Subdivision of Hempstead. This home features an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. The home also features a gameroom and extened patio, large windows for abundant natural light throughout. 2 car garage. Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living. Build in Deerwood OR let us help you find the best location for your home in Waller County. You can live in an area where you have neighbors nearby or enjoy your solitude with some acreage surrounding you.' ,`Acres` = '0.2288' ,`Area` = '26' ,`BuilderName` = 'Freedom Star Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S455200 DEERWOOD LAKES 2 LOT 223' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9967' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Deerwood Lakes' ,`TaxAmount` = '293' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667834953' WHERE `Matrix_Unique_ID` = '214073695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:04:12.960' ,`MLSNumber` = '10969121' ,`ListAgentFullName` = 'Edrina Fitting' ,`ListOfficeName` = 'Ladybug, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586784' ,`Longitude` = '-95.105674' ,`PhotoCount` = '41' ,`PostalCode` = '77059' ,`RoomCount` = '8' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Craighurst' ,`StreetNumber` = '16423' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A BEAUTIFUL CONTEMPORARY/TRADITIONAL HOME BUILT BY QUALITY KUSTOM KASTLE. CLIENTS SAY THEY JUST WANT TO LOOK AT HOUSES BUILT BY HIM! GORGEOUS HOME ON THE ESTATE STREET OF PRESTIGIOUS BROOK FOREST!! CRAIGHURST DR HOMES ARE UNIQUE AND ONE OF A KIND. LOOKING FOR A QUIET BUT NEIGHBORLY LOCATION...DON\'T MISS THIS ONE!!THIS HOME BOASTS W/ FAMILY AMENITIES OR AN ENTERTAINING HOME W/FRIENDS. KIDS CAN HAVE A FAMILY ROOM AT ONE END OF THE HOUSE LOOKING OVER THE POOL WHILE ADULTS CAN PLAY BRIDGE WITH THE BACKDROP OF THE OVERSIZED PRIVATE POOL.AN AMAZING FLOOR PLAN W/4 BATHROOMS, OVERSIZED KITCHEN(almost double the size of most kitchens.)\r\nKITCHEN IS ADJACENT TO THE GAME ROOM-FIREPLACE-ABUNDANCE OF BUILT-INS-DOUBLE CLOSET FOR THE WINTER JACKETS, SPORTS ITEMS,ETC.THE UPDATES...ARE TASTEFULLY DONE W/UNIQUE FEATURES..NO CARPET ON FIRST FLOOR.SELLER SAYS NO FLOODING.MOST OF THE HOUSE HAS PELLA EFFICIENT WINDOWS, 2 YEAR OLD ROOF, 2018 FENCE, $12K HI EFFICIENT PATIO DOOR.LG POOL.' ,`Acres` = '0.2376' ,`Area` = '7' ,`BuilderName` = 'KUSTOM KASTLE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 87 BROOK FOREST SEC 1 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '10350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Brook Forest Sec 01 R/P' ,`TaxAmount` = '9391' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834953' WHERE `Matrix_Unique_ID` = '214099774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:35:24.843' ,`MLSNumber` = '97290971' ,`ListAgentFullName` = 'Paige Houston' ,`ListOfficeName` = 'Texas Real Estate Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.941785' ,`Longitude` = '-95.628129' ,`PhotoCount` = '32' ,`PostalCode` = '77065' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Counselor' ,`StreetNumber` = '11506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Charming three bedroom, two bathroom one story home in the Meisterwood subdivision! This home has been beautifully maintained and has several BIG UPGRADES completed! Beautiful above builder-grade custom windows by Renewal by Anderson throughout the entire home. The spacious open concept living area offers high ceilings, built in shelving, a brick fireplace & ample room for furnishings. Above-builder grade 17-seer Coleman AC unit with new air ducts and furnace! PEX PLUMBING THROUGHOUT THE ENTIRE HOME IN 2019! OVERSIZED 50 GALLON WATER HEATER IN 2019. REVERSE OSMOSIS SYSTEM in the kitchen! FENCE REPLACED IN 2017 & 2019. Oversized covered back patio. The washer and dryer will stay with the home. Zoned to Cy-Fair ISD. Located close to 290, BW 8 & 99. HOA dues include trash pickup, use of the clubhouse and pool. This home will not last long, schedule your showing today!' ,`Acres` = '0.1663' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 2 MEISTERWOOD R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '547' ,`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` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meisterwood' ,`TaxAmount` = '4099' ,`TaxRate` = '2.381' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834954' WHERE `Matrix_Unique_ID` = '214134639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:40:41.793' ,`MLSNumber` = '58530066' ,`ListAgentFullName` = 'Ellis Young' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671854' ,`Longitude` = '-95.117604' ,`PhotoCount` = '29' ,`PostalCode` = '77536' ,`RoomCount` = '6' ,`ListPrice` = '269999.00' ,`Status` = 'Active' ,`StreetName` = 'Lincoln' ,`StreetNumber` = '517' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ask about our buy down your rate option!! Ask about a great flooring credit !!!!A must see home on a beautiful corner lot! 3 bedroom 2 bath home with game room. Updated appliances, double-paned windows with transferable warranty, Pex plumping in 2011. You need a bonus?...There\'s a huge extra room that could be your home office, a game room or an extra bedroom. Over-sized garage and 12x10 Shed included. Fantastic commute to pretty much anywhere... Come take a look and be prepared to fall in love!' ,`Acres` = '0.1856' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 5 HERITAGE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '8085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'BONNETTE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Sec 01' ,`TaxAmount` = '5507' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834954' WHERE `Matrix_Unique_ID` = '214153213' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:35:43.733' ,`MLSNumber` = '34829488' ,`ListAgentFullName` = 'Sylvester Garcia' ,`ListOfficeName` = 'Houston Homes Plus' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658520' ,`Longitude` = '-95.648234' ,`PhotoCount` = '48' ,`PostalCode` = '77498' ,`RoomCount` = '11' ,`ListPrice` = '574900.00' ,`Status` = 'Active' ,`StreetName` = 'Beech Fork' ,`StreetNumber` = '15106' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4682' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large & Lovely Estate with 5 Bedrooms, 3 1/2 Bath With 3 car garage located In the gated and Quaint Community Of Woodbridge Estates In The Prestigious City Of Sugar Land. The Huge living room boasts towering ceilings adorned with a gem like crystal chandelier. The large kitchen features granite counter tops, tiled back splash, Island kitchen with full stainless steel appliance package. The huge primary bedroom downstairs has a huge sitting area. A large closet and separate sinks. The upstairs includes 4 large bedrooms with walking closets and 2 Jack And Jill bathrooms with separate sinks. Upstairs you will find and enjoy a large family room perfect for entertainment for watching movies and sports. The family room includes an office library adjacent to it. The exterior boasts a newer roof, a huge year prefect for a pool. The front yard has a beautiful lake view. Enjoy the huge walking trails around the beautiful lake with water fountains. Call today to set up your personal tour.' ,`Acres` = '0.3011' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODBRIDGE ESTATES SEC 2, BLOCK 3, LOT 28' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '13116' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DRABEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodbridge Estates Sec 2' ,`TaxAmount` = '9000' ,`TaxRate` = '2.2929' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834954' WHERE `Matrix_Unique_ID` = '214176157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:04:18.950' ,`MLSNumber` = '72989093' ,`ListAgentFullName` = 'Kevin Hansel' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Anh Phan' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.655457' ,`Longitude` = '-95.613179' ,`PhotoCount` = '23' ,`PostalCode` = '77478' ,`RoomCount` = '6' ,`ListPrice` = '279900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rosstown' ,`StreetNumber` = '13111' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2 bath 1 story home. In award winning Ft Bend ISD schools. Move in ready with new wood look vinyl flooring in all common areas and brand new carpet in bedrooms. Entire inside of house has been painted a soothing light gray. Large open living room with high ceiling and gas fireplace. New grage door opener, brand new dishwasher just installed, leaf guard on gutters. Storage galore throughout house, all three bedrooms have walk in closets. Large fenced in backyard with covered patio for outdoor entertaining. Fresh landscaping in front of house.' ,`Acres` = '0.2086' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BARRINGTON PLACE SEC 2, BLOCK 5, LOT 16, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BARRINGTON PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Barrington Place Sec 2' ,`TaxAmount` = '4214' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834954' WHERE `Matrix_Unique_ID` = '214185026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:12:17.060' ,`MLSNumber` = '17816271' ,`ListAgentFullName` = 'Brandy Mayr' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.197231' ,`Longitude` = '-96.022577' ,`PhotoCount` = '25' ,`PostalCode` = '77445' ,`RoomCount` = '3' ,`ListPrice` = '279680.00' ,`Status` = 'Active' ,`StreetName` = 'Quail' ,`StreetNumber` = '38154' ,`StreetSuffix` = 'Drive' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW, one story, 3 bedroom, 2 bath, 1,572 square foot home on A QUARTER ACRE LOT! This home features an open floor plan in the kitchen/living room/dining. High ceilings, granite countertops, stainless steel appliances, spacious primary bed/bath, garden tub, glass encased shower, his/her vanities. Large windows for abundant natural light throughout. Deerwood amenities include Lakes, HUGE Park, Pool & clubhouse. Hempstead has fine schools, parks, and a low cost of living/family friendly area with country style living.' ,`Acres` = '0.2755' ,`Area` = '26' ,`BuilderName` = 'Freedom Star' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S455200 DEERWOOD LAKES 2 LOT 246' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '12001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Deerwood Lakes 2' ,`TaxAmount` = '352' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834954' WHERE `Matrix_Unique_ID` = '214204042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:28:05.700' ,`MLSNumber` = '13414647' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701834' ,`Longitude` = '-95.706431' ,`PhotoCount` = '23' ,`PostalCode` = '77407' ,`RoomCount` = '11' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Halifax Harvest' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1771' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Under Construction! Ultra Modern & Chic Elevation! Gorgeous Upgraded Vinyl Wood Plank Floors throughout! Plush Carpeting in all Bedrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen W/Stunning Quartz Countertops, Tile Back-splash, Large Eat-in Island W/Deep Under-mount Sink, Tall Shaker Cabinets, Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining Area & Amazing Family Area With Wall of Windows! The Private Owner\'s Suite features a Luxurious Bathroom built for 2 with Cultural Marble Counters, His & Her Undermount Sinks, Deep Soaker Tub, Shower W/Seamless Glass Door & Walk-in Closet! More! Energy Efficient Home: HERS Energy Rated! Tankless/On-Demand H2O Heater! \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! Amenities include: Pool, Splash Pad & More! 20 minutes to The Galleria!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lakeview Retreat Lot: 27 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Lakeview Retreat' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834955' WHERE `Matrix_Unique_ID` = '214227218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:14:19.237' ,`MLSNumber` = '31953842' ,`ListAgentFullName` = 'Manuel Becerra' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = 'Julie Baker' ,`SellingOfficeName` = 'Styled Real Estate' ,`Latitude` = '29.925019' ,`Longitude` = '-95.439657' ,`PhotoCount` = '42' ,`PostalCode` = '77038' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shady Trail' ,`StreetNumber` = '1046' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated home that is move-in ready. Easy access to Beltway 8 & 249. Enjoy the covered patio great for entertaining & BBQing. Spacious living room with vaulted ceiling. Make your appointment today...' ,`Acres` = '0.1993' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1024 BLK 28 FALLBROOK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'STEHLIK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fallbrook Sec 03' ,`TaxAmount` = '3316' ,`TaxRate` = '2.4008' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834955' WHERE `Matrix_Unique_ID` = '214252605' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:25:32.700' ,`MLSNumber` = '44326221' ,`ListAgentFullName` = 'Daniela Sumbera' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.963746' ,`Longitude` = '-95.197107' ,`PhotoCount` = '38' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Arches' ,`StreetNumber` = '12234' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2925' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two-story brick Highland Home in the desirable Eagle Springs Community! This stunning beauty greets you with a charming foyer. 5 bedroom 4 full bath is very unique and fully upgraded home! Home boasts tiled floors throughout the main areas. Open kitchen concept with spacious mahogany cabinets and large island that is perfect for entertaining. The spacious primary bedroom features large windows that oversee the rear of the home offering serene views of the back yard. Large game room perfect for entertaining, 3 additional bedrooms & 2 full bathrooms, plus two readily accessible attic spaces perfect for extra storage, round out the upstairs. Enjoy your quiet evenings in the covered back patio area. Short distance to award winning schools, freeways, and shopping and dining.' ,`Acres` = '0.1435' ,`Area` = '1' ,`BuilderName` = 'Highland Homes LTD' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 EAGLE SPRINGS SEC 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Spgs Sec 30' ,`TaxAmount` = '8558' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834955' WHERE `Matrix_Unique_ID` = '214254043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:06:13.527' ,`MLSNumber` = '34133341' ,`ListAgentFullName` = 'Cynthia Hodges' ,`ListOfficeName` = 'Broussard\'s Real Estate Invest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767133' ,`Longitude` = '-95.268391' ,`PhotoCount` = '8' ,`PostalCode` = '77029' ,`RoomCount` = '7' ,`ListPrice` = '177500.00' ,`Status` = 'Active' ,`StreetName` = 'Fannette' ,`StreetNumber` = '8735' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1336' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well kept 3 bedroom 1 bath home inside loop 610. Original oak hardwood flooring. Nice sized formal living room and den...perfect for entertaining! Ceiling fans and window coverings throughout. Spacious indoor laundry and utility room. Ample closet space. Kitchen equipped with 5 burner gas cook top stove, wall oven, and plenty of cabinet space. Dining room has patio doors that lead to the patio and back yard enclosed with a privacy fence. Double drive-way and carport.' ,`Acres` = '0.1324' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 131 BLK 7 PLEASANTVILLE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pleasantville' ,`TaxAmount` = '1977' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834955' WHERE `Matrix_Unique_ID` = '214260623' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:47:51.483' ,`MLSNumber` = '98945816' ,`ListAgentFullName` = 'Ricardo Bayon Lira' ,`ListOfficeName` = 'Hofer Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850511' ,`Longitude` = '-95.316891' ,`PhotoCount` = '22' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '214500.00' ,`Status` = 'Active' ,`StreetName` = 'Rietta' ,`StreetNumber` = '5724' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION, WONT LAST LONG! \r\nLovely one story 3-bedroom 2 bath open concept home featuring high ceilings and recessed lighting. Gorgeous kitchen with breakfast bar, granite countertops, and stainless steel appliances. Vinyl wood flooring throughout common areas and carpet in all 3 bedrooms. Spacious walk in closet in each bedroom. Huge backyard conveniently shaded with mature trees; perfect for entertaining BBQ ing and more. Prime location within walking distance to Shady Dale Elementary School, close to shopping centers and freeways. AMAZING PRICE! don’t miss out this great opportunity\r\n\r\nCall and schedule your showing today.' ,`Acres` = '0.1589' ,`Area` = '2' ,`BuilderName` = 'Sierra Nevada Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 2 WARWICK PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6923' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Warwick Place' ,`TaxAmount` = '525' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834956' WHERE `Matrix_Unique_ID` = '214302249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:27:37.370' ,`MLSNumber` = '63409482' ,`ListAgentFullName` = 'Waldina Galeano' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052291' ,`Longitude` = '-94.913867' ,`PhotoCount` = '42' ,`PostalCode` = '77535' ,`RoomCount` = '4' ,`ListPrice` = '496000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 660' ,`StreetNumber` = '516' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely Stunning custom-built, 4 bedroom, 2.5 bathrooms, 2 car garage, extended driveway. The home features a traditional open concept, Accent Wallsm with lots of windows, formal dining, a living area with a fireplace and opens to the kitchen and breakfast area and tons of, cabinet space, a large walk-in closet, and spacious bedrooms.' ,`Acres` = '0.732' ,`Area` = '52' ,`BuilderName` = 'Sercome Enterprise L' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 1, BLOCK 2, LOT 31, ACRES 0.7320' ,`LotDesciption` = 'Cleared' ,`LotSize` = '31886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Encino Estates, Sec 1' ,`TaxAmount` = '959' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834956' WHERE `Matrix_Unique_ID` = '214314540' --> 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','214332226','1667834956','214332226','2022-11-06T12:48:05.353','69765292','Lisa Hudgens','RE/MAX Northwest, REALTORS','','','29.985282','-95.705782','37','77429','9','330000.00','Active','Bladenboro','14707','Drive','Cypress','2','0','4','2576','Single-Family','The home features a beautiful professionally landscaped front yard, two car attached garage & 4 zone sprinkler system. The front entry opens into the study with French doors, tile flooring & wood style shutters. On the other side of the entry is the living room with high ceilings & engineered wood floors. The dining room is just off the living room & has two tone paint, chair railing and large picture window. The kitchen has ample counterspace, gas range, under mount microwave & plenty of cabinets. The family room has built ins surround a brick gas log fireplace, high ceilings, and a wall of windows overlooking the backyard. Primary bedroom is off the family room with updated carpet, En suite bath with soaking tub, standing shower, separate vanities and walk-in closet. The secondary bedrooms & bathroom are across from the kitchen with engineered wood floors, ceiling fans & closets. The extended covered patio has plenty of room for outdoor entertaining and lovely landscaped beds.','0.1515','35','','','Washer Connections','','Exclusions,Mud,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas','1','LT 19 BLK 1 CYPRESS MILL SEC 2','Subdivision Lot','6600','Appraisal District','','640','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','A ROBISON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Cypress Mill','6610','2.761','Water District','1996','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:58:49.580' ,`MLSNumber` = '41850862' ,`ListAgentFullName` = 'Kim Tyler' ,`ListOfficeName` = 'Greystone Realty, LLC' ,`SellingAgentFullName` = 'Christina Lopez' ,`SellingOfficeName` = '1st Class RE Luxury Living,LLC' ,`Latitude` = '29.636034' ,`Longitude` = '-95.439396' ,`PhotoCount` = '32' ,`PostalCode` = '77045' ,`RoomCount` = '9' ,`ListPrice` = '200000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Woodmont' ,`StreetNumber` = '4106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a property with NO HOA, this is it!!! Property is the last home on a dead-end street. It has plenty of outdoor space in the back yard, as well as a large open space on the side! The home is close to shopping and schools! The kitchen overlooks the family room and dining room! The flex room can be used as an office or a formal living area! Needs some work, but the possibilities are great!' ,`Acres` = '0.1703' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 11 BRENTWOOD SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '7420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brentwood Sec 02' ,`TaxAmount` = '2353' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834956' WHERE `Matrix_Unique_ID` = '214337289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:56:11.573' ,`MLSNumber` = '30797786' ,`ListAgentFullName` = 'Gay Fundling' ,`ListOfficeName` = 'Galveston Island Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.448965' ,`Longitude` = '-95.061429' ,`PhotoCount` = '32' ,`PostalCode` = '77539' ,`RoomCount` = '9' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Cove' ,`StreetNumber` = '5515' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant entrance with custom iron double doors that open to three story foyer and a large living room with beautiful wood flooring, crown molding, and numerous designer accents. It also features gorgeous pool views, balcony, large rooms and backyard. The spiral staircase has a presence of its own. The well-appointed kitchen features granite with custom backsplash and stainless steel appliances such as a gas cooktop. It has a three car garage with rear garage door.\r\nRelax and unwind with views from the living room as well as the second floor terrace of your private pool.\r\nThis is a desirable custom subdivision. Stop to visit your future home today!' ,`Acres` = '0.3579' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'FOREST COVE SEC 2 (2005) ABST 11, BLOCK 2, LOT 9, ACRES 0.35' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15592' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Forest Cove Sec 2 2005' ,`TaxAmount` = '13078' ,`TaxRate` = '2.5984' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834956' WHERE `Matrix_Unique_ID` = '214373987' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:27:03.113' ,`MLSNumber` = '35328199' ,`ListAgentFullName` = 'Zunaira Zaki' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045919' ,`Longitude` = '-95.394303' ,`PhotoCount` = '34' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayleaf' ,`StreetNumber` = '23230' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this phenomenal one-story home located in the Spring subdivision of Timber Lane. This stunning home features three bedrooms, two full bathrooms, a living room, a formal dining room, a two-car detached garage with epoxy flooring, and so much more! The welcoming entry leads you to a spacious living room with high ceilings and plenty of natural light. The kitchen features ample cabinets, quartz countertops with a single basin sink, stainless steel appliances, a microwave nook, and a spacious pantry. The primary suite offers natural light and a custom primary bathroom that features dual vanity sinks, a large shower, and a walk-in closet. In the backyard, you will find patio decking and beautiful landscaping. This home is in a prime location with convenient access to major highways. Schedule a tour to visit your future home today!' ,`Acres` = '0.194' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 7 TIMBER LANE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8449' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane Sec 01' ,`TaxAmount` = '4045' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834956' WHERE `Matrix_Unique_ID` = '214402475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:37:01.530' ,`MLSNumber` = '53819513' ,`ListAgentFullName` = 'Alejandra Szabo' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218156' ,`Longitude` = '-95.521490' ,`PhotoCount` = '49' ,`PostalCode` = '77382' ,`RoomCount` = '8' ,`ListPrice` = '379999.00' ,`Status` = 'Active' ,`StreetName` = 'Gaslight' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous, OPEN CONCEPT home. This beautiful 3 bedroom 2.5 bath property is located in a quiet cul-de-sac in the desired section of Alden Bridge, The Woodlands. Walking distance from McCullough Junior High, Acacia Park, Alden Place Park and more. This home features a bright modern kitchen with granite countertops, marble backsplash, white cabinets, and SS appliances. High Ceilings, lots of Natural light throughout the home, fireplace, and plenty of space to entertain or enjoy with the family. Large master bedroom upstairs near 2 additional rooms and a game room. This home is move-in ready and can be sold completely furnished if desired. Everything has been thoughtfully placed by a professional designer. Perfect investment opportunity.' ,`Acres` = '0.1376' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S971926 - WDLNDS VIL ALDEN BR 26, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5995' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 26' ,`TaxAmount` = '7416' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834957' WHERE `Matrix_Unique_ID` = '214412606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:27:12.710' ,`MLSNumber` = '24007585' ,`ListAgentFullName` = 'Waldina Galeano' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142508' ,`Longitude` = '-94.901124' ,`PhotoCount` = '8' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 662' ,`StreetNumber` = '12' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.998' ,`Area` = '52' ,`BuilderName` = 'Envision Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ENCINO ESTATES, SEC 1, BLOCK 7, LOT 15, ACRES .998' ,`LotDesciption` = 'Corner' ,`LotSize` = '43473' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Encino Estates' ,`TaxAmount` = '1307' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834957' WHERE `Matrix_Unique_ID` = '214418686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:30:51.350' ,`MLSNumber` = '18478210' ,`ListAgentFullName` = 'Stephanie Saculla' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.217065' ,`Longitude` = '-95.523477' ,`PhotoCount` = '35' ,`PostalCode` = '77382' ,`RoomCount` = '4' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'New Avery' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Turnkey 1-story on quiet cul-de-sac ready to move in. Walk to the park, Mitchell Intermediate school, shops and restaurants! This beautiful home has multiple updates and upgrades! Granite counter tops in kitchen and second bathroom, all rooms have a fresh coat of paint. The primary bedroom includes a fireplace & primary bathroom has been updated with Cambria Quartz counter tops, added storage tower and air and water jetted tub. All cabinet doors throughout are custom built with solid wood and soft-close doors. Large pull outs in the kitchen, the stove is gas with cook/warming drawer, Bosch dishwasher, custom shades, the HVAC system was replaced a couple years ago. Easy to maintain Luxury Vinyl Flooring and tile throughout, french doors on the study, crown moldings, all windows tinted with Geoshield, covered front and back porch, beautiful fireplace between family room and master suite. Call today to take your tour and make this beautiful home your own!' ,`Acres` = '0.1598' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BRIDGE 26, BLOCK 1, LOT 71' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 26' ,`TaxAmount` = '5968' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834957' WHERE `Matrix_Unique_ID` = '214448498' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T12:07:05.227' ,`MLSNumber` = '89256625' ,`ListAgentFullName` = 'Kimberly Mascis' ,`ListOfficeName` = 'MIH REALTY, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746921' ,`Longitude` = '-95.320942' ,`PhotoCount` = '24' ,`PostalCode` = '77011' ,`RoomCount` = '8' ,`ListPrice` = '615000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '5228' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern & clean aesthetic with spacious 1st floor living. Ideal kitchen for entertaining w/ plenty of storage. Multiple pantry spaces; built-in & walk-in. Custom upgrades through out; 3/4\" plywood cabinets, white oak door and drawers with soft-closing hardware. Wide plank, glued down engineered white oak floors. Spacious covered patio w/ 33\' x 16\' backyard enclosed for pets and kids. 2nd floor offers the ideal live/work space. Primary bedroom has an en suite, custom built-in storage and large walk-in closet with multiple storage solutions. Large laundry room w/ sink, storage & quartz counters. Bedrooms have custom wardrobes built-in giving the room a luxury feel. Construction utilizes beyond-code building methods & materials to bring clients a high performance home. Mascis-Garvey Design/Build is a unique studio that cares about how a house is built; focusing on providing quality, aesthetically modern, and most importantly high-performance, healthy homes.' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Second to None Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3258' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Avenue Homes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667834957' WHERE `Matrix_Unique_ID` = '214454887' --> 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','214458975','1667834958','214458975','2022-11-06T12:57:25.330','73698483','Guadalupe Flores','eXp Realty, LLC','','','30.015774','-95.311210','19','77338','6','210000.00','Active','Morgan Ranch','7503','Trail','Humble','2','0','3','1470','Single-Family','Black appliances: Refrigerator, Stove, Oven (all stay in house). Washer & Dryer will also stay! Built-in Murphy Bed will stay as well. Projector in living room will stay as well.','0.1188','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Humble Area West','Central Electric','1','LT 22 BLK 2 SADDLE RIDGE SEC 4','Subdivision Lot','5175','Appraisal District','','345','0','','2','Freestanding Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Call Occupant,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Saddle Rdg Sec 04','4325','2.7734','Water District','2008','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T11:45:55.983' ,`MLSNumber` = '39123865' ,`ListAgentFullName` = 'Theresa Almogabar' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139367' ,`Longitude` = '-95.378517' ,`PhotoCount` = '28' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Timbers' ,`StreetNumber` = '3809' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2612' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 BEDROOMS+GAME ROOM+OFFICE+POOL+Falls at Imperial Oaks = PERFECT!This gem waits for you! At the entry you\'re greeted by wide walkways leading into the kitchen & living areas.Your home office is at the front of the home with two large windows facing the front yard & french doors for added privacy. The chef in your home will love cooking in this kitchen with TONS of counter space,cabinets for storage,and under-cabinet lighting. The living room is anchored by a gas fireplace and 3 large windows to see the POOL outside. The primary bedroom is spacious and features a bay window to let in tons of natural light. Primary bathroom features double sinks, a large soaking tub and separate shower. Upstairs your game room is large enough for a pool table! The secondary bedrooms are spacious and one is currently being used as a media room. Step outside into your own backyard oasis with a screened-in porch, pool and spa to play or relax, a fire pit for those cool nights, and plenty of seating areas.' ,`Acres` = '0.1443' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504217 - FALLS AT IMPERIAL OAKS 17, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6284' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks' ,`TaxAmount` = '9363' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667834958' WHERE `Matrix_Unique_ID` = '214459059' --> Updated record success