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
- ©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