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

$ 129,500
  • ©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

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