2808 48th Avenue Unit# B, vernon, British Columbia V1T3R4

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

2808 48th Avenue Unit# B For Rent

vernon, British Columbia V1T3R4

$ 21

/ Year

©MLS 10324259
Area 1200 sq ft

Description

This bright 1200 sq ft ft ground floor retail unit offers high visibility, open spaces, ample plumbing and parking in the back! This one wont last long. (id:48970) Show More

Details

Property Type: Other
Type: Residential Commercial Mix
Neighbourhood: City of Vernon

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

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