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 '%commons%' AND PropertyType = 'Lots' AND City = 'huffman' ORDER BY ListPrice DESC
10728 Kingwood, Huffman, Texas 77336
13 - days on HARLots, in Commons/Lake Houston Sec 07 Residence of Huffman Area(Market Area)
$2,499,000
0 Commons Scenic View, Huffman, Texas 77336
13 - days on HARLots, in Commons/Lake Houston Sec 08 Residence of Huffman Area(Market Area)
$1,944,518
247 Vista Del Lago, Huffman, Texas 77336
15 - days on HARLots, in Commons of Lake Houston Sec 05 of Huffman Area(Market Area)
$325,000
407 Remington, Huffman, Texas 77336
27 - days on HARLots, in Commons Waterway Sec 5 of Huffman Area(Market Area)
$225,000
402 Remington, Huffman, Texas 77336
0 - days on HARLots, in Commons of Lake Houston of Huffman Area(Market Area)
$195,000
431 Mendecino Glen Court, Huffman, Texas 77336
0 - days on HARLots, in Commons of Lake Houston of Huffman Area(Market Area)
$145,000
29203 FM 2100, Huffman, Texas 77336
294 - days on HARLots, in Commons Of Lake Houston of Huffman Area(Market Area)
$125,000
29207 FM 2100, Huffman, Texas 77336
295 - days on HARLots, in Commons Of Lake Houston of Huffman Area(Market Area)
$125,000
1022 Commons View, Huffman, Texas 77336
35 - days on HARLots, in Commons/Lake Houston Sec 14 of Huffman Area(Market Area)
$119,500
28203 Lazy Rock, Huffman, Texas 77336
247 - days on HARLots, in Commons Waterway of Huffman Area(Market Area)
$109,000
Copyright Kimberly Berger 2013