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

20042 Dawn Mist, Humble, Texas 77346

 12 - days on HAR

MLS# 40537368

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

3 Bed(s)

1 Stories

28 Garages/Attached Garage

2.00 Bath(s)

1,387 Building Sq. Ft.

Active

$195,900

---

19915 Faye Oaks, Humble, Texas 77346

 7 - days on HAR

MLS# 14010328

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

3 Bed(s)

2 Stories

2 Garages/Attached Garage

2.10 Bath(s)

1,137 Building Sq. Ft.

Option Pending

$195,000

---

19806 Dawn Mist, Humble, Texas 77346

 5 - days on HAR

MLS# 66220854

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

3 Bed(s)

1 Stories

2 Garages/Attached Garage

2.00 Bath(s)

1,496 Building Sq. Ft.

Pending

$184,900

---

5455 Quail Tree, Humble, Texas 77346

 22 - days on HAR

MLS# 3823661

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

3 Bed(s)

1 Stories

2.00 Bath(s)

1,294 Building Sq. Ft.

Active

$179,900

---

20038 Faye Oaks, Humble, Texas 77346

 6 - days on HAR

MLS# 44939177

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

3 Bed(s)

2 Stories

2 Garages/Attached Garage

2.10 Bath(s)

1,449 Building Sq. Ft.

Pending

$155,000

---

Showing listings 1 to 5 of 5

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