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
- ©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