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!=27018073 having distance <= 11 order by distance limit 3
- ©MLS 2477581
Description
10 acre commercial zoned property (C-3, Tourist Commercial) situated along a major highway, Hwy.#6, which runs directly from the North Okanagan to the Kootenay's. This property would be ideal for a Gas Station / Convenience Store or Tourist Accommodation as it has direct access to Hwy. #6 and Calder Rd. The next closet tourist services are in Cherryville 83 kms to the West and Edgewood, 10 kms off the highway to the South. The 10 acres are mostly flat with hydro service already established on the property as well as a shallow Well. The land is nicely treed and very park-like. Buildings include a large 24' x 40' open front Storage Shed and a C-Can of little value. Zoning allows for one dwelling on the property, build your dream home and establish a business at the same time. Easy to view, call or email for an information package . (id:48970) Show More
Details
- Property Type: Vacant Land
- Community: West Arrow Park to Edgewood
Ammenities + Nearby
- Recreation Nearby
- Recreation Nearby
Features
- Flat site
- Treed Lot
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
