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` = '4' and ListingID!=27567584 having distance <= 11 order by distance limit 3
- ©MLS 10326489
- Area 3016 sq ft
- Bedrooms 3
- Bathrooms 4
- Parkings 1
Description
THE RIDGE at Silver Star Mountain Resort, never rented, NO GST - Former show home by Dauncey Construction. This 3-level turnkey duplex is waiting to offer you a year-round resort lifestyle! Ski in and ski out for both Alpine and Nordic!! Exceptional top floor main living area perfect for entertaining and your busy family! Assessed at $1.077.000 and over $100k in recent renovations; new oak engineered hardwood flooring, fresh paint throughout and new carpeting. Open concept with 9ft ceilings with custom open timber staircases with custom wood trim matching doors. Brazilian Slate tile floors throughout, gas fireplaces and expansive windows to take in the south facing views! TWO primary bedrooms on the main, complete with ensuites and shared private balcony plus den/bedroom with hide-a-bed on the top floor off the kitchen. Private guest accommodation bedroom with ensuite on lower level. This chalet sleeps 11 people! A spacious rec room with wet bar & ski tuning area with equipment storage! BONUS $21K hot tub included (purchased in 2022). Excellent kitchen with soft-close maple cabinets, Brazilian slate counters and raised bar & island for casual dining. This beautiful fully furnished home is ready for immediate possession, move in now or rent it out for the Holiday Season! Attached garage with paved driveway and Hardie Board siding exterior. Don't miss out on this one! Speculation Tax is not applicable. (id:48970) Show More
Details
- Constructed Date: 2009
- Property Type: Single Family
- Type: Duplex
- Neighbourhood: Silver Star
Features
- Central island
- Three Balconies
- Pets Allowed With Restrictions
- Mountain view
- Sprinkler System-Fire
- In Floor Heating
- Forced air
- Hot Water
- See remarks
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