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!=26617335 having distance <= 11 order by distance limit 3
- ©MLS 2475428
Description
Dreaming of owning a slice of paradise for outdoor enthusiasts? Look no further than this rare gem in Elko, British Columbia! Located at 8828 N. Hertz St., this 1/2 Acre parcel backs onto crownland, offering endless opportunities for hunting, fishing, and all your favorite outdoor sports! This Haven Mecca is not just a beautiful natural retreat but also a small subdivision opportunity for building your dream home or a modern modular home (no older than 10 years). ? With a 400-foot drilled well and electricity available, live your dream out here. Don't miss out on this chance to own your own piece of outdoor paradise! (id:48970) Show More
Details
- Property Type: Vacant Land
- Access Type: Public Road
- Community: Elko to Montana
Features
- Mountain 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