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

20010 Swiftbrook, Humble, Texas 77346

 10 - days on HAR

MLS# 83348566

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

4 Bed(s)

2 Stories

2 Garages/Attached Garage

2.10 Bath(s)

2,661 Building Sq. Ft.

Option Pending

$220,000

---

20006 River Brook, Humble, Texas 77346

 11 - days on HAR

MLS# 11985753

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

3 Bed(s)

2 Stories

2 Garages/Attached Garage

2.10 Bath(s)

1,913 Building Sq. Ft.

Pending

$185,000

---

5455 Quail Tree, Humble, Texas 77346

 132 - 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

$179,900

---

20202 Dawn Mist, Humble, Texas 77346

 1 - days on HAR

MLS# 12236005

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

4 Bed(s)

1 Stories

2.00 Bath(s)

1,445 Building Sq. Ft.

Active

$172,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 5 of 5

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