Lot 21 COLUMBIA RIDGE DRIVE, fairmont hot springs, British Columbia T3A6A6

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!=26769009 having distance <= 11 order by distance limit 3

Lot 21 COLUMBIA RIDGE DRIVE For Sale

fairmont hot springs, British Columbia T3A6A6

$ 99,000

©MLS 2476230

Description

*LAKE ACCESS BUILDING LOT WITH LOVELY MOUNTAIN VIEWS* This beautiful building lot is one of very few parcels left untouched and awaiting the vision you have in mind for your very own mountain retreat. Plenty of green space surrounds your building envelope on this large nearly half an acre building site and you are walking distance to the private community beach on Columbia Lake, one of many recreational amenities in the area. Also enjoy close proximity to numerous golf courses, restaurants, Fairmont Ski hill, Fairmont Hot Springs, hiking/biking trails and much much more. With no time to build commitment you can wait as long as you like to plan your construction or hold the lot for investment purposes. Act now! (id:48970) Show More

Details

Property Type: Vacant Land
Access Type: Public Road
Community: Fairmont/Columbia Lake

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

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