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

Lot 9 BELLA VISTA BOULEVARD For Sale

fairmont hot springs, British Columbia V0B1L1
$ 279,000
  • ©MLS 2472885

Description

With an amazing world class view and spectacular location this really is like living in a national park. Perched high above Columbia Lake in Bella Vista Estates on a quiet no-through road with inspiring mountain and lake views. Build your family's dream home on the partially treed .42 acre single-family estate lot with roughly 95 foot frontage and 200 feet of depth. This land deserves something special and with easy access to all area recreational amenities (golf, skiing, boating, hiking, biking...) this property 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 many different house 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 or time constraints, you can really plan and develop an amazing home! Enjoy the extensive walking paths throughout the community that feature quaint bridges, mountain creeks, and beautiful viewpoints of the lake and mountains. This is a professionally managed strata with secured boat and RV storage and a community club house available for Bella Vista residents. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Access Type: Public Road
  • Community: Fairmont/Columbia Lake
  • Maintenance Fee: 100.00/Monthly

Ammenities + Nearby

  • Ski area
  • Golf Nearby
  • Recreation Nearby
  • Airport
  • Park
  • Ski area
  • Golf Nearby
  • Recreation Nearby
  • Airport
  • Park

Features

  • Park setting
  • Treed Lot
  • Quiet Area
  • Rural Setting
  • Mountain view
  • Valley view
  • Lake 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®)