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 lease' and ListingID!=26842157 having distance <= 11 order by distance limit 3
- ©MLS C8059715
Description
1900 sq.ft. of street level storefront retail/office space located in Downtown Aldergrove. C2 zoning which allows for commercial, assembly uses, office, etc. Bring your business to the downtown core of Aldergrove! Contact for details. (id:48970) Show More
Details
- Property Type: Retail
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Fraser Valley Real Estate Board