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
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
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®)
