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 `BedroomsTotal` = '2' and `BedroomsTotal` = '1' and ListingID!=27706520 having distance <= 11 order by distance limit 3
Escape the hustle of city life with a retreat to this charming cabin by the lake. Located in the peaceful Parker Cove community, this panabode-style log home blends comfort with outdoor adventure. Key Features: Bed and Bath: featuring 2 cozy bedrooms & a well-appointed bathroom making this cabin perfect for family getaways or weekend retreats with friends. Kitchen: The updated bright white kitchen includes a pass-thru to the dining area, enhancing mealtime gatherings. Living Area: The roomy living room invites relaxation with its cozy propane fireplace, while the dining area boasts magnificent lake views that are sure to impress your guests. Modern Amenities: The home offers stylish vinyl plank flooring, an insulated crawl space for year-round occupancy &updated electric baseboard heaters. A propane hook-up on the deck is ready for your BBQ. Outdoor Living: The expansive front deck provides stunning lake views, ideal for al fresco dining and entertaining. Storage Options: A 10x8 detached storage shed offers additional space for gear & equipment. Community Benefits: Parker Cove is a scenic lakeside community on the west side of Vernon, just 25 minutes from the city. Residents enjoy over 2000 feet of Okanagan lakeshore & a convenient boat launch. Lease Information: The home’s lease is registered until January 2043, with a current annual fee of $4,817. Don't miss the chance to own this cabin at 36 Lakeshore Drive, perfect for a weekend getaway or full-time living. (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®)
