Image is missing
1427 N Lake Shore Dr
Single Family, Bed:2, Bath:1
Sqft:764

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
24406 W Hillside Dr
Single Family, Bed:2, Bath:1
Sqft:975

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
1504 Round Lake Dr
Single Family, Bed:na, Bath:2
Sqft:1560

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
920 Bonnie Brook Ln
Single Family, Bed:3, Bath:1
Sqft:896

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
1020 Bonnie Brook Ln
Foreclosure, Bed:3, Bath:1.5
Sqft:1257

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
144 E Lake Park Ave
Single Family, Bed:na, Bath:1
Sqft:1058

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="Round Lake Beach") and state="IL" and selling>=5000 and selling <=50000000 and bed>=0 and status<>"D" and type<>"L" ORDER by sindex, sellingtotalCount=129