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!=26621406 having distance <= 11 order by distance limit 3
- ©MLS 2475444
Description
Welcome home to beautiful Crawford Bay! This lovely 0.43 acre serviced lot has been thoughtfully developed to allow you the scope to create your dreams while still maintaining the majority of the majestic cedars and firs. Located across from the famous Kokanee Springs Golf course with a stunning view of the pond, greens and mountains beyond, this property is truly a place to build your future slice of Kootenay paradise! The paved roads offer easy access to your commute whether it be lakeside or the short drive to the Kootenay Bay ferry terminal. The community of Crawford Bay offers many modern conveniences along with the charm of friendly people and breathtaking natural beauty surrounding it. Call your REALTOR(R) and book your showing today! (id:48970) Show More
Details
- Property Type: Vacant Land
- Access Type: Public Road
- Community: Crawford Bay / Riondel
Ammenities + Nearby
- Golf Nearby
- Recreation Nearby
- Golf Nearby
- Recreation Nearby
Features
- Corner Site
- Treed Lot
- Quiet Area
- Rural Setting
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