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

4802 Conifer Ridge, Humble, Texas 77346

 6 - days on HAR
MLS# 45259123

Single-Family, Contemporary/Modern in Claytons Park of Atascocita South(Market Area)

5 Bed(s)
2 Stories
2 Garages/Attached Garage
3.10 Bath(s)
3,304 Building Sq. Ft.
Active

$295,000


17810 Deep Shade, Humble, Texas 77346

 35 - days on HAR
MLS# 60601032

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

5 Bed(s)
2 Stories
2 Garages/Attached Garage
3.00 Bath(s)
2,695 Building Sq. Ft.
Option Pending

$263,700


4946 Blue Spruce Hill, Humble, Texas 77346

 4 - days on HAR
MLS# 7909980

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,309 Building Sq. Ft.
Pending

$260,000


4702 Conifer Ridge, Humble, Texas 77346

 6 - days on HAR
MLS# 26773265

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

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

$249,999


4938 Conifer Ridge, Humble, Texas 77346

 3 - days on HAR
MLS# 73923399

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

4 Bed(s)
2 Stories
2 Garages/Attached Garage
2.10 Bath(s)
2,336 Building Sq. Ft.
Pending Continue to Show

$244,900


4739 Blue Spruce Hill, Humble, Texas 77346

 8 - days on HAR
MLS# 12428982

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

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

$239,900


5047 Blue Spruce Hill, Humble, Texas 77346

 0 - days on HAR
MLS# 75565704

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

3 Bed(s)
1 Stories
2 Garages/Attached Garage
2.20 Bath(s)
1,396 Building Sq. Ft.
Active

$220,000


Showing listings 1 to 7 of 7