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

DL 1999 Bouleau Lake Road For Sale

vernon, British Columbia V1T2G7
$ 120,000
$ 71 / Sq. Ft.
  • ©MLS 10311560
  • Area 1700 sq ft
  • Bedrooms 4
  • Bathrooms 1

Description

Enjoy a private setting on Bouleau lake known for its rainbow trout fishing, hiking trails, and peaceful mountain top surroundings. This original A-frame cabin has been substantially renovated and added onto in 2016 giving it approximately 1700 sq. ft. of enjoyable living space. This lake cabin comes partially furnished and complete with 4 unique bedrooms (7 beds in total), 1 bathroom (partially finished), a large open kitchen and dining area, a cozy family room with wood burning stove, and a massive covered porch for entertaining and enjoying the nature that surrounds you. *Please note - This is a seasonal, recreational, and a fully off-grid property, not intended be a primary residence. *Crown lease terms expires after 15 years from date of commencement, August 31, 2016 lease terms will be reviewed at time of renewal. (id:48970) Show More

Details

  • Constructed Date: 2016
  • Property Type: Single Family
  • Type: House
  • Architectural Style: Cabin, Cottage
  • Neighbourhood: Okanagan North

Features

  • Irregular lot size
  • One Balcony
  • Refrigerator
  • Range - Gas
  • Stove
  • Waterfront on lake

Rooms Details For DL 1999 Bouleau Lake Road

Type Level Dimension
Bedroom Second level 24' x 10'
Bedroom Second level 10' x 10'
Primary Bedroom Second level 12' x 10'
Bedroom Main level 10' x 8'
2pc Bathroom Main level 8' x 6'
Dining room Main level 10' x 10'
Living room Main level 24' x 12'
Kitchen Main level 20' x 12'

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