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!=27357517 having distance <= 11 order by distance limit 3
- ©MLS 10323241
Description
Mining permit up for sale on this 9.785 Acre Property close to Tumbler Ridge. This sand and gravel mine's current provincial permit is good until 2027 and can be renewed after that. This pit has roughly 500,000 tonnes still available to mine with roughly 10,000 tonnes being removed per year by Kode Contracting. License of Occupation and Notice of Work are available with any accepted offer. (id:48970) Show More
Details
- Property Type: Industrial
- Type: Other
- Neighbourhood: Tumbler Ridge
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