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 ListingID!=27292062 having distance <= 11 order by distance limit 3
- ©MLS 10321806
- Area 23483 sq ft
Description
SILVER STAR RESORT-The Bulldog Hotel – an icon in the heart of the Village is available for new ownership! Reflecting the colorful Victorian theme, this cozy slope-side lodge sits on .52 acre and offers the best ski in-out access - being just steps from the gondola. The two-story building and full basement provide 4 separate business areas: the Hotel/ Rooms, the Restaurant/Lounge, the Wine Cellar/Sports Bar, and the Laundry. Plans will also accommodate a bakery! 26 rooms (4 rented for staff) are fully equipped for guest comfort! The restaurant/lounge of approx. 3720 sq. ft. plus 900ft open air deck is licensed and seats 165 guests! The lower level includes the 1200 sq. ft, De Vine wine cellar which seats 30 patrons in cozy, just refurbished, après-ski comfort! The lower level also includes Ski lockers, bike storage, washrooms, the future bakery, staff room, cooler, laundry (that offers service to several other Village businesses). (id:48970) Show More
Details
- Constructed Date: 1983
- Property Type: Hospitality
- Type: Other
- Neighbourhood: Silver Star
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