$208531.0YesNoNo1 available136 N Butler Street 3

$57502.0YesNoNo1 available136 N Butler Street 6

$58502.0YesNoNo1 available135 N Butler Street 3

$203031.0YesNoNo1 available140 N Butler Street 2

$61001.0YesNoNo1 available136 N Butler Street 2

$58502.0YesNoNo1 availableMirabel Apartments 2 BR 2 BA

$1630 - $1940
22.0YesYesNo1 availableTimberlake Village Apartments 2 BR 1 BA

$1350 - $1425
21.0YesYesNo1 available136 N Butler Street 5

$59502.0YesNoNo1 availableMiddleton Ridge 2 BR 2 BA

$1790 - $1950
22.0YesYesNo1 availableBig Sky 1br

$113511.0YesYesNo1 availableTIMBERLAKE VILLAGE APARTMENTS 1 BR

$1160 - $1295
11.0NoNoNo8 available1113 E Mifflin Street A

$156021.0YesYesNo1 available109 N Butler St 3

$76501.0NoNoNo1 available523 Wingra Street 2

$111511.0NoNoNo0 available

SELECT inventory_items.*, inventory_items.id AS inventory_id, inventory_categories.name AS category_name FROM inventory_items JOIN inventory_category_item ON (inventory_category_item.item_id = inventory_items.id) JOIN inventory_categories ON (inventory_categories.id = inventory_category_item.category_id) WHERE ( show_item = 1 ) GROUP BY inventory_items.name ORDER BY stock_status ASC