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!=26765498 having distance <= 11 order by distance limit 3
- ©MLS 2476217
Description
This 6.7-acre lakeview lot offers south facing views of Galena Bay on Arrow Lake. Power is connected with a pole recently installed on the property. Also, a has been drilled 180 feet deep with a reported 7.5 gallons per minute flow. A garage foundation has been installed to get you started with your dream project. The area has so much recreation to offer, winter sports like sledding or downhill skiing/boarding at Revelstoke. Two hot spring areas are within a short drive. In the summer enjoy boating, fishing and a swimming beach is minutes away. The neighborhood has a public beach close by. Trout Lake is a short drive away, Nakusp is 45 minutes and Revelstoke one- and 1/4-hour drive for supplies and restaurants. (id:48970) Show More
Details
- Property Type: Vacant Land
- Access Type: Public Road
- Community: Nakusp Rural
Features
- Quiet Area
- 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