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!=26482002 having distance <= 11 order by distance limit 3
- ©MLS 176576
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: Business
- Community: Adams Lake
Features
- Treed
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