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

Lot 64 MARCER ROAD For Sale

lake koocanusa, British Columbia V0B1R0
$ 149,999
  • ©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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)