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

$ 219,500
  • ©MLS 10319650

Description

You'll simply love this set up! This is a premium lot located right on the sandy shore of the cove with beach leading you right into the water, perfect for a paddle board or a swim. Features include 50 Amp service, septic, water, a gazebo, and custom cedar fencing. When you own in the Cottonwood Cove Resort, it means secured, freehold ownership in a prime, 5-Star location on Shuswap Lake in Lee Creek. A short 5-minute drive from the Trans-Canada Highway over the Squilax Bridge brings you to this resort with over 3,000 feet of prime waterfront real estate. This provides a camping experience with a front row seat to nature, complete with urban services, amenities, and a sense of community. Park your rig here and have unlimited access to an on-site marina, boat launch, and year-round storage. Owners have the option of a private boat slip at an additional cost, subject to availability. Here you own more than just a lot, this community includes a clubhouse, 2 substantial, sandy waterfront beaches, a full in-ground pool, numerous hiking trails, and the convenience of an on-site general store, all within the confines of the development. The lake is the main attraction here and waterfront activities abound. Golf Talking Rock, just a 10-minute drive. No more worrying about where to park your RV or your boat for the winter, and no more missing out a spot due to overbooked campsites, you can now relax, knowing your spot at the lake is waiting for you, a nature lovers paradise. (id:48970) Show More

Details

  • Property Type: Recreational
  • Type: Other
  • Access Type: Easy access
  • Road: Gravel road
  • Community: The Cottonwood Cove Resort
  • Neighbourhood: North Shuswap
  • Maintenance Fee: 318.04/Monthly

Ammenities + Nearby

  • Golf Nearby
  • Park
  • Recreation
  • Golf Nearby
  • Park
  • Recreation

Features

  • Level lot
  • Private setting
  • Family Oriented
  • Pet Restrictions
  • Pets Allowed With Restrictions
  • Lake view
  • Mountain view
  • View (panoramic)

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