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

1111 East Ingram FSR Road For Sale

midway, British Columbia V0H1M0
$ 1,200,000
  • ©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

©️ Hybrid Real Estate Plugin For CREA DDF

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)