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 'Summerwood' ORDER BY ListPrice DESC
13723 Greenwood, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$539,900
13607 Blair Hill Ln, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$519,000
13611 Blair Hill, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$509,900
13915 Misty Leaf, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$460,000
12922 Breezy Meadow, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$429,999
13507 Wildwood Springs, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$429,000
13014 Teaberry, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$399,900
15614 Stone Gables, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$399,000
14335 Penshore Park, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$349,000
13419 Caney Springs, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$339,000