SELECT DISTINCT tourId, tourFeatureTitle, tourSubhead, tourCategory, tourIsNew, tourBookable, tourPage, tourVersionNum, tourLargeImg, tourMap, tourSaleCode, tourLandMinDuration, tourLandMaxDuration, tourLandMinEarlyBookPrice, tourLandMaxEarlyBookPrice, tourLandMinSalePrice, tourLandMaxSalePrice, tourAirMinDuration, tourAirMaxDuration, tourAirMinEarlyBookPrice, tourAirMaxEarlyBookPrice, tourAirMinSalePrice, tourAirMaxSalePrice, tourMinEarlyBookDiscount, tourMaxEarlyBookDiscount, tourMinSaleDiscount, tourMaxSaleDiscount, tourMinTotalDiscount, tourMaxTotalDiscount, ISNULL(tourAirMinSalePrice,tourLandMinSalePrice) AS tourMinSalePrice, DENSE_RANK() OVER(PARTITION BY tourPage, tourCategory ORDER BY tourVersionNum ASC) AS tourVersionOrder FROM toursActiveCache t LEFT JOIN tourLocations ON tourId = tlTourId LEFT JOIN locations ON tlLocationId = locationId AND locationType = 2 AND locationSiteId = 1 LEFT JOIN locationAssns ON laLocationId = locationId WHERE tourSiteId = 1 AND tourIsPublic = 1 AND locationId = 337 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle
44
Tours & Packages to Switzerland - Friendly Planet Travel
Jagged, snow-capped Alps form the backdrop for glacier trekking or shopping in ritzy St. Moritz. The world’s oldest democracy is delightfully clean, safe, and healthy. On-time trains carry Swiss toting bicycles and trekking poles. A melting pot with four official languages, it holds Europe’s highest coffee roastery and the loneliest train station on the “Heidi Express.”
Capital: Bern Population: 8.287 million Currency: Swiss franc (CHF) Languages: German, French, Italian and Romansh Drives on the: Right Time zone: UTC +8
Spring, summer and autumn are all very fair in Switzerland despite snow on its highest peaks year-round. June and July are when the alpine wildflowers bloom; they are also the peak season for tourists. Take a sweater no matter when you travel, and an umbrella.
Tipping
A 15% service charge is included in the price of all services and on your hotel bill. Round up taxi and restaurant bills if the service has been good.
Money & Credit Cards
The Swiss franc is the only currency accepted everywhere. Note that the Euro is a foreign currency in Switzerland, so accepting it results in extra costs and risks for shop owners. Therefore, if you pay with Euros, change will be in Swiss francs and the exchange rate is mostly not in your favor.
Always notify your bank prior to departure to avoid any problems using your credit or debit card while traveling.
Shopping
When shopping in Switzerland, look for watches, crystal, embroidered items, clocks, pottery, Swiss army knives, lace, cowbells, antiques, cutlery, ski clothing and equipment, shoes, chocolate, cheese, and liquors.
Electricity & Power Adapters
230 volts. Plug J. You will need a voltage converter and plug adapter in order to use U.S. appliances. We recommend getting a universal adapter and converter kit.
7 night captivating Rhine River cruise with shore excursions in Cologne, one of Germany’s oldest cities; medieval Ludwigshafen; Strasbourg, with its French & German influences; and historic Breisach
Christmas Market cruise with excursions in Düsseldorf, Germany's fashion capital; the winemaking town of Rüdesheim; Strasbourg, one of Europe's most beautiful cities; and medieval Colmar & Freiburg
We love hearing your stories and seeing your photos! Check out our entire fan photo gallery and upload your photos.
Check out independent, verified reviews from real travelers on Feefo.
Execution time
Starting query: SELECT locationId, locationName, locationParentId, locationCode2, locationHTMLTitle, locationMetaDesc, locationDesc, locationHighlights, locationLargeImage, showId AS locationSlideshowId, showLastModified AS locationSlideshowVer, slideImg AS locationSlideshowFirstImg, locationVideoIDs, locationFAQs, locationEntryReqs, locationFactsOverview, locationFactsHealth, locationFactsWeather, locationFactsClothing, locationFactsDining, locationFactsTipping, locationFactsMoney, locationFactsShopping, locationFactsPower, locationFactsTechnology, locationFactsPhotography, locationFactsTidbits, locationOmitFromMenus FROM locations LEFT JOIN ( SELECT showId, ROUND(CAST(s.lastModified AS float),4) AS showLastModified, slideImg, ROW_NUMBER() OVER (PARTITION BY showId ORDER BY slideOrder ASC) AS RowNum FROM slideshows s INNER JOIN slideshowImages i ON showId = slideShowId ) s ON showId = locationSlideshowId AND s.RowNum = 1 WHERE locationPage = 'switzerland' AND locationType = 2 AND locationSiteId = 1
0 seconds
Query executed in:
0.01 seconds
Starting query: SELECT DISTINCT tourId, tourFeatureTitle, tourSubhead, tourCategory, tourIsNew, tourBookable, tourPage, tourVersionNum, tourLargeImg, tourMap, tourSaleCode, tourLandMinDuration, tourLandMaxDuration, tourLandMinEarlyBookPrice, tourLandMaxEarlyBookPrice, tourLandMinSalePrice, tourLandMaxSalePrice, tourAirMinDuration, tourAirMaxDuration, tourAirMinEarlyBookPrice, tourAirMaxEarlyBookPrice, tourAirMinSalePrice, tourAirMaxSalePrice, tourMinEarlyBookDiscount, tourMaxEarlyBookDiscount, tourMinSaleDiscount, tourMaxSaleDiscount, tourMinTotalDiscount, tourMaxTotalDiscount, ISNULL(tourAirMinSalePrice,tourLandMinSalePrice) AS tourMinSalePrice, DENSE_RANK() OVER(PARTITION BY tourPage, tourCategory ORDER BY tourVersionNum ASC) AS tourVersionOrder FROM toursActiveCache t LEFT JOIN tourLocations ON tourId = tlTourId LEFT JOIN locations ON tlLocationId = locationId AND locationType = 2 AND locationSiteId = 1 LEFT JOIN locationAssns ON laLocationId = locationId WHERE tourSiteId = 1 AND tourIsPublic = 1 AND locationId = 337 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle