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!=27018073 having distance <= 11 order by distance limit 3
10 acre commercial zoned property (C-3, Tourist Commercial) situated along a major highway, Hwy.#6, which runs directly from the North Okanagan to the Kootenay's. This property would be ideal for a Gas Station / Convenience Store or Tourist Accommodation as it has direct access to Hwy. #6 and Calder Rd. The next closet tourist services are in Cherryville 83 kms to the West and Edgewood, 10 kms off the highway to the South. The 10 acres are mostly flat with hydro service already established on the property as well as a shallow Well. The land is nicely treed and very park-like. Buildings include a large 24' x 40' open front Storage Shed and a C-Can of little value. Zoning allows for one dwelling on the property, build your dream home and establish a business at the same time. Easy to view, call or email for an information package . (id:48970) Show More
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®)
