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` = '2' and `BedroomsTotal` = '2' and ListingID!=27125207 having distance <= 11 order by distance limit 3
- ©MLS 10318106
- Area 762 sq ft
- Bedrooms 2
- Bathrooms 2
Description
Okanagan living at it's finest! Okanagan Lake right outside your door! Newer Dock with boat lift (capable of 24 ft ) Two professionally built, oil field designed modulars, on skids. No roughing it here! Main living area has Vaulted ceilings, open Kitchen with island, french doors onto massive deck from living area! Bright an Spacious! Primary bedroom has stacked laundry in closet and Full bathroom Second unit has large bedroom with own bath. Storage around back for kayaks and paddle boards. Great waterfront getaway! Power, sand point well and septic all in place. Land is leased but cabins are owned! Quiet and peaceful. Half way between Kelowna and Vernon. This is a Buckshee Lease, $7200 per year. Occupany from April to October. No financing available. (id:48970) Show More
Details
- Property Type: Recreational
- Type: House
- Neighbourhood: Okanagan North
Features
- Central island
- Balcony
- Pet Restrictions
- Dock
- Lake view
- Mountain view
- View (panoramic)
- Refrigerator
- Range - Electric
- Water Heater - Electric
- Washer/Dryer Stack-Up
- Wall unit
- Heat Pump
- Waterfront on lake
Rooms Details For 4 Saskatoon Road
Type | Level | Dimension |
---|---|---|
3pc Bathroom | Main level | 10'5'' x 5'8'' |
Bedroom | Main level | 12'9'' x 10'6'' |
3pc Bathroom | Main level | 6'9'' x 5'11'' |
Primary Bedroom | Main level | 16'6'' x 12'4'' |
Dining room | Main level | 12'10'' x 5'5'' |
Living room | Main level | 12'4'' x 9'3'' |
Kitchen | Main level | 12'10'' x 6'11'' |
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