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

19310 Forest Fern, Humble, Texas 77346

 0 - days on HAR

MLS# 85212803

Single-Family, Traditional in Oaks of Atascocita of Atascocita North(Market Area)

4 Bed(s)

2 Stories

2 Garages/Detached Garage

2.10 Bath(s)

2,456 Building Sq. Ft.

Active

$229,900

---

Showing listings 1 to 1 of 1

• « first
• « prev
• 1
• next »
• last »