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` = '2' and ListingID!=27600341 having distance <= 11 order by distance limit 3
Discover Switchback Creek - Sun Peaks' newest luxury alpine homes, offering a perfect blend of relaxation and vibrant village life. Enjoy stunning mountain views, upscale designer finishes with premium upgrade options and flexible floor plans in both 6-plex and 4-plex configurations. Large 2 and 3 bedroom floor plans within the 6-plex option and 3 bedroom floor plans in the 4 plex option. Tailored for year-round mountain living, these residences feature spacious outdoor areas with hot tub hookup and gas BBQ connection, all set within a beautifully landscaped community with ample parking. Step outside to access over 30 kilometers of groomed Nordic trails, world-class mountain biking, hiking trails, and more. Switchback Creek also borders the 14th hole of the golf course. Short-term rentals are allowed, and the developer's disclosure statement is in effect. Price is GST applicable. Elevate your mountain lifestyle at Switchback Creek. (id:48970) Show More
Details
Constructed Date: 2024
Property Type: Single Family
Type: Apartment
Architectural Style: Other
Community: Switchback Creek
Neighbourhood: Sun Peaks
Maintenance Fee: 642.36/Monthly
Features
Range
Refrigerator
Dishwasher
Microwave
Washer & Dryer
Baseboard heaters
Rooms Details For 7005 MCGILLIVRAY LAKE Drive Unit# 12
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®)
