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!=27733202 having distance <= 11 order by distance limit 3
TWO LOTS - TWO APPROVED DOCKS. Discover opportunity to own two adjacent lots offering nearly 170 feet of breathtaking lakefront in the prestigious Raymer Bay. Renowned for its extraordinary water depth, this prime piece of Okanagan Lake real estate is ideal for boating enthusiasts and anyone seeking a tranquil waterfront lifestyle. Imagine building your dream home, complete with stunning views both day and night, showcasing picturesque sunrises and an evening skyline illuminated by the beautiful city lights. With direct lake access, every day feels like a vacation. In addition to the prime lots, you'll benefit from a fully renovated, exceptionally appointed home perched right along the water’s edge. Whether you envision peaceful mornings or lively gatherings with family and friends, this property provides the perfect canvas for your lakeside oasis. It is truly a rare chance to secure over an acre of waterfront property in one of the Okanagan's most sought-after locations. (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®)
