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!=26728067 having distance <= 11 order by distance limit 3
Discover the extraordinary opportunity to acquire JoiRyde Winery, a flourishing ready-to-go winery nestled within Oliver’s bustling District Wine Village. Immerse yourself in the well-established brand's spirit, celebrating spontaneity and the joys of life's adventures. This winery encompasses top-tier equipment, an extensive inventory, and an enviable location at the heart of Okanagan Wine Country. Step into the lifestyle of JoiRyde. Celebrated for its exceptional wines that perfectly complement the diverse dining and shopping experiences offered by nearby vendors. With a backdrop of picturesque mountains, proximity to lakes, Area 27 Raceway Park, and an abundance of outdoor recreational activities, coupled with a multitude of events and entertainment, this investment guarantees great enjoyment for both locals and tourists. Seize the opportunity as an entry point into the vibrant and rewarding winery business – a lifestyle choice not to be missed!"" (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®)
