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
- ©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