Business for Sale : Not Found
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=5 and a.state='minnesota' and a.city='St. Paul-Minneapolis-Twin Cities' and a.price_range='3' and a.category_id=6 and a.price_numeric!=0 order by a.price_numeric asc limit 0,10