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 `BedroomsTotal` = '2' and `BedroomsTotal` = '1' and ListingID!=26481643 having distance <= 11 order by distance limit 3

10045 ADAMS EAST FSR For Sale

adams lake, British Columbia V0E1M0
$ 3,499,900
$ 3,646 / Sq. Ft.
  • ©MLS 176574
  • Area 960 sq ft
  • Bedrooms 2
  • Bathrooms 1

Description

Adventure awaits at this exceptional 28 acre Resort Property, nestled on the banks of Adams Lake and the Momich River with LRT-2 zone. This property is the gateway to the world-famous Adams River Salmon Run, a destination for thrill-seekers and nature enthusiasts alike. Whether you're seeking the rush of world class fishing, or simply a peaceful escape into nature, this resort offers it all. Accommodations include modern renovated cabins, 100s of RV camping options as well as traditional tent sites are available for a night under the stars. Thrill-seekers can take advantage of world class snowmobile excitement or the endless hunting landscape, while others can explore the many hiking trails or unwind on the unlimited stretch of fine pebble beachfront. This resort is truly self-sufficient with a 9 kilowatt Solar System, a 38 kilowatt Diesel Generator and a Water Filtration System. Boaters and anglers alike will be delighted by the protected lagoon with a 45' concrete boat launch and 60'xl0' of dock. With abundant space, this property is a canvas ready for your vision and offers endless possibilities to enhance the already thriving Grizzly Adams Lake Resort. Currently there is a 2 bed log home, a 2 bed guest cabin, 2 separate bunkhouses and a shower house for the guests. This beautiful property is sided by crown land, giving you nature as far as the eye can see. Hunters, fishermen, adventures and families will have everything they need to create an experience to remember! (id:48970) Show More

Details

  • Property Type: Single Family
  • Type: House
  • Construction Material: Log
  • Road: No thru road
  • Community: Adams Lake

Features

  • Park setting
  • Private setting
  • Treed
  • Flat site
  • Quiet Area
  • View of water
  • Mountain view
  • River view
  • Refrigerator
  • Washer
  • Dishwasher
  • Dryer
  • Stove
  • Microwave
  • Waterfront

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kamloops & District Real Estate Association

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