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 '%tour 18%' AND PropertyType = 'Single-Family' ORDER BY ListPrice DESC
18306 Hampton Hills, Humble, Texas 77338

Single-Family, Traditional in Villages/Tour 18 Sec 1 of Humble Area East(Market Area)
$374,999
18015 Hampton Hills, Humble, Texas 77338

Single-Family, Traditional in Villages/Tour 18 Sec 1 of Humble Area East(Market Area)
$329,000
18222 Hampton Hills, Humble, Texas 77338

Single-Family, Traditional in Villages/Tour 18 of Humble Area East(Market Area)
$319,900
10311 Eagle Hollow, Humble, Texas 77338

Single-Family, Traditional in VILLAGES AT TOUR 18 of Humble Area East(Market Area)
$309,000