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 rent' and ListingID!=27566984 having distance <= 11 order by distance limit 3
- ©MLS 10325667
- Area 5000 sq ft
Description
Approximately 5,000 SF of partially basement level space available at 3315 30th Avenue in downtown Vernon. The property is zoned C7 - Heritage Business District which allows for a variety of uses including office, retail, business services, etc. Independent entrance at street level and secondary/loading access at rear from alley. Includes a dedicated lift for loading access to/from the basement space. A portion of the basement is built out as a retail store originally intended to be a cannabis store but is suitable for other retail uses. The remainder of the space is partially built out for office use. Washrooms with showers included and complete. (id:48970) Show More
Details
- Property Type: Retail
- Type: Retail
- Neighbourhood: City of Vernon
Features
- Security
- Forced air
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