Business for Sale : Not Found /businesses-details/noodle-and-sushi-bar--the-shop-has-a-reputation-for-quality-ingredients-and-great-tasting-food-the.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='NSW' and a.city='Sydney' and a.price_range='2' and a.category_id=2 and (c.type=1) order by a.id desc limit 0,10