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!=25344727 having distance <= 11 order by distance limit 3
Premium .16 acre lot in Wildsong with breathtaking views of Predator Ridge and Okanagan Lake. The best reason to live at Predator Ridge is the lifestyle. If you're looking for a true lifestyle community in Canada, you won't find another community richer in amenities. This development features 27 exclusive building lots that sold out when initially offered. This lot features 60’ of frontage x 115' depth, a perfect lot to build a walkout rancher style home. Wildsong is not a strata community, however it offers weekly landscaping and amenities ($205 Landscaping + Amenities $80) that covers landscaping maintenance, road snow removal and recreation. Predator Ridge offers 36 holes of world class golf, walking/hiking/biking trails, tennis/pickleball and minutes from spectacular lakes, wineries and the Kelowna International Airport. Choose from one of the exclusive builders to build your dream home and live the ""Resort Lifestyle"" at Predator Ridge to enjoy all the amenities it has to offer. (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®)
