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

2 - 2400 KOOTENAY RD NO 3 ROAD For Sale

windermere, British Columbia V0B1L1
$ 369,000
  • ©MLS 2479031

Description

PRIVATE ESTATE ACREAGE! Welcome to Elkhorn Estates, a gated community in Windermere, BC, where tranquility meets convenience. Nestled far from the hustle and bustle yet close to all essentials, this expansive 5-ACRE parcel offers magnificent 360-degree mountain views that stretch as far as the eye can see. Situated on Kootenay #3 Road, you are truly surrounded by nature in your own private oasis. The possibilities for your dream home are endless--build high to capture the sweeping valley & mountain views or nestle into the trees for ultimate coziness. You have an open canvas to create a masterpiece in multiple different locations on this property. Plus, with irrigation water rights from Windermere water, you can create a lush and glorious yard and garden to complement your perfect home. Picture yourself on a spacious wraparound deck, enjoying sunrises, sunsets, and stargazing in the perfect darkness that only nature provides. This extraordinary property awaits--call now to schedule a viewing! (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Community: Windermere
  • Communication: High Speed Internet

Ammenities + Nearby

  • Ski area
  • Stores
  • Schools
  • Golf Nearby
  • Recreation Nearby
  • Shopping
  • Ski area
  • Stores
  • Schools
  • Golf Nearby
  • Recreation Nearby
  • Shopping

Features

  • Hillside
  • Private setting
  • Wooded area
  • Treed Lot
  • Quiet Area
  • Rural Setting
  • 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: Kootenay 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®)