Image is missing
1610 Shady Glen Dr
Single Family, Bed:na, Bath:2.5
Sqft:1296

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
2406 Lakehurst Ave
Single Family, Bed:na, Bath:3.5
Sqft:995

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
1510 Shady Glen Dr
Single Family, Bed:na, Bath:na
Sqft:1155

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report

 
SELECT sqft,state,detaillink,city,bath,type,region,selling,basement,lot,bed,value,address,sindex,yearbuilt,imagelink,lat,longt,source as ID FROM allhomes WHERE (city="District Heights") and state="MD" and selling>=5000 and selling <=50000000 and bed>=0 and status<>"D" and type<>"L" ORDER by sindex, sellingtotalCount=131