WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/18...' at line 1]SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( - Latitude) * pi()/180 / 2), 2) +COS( * pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/180 / 2), 2) ))) as distance from wp_phl_property where `property_id`>0 and `Sold` != '1' and `TransactionType` = 'For sale' and ListingID!=27143086 having distance <= 11 order by distance limit 3
- ©MLS 2478256
Description
Welcome to Lakeview Terrace at Koocanusa Village! Koocanusa Village is a community nestled between southeastern BC's Mountain resort communities of Cranbrook & Fernie & is only a 3.5 hour drive from Calgary. Features include lake accessible properties, build-ready lots, marina slips, plenty of room to boat on 145km of stunning water & has exciting improvements in the works. Future plans for the community include an interior lake for swimming, paddle boarding & canoeing, a marina complex with a store, dry storage options, outdoor performance stage, washrooms, picnic areas, a restaurant & bar, & green space linkages to offer pedestrian routes - you'll easily be able to go visit with other residents! This 0.20 acre corner lot is situated on the Terrace. Located in a prime location this property boasts breathtaking views of the lake & its surrounding mountain ranges. This development has no building time restrictions, with water, sewer, and hydro conveniently located at the property line. No GST applicable. Don't miss out on this incredible opportunity, contact me today for more information! (id:48970) Show More
Details
- Property Type: Vacant Land
- Access Type: Public Road, Easy access
- Community: Jaffray and Vicinity
- Communication: High Speed Internet
Ammenities + Nearby
- Ski area
- Golf Nearby
- Recreation Nearby
- Recreation
- Park
- Ski area
- Golf Nearby
- Recreation Nearby
- Recreation
- Park
Features
- Park setting
- Visual exposure
- Family Oriented
- Mountain view
- Lake view
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kootenay Real Estate Board