Business for Sale : Not Found /businesses-details/coolabah-tree-caf--south-brisbane-qld-27507.php

The Business for sale you were after has been removed from our website. Please Search again or Look at some other businesses for sale below.

select a.*,b.name as category_name,c.type,c.logo,c.company_name,d.state as state_name, e.name as country_name,f.listing_id FROM listings a inner join active_listings as f on(f.listing_id=a.id) inner join users as c ON(f.user_id=c.id) inner join category as b ON (a.category_id=b.id) inner join state as d on(a.state=d.abv ) inner join country as e on (a.country_id=e.id) and e.id=d.country_id AND a.status=1 AND advert_status!=2 and a.country_id=1 and a.state='QLD' and a.city='BRISBANE' and a.price_range='4' and a.category_id=79 order by a.updated_date desc limit 0,10