REGION:00026Cats
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 #2048 | 800 acres (Land) | NE-14-30-22-W4 | 988,000 |
|
| This primo recreational property has been in my family for 100 years. It is comprised of 800 acres, 160 deeded and the rest as a grazing lease. The deeded property is a perfect home site being close to all services and having spectacular views of the 2 valleys and creeks. The terrain varies from cool spruce forests to striking badlands.Presently... [ read more] |
| [Top] |
| AD #2047 | 142 acres (Land) | S.E1-64-6 W 4, M.D. Bonnyville, Alberta | $280,000.00 |
|
| Own A Little Bit Of Country, 142 acres, 90 acres is seeded to tame grass, and 52 acres of Spruce and Popular. Soil is grey wooded. Beautiful rolling hills throughout property with 3 dugouts. Property is cross fenced and ready for horses or hobby farm. 200'x110' outdoor riding area, new 30' x 32' barn with new corrals watering... [ read more] |
| [Top] |
| AD #2061 | 80 acres (Land) | Batty Lake, West of St. Paul, Alberta, Sec 17 TWP 59 Rge.11 W4M | $139,000 |
|
| A quiet place on a lake where you can enjoy the great outdoors - 1 hour and 45 minutes from Edmonton and 20 minutes from St. Paul. Does this sound like a place made just for you? If this is the kind of setting you are longing for then we have a beautiful 80 acre property with over a 800 feet of lakefront located a short drive from Edmonton. Great... [ read more] |
| [Top] |
Debug:
REGION:00026Cats
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]
