REGION:00046Cats
Build HierarchyQUERY[SELECT DISTINCT c.*, h.name as h_name FROM cms_module_listings c INNER JOIN cms_module_listings_prodtohier ph ON ph.listing_id = c.id INNER JOIN cms_module_listings_hierarchy h ON ph.hierarchy_id = h.id WHERE c.status = 'published' and (c.listing_date < now() or c.listing_date is null) AND upper(h.long_name) LIKE upper(?) ORDER BY listing_date desc]
| AD #5043 | 90 acres (Land) | 155 Cloud River Road West, Neebing, Ontario | $42,000 |
|
| Reduced the price from $ 46,800 to $ 42,000 for quick sale.
Wood-forest recreational or farm acreage of 90 acres or 36.4 hectares. Located 25 miles (approx 40 kilometers) southwest of the city of Thunder Bay, and 15 miles (approx 24 kilometers) from US border in Province of Ontario, Canada. Off of Highway 61 connecting City of Thunder Bay and... [ read more] |
| [Top] |
| AD #5042 | Campground & Retail (Business) | #358, Hwy. 11 & 17, R.R.#1, Nipigon | $250,000.00 |
|
| 58 acres on Trans-Canada Highway presently operating as an overnight campground and rock/gift shop. Prime location with 800+ feet highway frontage. 10 acres presently developed with 20 more recently cleared. CAA/AAA, Woodalls, OPCA & Good Sam approved.
Abundant clean water from 3 wells.
Soil well-drained, raised glacial beaches. Various levenls... [ read more] |
| [Top] |
Debug:
REGION:00046Cats
Build HierarchyQUERY[SELECT DISTINCT c.*, h.name as h_name FROM cms_module_listings c INNER JOIN cms_module_listings_prodtohier ph ON ph.listing_id = c.id INNER JOIN cms_module_listings_hierarchy h ON ph.hierarchy_id = h.id WHERE c.status = 'published' and (c.listing_date < now() or c.listing_date is null) AND upper(h.long_name) LIKE upper(?) ORDER BY listing_date desc]
