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

8 Aline Hills Lake For Sale

shuswap lake, British Columbia V0E2V1
$ 379,000
$ 190 / Sq. Ft.
  • ©MLS 10314351
  • Area 1999 sq ft
  • Bedrooms 4
  • Bathrooms 3

Description

Beautiful Boat Access Cottage just minutes from the narrows and 20 minutes from Sicamous here on Shuswap Lake. Located on the West side of the Lake for early morning sun and late day shade to cool things down in the evenings. Family owed since built and is ready for the next family to create life long lake memories! Once inside you'll find 4 bedrooms, 3 bathrooms , a vaulted open concept kitchen, dinning and living area which flows out to the large deck with incredible mountain / lake views. The lower level has 2 of the bedrooms accessible by outdoor stairway. There is an additional enclosed shop area as well. An outdoor staircase brings you to the The upper level fourth private bedroom. The cottage is run off solar panels with battery bank, 110 plug ins and electric fridge. Must see property to appreciate its incredible location steps from the lake. Call today to discuss further. Water taxis available out of Sicamous. Vacant Lot #9 to the south also available. (id:48970) Show More

Details

  • Constructed Date: 1983
  • Property Type: Single Family
  • Type: House
  • Architectural Style: Cottage
  • Neighbourhood: Sicamous

Features

  • Private setting
  • Lake view
  • Mountain view
  • Refrigerator
  • Range - Gas
  • See Remarks
  • Stove
  • 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®)