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!=27223408 having distance <= 11 order by distance limit 3
Welcome to Koocanusa Village! This 0.54 acre lot is situated on the Terrace. Located in a prime location, this spacious property boasts breathtaking views of the lake and its surrounding mountain ranges. Koocanusa Village is a community nestled between southeastern BC's mountain resort communities of Cranbrook and Fernie, and 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, and has exciting improvements in the works. Future plans for the community include an interior lake for swimming, paddle boarding, and canoeing, a marina complex with a store, dry storage options, an outdoor performance stage, washrooms, picnic areas, a restaurant and bar, and green space linkages to offer pedestrian routes - you'll easily be able to visit with other residents! 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
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®)
