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!=26432619 having distance <= 11 order by distance limit 3
- ©MLS 2474641
Description
ROLLING GRASSLAND AROUND 300 ACRES. VENDOR FINANCING IS AVAILABLE FROM THE SELLERS. There are small towns nearby. 17 minutes to Midway, 23 minutes to Rock Creek, 28 minutes to Greenwood, and under two hours to Kelowna. The SPECTACLAR acreage has miles of ATV trails. A RURAL LIFE AT ITS BEST. Incredible views. The ranch is partially fenced for horses and has open areas for cattle to graze. Agricultural zoning allows for up to 10 worker accommodations and two residences. (id:48970) Show More
Details
- Constructed Date: 1994
- Property Type: Agriculture
- Community: Grand Forks Rural West
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