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!=27164665 having distance <= 11 order by distance limit 3
- ©MLS 10319357
Description
This hidden parcel of land is nestled above the Kettle Valley in the Boundary Country. Stunning views of valleys and mountains in any direction. KMs of trails to ride, hike, quad on. Lots of wildlife in the area, and the property has Crown Land on 3 sides. Large pond, and several other smaller ponds, springs and streams. Diverse mix of forest, hillsides and open pasture. Great for a wilderness ranch, recreational parcel, or off-grid remote homestead. Land is fully fenced. Drilled well. Cell service. No power. There is approx 5 KMs of non-maintained forestry road to access the property. No neighbors in sight. Property has Farm Status so GST applicable. (id:48970) Show More
Details
- Property Type: Vacant Land
- Type: Other
- Road: Gravel road
- Neighbourhood: Rock Crk. & Area
Features
- Mountain view
- Valley view
- View of water
- View (panoramic)
- Waterfront on pond
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline Real Estate Board