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 corner%' AND PropertyType = 'Single-Family' ORDER BY ListPrice DESC

×

Your Favorites

Remove All

12306 Granite Woods, Humble, Texas 77346

 0 - days on HAR
MLS# 94841789

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

4 Bed(s)
2 Stories
2.10 Bath(s)
2,690 Building Sq. Ft.
Option Pending

$225,000


18430 Emory Brook, Humble, Texas 77346

 8 - days on HAR
MLS# 31989555

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

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

$223,900


12306 English Brook, Humble, Texas 77346

 19 - days on HAR
MLS# 38722614

Single-Family, Traditional in Claytons Corner Sec 1 of Atascocita South(Market Area)

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

$199,000


12231 Carriage Oak, Humble, Texas 77346

 4 - days on HAR
MLS# 24817222

Single-Family, Traditional in Claytons Corner Sec 02 of Atascocita South(Market Area)

3 Bed(s)
1 Stories
2 Garages/Attached Garage
2.00 Bath(s)
1,745 Building Sq. Ft.
Option Pending

$183,000


Showing listings 1 to 4 of 4