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!=26943131 having distance <= 11 order by distance limit 3
- ©MLS 10314950
Description
Lot #6 Osprey Lane (strata lot 74) at Cottonwood Cove RV Resort is a private 2,024 sqft piece of paradise with beautiful beaches & amenities, this RV lot is just steps from the beach. Lots of room for your family, room for a large destination trailer or fifth wheel, room for parking up to three vehicles, easily add a gazebo or shed, full RV hookups Stratified, freehold ownership, gated, secure and exclusive lakefront at Cottonwood Cove RV Resort has 2 private beaches, 2 playgrounds, a pool & hot tub, games / community room, 2 washroom/shower facilities, convenience store, laundry, boat launch, boat storage & more. The Cottonwood community hosts multiple events every summer, including Canada Day Parade, Christmas in July, Halloween in August, live music & games nights. It is a very nice community, fun for the whole family, and conveniently located less than 10 minutes off the TransCanada Hwy. Your lot at Cottonwood has a year- round caretaker, hydro (50 Amp service), water, sewer, and wifi included in your monthly strata ($318/mo). Lot is 35x59 Ft. Nightly & seasonal rentals allowed through the management company. Not just an amazing boating lake to explore, but also great fishing just 100 meters from this lot. Come check it out, truly the best RV resort in the Shuswap. (id:48970) Show More
Details
- Property Type: Recreational
- Type: Other
- Access Type: Easy access
- Road: Gravel road
- Community: Cottonwood Cove Resort
- Neighbourhood: North Shuswap
- Maintenance Fee: 318.07/Monthly
Ammenities + Nearby
- Clubhouse
- Recreation Centre
- Golf Nearby
- Park
- Golf Nearby
- Park
Features
- Level lot
- Irregular lot size
- Family Oriented
- Recreational Facilities
- Pets Allowed
- Rentals Allowed
- Clubhouse
- Playground
- 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