No Businesses for sale found in Hyams Beach Please see below Other businesses for sale in New South Wales

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' order by a.id desc limit 0,10