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 '%Lochshire%' AND PropertyType = 'Single-Family' ORDER BY ListPrice DESC
27310 Farmcreek, Huffman, Texas 77336
39 - days on HARMLS# 95489453
Single-Family, Other Style in Lochshire Sec 01 of Huffman Area(Market Area)
5 Bed(s)
2 Stories
2.10 Bath(s)
2,380 Building Sq. Ft.
Pending
$240,000
27327 Afton, Huffman, Texas 77336
15 - days on HARMLS# 65419011
Single-Family, Traditional in Lochshire of Huffman Area(Market Area)
4 Bed(s)
2 Stories
2 Garages/Detached Garage
2.10 Bath(s)
2,192 Building Sq. Ft.
Pending
$225,000
Copyright Kimberly Berger 2013