select mls_number,price,neighborhood , zip , city , address , unit ,bedrooms,baths from listing_search where ( type='Residential Rental') && ( type='Residential Rental' ) && (idx='Y' || is_srg=1) ORDER BY price desc LIMIT 0,20 ;
$35,000
1010 West George Unit:
Lake View
4 bedrooms 5.1 baths
$35,000
105 South Deere Park Unit:
Highland Park
6 bedrooms 5.3 baths
$30,000
77 Wentworth Unit:
Glencoe
9 bedrooms 5.2 baths
$30,000
1955 Telegraph Unit:
Lake Forest
7 bedrooms 9.2 baths
$20,000
2461 North GENEVA Unit:
Lincoln Park
6 bedrooms 5.1 baths
$18,000
2324 North WAYNE Unit:
Lincoln Park
6 bedrooms 4.1 baths
$18,000
126 ABINGDON Unit:
Kenilworth
5 bedrooms 6.1 baths
$17,000
1203 Whitebridge Hill Unit:
Winnetka
6 bedrooms 6.2 baths
$16,500
145 OXFORD Unit:
Kenilworth
6 bedrooms 5.2 baths
NEW LISTING
$16,000
16556 COUNTY LINE Unit:
Capron
4 bedrooms 5.2 baths
$15,000
4230 North Marine Unit:
Uptown
4 bedrooms 5.1 baths
$15,000
33W870 Country Club Unit:
Wayne
6 bedrooms 7.1 baths
$15,000
15141 North LITTLE ST MARYS Unit:
Mettawa
2 bedrooms 2.1 baths
$15,000
745 Barberry Unit:
Lake Forest
6 bedrooms 6.1 baths
$15,000
1500 North DEARBORN Unit:
Near North Side
4 bedrooms 3.2 baths
$15,000
1906 North burling Unit:
Lincoln Park
5 bedrooms 5.3 baths
$15,000
1833 North ORCHARD Unit:
Lincoln Park
5 bedrooms 5.1 baths
$15,000
55 East ERIE Unit: 3203
Near North Side
4 bedrooms 4 baths
$14,900
1804 North Leavitt Unit:
Logan Square
5 bedrooms 4.1 baths
$13,000
800 North Michigan Unit: 4702
Near North Side
3 bedrooms 3.1 baths