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` = '3' and `BedroomsTotal` = '2' and ListingID!=27195942 having distance <= 11 order by distance limit 3
- ©MLS 10320096
- Area 1320 sq ft
- Bedrooms 3
- Bathrooms 2
Description
Welcome to your dream getaway at Crooked Lake, a haven for outdoor enthusiasts and nature lovers! It's the perfect place to create lasting memories, whether you're fishing, snowmobiling, or simply enjoying the stunning views. Don’t miss the opportunity to own this slice of paradise! The Cabin comes with a Private Dock with Floating Barge - Enjoy direct access to Crooked Lake & 4 other lakes, renowned for its excellent fishing + enjoy cross-country skiing, hiking, and ATV adventures. The cabin is equipped with a combination of solar, generator, and battery power, along with hot water on demand. There is even high-speed internet powered by Xplornet keeping you connected! The cabin features hardwood floors, an abundance of windows, and a massive sunroom that offers panoramic views of the lake and mountains. The open concept kitchen, dining, and living room create a spacious and welcoming atmosphere. With 3 bedrooms and 2 bathrooms, there is plenty of space for family and friends. A massive secure storage room under the cabin provides ample space for all your outdoor equipment. Additionally, there is an A-frame cabin on the property that can be used for storage. Convenient Access - Just 25 minutes from Lake Country. This property is on a renewable 15-year crown lease. Please note that traditional financing is not available for this property. (id:48970) Show More
Details
- Constructed Date: 2005
- Property Type: Recreational
- Type: House
- Neighbourhood: Lake Country East / Oyama
Features
- Mountain view
- Valley view
- View of water
- See remarks
- Waterfront on lake
Rooms Details For Block A Crooked Lake Road
| Type | Level | Dimension |
|---|---|---|
| Foyer | Main level | 6'11'' x 10'4'' |
| Full bathroom | Main level | 5' x 8'6'' |
| Bedroom | Main level | 12'4'' x 10'1'' |
| Bedroom | Main level | 8'6'' x 10'1'' |
| Full ensuite bathroom | Main level | 4'11'' x 10'1'' |
| Primary Bedroom | Main level | 10'9'' x 12'9'' |
| Sunroom | Main level | 19'1'' x 11'7'' |
| Living room | Main level | 17'10'' x 12'9'' |
| Kitchen | Main level | 14'4'' x 12'9'' |
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
