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

Proposed Lot 10 Scenic Ridge Drive For Sale

west kelowna, British Columbia V4T2X3
$ 529,900
  • ©MLS 10305316

Description

It’s 2020 at Smith Creek West!! For a very limited time, we have rolled back the pricing on our Phase 2 homesites by up to 25%, so don’t miss your chance to take advantage of this exciting offer! After many months of design and detail work with our Guidelines consultant, and the City, we are excited to bring you the finest, most diverse and well integrated family homesites in West Kelowna. This exciting new family neighborhood is sure to delight with its spectacular lake, mountain, and rural vistas, easy access and proximity to all the ever expanding amenities of West Kelowna. Designed to integrate well with the native environment, and respect the history of the area, a quiet walk, hiking, mountain biking, and more are all available at your back door. We are confident that you’ll something that satisfies your home design preferences, space requirement and budget with the same stunning natural surroundings, neighbourhood focus, easy access, and proximity to the amenities that lead to a very quick “sellout” of the previous phase. This is a walk-out homesite which will accommodate rancher or two story design with walkout basement, pool sized backyard, with easy and level access and great LAKEVIEW potential. Two year time limit to build, and you can bring your own builder! Subdivision registration anticipated by the end of March 2024. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Type: Other
  • Road: Paved road
  • Neighbourhood: Smith Creek

Features

  • City view
  • Lake view
  • Mountain view
  • Valley view
  • View (panoramic)

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