Posada Puerto Bemberg Iguazu

Globe Secret has been created from professional travelers, hospitality and e-business. Globe Secret team guarantee our users a high selection of boutique hotels. Travel agent register nÂ° IM075100403 - Financial guarantee : BPRP - Member of APST - RCP : Hiscox nÂ° HA PRC0055186 - CNIL 1517931. SSL, AmericanExpress, MasterCard, Visa, VisaElectron

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent96a2135195cee4dc19bc11b4bba8d8cd
  time1620284613
  timeout10
  languageeng
====
Request
+ –
Request

Cake Params
- controllerhotels
- actionview
- languageen
- named(empty)
- pass
 0697
 1posada-puerto-bemberg-iguazu
- plugin(null)
- url
 exthtml
 urlen/hotels/view/697/posada-puerto-bemberg-iguazu
- form(empty)
- isAjax(false)
$_GET
- urlen/hotels/view/697/posada-puerto-bemberg-iguazu
Cookie
- languageen
Current Route
- keys
 0language
 1controller
 2action
- options
 languageen|fr
- defaults
 plugin(null)
 actionindex
- template/:language/:controller/:action/*
- _greedy(true)
- _compiledRoute#^(?:/(en|fr))/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
 typecontent_type
 methodrequest_method
 serverserver_name
====

Sql Log

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `hotels`	34	34	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	0
SHOW FULL COLUMNS FROM `cities`	6	6	0
SHOW FULL COLUMNS FROM `states`	3	3	0
SHOW FULL COLUMNS FROM `countries`	3	3	0
SHOW FULL COLUMNS FROM `weather_forecasts`	15	15	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	0
SHOW FULL COLUMNS FROM `news`	4	4	0
SHOW FULL COLUMNS FROM `i18n`	6	6	0
SHOW FULL COLUMNS FROM `home_hotels`	4	4	0
SHOW FULL COLUMNS FROM `hotel_images`	6	6	0
SHOW FULL COLUMNS FROM `rooms`	15	15	0
SHOW FULL COLUMNS FROM `rooms_rates`	8	8	0
SHOW FULL COLUMNS FROM `rates_periods`	6	6	0
SHOW FULL COLUMNS FROM `rates_period_i18n`	6	6	0
SHOW FULL COLUMNS FROM `unavailabilities`	4	4	0
SHOW FULL COLUMNS FROM `envies`	3	3	0
SHOW FULL COLUMNS FROM `envie_i18n`	6	6	0
SHOW FULL COLUMNS FROM `envies_hotels`	2	2	0
SHOW FULL COLUMNS FROM `comments`	19	19	0
SHOW FULL COLUMNS FROM `users`	16	16	0
SHOW FULL COLUMNS FROM `addresses`	12	12	0
SHOW FULL COLUMNS FROM `janrain_profiles`	9	9	0
SHOW FULL COLUMNS FROM `admins`	15	15	0
SHOW FULL COLUMNS FROM `favorites`	8	8	0
SHOW FULL COLUMNS FROM `hotel_i18n`	6	6	0
SHOW FULL COLUMNS FROM `configs`	3	3	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';	1	1	0
SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'eng') WHERE 1 = 1	1	1	0
SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1)	2	2	0
SELECT `Hotel`., `City`., `Country`., `State`., `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'eng') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) WHERE `Hotel`.`id` = 697 LIMIT 1	1	1	1
SELECT `City`.`id`, `City`.`country_id`, `City`.`state_id`, `City`.`maintrack_id`, `City`.`name`, `City`.`main_key` FROM `cities` AS `City` WHERE `City`.`id` = 668	1	1	0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'AR'	1	1	0
SELECT `HotelImage`.`id`, `HotelImage`.`hotel_id`, `HotelImage`.`order`, `HotelImage`.`uri`, `HotelImage`.`ratio_hw`, `HotelImage`.`on_wall` FROM `hotel_images` AS `HotelImage` WHERE `HotelImage`.`hotel_id` = (697)	6	6	0
SELECT `Room`.`id`, `Room`.`type`, `Room`.`hotel_id`, `Room`.`name`, `Room`.`description`, `Room`.`name_fre`, `Room`.`description_fre`, `Room`.`lowest_rate`, `Room`.`lr_currency`, `Room`.`lr_people`, `Room`.`breakfast_included`, `Room`.`half_board`, `Room`.`all_inclusive`, `Room`.`full_board`, `Room`.`accomodation_only` FROM `rooms` AS `Room` WHERE `Room`.`hotel_id` = (697)	3	3	1	maybe slow
SELECT `RoomsRate`.`id`, `RoomsRate`.`rates_period_id`, `RoomsRate`.`room_id`, `RoomsRate`.`rate_regular`, `RoomsRate`.`rate_special`, `RoomsRate`.`rate_currency`, `RoomsRate`.`created`, `RoomsRate`.`modified` FROM `rooms_rates` AS `RoomsRate` WHERE `RoomsRate`.`room_id` IN (2851, 2852, 2853)	0	0	0
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`to` >= NOW() AND `RatesPeriod`.`hotel_id` = (697) ORDER BY `RatesPeriod`.`from` ASC LIMIT 5	0	0	0
SELECT `News`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content` FROM `news` AS `News` INNER JOIN `i18n` AS `I18n__name` ON (`News`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'News' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__description` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'News' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__link` ON (`News`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'News' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') WHERE `News`.`country_id` = 'AR' ORDER BY `News`.`created` DESC	0	0	1	maybe slow
SELECT `Hotel`., `HomeHotel`., `City`., `Country`., `State`.*, `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'eng') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) LEFT JOIN `home_hotels` AS `HomeHotel` ON (`HomeHotel`.`hotel_id` = `Hotel`.`id`) WHERE `Hotel`.`published` = 1 AND `Hotel`.`id` != 697 AND `Hotel`.`longitude` BETWEEN -55.601858697925 AND -53.599343302075 AND `Hotel`.`latitude` BETWEEN -26.82033795942 AND -25.01926204058 ORDER BY ABS(`Hotel`.`longitude` - -54.600601) + ABS(`Hotel`.`latitude` - -25.9198) ASC LIMIT 3	2	2	7	maybe slow
SELECT `HotelImage`.`id`, `HotelImage`.`hotel_id`, `HotelImage`.`order`, `HotelImage`.`uri`, `HotelImage`.`ratio_hw`, `HotelImage`.`on_wall` FROM `hotel_images` AS `HotelImage` WHERE `HotelImage`.`hotel_id` IN (764, 1419)	18	18	0
SELECT `Room`.`id`, `Room`.`type`, `Room`.`hotel_id`, `Room`.`name`, `Room`.`description`, `Room`.`name_fre`, `Room`.`description_fre`, `Room`.`lowest_rate`, `Room`.`lr_currency`, `Room`.`lr_people`, `Room`.`breakfast_included`, `Room`.`half_board`, `Room`.`all_inclusive`, `Room`.`full_board`, `Room`.`accomodation_only` FROM `rooms` AS `Room` WHERE `Room`.`hotel_id` IN (764, 1419)	4	4	1	maybe slow
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (764, 1419)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (764, 1419)	0	0	0
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (764, 1419)	0	0	0
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`foreign_key`, `Favorite`.`model`, `Favorite`.`type`, `Favorite`.`position`, `Favorite`.`created`, `Favorite`.`modified` FROM `favorites` AS `Favorite` WHERE `Favorite`.`model` = 'Hotel' AND `Favorite`.`foreign_key` IN (764, 1419)	0	0	0
SELECT `Taglines`.`id`, `Taglines`.`locale`, `Taglines`.`model`, `Taglines`.`foreign_key`, `Taglines`.`field`, `Taglines`.`content` FROM `hotel_i18n` AS `Taglines` WHERE `model` = 'Hotel' AND `field` = 'tagline' AND `Taglines`.`foreign_key` IN (764, 1419)	4	4	0
SELECT `Envie`.`id`, `Envie`.`created`, `Envie`.`modified`, `EnviesHotel`.`envie_id`, `EnviesHotel`.`hotel_id` FROM `envies` AS `Envie` JOIN `envies_hotels` AS `EnviesHotel` ON (`EnviesHotel`.`hotel_id` IN (764, 1419) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `events`	18	18	0
SHOW FULL COLUMNS FROM `home_events`	4	4	0
SHOW FULL COLUMNS FROM `event_images`	5	5	0
SHOW FULL COLUMNS FROM `themes`	4	4	0
SHOW FULL COLUMNS FROM `theme_i18n`	6	6	0
SHOW FULL COLUMNS FROM `events_hotels`	2	2	0
SHOW FULL COLUMNS FROM `events_themes`	2	2	0
SHOW FULL COLUMNS FROM `event_i18n`	6	6	0
SELECT `Event`., `HomeEvent`., `CreatedUser`., `Country`., `State`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18n__name` ON (`Event`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Event' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__description` ON (`Event`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Event' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__link` ON (`Event`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Event' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE ((`Event`.`end` IS NULL) OR (`Event`.`end` >= NOW())) AND `Event`.`longitude` BETWEEN -55.601858697925 AND -53.599343302075 AND `Event`.`latitude` BETWEEN -26.82033795942 AND -25.01926204058 ORDER BY ABS(`Event`.`longitude` - -54.600601) + ABS(`Event`.`latitude` - -25.9198) ASC LIMIT 10	3	3	10	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (1656, 755, 1314)	0	0	0
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (1656, 755, 1314)	0	0	0
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`foreign_key`, `Favorite`.`model`, `Favorite`.`type`, `Favorite`.`position`, `Favorite`.`created`, `Favorite`.`modified` FROM `favorites` AS `Favorite` WHERE `Favorite`.`model` = 'Event' AND `Favorite`.`foreign_key` IN (1656, 755, 1314)	0	0	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `event_i18n` AS `Names` WHERE `model` = 'Event' AND `field` = 'name' AND `Names`.`foreign_key` IN (1656, 755, 1314)	6	6	0
SELECT `Descriptions`.`id`, `Descriptions`.`locale`, `Descriptions`.`model`, `Descriptions`.`foreign_key`, `Descriptions`.`field`, `Descriptions`.`content` FROM `event_i18n` AS `Descriptions` WHERE `model` = 'Event' AND `field` = 'description' AND `Descriptions`.`foreign_key` IN (1656, 755, 1314)	6	6	0
SELECT `Links`.`id`, `Links`.`locale`, `Links`.`model`, `Links`.`foreign_key`, `Links`.`field`, `Links`.`content` FROM `event_i18n` AS `Links` WHERE `model` = 'Event' AND `field` = 'link' AND `Links`.`foreign_key` IN (1656, 755, 1314)	6	6	0
SELECT `Hotel`.`id`, `Hotel`.`starred`, `Hotel`.`in`, `Hotel`.`maintrack_hotel_id`, `Hotel`.`brand_code`, `Hotel`.`name`, `Hotel`.`address`, `Hotel`.`zip_code`, `Hotel`.`cityarea_id`, `Hotel`.`city_id`, `Hotel`.`region_id`, `Hotel`.`state_id`, `Hotel`.`country_id`, `Hotel`.`latitude`, `Hotel`.`longitude`, `Hotel`.`zoom`, `Hotel`.`rating`, `Hotel`.`phone`, `Hotel`.`reservation_phone`, `Hotel`.`fax`, `Hotel`.`email`, `Hotel`.`created`, `Hotel`.`modified`, `Hotel`.`description`, `Hotel`.`description_fre`, `Hotel`.`amenity`, `Hotel`.`amenity_fre`, `Hotel`.`lowest_rate`, `Hotel`.`lr_currency`, `Hotel`.`lr_people`, `Hotel`.`comment_count`, `Hotel`.`cancellation_policy`, `Hotel`.`cancellation_policy_fre`, `Hotel`.`published`, `EventsHotel`.`event_id`, `EventsHotel`.`hotel_id` FROM `hotels` AS `Hotel` JOIN `events_hotels` AS `EventsHotel` ON (`EventsHotel`.`event_id` IN (1656, 755, 1314) AND `EventsHotel`.`hotel_id` = `Hotel`.`id`)	0	0	0
SELECT `Theme`.`id`, `Theme`.`created`, `Theme`.`modified`, `Theme`.`uri`, `EventsTheme`.`event_id`, `EventsTheme`.`theme_id` FROM `themes` AS `Theme` JOIN `events_themes` AS `EventsTheme` ON (`EventsTheme`.`event_id` IN (1656, 755, 1314) AND `EventsTheme`.`theme_id` = `Theme`.`id`)	0	0	0
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC	256	256	0
SELECT `Theme`.*, `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18n__name` ON (`Theme`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Theme' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	10	10	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `theme_i18n` AS `Names` WHERE `model` = 'Theme' AND `field` = 'name' AND `Names`.`foreign_key` IN (6, 10, 7, 12, 11, 13, 5, 8, 4, 9)	20	20	0
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1	10	10	0
SELECT `Envie`.*, `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18n__name` ON (`Envie`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Envie' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	29	29	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `envie_i18n` AS `Names` WHERE `model` = 'Envie' AND `field` = 'name' AND `Names`.`foreign_key` IN (19, 5, 6, 24, 8, 25, 4, 10, 12, 7, 9, 22, 30, 14, 26, 21, 3, 1, 13, 27, 18, 11, 28, 29, 16, 15, 23, 2, 17)	58	58	0
SELECT `Hotel`.`id`, `Country`.*, `Country`.`id` FROM `hotels` AS `Hotel` LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) WHERE 1 = 1 GROUP BY `Hotel`.`country_id` ORDER BY `Country`.`name` ASC	120	120	0
SHOW FULL COLUMNS FROM `promises`	3	3	0
SELECT `Promise`.*, `I18n__title`.`content`, `I18n__content`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18n__title` ON (`Promise`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Promise' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__content` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Promise' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') WHERE 1 = 1 LIMIT 4	4	4	0
SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Promise' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT `Contents`.`id`, `Contents`.`locale`, `Contents`.`model`, `Contents`.`foreign_key`, `Contents`.`field`, `Contents`.`content` FROM `i18n` AS `Contents` WHERE `model` = 'Promise' AND `field` = 'content' AND `Contents`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 697 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham')	1	1	0
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified`, `Hotel`.`id`, `UserModel`.`id`, `UserModel`.`first_name`, (CONCAT(`UserModel`.`first_name`, ' ', `UserModel`.`name`)) AS `UserModel__full_name`, (`UserModel`.`id`) AS `UserModel__slug` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 697 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5	0	0	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

+ –

Memory

Peak Memory Use 25.24 MB

Message	Memory use
Component initialization	14.31 MB
Controller action start	14.48 MB
Controller render start	16.05 MB
View render complete	19.89 MB

Timers

Total Request Time: 496 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	74.98
Component initialization and startup	3.80
Controller action	212.86
Render Controller Action	96.88
» Rendering View	93.49
» » Rendering APP/views/hotels/view.ctp	39.40
» » » Rendering APP/views/elements/sharing_widget.ctp	0.26
» » » Rendering APP/views/elements/comments/flat/main.ctp	0.40
» » » Rendering APP/views/elements/hotels/form_reservation.ctp	3.43
» » » Rendering APP/views/elements/events/related.ctp	1.53
» » » Rendering APP/views/elements/events/related.ctp #2	1.46
» » » Rendering APP/views/elements/events/related.ctp #3	1.46
» » » Rendering APP/views/elements/events/legend.ctp	3.49
» » » Rendering APP/views/elements/hotels/related.ctp #4	0.62
» » » Rendering APP/views/elements/hotels/related.ctp #5	0.57
» » Rendering APP/views/layouts/default.ctp	53.88
» » » Rendering APP/views/elements/google_analytics.ctp	0.08
» » » Rendering APP/views/elements/layout/top.ctp	1.38
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0.31
» » » Rendering APP/views/elements/layout/header.ctp	47.11
» » » Rendering APP/views/elements/layout/extra.ctp	0.12
» » » Rendering APP/views/elements/layout/footer.ctp	4.12
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0.30
» » » Rendering APP/views/elements/layout/footnotes.ctp	0.08

====

Log

+ –

Logs

warning

Time	Message
2021-05-05 23:03:33	Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: StartTag: invalid element name in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92]
2021-05-05 23:03:33	Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: Extra content at the end of the document in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92]

error

Time	Message
2021-05-05 23:03:33	Impossible to access the Google API
2021-05-05 23:03:33	Impossible to access the Google API

====

Variables
+ –
View Variables
- promises_for_layout
 0
 Promise
 id1
 title A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 content
 localeeng
 Titles
 0
 id10143
 localeeng
 modelPromise
 foreign_key1
 fieldtitle
 content A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 1
 id10144
 localefre
 modelPromise
 foreign_key1
 fieldtitle
 content Des hôtels de charme a taille humaine
 Contents
 0
 id10145
 localeeng
 modelPromise
 foreign_key1
 fieldcontent
 content
 1
 id10146
 localefre
 modelPromise
 foreign_key1
 fieldcontent
 content Globe Secret se distingue par l’originalité de sa sélection d’hôtels de charme. Ces quelques 1200 adresses autour du monde ont pour trait commun l’intimité (maximum 30 chambres) et un cadre préservé. Inclassables, ces adresses sont ancrées dans la culture de leur pays, revendiquant une authenticité et un accueil personnalisé. Avec Globe Secret, vous n’êtes pas prêts d’oublier vos vacances…             <meta charset="utf-8" /> 
 1
 Promise
 id2
 title BOOKING AT NO ADDITIONAL COST
 content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 localeeng
 Titles
 0
 id10147
 localeeng
 modelPromise
 foreign_key2
 fieldtitle
 content BOOKING AT NO ADDITIONAL COST
 1
 id10148
 localefre
 modelPromise
 foreign_key2
 fieldtitle
 content RESERVATION SANS FRAIS
 Contents
 0
 id10149
 localeeng
 modelPromise
 foreign_key2
 fieldcontent
 content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 1
 id10150
 localefre
 modelPromise
 foreign_key2
 fieldcontent
 content Globe Secret garantie une transparence de prix et de réservation. En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.
 2
 Promise
 id3
 title UNIQUE SELECTION CRITERIA
 content
 localeeng
 Titles
 0
 id10151
 localeeng
 modelPromise
 foreign_key3
 fieldtitle
 content UNIQUE SELECTION CRITERIA
 1
 id10152
 localefre
 modelPromise
 foreign_key3
 fieldtitle
 content DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 Contents
 0
 id10153
 localeeng
 modelPromise
 foreign_key3
 fieldcontent
 content
 1
 id10154
 localefre
 modelPromise
 foreign_key3
 fieldcontent
 content   Globe Secret vous propose de nombreux critères d’entrée et originaux pour choisir l’hôtel ou l’expérience qui correspond à vos envies. Ex: la zone géographique mais aussi le climat, la galerie. Nous avons classé les hôtels par thèmes, vous permettant de faire une recherche d'hotel ou une expérience en fonction de vos goûts ou d'une envie particulière ex: équitation, culture, festival, pêche,..
 3
 Promise
 id4
 title MORE TAILORED SERVICES
 content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 localeeng
 Titles
 0
 id10155
 localeeng
 modelPromise
 foreign_key4
 fieldtitle
 content MORE TAILORED SERVICES
 1
 id10156
 localefre
 modelPromise
 foreign_key4
 fieldtitle
 content PLUS DE SERVICES A LA CARTE
 Contents
 0
 id10157
 localeeng
 modelPromise
 foreign_key4
 fieldcontent
 content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 1
 id10158
 localefre
 modelPromise
 foreign_key4
 fieldcontent
 content   <meta charset="utf-8" /> <div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; "> Globe Secret vous propose aussi ses services pour la réservation de vos billets d’avion. Accédez ainsi à des tarifs négociés sur + de 500 compagnies aériennes vers plus de 1000 destinations. Toujours selon le même principe, ce service est sans frais supplémentaires. Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste, nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. Faites-nous part de vos projets !</div>
- destinations_for_layout
 AFAfghanistan
 AXAland Islands
 ALAlbania
 DZAlgeria
 ASAmerican Samoa
 ADAndorra
 AOAngola
 AIAnguilla
 AQAntarctica
 AGAntigua/Barbuda
 ARArgentina
 AMArmenia
 AWAruba
 AUAustralia
 ATAustria
 AZAzerbaijan
 BSBahamas
 BHBahrain
 BDBangladesh
 BBBarbados
 BYBelarus
 BEBelgium
 BZBelize
 BJBenin
 BMBermuda
 BTBhutan
 BOBolivia
 BABosnia
 BWBotswana
 BVBouvet Island
 BRBrazil
 IOBritish Indian Ocean Territory
 WIBritish West Indies
 BNBrunei Darussalam
 BGBulgaria
 BFBurkina Faso
 BIBurundi
 KHCambodia
 CMCameroon
 CACanada
 CVCape Verde
 KYCayman Islands
 CFCentral Africa
 TDChad
 CLChile
 CNChina
 CXChristmas Island
 CCCocos (Keeling) Islands
 COColombia
 KMComoros
 CGCongo
 CDCongo
 CKCook Islands
 CRCosta Rica
 CICote D'Ivoire
 HRCroatia
 CUCuba
 CYCyprus
 CZCzech Republic
 DKDenmark
 DJDjibouti
 DMDominica
 DODominican Republic
 TPEast Timor
 ECEcuador
 EGEgypt
 SVEl Salvador
 GQEquatorial Guinea
 EREritrea
 EEEstonia
 ETEthiopia
 FOFaeroe Islands
 FKFalkland Islands
 FJFiji
 FIFinland
 FRFrance
 PFFrench Polynesia
 TFFrench Southern Territories
 GAGabon
 GMGambia
 XAGaza
 GEGeorgia
 DEGermany
 GHGhana
 GIGibraltar
 GRGreece
 GLGreenland
 GDGrenada
 GPGuadeloupe
 GUGuam
 GTGuatemala
 GGGuernsey
 GFGuiana
 GNGuinea
 GWGuinea-Bissau
 GYGuyana
 HTHaiti
 HMHeard And Mcdonald Islands
 XHHeld Territories
 HNHonduras
 HKHong Kong
 HUHungary
 ISIceland
 INIndia
 XIIndian Ocean Islands
 IDIndonesia
 IRIran
 IQIraq
 IEIreland
 IMIsle of Man
 ILIsrael
 ITItaly
 JMJamaica
 JPJapan
 JEJersey
 JOJordan
 KZKazakhstan
 KEKenya
 KIKiribati
 KRKorea
 KWKuwait
 KGKyrgyzstan
 LALaos
 LVLatvia
 LBLebanon
 LSLesotho
 LRLiberia
 LYLibya
 LILiechtenstein
 LTLithuania
 LULuxembourg
 MOMacau
 MKMacedonia
 MGMadagascar
 MWMalawi
 MYMalaysia
 MVMaldives
 MLMali
 MTMalta
 MHMarshall Islands
 MQMartinique
 MRMauritania
 MUMauritius
 YTMayotte
 MXMexico
 FMMicronesia
 MDMoldova
 MCMonaco
 MNMongolia
 MEMontenegro
 MSMontserrat
 MAMorocco
 MZMozambique
 MMMyanmar
 NANamibia
 NRNauru
 NPNepal
 NLNetherlands
 ANNetherlands Antilles
 NCNew Caledonia
 NZNew Zealand
 NINicaragua
 NENiger
 NGNigeria
 NUNiue
 NFNorfolk Island
 XBNorthern Ireland
 MPNorthern Mariana Islands
 NONorway
 OMOman
 PKPakistan
 PWPalau
 PSPalestinian Territory
 PAPanama
 PGPapua New Guinea
 PYParaguay
 PEPeru
 PHPhilippines
 PNPitcairn
 PLPoland
 PTPortugal
 PRPuerto Rico
 QAQatar
 REReunion
 RORomania
 RURussia
 RWRwanda
 LCSaint Lucia
 BLSaint-Barthelemy
 MFSaint-Martin
 SMSan Marino
 STSao Tome And Principe
 SASaudi Arabia
 WYScotland
 SNSenegal
 RSSerbia
 YUSerbia and Montenegro
 CSSerbia and Montenegro
 SCSeychelles
 SLSierra Leone
 SGSingapore
 SKSlovak Republic
 SISlovenia
 SBSolomon Islands
 SOSomalia
 ZASouth Africa
 GSSouth Georgia
 ESSpain
 LKSri Lanka
 SHSt. Helena
 KNSt. Kitts & Nevis
 PMSt. Pierre
 VCSt. Vincent & The Grenadines
 SDSudan
 SRSuriname
 SJSvalbard And Jan Mayen Islands
 SZSwaziland
 SESweden
 CHSwitzerland
 SYSyria
 TWTaiwan
 TJTajikistan
 TZTanzania
 THThailand
 TLTimor-Leste
 TGTogo
 TKTokelau
 TOTonga
 TTTrinidad And Tobago
 TNTunisia
 TRTurkey
 TMTurkmenistan
 TCTurks And Caicos Islands
 TVTuvalu
 UMU.S. Minor Outlying Islands
 UGUganda
 UAUkraine
 AEUnited Arab Emirates
 GBUnited Kingdom
 USUnited States
 UYUruguay
 UZUzbekistan
 VUVanuatu
 VAVatican City State
 VEVenezuela
 VNVietnam
 VGVirgin Islands (British)
 VIVirgin Islands (U.S.)
 WXWales
 WFWallis And Futuna Islands
 EHWestern Sahara
 WSWestern Samoa
 YEYemen
 ZRZaire
 ZMZambia
 ZWZimbabwe
- themes_for_layout
 6Art & Culture
 10Famille & Enfant
 7Festival & Tradition
 12Gastronomie
 11Insolite & Curieux
 13Marché & Shopping
 5Musique
 8Nature
 4Parc & Jardin
 9Sport
- themes_images_for_layout
 6art0.png
 4parc1.png
 5musique0.png
 7festival0.png
 8nature0.png
 9sport0.png
 10famille0.png
 11insolite0.png
 12gastronomie0.png
 13shopping0.png
- envies_for_layout
 19BABY SITTING
 5BEACH
 6BICYCLE RENTAL
 24CIGAR LOUNGE
 8CITY
 25COUNTRYSIDE
 4DESERT
 10DIVING
 12ECOLOGY
 7FISHING
 9GOLF
 22HANDICAP ACCESS
 30HELIPORT
 14HORSEBACK RIDING
 26HUNTING
 21INTERNET ACCESS
 3ISLAND
 1JUNGLE
 13LAKE
 27POLO
 18POOL
 11SAFARI
 28SAILING
 29SHOPPING
 16SKIING
 15SPA
 23TENNIS
 2TREKKING
 17WINERY
- countries_for_layout
 0
 Country
 idAL
 nameAlbania
 name_freAlbanie
 1
 Country
 idAD
 nameAndorra
 name_freAndorre
 2
 Country
 idAI
 nameAnguilla
 name_freAnguilla
 3
 Country
 idAG
 nameAntigua/Barbuda
 name_freAntigua-Et-Barbuda
 4
 Country
 idAR
 nameArgentina
 name_freArgentine
 5
 Country
 idAM
 nameArmenia
 name_freArménie
 6
 Country
 idAU
 nameAustralia
 name_freAustralie
 7
 Country
 idAT
 nameAustria
 name_freAutriche
 8
 Country
 idAZ
 nameAzerbaijan
 name_freAzerbaïdjan
 9
 Country
 idBS
 nameBahamas
 name_freBahamas
 10
 Country
 idBB
 nameBarbados
 name_freBarbade
 11
 Country
 idBE
 nameBelgium
 name_freBelgique
 12
 Country
 idBZ
 nameBelize
 name_freBelize
 13
 Country
 idBM
 nameBermuda
 name_freBermudes
 14
 Country
 idBT
 nameBhutan
 name_freBhoutan
 15
 Country
 idBO
 nameBolivia
 name_freBolivie
 16
 Country
 idBA
 nameBosnia
 name_freBosnie-Herzégovine
 17
 Country
 idBR
 nameBrazil
 name_freBrésil
 18
 Country
 idKH
 nameCambodia
 name_freCambodge
 19
 Country
 idCA
 nameCanada
 name_freCanada
 20
 Country
 idCL
 nameChile
 name_freChili
 21
 Country
 idCN
 nameChina
 name_freChine
 22
 Country
 idCO
 nameColombia
 name_freColombie
 23
 Country
 idCK
 nameCook Islands
 name_freÎles Cook
 24
 Country
 idCR
 nameCosta Rica
 name_freCosta Rica
 25
 Country
 idHR
 nameCroatia
 name_freCroatie
 26
 Country
 idCZ
 nameCzech Republic
 name_freRépublique Tchèque
 27
 Country
 idDK
 nameDenmark
 name_freDanemark
 28
 Country
 idDM
 nameDominica
 name_freDominique
 29
 Country
 idDO
 nameDominican Republic
 name_freRépublique Dominicaine
 30
 Country
 idEC
 nameEcuador
 name_freÉquateur
 31
 Country
 idEG
 nameEgypt
 name_freÉgypte
 32
 Country
 idEE
 nameEstonia
 name_freEstonie
 33
 Country
 idFJ
 nameFiji
 name_freFidji
 34
 Country
 idFI
 nameFinland
 name_freFinlande
 35
 Country
 idFR
 nameFrance
 name_freFrance
 36
 Country
 idPF
 nameFrench Polynesia
 name_frePolynésie Française
 37
 Country
 idDE
 nameGermany
 name_freAllemagne
 38
 Country
 idGR
 nameGreece
 name_freGrèce
 39
 Country
 idGD
 nameGrenada
 name_freGrenade
 40
 Country
 idGP
 nameGuadeloupe
 name_freGuadeloupe
 41
 Country
 idGT
 nameGuatemala
 name_freGuatemala
 42
 Country
 idHN
 nameHonduras
 name_freHonduras
 43
 Country
 idHK
 nameHong Kong
 name_freHong-Kong
 44
 Country
 idHU
 nameHungary
 name_freHongrie
 45
 Country
 idIS
 nameIceland
 name_freIslande
 46
 Country
 idIN
 nameIndia
 name_freInde
 47
 Country
 idID
 nameIndonesia
 name_freIndonésie
 48
 Country
 idIE
 nameIreland
 name_freIrlande
 49
 Country
 idIL
 nameIsrael
 name_freIsraël
 50
 Country
 idIT
 nameItaly
 name_freItalie
 51
 Country
 idJM
 nameJamaica
 name_freJamaïque
 52
 Country
 idJP
 nameJapan
 name_freJapon
 53
 Country
 idJO
 nameJordan
 name_freJordanie
 54
 Country
 idKE
 nameKenya
 name_freKenya
 55
 Country
 idLA
 nameLaos
 name_freLaos
 56
 Country
 idLV
 nameLatvia
 name_freLettonie
 57
 Country
 idLB
 nameLebanon
 name_freLiban
 58
 Country
 idLT
 nameLithuania
 name_freLituanie
 59
 Country
 idMO
 nameMacau
 name_freMacao
 60
 Country
 idMG
 nameMadagascar
 name_freMadagascar
 61
 Country
 idMY
 nameMalaysia
 name_freMalaisie
 62
 Country
 idMV
 nameMaldives
 name_freMaldives
 63
 Country
 idMU
 nameMauritius
 name_freMaurice
 64
 Country
 idMX
 nameMexico
 name_freMexique
 65
 Country
 idMN
 nameMongolia
 name_freMongolie
 66
 Country
 idME
 nameMontenegro
 name_freMonténégro
 67
 Country
 idMA
 nameMorocco
 name_freMaroc
 68
 Country
 idMZ
 nameMozambique
 name_freMozambique
 69
 Country
 idMM
 nameMyanmar
 name_freMyanmar
 70
 Country
 idNA
 nameNamibia
 name_freNamibie
 71
 Country
 idNL
 nameNetherlands
 name_frePays-Bas
 72
 Country
 idAN
 nameNetherlands Antilles
 name_freAntilles Néerlandaises
 73
 Country
 idNZ
 nameNew Zealand
 name_freNouvelle-Zélande
 74
 Country
 idNI
 nameNicaragua
 name_freNicaragua
 75
 Country
 idNO
 nameNorway
 name_freNorvège
 76
 Country
 idOM
 nameOman
 name_freOman
 77
 Country
 idPK
 namePakistan
 name_frePakistan
 78
 Country
 idPA
 namePanama
 name_frePanama
 79
 Country
 idPE
 namePeru
 name_frePérou
 80
 Country
 idPH
 namePhilippines
 name_frePhilippines
 81
 Country
 idPL
 namePoland
 name_frePologne
 82
 Country
 idPT
 namePortugal
 name_frePortugal
 83
 Country
 idPR
 namePuerto Rico
 name_frePorto Rico
 84
 Country
 idRE
 nameReunion
 name_freRéunion
 85
 Country
 idRO
 nameRomania
 name_freRoumanie
 86
 Country
 idRU
 nameRussia
 name_freRussie
 87
 Country
 idLC
 nameSaint Lucia
 name_freSainte-Lucie
 88
 Country
 idBL
 nameSaint-Barthelemy
 name_freSaint-Barthélemy
 89
 Country
 idSA
 nameSaudi Arabia
 name_freArabie Saoudite
 90
 Country
 idRS
 nameSerbia
 name_freSerbie
 91
 Country
 idSC
 nameSeychelles
 name_freSeychelles
 92
 Country
 idSG
 nameSingapore
 name_freSingapour
 93
 Country
 idSK
 nameSlovak Republic
 name_freSlovaquie
 94
 Country
 idSI
 nameSlovenia
 name_freSlovénie
 95
 Country
 idZA
 nameSouth Africa
 name_freAfrique Du Sud
 96
 Country
 idES
 nameSpain
 name_freEspagne
 97
 Country
 idLK
 nameSri Lanka
 name_freSri Lanka
 98
 Country
 idKN
 nameSt. Kitts & Nevis
 name_freSaint-Kitts-Et-Nevis
 99
 Country
 idVC
 nameSt. Vincent & The Grenadines
 name_freSaint-Vincent-Et-Les Grenadines
 100
 Country
 idSJ
 nameSvalbard And Jan Mayen Islands
 name_freSvalbard Et Île Jan Mayen
 101
 Country
 idSE
 nameSweden
 name_freSuède
 102
 Country
 idCH
 nameSwitzerland
 name_freSuisse
 103
 Country
 idTW
 nameTaiwan
 name_freTaïwan
 104
 Country
 idTZ
 nameTanzania
 name_freTanzanie
 105
 Country
 idTH
 nameThailand
 name_freThaïlande
 106
 Country
 idTN
 nameTunisia
 name_freTunisie
 107
 Country
 idTR
 nameTurkey
 name_freTurquie
 108
 Country
 idTC
 nameTurks And Caicos Islands
 name_freÎles Turks et Caïques
 109
 Country
 idUG
 nameUganda
 name_freOuganda
 110
 Country
 idUA
 nameUkraine
 name_freUkraine
 111
 Country
 idAE
 nameUnited Arab Emirates
 name_freÉmirats Arabes Unis
 112
 Country
 idGB
 nameUnited Kingdom
 name_freRoyaume-Uni
 113
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 114
 Country
 idUY
 nameUruguay
 name_freUruguay
 115
 Country
 idVU
 nameVanuatu
 name_freVanuatu
 116
 Country
 idVN
 nameVietnam
 name_freViet Nam
 117
 Country
 idVG
 nameVirgin Islands (British)
 name_freÎles Vierges Britanniques
 118
 Country
 idVI
 nameVirgin Islands (U.S.)
 name_freÎles Vierges Des États-Unis
 119
 Country
 idZW
 nameZimbabwe
 name_freZimbabwe
- staticSlugs
 0who-we-are
 1sitemap
 2terms-and-conditions
 3news
 4jobs
 5legal
 6credits
- userFavorites
 fav-event(empty)
 fav-hotel(empty)
- hotel
 Hotel
 id697
 starred0
 in0
 maintrack_hotel_id356734
 brand_codeYX
 namePosada Puerto Bemberg Iguazu
 addressFundadores Bemberg
 zip_code00000
 cityarea_id(null)
 city_id668
 region_id(null)
 state_id(null)
 country_idAR
 latitude-25.9198
 longitude-54.600601
 zoom12
 rating0
 phone54 11 40050050
 reservation_phone(null)
 fax54 11 47494655
 email(null)
 created2011-07-25 18:58:11
 modified2011-07-27 11:37:36
 descriptionAt Puerto Bemberg one breathes and enjoys the forest. In the heart of a subtropical ecosystem, time flows amidst trails, bird sounds, dikes falls, woodlands, natural vantage points, native legend and the murmur of the Parana River. Combining a turn-of-century style with amenities and facilities that will please the most demanding traveler, this history-filled in of colonial tiles, wide spaces and native furniture is the hub of singular and intimate experiences with nature. Fourteen spacious and luminous rooms, an exclusive restaurant offering local cuisine with gourmet influences, a natural pool, La Cave and its variety of delicious wines and the outdoor terrace overlooking the Parana River are some of the highlights of relaxing in this paradise. Only thirty minutes away from the entrance to the Iguazu National Park it is a different alternative for those wishing to visit one of the world wonders.
 description_freÀ la Posada Puerto Bemberg, on respire et on jouit de la forêt. Au coeur d'un écosystème subtropical, le temps s'écoule au milieu des sentiers, des chants d'oiseaux, des chutes, des bois, points de vue naturel, la légende indigène et le murmure de la rivière Parana. Alliant un style de siècle passé, avec des équipements et des installations qui conviendront aux voyageurs les plus exigeants, cette histoire remplie de surprises, de grands espaces est la plaque tournante d'expériences singulières et intime avec la nature. Quatorze chambres spacieuses et lumineuses, une cuisine exclusive offrant des influences gastronomiques locales, une piscine naturelle, La Cave et sa variété de vins délicieux et la terrasse extérieure donnant sur le fleuve Parana sont quelques-uns des faits saillants de détente dans ce petit paradis. A seulement trente minutes de l'entrée du Parc national d'Iguazu, il représente une alternative différente pour ceux qui souhaitent visiter l'une des merveilles du monde.
 amenityFamily Plan, Babysitting/Child Services, Jogging Track, Massage, Breakfast Buffet, Room Service, Express Check In, Wake-up Service, Air Conditioned, Hairdryers Available, Car Rental Desk, Concierge Desk, 24 Hour Front Desk, Outdoor Pool, Pool, Restaurant, Doctor on Call, Maid Service, Turndown Service, Laundry/Valet Services, Free Airport Shuttle, Terrace, High speed internet access, Safe, Wireless Internet Access, Meal Plan - Bed and Breakfast.
 amenity_freRégime familial, garde / Services à l'enfance, piste de jogging, massage, petit déjeuner buffet, service en chambre, Enregistrement express, Service de réveil, air conditionné, sèche-cheveux disponibles, Location de voitures, bureau de concierge, réception ouverte 24 heures, piscine, restaurant, docteur à l'appel, Service d'entretien, de préparation de lit services service, blanchisserie / service de voiturier, navette d'aéroport gratuit, terrasse, accès internet haut débit, coffre-fort, accès Internet sans fil, Repas - Chambres d'hôtes.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localeeng
 tagline
 City
 id668
 country_idAR
 state_id(null)
 maintrack_idPUERTOLIBERTAD
 namePuerto Libertad
 main_key
 Country
 idAR
 nameArgentina
 name_freArgentine
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id11364
 hotel_id697
 order2
 urihttp://images.pegs.com/imageRepo/1/0/29/736/141/posada-puerto-bemberg-hotel-de-selva-foto_1_J.jpg
 ratio_hw0.71
 on_wall0
 1
 id11365
 hotel_id697
 order3
 urihttp://images.pegs.com/imageRepo/1/0/29/736/145/posada-puerto-bemberg-hotel-de-selva-foto_3_J.jpg
 ratio_hw0.71
 on_wall0
 2
 id11366
 hotel_id697
 order4
 urihttp://images.pegs.com/imageRepo/1/0/29/736/149/posada-puerto-bemberg-hotel-de-selva-foto_6_J.jpg
 ratio_hw0.71
 on_wall0
 3
 id11367
 hotel_id697
 order5
 urihttp://images.pegs.com/imageRepo/1/0/29/736/153/posada-puerto-bemberg-hotel-de-selva-foto_4_J.jpg
 ratio_hw0.71
 on_wall0
 4
 id11368
 hotel_id697
 order6
 urihttp://images.pegs.com/imageRepo/1/0/29/736/157/posada-puerto-bemberg-hotel-de-selva-foto_5_J.jpg
 ratio_hw0.71
 on_wall0
 5
 id11369
 hotel_id697
 order7
 urihttp://images.pegs.com/imageRepo/1/0/29/736/161/posada-puerto-bemberg-hotel-de-selva-foto_2_J.jpg
 ratio_hw0.71
 on_wall0
 Room
 0
 id2851
 typeOTH
 hotel_id697
 nameDeluxe single-double room
 descriptionPillow menu- cordless phone with IDD- air conditioning and heating- library in every room.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 1
 id2852
 typeOTH
 hotel_id697
 nameSuite single-double room
 descriptionPillow menu- cordless phone with IDD- air conditioning and heating- library in every room.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 2
 id2853
 typeOTH
 hotel_id697
 nameSuperior single-double room
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 RatesPeriod(empty)
 Weather(false)
 News(empty)
- relatedHotels
 0
 Hotel
 id764
 starred0
 in0
 maintrack_hotel_id378025
 brand_codeUZ
 nameLa Cantera Jungle Lodge Iguazu
 addressSelva Iriapu Misiones
 zip_code33700
 cityarea_id(null)
 city_id742
 region_id(null)
 state_id(null)
 country_idAR
 latitude-25.566601
 longitude-54.566601
 zoom13
 rating4
 phone54375715548333
 reservation_phone(null)
 fax541148037335
 emailventas@hotellacantera.com
 created2011-08-01 17:38:40
 modified2011-08-04 13:14:47
 descriptionSituated in the Irya jungle - only 10 km from Argentinean Falls and in perfect harmony with its ecosystem - La Cantera has 24 rooms spread across 3 buildings - which are outlined for its great space - elegance and comfort - guaranteeing the satisfaction of the most demanding guests. Furnished tastefully - each bedroom - suite - has a king size beds - Bergere or Pampas armchairs - flat screen TV and satellite television - baths with Jacuzzi - Wi-Fi and a swimming pool. Everything that you need in order to feel like at home. The Cantera adapts to the requirements of the most selective traveller. Our personnel is bilingual - suitable and highly qualified to answer your all your questions and assist you with all your needs; they will help you to know every Iguazu's corner and its natural secrets. Let us to guide you through Iguazu Argentina
 description_freSitué dans la jungle Irya, à 10 km seulement des chutes Argentine et en parfaite harmonie avec son écosystème, La Cantera dispose de 24 chambres réparties sur 3 bâtiments qui sont appréciés pour son élégance et le confort d'un grand espace garantissant la satisfaction des clients les plus exigeants. Meublé avec goût, chaque suite dispose d'une chambre avec grand lit, des fauteuils bergère, TV écran plat et télévision par satellite, bains avec jacuzzi, Wi-Fi et d'une piscine. Tout ce que vous avez besoin pour vous sentir comme à la maison. La Cantera s'adapte aux exigences des voyageurs les plus sélectifs. Notre personnel est bilingue et hautement qualifiés pour répondre à toutes vos questions et vous aider, ils vous permettront de connaître tous les coins d'Iguazu et ses secrets naturels. Laissez-nous vous guider à travers Iguazu en Argentine.
 amenityBar/Lounge; Free Parking; Restaurant
 amenity_freBar/ Lounge, Parking, Restaurant.
 lowest_rate159.00
 lr_currencyUSD
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localeeng
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id742
 country_idAR
 state_id(null)
 maintrack_idPUERTOIGUAZU
 namePuerto Iguazú
 main_key
 Country
 idAR
 nameArgentina
 name_freArgentine
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id12134
 hotel_id764
 order2
 urihttp://images.pegs.com/imageRepo/1/0/27/649/151/La%20Cantera%20Iguazu%20Exterior%201_J.jpg
 ratio_hw1.33
 on_wall0
 1
 id12135
 hotel_id764
 order3
 urihttp://images.pegs.com/imageRepo/1/0/27/649/341/La%20Cantera%20Iguazu%20Exterior%202_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id3115
 typeOTH
 hotel_id764
 nameTierra - Single Room
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id1171
 localeeng
 modelHotel
 foreign_key764
 fieldtagline
 content
 1
 id1172
 localefre
 modelHotel
 foreign_key764
 fieldtagline
 content
 Envie
 0
 id1
 created2011-05-17 19:21:13
 modified2011-05-17 19:21:13
 1
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 1
 Hotel
 id1419
 starred0
 in0
 maintrack_hotel_id(null)
 brand_code
 nameYacutinga Lodge
 address
 zip_code0000
 cityarea_id(null)
 city_id1346
 region_id(null)
 state_id(null)
 country_idAR
 latitude-25.5886724374808
 longitude-54.0732690795899
 zoom12
 rating0
 phone(null)
 reservation_phone(null)
 fax(null)
 email(null)
 created2012-01-11 17:30:13
 modified2012-01-11 18:44:51
 descriptionYacutina Lodge and its Nature Reserve are located on the upper Iguassú River 80km from the spectacular Iguassu Falls in the northeastern Misiones Province of Argentina. This unique Lodge provides a great opportunity to explore the mysteries of the Interior Atlantic Rainforest far away of massive tourism where you can live and breathe the atmosphere of the pristine subtropical jungle and enjoy the peace and tranquility. The lodge is a perfect place to spend a minimum of 2 nights after a visit to the Iguassu waterfalls. Native materials, such as stones and large logs from fallen trees have been successfully incorporated into the architectural concept of our place, which integrates completely with the natural surrounding and special care has been taken not to disturb the forest. The 20 comfortable and rustic-styled rooms are referred to as "Butterflies" and a recently added Yatei-Suite. There is no TV, mini-bar or other 5 star facilities in the rooms. Yacutinga Lodge's ecotourism concept is devoted to produce a wonderful relationship between the visitor and the surrounding nature. This means that everyone visiting Yacutinga Lodge takes part in different environmental activities, such as environmental education-based walks ,navigations, native trees planting, wildlife observation and classification, and interpretation of natural processes to understand and discover this forest.
 description_freLe Yacutina Lodge et sa réserve naturelle sont situés dans la partie supérieure du fleuve Iguaçu à 80 km des spectaculaires Chutes d'Iguaçu, dans la province de Misiones au nord de l'Argentine. Ce Lodge unique offre une excellente occasion d'explorer les mystères de la forêt tropicale de l'Atlantique Intérieur loin du tourisme de masse où l'on peut vivre et respirer l'atmosphère de la jungle vierge subtropicale et profiter de la paix et la tranquillité. Le lodge est un endroit parfait pour passer un minimum de 2 nuits après une visite des chutes d'Iguaçu. Avec des matériaux indigènes, tels que des pierres et des gros troncs d'arbres tombés ont été incorporées avec succès dans le concept architectural, qui s'intègre complètement à l'environnant et le soin particulier a été apporté pour ne pas déranger la forêt. Les 20 chambres confortables ont été conçus dans un style rustique. Il n'y a pas de télévision, mini-bar ou d'autres installations 5 étoiles dans les chambres. L'écolodge Yacutinga est consacré pour offrir une merveilleuse relation entre le visiteur et la nature environnante. Cela signifie que chaque visiteur prend part à différentes activités environnementales, tels que l'éducation environnementale basée sur les promenades, navigations, la plantation d'arbres natifs, observation de la faune et de la classification et l'interprétation des processus naturels pour comprendre et découvrir cette forêt.
 amenitylobby, restaurant, jardin, forest, cotton linen, bathroom, hot running water, nature reserve.
 amenity_frehall, le restaurant, jardin, forêt, draps en coton, salle de bains, eau chaude, réserve naturelle.
 lowest_rate966.00
 lr_currencyUSD
 lr_people2
 comment_count0
 cancellation_policyRates: All rates are in $USD and inclusive of transfers, accommodations, meals and all activities as described in the specific chosen itinerary. Excluded are all beverages. All rates are per person according to the chosen room type and program. VAT is included and prepayment is requested. Credit Cards: Beverages are not included in our rate. The consumptions at the Lodge will be paid upon check-out and please note that we do NOT accept any type of credit cards . Traveler checks and the following currencies are accepted: Pesos (Argentina), Reais (Brazil), US Dollars and Euros. Children: Children under 10 years of age are not accepted Group policy: for each 15 guests there will be 1 free of charge. Payment policy: We request full prepayment one week prior guests arrival at the Lodge.
 cancellation_policy_freTarifs: Tous les tarifs sont en $ USD et inclus les transferts, l'hébergement, les repas et toutes les activités décrites dans le package spécifique choisie. Sont exclues toutes les boissons. Tous les tarifs sont par personne selon le type de chambre et le package choisit. La TVA est incluse et le prépaiement est demandé. Cartes de crédit: Les boissons ne sont pas inclus dans nos tarifs. Les consommations au Lodge sera payée au moment du check-out et s'il vous plaît noter que nous n'acceptons pas tous les types de cartes de crédit. Les chèques de voyage et les devises suivantes sont acceptées: Pesos (Argentine), Reais (Brésil), en dollars américains et en euros. enfants: Les enfants de moins de 10 ans ne sont pas acceptés. Les groupes: pour chaque groupe de 15 invités, il y aura une personne gratuite. Politique de paiement: Nous demandons un acompte complet une semaine avant l'arrivée au Lodge.
 published1
 localeeng
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id1346
 country_idAR
 state_id(null)
 maintrack_id(null)
 nameSilvestre Yacutinga
 main_key(null)
 Country
 idAR
 nameArgentina
 name_freArgentine
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id20894
 hotel_id1419
 order1
 uriGarden-Pool0.jpg
 ratio_hw0.67
 on_wall0
 1
 id20895
 hotel_id1419
 order2
 uriLobby0.jpg
 ratio_hw0.67
 on_wall0
 2
 id20896
 hotel_id1419
 order3
 uricronoviolaceaperching0.jpg
 ratio_hw0.67
 on_wall0
 3
 id20897
 hotel_id1419
 order4
 uriThe-Camp0.jpg
 ratio_hw0.67
 on_wall0
 4
 id20898
 hotel_id1419
 order5
 uriTwin-Room0.jpg
 ratio_hw0.67
 on_wall0
 5
 id20899
 hotel_id1419
 order6
 uriLobby-corner10.jpg
 ratio_hw0.67
 on_wall0
 6
 id20900
 hotel_id1419
 order7
 uriDWL-Room0.jpg
 ratio_hw0.67
 on_wall0
 7
 id20901
 hotel_id1419
 order8
 uriJungle-furniture-10.jpg
 ratio_hw0.67
 on_wall0
 8
 id20902
 hotel_id1419
 order9
 uriMelting-Architecture0.jpg
 ratio_hw0.67
 on_wall0
 9
 id20903
 hotel_id1419
 order10
 uriGlass-detail0.jpg
 ratio_hw0.67
 on_wall0
 10
 id20904
 hotel_id1419
 order11
 uridetalhe30.jpg
 ratio_hw0.67
 on_wall0
 11
 id20905
 hotel_id1419
 order12
 uriGuest-Book0.jpg
 ratio_hw0.67
 on_wall0
 12
 id20906
 hotel_id1419
 order13
 uriDetail-10.jpg
 ratio_hw0.67
 on_wall0
 13
 id20907
 hotel_id1419
 order14
 uriPapaya0.jpg
 ratio_hw0.67
 on_wall0
 14
 id20908
 hotel_id1419
 order15
 uriMain-entrance0.jpg
 ratio_hw0.67
 on_wall0
 15
 id20909
 hotel_id1419
 order16
 uriEscalera-Guazu0.jpg
 ratio_hw0.67
 on_wall0
 Room
 0
 id5552
 type
 hotel_id1419
 nameYACUTINGA EXPERIENCE - 2 NIGHTS IN SELVA ROOM
 descriptionYacutinga Experience includes: roundtrip transfer from meeting point "Raices Argentinas" in Iguaçu, full pension, 2 nights accomodation, excursions as per description, enter the Yacutinga Reserve, naturalist english speaking guide, auxiliary guide during the excursions.
 name_freEXPERIENCE YACUTINGA - 2 NUITS CHAMBRE SELVA
 description_freExpérience Yacutinga comprend: le transfert aller-retour du point de rencontre "Raices Argentinas" à Iguaçu, pension complète, 2 nuits d'hébergement, des excursions selon la description, entré à la Réserve Yacutinga, guide naturaliste parlant anglais, un guide auxiliaire pendant les excursions.
 lowest_rate966.00
 lr_currencyUSD
 lr_people2
 breakfast_included0
 half_board0
 all_inclusive0
 full_board1
 accomodation_only0
 1
 id5553
 type
 hotel_id1419
 nameYACUTINGA NATURALE AND GUARANIE CULTURE - 3 NIGHTS
 descriptionYacutinga Nature & Culture Birdwatching includes: Roundtrip Transfer from meeting point “Raices Argentinas” in Iguazu, Full Pension, 3 nights accomodation, excursions as per description, Rights to enter the Yacutinga private Reserve, Check-List – Ornithologist, Auxiliary guide during the excursions.
 name_freYACUTINGA NATURE ET CULTURE GUARANIE - 3 NUITS
 description_freYacutinga Nature & Culture Birdwatching comprend: Transfert aller-retour du point de rencontre "Raices Argentinas" à Iguazu, Pension complète, logement, excursions 3 nuits selon la description, les droits d'entrée dans la réserve privée Yacutinga, Check-List, Ornithologue, guide auxiliaire lors de les excursions.
 lowest_rate1656.00
 lr_currencyUSD
 lr_people2
 breakfast_included0
 half_board0
 all_inclusive0
 full_board1
 accomodation_only0
 2
 id5554
 type
 hotel_id1419
 nameBIRDWATCHING PROGRAM - 4 NIGHTS
 descriptionYacutinga Birdwatching includes: Roundtrip Transfer from meeting point “Raices Argentinas” in Iguazu, Full Pension, 4 nights accomodation, excursions as per description, Rights to enter the Yacutinga private Reserve, Check-List, Ornithologist, Auxiliary guide during the excursions.
 name_frePROGRAMME OBSERVATION DES OISEAUX - 4 NUITS
 description_freObservation des oiseaux Yacutinga comprend: Transfert aller-retour au point de rencontre "Raices Argentinas" à Iguazu, pension complète, 4 nuits d'hébergement, excursions, les droits d'entrée dans la réserve privée Yacutinga, check-list, ornithologue, guide auxiliaire pendant les excursions.
 lowest_rate2346.00
 lr_currencyUSD
 lr_people2
 breakfast_included0
 half_board0
 all_inclusive0
 full_board1
 accomodation_only0
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id2437
 localeeng
 modelHotel
 foreign_key1419
 fieldtagline
 content
 1
 id2438
 localefre
 modelHotel
 foreign_key1419
 fieldtagline
 content
 Envie
 0
 id1
 created2011-05-17 19:21:13
 modified2011-05-17 19:21:13
 1
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 2
 id11
 created2011-05-17 19:26:32
 modified2011-05-17 19:26:32
 3
 id12
 created2011-05-17 19:26:48
 modified2011-05-17 19:26:48
- relatedEvents
 0
 Event
 id1656
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationWanda, Province de Misiones, Argentine
 latitude-25.9712
 longitude-54.5642
 zoom13
 state_id(null)
 country_id
 created2011-11-29 14:47:34
 modified2011-11-29 14:47:34
 url(null)
 comment_count0
 former_business_id1264
 localeeng
 nameTHE OLD JUNGLE CITIES
 descriptionStrong immigration from Central Europe and Scandinavia settled in that province. Traces of these cultures are still visible in the traditions and indigenous traits. A clear example of this phenomenon is found in the festival of immigrants being held in Oberá. Stop by the fields in semi-precious stones and Wanda Hito Tres Fronteras de las, where Argentina, Brazil and Paraguay converge.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id9907
 localeeng
 modelEvent
 foreign_key1656
 fieldname
 contentTHE OLD JUNGLE CITIES
 1
 id9908
 localefre
 modelEvent
 foreign_key1656
 fieldname
 contentLES ANCIENNES CITEES DE LA JUNGLE
 Descriptions
 0
 id9909
 localeeng
 modelEvent
 foreign_key1656
 fielddescription
 contentStrong immigration from Central Europe and Scandinavia settled in that province. Traces of these cultures are still visible in the traditions and indigenous traits. A clear example of this phenomenon is found in the festival of immigrants being held in Oberá. Stop by the fields in semi-precious stones and Wanda Hito Tres Fronteras de las, where Argentina, Brazil and Paraguay converge.
 1
 id9910
 localefre
 modelEvent
 foreign_key1656
 fielddescription
 contentUne forte immigration venant d'Europe centrale et de Scandinavie se sont installés dans cette province. Des traces de ces cultures sont encore visibles dans les traditions et les traits indigènes. Un exemple clair de ce phénomène se retrouve dans le festival des immigrants qui se tient à Oberá. Faites un arrêt au champs de pierres semi-précieuses dans Wanda et à Hito de las Tres Fronteras, où l'Argentine, le Brésil et le Paraguay convergent.
 Links
 0
 id9911
 localeeng
 modelEvent
 foreign_key1656
 fieldlink
 content
 1
 id9912
 localefre
 modelEvent
 foreign_key1656
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 1
 Event
 id755
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationFoz do Iguaçu - Paraná, Brésil
 latitude-25.5469
 longitude-54.5882
 zoom12
 state_id(null)
 country_id
 created2011-07-26 13:24:21
 modified2011-07-26 13:24:21
 url(null)
 comment_count0
 former_business_id363
 localeeng
 nameIGUACU NATIONAL PARK
 descriptionNational Park of Iguaçu, you can see, over a length of 2700m, one of the largest waterfalls in the world. It is home to many rare and endangered species of flora and fauna, including the giant otter and giant anteater. The clouds of spray produced by the falls support the growth of lush vegetation.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id4501
 localeeng
 modelEvent
 foreign_key755
 fieldname
 contentIGUACU NATIONAL PARK
 1
 id4502
 localefre
 modelEvent
 foreign_key755
 fieldname
 contentPARC NATIONAL IGUACU
 Descriptions
 0
 id4503
 localeeng
 modelEvent
 foreign_key755
 fielddescription
 contentNational Park of Iguaçu, you can see, over a length of 2700m, one of the largest waterfalls in the world. It is home to many rare and endangered species of flora and fauna, including the giant otter and giant anteater. The clouds of spray produced by the falls support the growth of lush vegetation.
 1
 id4504
 localefre
 modelEvent
 foreign_key755
 fielddescription
 contentLe parc national de l’Iguaçu vous permet d’admirer, sur une longueur de 2700m, l’une des plus grandes chutes du monde. Il abrite de nombreuses espèces rares et menacées de flore et de faune, et notamment la loutre géante et le fourmilier géant. Les nuages d’embruns qui se dégagent des chutes favorisent la croissance d’une végétation luxuriante.
 Links
 0
 id4505
 localeeng
 modelEvent
 foreign_key755
 fieldlink
 content
 1
 id4506
 localefre
 modelEvent
 foreign_key755
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 2
 Event
 id1314
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationIryapú Jungle
 latitude-25.363
 longitude-54.33
 zoom13
 state_id(null)
 country_id
 created2011-10-28 15:16:31
 modified2011-10-28 15:16:31
 url(null)
 comment_count0
 former_business_id920
 localeeng
 nameRAPPELLING IN JUNGLE
 descriptionFrom a platform at the height of the canopy, you can see the roof of the jungle and dazzling with harnesses and safety ropes, rappelling you having an indescribable feeling to experience in a unique natural environment.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id7855
 localeeng
 modelEvent
 foreign_key1314
 fieldname
 contentRAPPELLING IN JUNGLE
 1
 id7856
 localefre
 modelEvent
 foreign_key1314
 fieldname
 contentDESCENDRE EN RAPPEL DANS LA JUNGLE
 Descriptions
 0
 id7857
 localeeng
 modelEvent
 foreign_key1314
 fielddescription
 contentFrom a platform at the height of the canopy, you can see the roof of the jungle and dazzling with harnesses and safety ropes, rappelling you having an indescribable feeling to experience in a unique natural environment.
 1
 id7858
 localefre
 modelEvent
 foreign_key1314
 fielddescription
 contentA partir d'une plateforme située à la hauteur de la canopée, vous pourrez observer le toit de la jungle éblouissante et à l'aide de harnais et de cordes de sécurités, vous descendrez en rappel en ayant un sentiment indescriptible de faire une expérience dans un environnement naturel unique.
 Links
 0
 id7859
 localeeng
 modelEvent
 foreign_key1314
 fieldlink
 content
 1
 id7860
 localefre
 modelEvent
 foreign_key1314
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
- weather(false)
- meta_description_for_layoutAt Puerto Bemberg one breathes and enjoys the forest. In the heart of a subtropical ecosystem, time flows amidst trails, bird sounds, dikes falls, woodlands, natural vantage points, native legend and the murmur of the Parana River. Combining a turn-of-century style with amenities and facilities that will please the most demanding traveler, this history-filled in of colonial tiles, wide spaces and native furniture is the hub of singular and intimate experiences with nature. Fourteen spacious and luminous rooms, an exclusive restaurant offering local cuisine with gourmet influences, a natural pool, La Cave and its variety of delicious wines and the outdoor terrace overlooking the Parana River are some of the highlights of relaxing in this paradise. Only thirty minutes away from the entrance to the Iguazu National Park it is a different alternative for those wishing to visit one of the world wonders.
- userData(null)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
 0paginator
 1simpleGraph
 2number
 3htmlToolbar
 4toolbar
 5tree
 6cleaner
 7commentWidget
 8javascript
 9imageCache
 10text
 11i18n
 12globesecret
 13arraySplitter
 14time
 15jqueryEngine
 16form
 17js
 18session
 19favorites
 20shareThis
 21breadcrumbs
 22html
 23assetCompress
====

Find an experience

Let us guide you

Find a boutique hotel

Search by desire

By country

Posada Puerto Bemberg Iguazu

Puerto Libertad, Argentina

0 comment

Book this hotel

Experiences close to the hotel

Globe Secret's guarantees

A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL

BOOKING AT NO ADDITIONAL COST

UNIQUE SELECTION CRITERIA

MORE TAILORED SERVICES

default

Query Explain:

Memory

Timers

warning

error

Find an experience

Let us guide you

Find a boutique hotel

Search by desire

By country

Posada Puerto Bemberg Iguazu

Puerto Libertad, Argentina

0 comment

Book this hotel

Experiences close to the hotel

THE OLD JUNGLE CITIES

IGUACU NATIONAL PARK

RAPPELLING IN JUNGLE

Other hotels matching your criteria

Puerto Iguazú, Argentina La Cantera Jungle Lodge Iguazu

Silvestre Yacutinga, Argentina Yacutinga Lodge

Read more

News

Globe Secret's guarantees

A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL

BOOKING AT NO ADDITIONAL COST

UNIQUE SELECTION CRITERIA

MORE TAILORED SERVICES

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

warning

error

View Variables

Puerto Iguazú, Argentina
La Cantera Jungle Lodge Iguazu

Silvestre Yacutinga, Argentina
Yacutinga Lodge