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

Lot 21 WALNUT STREET For Sale

powell river, British Columbia
$ 269,000
  • ©MLS 18161

Description

Prime development property in the heart of Powell River's 'Townsite Business Area'. One of a five-lot package of almost three-quarters of an acre of gently sloping land overlooking the Salish Sea and central to an up-and-coming business area in Powell River's Townsite, this is a prime location for a variety of commercial possibilities. Purchase one or more of the five! The city and the T'lamen First Nation are working together to renew the old pulp mill site and a large, nearby property like this one will be ideal to capitalize on a new venture for the future. It has great visibility being on or adjacent to Marine Ave, the north-south thoroughfare. This older area in Powell River has seen much popularity and improvement in the last 10 years and is growing into a vibrant community. This property offers much possibility nestled among a variety of growing businesses. (id:48970) Show More

Details

  • Property Type: Business

Ammenities + Nearby

  • Shopping
  • Shopping

Features

  • Sloping
  • Visual exposure
  • Accommodation
  • Restaurant
  • Retail and Wholesale
  • Retail and Wholesale
  • Service
  • Health Care and Social Assistance
  • Restaurant/pub
  • Food store
  • General retail

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Powell River Sunshine Coast Real Estate Board

©️ Hybrid Real Estate Plugin For CREA DDF

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