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

5631 Deer Timbers, Humble, Texas 77346

 6 - days on HAR

MLS# 90392395

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

4 Bed(s)

2 Stories

2 Garages/Attached Garage

2.10 Bath(s)

2,534 Building Sq. Ft.

Pending

$224,900

---

19918 Misty Pines, Humble, Texas 77346

 9 - days on HAR

MLS# 72580671

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

4 Bed(s)

2 Stories

2 Garages/Attached Garage

2.10 Bath(s)

1,799 Building Sq. Ft.

Pending

$189,500

---

5455 Quail Tree, Humble, Texas 77346

 59 - days on HAR

MLS# 15272304

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

$169,900

---

19931 Faye Oaks, Humble, Texas 77346

 6 - days on HAR

MLS# 64859354

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

3 Bed(s)

1 Stories

2 Garages/Attached Garage

2.00 Bath(s)

1,257 Building Sq. Ft.

Pending

$164,900

---

Showing listings 1 to 4 of 4

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