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
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
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®)
