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

LOT 40 DAWN VISTA Ridge For Sale

fairmont hot springs, British Columbia V0B1L1
$ 140,000
  • ©MLS 2479874

Description

Nestled in the trees, on a quiet street in picturesque Bella Vista Estates! You will have views of not one but two Mountain ranges. You really do need to visit Columbia Lake to experience the scenic views and the beauty and tranquility. This flat estate lot is .41 an acre and has 108 feet of frontage (174 feet deep) and could be the spot you have been searching for to build your custom, light-filled family retreat. Bella Vista has a generous building scheme and architectural guidelines that include size options to fit any family's wishes and budget. Underground services including propane are brought right to the property line (rare for the Valley) and with no building commitment, you can take the time you want to plan and develop an amazing dream home! Enjoy the extensive walking paths throughout the community that feature quaint bridges, mountain creeks, and beautiful viewpoints of the lake and mountains. Bella Vista?s convenient location offers easy access to airports, golf, skiing, fishing, boating, hiking and biking. This is a professionally managed strata with secured boat and RV storage available for Bella Vista residents. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Type: Other
  • Neighbourhood: Fairmont/Columbia Lake

Ammenities + Nearby

  • Golf Nearby
  • Airport
  • Recreation
  • Shopping
  • Ski area
  • Golf Nearby
  • Airport
  • Recreation
  • Shopping
  • Ski area

Features

  • Level lot
  • Treed
  • Mountain view
  • Valley view
  • View (panoramic)
  • No heat

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