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

3 Willows on Anstey Beach E Unit# Lot For Sale

anstey arm, British Columbia V0E2V0
$ 795,000
  • ©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

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