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!=27211867 having distance <= 11 order by distance limit 3
- ©MLS 2478624
Description
Discover the Ultimate Mountain Escape at Lot 7 Bella Vista Boulevard! This incredible lot offers double access and showcases stunning views of Columbia Lake and the majestic Rocky Mountains. Create your dream home with soaring windows that capture nature's grandeur. Bella Vista Estates is a private, gated community with walking trails, a community center, and waterfalls, nestled in the heart of recreational paradise. Enjoy paddling and wind sports on Columbia Lake. Embrace lake life and build cherished family memories in this captivating locale. Don't miss this once-in-a-lifetime opportunity to claim your piece of mountain paradise and experience an extraordinary lifestyle! Act now and call for more information. Your dream home awaits! (id:48970) Show More
Details
- Property Type: Vacant Land
- Access Type: Public Road, Easy access
- Community: Fairmont/Columbia Lake
- Communication: High Speed Internet
Ammenities + Nearby
- Ski area
- Golf Nearby
- Recreation Nearby
- Recreation
- Ski area
- Golf Nearby
- Recreation Nearby
- Recreation
Features
- Park setting
- Private setting
- Sloping
- Visual exposure
- Treed Lot
- Quiet Area
- Family Oriented
- Rural Setting
- Mountain 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
