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!=26989324 having distance <= 11 order by distance limit 3
- ©MLS 10315714
Description
Turtle Mountain provides incredible Okanagan Lake and valley views. Live within the amazing nature Vernon has to offer while being only steps away from local amenities and the city’s core. Enjoy also the Grey Canal hiking trail and mesmerizing Bella Vista views, world famous beaches, award winning wineries and spectacular golf courses. They are only minutes away! Tassie Creek Estate has been created to help celebrate all that this region has to offer. A stunning 5 acre park with all its beauty compliments the estate’s area and outdoor living. Build your dream home the way you want with the builder you desire. Choose a customized layout. The possibilities of this property are endless. (id:48970) Show More
Details
- Property Type: Vacant Land
- Type: Other
- Access Type: Easy access
- Road: Paved road
- Neighbourhood: Bella Vista
Ammenities + Nearby
- Airport
- Recreation
- Schools
- Shopping
- Ski area
- Airport
- Recreation
- Schools
- Shopping
- Ski area
Features
- Mountain view
- Valley view
- 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
