7654 DONALDSON DRIVE, grand forks, British Columbia V0H1H2

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!=25173442 having distance <= 11 order by distance limit 3

7654 DONALDSON DRIVE For Sale

grand forks, British Columbia V0H1H2

$ 899,000

©MLS 2468671

Description

The Grand Forks Station Pub, with its heritage charm and friendly service, this is a great business opportunity! This is a truly unique business and property with a ton of potential to grow. The building sits on 0.823 acres of prime commercially zoned property. There is an amazing patio facing the TransCanada trail. If you are considering a unique hospitality business, this could be your next purchase! Call your agent to view today! No direct contact with the employees or staff. Viewings before business hours only. (id:48970) Show More

Details

Constructed Date: 1910
Property Type: Retail
Community: Grand Forks

Features

Forced air

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

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®)