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!=27236228 having distance <= 11 order by distance limit 3
- ©MLS 2478718
Description
Welcome to 421 Mountain View Rd, one of the largest lots in the Grandview subdivision. This 4.8 acre lot is only 24 min from Nelson. This property offers multiple build sites with road access, ready for development. The views are absolutely breathtaking, overlooking both directions of Kootenay lake. The setting is quiet, peaceful and private. The south facing slopes are the ideal orientation for morning and evening sun exposure. Power, gas, water, and sewer are ready for hookup. This dream lot is a blank canvas primed for your creation! (id:48970) Show More
Details
- Property Type: Vacant Land
- Access Type: Public Road
- Community: Kokanee Creek to Balfour
Ammenities + Nearby
- Recreation Nearby
- Recreation Nearby
Features
- Private setting
- 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
