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)
$554,900
14223 Chartley Falls, Houston, Texas 77044

Single-Family, Traditional in SUMMERWOOD of Summerwood/Lakeshore(Market Area)
$399,900
15702 Tremout Hollow, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$389,000
14414 Wildwood Springs, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$350,000
13703 Slate Mountain, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$335,000
15718 Starcreek, Houston, Texas 77044

Single-Family, Contemporary/Modern in Summerwood of Summerwood/Lakeshore(Market Area)
$295,000
14815 Chapal Gate, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$289,900
12818 Cambridge Eagle, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$279,750
14126 Seagler Springs, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$279,000
12735 Bridle Springs, Houston, Texas 77044

Single-Family, Traditional in Summerwood of Summerwood/Lakeshore(Market Area)
$249,900