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!=26569871 having distance <= 11 order by distance limit 3
This 0.60 sloped lot with no timeline to build has two access points. The first being Mountain Drive and the second being an easement off Lakewood Drive at the top of the lot. The top of the lot offers stunning view of multiple arms of Okanagan Lake as well as partial city views of Vernon. Westshore Estates is approximately 30 mins from Vernon where you will find 3 fantastic golf courses, restaurants to suite the whole family, Silver Star Mountain and many more tourist activities for the whole family to enjoy. Stop and check out the iconic Fintry Provincial campground complete with the Fintry falls. Residents of Westshore Estates have access to the community beach complete with boat ramp, picnic tables, washrooms and dog beach. This lot is fantastic for a forever home or a summer getaway. (id:48970) Show More
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®)
