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

$ 144,900
  • ©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

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