REGION:00112Cats
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 #1080 | 160 ACRE + (Land) | WILLIAMS LK, BRITISH COLUMBIA | $211,000 + |
|
| Unique Cariboo properties for sale 36 titles of 80- 800 acre parcels, to be sold seperatley. 10 mins south of Williams Lk. B.C.scenic rolling hills with beautiful veiws of the San Jose River valley. Hwy 97 and paved road access, power and natural gas . 10 min. away from all amenities 20 minutes to airport river frontage, lake frontage,southern... [ read more] |
| [Top] |
| AD #1079 | Log Home (Home) | 151 Chignell Road, Tatla Lake, British Columbia | $475,000 |
|
| "The Balconies" $475,000 CN
A rare opportunity to own a piece of the Chilcotin! The Chilcotin is a unique area of the British Columbia Interior with very few properties available for private ownership.
This beautiful south western facing home with acreage is centrally located in recreational paradise. Surrounded by fantastic views of... [ read more] |
| [Top] |
| AD #1108 | 650+ acres (Land) | 9547 Highway 20, Kleena Kleene, British Columbia | $2,200,000 |
|
| Approximately 95% fenced and cross-fenced, this spectacular Chilcotin acreage provides multiple suitable building sites with magnificent views of the Coast Mountain Range.
The Kleena Kleene (Klinaklini) River flows through the property and the scenic mountainous surroundings make this estate an excellent choice for a variety of uses or... [ read more] |
| [Top] |
Debug:
REGION:00112Cats
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]
