Business for Sale : Not Found /businesses-details/artificial-lawns.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='WA' and a.city='0' and a.price_range='3' and a.category_id=6 order by a.id desc limit 0,10