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