Matching Apartments
| | $
BJB Properties's inventory is constantly growing, rehabbing and improving.
Below are the best of the best Chicago apartments that BJB Properties offers.
-
select b.building, b.hmy, c.overview, c.street_address, c.street_direction, c.street, b.crossStreets, c.location from availability_current a
INNER JOIN building_alias b
ON b.yardiDisplay = a.building
INNER JOIN buildings c
ON c.name = b.building
INNER JOIN unit_type_key d
on d.unitTypeNew = a.unitType
WHERE sub = 'No' GROUP BY b.building, b.hmy, c.overview, c.street_address, c.street_direction, c.street, c.location, b.crossStreets
-
Click to View MoreView Property1036 N. Dearborn
-
Click to View MoreView Property1063 Columbia
-
Click to View MoreView Property11 W. Division
-
Click to View MoreView Property1135 W. Pratt
-
Click to View MoreView Property1157 W. Diversey
-
Click to View MoreView Property1215 W. Diversey
-
Click to View MoreView Property1246 W. Pratt
-
Click to View MoreView Property18 E. Elm
-
-153-Feature.jpg)
Click to View MoreView Property180 W. Adams
-
Click to View MoreView Property2046 N. Orleans
-
Click to View MoreView Property211 E. Delaware
-
Click to View MoreView Property2244 N. Cleveland
-
Click to View MoreView Property244 E. Pearson
-
Click to View MoreView Property2828 N. Pine Grove
-
Click to View MoreView Property2850 N. Sheridan
-
Click to View MoreView Property320 N. Michigan
-
Click to View MoreView Property3838 N. Broadway
-
Click to View MoreView Property4100 N. Marine Dr.
-
Click to View MoreView Property
420 W. Surf
-
Click to View MoreView Property424 W. Diversey
-
Click to View MoreView Property443 Wrightwood
-
.jpg)
Click to View MoreView Property451 W. Wrightwood
-
Click to View MoreView Property629 W. Deming
-
Click to View MoreView Property660 W. Barry
-
Click to View MoreView Property6701 N. Glenwood
-
Click to View MoreView Property6720 N. Sheridan
-
Click to View MoreView Property721 W. Belmont
-
Click to View MoreView Property742 W. Fullerton
-
Click to View MoreView Property768 W. Jackson
-
Click to View MoreView Property839 Diversey
-
Click to View MoreView Property
Brookwood
-
Click to View MoreView Property
Stonegate
-
Click to View MoreView Property
The Ridge
-153-Feature.jpg)
.jpg)
