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!=27624566 having distance <= 11 order by distance limit 3
Dual Brand Opportunity - Two brands under one roof. This restaurant is location in the heart of Vernon, inside of the Best Western Pacific Inn. This Canadian brand franchise offers a unique dining experience that caters to customer that require classic comfort food and unique authentic Italian Pizzas. Don't miss out on this once in a lifetime opportunity to be part of the Ricky's/Famoso Neapolitan Pizzeria Franchise Family. Existing Ricky's location was renovated in 2023 and upgraded to add a Famoso Neapolitan Pizzeria. Ricky's has been operating for the past 10 years. Franchisor approval is required and a minimum of 40% of liquid cash required for approval. Business owners or staff are not to be approached directly. (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®)
