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!=27541812 having distance <= 11 order by distance limit 3
- ©MLS 2480054
Description
Build your dream retreat with this exceptional lot offering breathtaking mountain views in a sought-after golf and ski destination. Nestled in a tranquil setting, this location provides the perfect canvas for your future home or vacation getaway. Imagine waking up to stunning sunrises and panoramic vistas that change with the seasons, creating a picturesque backdrop year-round. With easy access to world-class skiing at Panorma Mountain Resort in winter and Greywolf golf course in the summer, outdoor enthusiasts will find endless opportunities for adventure right at their doorstep. The lot's prime location ensures both privacy and convenience, with nearby amenities, dining, and recreational activities just a short drive away. Whether you're looking to build a cozy cabin or a luxurious retreat, this is a rare opportunity to own a piece of paradise in a vibrant community. Don?t miss your chance to create lasting memories in this idyllic setting?where every day feels like a vacation! (id:48970) Show More
Details
- Property Type: Vacant Land
- Type: Other
- Road: Cul de sac
- Neighbourhood: Panorama
Ammenities + Nearby
- Golf Nearby
- Recreation
- Ski area
- Golf Nearby
- Recreation
- Ski area
Features
- Cul-de-sac
- Treed
- Sloping
- Rural Setting
- Mountain view
- No heat
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