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 INNER JOIN tourThemes ON ttTourId = tourId AND ttThemeId IN (4) WHERE tourSiteId = 1 AND tourIsPublic = 1 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle

Grand Tours - Friendly Planet Travel

*** DEVELOPMENT VERSION ***

This is quite embarrassing, but our website database is currently having issues. That means most stuff related to our tours & packages won't work, including webpages, online bookings, search results and lists of our packages. We are working to fix this as quickly as we can, so please check back soon!

Grand Tours

Grand Tours

Get ready for the adventure of a lifetime, without a gigantic price tag! Typically longer in duration, you take time, delve deeper and truly immerse yourself in a destination and culture. You'll enjoy high-quality, well-located hotels, small groups and special insider access to comfortably indulge in the iconic, as well as the hidden treasures, of your destination.

Search filters:
  • Interests: Grand Tours
  • including closed packages
to
to
to
clear all
Sorry, there are currently no matching packages. Try searching again for something different or less specific.
* Advertised prices may include an "Instant Savings" discount and/or sale discount, available for a limited time. Prices reflect these discounts. Advertised prices are per person, based on double occupancy; single occupancy rooms may be available for an additional charge. Advertised prices are the best available based on the least expensive travel dates, departure city, and other options, and do not include optional excursions or other optional items. Your total price will vary based upon the dates, flights, and other options you select during the booking process. For packages including flights, prices include Airline Taxes, Fees & Sept. 11th Security Fee, but do not include excess baggage fees or advance seat reservations. Prices and availability subject to change. More about our prices.

© Friendly Planet Travel   Privacy Policy
SCRIPT ERRORS:

Database errors occured on /vacation-packages/index.asp?theme=4 while opening database connection
Error #: 0
Description: Invalid connection string attribute
Native error: 0



Please notify the webmaster of this error.
Execution time
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 INNER JOIN tourThemes ON ttTourId = tourId AND ttThemeId IN (4) WHERE tourSiteId = 1 AND tourIsPublic = 1 AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle		 0.01 seconds
Query executed in: 0.04 seconds
Total execution:   0.06 seconds