Eremo della Giubiliana

Globe Secret est né de l'association de professionnels du tourisme, de l’hotellerie et du e-commerce. Les équipes de Globe Secret garantissent à ses utilisateurs une sélection rigoureuse d'hôtels de charme. Immatriculation d'agent de voyages n° IM075100403 - Garantie Financière : BPRP - Membre de l' APST - RCP : Hiscox n° HA PRC0055186 - CNIL 1517931. SSL, AmericanExpress, MasterCard, Visa, VisaElectron

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent96a2135195cee4dc19bc11b4bba8d8cd
  time1652752643
  timeout10
  languagefre
====
Request
+ –
Request

Cake Params
- controllerhotels
- actionview
- named(empty)
- pass
 0388
 1eremo-della-giubiliana
- languagefr
- plugin(null)
- url
 exthtml
 urlfr/hotels/voir/388/eremo-della-giubiliana
- form(empty)
- isAjax(false)
$_GET
- urlfr/hotels/voir/388/eremo-della-giubiliana
Cookie
- languagefr
Current Route
- keys(empty)
- options(empty)
- defaults
 controllerhotels
 actionview
 languagefr
 plugin(null)
- template/fr/hotels/voir/*
- _greedy(true)
- _compiledRoute#^/fr/hotels/voir(?:/(?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	1
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` = 'fre') 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` = 'fre') 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` = 388 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` = 344	1	1	0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'IT'	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` = (388)	9	9	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` = (388)	10	10	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 (1590, 1591, 1592, 1593, 1594, 1595, 1596, 1597, 1598, 1599)	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` = (388) 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` = 'fre') 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` = 'fre') 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` = 'fre') WHERE `News`.`country_id` = 'IT' ORDER BY `News`.`created` DESC	0	0	2	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` = 'fre') 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` != 388 AND `Hotel`.`longitude` BETWEEN 13.538283312183 AND 15.790716687817 AND `Hotel`.`latitude` BETWEEN 36.00626104058 AND 37.80733695942 ORDER BY ABS(`Hotel`.`longitude` - 14.6645) + ABS(`Hotel`.`latitude` - 36.906799) ASC LIMIT 3	3	3	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 (968, 1473, 907)	29	29	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 (968, 1473, 907)	12	12	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 (968, 1473, 907)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (968, 1473, 907)	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 (968, 1473, 907)	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 (968, 1473, 907)	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 (968, 1473, 907)	6	6	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 (968, 1473, 907) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	13	13	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` = 'fre') 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` = 'fre') 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` = 'fre') 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 13.538283312183 AND 15.790716687817 AND `Event`.`latitude` BETWEEN 36.00626104058 AND 37.80733695942 ORDER BY ABS(`Event`.`longitude` - 14.6645) + ABS(`Event`.`latitude` - 36.906799) ASC LIMIT 10	10	10	11	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (908, 633, 533, 632, 631, 529, 530, 532, 907, 629)	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 (908, 633, 533, 632, 631, 529, 530, 532, 907, 629)	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 (908, 633, 533, 632, 631, 529, 530, 532, 907, 629)	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 (908, 633, 533, 632, 631, 529, 530, 532, 907, 629)	20	20	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 (908, 633, 533, 632, 631, 529, 530, 532, 907, 629)	20	20	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 (908, 633, 533, 632, 631, 529, 530, 532, 907, 629)	20	20	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 (908, 633, 533, 632, 631, 529, 530, 532, 907, 629) 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 (908, 633, 533, 632, 631, 529, 530, 532, 907, 629) 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` = 'fre') 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` = 'fre') 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 (22, 21, 25, 26, 4, 12, 14, 19, 9, 30, 3, 1, 13, 6, 24, 7, 18, 5, 10, 27, 2, 11, 29, 16, 15, 23, 17, 8, 28)	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_fre` 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` = 'fre') 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` = 'fre') 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` = 388 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` = 388 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 26,00 MB

Message	Memory use
Component initialization	14,00 MB
Controller action start	14,00 MB
Controller render start	16,00 MB
View render complete	20,00 MB

Timers

Total Request Time: 512 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	88,11
Component initialization and startup	4,61
Controller action	203,45
Render Controller Action	103,38
» Rendering View	99,99
» » Rendering APP/views/hotels/view.ctp	47,30
» » » Rendering APP/views/elements/sharing_widget.ctp	0,22
» » » Rendering APP/views/elements/comments/flat/main.ctp	0,41
» » » Rendering APP/views/elements/hotels/form_reservation.ctp	3,33
» » » Rendering APP/views/elements/events/related.ctp	0,94
» » » Rendering APP/views/elements/events/related.ctp #2	0,95
» » » Rendering APP/views/elements/events/related.ctp #3	0,92
» » » Rendering APP/views/elements/events/related.ctp #4	1,04
» » » Rendering APP/views/elements/events/related.ctp #5	0,97
» » » Rendering APP/views/elements/events/related.ctp #6	1,01
» » » Rendering APP/views/elements/events/related.ctp #7	0,92
» » » Rendering APP/views/elements/events/related.ctp #8	0,91
» » » Rendering APP/views/elements/events/related.ctp #9	0,97
» » » Rendering APP/views/elements/events/related.ctp #10	0,97
» » » Rendering APP/views/elements/events/legend.ctp	1,84
» » » Rendering APP/views/elements/hotels/related.ctp #11	0,62
» » » Rendering APP/views/elements/hotels/related.ctp #12	0,63
» » » Rendering APP/views/elements/hotels/related.ctp #13	0,61
» » Rendering APP/views/layouts/default.ctp	52,49
» » » Rendering APP/views/elements/google_analytics.ctp	0,09
» » » Rendering APP/views/elements/layout/top.ctp	1,58
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0,30
» » » Rendering APP/views/elements/layout/header.ctp	45,92
» » » Rendering APP/views/elements/layout/extra.ctp	0,13
» » » Rendering APP/views/elements/layout/footer.ctp	3,65
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0,30
» » » Rendering APP/views/elements/layout/footnotes.ctp	0,09

====

Log

+ –

Logs

warning

Time	Message
2022-05-16 17:57:24	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]
2022-05-16 17:57:24	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
2022-05-16 17:57:24	Impossible to access the Google API
2022-05-16 17:57:24	Impossible to access the Google API

====

Variables
+ –
View Variables
- promises_for_layout
 0
 Promise
 id1
 title Des hôtels de charme a taille humaine
 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" /> 
 localefre
 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 RESERVATION SANS FRAIS
 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.
 localefre
 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 DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 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,..
 localefre
 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 PLUS DE SERVICES A LA CARTE
 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>
 localefre
 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
 6Arts & 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
 22ACCES HANDICAPE
 21ACCES INTERNET
 25CAMPAGNE
 26CHASSE
 4DESERT
 12ECOLOGIE
 14EQUITATION
 19GARDE ENFANT
 9GOLF
 30HELIPORT
 3ILE
 1JUNGLE
 13LAC
 6LOCATION DE VELO
 24LOUNGE CIGARE
 7PECHE
 18PISCINE
 5PLAGE
 10PLONGEE
 27POLO
 2RANDONNEE
 11SAFARI
 29SHOPPING
 16SKI
 15SPA
 23TENNIS
 17VIGNOBLE
 8VILLE
 28VOILE
- countries_for_layout
 0
 Country
 idZA
 nameSouth Africa
 name_freAfrique Du Sud
 1
 Country
 idAL
 nameAlbania
 name_freAlbanie
 2
 Country
 idDE
 nameGermany
 name_freAllemagne
 3
 Country
 idAD
 nameAndorra
 name_freAndorre
 4
 Country
 idAI
 nameAnguilla
 name_freAnguilla
 5
 Country
 idAG
 nameAntigua/Barbuda
 name_freAntigua-Et-Barbuda
 6
 Country
 idAN
 nameNetherlands Antilles
 name_freAntilles Néerlandaises
 7
 Country
 idSA
 nameSaudi Arabia
 name_freArabie Saoudite
 8
 Country
 idAR
 nameArgentina
 name_freArgentine
 9
 Country
 idAM
 nameArmenia
 name_freArménie
 10
 Country
 idAU
 nameAustralia
 name_freAustralie
 11
 Country
 idAT
 nameAustria
 name_freAutriche
 12
 Country
 idAZ
 nameAzerbaijan
 name_freAzerbaïdjan
 13
 Country
 idBS
 nameBahamas
 name_freBahamas
 14
 Country
 idBB
 nameBarbados
 name_freBarbade
 15
 Country
 idBE
 nameBelgium
 name_freBelgique
 16
 Country
 idBZ
 nameBelize
 name_freBelize
 17
 Country
 idBM
 nameBermuda
 name_freBermudes
 18
 Country
 idBT
 nameBhutan
 name_freBhoutan
 19
 Country
 idBO
 nameBolivia
 name_freBolivie
 20
 Country
 idBA
 nameBosnia
 name_freBosnie-Herzégovine
 21
 Country
 idBR
 nameBrazil
 name_freBrésil
 22
 Country
 idKH
 nameCambodia
 name_freCambodge
 23
 Country
 idCA
 nameCanada
 name_freCanada
 24
 Country
 idCL
 nameChile
 name_freChili
 25
 Country
 idCN
 nameChina
 name_freChine
 26
 Country
 idCO
 nameColombia
 name_freColombie
 27
 Country
 idCR
 nameCosta Rica
 name_freCosta Rica
 28
 Country
 idHR
 nameCroatia
 name_freCroatie
 29
 Country
 idDK
 nameDenmark
 name_freDanemark
 30
 Country
 idDM
 nameDominica
 name_freDominique
 31
 Country
 idEG
 nameEgypt
 name_freÉgypte
 32
 Country
 idAE
 nameUnited Arab Emirates
 name_freÉmirats Arabes Unis
 33
 Country
 idEC
 nameEcuador
 name_freÉquateur
 34
 Country
 idES
 nameSpain
 name_freEspagne
 35
 Country
 idEE
 nameEstonia
 name_freEstonie
 36
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 37
 Country
 idFJ
 nameFiji
 name_freFidji
 38
 Country
 idFI
 nameFinland
 name_freFinlande
 39
 Country
 idFR
 nameFrance
 name_freFrance
 40
 Country
 idGR
 nameGreece
 name_freGrèce
 41
 Country
 idGD
 nameGrenada
 name_freGrenade
 42
 Country
 idGP
 nameGuadeloupe
 name_freGuadeloupe
 43
 Country
 idGT
 nameGuatemala
 name_freGuatemala
 44
 Country
 idHN
 nameHonduras
 name_freHonduras
 45
 Country
 idHK
 nameHong Kong
 name_freHong-Kong
 46
 Country
 idHU
 nameHungary
 name_freHongrie
 47
 Country
 idCK
 nameCook Islands
 name_freÎles Cook
 48
 Country
 idTC
 nameTurks And Caicos Islands
 name_freÎles Turks et Caïques
 49
 Country
 idVG
 nameVirgin Islands (British)
 name_freÎles Vierges Britanniques
 50
 Country
 idVI
 nameVirgin Islands (U.S.)
 name_freÎles Vierges Des États-Unis
 51
 Country
 idIN
 nameIndia
 name_freInde
 52
 Country
 idID
 nameIndonesia
 name_freIndonésie
 53
 Country
 idIE
 nameIreland
 name_freIrlande
 54
 Country
 idIS
 nameIceland
 name_freIslande
 55
 Country
 idIL
 nameIsrael
 name_freIsraël
 56
 Country
 idIT
 nameItaly
 name_freItalie
 57
 Country
 idJM
 nameJamaica
 name_freJamaïque
 58
 Country
 idJP
 nameJapan
 name_freJapon
 59
 Country
 idJO
 nameJordan
 name_freJordanie
 60
 Country
 idKE
 nameKenya
 name_freKenya
 61
 Country
 idLA
 nameLaos
 name_freLaos
 62
 Country
 idLV
 nameLatvia
 name_freLettonie
 63
 Country
 idLB
 nameLebanon
 name_freLiban
 64
 Country
 idLT
 nameLithuania
 name_freLituanie
 65
 Country
 idMO
 nameMacau
 name_freMacao
 66
 Country
 idMG
 nameMadagascar
 name_freMadagascar
 67
 Country
 idMY
 nameMalaysia
 name_freMalaisie
 68
 Country
 idMV
 nameMaldives
 name_freMaldives
 69
 Country
 idMA
 nameMorocco
 name_freMaroc
 70
 Country
 idMU
 nameMauritius
 name_freMaurice
 71
 Country
 idMX
 nameMexico
 name_freMexique
 72
 Country
 idMN
 nameMongolia
 name_freMongolie
 73
 Country
 idME
 nameMontenegro
 name_freMonténégro
 74
 Country
 idMZ
 nameMozambique
 name_freMozambique
 75
 Country
 idMM
 nameMyanmar
 name_freMyanmar
 76
 Country
 idNA
 nameNamibia
 name_freNamibie
 77
 Country
 idNI
 nameNicaragua
 name_freNicaragua
 78
 Country
 idNO
 nameNorway
 name_freNorvège
 79
 Country
 idNZ
 nameNew Zealand
 name_freNouvelle-Zélande
 80
 Country
 idOM
 nameOman
 name_freOman
 81
 Country
 idUG
 nameUganda
 name_freOuganda
 82
 Country
 idPK
 namePakistan
 name_frePakistan
 83
 Country
 idPA
 namePanama
 name_frePanama
 84
 Country
 idNL
 nameNetherlands
 name_frePays-Bas
 85
 Country
 idPE
 namePeru
 name_frePérou
 86
 Country
 idPH
 namePhilippines
 name_frePhilippines
 87
 Country
 idPL
 namePoland
 name_frePologne
 88
 Country
 idPF
 nameFrench Polynesia
 name_frePolynésie Française
 89
 Country
 idPR
 namePuerto Rico
 name_frePorto Rico
 90
 Country
 idPT
 namePortugal
 name_frePortugal
 91
 Country
 idDO
 nameDominican Republic
 name_freRépublique Dominicaine
 92
 Country
 idCZ
 nameCzech Republic
 name_freRépublique Tchèque
 93
 Country
 idRE
 nameReunion
 name_freRéunion
 94
 Country
 idRO
 nameRomania
 name_freRoumanie
 95
 Country
 idGB
 nameUnited Kingdom
 name_freRoyaume-Uni
 96
 Country
 idRU
 nameRussia
 name_freRussie
 97
 Country
 idBL
 nameSaint-Barthelemy
 name_freSaint-Barthélemy
 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
 idLC
 nameSaint Lucia
 name_freSainte-Lucie
 101
 Country
 idRS
 nameSerbia
 name_freSerbie
 102
 Country
 idSC
 nameSeychelles
 name_freSeychelles
 103
 Country
 idSG
 nameSingapore
 name_freSingapour
 104
 Country
 idSK
 nameSlovak Republic
 name_freSlovaquie
 105
 Country
 idSI
 nameSlovenia
 name_freSlovénie
 106
 Country
 idLK
 nameSri Lanka
 name_freSri Lanka
 107
 Country
 idSE
 nameSweden
 name_freSuède
 108
 Country
 idCH
 nameSwitzerland
 name_freSuisse
 109
 Country
 idSJ
 nameSvalbard And Jan Mayen Islands
 name_freSvalbard Et Île Jan Mayen
 110
 Country
 idTW
 nameTaiwan
 name_freTaïwan
 111
 Country
 idTZ
 nameTanzania
 name_freTanzanie
 112
 Country
 idTH
 nameThailand
 name_freThaïlande
 113
 Country
 idTN
 nameTunisia
 name_freTunisie
 114
 Country
 idTR
 nameTurkey
 name_freTurquie
 115
 Country
 idUA
 nameUkraine
 name_freUkraine
 116
 Country
 idUY
 nameUruguay
 name_freUruguay
 117
 Country
 idVU
 nameVanuatu
 name_freVanuatu
 118
 Country
 idVN
 nameVietnam
 name_freViet Nam
 119
 Country
 idZW
 nameZimbabwe
 name_freZimbabwe
- staticSlugs
 0qui-sommes-nous
 1plan-du-site
 2termes-et-conditions
 3actualites
 4emplois
 5mentions-legales
 6credits
- userFavorites
 fav-event(empty)
 fav-hotel(empty)
- hotel
 Hotel
 id388
 starred0
 in0
 maintrack_hotel_id356723
 brand_codeYX
 nameEremo della Giubiliana
 addressC da Giubiliana SP25
 zip_code97100
 cityarea_id(null)
 city_id344
 region_id(null)
 state_id(null)
 country_idIT
 latitude36.906799
 longitude14.6645
 zoom11
 rating0
 phone39 0932 669119
 reservation_phone(null)
 fax39 0932 669129
 emailinfo@eremodellagiubiliana.com
 created2011-05-13 21:09:01
 modified2011-07-05 18:38:54
 descriptionA historical site dominating the Mediterranean sea in the midst of the pristine countryside of the Hyblean plateau. A charming hotel set in the historical residence of the ancient noble Nifosi family, a few kilometres south of Ragusa to the south of Tunisi, among carob forests and stone walls. Very old thick white dry-stone walls surround and protect the courtyards and inner structure. Its white towers overlook the plateau that gently slopes towards the sea and on clear days, which are common in these latitudes, you can see the island of Malta and the African Coast. It is surrounded by the typical dry-stone walls. The estate was part of an ecclesiastical feudal hold dating from the 12th century and was a sort of fortified fortress dominating the sea against the incursions of Barbary pirates. The Knights of Malta used the building in the first half of the 16th century. In the 18th century the Eremo was acquired by the Nifosi family of wealthy land-owners. The last heiress. Vincenza Jolanda Nifosi decided to restore it and open it to luxury hospitality. The lobby immediately reveals the character of the Eremo with white stone arches, polished peach-stone flooring with the white family symbol inlay, standing armour and old Sicilian style furniture in the sitting area. The intimacy of the inner stone courtyards make you feel at home, aromatic herbs and blooming plants and fruitful trees populate the garden which opens at the end with a small swimming pool, walks through the garden will make you discover a small fountain. Arab water systems and a necroplois dating back to the V century just at the back of the building. Candle-lit dinners take place in a big dining room, wine tasting and small meetings are held in the old Crypt. The guestrooms have been converted from the Friars cells, the exclusive suites were once the residences of the noble family or of the ecclesiastical relatives.
 description_freUn site historique dominant la mer Méditerranée au milieu de la nature intacte du plateau ibleo. Un charmant hôtel situé dans la résidence historique de l'ancienne famille noble Nifosi; à quelques kilomètres au sud de Raguse, au sud de Tunisi, au milieu des forêts de caroubiers et des murs en pierre. Les très vieux murs blancs de pierres sèches entourent et protègent les cours et la structure intérieure. Ses tours blanches surplombent le plateau qui descend doucement vers la mer, qui sont communs dans ces parages, vous pouvez voir l'île de Malte et la côte africaine. Il est entouré par les murs de pierres sèches typiques. Le domaine féodal a été le cadre d'une prise ecclésiastique datant du 12ème siècle et fut une sorte de forteresse, dominant la mer contre les incursions des pirates barbares. Les Chevaliers de Malte ont utilisé le bâtiment dans la première moitié du 16ème siècle. Au 18ème siècle, l'Eremo a été acquis par la famille Nifosi, de riches propriétaires terriens. La dernière héritière. Vincenza Jolanda Nifosi décida de le restaurer et l'ouvrir à l'hôtellerie de luxe. Le lobby révèle immédiatement le caractère de l'Eremo avec ses arches de pierre blanche, son plancher en noyau de pêche avec l'incrustation du symbole de la famille, des armures et d'anciens meubles de style sicilien dans le salon. L'intimité de la cour intérieure en pierre vous donne l'impression de vous sentir à la maison, les herbes aromatiques et des plantes en fleurs et des arbres fruitiers peuplent le jardin qui s'ouvre sur une petite piscine; des promenades dans le jardin vous feront découvrir une petite fontaine. Un système d'eau arabe et une nécropole datant du Ve siècle se trouvent juste à l'arrière du bâtiment. Des dîners aux chandelles ont lieu dans une grande salle à manger, des dégustation de vins ont aussi lieu dans l'ancienne crypte. Les chambres ont été converties à partir des cellules des frères, les suites luxueuses ont été créées par la famille noble ou des proches ecclésiastique.
 amenityFitness Center or Spa, Tennis, Free Airport Shuttle, Coffee Maker in Room, Currency Exchange, Doorman, Business Center, Copy Service, Childrens Activities, Car Rental Desk, Barber Shop, Phone Service, Family Plan, Pets Allowed, Babysitting/Child Services, Concierge Desk, Tour Desk, Breakfast Buffet, Meal Plan, Room Service, Elevators, Health Club, Jogging Track, Massage, Sauna, 24 Hour Front Desk, Porters, Wake-up Service, Air Conditioned, Hairdryers Available, No Smoking Rooms/Facilities, Private Bathroom, Free Parking, Parking, Golf, Outdoor Pool, Lounge, Restaurant, 24 Hour Security, Doctor on Call, Maid Service, News Stand, High speed internet access, Handicapped Rooms/Facilities, AM/FM Alarm Clock, Bathrobes, Bathroom Telephone, Bidet, Television with Cable, Jacuzzi, Mini Bar, Telephone, Temperature Control, TV, Safe, Outlet Adapters, Satellite TV, Boating, Scuba Diving, Fishing, Secretarial Service, Computer Rental, Audio Visual Equipment, Meal Plan - Bed and Breakfast, Continental Breakfast, Rural/Country.
 amenity_freCentre de fitness ou Spa, tennis, Cafetière dans la chambre, service de change, Portier, Centre d'Affaires, Service de photocopie, activités pour enfants, Location de voitures, boutique souvenirs, service de téléphone, plan de la famille, animaux domestiques admis, garde d'enfants, bureau du concierge, bureau d'excursions, petit déjeuner buffet, les repas, service en chambre, Ascenseurs, club de santé, piste de jogging, massage, sauna, Réception 24 heures, Porters, Service de réveil, air conditionné, sèche-cheveux disponibles, Chambres non fumeurs / Equipements, Salle de bain privée, parking gratuit, parking, golf, piscine extérieure, Lounge, Restaurant, 24 heures de sécurité, Docteur à l'appel, Service d'entretien, Nouvelles Stand, l'accès Internet à haute vitesse, chambres / équipements pour handicapés, Radio AM / FM Réveil, peignoirs , Salle de bains Téléphone, Bidet, Télévision par câble, jacuzzi, mini-bar, Téléphone, Contrôle de la température, TV, Coffre-fort, Outlet Adapters, TV satellite, nautique, plongée sous-marine, pêche, Service de secrétariat, location d'ordinateurs, Matériel audio-visuel, Repas - Chambres d'hôtes, petit déjeuner continental, rural / Pays.
 lowest_rate129.00
 lr_currencyEUR
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 City
 id344
 country_idIT
 state_id(null)
 maintrack_idRAGUSA
 nameRagusa
 main_key
 Country
 idIT
 nameItaly
 name_freItalie
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id8383
 hotel_id388
 order1
 urie_giubiliana_160.jpg
 ratio_hw0.67
 on_wall0
 1
 id8384
 hotel_id388
 order2
 urie_giubiliana_570.jpg
 ratio_hw0.67
 on_wall0
 2
 id8385
 hotel_id388
 order3
 urie_giubiliana_670.jpg
 ratio_hw0.67
 on_wall0
 3
 id8386
 hotel_id388
 order4
 urie_giubiliana_81_20.jpg
 ratio_hw0.67
 on_wall0
 4
 id8387
 hotel_id388
 order5
 urie_giubiliana_141_20.jpg
 ratio_hw0.67
 on_wall0
 5
 id8388
 hotel_id388
 order6
 urie_giubiliana_121_0.JPG
 ratio_hw1.00
 on_wall0
 6
 id8389
 hotel_id388
 order7
 urie_giubiliana_132_0.JPG
 ratio_hw1.00
 on_wall0
 7
 id8390
 hotel_id388
 order8
 urie_giubiliana_146_20.jpg
 ratio_hw0.68
 on_wall0
 8
 id8391
 hotel_id388
 order9
 urie_giubiliana_126_0.JPG
 ratio_hw1.00
 on_wall0
 Room
 0
 id1590
 typeOTH
 hotel_id388
 nameClassic
 descriptionClassic-1King-Garden View Phone-AC-TV-Safe-Minibar-Bathrobe-Max Occ 2
 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
 id1591
 typeOTH
 hotel_id388
 nameCottage
 descriptionCottage-1K-Ensuite-Veranda-Garden-View-Phone BBQ-Kitchenette-AC-TV-Safe-Minibar-MaxOcc2
 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
 id1592
 typeOTH
 hotel_id388
 nameDeluxe
 descriptionClassic-1King-Ensuite-Terrace-Garden View Phone-AC-TV-Safe-Minibar-Bathrobe-Max Occ 2
 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)
 3
 id1593
 typeOTH
 hotel_id388
 nameSuite della Guardia
 descriptionSuitedellaGuardia-1K-Ensuite- Exclusive-SatTV-AC-Jacuzzi-SittingArea-Fireplace-MaxOcc2
 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)
 4
 id1594
 typeOTH
 hotel_id388
 nameSuite del Frate Nero
 descriptionCottage-1K-Ensuite-Veranda-Garden-View-Phone BBQ-Kitchenette-AC-TV-Safe-Minibar-MaxOcc2
 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)
 5
 id1595
 typeOTH
 hotel_id388
 nameSuite del Gran Maestro
 descriptionSuite GranMaestro-1K-Ensuite- Luxury-2Balcony SittingRm-Views-AC-Bathrobe-SatTV-MaxOcc2
 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)
 6
 id1596
 typeOTH
 hotel_id388
 nameSuite Grande
 descriptionSuiteGrande-1King-Large Ensuite-2Floors-SatTV-LivingRm-PrivateCourtyard-AC-Safe-Max Occ 2
 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)
 7
 id1597
 typeOTH
 hotel_id388
 nameSuite Torre
 descriptionSuiteTorre-1K-Ensuite-3 Ancient Stone Rooms Courtyard-GunDisplay-StoneFireplace-MaxOcc2
 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)
 8
 id1598
 typeOTH
 hotel_id388
 nameSuite Torre del Canonico
 descriptionTorreCanonico-1K-Ensuite-3Floors-LgeTerrace-xceptionalViews-SatTV-AC-LivingRm-MaxOcc2
 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)
 9
 id1599
 typeOTH
 hotel_id388
 nameSuperior
 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
 id968
 starred0
 in0
 maintrack_hotel_id(null)
 brand_code
 nameLocanda Don Serafino
 addressVia XI Febbraio, 15
 zip_code97100
 cityarea_id(null)
 city_id920
 region_id(null)
 state_id(null)
 country_idIT
 latitude36.9271677
 longitude14.7379919
 zoom12
 rating0
 phone(null)
 reservation_phone(null)
 fax(null)
 email(null)
 created2011-09-01 13:59:02
 modified2011-09-01 14:09:56
 descriptionThe scene is Ibla, Ragusa's historic center. La Locanda Don Serafino is situated in the heart of Baroque, recently inscribed on World Heritage List of Unesco, in a 19th century mansion tastefully renovated: it offers ten elegant and comfortable rooms, provided with all services. An enchanting place, with only 22 beds for clients who wish to have a memorable stay. The restaurant is also unique within walking distance is one of the best restaurants in Sicily for its cuisine and wines.
 description_freLe décor est Ibla, le centre historique de Raguse. La Locanda Don Serafino est situé en plein coeur du quartier baroque, récemment inscrit sur la liste du patrimoine mondial de l'Unesco, dans un manoir du 19ème siècle rénovée avec goût: il propose dix chambres élégantes et confortables, fourni avec tous les services. Un lieu enchanteur, avec 22 lits seulement, pour les clients qui souhaitent avoir un séjour inoubliable. Le restaurant est lui aussi unique, à distance de marche, c'est l'un des meilleurs restaurants en Sicile pour sa cuisine et ses vins.
 amenityAir conditioning: autonomous adjustable heating system (Hot/Cold), Special rooms for disabled are available, Private and fully equipped beach in Marina di Ragusa (20 km. away), Breakfast hall and Bar: Breakfast from 7.30 to 11.00: Sweet and savoury food, mostly based on typical local products, Reading room: Excavated in the rock, it has got comfortable sofas.
 amenity_freAir conditionné: système autonome de chauffage réglable (chaud / froid), des chambres spéciales pour handicapés sont disponibles, plage privée et entièrement équipée à Marina di Ragusa (20 km.), Salle de petit déjeuner et Bar: Petit déjeuner 7,30 à 11,00: sucrés et salés, principalement basée sur des produits typiques locaux, Salle de lecture: creusés dans la roche est pourvu de canapés confortables.
 lowest_rate135.00
 lr_currencyEUR
 lr_people2
 comment_count0
 cancellation_policyCancellation policy: Cancellation of 8 to 4 days before arrival: 50% of stay charge 3 to 0 days before arrival: 100% of stay (in the absence of such a prepayment penalty will be charged from your credit card) for an early departure: The remaining nights will be charged. Payment: The credit card is only used to guarantee reservations We accept: Cash, Transfers, Cash, Visa, Mastercard, Amex Terms of price: Rates include breakfast and taxes. Check-in: the rooms are available from 15.00 pm Check-out: rooms must be vacated by 12.00; Pets are not allowed.
 cancellation_policy_frePolitique d'annulation: Annulation de 8 à 4 jours avant l'arrivée: 50% du séjour de frais de 3 à 0 jours avant l'arrivée: 100% du séjour (en l'absence d'une telle pénalité pour remboursement anticipé sera prélevé à partir de votre carte de crédit) pour un départ anticipé: Les nuits restantes seront également facturés. Modalités de paiement: La carte de crédit n'est utilisé que pour garantir les réservations Nous acceptons: Espèces, Virements, Espèces, Visa, Mastercard, Amex Conditions de tarif: Les tarifs comprennent le petit déjeuner et les taxes. Check-in: les chambres sont disponibles à partir de 15.00 heures, Check-out: les chambres doivent être libérées à 12.00; animaux ne sont pas autorisés.
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id920
 country_idIT
 state_id(null)
 maintrack_id(null)
 nameRagusa Ibla (RG)
 main_key(null)
 Country
 idIT
 nameItaly
 name_freItalie
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id14867
 hotel_id968
 order1
 urihotel-esterno20.jpg
 ratio_hw0.67
 on_wall0
 1
 id14868
 hotel_id968
 order2
 urihotel-hall30.jpg
 ratio_hw0.67
 on_wall0
 2
 id14869
 hotel_id968
 order3
 uri5_g0.jpg
 ratio_hw0.67
 on_wall0
 3
 id14870
 hotel_id968
 order4
 uri10_g0.jpg
 ratio_hw0.67
 on_wall0
 4
 id14871
 hotel_id968
 order5
 uri41_g0.jpg
 ratio_hw0.67
 on_wall0
 5
 id14872
 hotel_id968
 order6
 urihotel-stanze20.jpg
 ratio_hw0.67
 on_wall0
 6
 id14873
 hotel_id968
 order7
 urihotel-stanze60.jpg
 ratio_hw0.67
 on_wall0
 7
 id14874
 hotel_id968
 order8
 urihotel-stanze30.jpg
 ratio_hw0.67
 on_wall0
 Room
 0
 id3816
 type
 hotel_id968
 nameSTANDARD FRANCESE
 description
 name_freSTANDARD FRANCESE
 description_fre
 lowest_rate135.00
 lr_currencyEUR
 lr_people2
 breakfast_included1
 half_board0
 all_inclusive0
 full_board0
 accomodation_only0
 1
 id3817
 type
 hotel_id968
 nameSTANDARD 3
 description
 name_freSTANDARD 3
 description_fre
 lowest_rate148.00
 lr_currencyEUR
 lr_people2
 breakfast_included1
 half_board0
 all_inclusive0
 full_board0
 accomodation_only0
 2
 id3818
 type
 hotel_id968
 nameJUNIOR SUITE
 description
 name_freSUITE JUNIOR
 description_fre
 lowest_rate195.00
 lr_currencyEUR
 lr_people2
 breakfast_included1
 half_board0
 all_inclusive0
 full_board0
 accomodation_only0
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id1575
 localeeng
 modelHotel
 foreign_key968
 fieldtagline
 content
 1
 id1576
 localefre
 modelHotel
 foreign_key968
 fieldtagline
 content
 Envie
 0
 id3
 created2011-05-17 19:21:37
 modified2011-05-17 19:21:37
 1
 id5
 created2011-05-17 19:24:26
 modified2011-05-17 19:24:26
 2
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 3
 id22
 created2011-05-24 08:23:46
 modified2011-05-24 08:23:46
 1
 Hotel
 id1473
 starred0
 in0
 maintrack_hotel_id507637
 brand_codeOK
 nameAlgila' Ortigia Charme Hotel
 addressVia Vittorio Veneto 93
 zip_code96100
 cityarea_id(null)
 city_id1384
 region_id(null)
 state_id(null)
 country_idIT
 latitude37.0626924
 longitude15.296135
 zoom13
 rating4
 phone39 0931 465186
 reservation_phone(null)
 fax(null)
 emailinfo@algila.it
 created2012-02-09 16:17:11
 modified2012-02-13 09:19:55
 descriptionThe hotel is located on the waterfront, in the hearth of Ortigia, the historic centre of Siracusa. It gives onto the ancient "Mastra Rua" where the Siracusan nobility resided as far back as the 14th. The property restoration has carefully mantained the original structure which is made up of 3 buildings. All of the rooms are furnished differently with a refined interior design, featuring individual and distinctive decors which incorporate antique furniture. Mediterranean style bathroom tiles and four-poster beds. The furnishings and fittings have been restored and include the traditional Sicilian touches.
 description_freL'hôtel est situé sur le front de mer, dans le quartier d'Ortigia, le centre historique de Syracuse. Il donne sur l'ancienne "Rua Mastra" où la noblesse de Syracuse résidait au 14ème siècle. La restauration de l propriété a été soigneusement entretenue dans sa structure originale qui se compose de 3 bâtiments. Toutes les chambres sont meublées différemment avec une décoration intérieure raffiné, avec des décors individuels et distinctif qui incorporent des meubles anciens. Des carreaux méditerranéens dans la salle de bain et des lits à baldaquin. Le mobilier et les accessoires ont été restaurés, et incluent les touches traditionnelles siciliennes.
 amenityRestaurant, High speed internet access, Wireless Internet Access, Wheel Chair Access, Lounge, Air Conditioned, Internet Access, Beach,
 amenity_freRestaurant, Accès pour chaises roulantes, Salon, Climatisation, Plage.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id1384
 country_idIT
 state_id(null)
 maintrack_idSIRACUSA
 nameSyracuse
 main_key
 Country
 idIT
 nameItaly
 name_freItalie
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id21675
 hotel_id1473
 order11
 uriAlgila-31.jpg
 ratio_hw0.67
 on_wall0
 1
 id21676
 hotel_id1473
 order12
 uricamere-172.jpg
 ratio_hw0.67
 on_wall0
 2
 id21670
 hotel_id1473
 order9
 uricamere-90.jpg
 ratio_hw0.67
 on_wall0
 3
 id21671
 hotel_id1473
 order10
 uricamere-00.jpg
 ratio_hw0.67
 on_wall0
 4
 id21668
 hotel_id1473
 order7
 uriAlgila-5_20.jpg
 ratio_hw0.67
 on_wall0
 5
 id21669
 hotel_id1473
 order8
 uricamere-50.jpg
 ratio_hw0.67
 on_wall0
 6
 id21666
 hotel_id1473
 order5
 uriexecutive020.jpg
 ratio_hw0.67
 on_wall0
 7
 id21667
 hotel_id1473
 order6
 uricamere-100.jpg
 ratio_hw0.67
 on_wall0
 8
 id21664
 hotel_id1473
 order3
 uriAlgila-0_20.jpg
 ratio_hw0.67
 on_wall0
 9
 id21665
 hotel_id1473
 order4
 uricamere-70.jpg
 ratio_hw0.67
 on_wall0
 10
 id21662
 hotel_id1473
 order1
 uriAlgila-70.jpg
 ratio_hw0.67
 on_wall0
 11
 id21663
 hotel_id1473
 order2
 uriAlgila-10.jpg
 ratio_hw0.67
 on_wall0
 Room
 0
 id5730
 typeOTH
 hotel_id1473
 nameClassic Double Room
 descriptionClassic Double or twin beds rooms, private bathroom, sattv, ddphone, safe.
 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
 1
 id5731
 typeOTH
 hotel_id1473
 nameExecutive Double Room
 descriptionExecutive King size bed, private bathroom, sattv, ddphone, safe, solarium, hydro-massage bath on the private terrace
 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
 2
 id5732
 typeOTH
 hotel_id1473
 nameJunior Suite
 descriptionJuniorSuite with living area. Comfortable for 3 persons.
 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
 3
 id5733
 typeOTH
 hotel_id1473
 nameSingle Room
 descriptionCosy and smart classic single room, private bathroom, sattv, ddphone, safe
 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
 4
 id5734
 typeOTH
 hotel_id1473
 nameClassic Double Standard sea View
 descriptionStandard double or twin bedded room, seaview, private bathroom, sattv, ddphone, safe
 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
 5
 id5735
 typeOTH
 hotel_id1473
 nameJunior Suite Sea View
 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
 id2535
 localeeng
 modelHotel
 foreign_key1473
 fieldtagline
 content
 1
 id2536
 localefre
 modelHotel
 foreign_key1473
 fieldtagline
 content
 Envie
 0
 id3
 created2011-05-17 19:21:37
 modified2011-05-17 19:21:37
 1
 id5
 created2011-05-17 19:24:26
 modified2011-05-17 19:24:26
 2
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 3
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 4
 id22
 created2011-05-24 08:23:46
 modified2011-05-24 08:23:46
 5
 id29
 created2011-10-11 17:12:25
 modified2011-10-11 17:12:25
 2
 Hotel
 id907
 starred0
 in0
 maintrack_hotel_id374111
 brand_codeON
 nameAgriturismo Sicilia Monaco di Mezzo
 addressContrada Monaco di Mezzo
 zip_code93010
 cityarea_id(null)
 city_id865
 region_id(null)
 state_id(null)
 country_idIT
 latitude37.652359
 longitude14.0723
 zoom13
 rating0
 phone39 0934673949
 reservation_phone(null)
 fax39 0934673949
 emailinfo@monacodimezzo.com
 created2011-08-28 18:45:58
 modified2011-08-30 08:47:58
 descriptionThe farm is equipped with a variety of self-contained apartments, a restaurant and community area all of which are harmoniously in keeping with the surroundings. The warmth of timber and local stone frame the spectacular views from this natural haven of rest, without a sign of human pollution but with the perpetual beauty of the seasonally changing colour. Many sports facilities are available, ranging from horse-riding to trekking; there is the nearby Madonie National Park and Nature Conservation Area with its history and art; there are local wines, olive oil, cheeses, preserves, home-cured meats and home-reared beef to taste, all things to make a stay varied and enjoyable.
 description_freLa ferme est équipée d'une variété d'appartements indépendants, un espace de restauration qui sont tous en harmonie avec les environs. La chaleur du bois et le cadre en pierre locale avec des vues spectaculaires sur un havre de repos naturel, sans source de pollution humaine, mais avec la beauté des couleurs changeantes selon les saisons. De nombreuses installations sportives sont disponibles, allant de l'équitation à la randonnée à proximité du parc national des Madonie et de l'aire de conservation de la nature. Vous trouverez des vins locaux, huile d'olive, fromages, confitures, charcuterie maison, toutes les choses pour faire un séjour varié et agréable.
 amenityAir Conditioned, Free Parking, Outdoor Parking, Parking, Pool, Tour Desk, Wake-up Service, AM/FM Alarm Clock, Bath Tub, Bidet, TV, Hairdryers Available, Mini Bar, Refrigerator, TV Remote Control, Smoke Detectors, Telephone, WC, Shower, Kitchen, Horseback Riding, Tennis, Billiards / Pool Tables, Childrens Activities, Meal Plan - American, Meal Plan - Bed and Breakfast, Meal Plan - MAP/Half-board, Meal Plan - Bermuda,
 amenity_freClimatisation, Parking gratuit, Parking en plein air, Parking, Piscine, Agence de voyage, Service de réveil, Radio-réveil AM/FM, Baignoire, Bidet, TV, Sèches-cheveux, Mini-bar, Réfrigérateur, Télécommande TV, Détecteurs de fumée, Téléphone, WC, Douche, Cuisine, Equitation, Tennis, Pension complète, Bed and breakfast, Demi-pension (DP), Petit déjeuner anglais.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id865
 country_idIT
 state_id(null)
 maintrack_idCIOLINO
 nameCiolino
 main_key
 Country
 idIT
 nameItaly
 name_freItalie
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id13965
 hotel_id907
 order2
 urihttp://images.pegs.com/imageRepo/1/0/24/392/789/ON1163194_Ext1_j_J.jpg
 ratio_hw0.81
 on_wall0
 1
 id13966
 hotel_id907
 order3
 urihttp://images.pegs.com/imageRepo/1/0/24/392/793/ON1163194_Ext2_j_J.jpg
 ratio_hw0.67
 on_wall0
 2
 id13967
 hotel_id907
 order4
 urihttp://images.pegs.com/imageRepo/1/0/24/392/797/ON1163194_Ext3_j_J.jpg
 ratio_hw0.67
 on_wall0
 3
 id13968
 hotel_id907
 order5
 urihttp://images.pegs.com/imageRepo/1/0/24/392/801/ON1163194_Msc1_j_J.jpg
 ratio_hw0.67
 on_wall0
 4
 id13969
 hotel_id907
 order6
 urihttp://images.pegs.com/imageRepo/1/0/24/392/805/ON1163194_Msc2_j_J.jpg
 ratio_hw0.67
 on_wall0
 5
 id13970
 hotel_id907
 order7
 urihttp://images.pegs.com/imageRepo/1/0/24/392/809/ON1163194_Pool1_j_J.jpg
 ratio_hw0.67
 on_wall0
 6
 id13971
 hotel_id907
 order8
 urihttp://images.pegs.com/imageRepo/1/0/24/392/813/ON1163194_Room1_j_J.jpg
 ratio_hw0.93
 on_wall0
 7
 id13972
 hotel_id907
 order9
 urihttp://images.pegs.com/imageRepo/1/0/24/392/817/ON1163194_Room2_j_J.jpg
 ratio_hw1.00
 on_wall0
 8
 id13973
 hotel_id907
 order10
 urihttp://images.pegs.com/imageRepo/1/0/24/392/821/ON1163194_Room3_j_J.jpg
 ratio_hw0.92
 on_wall0
 Room
 0
 id3590
 typeOTH
 hotel_id907
 nameDouble Room
 descriptionDouble Room for two people. The warmth of timber and local stone frame this double room. Bedlinens and towels included. Equipped with private bathroom, radio and Tv, air conditioning, minibar
 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
 1
 id3591
 typeOTH
 hotel_id907
 nameQuadruple Room
 descriptionFirst floor - 4 / 6 guests. Quadruple Room. Equipped with a sofa bed, kitchen, bedlinens and towels
 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
 2
 id3592
 typeOTH
 hotel_id907
 nameTriple 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
 id1451
 localeeng
 modelHotel
 foreign_key907
 fieldtagline
 content
 1
 id1452
 localefre
 modelHotel
 foreign_key907
 fieldtagline
 content
 Envie
 0
 id14
 created2011-05-17 19:27:21
 modified2011-09-01 11:30:03
 1
 id18
 created2011-05-17 19:28:28
 modified2011-05-17 19:28:28
 2
 id23
 created2011-05-24 08:28:10
 modified2011-05-24 08:28:10
- relatedEvents
 0
 Event
 id908
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationVico San Giorgio, 97100 Raguse, Italie
 latitude36.926
 longitude14.7419
 zoom11
 state_id(null)
 country_id
 created2011-08-05 16:47:10
 modified2011-08-05 16:47:10
 url(null)
 comment_count0
 former_business_id516
 localefre
 nameEGLISE SAN GIORGIO
 descriptionC'est l'une des églises les plus extraordinaires de Sicile, sa décoration en marbre vous surprendra.
 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
 id5419
 localeeng
 modelEvent
 foreign_key908
 fieldname
 contentSAN GIROGIO CHURCH
 1
 id5420
 localefre
 modelEvent
 foreign_key908
 fieldname
 contentEGLISE SAN GIORGIO
 Descriptions
 0
 id5421
 localeeng
 modelEvent
 foreign_key908
 fielddescription
 contentThis is one of the most extraordinary churches in Sicily, its marble decoration will surprise you.
 1
 id5422
 localefre
 modelEvent
 foreign_key908
 fielddescription
 contentC'est l'une des églises les plus extraordinaires de Sicile, sa décoration en marbre vous surprendra.
 Links
 0
 id5423
 localeeng
 modelEvent
 foreign_key908
 fieldlink
 content
 1
 id5424
 localefre
 modelEvent
 foreign_key908
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 1
 Event
 id633
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location95043 Militello in Val di Catania Catane, Italie
 latitude37.2759
 longitude14.7943
 zoom8
 state_id(null)
 country_id
 created2011-07-12 16:55:53
 modified2011-07-12 16:55:53
 url(null)
 comment_count0
 former_business_id241
 localefre
 nameVILLES DU BAROQUE TARDIF
 descriptionLes huit villes du sud-est de la Sicile : Caltagirone, Militello Val di Catania, Catane, Modica, Noto, Palazzolo, Raguse et Scicli -- ont toutes été reconstruites après 1693.
 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
 id3769
 localeeng
 modelEvent
 foreign_key633
 fieldname
 contentLATE BAROCCO CITYS
 1
 id3770
 localefre
 modelEvent
 foreign_key633
 fieldname
 contentVILLES DU BAROQUE TARDIF
 Descriptions
 0
 id3771
 localeeng
 modelEvent
 foreign_key633
 fielddescription
 contentThe eight towns in south-eastern Sicily - Caltagirone, Militello Val di Catania, Catania, Modica, Noto, Palazzolo, Ragusa and Scicli - were all rebuilt after 1693.
 1
 id3772
 localefre
 modelEvent
 foreign_key633
 fielddescription
 contentLes huit villes du sud-est de la Sicile : Caltagirone, Militello Val di Catania, Catane, Modica, Noto, Palazzolo, Raguse et Scicli -- ont toutes été reconstruites après 1693.
 Links
 0
 id3773
 localeeng
 modelEvent
 foreign_key633
 fieldlink
 content
 1
 id3774
 localefre
 modelEvent
 foreign_key633
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 2
 Event
 id533
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationRiserva Naturale Oasi Faunistica Vendicari, 96017 Noto Syracuse, Italie
 latitude36.8052
 longitude15.0918
 zoom10
 state_id(null)
 country_id
 created2011-07-11 13:57:16
 modified2011-07-11 13:57:16
 url(null)
 comment_count0
 former_business_id141
 localefre
 nameRESERVE DE VENDICARI
 descriptionNe ratez pas la réserve naturelle de Vendicari
 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
 id3169
 localeeng
 modelEvent
 foreign_key533
 fieldname
 contentVENDICARI RESERVE
 1
 id3170
 localefre
 modelEvent
 foreign_key533
 fieldname
 contentRESERVE DE VENDICARI
 Descriptions
 0
 id3171
 localeeng
 modelEvent
 foreign_key533
 fielddescription
 contentDon't miss to go to Vendicari natural reserve.
 1
 id3172
 localefre
 modelEvent
 foreign_key533
 fielddescription
 contentNe ratez pas la réserve naturelle de Vendicari
 Links
 0
 id3173
 localeeng
 modelEvent
 foreign_key533
 fieldlink
 content
 1
 id3174
 localefre
 modelEvent
 foreign_key533
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 3
 Event
 id632
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationPantalica, 96010 Sortino Syracuse, Italie
 latitude37.1253
 longitude15.0166
 zoom8
 state_id(null)
 country_id
 created2011-07-12 16:53:50
 modified2011-07-12 16:53:50
 url(null)
 comment_count0
 former_business_id240
 localefre
 nameSYRACUSE ET LA NECROPOLE DE PANTALICA
 descriptionla Nécropole de Pantalica compte plus de 5000 tombes taillées dans la roche près de carrières à ciel ouvert et datant pour l’essentiel de la période comprise entre le XIIIe et le VIIe siècle av. J.-C.
 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
 id3763
 localeeng
 modelEvent
 foreign_key632
 fieldname
 contentSIRACUSA AND THE PANTALICA NECROPOLIS
 1
 id3764
 localefre
 modelEvent
 foreign_key632
 fieldname
 contentSYRACUSE ET LA NECROPOLE DE PANTALICA
 Descriptions
 0
 id3765
 localeeng
 modelEvent
 foreign_key632
 fielddescription
 contentNecropolis of Pantalica has over 5,000 tombs cut into the rock near open pits and dating mainly from the period between the thirteenth and seventh century BC. AD
 1
 id3766
 localefre
 modelEvent
 foreign_key632
 fielddescription
 contentla Nécropole de Pantalica compte plus de 5000 tombes taillées dans la roche près de carrières à ciel ouvert et datant pour l’essentiel de la période comprise entre le XIIIe et le VIIe siècle av. J.-C.
 Links
 0
 id3767
 localeeng
 modelEvent
 foreign_key632
 fieldlink
 content
 1
 id3768
 localefre
 modelEvent
 foreign_key632
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 4
 Event
 id631
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationVilla Romana del Casale, 94015 Piazza Armerina Enna, Italie
 latitude37.3665
 longitude14.336
 zoom7
 state_id(null)
 country_id
 created2011-07-12 16:50:39
 modified2011-07-12 16:50:39
 url(null)
 comment_count0
 former_business_id239
 localefre
 nameVILLA ROMAINE DU CASALE
 descriptionL'exploitation de la campagne à la période romaine est symbolisée par la villa, centre du grand domaine sur lequel était fondée l'économie rurale de l'empire d'Occident.
 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
 id3757
 localeeng
 modelEvent
 foreign_key631
 fieldname
 contentVILLA ROMANA DEI CASALE
 1
 id3758
 localefre
 modelEvent
 foreign_key631
 fieldname
 contentVILLA ROMAINE DU CASALE
 Descriptions
 0
 id3759
 localeeng
 modelEvent
 foreign_key631
 fielddescription
 contentThe exploitation of the countryside to the Roman period is symbolized by the villa, the center of the large estate which was based on the rural economy of the Western Empire.
 1
 id3760
 localefre
 modelEvent
 foreign_key631
 fielddescription
 contentL'exploitation de la campagne à la période romaine est symbolisée par la villa, centre du grand domaine sur lequel était fondée l'économie rurale de l'empire d'Occident.
 Links
 0
 id3761
 localeeng
 modelEvent
 foreign_key631
 fieldlink
 content
 1
 id3762
 localefre
 modelEvent
 foreign_key631
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 5
 Event
 id529
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationVia Santa Barbara, 67, 95124 Catane, Italie
 latitude37.5029
 longitude15.0797
 zoom10
 state_id(null)
 country_id
 created2011-07-11 13:46:43
 modified2011-07-11 13:46:43
 url(null)
 comment_count0
 former_business_id137
 localefre
 nameRESTAURANT LE TERRAZZE DI VICO
 descriptionUn endroit secret pour déguster des fruits de mer, réservez !
 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
 id3145
 localeeng
 modelEvent
 foreign_key529
 fieldname
 contentRESTAURANT LA TERRAZZE DI VICO
 1
 id3146
 localefre
 modelEvent
 foreign_key529
 fieldname
 contentRESTAURANT LE TERRAZZE DI VICO
 Descriptions
 0
 id3147
 localeeng
 modelEvent
 foreign_key529
 fielddescription
 contentThis is a secret place for eating seafoods. Book before!
 1
 id3148
 localefre
 modelEvent
 foreign_key529
 fielddescription
 contentUn endroit secret pour déguster des fruits de mer, réservez !
 Links
 0
 id3149
 localeeng
 modelEvent
 foreign_key529
 fieldlink
 content
 1
 id3150
 localefre
 modelEvent
 foreign_key529
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 6
 Event
 id530
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationPiazza Duomo, Piazza del Duomo, 95124 Catane, Italie
 latitude37.5024
 longitude15.0873
 zoom9
 state_id(null)
 country_id
 created2011-07-11 13:49:50
 modified2011-07-11 13:49:50
 url(null)
 comment_count0
 former_business_id138
 localefre
 nameAMBASCIATA DEL MARE
 descriptionUn cadre raffiné pour manger des fruits de mer.
 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
 id3151
 localeeng
 modelEvent
 foreign_key530
 fieldname
 contentAMBASCIATA DEL MARE
 1
 id3152
 localefre
 modelEvent
 foreign_key530
 fieldname
 contentAMBASCIATA DEL MARE
 Descriptions
 0
 id3153
 localeeng
 modelEvent
 foreign_key530
 fielddescription
 contentA good restaurant for seafoods in a cozy place.
 1
 id3154
 localefre
 modelEvent
 foreign_key530
 fielddescription
 contentUn cadre raffiné pour manger des fruits de mer.
 Links
 0
 id3155
 localeeng
 modelEvent
 foreign_key530
 fieldlink
 content
 1
 id3156
 localefre
 modelEvent
 foreign_key530
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 7
 Event
 id532
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationVia Museo Biscari, 95131 Catane, Italie
 latitude37.5025
 longitude15.0904
 zoom12
 state_id(null)
 country_id
 created2011-07-11 13:55:41
 modified2011-07-11 13:55:41
 url(null)
 comment_count0
 former_business_id140
 localefre
 namePALAIS BISCARI
 descriptionVisitez le Palis Biscari du prince Moncada.
 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
 id3163
 localeeng
 modelEvent
 foreign_key532
 fieldname
 contentPALAZZO BISCARI
 1
 id3164
 localefre
 modelEvent
 foreign_key532
 fieldname
 contentPALAIS BISCARI
 Descriptions
 0
 id3165
 localeeng
 modelEvent
 foreign_key532
 fielddescription
 contentVisit the palazzo Biscari of the Prince Moncada.
 1
 id3166
 localefre
 modelEvent
 foreign_key532
 fielddescription
 contentVisitez le Palis Biscari du prince Moncada.
 Links
 0
 id3167
 localeeng
 modelEvent
 foreign_key532
 fieldlink
 content
 1
 id3168
 localefre
 modelEvent
 foreign_key532
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 8
 Event
 id907
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationEtna, 95012 Castiglione di Sicilia Catane, Italie
 latitude37.7544
 longitude14.9959
 zoom8
 state_id(null)
 country_id
 created2011-08-05 16:42:48
 modified2011-08-05 16:42:48
 url(null)
 comment_count0
 former_business_id515
 localefre
 nameVOLCAN ETNA
 descriptionL'Etna est le plus haut volcan en activité d'Europe (3.295 mètres), mais l'Etna est aussi l'un des plus actifs au monde. Prenez le car jusqu'à Rifugio Sapienza d'où part le téléphérique Funivia dell'Etna qui monte à 2500 m.
 linkwww.funiviaetna.com
 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
 id5413
 localeeng
 modelEvent
 foreign_key907
 fieldname
 contentETNA VOLCANO
 1
 id5414
 localefre
 modelEvent
 foreign_key907
 fieldname
 contentVOLCAN ETNA
 Descriptions
 0
 id5415
 localeeng
 modelEvent
 foreign_key907
 fielddescription
 contentEtna is the highest active volcano in Europe (3295 meters), but Etna is also one of the busiest in the world. Take the bus to Rifugio Sapienza, from where the cable Funivia dell'Etna that rises to 2500 m.
 1
 id5416
 localefre
 modelEvent
 foreign_key907
 fielddescription
 contentL'Etna est le plus haut volcan en activité d'Europe (3.295 mètres), mais l'Etna est aussi l'un des plus actifs au monde. Prenez le car jusqu'à Rifugio Sapienza d'où part le téléphérique Funivia dell'Etna qui monte à 2500 m.
 Links
 0
 id5417
 localeeng
 modelEvent
 foreign_key907
 fieldlink
 contentwww.funiviaetna.com
 1
 id5418
 localefre
 modelEvent
 foreign_key907
 fieldlink
 contentwww.funiviaetna.com
 Hotel(empty)
 Theme(empty)
 9
 Event
 id629
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location92100 Agrigente, Italie
 latitude37.3112
 longitude13.577
 zoom7
 state_id(null)
 country_id
 created2011-07-12 16:47:24
 modified2011-07-12 16:47:24
 url(null)
 comment_count0
 former_business_id237
 localefre
 nameZONE ARCHEOLOGIQUE AGRIGENTE
 descriptionColonie grecque fondée au VIe siècle av. J.-C., Agrigente est devenue l'une des principales cités du monde méditerranéen.
 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
 id3745
 localeeng
 modelEvent
 foreign_key629
 fieldname
 contentARCHEOLOGICAL AREA AGRIGENTE
 1
 id3746
 localefre
 modelEvent
 foreign_key629
 fieldname
 contentZONE ARCHEOLOGIQUE AGRIGENTE
 Descriptions
 0
 id3747
 localeeng
 modelEvent
 foreign_key629
 fielddescription
 contentGreek colony founded in the sixth century BC. BC, Agrigento became one of the major cities of the Mediterranean world.
 1
 id3748
 localefre
 modelEvent
 foreign_key629
 fielddescription
 contentColonie grecque fondée au VIe siècle av. J.-C., Agrigente est devenue l'une des principales cités du monde méditerranéen.
 Links
 0
 id3749
 localeeng
 modelEvent
 foreign_key629
 fieldlink
 content
 1
 id3750
 localefre
 modelEvent
 foreign_key629
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
- weather(false)
- meta_description_for_layoutA historical site dominating the Mediterranean sea in the midst of the pristine countryside of the Hyblean plateau. A charming hotel set in the historical residence of the ancient noble Nifosi family, a few kilometres south of Ragusa to the south of Tunisi, among carob forests and stone walls. Very old thick white dry-stone walls surround and protect the courtyards and inner structure. Its white towers overlook the plateau that gently slopes towards the sea and on clear days, which are common in these latitudes, you can see the island of Malta and the African Coast. It is surrounded by the typical dry-stone walls. The estate was part of an ecclesiastical feudal hold dating from the 12th century and was a sort of fortified fortress dominating the sea against the incursions of Barbary pirates. The Knights of Malta used the building in the first half of the 16th century. In the 18th century the Eremo was acquired by the Nifosi family of wealthy land-owners. The last heiress. Vincenza Jolanda Nifosi decided to restore it and open it to luxury hospitality. The lobby immediately reveals the character of the Eremo with white stone arches, polished peach-stone flooring with the white family symbol inlay, standing armour and old Sicilian style furniture in the sitting area. The intimacy of the inner stone courtyards make you feel at home, aromatic herbs and blooming plants and fruitful trees populate the garden which opens at the end with a small swimming pool, walks through the garden will make you discover a small fountain. Arab water systems and a necroplois dating back to the V century just at the back of the building. Candle-lit dinners take place in a big dining room, wine tasting and small meetings are held in the old Crypt. The guestrooms have been converted from the Friars cells, the exclusive suites were once the residences of the noble family or of the ecclesiastical relatives.
- 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
====

Rechercher une expérience

Se laisser guider

Rechercher un hôtel de charme

Rechercher par envie

Par pays

Eremo della Giubiliana

Ragusa, Italie

0 commentaires

Réserver cet hôtel

Les expériences proches de l'hôtel

Les promesses Globe Secret

Des hôtels de charme a taille humaine

RESERVATION SANS FRAIS

DES CRITERES DE CHOIX UNIQUES

PLUS DE SERVICES A LA CARTE

default

Query Explain:

Memory

Timers

warning

error

Rechercher une expérience

Se laisser guider

Rechercher un hôtel de charme

Rechercher par envie

Par pays

Eremo della Giubiliana

Ragusa, Italie

0 commentaires

Réserver cet hôtel

Les expériences proches de l'hôtel

Autres hôtels selon vos critères

Ragusa Ibla (RG), Italie Locanda Don Serafino

Syracuse, Italie Algila' Ortigia Charme Hotel

Ciolino, Italie Agriturismo Sicilia Monaco di Mezzo

En savoir plus

Brèves

Les promesses Globe Secret

Des hôtels de charme a taille humaine

RESERVATION SANS FRAIS

DES CRITERES DE CHOIX UNIQUES

PLUS DE SERVICES A LA CARTE

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

warning

error

View Variables

Ragusa Ibla (RG), Italie
Locanda Don Serafino

Syracuse, Italie
Algila' Ortigia Charme Hotel

Ciolino, Italie
Agriturismo Sicilia Monaco di Mezzo