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

$ 395,000
  • ©MLS 10315716

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
  • Road: Paved road
  • Neighbourhood: Bella Vista

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