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