Les Etangs de Corot

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
  time1679928730
  timeout10
  languagefre
====
Request
+ –
Request

Cake Params
- controllerhotels
- actionview
- named(empty)
- pass
 0362
 1les-etangs-de-corot
- languagefr
- plugin(null)
- url
 exthtml
 urlfr/hotels/voir/362/les-etangs-de-corot
- form(empty)
- isAjax(false)
$_GET
- urlfr/hotels/voir/362/les-etangs-de-corot
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	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` = '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` = 362 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` = 323	1	1	0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'FR'	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` = (362)	37	37	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` = (362)	6	6	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 (1455, 1456, 1457, 1458, 1459, 1460)	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` = (362) 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` = 'FR' ORDER BY `News`.`created` DESC	2	2	2
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` != 362 AND `Hotel`.`longitude` BETWEEN 0.8155051585912 AND 3.5510408414088 AND `Hotel`.`latitude` BETWEEN 47.92152204058 AND 49.72259795942 ORDER BY ABS(`Hotel`.`longitude` - 2.183273) + ABS(`Hotel`.`latitude` - 48.82206) 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 (374, 1051, 767)	20	20	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 (374, 1051, 767)	4	4	2	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 (374, 1051, 767)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (374, 1051, 767)	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 (374, 1051, 767)	1	1	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 (374, 1051, 767)	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 (374, 1051, 767)	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 (374, 1051, 767) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	9	9	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 0.8155051585912 AND 3.5510408414088 AND `Event`.`latitude` BETWEEN 47.92152204058 AND 49.72259795942 ORDER BY ABS(`Event`.`longitude` - 2.183273) + ABS(`Event`.`latitude` - 48.82206) ASC LIMIT 10	10	10	12	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928)	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 (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928)	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 (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928)	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 (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928)	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 (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928)	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 (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928)	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 (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928) 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 (634, 759, 1938, 1922, 760, 761, 952, 762, 758, 928) 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` = 362 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` = 362 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 27,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: 1245 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	78,57
Component initialization and startup	6,48
Controller action	634,05
Render Controller Action	409,30
» Rendering View	405,99
» » Rendering APP/views/hotels/view.ctp	351,91
» » » Rendering APP/views/elements/sharing_widget.ctp	0,20
» » » Rendering APP/views/elements/comments/flat/main.ctp	0,40
» » » Rendering APP/views/elements/hotels/form_reservation.ctp	3,27
» » » Rendering APP/views/elements/events/related.ctp	0,94
» » » Rendering APP/views/elements/events/related.ctp #2	0,99
» » » Rendering APP/views/elements/events/related.ctp #3	0,95
» » » Rendering APP/views/elements/events/related.ctp #4	0,95
» » » Rendering APP/views/elements/events/related.ctp #5	0,97
» » » Rendering APP/views/elements/events/related.ctp #6	1,03
» » » Rendering APP/views/elements/events/related.ctp #7	0,94
» » » Rendering APP/views/elements/events/related.ctp #8	0,90
» » » Rendering APP/views/elements/events/related.ctp #9	0,93
» » » Rendering APP/views/elements/events/related.ctp #10	0,96
» » » Rendering APP/views/elements/events/legend.ctp	1,83
» » » Rendering APP/views/elements/hotels/related.ctp #11	2,41
» » » Rendering APP/views/elements/hotels/related.ctp #12	0,73
» » » Rendering APP/views/elements/hotels/related.ctp #13	0,55
» » Rendering APP/views/layouts/default.ctp	53,85
» » » Rendering APP/views/elements/google_analytics.ctp	0,09
» » » Rendering APP/views/elements/layout/top.ctp	1,71
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0,32
» » » Rendering APP/views/elements/layout/header.ctp	46,92
» » » Rendering APP/views/elements/layout/extra.ctp	0,18
» » » Rendering APP/views/elements/layout/footer.ctp	3,69
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0,34
» » » Rendering APP/views/elements/layout/footnotes.ctp	0,09

====

Log

+ –

Logs

warning

Time	Message
2023-03-27 06:52:11	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]
2023-03-27 06:52:11	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
2023-03-27 06:52:11	Impossible to access the Google API
2023-03-27 06:52:11	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
 id362
 starred0
 in0
 maintrack_hotel_id356794
 brand_code000194
 nameLes Etangs de Corot
 address53 rue de Versailles
 zip_code92410
 cityarea_id(null)
 city_id323
 region_id(null)
 state_id(null)
 country_idFR
 latitude48.82206
 longitude2.183273
 zoom13
 rating4
 phone33 1 41153700
 reservation_phone(null)
 fax(null)
 emailcontact@etangs-corot.com
 created2011-05-13 21:08:51
 modified2011-06-07 18:00:35
 descriptionA picturesque retreat surrounded by lakes and gardens, Les Etangs de Corot nestles in Ville d'Avray, a beautiful setting that has attracted artists and writers for over 200 years, yet just 15 minutes from Paris. Blending into its pretty surrounds, the hotel has an imaginative and contemporary collection of rooms, a choice of three restaurants and a unique Caudalie Vinotherapie Spa. Named after the landscape that inspired the 19th century artist, Jean-Baptiste Camille Corot, a precursor of Impressionism, the hotel's ambience is warm and light. The rooms, decorated in pastel shades, are individually designed, most with views over the gardens and lakes. Enjoy the relaxing treatments at the Caudalie Vinotherapie Spa, then wander through the gardens to admire the beauty of the lakes that motivated Corot. Dine on one of the restaurant terraces which have breathtaking views over the lakes. Les Etangs de Corot is a Small Luxury Hotels of the World property.
 description_freUne retraite pittoresque entouré de lacs et de jardins, Les Etangs de Corot est niché à Ville d'Avray, un cadre magnifique qui a attiré les artistes et les écrivains pendant plus de 200 ans, mais à seulement 15 minutes de Paris. Se fondant dans ses jolies environs, l'hôtel dispose d'une collection originale et contemporaine de chambres, un choix de trois restaurants et un Spa unique Caudalie Vinothérapie. Décrite d'après le paysage qui a inspiré l'artiste du 19ème siècle, Jean-Baptiste Camille Corot, précurseur de l'impressionnisme, l'ambiance de l'hôtel est chaleureuse. Les chambres, décorées dans des tons pastel, sont conçues individuellement, la plupart avec vue sur les jardins et les lacs. Profitez des traitements de détente au Spa Vinothérapie Caudalie, puis flânez dans les jardins pour admirer la beauté des lacs qui ont inspiré Corot. Dînez sur l'une des terrasses de restaurants qui ont une vue imprenable sur les lacs. Les Etangs de Corot est membre de Small Luxury Hotels of the World.
 amenityRoom Service, Internet Access, High speed internet access, Telephone, City Center.
 amenity_freService en chambre, accès internet, accès internet haut débit, Téléphone, Centre Ville.
 lowest_rate196.00
 lr_currencyEUR
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 City
 id323
 country_idFR
 state_id(null)
 maintrack_idVILLEDAVRAY
 nameVille D Avray
 main_key
 Country
 idFR
 nameFrance
 name_freFrance
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id6610
 hotel_id362
 order2
 urihttp://images.pegs.com/imageRepo/1/0/26/134/793/visu4_J.jpg
 ratio_hw0.66
 on_wall0
 1
 id6611
 hotel_id362
 order3
 urihttp://images.pegs.com/imageRepo/1/0/27/991/444/Les%20Etangs%20de%20Corot%20001_J.jpg
 ratio_hw0.58
 on_wall0
 2
 id6612
 hotel_id362
 order4
 urihttp://images.pegs.com/imageRepo/1/0/27/991/448/Chambre%20junior%20suite%2027-3_J.jpg
 ratio_hw0.67
 on_wall0
 3
 id6613
 hotel_id362
 order5
 urihttp://images.pegs.com/imageRepo/1/0/26/134/828/Corot_06%2009_0289_J.jpg
 ratio_hw0.67
 on_wall0
 4
 id6614
 hotel_id362
 order6
 urihttp://images.pegs.com/imageRepo/1/0/26/134/868/Corot_06%2009_0357-2_J.jpg
 ratio_hw0.67
 on_wall0
 5
 id6615
 hotel_id362
 order7
 urihttp://images.pegs.com/imageRepo/1/0/26/134/892/Corot_06%2009_0297_J.jpg
 ratio_hw0.67
 on_wall0
 6
 id6616
 hotel_id362
 order8
 urihttp://images.pegs.com/imageRepo/1/0/26/134/910/Alfred%20de%20Musset_J.jpg
 ratio_hw0.68
 on_wall0
 7
 id6617
 hotel_id362
 order9
 urihttp://images.pegs.com/imageRepo/1/0/27/991/462/Junior%20suite%20Monet_J.jpg
 ratio_hw0.67
 on_wall0
 8
 id6618
 hotel_id362
 order10
 urihttp://images.pegs.com/imageRepo/1/0/26/134/924/Suite%20Baron%20Thierry_J.jpg
 ratio_hw0.67
 on_wall0
 9
 id6619
 hotel_id362
 order11
 urihttp://images.pegs.com/imageRepo/1/0/26/134/934/Junior%20suite%20Offenbach_J.jpg
 ratio_hw0.67
 on_wall0
 10
 id6620
 hotel_id362
 order12
 urihttp://images.pegs.com/imageRepo/1/0/26/134/944/Corot_06%2009_0062_J.jpg
 ratio_hw0.67
 on_wall0
 11
 id6621
 hotel_id362
 order13
 urihttp://images.pegs.com/imageRepo/1/0/26/134/972/Corot_06%2009_0268_J.jpg
 ratio_hw0.67
 on_wall0
 12
 id6622
 hotel_id362
 order14
 urihttp://images.pegs.com/imageRepo/1/0/27/991/474/Restaurant%202_J.jpg
 ratio_hw0.66
 on_wall0
 13
 id6623
 hotel_id362
 order15
 urihttp://images.pegs.com/imageRepo/1/0/26/135/32/Corot_06%2009_0508_J.jpg
 ratio_hw0.67
 on_wall0
 14
 id6624
 hotel_id362
 order16
 urihttp://images.pegs.com/imageRepo/1/0/26/135/76/paillotes%20HD_J.jpg
 ratio_hw0.67
 on_wall0
 15
 id6625
 hotel_id362
 order17
 urihttp://images.pegs.com/imageRepo/1/0/27/991/488/Assiette%202%20HD_J.jpg
 ratio_hw1.50
 on_wall0
 16
 id6626
 hotel_id362
 order18
 urihttp://images.pegs.com/imageRepo/1/0/27/991/492/accueil%20spa_J.jpg
 ratio_hw0.67
 on_wall0
 17
 id6627
 hotel_id362
 order19
 urihttp://images.pegs.com/imageRepo/1/0/26/135/146/Jacuzzi_J.jpg
 ratio_hw0.70
 on_wall0
 18
 id6628
 hotel_id362
 order20
 urihttp://images.pegs.com/imageRepo/1/0/26/135/180/Salle%20de%20repos_J.jpg
 ratio_hw0.67
 on_wall0
 19
 id6629
 hotel_id362
 order21
 urihttp://images.pegs.com/imageRepo/1/0/26/135/192/Cabine%20de%20soin87_J.jpg
 ratio_hw0.67
 on_wall0
 20
 id6630
 hotel_id362
 order22
 urihttp://images.pegs.com/imageRepo/1/0/27/991/506/salle%20de%20fitness_J.jpg
 ratio_hw0.66
 on_wall0
 21
 id6631
 hotel_id362
 order23
 urihttp://images.pegs.com/imageRepo/1/0/27/991/510/Etangs%20de%20Corot%20-%20Bar%20des%20Artistes_J.jpg
 ratio_hw0.66
 on_wall0
 22
 id6632
 hotel_id362
 order24
 urihttp://images.pegs.com/imageRepo/1/0/27/991/514/Les%20Etangs%20de%20Corot%20005_J.jpg
 ratio_hw0.67
 on_wall0
 23
 id6633
 hotel_id362
 order25
 urihttp://images.pegs.com/imageRepo/1/0/27/991/518/Les%20Etangs%20de%20Corot%20006_J.jpg
 ratio_hw0.67
 on_wall0
 24
 id6634
 hotel_id362
 order26
 urihttp://images.pegs.com/imageRepo/1/0/26/135/334/Patio_J.jpg
 ratio_hw1.50
 on_wall0
 25
 id6635
 hotel_id362
 order27
 urihttp://images.pegs.com/imageRepo/1/0/27/991/534/H%C3%83%C2%B4tel%20lustre_J.jpg
 ratio_hw0.67
 on_wall0
 26
 id6636
 hotel_id362
 order28
 urihttp://images.pegs.com/imageRepo/1/0/26/134/733/Les%20Etangs%20de%20Corot_J.jpg
 ratio_hw0.67
 on_wall0
 27
 id6637
 hotel_id362
 order29
 urihttp://images.pegs.com/imageRepo/1/0/26/134/779/Corot_06%2009_0923_J.jpg
 ratio_hw1.50
 on_wall0
 28
 id6638
 hotel_id362
 order30
 urihttp://images.pegs.com/imageRepo/1/0/31/768/496/DSC_4325%20-%20web_J.jpg
 ratio_hw0.66
 on_wall0
 29
 id6639
 hotel_id362
 order31
 urihttp://images.pegs.com/imageRepo/1/0/33/494/850/1138584cdmsVSSLHphoto_img_pho_000_nc__1893303%7EMG__1_J.jpg
 ratio_hw1.50
 on_wall0
 30
 id6640
 hotel_id362
 order32
 urihttp://images.pegs.com/imageRepo/1/0/33/494/841/1138584cdmsVSSLHphoto_img_pho_000_nc__1893302%7EJunior-Suit_J.jpg
 ratio_hw1.50
 on_wall0
 31
 id6641
 hotel_id362
 order33
 urihttp://images.pegs.com/imageRepo/1/0/33/494/832/1138584cdmsVSSLHphoto_img_pho_000_nc__1893300%7EExterior__1_J.jpg
 ratio_hw1.50
 on_wall0
 32
 id6642
 hotel_id362
 order34
 urihttp://images.pegs.com/imageRepo/1/0/33/494/877/1138584cdmsVSSLHphoto_img_pho_000_nc__1893310%7ELe-Corot-Re_J.jpg
 ratio_hw1.50
 on_wall0
 33
 id6643
 hotel_id362
 order35
 urihttp://images.pegs.com/imageRepo/1/0/33/494/868/1138584cdmsVSSLHphoto_img_pho_000_nc__1893307%7EMG__1_J.jpg
 ratio_hw1.50
 on_wall0
 34
 id6644
 hotel_id362
 order36
 urihttp://images.pegs.com/imageRepo/1/0/33/494/859/1138584cdmsVSSLHphoto_img_pho_000_nc__1893306%7ECrushed-Cab_J.jpg
 ratio_hw1.50
 on_wall0
 35
 id6645
 hotel_id362
 order37
 urihttp://images.pegs.com/imageRepo/1/0/33/494/886/1138584cdmsVSSLHphoto_img_pho_000_nc__1893455%7ESpa__1_J.jpg
 ratio_hw1.51
 on_wall0
 36
 id6646
 hotel_id362
 order38
 urihttp://images.pegs.com/imageRepo/1/0/33/536/778/1138584cdmsVSSLHphoto_img_pho_000_nc__1556106%7EWeb__1_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id1455
 typeOTH
 hotel_id362
 nameComfort Room
 descriptionComfort 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
 id1456
 typeOTH
 hotel_id362
 nameHandicapped Room
 descriptionHandicapped room with lake view
 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
 id1457
 typeOTH
 hotel_id362
 nameJunior Suite
 descriptionA junior Suite with outstanding views
 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
 id1458
 typeOTH
 hotel_id362
 namePrestige Room
 descriptionPrestige room with a King sized bed and lake view.
 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
 id1459
 typeOTH
 hotel_id362
 nameStandard Room
 descriptionStandard room, perfect for single occupancy
 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
 id1460
 typeOTH
 hotel_id362
 nameSuite
 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
 0
 News
 id8
 country_idFR
 created2011-10-14 12:28:44
 modified2011-10-14 12:28:44
 localefre
 nameLe projet de réaménagement du premier étage de la Tour Eiffel
 descriptionDes nouveaux bâtiments et des espaces publics entièrement réaménagés pour refaire du 1er étage de la Tour l'un des lieux les plus spectaculaires et attrayants de Paris, à 57 mètres au-dessus de la ville.
 linkhttp://www.tour-eiffel.fr/actualites/a-la-une.html
 1
 News
 id3
 country_idFR
 created2011-07-12 16:33:30
 modified2011-07-12 16:33:30
 localefre
 nameLe Mexique à Arles
 descriptionMalgré l'annulation de l'Année du Mexique en France, le pays du Serpent à plumes enrichit de façon spectaculaire ces Rencontres 2011 qui s'interrogent sur l'avenir de l'image sur Internet.
 linkhttp://www.lefigaro.fr/culture/2011/07/12/03004-20110712ARTFIG00355-arles-sous-le-soleil-noir-du-mexique.php
- relatedHotels
 0
 Hotel
 id374
 starred0
 in0
 maintrack_hotel_id364236
 brand_codeRAD
 nameRadisson Blu Le Dokhan s Hotel Paris Trocadero
 address117 RUE LAURISTON
 zip_codeF-75116
 cityarea_id(null)
 city_id332
 region_id(null)
 state_id(null)
 country_idFR
 latitude48.869999
 longitude2.29
 zoom13
 rating4
 phone33 1536 56670
 reservation_phone(null)
 fax33 1536 56688
 emailinfo.dokhan.paris@radissonsas.com
 created2011-05-13 21:08:55
 modified2011-06-08 10:09:20
 descriptionSituated in the heart of Paris's 16th arrondissment, Le Dokhan's Hotel in the Trocadéro area of Paris occupies a beautiful former private residence that harkens back to the elegant days of the 18th century. With its well-preserved Haussmann façade, neo-classical furnishings and impressive artwork, this Paris hotel is a delight to the senses. Located in the 16th arrondissement, this luxury boutique hotel in Paris offers 41 uniquely designed rooms and four exceptional suites that feature Free high-speed Internet and other modern amenities. The hotel is also home to Le Dokhan's Bar, the first champagne bar in Paris.
 description_freSitué au cœur du 16ème arrondissement de Paris, l'Hôtel Le Dokhan's dans le quartier du Trocadéro de Paris occupe une belle ancienne résidence privée qui nous ramène à l'époque élégante du 18ème siècle. Avec sa façade de type haussmannien bien préservé, mobilier néo-classique et oeuvres d'art impressionnantes, cet hôtel de Paris est un délice pour les sens. Cet hôtel de luxe à Paris vous propose 41 chambres au design unique et quatre suites exceptionnelles, fonctionnalité Internet haut débit gratuit et d'autres équipements modernes. L'hôtel est également la maison du Bar Le Dokhan's, le premier bar à champagne à Paris.
 amenity220 AC, 220 DC, 24 Hour Room Service, Adjoining Rooms, Air Conditioned, Lounge, Copy Service, Currency Exchange, Elevators, Golf, Hairdryers Available, Internet Access ? Complimentary, Indoor Parking, Ironing Board, Guest Laundromat, Laundry/Valet Services, Multilingual, No Smoking Rooms/Facilities, Pets Allowed, Room Service, Safe Deposit Box, Valet Parking, Terrace, Television with Cable, Coffee Maker in Room, Connecting Rooms, Cribs Available, Iron, Mini Bar, In Room Movies, Safe, Smoke Detectors.
 amenity_fre220 V AC, 220 cc, 24 Hour Room Service, Chambres communicantes, Climatisation, Salon, Service de photocopie, service de change, ascenseurs, Golf, sèche-cheveux disponibles, l'accès Internet gratuit, planche à repasser, Laverie, Blanchisserie / Services de voiturier, multilingue, Chambres non fumeur / Équipements, animaux domestiques admis, service en chambre, coffre-fort, service de voiturier, terrasse, télévision avec câble, bouilloire dans la chambre, Chambres communicantes , Berceaux disponibles, fer à repasser, mini-bar, Films dans la chambre, Coffre-fort, Détecteurs de fumée.
 lowest_rate216.00
 lr_currencyEUR
 lr_people2
 comment_count1
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id332
 country_idFR
 state_id(null)
 maintrack_idPARIS
 nameParis
 main_key
 Country
 idFR
 nameFrance
 name_freFrance
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id6690
 hotel_id374
 order2
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/Exterior_01%20PARZR_j.jpg
 ratio_hw1.50
 on_wall0
 1
 id6691
 hotel_id374
 order3
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/PARZR%20-%20MINGLI%7E1_j.jpg
 ratio_hw1.50
 on_wall0
 2
 id6692
 hotel_id374
 order4
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/Room_02%20PARZR_j.jpg
 ratio_hw0.66
 on_wall0
 3
 id6693
 hotel_id374
 order5
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/PARZR%20-%20Room_01%20PARZR_j.jpg
 ratio_hw1.50
 on_wall0
 4
 id6694
 hotel_id374
 order6
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/Bar_01%20PARZR_j.jpg
 ratio_hw1.50
 on_wall0
 5
 id6695
 hotel_id374
 order7
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/PARZR%20-%20EIFFEL%7E3_j.jpg
 ratio_hw1.50
 on_wall0
 6
 id6696
 hotel_id374
 order8
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/PARZR%20-%20Champagne_01%20PARZR_j.jpg
 ratio_hw1.50
 on_wall0
 7
 id6697
 hotel_id374
 order9
 urihttp://image.pegs.com/content/H/H7R/H7R8/H7R8R/PARZR%20-%20Fireplace_01%20PARZR_j.jpg
 ratio_hw1.01
 on_wall0
 Room(empty)
 RatesPeriod(empty)
 Unavailability(empty)
 Comment
 0
 id4e09e44e-c308-455a-9652-5b56b2216750
 parent_id(null)
 foreign_key374
 user_id20
 lft1
 rght2
 modelHotel
 approved1
 is_spamclean
 title
 slug(null)
 bodyPour l'avoir bien pratiquée, la dégustation de coupettes la plus chic de la ville ! Des lambris verts, un petit salon à l'ancienne, c'est l'endroit parfait pour se murmurer des secrets pétillants...
 author_name(null)
 author_url(null)
 author_email
 languageeng
 comment_typecomment
 created2011-06-28 16:25:18
 modified2011-06-29 10:06:53
 Favorite(empty)
 Taglines
 0
 id413
 localeeng
 modelHotel
 foreign_key374
 fieldtagline
 content
 1
 id414
 localefre
 modelHotel
 foreign_key374
 fieldtagline
 content
 Envie
 0
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 1
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 1
 Hotel
 id1051
 starred0
 in0
 maintrack_hotel_id512551
 brand_codeC2
 nameVilla Carioca
 address15 avenue Vergniaud
 zip_code78600
 cityarea_id(null)
 city_id986
 region_id(null)
 state_id(null)
 country_idFR
 latitude48.9541888
 longitude2.15527650000001
 zoom13
 rating0
 phone33 1 39625705
 reservation_phone(null)
 fax33 1 39626284
 emailvillacarioca@orange.fr
 created2011-09-08 19:35:02
 modified2011-09-09 16:50:24
 descriptionVilla Carioca enjoys a superb setting in the former gardens of the Chateau de Maisons Laffitte. The furniture and antiques blends in seamlessly with the Second Empire colours in this fine Mansart style property the green of a linden tree here a touch of yellow there. The subtle decor is a sight to behold. Superb rooms looking onto the garden. A quick trip to Rio in the blue Ipanema. Time is suspended in Copacabana with its beautiful fireplace and bookcase. Breakfast is party time with the French Brazilian owners.
 description_freLa Villa Carioca bénéficie d'un cadre superbe dans les anciens jardins du château de Maison Laffitte. Les meubles et antiquités se marie parfaitement avec les couleurs du Second Empire dans cette propriété de style Mansart, le vert d'un tilleul ici, une touche de jaune là. Le décor subtile est un spectacle à voir. Les superbes chambres donnent sur le jardin. Un voyage rapide à Rio dans le bleu de l'Ipanema. Le temps est suspendu à Copacabana avec sa belle cheminée et sa bibliothèque. Le petit déjeuner est un temps de fête avec les propriétaires franco-brésilien.
 amenityBreakfast Buffet, Parking, Golf, Tennis, Maid Service, No Smoking Rooms/Facilities, Telephone, Rural/Country, Smoke Detectors, 24 Hour Security.
 amenity_frePetit-déjeuner buffet, parking, Golf, Tennis, Service d'entretien, chambres non fumeur / équipements, Téléphone, rural / Pays de détecteurs de fumée, 24 heures de sécurité.
 lowest_rate140.00
 lr_currencyEUR
 lr_people1
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id986
 country_idFR
 state_id(null)
 maintrack_idMAISONSLAFFITTE
 nameMaisons-Laffitte
 main_key
 Country
 idFR
 nameFrance
 name_freFrance
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id15904
 hotel_id1051
 order2
 urihttp://images.pegs.com/imageRepo/1/0/33/465/839/1138756cdmsCRSphoto_img_pho_000_nc__1886369%7EVilla_Carioca_J.jpg
 ratio_hw0.67
 on_wall0
 1
 id15905
 hotel_id1051
 order3
 urihttp://images.pegs.com/imageRepo/1/0/33/465/848/1138756cdmsCRSphoto_img_pho_000_nc__1886372%7EVilla_Carioca_J.jpg
 ratio_hw1.53
 on_wall0
 2
 id15906
 hotel_id1051
 order4
 urihttp://images.pegs.com/imageRepo/1/0/33/465/902/1138756cdmsCRSphoto_img_pho_000_nc__1886390%7EVilla_Carioca_J.jpg
 ratio_hw0.65
 on_wall0
 3
 id15907
 hotel_id1051
 order5
 urihttp://images.pegs.com/imageRepo/1/0/33/465/911/1138756cdmsCRSphoto_img_pho_000_nc__1886393%7EVilla_Carioca_J.jpg
 ratio_hw0.65
 on_wall0
 4
 id15908
 hotel_id1051
 order6
 urihttp://images.pegs.com/imageRepo/1/0/33/465/920/1138756cdmsCRSphoto_img_pho_000_nc__1886396%7EVilla_Carioca_J.jpg
 ratio_hw1.33
 on_wall0
 5
 id15909
 hotel_id1051
 order7
 urihttp://images.pegs.com/imageRepo/1/0/33/465/929/1138756cdmsCRSphoto_img_pho_000_nc__1886399%7EVilla_Carioca_J.jpg
 ratio_hw1.33
 on_wall0
 Room
 0
 id4106
 typeOTH
 hotel_id1051
 nameStandard double room
 descriptionStandard double 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
 1
 id4107
 typeOTH
 hotel_id1051
 nameSuperior 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
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id1741
 localeeng
 modelHotel
 foreign_key1051
 fieldtagline
 content
 1
 id1742
 localefre
 modelHotel
 foreign_key1051
 fieldtagline
 content
 Envie
 0
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 1
 id9
 created2011-05-17 19:26:00
 modified2011-05-17 19:26:00
 2
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 3
 id23
 created2011-05-24 08:28:10
 modified2011-05-24 08:28:10
 4
 id25
 created2011-09-01 11:26:54
 modified2011-09-01 11:28:10
 2
 Hotel
 id767
 starred0
 in0
 maintrack_hotel_id305427
 brand_codeON
 nameHotel Vaneau Saint Germain
 address86 rue Vaneau
 zip_code75007
 cityarea_id(null)
 city_id332
 region_id(null)
 state_id(null)
 country_idFR
 latitude48.848808
 longitude2.32018
 zoom13
 rating3
 phone33 145487311
 reservation_phone(null)
 fax33 145492774
 emailhotel@vaneausaintgermain.com
 created2011-08-02 07:40:28
 modified2011-08-08 18:09:06
 descriptionNear the Saint-Germain-des-Près area and the Orsay Museum, member of Les Hôtels France Patrimoine, the Hotel Vaneau Saint Germain offers 39 subtly refined rooms. The decor of its rooms, which is original for the stained-glass windows and marble fireplaces, lets our imagination carry us to the atmosphere of the 19th century. At that time, this area was the meeting point of several artists and intellectuals, such as Delacroix, Manet, Racine and Balzac.
 description_freEn plein coeur du quartier de Saint-Germain-des-Près et à proximité du Musée d'Orsay, l'Hôtel Vaneau Saint Germain, membre de la chaîne Les Hôtels France Patrimoine, offre 39 chambres simples et raffinées. Caractéristique pour ses vitraux et ses cheminées en marbre, ce décor repeint l'atmosphère du XIXème siècle du quartier, où les plus grands artistes et intellectuels, tels que Delacroix, Manet, Racine ou encore Balzac, se retrouvaient.
 amenity24 Hour Front Desk, Air Conditioned, Elevators, News Stand, Parking, Safe Deposit Box, Tour Desk, Wake-up Service, Multilingual, Wireless Internet Access, No Smoking Rooms/Facilities, Internet Access Complimentary, Radio, Bathrobes, Television with Cable, TV, Connecting Rooms, Fire Place, Hairdryers Available, Internet Access, Mini Bar, Modem Lines in Room, TV Remote Control, Safe, Telephone, VCR, WC, Shower, Satellite TV, AM/FM Alarm Clock, Shops/Commercial Services, Night Club, FAX, High speed internet access, Meeting/Banquet Facilities, Meal Plan - Bed and Breakfast, City Center,
 amenity_freRéception ouverte 24h/24, Climatisation, Ascenseurs, Kiosque à journaux, Parking, Coffre-fort à la réception, Agence de voyage, Service de réveil, Multilingue, Espaces/Salles non fumeurs, Radio, Télévision par câble, TV, Chambres communicantes, Cheminée, Sèches-cheveux, Mini-bar, Chambre avec lignes pour modems, Télécommande TV, Coffre-fort dans la chambre, Téléphone, Magnétoscope, WC, Douche, Radio-réveil AM/FM, Magasins/Services commerciaux, Boîte de nuit, FAX, Salles de réunions/banquets, Bed and breakfast.
 lowest_rate109.00
 lr_currencyEUR
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id332
 country_idFR
 state_id(null)
 maintrack_idPARIS
 nameParis
 main_key
 Country
 idFR
 nameFrance
 name_freFrance
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id12154
 hotel_id767
 order2
 urihttp://images.pegs.com/imageRepo/1/0/18/17/832/31644r_J.jpg
 ratio_hw1.51
 on_wall0
 1
 id12155
 hotel_id767
 order3
 urihttp://images.pegs.com/imageRepo/1/0/18/17/836/31644s_J.jpg
 ratio_hw0.66
 on_wall0
 2
 id12156
 hotel_id767
 order4
 urihttp://images.pegs.com/imageRepo/1/0/18/17/840/31644x_J.jpg
 ratio_hw1.53
 on_wall0
 3
 id12157
 hotel_id767
 order5
 urihttp://images.pegs.com/imageRepo/1/0/18/17/848/31644ro35678_J.jpg
 ratio_hw0.66
 on_wall0
 4
 id12158
 hotel_id767
 order6
 urihttp://images.pegs.com/imageRepo/1/0/18/17/852/31644w_J.jpg
 ratio_hw1.50
 on_wall0
 5
 id12159
 hotel_id767
 order7
 urihttp://images.pegs.com/imageRepo/1/0/18/17/856/31644ro35679_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id3121
 typeOTH
 hotel_id767
 nameDOUBLE STANDARD
 descriptionStandardStandard Room for 2 people, 1 King Bed or Twin Beds wiht air conditioning. Approx 16sqm Bedroom overlooking the street (Rue Vaneau).
 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
 id3122
 typeOTH
 hotel_id767
 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
 id1177
 localeeng
 modelHotel
 foreign_key767
 fieldtagline
 content
 1
 id1178
 localefre
 modelHotel
 foreign_key767
 fieldtagline
 content
 Envie
 0
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 1
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
- relatedEvents
 0
 Event
 id634
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location5 Chemin des Montquartiers, 92130 Issy-les-Moulineaux, France
 latitude48.8173
 longitude2.25151
 zoom11
 state_id(null)
 country_id
 created2011-07-12 17:00:23
 modified2011-07-12 17:00:23
 url(null)
 comment_count0
 former_business_id242
 localefre
 nameCRAYERES MONTQUARTIER
 descriptionC'est un lieu étonnant, immense, on s'y perdrait tant les galeries semblent infinies.
 linkhttp://www.crayeres-montquartiers.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
 id3775
 localeeng
 modelEvent
 foreign_key634
 fieldname
 contentTHE MONTQUARTIER CAVES
 1
 id3776
 localefre
 modelEvent
 foreign_key634
 fieldname
 contentCRAYERES MONTQUARTIER
 Descriptions
 0
 id3777
 localeeng
 modelEvent
 foreign_key634
 fielddescription
 contentThis is an amazing place, immense, as one would lose the galleries seem endless.
 1
 id3778
 localefre
 modelEvent
 foreign_key634
 fielddescription
 contentC'est un lieu étonnant, immense, on s'y perdrait tant les galeries semblent infinies.
 Links
 0
 id3779
 localeeng
 modelEvent
 foreign_key634
 fieldlink
 contenthttp://www.crayeres-montquartiers.com
 1
 id3780
 localefre
 modelEvent
 foreign_key634
 fieldlink
 contenthttp://www.crayeres-montquartiers.com
 Hotel(empty)
 Theme(empty)
 1
 Event
 id759
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location1 Allée du Bord de l'Eau, 75016 Paris, France
 latitude48.8554
 longitude2.22618
 zoom13
 state_id(null)
 country_id
 created2011-07-27 16:13:39
 modified2011-07-27 16:13:39
 url(null)
 comment_count0
 former_business_id367
 localefre
 nameSKI NAUTIQUE AU BOIS DE BOULOGNE
 descriptionLa base nautique vous fournira l'équipement pour vous essayer au ski nautique en plein Paris.
 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
 id4525
 localeeng
 modelEvent
 foreign_key759
 fieldname
 contentWATER SKIING IN THE BOIS DE BOULOGNE
 1
 id4526
 localefre
 modelEvent
 foreign_key759
 fieldname
 contentSKI NAUTIQUE AU BOIS DE BOULOGNE
 Descriptions
 0
 id4527
 localeeng
 modelEvent
 foreign_key759
 fielddescription
 contentThe water base will provide equipment to try your hand at water skiing in central Paris.
 1
 id4528
 localefre
 modelEvent
 foreign_key759
 fielddescription
 contentLa base nautique vous fournira l'équipement pour vous essayer au ski nautique en plein Paris.
 Links
 0
 id4529
 localeeng
 modelEvent
 foreign_key759
 fieldlink
 content
 1
 id4530
 localefre
 modelEvent
 foreign_key759
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 2
 Event
 id1938
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location1 Rue Robert de Cotte, 78000 Versailles, France
 latitude48.8047
 longitude2.12369
 zoom13
 state_id(null)
 country_id
 created2012-01-02 15:43:44
 modified2012-01-02 15:43:44
 url(null)
 comment_count0
 former_business_id1548
 localefre
 nameASSISTER A UN OPERA ROYAL
 descriptionLe plus beau théâtre du plus beau des palais du monde renaît depuis quelques temps; jamais depuis Louis XV, ses ors n'avaient autant retenti des accents de Lully, Rameau et les autres...
 linkhttp://www.chateauversaillesspectacles.fr/meta_spectacle.php?metaspe=2
 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
 id11599
 localeeng
 modelEvent
 foreign_key1938
 fieldname
 contentATTEND A ROYAL OPERA
 1
 id11600
 localefre
 modelEvent
 foreign_key1938
 fieldname
 contentASSISTER A UN OPERA ROYAL
 Descriptions
 0
 id11601
 localeeng
 modelEvent
 foreign_key1938
 fielddescription
 contentThe best scene of the most beautiful palaces in the world is reborn for some time, ever since Louis XV, had its gold accents sounded as Lully, Rameau and others ...
 1
 id11602
 localefre
 modelEvent
 foreign_key1938
 fielddescription
 contentLe plus beau théâtre du plus beau des palais du monde renaît depuis quelques temps; jamais depuis Louis XV, ses ors n'avaient autant retenti des accents de Lully, Rameau et les autres...
 Links
 0
 id11603
 localeeng
 modelEvent
 foreign_key1938
 fieldlink
 contenthttp://www.chateauversaillesspectacles.fr/home.php?&lang=eng
 1
 id11604
 localefre
 modelEvent
 foreign_key1938
 fieldlink
 contenthttp://www.chateauversaillesspectacles.fr/meta_spectacle.php?metaspe=2
 Hotel(empty)
 Theme(empty)
 3
 Event
 id1922
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location31 Rue Saint-Louis en l'Île, 75004 Paris, France
 latitude48.8517
 longitude2.35676
 zoom13
 state_id(null)
 country_id
 created2011-12-21 17:37:53
 modified2011-12-21 17:37:53
 url(null)
 comment_count0
 former_business_id1532
 localefre
 nameLES GLACES DE BERTHILLON
 descriptionSuccombez aux crèmes glacés de Berthillon: célèbre glacier de Paris. Les arômes de fruits (cassis, par exemple) sont à juste titre réputé, le chocolat, le café, marrons glacés, Agenaise (Armagnac et pruneaux), noisette (noisette) et le nougat au miel (miel nougat) sont encore plus riches. Choisissez parmi 70 saveurs.
 linkhttp://www.berthillon.fr
 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
 id11503
 localeeng
 modelEvent
 foreign_key1922
 fieldname
 contentTHE BERTHILLON ICE CREAM
 1
 id11504
 localefre
 modelEvent
 foreign_key1922
 fieldname
 contentLES GLACES DE BERTHILLON
 Descriptions
 0
 id11505
 localeeng
 modelEvent
 foreign_key1922
 fielddescription
 contentSuccumb to the Ice Cream of Berthillon: famous glacier de Paris. The fruit aromas (blackcurrant, for example) are justifiably famous, chocolate, coffee, glazed chestnuts, Agenaise (Armagnac and prunes), nut (hazelnut) and honey nougat (honey nougat) are even richer. Choose from 70 flavors.
 1
 id11506
 localefre
 modelEvent
 foreign_key1922
 fielddescription
 contentSuccombez aux crèmes glacés de Berthillon: célèbre glacier de Paris. Les arômes de fruits (cassis, par exemple) sont à juste titre réputé, le chocolat, le café, marrons glacés, Agenaise (Armagnac et pruneaux), noisette (noisette) et le nougat au miel (miel nougat) sont encore plus riches. Choisissez parmi 70 saveurs.
 Links
 0
 id11507
 localeeng
 modelEvent
 foreign_key1922
 fieldlink
 contenthttp://www.berthillon.fr
 1
 id11508
 localefre
 modelEvent
 foreign_key1922
 fieldlink
 contenthttp://www.berthillon.fr
 Hotel(empty)
 Theme(empty)
 4
 Event
 id760
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationParis, France
 latitude48.8566
 longitude2.35222
 zoom10
 state_id(null)
 country_id
 created2011-07-27 16:19:47
 modified2011-07-27 16:19:47
 url(null)
 comment_count0
 former_business_id368
 localefre
 nameSURVOL DE PARIS EN HELICOPTERE
 descriptionUne expérience unique de voir Paris, ses environs et Versailles depuis le ciel.
 linkhttp://www.airshow.fr
 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
 id4531
 localeeng
 modelEvent
 foreign_key760
 fieldname
 contentPARIS HELICOPTER FLIGHT
 1
 id4532
 localefre
 modelEvent
 foreign_key760
 fieldname
 contentSURVOL DE PARIS EN HELICOPTERE
 Descriptions
 0
 id4533
 localeeng
 modelEvent
 foreign_key760
 fielddescription
 contentA unique experience to see Paris, around and Versailles from the sky.
 1
 id4534
 localefre
 modelEvent
 foreign_key760
 fielddescription
 contentUne expérience unique de voir Paris, ses environs et Versailles depuis le ciel.
 Links
 0
 id4535
 localeeng
 modelEvent
 foreign_key760
 fieldlink
 contenthttp://www.airshow.fr
 1
 id4536
 localefre
 modelEvent
 foreign_key760
 fieldlink
 contenthttp://www.airshow.fr
 Hotel(empty)
 Theme(empty)
 5
 Event
 id761
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationParis, France
 latitude48.8566
 longitude2.35222
 zoom11
 state_id(null)
 country_id
 created2011-07-27 16:25:12
 modified2011-07-27 16:25:12
 url(null)
 comment_count0
 former_business_id369
 localefre
 nameLES TOURS DE PARIS DU CINEMA
 descriptionDécouvrez les lieux qui ont inspirés les producteurs de film à travers Paris.
 linkhttp://www.cinema.paris.fr
 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
 id4537
 localeeng
 modelEvent
 foreign_key761
 fieldname
 contentPARIS MOOVIES TOURS
 1
 id4538
 localefre
 modelEvent
 foreign_key761
 fieldname
 contentLES TOURS DE PARIS DU CINEMA
 Descriptions
 0
 id4539
 localeeng
 modelEvent
 foreign_key761
 fielddescription
 contentDiscover and follow the tour and find places that inspired film producers over Paris.
 1
 id4540
 localefre
 modelEvent
 foreign_key761
 fielddescription
 contentDécouvrez les lieux qui ont inspirés les producteurs de film à travers Paris.
 Links
 0
 id4541
 localeeng
 modelEvent
 foreign_key761
 fieldlink
 contenthttp://www.cinema.paris.fr
 1
 id4542
 localefre
 modelEvent
 foreign_key761
 fieldlink
 contenthttp://www.cinema.paris.fr
 Hotel(empty)
 Theme(empty)
 6
 Event
 id952
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationParis, France
 latitude48.8566
 longitude2.35222
 zoom12
 state_id(null)
 country_id
 created2011-08-11 08:20:55
 modified2011-08-11 08:20:55
 url(null)
 comment_count0
 former_business_id560
 localefre
 nameVISITE DU PARIS SECRET
 descriptionSecrets de Paris propose des découvertes à thèmes de l'histoire de Paris. Ces visites peuvent être associées avec un repas dans un restaurant dont l'histoire est liée avec le thème choisi. Pour les enfants, les amoureux les entreprises vous verrez le Paris insolite. Toutes ces visites peuvent être organisées en dehors des dates programmées, sur demande et sur devis par courriel. QUARTIERS DE PARIS Montparnasse et la bohème Paris 14e Les années folles à Montparnasse Paris 6e et 14e Le quartier Montsouris Paris 14e Le quartier Chinois Paris 13e Plaisance secret Paris 14e L'ancien village d'Orléans Paris 14e La Villa Brune Paris 14e L'ïle Saint-Louis Paris 4e Saint-Germain des Prés Paris 6e
 linkhttp://secretsdeparis.blogspirit.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
 id5683
 localeeng
 modelEvent
 foreign_key952
 fieldname
 contentVISIT SECRET PARIS
 1
 id5684
 localefre
 modelEvent
 foreign_key952
 fieldname
 contentVISITE DU PARIS SECRET
 Descriptions
 0
 id5685
 localeeng
 modelEvent
 foreign_key952
 fielddescription
 contentSecrets of Paris offers themed discoveries in the history of Paris. These visits may be associated with a meal in a restaurant whose history is linked with the theme. For children, lovers or companies you will see the unusual Paris. All these visits can be arranged outside the scheduled dates, and quotations on request by email. PARIS NEIGHBORHOODS: Bohemian Montparnasse and Paris 14th The Roaring Twenties in Paris Montparnasse 6th and 14th Montsouris Paris 14th district The 13th Paris Chinatown Secret Plaisance Paris 14e The old village of Orleans Paris 14e Villa Brune Paris 14e The Ile Saint-Louis Paris 4th Saint-Germain des Prés Paris 6e
 1
 id5686
 localefre
 modelEvent
 foreign_key952
 fielddescription
 contentSecrets de Paris propose des découvertes à thèmes de l'histoire de Paris. Ces visites peuvent être associées avec un repas dans un restaurant dont l'histoire est liée avec le thème choisi. Pour les enfants, les amoureux les entreprises vous verrez le Paris insolite. Toutes ces visites peuvent être organisées en dehors des dates programmées, sur demande et sur devis par courriel. QUARTIERS DE PARIS Montparnasse et la bohème Paris 14e Les années folles à Montparnasse Paris 6e et 14e Le quartier Montsouris Paris 14e Le quartier Chinois Paris 13e Plaisance secret Paris 14e L'ancien village d'Orléans Paris 14e La Villa Brune Paris 14e L'ïle Saint-Louis Paris 4e Saint-Germain des Prés Paris 6e
 Links
 0
 id5687
 localeeng
 modelEvent
 foreign_key952
 fieldlink
 contenthttp://secretsdeparis.blogspirit.com/
 1
 id5688
 localefre
 modelEvent
 foreign_key952
 fieldlink
 contenthttp://secretsdeparis.blogspirit.com/
 Hotel(empty)
 Theme(empty)
 7
 Event
 id762
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location14 Rue Joseph de Maistre, 75018 Paris, France
 latitude48.8865
 longitude2.33287
 zoom11
 state_id(null)
 country_id
 created2011-07-27 16:30:55
 modified2011-07-27 16:30:55
 url(null)
 comment_count0
 former_business_id370
 localefre
 nameREFUGE PARISIENS
 descriptionPour fuir le bruit et la foule de Montmartre allez dans ce refuge au 7ème étage et admirez la vue avec un cocktail.
 linkhttp://www.terrass-hotel.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
 id4543
 localeeng
 modelEvent
 foreign_key762
 fieldname
 contentPARIS REFUGE
 1
 id4544
 localefre
 modelEvent
 foreign_key762
 fieldname
 contentREFUGE PARISIENS
 Descriptions
 0
 id4545
 localeeng
 modelEvent
 foreign_key762
 fielddescription
 contentTo escape the noise and crowds of Montmartre go this 7 floor refuge. Eat and see the 180 degree view of Paris.
 1
 id4546
 localefre
 modelEvent
 foreign_key762
 fielddescription
 contentPour fuir le bruit et la foule de Montmartre allez dans ce refuge au 7ème étage et admirez la vue avec un cocktail.
 Links
 0
 id4547
 localeeng
 modelEvent
 foreign_key762
 fieldlink
 contenthttp://www.terrass-hotel.com
 1
 id4548
 localefre
 modelEvent
 foreign_key762
 fieldlink
 contenthttp://www.terrass-hotel.com
 Hotel(empty)
 Theme(empty)
 8
 Event
 id758
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location17-31 Rue Saint-Vincent, 75018 Paris, France
 latitude48.8885
 longitude2.34091
 zoom12
 state_id(null)
 country_id
 created2011-07-27 16:09:32
 modified2011-07-27 16:09:32
 url(null)
 comment_count0
 former_business_id366
 localefre
 nameJARDIN SAINT VINCENT
 descriptionVéritable petit nid de verdure de 1500 m2 accroché sur la butte Montmartre.
 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
 id4519
 localeeng
 modelEvent
 foreign_key758
 fieldname
 contentSAINT VINCENT GARDEN
 1
 id4520
 localefre
 modelEvent
 foreign_key758
 fieldname
 contentJARDIN SAINT VINCENT
 Descriptions
 0
 id4521
 localeeng
 modelEvent
 foreign_key758
 fielddescription
 contentA real nest of greenery of 1500 m2 hung on Montmartre.
 1
 id4522
 localefre
 modelEvent
 foreign_key758
 fielddescription
 contentVéritable petit nid de verdure de 1500 m2 accroché sur la butte Montmartre.
 Links
 0
 id4523
 localeeng
 modelEvent
 foreign_key758
 fieldlink
 content
 1
 id4524
 localefre
 modelEvent
 foreign_key758
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 9
 Event
 id928
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location2-6 Place du Général de Gaulle, 94150 Rungis, France
 latitude48.7536
 longitude2.35011
 zoom13
 state_id(null)
 country_id
 created2011-08-08 11:12:10
 modified2011-08-08 11:12:10
 url(null)
 comment_count0
 former_business_id536
 localefre
 nameVISITE DU MARCHE DE RUNGIS
 descriptionUne visite au plus grand marché de produits frais d'Europe est réservé au lève tôt ! A partir de 4 heures du matin vous pourrez observer les 12 000 personnes qui s'activent sur les 230 hectares du site répartis en différents pavillons (pêche, viande, fleurs,..).
 linkwww.visiterungis.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
 id5539
 localeeng
 modelEvent
 foreign_key928
 fieldname
 contentRUNGIS MARKET VISIT
 1
 id5540
 localefre
 modelEvent
 foreign_key928
 fieldname
 contentVISITE DU MARCHE DE RUNGIS
 Descriptions
 0
 id5541
 localeeng
 modelEvent
 foreign_key928
 fielddescription
 contentA visit to Rungis is for early risers. It must indeed be up from 4 and a half hours in the morning to discover the largest market in France and 12,000 actors who activate daily between dealers flowers, poultry, dairy and other fishmongers.
 1
 id5542
 localefre
 modelEvent
 foreign_key928
 fielddescription
 contentUne visite au plus grand marché de produits frais d'Europe est réservé au lève tôt ! A partir de 4 heures du matin vous pourrez observer les 12 000 personnes qui s'activent sur les 230 hectares du site répartis en différents pavillons (pêche, viande, fleurs,..).
 Links
 0
 id5543
 localeeng
 modelEvent
 foreign_key928
 fieldlink
 contentwww.visiterungis.com
 1
 id5544
 localefre
 modelEvent
 foreign_key928
 fieldlink
 contentwww.visiterungis.com
 Hotel(empty)
 Theme(empty)
- weather(false)
- meta_description_for_layoutA picturesque retreat surrounded by lakes and gardens, Les Etangs de Corot nestles in Ville d'Avray, a beautiful setting that has attracted artists and writers for over 200 years, yet just 15 minutes from Paris. Blending into its pretty surrounds, the hotel has an imaginative and contemporary collection of rooms, a choice of three restaurants and a unique Caudalie Vinotherapie Spa. Named after the landscape that inspired the 19th century artist, Jean-Baptiste Camille Corot, a precursor of Impressionism, the hotel's ambience is warm and light. The rooms, decorated in pastel shades, are individually designed, most with views over the gardens and lakes. Enjoy the relaxing treatments at the Caudalie Vinotherapie Spa, then wander through the gardens to admire the beauty of the lakes that motivated Corot. Dine on one of the restaurant terraces which have breathtaking views over the lakes. Les Etangs de Corot is a Small Luxury Hotels of the World property.
- 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

Les Etangs de Corot

Ville D Avray, France

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

Les Etangs de Corot

Ville D Avray, France

0 commentaires

Réserver cet hôtel

Les expériences proches de l'hôtel

Autres hôtels selon vos critères

Paris, France Radisson Blu Le Dokhan s Hotel Paris Trocadero

Maisons-Laffitte, France Villa Carioca

Paris, France Hotel Vaneau Saint Germain

En savoir plus

Brèves

> Le projet de réaménagement du premier étage de la Tour Eiffel

> Le Mexique à Arles

Liens utiles

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

Paris, France
Radisson Blu Le Dokhan s Hotel Paris Trocadero

Maisons-Laffitte, France
Villa Carioca

Paris, France
Hotel Vaneau Saint Germain