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 lease' and ListingID!=27459894 having distance <= 11 order by distance limit 3
- ©MLS 10324843
- Area 1864 sq ft
Description
At Silver Star Mountain Resort, a well appointed restaurant ready to go in a high exposure location in the Vance Creek Hotel. Virtually completely renovated. Tall ceilings, liquor license was in the restaurant plus the deck, 50 seats insider and 25 on the deck May also be combined with the Coldstream Drygoods location adjacent to provide over 50 feet of frontage on Main Street at Silver Star Mountain Resort. Two washrooms. Triple net fees include taxes, insurance, utilities excepting natural gas, snow removal (id:48970) Show More
Details
- Constructed Date: 1984
- Property Type: Business
- Type: Other
- Access Type: Easy access
- Community: Vance Creek
- Neighbourhood: Silver Star
Ammenities + Nearby
- Recreation
- Shopping
- Ski area
- Recreation
- Shopping
- Ski area
Features
- Balcony
- Family Oriented
- Baseboard heaters
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
