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