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 ;
$46,000
11 East Walton Unit: 5500
CHI - Near North Side
4 bedrooms 4.1 baths
$40,000
973 SHERIDAN Unit:
Winnetka
10 bedrooms 11. baths
$20,000
130 North GARLAND Unit: PH5702
CHI - Loop
4 bedrooms 3.1 baths
$18,000
1239 Oxford Unit:
Naperville
6 bedrooms 7.2 baths
$17,000
336 West Wisconsin Unit:
CHI - Lincoln Park
5 bedrooms 4.2 baths
$16,000
6 Athena Unit:
Tinley Park
6 bedrooms 9.2 baths
$15,000
63 West SCHILLER Unit:
CHI - Near North Side
4 bedrooms 4.1 baths
$14,000
1242 North Astor Unit:
CHI - Near North Side
6 bedrooms 4.3 baths
$13,000
77 East Walton Unit: 28B
CHI - Near North Side
3 bedrooms 3.1 baths
$12,900
1815 South PRAIRIE Unit:
CHI - Near South Side
4 bedrooms 4.2 baths
$12,500
1664 North Burling Unit:
CHI - Lincoln Park
5 bedrooms 4.1 baths
$12,000
401 North Wabash Unit: 72D
CHI - Near North Side
3 bedrooms 4 baths
$12,000
914 West Hubbard Unit: PHN
CHI - West Town
4 bedrooms 4.1 baths
$12,000
100 Laurel Unit:
Highland Park
5 bedrooms 6.2 baths
$12,000
2020 Pensive Unit:
Northbrook
6 bedrooms 5.1 baths
$11,500
640 South WAUKEGAN Unit:
Lake Forest
5 bedrooms 7.1 baths
$11,000
1555 Hazel Unit:
Winnetka
5 bedrooms 6.3 baths
$11,000
401 North Wabash Unit: 31A
CHI - Near North Side
3 bedrooms 4 baths
$10,500
401 North WABASH Unit: 60E
CHI - Near North Side
2 bedrooms 3 baths
$10,000
218 East Sixth Unit:
Hinsdale
6 bedrooms 5.1 baths