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

LOT 14 ALDER Court For Sale

sun peaks, British Columbia V0E5N0
$ 649,000
  • ©MLS 10331107

Description

Welcome to the building site of your dreams in 'Alder Estates'. This new 16 lot subdivision is adjacent to the Sun Peaks Golf Course and offers easy access to world-class skiing, Nordic trails and thrilling mountain biking terrain. This location offers the best of lifestyle and mountain majesty with gentle topography and southern/westerly exposure. Nestled within a serene and private landscape, this exceptional subdivision presents a unique opportunity for the investor or homeowner seeking to bring their architectural dreams to life. These prepared building lots feature underground utilities and are zoned for short term rentals. This one-of-a-kind subdivision exudes a sense of seclusion and tranquility surrounded by the embrace of nature. The property showcases stunning mountain views that will leave you in awe. Don't miss this opportunity to build your mountain retreat, embrace the extraordinary beauty of Alder Estates and create a lifetime of cherished memories. GST applies. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Type: Other
  • Access Type: Easy access
  • Road: Paved road, Cul de sac
  • Neighbourhood: Sun Peaks

Ammenities + Nearby

  • Golf Nearby
  • Recreation
  • Ski area
  • Golf Nearby
  • Recreation
  • Ski area

Features

  • Cul-de-sac
  • Private setting
  • View (panoramic)

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline 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®)