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` = '1' and ListingID!=27438103 having distance <= 11 order by distance limit 3
- ©MLS 10324410
- Area 1081 sq ft
- Bedrooms 2
- Bathrooms 1
- Parkings 2
Description
Nestled in the desirable Knoll at Silver Star Mountain Resort, this rare two-bedroom suite offers breathtaking views of the ski slopes and the Village. With no GST and no rental obligations, this unit is perfect for quick possession and immediate enjoyment. The open-concept layout, enhanced by 9-foot ceilings and abundant natural light from the numerous windows, creates a spacious and inviting atmosphere. Step out onto the covered deck to relax in your private hot tub while enjoying the mountain scenery. The suite features in-suite laundry, hot water heating, and a practical layout designed for convenience. A dedicated ski locker, waxing station, and storage room located near the main entry make it easy to gear up for your outdoor adventures. Situated adjacent to a ski way, biking, and walking path, this property offers unparalleled access to year-round recreation. Don't miss this opportunity to own a piece of mountain paradise! (id:48970) Show More
Details
- Constructed Date: 2001
- Property Type: Single Family
- Type: House
- Community: Blueskies
- Neighbourhood: Silver Star
Features
- Irregular lot size
- Pets Allowed
- Rentals Allowed
- Mountain view
- Range
- Refrigerator
- Dishwasher
- Dryer
- Hood Fan
- Washer & Dryer
- Hot Water
- See remarks
- Storage, Locker
- Waterfront nearby
Rooms Details For 415 Silver Queen Road Unit# 2
Type | Level | Dimension |
---|---|---|
Full bathroom | Basement | 8'2'' x 4'11'' |
Bedroom | Basement | 12'4'' x 10'5'' |
Primary Bedroom | Basement | 11'10'' x 12'0'' |
Kitchen | Basement | 12'8'' x 10'0'' |
Dining room | Basement | 12'7'' x 9'3'' |
Living room | Basement | 16'4'' x 14'5'' |
Storage | Main level | 4'7'' x 7'4'' |
Storage | Main level | 7'3'' x 4'0'' |
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