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!=27078902 having distance <= 11 order by distance limit 3
- ©MLS 10317702
Description
Enjoy 2.5 acres of Pristine Anstey Arm, east side, Waterfront with 154 feet of Soft Sandy Beach on Shuswap Lake with nice level field to play on. The most Majestic and Pristine area of the Shuswap (Number 1# boating lake in Canada). This lot has forestry road access, new aluminum dock & buoy and professionally designed floor plans maximizing the view for a cottage with 2 bedrooms, plus den and 2 bathrooms. Lake water intake available with application, large geo technical engineered safe building site established and septic already installed. Great Wifi and cell service available with only a 1.15 hour drive and 20-30 minutes boat ride from Sicamous. The $500 annual maintenance fee is for the shared road maintenance. This exceptional property is also connected to the Queest Mountain trail system for incredible sledding, hiking and quadding adventures. Another Bonus is you are located on the east side of the lake facing west, giving you sun until the end of the day and beautiful sunsets to cherish. Shark Shack restaurant and Sea Store are just a short boat ride away! (id:48970) Show More
Details
- Property Type: Recreational
- Type: Other
- Road: Gravel road
- Community: Willow on Anstey
- Neighbourhood: Shus./Anstey/Sey.
Features
- Irregular lot size
- Pets Allowed
- Rentals Allowed
- Lake view
- Mountain view
- View (panoramic)
- Waterfront on lake
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