SELECT Acres,BathsFull,BathsHalf,BathsTotal,BedsTotal,City,DOM,GarageDesc,GeoMarketArea,Latitude,ListAgentFullName,ListOfficeName,ListPrice,Longitude,Matrix_Unique_ID,MLSNumber,NoOfGarageCap,PoolPrivate,PostalCode,PropertyType,SqFtTotal,StateOrProvince,Status,Stories,StreetName,StreetNumber,Style,Subdivision,YearBuilt,url FROM wp99_rets_property_listing LEFT JOIN wp99_rets_property_images ON wp99_rets_property_listing.Matrix_Unique_ID = wp99_rets_property_images.matrixID WHERE (main=1) AND Subdivision LIKE '%claytons park%' AND PropertyType = 'Single-Family' ORDER BY ListPrice DESC

×

Your Favorites

Remove All

12215 Urban Trees, Humble, Texas 77346

 7 - days on HAR
MLS# 71061180

Single-Family, Traditional in Claytons Park Sec 6 of Atascocita South(Market Area)

5 Bed(s)
2 Stories
3.10 Bath(s)
3,226 Building Sq. Ft.
Option Pending

$284,900


4843 Dappled Grove, Humble, Texas 77346

 1 - days on HAR
MLS# 12517597

Single-Family, Traditional in Claytons Park of Atascocita South(Market Area)

4 Bed(s)
2 Stories
2 Garages/Attached Garage
2.10 Bath(s)
3,220 Building Sq. Ft.
Active

$235,000


12210 Zenith Ridge, Humble, Texas 77346

 5 - days on HAR
MLS# 72513595

Single-Family, Traditional in CLAYTONS PARK of Atascocita South(Market Area)

4 Bed(s)
2 Stories
2 Garages/Attached Garage
2.10 Bath(s)
2,371 Building Sq. Ft.
Pending

$234,900


17818 Alpine Brook, Humble, Texas 77346

 5 - days on HAR
MLS# 46164705

Single-Family, Traditional in Claytons Park Sec 01 of Atascocita South(Market Area)

4 Bed(s)
2 Stories
2 Garages/Attached Garage
3.00 Bath(s)
2,144 Building Sq. Ft.
Pending

$220,000


Showing listings 1 to 4 of 4