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

415 Silver Queen Road Unit# 2 For Sale

silver star, British Columbia V1B3M1
$ 700,000
$ 648 / Sq. Ft.
  • ©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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)