'Pictures of travel and vacation destinations and tours for Central America and South America and México
'Pictures of travel and vacation destinations and tours for Central America and South America and México
México

Reservation Form for Hotel Fiesta Americana Grand Los Cabos - Los Cabos, México

Room Types Available
Personal Data







* Indicates Required Field

Trip Details





Possible Dates


Comments

Please indicate if you have any special needs or requirements not specified here (or if there´s something you specifically don´t like to do):



Call Latin America Collection Toll Free from the USA or CANADA toll free
USA:
1-866-256-2765
or
(800)-807-7952
CANADA:
(800)-807-7952

Click to View Larger Map
View Large mexico Map

  MEMORY USAGE  
2,609,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0816
Controller Execution Time ( Package Reservation / Index )  1.0068
Total Execution Time  1.0885
  URI STRING  
/mexico/reservation/hotel/resort/fiesta_americana_grand_los_cabos
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  QUERIES (19)  
0.0003  INSERT INTO ci_sessions (session_id, ip_address, user_agent, last_activity) VALUES ('ccc176575c0d6fb5c83f6de18762c640', '107.22.8.81', 'CCBot/2.0 (http://commoncrawl.org/faq/)', 1501104727)
0.3068  select * from hotels h join latinamericacollection.country c on h.CountryID = c.country_id join hotel_urls hu on hu.HotelID = h.HotelID join destinations_common d on d.DestinationID = h.DestinationID left join hotelclasses hc on hc.HotelClassID = h.HotelClassID where hu.HotelUrl = 'resort/fiesta_americana_grand_los_cabos' group by CompanyName
0.0001  SELECT `country_continent` FROM (`country`) WHERE `country_linkname` = 'mexico'
0.0001  SELECT page_country FROM pages where page_country != '' group by page_country order by page_country
0.0001  SELECT countryID from newest_packages_interests where packagetype like '%special%'
0.0001  SELECT * FROM country WHERE country_continent = 'south' order by country_name
0.0001  SELECT countryID from newest_packages_interests where packagetype like '%special%'
0.0001  SELECT * FROM country WHERE country_continent = 'central' order by country_name
0.0001  SELECT page_type FROM pages WHERE page_country = 'mexico' and page_type != 'reservation' group by page_type order by page_type
0.0001  SELECT `country_continent` FROM (`country`) WHERE `country_linkname` = 'mexico'
0.0001  SELECT * FROM new_package_destinations npd join country c on c.country_id = npd.countryID where country_linkname = 'mexico'
0.0001  SELECT * FROM new_package_interests npd join country c on c.country_id = npd.countryID where country_linkname = 'mexico'
0.0001  SELECT `country_name` FROM (`country`) WHERE `country_linkname` = 'mexico'
0.0001  SELECT `country_name` FROM (`country`) WHERE `country_linkname` = 'mexico'
0.0001  SELECT * from newest_packages_interests where countryID = '' and packagetype like '%special%'
0.0006  Select * from hotels h join country c on c.country_id = h.CountryID where country_linkname = 'mexico'
0.0001  SELECT `country_id` FROM (`country`) WHERE `country_linkname` = 'mexico'
0.0002  SELECT * FROM (`unesco`) WHERE `site_country_id` = '126'
0.0409  SELECT * FROM common_be.rooms r where HotelID = '4010566'