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 Property1063 Columbia
-
Click to View MoreView Property2046 N. Orleans
-
Click to View MoreView Property320 N. Michigan
-
Click to View MoreView Property4100 N. Marine Dr.
-
Click to View MoreView Property426 W. Surf
-
Click to View MoreView Property443 Wrightwood
-
Click to View MoreView Property6701 N. Glenwood
-
Click to View MoreView Property6710 N. Sheridan
-
Click to View MoreView Property6720 N. Sheridan
-
Click to View MoreView Property
Brookwood
-
Click to View MoreView Property
Stonegate
-
Click to View MoreView Property
The Ridge
