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!=27488920 having distance <= 11 order by distance limit 3

9190 Silver Star Road For Sale

silver star, British Columbia V1B3M1
$ 3,750,000
  • ©MLS 10324181

Description

Don’t let this opportunity pass you by! Invest early in the potential of a unique proposed 14-lot Country Residential Subdivision in the Sunny Okanagan Ski Country. Tamarack Estates offers unparalleled proximity to the Controlled Recreation areas of Sovereign Lake and Silver Star Ski Resort. Just a scenic 4-minute drive from the Tamarack gate to the Silver Star Resort Village and only 20 minutes from Downtown Vernon, with Kelowna International Airport just 58 minutes away. Situated on 80 acres adjacent to Silver Star Provincial Park, currently zoned as Large Holding (LH) but planned for Country Residential (CR), Tamarack Estates promises an exclusive retreat amidst nature. Rezoning to CR is pending to facilitate development. Each 5.0-acre CR zoned freehold lot will feature private access roads, driveways, building pads, water, and electric services included. Fortis Gas will provide natural gas, and sewer will be managed via individual septic fields on each lot. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Type: Other
  • Road: Gravel road
  • Neighbourhood: Silver Star

Features

  • City view
  • Lake view
  • Mountain view
  • Valley view

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