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

4795 34th Street For Sale

vernon, British Columbia V1T5Y9
$ 650,000
$ 184 / Sq. Ft.
  • ©MLS 10328023
  • Area 3538 sq ft

Description

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

Details

  • Property Type: Hospitality
  • Type: Other
  • Neighbourhood: City of Vernon

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline 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®)