Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:20:16.963' ,`MLSNumber` = '6627072' ,`ListAgentFullName` = 'Richard Garcia' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769261' ,`Longitude` = '-96.154329' ,`PhotoCount` = '39' ,`PostalCode` = '77474' ,`RoomCount` = '5' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Meyer' ,`StreetNumber` = '1200' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 1200 N Meyer St located in the heart of Sealy TX! This immaculate 3 bedroom, 1 story open floor plan home with an additional den and on 15,000+ sq ft lot is conveniently located near the US-90 and I-10. Ready to move in & dressed to impress, this charming home features beautiful finishes, outdoor living, and architectural details throughout. Spacious living room offers large glass windows overlooking the front yard that allow in plenty of natural light. Gourmet kitchen features bright white wood cabinet and easy access to the dining/living room. Very spacious backyard with a gorgeous deck for entertaining. Located just across the street from the Sealy food truck court and just blocks from parks, historical downtown businesses and events. This home is just waiting for someone ready to embrace the ease and fun of small town life. This home can also be used for a commercial space! Best of all, home was HIGH & DRY from Harvey! Call today for a private showing!' ,`Acres` = '0.365' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A179 I GIFFORD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15899' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H & Tcrr Co Surv Abst' ,`TaxAmount` = '2690' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638684' WHERE `Matrix_Unique_ID` = '207400871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:37:01.200' ,`MLSNumber` = '49007932' ,`ListAgentFullName` = 'Walter Bering' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747018' ,`Longitude` = '-95.412758' ,`PhotoCount` = '26' ,`PostalCode` = '77019' ,`RoomCount` = '11' ,`ListPrice` = '1050000.00' ,`Status` = 'Active' ,`StreetName` = 'Persa' ,`StreetNumber` = '2030' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home in the River Oaks area is ideal as a starter home, home, or \"pied-a-terre\". Perfect for someone desiring a stylish home “on the ground” level. The floor plan centers around an interior atrium. Front room features a study or den area, which flows to a large living area. Nicely updated kitchen with stone countertops and stainless appliances. Primary bedroom offers a walk-in closet, en-suite bath, and access to an adjacent extra room that can serve as a home office; or convert to an additional bedroom. Floors are a mixture of parquet hardwoods and terra cotta tile. Generous backyard slate patio for outdoor entertaining. Situated on a 6,100 sq. ft. lot (per HCAD) on the corner of Persa and Avalon, this site would also be ideal for building one single family home. The home in its current state needs some love! Great opportunity to renovate; or build something new on this great lot in Melanie Court. It is also zoned to River Oaks Elementary School.' ,`Acres` = '0.14' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 & TR 8A BLK 5 MELANIE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Melanie Court' ,`TaxAmount` = '21186' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638685' WHERE `Matrix_Unique_ID` = '209062383' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:58:50.247' ,`MLSNumber` = '81710045' ,`ListAgentFullName` = 'Jose Oti' ,`ListOfficeName` = 'Beth Wolff, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739800' ,`Longitude` = '-95.439312' ,`PhotoCount` = '13' ,`PostalCode` = '77027' ,`RoomCount` = '13' ,`ListPrice` = '2695000.00' ,`Status` = 'Active' ,`StreetName` = 'Eastgrove Lane' ,`StreetNumber` = '2806' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5608' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TMB Development presents an exceptional residence in the River Oaks area. Designed by Todd Rice, this spacious custom home encompasses all of the desirable features for today\'s lifestyle. The spacious entry foyer gives direct access to the study and formal dining room and leads to the great room and island kitchen, a layout for entertaining. The first floor primary bedroom has views of the yard which can accommodate a swimming pool and the 400+ sq. ft. veranda with an outdoor kitchen and wood burning fireplace. The second floor is accessed by an open staircase or the elevator and includes four generous sized bedrooms, three baths, a large game room, and laundry room. In addition the 1/2 story accessed by both stairs and elevator includes a theater with a full bath making this a flexible space to meet your needs. The home is walking distance from Central Market and Highland Village.' ,`Acres` = '0.15' ,`Area` = '16' ,`BuilderName` = 'TMB Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Greenway Plaza' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 WESTGROVE COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2.5' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Westgrove Court' ,`TaxAmount` = '' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666638685' WHERE `Matrix_Unique_ID` = '209121329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:58:25.117' ,`MLSNumber` = '12326943' ,`ListAgentFullName` = 'Brian Spack' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762939' ,`Longitude` = '-95.476501' ,`PhotoCount` = '50' ,`PostalCode` = '77056' ,`RoomCount` = '19' ,`ListPrice` = '4500000.00' ,`Status` = 'Active' ,`StreetName` = 'Russett' ,`StreetNumber` = '5514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '9598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AUCTION: Bid November 9-15. Currently Offered for $4.5M. No Reserve. Daily showings from 1:00PM to 4:00PM\r\nMagnificent functionality, grand spaces for entertaining, and a private garden sanctuary are yours on an exclusive Tanglewood cul-de-sac. This stately brick facade is like a warm embrace, hinting at what’s to come. From the foyer’s groin vault ceiling to the 250-year-old oak floors, this estate offers a bounty of warm custom finishes: antique transoms, stone walls, + reclaimed beams. The thoughtful floor plan functions beautifully for a crowd. Pocket doors effortlessly carve out intimate spaces for small gatherings. Understated elegance flows throughout without ostentation, from the showpiece kitchen to the soaring great room to the versatile solarium. Open the accordion sliding glass doors, and the sunroom becomes part of the spectacular backyard. Lush landscaping winds around the gunite pool, putting green and stone-paved patio create the ultimate at-home escape.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Goodchild' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 15 TANGLEWOOD SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '30000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other,Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood' ,`TaxAmount` = '65259' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638685' WHERE `Matrix_Unique_ID` = '210946016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:16:36.087' ,`MLSNumber` = '18126283' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711917' ,`Longitude` = '-95.853727' ,`PhotoCount` = '22' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '584990.00' ,`Status` = 'Active' ,`StreetName` = 'Kenton Place' ,`StreetNumber` = '5222' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW... Stunning One Story home in the heart of Cross Creek Ranch Master Planned Community. Featuring 4 bedrooms, 3 bathrooms, Game Room, Private study, PLUS a 3 CAR GARAGE- this home will not disappoint. Formal entry with tall ceilings, tile flooring, and a home office with new double doors are just some of the details you will notice upon entering. This beautiful floorplan offers a spacious living area with tall ceilings and a gas fireplace. Well laid out open kitchen with butler pantry, stainless steel appliances, under cabinet lighting, and center island. Expansive primary retreat with en-suite bath featuring dual sinks, separate shower, and soaking tub. The home backs to green space and walking trails. Oversized back and side yard. ROOM FOR A POOL! Fresh paint throughout! Light and Bright! New flooring in all bedrooms. Cross Creek Ranch features miles of walking and biking trails, community pools, tennis courts, pickle ball courts and other amenities. Exemplary KISD!' ,`Acres` = '0.2502' ,`Area` = '36' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK BEND AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 13' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10897' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creek Bend At Cross Creek Ranch Sec 6' ,`TaxAmount` = '12411' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638685' WHERE `Matrix_Unique_ID` = '211194885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:00:35.307' ,`MLSNumber` = '39149972' ,`ListAgentFullName` = 'Andrea Keiller' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.166685' ,`Longitude` = '-95.628003' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '16' ,`ListPrice` = '1450000.00' ,`Status` = 'Active' ,`StreetName` = 'Riata' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '7706' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the desirable gated neighborhood of the Ranches of Pinehurst this outstanding home offers privacy, enormous entertaining space with convenient access to The Woodlands. Dramatic entry with sweeping iron staircase, wall of windows overlooking the fabulous backyard, both formals with wood flooring, huge master retreat with sitting room, exercise room & fireplace, powder with travertine sink, study with extensive built-ins and shelving, gourmet kitchen with butlers pantry, wine fridge, two warming drawers, double oven, vegetable sink, compactor, 6 ring gas range & large breakfast bar. Upstairs an incredible game room, outside patio with spiral iron staircase to below, extra room with full bar, fridge and media room with 110\" TV screen. 3 large secondary bedrooms with walk in closets. Tropical backyard with summer kitchen, fridge, 3 burners, griddle, grill & pool bath with shower. Sparkling pool with water features. 4 car garage with epoxy coating. The perfect entertaining home!' ,`Acres` = '5' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'A0205 FOSTER JOHN, TRACT 1E-3, ACRES 5.000' ,`LotDesciption` = 'Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '804' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ranches of Pinehurst' ,`TaxAmount` = '22324' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638685' WHERE `Matrix_Unique_ID` = '211601648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:40:02.753' ,`MLSNumber` = '43385195' ,`ListAgentFullName` = 'Brandi Paullo' ,`ListOfficeName` = 'The Taylor Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806079' ,`Longitude` = '-95.575163' ,`PhotoCount` = '33' ,`PostalCode` = '77043' ,`RoomCount` = '5' ,`ListPrice` = '387900.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood Forest' ,`StreetNumber` = '2067' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1876' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new! This fabulous 2019 built 3 bedroom 3.5 bath patio home with attached 2 car garage has it all! The lightly lived in fresh modern interior features high ceilings, engineered wood floors, private gated front yard, plantation shutters, open floor plan and more. Open island kitchen with white cabinetry, custom backsplash, apron sink, quartz counter tops, and stainless appliances. Large living room and open dining space, add to the appeal of the downstair with lots of natural light. Master boasts walk-in closet, double sinks, soaking tub, and oversized shower. Both secondary bedrooms with private bathrooms, generous closets and high ceilings. The open floorplan is perfect for entertaining and there is ample street parking. Easy access to BW8, I-10, City Centre, Energy Corridor, and Memorial City. Schedule your private showing today!' ,`Acres` = '0.0464' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BEYOND METRONOME' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beyond Metronome' ,`TaxAmount` = '8243' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638686' WHERE `Matrix_Unique_ID` = '211892088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:53:22.023' ,`MLSNumber` = '61030995' ,`ListAgentFullName` = 'Susan Heflin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665465' ,`Longitude` = '-95.017205' ,`PhotoCount` = '19' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'A' ,`StreetNumber` = '325' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location!! What an incredible find in the heart of LaPorte, 325 E A is sitting on a prime piece of real estate with an incredible updated barn style home with all the modern conveniences. Are you looking for a large double workshop/garage space to work on your classic cars or have the space for different hobbies? \r\nIf so, you have met your match.' ,`Acres` = '0.287' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 14 15 16 & 17 BLK 197 LA PORTE' ,`LotDesciption` = 'Corner' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'La Porte' ,`TaxAmount` = '2483' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638686' WHERE `Matrix_Unique_ID` = '212002792' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:22:37.093' ,`MLSNumber` = '53088966' ,`ListAgentFullName` = 'Scarlett Snell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128656' ,`Longitude` = '-95.743133' ,`PhotoCount` = '32' ,`PostalCode` = '77355' ,`RoomCount` = '4' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Mile' ,`StreetNumber` = '17520' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come live in the serenity of Magnolia Ranch Estates! This gorgeous home boasts a 1 acre lot and highly sought after 3 car garage. Nestled amongst the trees you\'ll enjoy the peace and quiet while being just minutes from shopping and dining. While this home is stunning, its the unique features that set this home apart from the others. On the inside you\'ll find special features like arched doorways, crown molding, and upgraded baseboards. The open floor plan makes it easy to entertain and the stunning finishes make it easy to show off. The On the exterior you\'ll find additional features like the large shed, huge deck, hot and cold water available outside, gutters with leaf guards, plugs all around the outside of the home for lighting, zoned sprinkler system, and even great wi-fi in the garage. Come see this home for yourself because it\'s too good to wait!' ,`Acres` = '1' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S710600 - MAGNOLIA RANCH ESTATES, BLOCK 1, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Ranch Estates' ,`TaxAmount` = '7109' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638686' WHERE `Matrix_Unique_ID` = '212074561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:52:21.590' ,`MLSNumber` = '67971709' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.075763' ,`Longitude` = '-95.131467' ,`PhotoCount` = '39' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '514900.00' ,`Status` = 'Active' ,`StreetName` = 'China Clipper' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TREASURE ISLAND Canal Home with Boat Lift is ready for its next owner. Grab the boat keys and head out to deep water fishing. Come home and make use of the docks water station to prepare your catch for dinner. Walk onto the spacious front deck to enter this 3bed, 2bath home, with open living floorplan, vaulted ceilings, updated flooring, tiled showers, quartz counters, and perfectly decorated furnishings (sold furnished). The back deck is the ideal location to enjoy the sunset after a fun day on the water. Treasure Island is a rare community with Galveston just across the bridge, Surfside Restaurants/Stores just down the road, and the beach is a short golf cart ride away. Schedule your tour of this signature property today!' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND NO 2 (A0029 S F AUSTIN) BLK 4 LOT 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '6270' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638686' WHERE `Matrix_Unique_ID` = '212162690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:44:19.823' ,`MLSNumber` = '32135797' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.329985' ,`Longitude` = '-94.946701' ,`PhotoCount` = '28' ,`PostalCode` = '77563' ,`RoomCount` = '8' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'La France' ,`StreetNumber` = '7308' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful canal front home with a rare unobstructed west view. Quick access to Hwy 6 and I-45. This home features 3 bedrooms and 2 full baths, walk-in master closet, laundry room upstairs, living and large open kitchen. Large outdoor area to grill and enjoy the views. Front and back porches where you can sit and take in the sunrise, sunset, and wetlands. Recent updates include interior and exterior paint, and front door. Updates within the last two years include new flooring, sliding patio doors, garage, elevated lot, sod, concrete driveway, and vinyl bulkhead. Birdwatchers paradise.' ,`Acres` = '0.1961' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Highland Bayou' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 175 J SPILLMAN SUR LOT 11 HIGHLAND BAYOU ESTATES SEC 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '8541' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Bayou Estates' ,`TaxAmount` = '2455' ,`TaxRate` = '1.7642' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666638686' WHERE `Matrix_Unique_ID` = '212236771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:57:51.290' ,`MLSNumber` = '76364221' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.946471' ,`Longitude` = '-95.295190' ,`PhotoCount` = '34' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Seabean' ,`StreetNumber` = '445' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This surfside home has open floorplan with upgraded flooring, and extended deck for entertaining friends and family. You will love the updated kitchen with quartz countertops, induction range with air fryer, undercabinet lighting, freshly installed cabinets, upgraded lighting fixtures, and home water filtration system. After a long day at the beach, relax and stay cool with recently installed AC, and shower in one of 2 baths with the tankless water-heater. Your furry family members will have room to play with access to multiple fenced areas and the concrete pad with asphalt drive is a great place to park your beach toys or hang a hammock for an afternoon nap in the shade. Looking to store your beach toys.... there are 2, the louvered storage on concrete pad and 2nd storage bldg in the backyard surrounded by chain-link fenced yard. Upgraded wiring on the ground floor. View the back deck sunsets and live your best beach life!!' ,`Acres` = '0.18' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GULF RIDGE (A0051 F J CALVIT TR G) BLK 1 LOT 10-10A SURFSIDE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Gulf Ridge' ,`TaxAmount` = '5667' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638687' WHERE `Matrix_Unique_ID` = '212351717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:13:36.873' ,`MLSNumber` = '56001944' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984105' ,`Longitude` = '-96.318009' ,`PhotoCount` = '38' ,`PostalCode` = '77418' ,`RoomCount` = '9' ,`ListPrice` = '829990.00' ,`Status` = 'Active' ,`StreetName` = 'Hillview' ,`StreetNumber` = '2260' ,`StreetSuffix` = 'Road' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing and rare opportunity in the highly sought-after Sycamore Hills community. This beautiful home is nestled on just over 3 acres of land. Stunning stone front elevation with large wrap-around covered porch. Welcoming entry, family room with spectacular floor-to-ceiling stone fireplace and a sunroom perfect for taking in the view. The kitchen features a custom tile backsplash, Italian marble farm sink facing an oversized picture window, stainless steel appliances, and a breakfast nook overlooking the sprawling backyard. Luxurious primary suite with, soaking tub, and large walk-in shower. 2 bedrooms and home office or den upstairs! Porcelain tile and engineered wood. Large Barn and workshop with wood interior and balcony. At the end of the street is the private 37.5 acre wildlife preserve & recreational park for Sycamore Hill property owners & guests with walking trails, 3.5 acre catch & release lake, pavilion, fireplace & restrooms. Low Tax Rate! 5 min to Bellville, 10 to Brenham.' ,`Acres` = '3.07' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SYCAMORE HILL LOT 18' ,`LotDesciption` = 'Subdivision Lot,Water View,Wooded' ,`LotSize` = '133729' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sycamore Hill' ,`TaxAmount` = '9655' ,`TaxRate` = '1.8096' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666638687' WHERE `Matrix_Unique_ID` = '212557832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:33:01.760' ,`MLSNumber` = '97212716' ,`ListAgentFullName` = 'Darla Doshier' ,`ListOfficeName` = 'Pearl Partner Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043315' ,`Longitude` = '-95.174767' ,`PhotoCount` = '33' ,`PostalCode` = '77345' ,`RoomCount` = '10' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Breezy Point' ,`StreetNumber` = '4707' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peaceful cul-de-sac street in Fosters Mill Estates and ON the golf course! This beautiful home has a contemporary flair in design, color and decor and has been renovated to the highest standards. New cabinetry, flooring, quartz counters, new appliances, lighting, fixtures and paint. This home is elegance personified! The backyard offers privacy and a new pergola to sip a beverage and watch the sun go down over the absolutely gorgeous view of the golf course. You can watch the deer graze in the fields behind the house. The in-ground pool has all new equipment. AC is new and the roof is four years old, according to the owner. Buyer will need a survey as the pergola is a new structure. Room measurements approximated; please measure if necessary.' ,`Acres` = '0.3524' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 17 FOSTERS MILL VILLAGE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course' ,`LotSize` = '15351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fosters Mill Village' ,`TaxAmount` = '13392' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638687' WHERE `Matrix_Unique_ID` = '212615142' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:17:58.547' ,`MLSNumber` = '27592340' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.640745' ,`Longitude` = '-95.790320' ,`PhotoCount` = '37' ,`PostalCode` = '77406' ,`RoomCount` = '14' ,`ListPrice` = '1400000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Valley' ,`StreetNumber` = '5410' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5645' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM BUILT 5 bed 4.5 bath home situated on 1.8 acres. A BEAUTIFUL all-stone exterior, loaded with upgrades. The front-covered farmhouse porch invites you into the breathtaking foyer. A spiral wooden staircase, recessed lighting, & tons of natural light adorn the downstairs living space. The gourmet kitchen is sure to bring out your inner Chef, boasting granite countertops, upgraded stainless steel appliances, under cabinet lighting, & a large granite island. The family room features wood flooring, a fireplace, built-in shelving, & a spectacular wall of windows spanning the length of the family room and breakfast area. The primary suite will not disappoint, featuring tall tray ceilings, large windows, dual vanities, & a soaking tub to provide a sanctuary like no other. Upstairs 3 bedrooms, 2 bathrooms, game room, and a fitness/flex room await. Step out onto another large covered patio and into your own private oasis, with a pool/spa, travertine, and luscious landscaping.' ,`Acres` = '1.82' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODS EDGE SEC 2, LOT 116, ACRES 1.820' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '79279' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '273' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woods Edge Sec 2' ,`TaxAmount` = '15120' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638687' WHERE `Matrix_Unique_ID` = '212696053' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:10:15.247' ,`MLSNumber` = '58656495' ,`ListAgentFullName` = 'Stephen Bomar' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214452' ,`Longitude` = '-95.450042' ,`PhotoCount` = '27' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '349500.00' ,`Status` = 'Active' ,`StreetName` = 'Thicket Grove' ,`StreetNumber` = '47' ,`StreetSuffix` = 'Place' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2211' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Lennar home in sought after Harpers Landing. Home features granite counter tops, water filtration system and water softener. The garage has been converted into a separate room and air conditioned. Primary bedroom is downstairs with beautiful garden tub in master bathroom and two walk-in closets. Secondary bedrooms are upstairs with full bath. The HVAC was replaced in 2018. Within walking distance of park, and close to The Woodlands Mall, restaurants, Cosco, medical facilities, and schools. Hurry to make this your home, this won\'t last long!' ,`Acres` = '0.1157' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S970116 - WDLNDS HARPER\'S LND COLLEGE PK 16, BLOCK 1, LOT 54' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Wdlnds Harpers Lnd College Park' ,`TaxAmount` = '5388' ,`TaxRate` = '2.2719' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638687' WHERE `Matrix_Unique_ID` = '212709305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:01:29.420' ,`MLSNumber` = '93589341' ,`ListAgentFullName` = 'Barett Engelhardt' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.078269' ,`Longitude` = '-95.396281' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '283900.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Hill' ,`StreetNumber` = '25510' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully-updated in Lexington Woods! This charming community welcomes you home; enjoy the mature trees, peaceful feel, and gated community pool. Your one-story 4/2 has lots of updates to enjoy. Great open floorplan connects the modernized kitchen with the family room. Large living room boasts soaring ceilings and lots of natural light. New paint inside and out, new lighting, new luxury vinyl plank and carpet, and NO HISTORY OF FLOODING! Superb access to I-45 N Corridor and Hardy Toll Road! Make an appointment today!\r\n\r\nSeller to include One year Home Warranty.' ,`Acres` = '0.1928' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 15 LEXINGTON WOODS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638688' WHERE `Matrix_Unique_ID` = '212814911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:30:13.407' ,`MLSNumber` = '79257695' ,`ListAgentFullName` = 'Stacy Newton' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118654' ,`Longitude` = '-95.502014' ,`PhotoCount` = '32' ,`PostalCode` = '77389' ,`RoomCount` = '7' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Glenfield Spring' ,`StreetNumber` = '5422' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home conveniently located. Upon walking up to this home you are welcomed to an inviting front porch. When entering the home you will have a private office/study off of the entry hall. The kitchen with a large walk in pantry and tons of cabinet space is open to the dining room and family room. The back yard backs up to a greenbelt space which offers added privacy so you can sit on the covered back patio and relax. The primary suite has a room connected to it with closet space and a window that could easily be used as a private office, nursery, workout space - the possibilities are endless. Both secondary rooms are down their own hallway for privacy. The home also offers a central vacuum system throughout. Call today to schedule a private showing.' ,`Acres` = '0.1544' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 HAMPTON CREEK SEC 2 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRENCH ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hampton Crk Sec 2' ,`TaxAmount` = '8939' ,`TaxRate` = '3.304' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638688' WHERE `Matrix_Unique_ID` = '212880832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:36:31.093' ,`MLSNumber` = '34743951' ,`ListAgentFullName` = 'Kimberly Englebert' ,`ListOfficeName` = 'Yokom Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034599' ,`Longitude` = '-95.645958' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '464999.00' ,`Status` = 'Active' ,`StreetName` = 'Quarry Vale' ,`StreetNumber` = '18147' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2717' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Like-new 4 bedroom, 2.5 bathroom, two-story home, zoned to the highly acclaimed Tomball Independent School District, and located within the prestigious Hayden Lakes Community! Walk into a grand entry with hardwood flooring leading to the living area, which is open to the kitchen. The kitchen features 42” white cabinets, subway tile backsplash, pendant lighting, stainless steel appliances and a gas stove. Entertain in the backyard underneath the extended covered back patio in a yard that has ample room for a pool. In additional to the 4 bedrooms, this home has a study downstairs and a large game room upstairs—either can be used as a flex space. Conveniently located to TX-249 and the Grand Parkway, this home is ideal for commuters. Community features and amenities include a sparkling pool, dog park and several water features and sidewalks throughout….AND don’t forget—LOW TAX RATE! Come check out this beautiful home today!' ,`Acres` = '0.168' ,`Area` = '35' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 HAYDEN LAKES SEC 9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7318' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hayden Lakes Sec 9' ,`TaxAmount` = '8931' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666638688' WHERE `Matrix_Unique_ID` = '212981700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:55:15.250' ,`MLSNumber` = '61518251' ,`ListAgentFullName` = 'Christopher Diaz' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762910' ,`Longitude` = '-95.235490' ,`PhotoCount` = '36' ,`PostalCode` = '77029' ,`RoomCount` = '4' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Munn' ,`StreetNumber` = '11006' ,`StreetSuffix` = 'Street' ,`City` = 'Jacinto City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 full bath with huge garage/workshop. Home on large 1/3 of acre lot. Attached workshop with tons of space with additional large storage shed behind home. Home has been renovated recently with fresh paint, new tile, carpet, updated kitchen and brand new restroom. Home is located in city of Jacinto city. Jacinto city provides its own service. Pd. Ems. Public works. Recreation center heritage hall for senior citizen activities Police department has a response time of less that 3 minutes. In addition very close to school system and stores restaurants and medical center. Metro transportation system is within proximity for commutes into Houston metro areas. The has public swimming pool. Little league fields. Holiday celebrations such as Christmas parades,Santa in the fire truck,annual Easter egg hunt,market days festival once a month. National night out festivities. 4 th of July firework show. A must see call and schedule your private showing today.' ,`Acres` = '0.3746' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 8 BLK 50 INDUSTRIAL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '16318' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'JACINTO CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Industrial' ,`TaxAmount` = '2898' ,`TaxRate` = '2.993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1926' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638688' WHERE `Matrix_Unique_ID` = '213064774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:22:43.837' ,`MLSNumber` = '47541782' ,`ListAgentFullName` = 'Cristina Riol' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Maria Acuna' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.574347' ,`Longitude` = '-95.362306' ,`PhotoCount` = '11' ,`PostalCode` = '77584' ,`RoomCount` = '10' ,`ListPrice` = '300000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wellsford' ,`StreetNumber` = '1027' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED! Situated in the middle of the highly desirable Southdown neighborhood in Pearland. This home is a single story, open concept 3/2/2. Fireplace centers the Family Room with a wall of windows overlooking the gorgeous pool in the backyard. The home features an extra large kitchen open to the breakfast area and the living room, separate shower and garden tub, pool, and not a single stair in sight. Needs flooring throughout - just an opportunity to put in your personal touch. Conveniently located near SH-288, Pearland Medical Center, and Town Center. Schedule your showing today!' ,`Acres` = '0.1446' ,`Area` = '5' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHDOWN S/D, BLOCK 5, LOT 14 SEC 5, A0310 H T & B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southdown' ,`TaxAmount` = '6567' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638688' WHERE `Matrix_Unique_ID` = '213204078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:50:15.843' ,`MLSNumber` = '38745440' ,`ListAgentFullName` = 'Stephanie Childress' ,`ListOfficeName` = 'Rockin 4C Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477510' ,`Longitude` = '-95.222039' ,`PhotoCount` = '39' ,`PostalCode` = '77546' ,`RoomCount` = '8' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Vine' ,`StreetNumber` = '1580' ,`StreetSuffix` = 'Court' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Gorgeous 4 bedroom, 3.5 bath home has it all! The open floor Plan is perfect for entertaining. The Kitchen has beautiful granite and a large area for prepping all your gourmet meals, plenty of storage and a walk in pantry. Warm up with the fireplace in the living area or just enjoy all the natural lighting that comes in. The primary bedroom is oversized and the primary ensuite bath gives you that spa feeling. Upstairs is a large game room with an extra area perfect for storage or a smaller play room and 3 more bedrooms one with an ensute bath. Outside is a cover patio to sit and enjoy the large backyard that would easily fit a pool. This home has so much to offer and many more upgrades, it\'s ready for its new owners.' ,`Acres` = '0.1578' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 29 BLK 6 FRIENDSWOOD TRAILS SEC 1, 2 & COMM (2020) ABST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Friendswood Trails' ,`TaxAmount` = '4131' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638689' WHERE `Matrix_Unique_ID` = '213209645' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:37:04.010' ,`MLSNumber` = '92708393' ,`ListAgentFullName` = 'Travis Wade' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026064' ,`Longitude` = '-95.415842' ,`PhotoCount` = '43' ,`PostalCode` = '77073' ,`RoomCount` = '11' ,`ListPrice` = '296500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodchurch' ,`StreetNumber` = '902' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2299' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is completely remodeled. Located in a Cul-da-sac, this beautiful home on a huge lot is sure to please. This neighborhood has a large neighborhood pool and clubhouse in walking distance. Did I mention the back yard is huge? It has new flooring, new appliances, new granite countertops throughout, new lighting fixtures inside and out, newly painted inside and out, new AC system, newer water heater, new landscaping, new plumbing fixtures and faucets, gorgeous Chimney in the Great Room, custom tile showers and new plugs and switches. There is a new updated electrical panel as well. What more can I say. Come see it for yourself, while you can.\nVideo tour: https://m.bixel1.net/3mncij' ,`Acres` = '0.287' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 INVERNESS FOREST SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Forest Sec 01' ,`TaxAmount` = '4694' ,`TaxRate` = '2.5234' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638689' WHERE `Matrix_Unique_ID` = '213268797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:13:59.430' ,`MLSNumber` = '40170626' ,`ListAgentFullName` = 'Ronald Graham' ,`ListOfficeName` = 'Sharpstown Realty' ,`SellingAgentFullName` = 'Moselle Chapman' ,`SellingOfficeName` = 'Greenwood King Properties' ,`Latitude` = '29.702728' ,`Longitude` = '-95.511589' ,`PhotoCount` = '10' ,`PostalCode` = '77074' ,`RoomCount` = '5' ,`ListPrice` = '228999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Leader' ,`StreetNumber` = '7203' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1087' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home on corner lot with many NEW upgrades:\r\nnew Hvac 16 seer r-8 all new down to the copper lines,\r\nBeautiful new quartz countertops in the kitchen, new stainless steel sink w/ gourmet faucet, new garbage disposal,\r\nnew dishwasher, new stove and vent hood . New sliding glass door two new exterior six panel doors, beautiful fresh paint on the outside of the house, new texture and paint for the interior and much more..\r\nYou may be able to pick the new color of the front door. Submit your contract today! \r\nThis home has never flooded. Not in a 100 year flood zone. \r\nCorner lot one block off Bellaire Blvd. Eight minutes to the Galleria, Fifteen minutes to Downtown Houston\r\nSharptstown is a wonderful area to buy or invest in, the numbers speak for them self.\r\nSharpstown is the largest subdivision in the United States over 8000 Homes appx.' ,`Acres` = '0.2131' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 4 SHARPSTOWN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9282' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown 2' ,`TaxAmount` = '3496' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638689' WHERE `Matrix_Unique_ID` = '213454138' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:21:54.940' ,`MLSNumber` = '86495883' ,`ListAgentFullName` = 'Scarlett Snell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225743' ,`Longitude` = '-95.667065' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Winchester' ,`StreetNumber` = '12806' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This STUNNING home on Winchester Ct. is a must see with amazing curb appeal! The brick and stone exterior sets the tone for the wonderful interior. From the 2 story formal entry you immediately enjoy the open bright and light floor plan. This unique floor plan is everything you need to entertain like a pro. The living room boasts a cozy stone fireplace and vaulted ceilings. The chef of the family will enjoy the large kitchen equipped with island, plenty of counter space, and stainless appliances. As you head upstairs you\'ll notice the nice sized bedrooms and the flex room which can be used to meet many of your needs. Outside is the gem of the home, your own private oasis. From the huge covered patio to the sparkling swimming pool all surrounded by mature trees for privacy and tranquility. For those car lovers out there don\'t forget the 3 car garage! This home has it all, come see it before its gone!' ,`Acres` = '0.6574' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MOSTYN MANOR 01, BLOCK 1, LOT 12, ACRES 0.610' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '28637' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor 01' ,`TaxAmount` = '6728' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638689' WHERE `Matrix_Unique_ID` = '213521433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:28:28.403' ,`MLSNumber` = '81321287' ,`ListAgentFullName` = 'Shelli Underwood' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054514' ,`Longitude` = '-95.166116' ,`PhotoCount` = '34' ,`PostalCode` = '77345' ,`RoomCount` = '11' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Villas' ,`StreetNumber` = '5307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3069' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller!! Welcome to this magnificent home located in the highly sought after Sand Creek Village in Kingwood. This fabulous custom (Marilyn O’Conner) home has been meticulously maintained and it shows from the moment you arrive. Featuring a wonderful layout with a tiled family room opening to the dining room with wood floors and tiled kitchen and breakfast area with large upgraded windows. The kitchen has huge island and granite counters with under counter lighting The primary bedroom is located on the first floor with large en-suite with double sinks, whirlpool tub and separate shower with two vanity areas and two walk in closets. You will love working from home in the attached office with French doors and vaulted ceilings with great views of the back yard and access to the covered patio. Gameroom upstairs and three bedoroms with walk in closets with one full bath and one Hollywood bath. Plantation shutters in den and dining room. Plenty of room for a pool!!!' ,`Acres` = '0.24' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 3 SAND CREEK VILLAGE SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10455' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sand Creek Village Sec 02 R/P' ,`TaxAmount` = '8223' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638689' WHERE `Matrix_Unique_ID` = '213562577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:38:20.637' ,`MLSNumber` = '16801391' ,`ListAgentFullName` = 'Ashley Davis' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.046655' ,`Longitude` = '-95.000309' ,`PhotoCount` = '36' ,`PostalCode` = '77535' ,`RoomCount` = '10' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1960' ,`StreetNumber` = '7906' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for the country life with fast access to the city, then this is the perfect place for you!! This home offers a fully fenced in yard with a lemon tree, kumquat tree, banana trees, pear trees and crepe myrtles! At the back of the property, it is crossed fenced for livestock, where a large chicken pen is tucked away in the back. Come make this beautiful 4-bedroom 2-bath with a large upstairs game room your own country oasis!!' ,`Acres` = '2.292' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000493 R PRUITT-116, TRACT 82, ACRES 2.292' ,`LotDesciption` = 'Cleared' ,`LotSize` = '99840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'R Pruitt-116' ,`TaxAmount` = '7443' ,`TaxRate` = '2.6631' ,`WaterSewer` = 'Septic Tank,Water District,Well' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638690' WHERE `Matrix_Unique_ID` = '213564137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:12:34.210' ,`MLSNumber` = '11783409' ,`ListAgentFullName` = 'Keila Leal' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984897' ,`Longitude` = '-95.520389' ,`PhotoCount` = '34' ,`PostalCode` = '77069' ,`RoomCount` = '6' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Vestavia' ,`StreetNumber` = '13410' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful well-maintained 4 bedroom home with a pool and spa in the desirable Champions area. The home sits on a large, landscaped cul-de-sac lot with lots of mature trees, a long driveway to fit all your cars & great outdoor living space. The first floor is the heart of the home, with an open main living area that opens up to the kitchen and breakfast area. The spacious primary bath has a large vanity area, with lots of cabinet space. This home definitely gives a warm cozy feeling all throughout the home & offers lots of natural light. Don\'t miss out! Open House this Saturday from 1-4pm' ,`Acres` = '0.2771' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 113 BLK 7 CHAMPIONS EAST U/R & PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions East U/R & Prcl R/P' ,`TaxAmount` = '6599' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638690' WHERE `Matrix_Unique_ID` = '213585388' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:34:34.860' ,`MLSNumber` = '33811486' ,`ListAgentFullName` = 'Anthony Meza' ,`ListOfficeName` = 'Cy-Fair Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984016' ,`Longitude` = '-95.697513' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '318000.00' ,`Status` = 'Active' ,`StreetName` = 'Windwood Park' ,`StreetNumber` = '14646' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1916' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this immaculately kept home in a corner lot of Cypress Mill Park. The home features a front covered porch with a new side fence recently installed. As you walk into the home, you will be greeted with new flooring throughout the home as well as paint. The home follows a split floorplan from the owner\'s bedroom to the secondary rooms and office space. Spacious open-concept kitchen and dining room combo with cabinets reaching the ceiling open to the large vaulted ceiling living room. The home has double-paned windows for efficiency, Pex piping, A/C coils replaced 3 years ago, a replaced roof 5 years ago, and you can feel the pride in homeownership as you walk through this very well-kept home. The community itself includes access to two pools, parks, walking trails, tennis courts, and a clubhouse exclusively for residents of the community. This home is zoned out to some of the best schools in the very recognized Cy-Fair ISD. With so many great features it is a must-see!' ,`Acres` = '0.1308' ,`Area` = '35' ,`BuilderName` = 'Ryland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 8 CYPRESS MILL PARK SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '5697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Mill Park Sec 02' ,`TaxAmount` = '6111' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638690' WHERE `Matrix_Unique_ID` = '213603593' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:16:32.227' ,`MLSNumber` = '75344842' ,`ListAgentFullName` = 'Jay Richardson' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968195' ,`Longitude` = '-95.435205' ,`PhotoCount` = '38' ,`PostalCode` = '77014' ,`RoomCount` = '10' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Clear Valley' ,`StreetNumber` = '1231' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Such a Beautiful Home! Conveniently located near I-45 and Beltway 8 and just minutes away from Bush airport, Downtown, and The Woodlands. Great property for a family. Great for entertaining. Recently updated! Be sure to check out the huge family room. Its spacious island kitchen includes granite and stainless steel countertops, a gas range, a microwave, a dishwasher, garbage disposal with lots of cabinets, and counter space. Primary bath with Whirlpool bathtub and separate shower. Outdoors features a very large backyard with an oversized covered patio which is perfect for children and our furry family members. No carpet here. Only Luxury Vinyl Plank and Ceramic Tile. Ceiling fans are located in each room. Schools and parks are all nearby! Ready for a fast move-in, it\'s time for you to make this house your Home! Request an appointment to view this beauty today!!' ,`Acres` = '0.1832' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 2 & 3A BLK 4 CRANBROOK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7980' ,`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` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cranbrook' ,`TaxAmount` = '4230' ,`TaxRate` = '2.7192' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638690' WHERE `Matrix_Unique_ID` = '213637343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:05:20.113' ,`MLSNumber` = '83873037' ,`ListAgentFullName` = 'Cole Watkins' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762974' ,`Longitude` = '-95.882772' ,`PhotoCount` = '38' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Village Orchard' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2082' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*** Welcome home to 1910 Village Orchard Ln! This stunning LIKE NEW one-story M/I Home sits at 2,082 sqft and boasts 3 Bedrooms, 2 Bathrooms, and a spacious GAME ROOM/FLEX SPACE! This home has an amazing location on a 8,867 sqft LOT in the community of Young Ranch featuring a state-of-the-art recreation center, a multi-function swimming pool, playground, and is zoned to the highly sought after FULSHEAR HS! You\'ll love all the incredible features this home has to offer, including an open floor plan, beautiful quartz countertops, a luxurious master suite, an elegant dining space, durable wood look vinyl floors, COVERED PATIO, impeccable landscaping (including added trees, bushes, and edging), and so much more! Schedule your private showing to see more of this gorgeous home!' ,`Acres` = '0.2036' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'YOUNG RANCH SEC 12, BLOCK 1, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8867' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Young Ranch' ,`TaxAmount` = '8144' ,`TaxRate` = '3.072' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638690' WHERE `Matrix_Unique_ID` = '213748468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:09:20.490' ,`MLSNumber` = '62581056' ,`ListAgentFullName` = 'Linse Meadows' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710341' ,`Longitude` = '-95.740741' ,`PhotoCount` = '44' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '424000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut Canyon' ,`StreetNumber` = '20506' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2061' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 20506 Walnut Canyon! This stunning home sits on a 8,320 sq/ft lot and offers a spacious 2,061 sq/ft of living space with 3 bedrooms, and 2 full bathrooms, sitting on a quiet cul-de-sac street with beautiful landscaping, brick exterior, and all zoned to Katy ISD! You\'ll love all the incredible features this home has to offer, including a gorgeous primary suite, spacious living room, extra wide driveway, recently resurfaced swimming pool with gas heater and waterfalls, gas firepit, solar screens, custom wood cabinets, Italian tile throughout the house, fully fenced backyard, covered back patio, and so much more! Canyon Gate at Cinco Ranch is minutes from 99 and Westpark Tollway - in an excellent location! Schedule your private showing today!' ,`Acres` = '0.191' ,`Area` = '36' ,`BuilderName` = 'Deerwood' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON GATE CINCO RANCH SEC 7, BLOCK 3, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate at Cinco Ranch' ,`TaxAmount` = '7076' ,`TaxRate` = '2.6862' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638691' WHERE `Matrix_Unique_ID` = '213754184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:14:16.260' ,`MLSNumber` = '87055807' ,`ListAgentFullName` = 'Sarah Steinkopf' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.871687' ,`Longitude` = '-94.852306' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '549999.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Ridge' ,`StreetNumber` = '3808' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love this custom home in Fishers Landing! Located on the North side of i-10, near 99 and 146, in highly acclaimed BHISD! Inside features an open floor plan with 5 bedrooms, 4.5 baths, formal dining, office/flex room, includes a mother in-laws suite. The owners retreat includes a cozy fireplace, separate tub, shower, and a HUGE closet with built-ins. Outside you\'ll find a pool and spacious additional apartment/pool house, complete with kitchen and full bath. Recent updates include 2 AC units, 2 tank-less hot water heaters and a whole home generator, all new windows, gutters, most light fixtures, dishwasher, new deck, two sheds, smart thermostats, in ceiling speakers in garage and patio. 854 sq ft in pool house per appraisal district.' ,`Acres` = '0.3175' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E/2 LT 121 & FISHERS LANDING W/2 LT 122' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fishers Landing Sec 01' ,`TaxAmount` = '8254' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638691' WHERE `Matrix_Unique_ID` = '213788654' --> 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','213818820','1666638691','213818820','2022-10-24T07:22:29.530','80067142','Nelly Montoya','Realty World Metropolitan','','','29.818321','-94.826851','20','77523','4','370000.00','Active','Rain Tree','14506','Drive','Baytown','3','0','4','2251','Single-Family','The Mitchell plan is a Beautiful two-story home featuring 4 bedrooms, 3 baths, and a 2 car garage. The home opens to a downstairs guest bedroom and full bath with linen shelves. Very Open concept the kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry which connects to the split dining area and family room. The private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. A versatile game room greets you at the top of the stairs and opens to two additional bedrooms and bath. The standard rear covered patio is located off the family room','','53','DR Horton','','Electric Dryer Connections,Washer Connections','','HOA First Right of Refusal','1','','0','Chambers County West','Central Gas','1','LT 13 BLK 4 SEC 1','Cul-De-Sac,Subdivision Lot','11800','Appraisal District','','700','0','','2','Electric Oven,Freestanding Oven','0','','','Gas Range','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Raintree','','','Water District','2021','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:57:06.757' ,`MLSNumber` = '16417408' ,`ListAgentFullName` = 'Brian Spack' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747545' ,`Longitude` = '-95.526356' ,`PhotoCount` = '47' ,`PostalCode` = '77024' ,`RoomCount` = '15' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Forest' ,`StreetNumber` = '9139' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is a once in a lifetime chance to own a once in a lifetime home! In a pastoral setting—aside the lazy Bayou, hilly + green—sits a regal, comfortably elegant residence with an old, Southern lake home vibe. Winding through the private, verdant streets of Hudson, one is transported deep into nature. The home rises high amongst the thicket—you have found your paradise! Inside, floor to ceiling windows give treetop views. Ceilings are high, rooms are spacious, floors are hardwood. The wide Entry overlooks the expansive Great Room with wood burning, gas log fireplace + is open to the Dining Room. Through the Butler’s Pantry is an updated Kitchen with beautiful finishes, dual dishwashers + tons of cabinets and built-ins. En-Suite secondary Bedrooms dot the hallway that leads to a private, sweeping Master Suite with updated Bath, dual closets + a billion dollar view. Additional luxuries include 3 screened porches, giant Game Room with wet bar plus the comfort of guard gated Hudson Bayou.' ,`Acres` = '0.167' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'TH 49 BLDG B HUDSON ON BAYOU T/H SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7276' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Hudson on the Bayou' ,`TaxAmount` = '16391' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638691' WHERE `Matrix_Unique_ID` = '213822351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T07:03:08.373' ,`MLSNumber` = '34718251' ,`ListAgentFullName` = 'Darlyn Gomez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120761' ,`Longitude` = '-95.568476' ,`PhotoCount` = '32' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Songlark Bend' ,`StreetNumber` = '24638' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Welcome home to 24638 Songlark Bend Dr! This stunning 2,080 sqft one-story home boasts 3 bedrooms, 2 bathrooms, with many wonderful upgrades, a Formal Dining Room, a large covered patio, is zoned to Klein ISD! You will love the spacious open layout between the kitchen, living room, and dining spaces. There are an abundance of features including beautiful tile floors, granite countertops, modern finishes, stunning master suite, spacious kitchen, high ceilings, NO BACK NEIGHBORS and a beautiful view of the LAKE! The community of Lakes at Creekside is conveniently located near I-45 and 99 for an easy commute with lots of amenities including lakes, pool, and playground. Schedule your private showing today!' ,`Acres` = '0.1896' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 LAKES AT CREEKSIDE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '865' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Creekside' ,`TaxAmount` = '8944' ,`TaxRate` = '2.834' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638691' WHERE `Matrix_Unique_ID` = '213899628' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:54:42.487' ,`MLSNumber` = '46059437' ,`ListAgentFullName` = 'Jared English' ,`ListOfficeName` = 'Congress Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.474921' ,`Longitude` = '-95.025047' ,`PhotoCount` = '25' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Red River' ,`StreetNumber` = '5806' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This delightful, well-maintained home beckons you to enter and find a tranquil haven. DID NOT FLOOD IN HARVEY. 3 BR/ 2BA split floor plan home in Cheyenne subdivision. Great location close to shopping and schools. Open concept living area with a high tray ceiling. Updated kitchen with quartz counter tops, deep double under-mount sink, and stainless steel appliances. Updated bathrooms with stylish light fixtures/chandelier. Vinyl plank flooring in living area, porcelain floor tile in bathrooms/laundry, and carpet in bedrooms. Spacious walk in closets in all bedrooms. Interior laundry room with ample shelving. 2 car garage with plenty of built in storage. Inviting backyard with crushed granite patio area, mature trees, and built in natural gas grill. 8x8 shed for all of your tools and gadgets. Fresh landscaping and so much more!' ,`Acres` = '0.152' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 155 P G MERRITT SUR LOTS 17 & 18 BLK 7 CHEYENNE SUB REP' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6622' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '188' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cheyenne' ,`TaxAmount` = '3852' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638692' WHERE `Matrix_Unique_ID` = '213906810' --> 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','213938007','1666638692','213938007','2022-10-24T07:15:47.790','33783882','Jeffrey Lutz','RE/MAX Fine Properties','','','29.033461','-95.873950','48','77482','12','239900.00','Active','Oak Creek','43','Drive','Van Vleck','2','0','4','1469','Single-Family','Unique opportunity to own a nice country style home on +/- 1.55 acres of land with +/- 1456 Sgft. This beautiful setting is sure to please all your country desires. Draping big trees, lots of nice shade, treed lot lines for privacy and plenty of room for all your toys and vehicles. The home features a nice size family room, modern kitchen with granite tops and stainless appliances. There is a cute breakfast breakfast room off the kitchen. There is a nice size room with adjoining bath off the kitchen that could be used as a primary bedroom with an en-suite bath, and clothing racks within the bath. There is another bedroom with main bath access from the bedroom, but this is the main house bath. There are two more bedrooms and indoor utility room. Come on out front to the super long covered porch,or retire to the back yard with a stone patio that is also covered as well. There is a spacious two car carport with an attached one car garage/workshop/man cave. Fenced back yard for your pets.','1.556','54','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','0','','Central Electric','0','OAK CREEK SEC 1, BLOCK 2, LOT 6, ACRES 1.556','Subdivision Lot','67779','Appraisal District','','','0','','1','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Aluminum,Other','134 - Van Vleck','VAN VLECK ELEMENTARY SCHOOL','VAN VLECK HIGH SCHOOL','O H HERMAN MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Oak Creek Sec 1','2407','1.9671','Septic Tank','1996','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T06:35:12.670' ,`MLSNumber` = '10326923' ,`ListAgentFullName` = 'Alma Howard' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654441' ,`Longitude` = '-95.537717' ,`PhotoCount` = '18' ,`PostalCode` = '77031' ,`RoomCount` = '6' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Haverstock' ,`StreetNumber` = '8714' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely, well maintained patio home is move in ready. This home features an open floor plan, 3 bedrooms, 2 full baths, and a private entry from the 2 car garage directly into the house. This gorgeous property includes a fully renovated interior, kitchen renovated in 2018 with beautiful quartz counter tops, stainless steel appliances and custom made maple wood cabinets, master bathroom renovated in 2018 with added double sinks and stand-up shower with glass doors, wood grain and ceramic tile flooring throughout the home, new fans and light fixtures, additional outdoor outlets installed with protection covers and so much more! Located just minutes away from 59 and Beltway 8 for easy commute to the city work centers and major retail shopping. Schedule your showing today!' ,`Acres` = '0.0748' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 57 1/94 INT COMMON LAND & ELE RES A BLK 9 GLENSHIRE PATIO' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glenshire Patio Homes' ,`TaxAmount` = '3333' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638692' WHERE `Matrix_Unique_ID` = '213993771' --> 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','213997074','1666638692','213997074','2022-10-24T07:16:43.153','41262719','Demoine Oneal','The Real Estate Firm','','','29.640768','-95.349596','1','77048','3','141667.00','Active','Jutland','10902','Road','Houston','2','0','3','1254','Single-Family','***INVESTOR SPECIAL*** This property is currently being sold as part of a portfolio sale. The portfolio consists of 4 cash flowing properties within 5 minutes of each other. Please contact the listing agent for details. *** Please do not disturb tenants***','0.1331','3','','','Gas Dryer Connections,Washer Connections','','No Disclosures,Owner/Agent','1','','','Medical Center South','Central Gas','0','LT 1 BLK 25 CRESTMONT PARK SEC 2','Cul-De-Sac','5800','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','WOODSON ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Crestmont Park Sec 02','2466','2.3307','Public Sewer','1970','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213997115','1666638692','213997115','2022-10-24T06:15:39.907','63182804','Emilio Zaporteza','Vez Realty, LLC','','','29.928608','-95.256870','45','77396','13','589900.00','Active','Birch Arbor','14702','Court','Humble','3','2','5','4410','Single-Family','This house is located on a corner cul de sac street. Very spacious floor plan. It features, Home office, island kitchen with Granite counter top, 5 bedrooms, 3 full bath and 2 half bath, large gameroom and extra room that can be another game room or media room, swimming pool, outdoor kitchen, Water softener and Home generator, New roof was install 10/22/22','0.2344','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','2','Fall Creek Area','Central Gas','1','LT 38 BLK 2 FALL CREEK SEC 10','Corner,Cul-De-Sac','10212','Appraisal District','','1090','0','','3','Electric Oven','1','In Ground','','Gas Cooktop','','Composition','29 - Humble','AUTUMN CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','WOODCREEK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Seller','2','Traditional','Fall Creek Sec 10','13617','2.9973','Public Sewer,Public Water,Water District','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213997277','1666638692','213997277','2022-10-24T07:16:09.940','24005189','Demoine Oneal','The Real Estate Firm','','','29.640438','-95.347592','1','77048','4','155000.00','Active','Panay','10906','Drive','Houston','3','0','4','1927','Single-Family','***INVESTOR SPECIAL*** This property is currently being sold as part of a portfolio sale. The portfolio consists of 4 cash flowing properties within 5 minutes of each other. Please contact the listing agent for details. *** Please do not disturb tenants***','0.2524','3','','','','','No Disclosures,Owner/Agent,Tenant Occupied','1','','','Medical Center South','Central Electric','0','LT 11 BLK 24 CRESTMONT PARK SEC 2','Cul-De-Sac','10996','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','CODWELL ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Crestmont Park Sec 02','2775','2.3307','Public Sewer','1960','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213997357','1666638692','213997357','2022-10-24T07:17:14.290','48865194','Demoine Oneal','The Real Estate Firm','','','29.627072','-95.343937','1','77048','3','168300.00','Active','Sandrock','12107','Drive','Houston','2','0','3','1405','Single-Family','***INVESTOR SPECIAL*** This property is currently being sold as part of a portfolio sale. The portfolio consists of 4 cash flowing properties within 5 minutes of each other. Please contact the listing agent for details. *** Please do not disturb tenants***','0.1326','3','','','Gas Dryer Connections,Washer Connections','','No Disclosures,Owner/Agent,Tenant Occupied','1','','','Medical Center South','Central Gas','0','LT 2 BLK 9 KING ESTATES SEC 1','Subdivision Lot','5775','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','CODWELL ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','King Estates Sec 1','2894','2.3307','Public Sewer','1975','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213997416','1666638692','213997416','2022-10-24T07:17:56.643','79621988','Demoine Oneal','The Real Estate Firm','','','29.633959','-95.350814','1','77048','4','199817.00','Active','Bay Cedar','11710','Drive','Houston','1','1','4','1793','Single-Family','***INVESTOR SPECIAL*** This property is currently being sold as part of a portfolio sale. The portfolio consists of 4 cash flowing properties within 5 minutes of each other. Please contact the listing agent for details. *** Please do not disturb tenants***','0.1376','3','','','','','No Disclosures,Owner/Agent,Tenant Occupied','','','','Medical Center South','Central Gas','0','LT 3 BLK 8 KENNEDY HEIGHTS SEC 2','Subdivision Lot','5992','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','WOODSON ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Kennedy Heights Sec 02','2883','2.3307','Public Sewer','1975','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213997518','1666638692','213997518','2022-10-24T07:28:02.853','84325969','Feras Rachid','Opendoor Brokerage, LLC','','','29.781176','-95.768755','26','77450','5','396000.00','Active','Cheddington','227','Drive','Katy','3','1','5','3198','Single-Family','This Katy two-story home offers a patio, and a three-car garage.','0.1994','36','','','','','Sellers Disclosure','1','','1','Katy - Southeast','Central Gas','1','LT 9 BLK 4 GOVERNORS PLACE SEC 4','Subdivision Lot','8686','Appraisal District','','620','0','','3','','0','','','','','Other','30 - Katy','WEST MEMORIAL ELEMENTARY SCHOOL','TAYLOR HIGH SCHOOL (KATY)','WEST MEMORIAL JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Vacant/Unoccupied','Seller','2','Traditional','Governors Place Sec 04','7440','2.3833','Water District','1997','Seller'); --> New record created successfully