or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

Sign up to our newsletter and become the first to know about our latest deals and promotions

Your 'Port' has been chosen Clear this filter or visit another page to change

Puerto Vallarta, Mexico

Enquire about cruises in this region

By reputation the second of Mexico's beach resorts, PUERTO VALLARTA is smaller, quieter and younger than Acapulco.

Whether you just want to relax and get away from it all or you are in the mood to party all night, Puerto Vallarta is the place for natural beauty of the ocean and hills and the warmth of the people.

When most people think of Mexico, they think of the special culture of the state of Jalisco: the Mariachi music, the colorful, swirling traditional dresses, the manly horsemen, and let’s not forget Jalisco’s most popular export – tequila! Puerto Vallarta is on the coast of this most representative of all Mexican states and you can get to know Mexico by visiting Puerto Vallarta.

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 21

Total elapsed time: 0.055328607559204

# Query Time
(1) connect 0.00073003768920898
(2) DESCRIBE `ports` 0.0024809837341309
(3) SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'puerto-vallarta-mexico') AND (orchid_available = 1) LIMIT 1 0.0074958801269531
(4) DESCRIBE `destinations` 0.0027120113372803
(5) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 53))) 0.00052118301391602
(6) DESCRIBE `avid_specials` 0.0024149417877197
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '53' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0040831565856934
(8) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00040006637573242
(9) SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '166') 0.0042498111724854
(10) SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '166') 0.0027379989624023
(11) DESCRIBE `cruises` 0.0029017925262451
(12) SELECT `cruises`.* FROM `cruises` WHERE (id IN (58987, 67122, 79927, 69691, 69735, 67915, 69688, 67915, 80920, 77031)) ORDER BY FIND_IN_SET(id, '58987,67122,79927,69691,69735,67915,69688,67915,80920,77031') 0.002004861831665
(13) DESCRIBE `cruiselines` 0.0027358531951904
(14) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '18', '23', '20', '91', '16', '33', '8', '14', '26', '19', '24', '114', '151')) ORDER BY FIND_IN_SET(id, '218,18,23,20,91,16,33,8,14,26,19,24,114,151') 0.0014941692352295
(15) DESCRIBE `ships` 0.0041859149932861
(16) SELECT `ships`.* FROM `ships` WHERE (id IN ('1711', '1302', '669', '1021', '340', '1742', '78', '657', '70', '1108', '441', '580', '1266', '84', '1569', '98', '74', '75', '123', '348', '674', '82', '332', '792', '43', '66', '290', '291', '325', '341', '394', '626', '776', '796', '108', '111', '253', '389', '616')) ORDER BY FIND_IN_SET(id, '1711,1302,669,1021,340,1742,78,657,70,1108,441,580,1266,84,1569,98,74,75,123,348,674,82,332,792,43,66,290,291,325,341,394,626,776,796,108,111,253,389,616') 0.0044479370117188
(17) DESCRIBE `cruisetypes` 0.0019409656524658
(18) DESCRIBE `destinations` 0.0033590793609619
(19) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('53', '48', '40', '37', '29', '34', '38', '43')) ORDER BY FIND_IN_SET(id, '53,48,40,37,29,34,38,43') 0.0014641284942627
(20) DESCRIBE `ports` 0.0024218559265137
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00054597854614258