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 (locationParentId = 397 OR laParentId = 397) AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle
4
Tours & Packages to Central America - Friendly Planet Travel
Central America, a captivating region between the Pacific Ocean and the Caribbean Sea, beckons adventurers with its vibrant tapestry of cultures, breathtaking landscapes, and rich history. Explore lush rainforests, where howler monkeys swing from towering trees and colorful macaws paint the sky. Discover the awe-inspiring Mayan ruins that whisper tales of an ancient civilization's glory. Dive into crystal-clear waters teeming with kaleidoscopic marine life or ride exhilarating waves along the coastline. Sample mouthwatering cuisine influenced by indigenous traditions and Spanish heritage. Savor aromatic local coffee or sample delectable street food in vibrant local markets. Whether you seek adventures like zip-lining through cloud forests or seek solace on secluded white sand beaches, Central America promises unforgettable experiences at every turn. So pack your sense of adventure and let Central America captivate your heart as it unveils its hidden treasures.
Browse our packages to Central America below, or select a destination to narrow the results.
The capital San José, spectacular Arenal and its volcano, 3 relaxing days in Playa Hermosa; travel on your own with flights & hotel included. Optional pre-tour to Tortuguero.
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, locationHTMLTitle, locationMetaDesc, locationDesc, locationLargeImage FROM locations WHERE locationPage = 'central-america' AND locationType = 1 AND locationSiteId = 1
0 seconds
Query executed in:
0.04 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 (locationParentId = 397 OR laParentId = 397) AND tourCategory IN (1,3,4) ORDER BY tourBookable DESC, tourMinSalePrice, tourFeatureTitle