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
- ©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