Search Apartments for rent in Madison WI

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 ) AND inventory_items.id IN (SELECT inventory_items.id FROM inventory_items JOIN inventory_tag_item itiaa ON (inventory_items.id = itiaa.item_id) JOIN inventory_tags itaa ON (itaa.id = itiaa.tag_id AND itaa.name LIKE '%Furnished%')) GROUP BY inventory_items.name ORDER BY stock_status ASC