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!=26608406 having distance <= 11 order by distance limit 3
- ©MLS 10306720
Description
Cottonwood Cove Resort - This premium, private corner lot features 50 Amp service, septic, water, a fence and comes fully landscaped. 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. With approval, owners can construct sheds and decks on their lots. Owners have the option of a private boat slip at an additional cost, subject to availability. Here you own more than just a lot, you're investing in a lifestyle! Park your rig here and have unlimited access to an on-site marina, boat launch, and year-round storage. With approval, owners can construct sheds and decks on their lots. Owners have the option of a private boat slip at an additional cost, subject to availability. Here you own more than just a lot, you're investing in a lifestyle. (id:48970) Show More
Details
- Property Type: Recreational
- Type: Recreational
- Access Type: Easy access
- Road: Gravel road
- Neighbourhood: North Shuswap
Ammenities + Nearby
- Golf Nearby
- Recreation
- Golf Nearby
- Recreation
Features
- Level lot
- Private setting
- Family Oriented
- Pet Restrictions
- Pets Allowed With Restrictions
- Rentals Allowed
- River view
- Lake view
- Mountain view
- View of water
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