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