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` = '1' and `BedroomsTotal` = '1' and ListingID!=27728083 having distance <= 11 order by distance limit 3

148 Silver Lode Lane Unit# 309 For Sale

silver star, British Columbia V1B3M1
$ 149,000
$ 283 / Sq. Ft.
  • ©MLS 10330168
  • Area 527 sq ft
  • Bedrooms 1
  • Bathrooms 1

Description

Located in the heart of the Village, Vance Creek offers an affordable and lucrative investment opportunity! Enjoy the convenience of ski in and ski out access, with the hotel handling all bookings. Indulge in rooftop hot tubs, ski lockers, and wheelchair accessibility. Adjacent to the Black Pine Restaurant and Red Antler Pub, this fully furnished suite sleeps 6, complete with a full kitchen and bathroom featuring a tub and shower. Vance Creek management ensures hassle-free bookings, making ownership a breeze. (id:48970) Show More

Details

  • Constructed Date: 1993
  • Property Type: Single Family
  • Type: Apartment
  • Access Type: Easy access
  • Community: Vance Creek Hotel
  • Neighbourhood: Silver Star
  • Maintenance Fee: 1037.00/Monthly

Ammenities + Nearby

  • Cable TV
  • Park
  • Recreation
  • Shopping
  • Ski area
  • Park
  • Recreation
  • Shopping
  • Ski area

Features

  • Mountain view
  • View (panoramic)
  • Smoke Detector Only
  • Baseboard heaters
  • Storage, Locker

Rooms Details For 148 Silver Lode Lane Unit# 309

Type Level Dimension
Full bathroom Main level 11'7'' x 5'7''
Primary Bedroom Main level 11'7'' x 15'2''
Living room Main level 11'7'' x 10'7''
Kitchen Main level 11'7'' x 5'7''

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

©️ Hybrid Real Estate Plugin For CREA DDF

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