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 ;
$26,000
1244 North STONE Unit: PH
CHI - Near North Side
3 bedrooms 3.1 baths
$22,000
1955 Telegraph Unit:
Lake Forest
7 bedrooms 9.2 baths
$22,000
401 North WABASH Unit: 88A
CHI - Near North Side
3 bedrooms 5.1 baths
$20,000
1555 North ASTOR Unit: 41EW
CHI - Near North Side
4 bedrooms 4.2 baths
$19,500
22 LAKEWOOD Unit:
Highland Park
7 bedrooms 8.2 baths
$18,000
199 East LAKE SHORE Unit: 5E
CHI - Near North Side
3 bedrooms 3.1 baths
$17,000
1906 North Burling Unit:
CHI - Lincoln Park
5 bedrooms 5.3 baths
$16,000
1299 Waters Edge Unit:
Northbrook
3 bedrooms 5.1 baths
$16,000
16556 County Line Unit:
Capron
4 bedrooms 6.2 baths
$16,000
25164 West SUNSET Unit:
Lake Villa / Lindenhurst
7 bedrooms 8.2 baths
$15,000
199 East Lake Shore Unit: 6E
CHI - Near North Side
3 bedrooms 3.2 baths
$15,000
575 LONGWOOD Unit:
Glencoe
5 bedrooms 5.2 baths
$15,000
3912 North KEELER Unit:
CHI - Irving Park
6 bedrooms 4.2 baths
$14,000
11 East Walton Unit: 3002
CHI - Near North Side
3 bedrooms 3.1 baths
$13,000
1221 SHERIDAN Unit:
Wilmette
4 bedrooms 4.1 baths
$12,500
2020 PENSIVE Unit:
Northbrook
5 bedrooms 5.1 baths
$12,000
411 East North Water Unit:
CHI - Near North Side
3 bedrooms 4.1 baths
$12,000
401 North Wabash Unit: 85A
CHI - Near North Side
3 bedrooms 3.1 baths
$11,750
401 North Wabash Unit: 72D
CHI - Near North Side
3 bedrooms 4 baths
$11,000
676 LONGWOOD Unit:
Glencoe
5 bedrooms 6 baths