Sunset Beach

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

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

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

Sql Log

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `hotels`	34	34	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	0
SHOW FULL COLUMNS FROM `cities`	6	6	0
SHOW FULL COLUMNS FROM `states`	3	3	0
SHOW FULL COLUMNS FROM `countries`	3	3	0
SHOW FULL COLUMNS FROM `weather_forecasts`	15	15	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	0
SHOW FULL COLUMNS FROM `news`	4	4	0
SHOW FULL COLUMNS FROM `i18n`	6	6	0
SHOW FULL COLUMNS FROM `home_hotels`	4	4	0
SHOW FULL COLUMNS FROM `hotel_images`	6	6	0
SHOW FULL COLUMNS FROM `rooms`	15	15	0
SHOW FULL COLUMNS FROM `rooms_rates`	8	8	0
SHOW FULL COLUMNS FROM `rates_periods`	6	6	0
SHOW FULL COLUMNS FROM `rates_period_i18n`	6	6	0
SHOW FULL COLUMNS FROM `unavailabilities`	4	4	0
SHOW FULL COLUMNS FROM `envies`	3	3	0
SHOW FULL COLUMNS FROM `envie_i18n`	6	6	0
SHOW FULL COLUMNS FROM `envies_hotels`	2	2	0
SHOW FULL COLUMNS FROM `comments`	19	19	0
SHOW FULL COLUMNS FROM `users`	16	16	0
SHOW FULL COLUMNS FROM `addresses`	12	12	0
SHOW FULL COLUMNS FROM `janrain_profiles`	9	9	0
SHOW FULL COLUMNS FROM `admins`	15	15	0
SHOW FULL COLUMNS FROM `favorites`	8	8	0
SHOW FULL COLUMNS FROM `hotel_i18n`	6	6	0
SHOW FULL COLUMNS FROM `configs`	3	3	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';	1	1	0
SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'eng') WHERE 1 = 1	1	1	0
SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1)	2	2	0
SELECT `Hotel`., `City`., `Country`., `State`., `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'eng') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) WHERE `Hotel`.`id` = 513 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` = 471	1	1	0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'US'	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` = (513)	5	5	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` = (513)	2	2	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 (2128, 2129)	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` = (513) ORDER BY `RatesPeriod`.`from` ASC LIMIT 5	0	0	0
SELECT `News`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content` FROM `news` AS `News` INNER JOIN `i18n` AS `I18n__name` ON (`News`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'News' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__description` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'News' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__link` ON (`News`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'News' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') WHERE `News`.`country_id` = 'US' ORDER BY `News`.`created` DESC	1	1	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` = 'eng') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) LEFT JOIN `home_hotels` AS `HomeHotel` ON (`HomeHotel`.`hotel_id` = `Hotel`.`id`) WHERE `Hotel`.`published` = 1 AND `Hotel`.`id` != 513 AND `Hotel`.`longitude` BETWEEN -73.541721319756 AND -71.151866680244 AND `Hotel`.`latitude` BETWEEN 40.19330004058 AND 41.99437595942 ORDER BY ABS(`Hotel`.`longitude` - -72.346794) + ABS(`Hotel`.`latitude` - 41.093838) 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 (1308, 1327, 578)	39	39	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 (1308, 1327, 578)	20	20	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 (1308, 1327, 578)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1308, 1327, 578)	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 (1308, 1327, 578)	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 (1308, 1327, 578)	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 (1308, 1327, 578)	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 (1308, 1327, 578) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	25	25	1
SHOW FULL COLUMNS FROM `events`	18	18	0
SHOW FULL COLUMNS FROM `home_events`	4	4	0
SHOW FULL COLUMNS FROM `event_images`	5	5	0
SHOW FULL COLUMNS FROM `themes`	4	4	0
SHOW FULL COLUMNS FROM `theme_i18n`	6	6	0
SHOW FULL COLUMNS FROM `events_hotels`	2	2	0
SHOW FULL COLUMNS FROM `events_themes`	2	2	0
SHOW FULL COLUMNS FROM `event_i18n`	6	6	0
SELECT `Event`., `HomeEvent`., `CreatedUser`., `Country`., `State`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18n__name` ON (`Event`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Event' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__description` ON (`Event`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Event' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__link` ON (`Event`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Event' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE ((`Event`.`end` IS NULL) OR (`Event`.`end` >= NOW())) AND `Event`.`longitude` BETWEEN -73.541721319756 AND -71.151866680244 AND `Event`.`latitude` BETWEEN 40.19330004058 AND 41.99437595942 ORDER BY ABS(`Event`.`longitude` - -72.346794) + ABS(`Event`.`latitude` - 41.093838) ASC LIMIT 10	8	8	10	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378)	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 (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378)	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 (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378)	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 (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378)	16	16	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 (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378)	16	16	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 (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378)	16	16	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 (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378) 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 (915, 1989, 1988, 1845, 1831, 1846, 1830, 1378) AND `EventsTheme`.`theme_id` = `Theme`.`id`)	0	0	0
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC	256	256	0
SELECT `Theme`.*, `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18n__name` ON (`Theme`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Theme' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	10	10	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `theme_i18n` AS `Names` WHERE `model` = 'Theme' AND `field` = 'name' AND `Names`.`foreign_key` IN (6, 10, 7, 12, 11, 13, 5, 8, 4, 9)	20	20	0
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1	10	10	0
SELECT `Envie`.*, `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18n__name` ON (`Envie`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Envie' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	29	29	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `envie_i18n` AS `Names` WHERE `model` = 'Envie' AND `field` = 'name' AND `Names`.`foreign_key` IN (19, 5, 6, 24, 8, 25, 4, 10, 12, 7, 9, 22, 30, 14, 26, 21, 3, 1, 13, 27, 18, 11, 28, 29, 16, 15, 23, 2, 17)	58	58	0
SELECT `Hotel`.`id`, `Country`.*, `Country`.`id` FROM `hotels` AS `Hotel` LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) WHERE 1 = 1 GROUP BY `Hotel`.`country_id` ORDER BY `Country`.`name` ASC	120	120	0
SHOW FULL COLUMNS FROM `promises`	3	3	0
SELECT `Promise`.*, `I18n__title`.`content`, `I18n__content`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18n__title` ON (`Promise`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Promise' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__content` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Promise' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') WHERE 1 = 1 LIMIT 4	4	4	0
SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Promise' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT `Contents`.`id`, `Contents`.`locale`, `Contents`.`model`, `Contents`.`foreign_key`, `Contents`.`field`, `Contents`.`content` FROM `i18n` AS `Contents` WHERE `model` = 'Promise' AND `field` = 'content' AND `Contents`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 513 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` = 513 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5	0	0	0

Query Explain:

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

====

Timer

+ –

Memory

Peak Memory Use 25.41 MB

Message	Memory use
Component initialization	14.31 MB
Controller action start	14.48 MB
Controller render start	16.25 MB
View render complete	20.12 MB

Timers

Total Request Time: 521 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	76.55
Component initialization and startup	4.08
Controller action	227.53
Render Controller Action	108.13
» Rendering View	104.73
» » Rendering APP/views/hotels/view.ctp	49.82
» » » Rendering APP/views/elements/sharing_widget.ctp	0.21
» » » Rendering APP/views/elements/comments/flat/main.ctp	0.40
» » » Rendering APP/views/elements/hotels/form_reservation.ctp	3.41
» » » Rendering APP/views/elements/events/related.ctp	1.49
» » » Rendering APP/views/elements/events/related.ctp #2	1.49
» » » Rendering APP/views/elements/events/related.ctp #3	1.48
» » » Rendering APP/views/elements/events/related.ctp #4	1.49
» » » Rendering APP/views/elements/events/related.ctp #5	1.53
» » » Rendering APP/views/elements/events/related.ctp #6	1.50
» » » Rendering APP/views/elements/events/related.ctp #7	1.51
» » » Rendering APP/views/elements/events/related.ctp #8	1.60
» » » Rendering APP/views/elements/events/legend.ctp	3.49
» » » Rendering APP/views/elements/hotels/related.ctp #9	0.49
» » » Rendering APP/views/elements/hotels/related.ctp #10	0.58
» » » Rendering APP/views/elements/hotels/related.ctp #11	0.69
» » Rendering APP/views/layouts/default.ctp	54.70
» » » Rendering APP/views/elements/google_analytics.ctp	0.09
» » » Rendering APP/views/elements/layout/top.ctp	1.42
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0.31
» » » Rendering APP/views/elements/layout/header.ctp	47.81
» » » Rendering APP/views/elements/layout/extra.ctp	0.12
» » » Rendering APP/views/elements/layout/footer.ctp	4.23
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0.31
» » » Rendering APP/views/elements/layout/footnotes.ctp	0.09

====

Log

+ –

Logs

warning

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

error

Time	Message
2021-09-26 10:48:50	Impossible to access the Google API
2021-09-26 10:48:50	Impossible to access the Google API

====

Variables
+ –
View Variables
- promises_for_layout
 0
 Promise
 id1
 title A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 content
 localeeng
 Titles
 0
 id10143
 localeeng
 modelPromise
 foreign_key1
 fieldtitle
 content A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 1
 id10144
 localefre
 modelPromise
 foreign_key1
 fieldtitle
 content Des hôtels de charme a taille humaine
 Contents
 0
 id10145
 localeeng
 modelPromise
 foreign_key1
 fieldcontent
 content
 1
 id10146
 localefre
 modelPromise
 foreign_key1
 fieldcontent
 content Globe Secret se distingue par l’originalité de sa sélection d’hôtels de charme. Ces quelques 1200 adresses autour du monde ont pour trait commun l’intimité (maximum 30 chambres) et un cadre préservé. Inclassables, ces adresses sont ancrées dans la culture de leur pays, revendiquant une authenticité et un accueil personnalisé. Avec Globe Secret, vous n’êtes pas prêts d’oublier vos vacances…             <meta charset="utf-8" /> 
 1
 Promise
 id2
 title BOOKING AT NO ADDITIONAL COST
 content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 localeeng
 Titles
 0
 id10147
 localeeng
 modelPromise
 foreign_key2
 fieldtitle
 content BOOKING AT NO ADDITIONAL COST
 1
 id10148
 localefre
 modelPromise
 foreign_key2
 fieldtitle
 content RESERVATION SANS FRAIS
 Contents
 0
 id10149
 localeeng
 modelPromise
 foreign_key2
 fieldcontent
 content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 1
 id10150
 localefre
 modelPromise
 foreign_key2
 fieldcontent
 content Globe Secret garantie une transparence de prix et de réservation. En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.
 2
 Promise
 id3
 title UNIQUE SELECTION CRITERIA
 content
 localeeng
 Titles
 0
 id10151
 localeeng
 modelPromise
 foreign_key3
 fieldtitle
 content UNIQUE SELECTION CRITERIA
 1
 id10152
 localefre
 modelPromise
 foreign_key3
 fieldtitle
 content DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 Contents
 0
 id10153
 localeeng
 modelPromise
 foreign_key3
 fieldcontent
 content
 1
 id10154
 localefre
 modelPromise
 foreign_key3
 fieldcontent
 content   Globe Secret vous propose de nombreux critères d’entrée et originaux pour choisir l’hôtel ou l’expérience qui correspond à vos envies. Ex: la zone géographique mais aussi le climat, la galerie. Nous avons classé les hôtels par thèmes, vous permettant de faire une recherche d'hotel ou une expérience en fonction de vos goûts ou d'une envie particulière ex: équitation, culture, festival, pêche,..
 3
 Promise
 id4
 title MORE TAILORED SERVICES
 content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 localeeng
 Titles
 0
 id10155
 localeeng
 modelPromise
 foreign_key4
 fieldtitle
 content MORE TAILORED SERVICES
 1
 id10156
 localefre
 modelPromise
 foreign_key4
 fieldtitle
 content PLUS DE SERVICES A LA CARTE
 Contents
 0
 id10157
 localeeng
 modelPromise
 foreign_key4
 fieldcontent
 content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 1
 id10158
 localefre
 modelPromise
 foreign_key4
 fieldcontent
 content   <meta charset="utf-8" /> <div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; "> Globe Secret vous propose aussi ses services pour la réservation de vos billets d’avion. Accédez ainsi à des tarifs négociés sur + de 500 compagnies aériennes vers plus de 1000 destinations. Toujours selon le même principe, ce service est sans frais supplémentaires. Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste, nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. Faites-nous part de vos projets !</div>
- destinations_for_layout
 AFAfghanistan
 AXAland Islands
 ALAlbania
 DZAlgeria
 ASAmerican Samoa
 ADAndorra
 AOAngola
 AIAnguilla
 AQAntarctica
 AGAntigua/Barbuda
 ARArgentina
 AMArmenia
 AWAruba
 AUAustralia
 ATAustria
 AZAzerbaijan
 BSBahamas
 BHBahrain
 BDBangladesh
 BBBarbados
 BYBelarus
 BEBelgium
 BZBelize
 BJBenin
 BMBermuda
 BTBhutan
 BOBolivia
 BABosnia
 BWBotswana
 BVBouvet Island
 BRBrazil
 IOBritish Indian Ocean Territory
 WIBritish West Indies
 BNBrunei Darussalam
 BGBulgaria
 BFBurkina Faso
 BIBurundi
 KHCambodia
 CMCameroon
 CACanada
 CVCape Verde
 KYCayman Islands
 CFCentral Africa
 TDChad
 CLChile
 CNChina
 CXChristmas Island
 CCCocos (Keeling) Islands
 COColombia
 KMComoros
 CGCongo
 CDCongo
 CKCook Islands
 CRCosta Rica
 CICote D'Ivoire
 HRCroatia
 CUCuba
 CYCyprus
 CZCzech Republic
 DKDenmark
 DJDjibouti
 DMDominica
 DODominican Republic
 TPEast Timor
 ECEcuador
 EGEgypt
 SVEl Salvador
 GQEquatorial Guinea
 EREritrea
 EEEstonia
 ETEthiopia
 FOFaeroe Islands
 FKFalkland Islands
 FJFiji
 FIFinland
 FRFrance
 PFFrench Polynesia
 TFFrench Southern Territories
 GAGabon
 GMGambia
 XAGaza
 GEGeorgia
 DEGermany
 GHGhana
 GIGibraltar
 GRGreece
 GLGreenland
 GDGrenada
 GPGuadeloupe
 GUGuam
 GTGuatemala
 GGGuernsey
 GFGuiana
 GNGuinea
 GWGuinea-Bissau
 GYGuyana
 HTHaiti
 HMHeard And Mcdonald Islands
 XHHeld Territories
 HNHonduras
 HKHong Kong
 HUHungary
 ISIceland
 INIndia
 XIIndian Ocean Islands
 IDIndonesia
 IRIran
 IQIraq
 IEIreland
 IMIsle of Man
 ILIsrael
 ITItaly
 JMJamaica
 JPJapan
 JEJersey
 JOJordan
 KZKazakhstan
 KEKenya
 KIKiribati
 KRKorea
 KWKuwait
 KGKyrgyzstan
 LALaos
 LVLatvia
 LBLebanon
 LSLesotho
 LRLiberia
 LYLibya
 LILiechtenstein
 LTLithuania
 LULuxembourg
 MOMacau
 MKMacedonia
 MGMadagascar
 MWMalawi
 MYMalaysia
 MVMaldives
 MLMali
 MTMalta
 MHMarshall Islands
 MQMartinique
 MRMauritania
 MUMauritius
 YTMayotte
 MXMexico
 FMMicronesia
 MDMoldova
 MCMonaco
 MNMongolia
 MEMontenegro
 MSMontserrat
 MAMorocco
 MZMozambique
 MMMyanmar
 NANamibia
 NRNauru
 NPNepal
 NLNetherlands
 ANNetherlands Antilles
 NCNew Caledonia
 NZNew Zealand
 NINicaragua
 NENiger
 NGNigeria
 NUNiue
 NFNorfolk Island
 XBNorthern Ireland
 MPNorthern Mariana Islands
 NONorway
 OMOman
 PKPakistan
 PWPalau
 PSPalestinian Territory
 PAPanama
 PGPapua New Guinea
 PYParaguay
 PEPeru
 PHPhilippines
 PNPitcairn
 PLPoland
 PTPortugal
 PRPuerto Rico
 QAQatar
 REReunion
 RORomania
 RURussia
 RWRwanda
 LCSaint Lucia
 BLSaint-Barthelemy
 MFSaint-Martin
 SMSan Marino
 STSao Tome And Principe
 SASaudi Arabia
 WYScotland
 SNSenegal
 RSSerbia
 YUSerbia and Montenegro
 CSSerbia and Montenegro
 SCSeychelles
 SLSierra Leone
 SGSingapore
 SKSlovak Republic
 SISlovenia
 SBSolomon Islands
 SOSomalia
 ZASouth Africa
 GSSouth Georgia
 ESSpain
 LKSri Lanka
 SHSt. Helena
 KNSt. Kitts & Nevis
 PMSt. Pierre
 VCSt. Vincent & The Grenadines
 SDSudan
 SRSuriname
 SJSvalbard And Jan Mayen Islands
 SZSwaziland
 SESweden
 CHSwitzerland
 SYSyria
 TWTaiwan
 TJTajikistan
 TZTanzania
 THThailand
 TLTimor-Leste
 TGTogo
 TKTokelau
 TOTonga
 TTTrinidad And Tobago
 TNTunisia
 TRTurkey
 TMTurkmenistan
 TCTurks And Caicos Islands
 TVTuvalu
 UMU.S. Minor Outlying Islands
 UGUganda
 UAUkraine
 AEUnited Arab Emirates
 GBUnited Kingdom
 USUnited States
 UYUruguay
 UZUzbekistan
 VUVanuatu
 VAVatican City State
 VEVenezuela
 VNVietnam
 VGVirgin Islands (British)
 VIVirgin Islands (U.S.)
 WXWales
 WFWallis And Futuna Islands
 EHWestern Sahara
 WSWestern Samoa
 YEYemen
 ZRZaire
 ZMZambia
 ZWZimbabwe
- themes_for_layout
 6Art & Culture
 10Famille & Enfant
 7Festival & Tradition
 12Gastronomie
 11Insolite & Curieux
 13Marché & Shopping
 5Musique
 8Nature
 4Parc & Jardin
 9Sport
- themes_images_for_layout
 6art0.png
 4parc1.png
 5musique0.png
 7festival0.png
 8nature0.png
 9sport0.png
 10famille0.png
 11insolite0.png
 12gastronomie0.png
 13shopping0.png
- envies_for_layout
 19BABY SITTING
 5BEACH
 6BICYCLE RENTAL
 24CIGAR LOUNGE
 8CITY
 25COUNTRYSIDE
 4DESERT
 10DIVING
 12ECOLOGY
 7FISHING
 9GOLF
 22HANDICAP ACCESS
 30HELIPORT
 14HORSEBACK RIDING
 26HUNTING
 21INTERNET ACCESS
 3ISLAND
 1JUNGLE
 13LAKE
 27POLO
 18POOL
 11SAFARI
 28SAILING
 29SHOPPING
 16SKIING
 15SPA
 23TENNIS
 2TREKKING
 17WINERY
- countries_for_layout
 0
 Country
 idAL
 nameAlbania
 name_freAlbanie
 1
 Country
 idAD
 nameAndorra
 name_freAndorre
 2
 Country
 idAI
 nameAnguilla
 name_freAnguilla
 3
 Country
 idAG
 nameAntigua/Barbuda
 name_freAntigua-Et-Barbuda
 4
 Country
 idAR
 nameArgentina
 name_freArgentine
 5
 Country
 idAM
 nameArmenia
 name_freArménie
 6
 Country
 idAU
 nameAustralia
 name_freAustralie
 7
 Country
 idAT
 nameAustria
 name_freAutriche
 8
 Country
 idAZ
 nameAzerbaijan
 name_freAzerbaïdjan
 9
 Country
 idBS
 nameBahamas
 name_freBahamas
 10
 Country
 idBB
 nameBarbados
 name_freBarbade
 11
 Country
 idBE
 nameBelgium
 name_freBelgique
 12
 Country
 idBZ
 nameBelize
 name_freBelize
 13
 Country
 idBM
 nameBermuda
 name_freBermudes
 14
 Country
 idBT
 nameBhutan
 name_freBhoutan
 15
 Country
 idBO
 nameBolivia
 name_freBolivie
 16
 Country
 idBA
 nameBosnia
 name_freBosnie-Herzégovine
 17
 Country
 idBR
 nameBrazil
 name_freBrésil
 18
 Country
 idKH
 nameCambodia
 name_freCambodge
 19
 Country
 idCA
 nameCanada
 name_freCanada
 20
 Country
 idCL
 nameChile
 name_freChili
 21
 Country
 idCN
 nameChina
 name_freChine
 22
 Country
 idCO
 nameColombia
 name_freColombie
 23
 Country
 idCK
 nameCook Islands
 name_freÎles Cook
 24
 Country
 idCR
 nameCosta Rica
 name_freCosta Rica
 25
 Country
 idHR
 nameCroatia
 name_freCroatie
 26
 Country
 idCZ
 nameCzech Republic
 name_freRépublique Tchèque
 27
 Country
 idDK
 nameDenmark
 name_freDanemark
 28
 Country
 idDM
 nameDominica
 name_freDominique
 29
 Country
 idDO
 nameDominican Republic
 name_freRépublique Dominicaine
 30
 Country
 idEC
 nameEcuador
 name_freÉquateur
 31
 Country
 idEG
 nameEgypt
 name_freÉgypte
 32
 Country
 idEE
 nameEstonia
 name_freEstonie
 33
 Country
 idFJ
 nameFiji
 name_freFidji
 34
 Country
 idFI
 nameFinland
 name_freFinlande
 35
 Country
 idFR
 nameFrance
 name_freFrance
 36
 Country
 idPF
 nameFrench Polynesia
 name_frePolynésie Française
 37
 Country
 idDE
 nameGermany
 name_freAllemagne
 38
 Country
 idGR
 nameGreece
 name_freGrèce
 39
 Country
 idGD
 nameGrenada
 name_freGrenade
 40
 Country
 idGP
 nameGuadeloupe
 name_freGuadeloupe
 41
 Country
 idGT
 nameGuatemala
 name_freGuatemala
 42
 Country
 idHN
 nameHonduras
 name_freHonduras
 43
 Country
 idHK
 nameHong Kong
 name_freHong-Kong
 44
 Country
 idHU
 nameHungary
 name_freHongrie
 45
 Country
 idIS
 nameIceland
 name_freIslande
 46
 Country
 idIN
 nameIndia
 name_freInde
 47
 Country
 idID
 nameIndonesia
 name_freIndonésie
 48
 Country
 idIE
 nameIreland
 name_freIrlande
 49
 Country
 idIL
 nameIsrael
 name_freIsraël
 50
 Country
 idIT
 nameItaly
 name_freItalie
 51
 Country
 idJM
 nameJamaica
 name_freJamaïque
 52
 Country
 idJP
 nameJapan
 name_freJapon
 53
 Country
 idJO
 nameJordan
 name_freJordanie
 54
 Country
 idKE
 nameKenya
 name_freKenya
 55
 Country
 idLA
 nameLaos
 name_freLaos
 56
 Country
 idLV
 nameLatvia
 name_freLettonie
 57
 Country
 idLB
 nameLebanon
 name_freLiban
 58
 Country
 idLT
 nameLithuania
 name_freLituanie
 59
 Country
 idMO
 nameMacau
 name_freMacao
 60
 Country
 idMG
 nameMadagascar
 name_freMadagascar
 61
 Country
 idMY
 nameMalaysia
 name_freMalaisie
 62
 Country
 idMV
 nameMaldives
 name_freMaldives
 63
 Country
 idMU
 nameMauritius
 name_freMaurice
 64
 Country
 idMX
 nameMexico
 name_freMexique
 65
 Country
 idMN
 nameMongolia
 name_freMongolie
 66
 Country
 idME
 nameMontenegro
 name_freMonténégro
 67
 Country
 idMA
 nameMorocco
 name_freMaroc
 68
 Country
 idMZ
 nameMozambique
 name_freMozambique
 69
 Country
 idMM
 nameMyanmar
 name_freMyanmar
 70
 Country
 idNA
 nameNamibia
 name_freNamibie
 71
 Country
 idNL
 nameNetherlands
 name_frePays-Bas
 72
 Country
 idAN
 nameNetherlands Antilles
 name_freAntilles Néerlandaises
 73
 Country
 idNZ
 nameNew Zealand
 name_freNouvelle-Zélande
 74
 Country
 idNI
 nameNicaragua
 name_freNicaragua
 75
 Country
 idNO
 nameNorway
 name_freNorvège
 76
 Country
 idOM
 nameOman
 name_freOman
 77
 Country
 idPK
 namePakistan
 name_frePakistan
 78
 Country
 idPA
 namePanama
 name_frePanama
 79
 Country
 idPE
 namePeru
 name_frePérou
 80
 Country
 idPH
 namePhilippines
 name_frePhilippines
 81
 Country
 idPL
 namePoland
 name_frePologne
 82
 Country
 idPT
 namePortugal
 name_frePortugal
 83
 Country
 idPR
 namePuerto Rico
 name_frePorto Rico
 84
 Country
 idRE
 nameReunion
 name_freRéunion
 85
 Country
 idRO
 nameRomania
 name_freRoumanie
 86
 Country
 idRU
 nameRussia
 name_freRussie
 87
 Country
 idLC
 nameSaint Lucia
 name_freSainte-Lucie
 88
 Country
 idBL
 nameSaint-Barthelemy
 name_freSaint-Barthélemy
 89
 Country
 idSA
 nameSaudi Arabia
 name_freArabie Saoudite
 90
 Country
 idRS
 nameSerbia
 name_freSerbie
 91
 Country
 idSC
 nameSeychelles
 name_freSeychelles
 92
 Country
 idSG
 nameSingapore
 name_freSingapour
 93
 Country
 idSK
 nameSlovak Republic
 name_freSlovaquie
 94
 Country
 idSI
 nameSlovenia
 name_freSlovénie
 95
 Country
 idZA
 nameSouth Africa
 name_freAfrique Du Sud
 96
 Country
 idES
 nameSpain
 name_freEspagne
 97
 Country
 idLK
 nameSri Lanka
 name_freSri Lanka
 98
 Country
 idKN
 nameSt. Kitts & Nevis
 name_freSaint-Kitts-Et-Nevis
 99
 Country
 idVC
 nameSt. Vincent & The Grenadines
 name_freSaint-Vincent-Et-Les Grenadines
 100
 Country
 idSJ
 nameSvalbard And Jan Mayen Islands
 name_freSvalbard Et Île Jan Mayen
 101
 Country
 idSE
 nameSweden
 name_freSuède
 102
 Country
 idCH
 nameSwitzerland
 name_freSuisse
 103
 Country
 idTW
 nameTaiwan
 name_freTaïwan
 104
 Country
 idTZ
 nameTanzania
 name_freTanzanie
 105
 Country
 idTH
 nameThailand
 name_freThaïlande
 106
 Country
 idTN
 nameTunisia
 name_freTunisie
 107
 Country
 idTR
 nameTurkey
 name_freTurquie
 108
 Country
 idTC
 nameTurks And Caicos Islands
 name_freÎles Turks et Caïques
 109
 Country
 idUG
 nameUganda
 name_freOuganda
 110
 Country
 idUA
 nameUkraine
 name_freUkraine
 111
 Country
 idAE
 nameUnited Arab Emirates
 name_freÉmirats Arabes Unis
 112
 Country
 idGB
 nameUnited Kingdom
 name_freRoyaume-Uni
 113
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 114
 Country
 idUY
 nameUruguay
 name_freUruguay
 115
 Country
 idVU
 nameVanuatu
 name_freVanuatu
 116
 Country
 idVN
 nameVietnam
 name_freViet Nam
 117
 Country
 idVG
 nameVirgin Islands (British)
 name_freÎles Vierges Britanniques
 118
 Country
 idVI
 nameVirgin Islands (U.S.)
 name_freÎles Vierges Des États-Unis
 119
 Country
 idZW
 nameZimbabwe
 name_freZimbabwe
- staticSlugs
 0who-we-are
 1sitemap
 2terms-and-conditions
 3news
 4jobs
 5legal
 6credits
- userFavorites
 fav-event(empty)
 fav-hotel(empty)
- hotel
 Hotel
 id513
 starred0
 in0
 maintrack_hotel_id361306
 brand_codeBZ
 nameSunset Beach
 address35 Shore Road
 zip_code11965
 cityarea_id(null)
 city_id471
 region_id(null)
 state_id(null)
 country_idUS
 latitude41.093838
 longitude-72.346794
 zoom13
 rating0
 phone1 631 7492001
 reservation_phone(null)
 fax1 631 7491843
 emailreservations@sunsetbeachli.com
 created2011-06-30 15:05:46
 modified2011-07-05 15:09:19
 descriptionSunset Beach is a relaxing hideaway on secluded Shelter Island. The exquisite 20 room seasonal hotel has a charming restaurant and bar where you can take in the stunning sunset views across the picturesque Peconic Bay. Inspired by the Italian and French Rivieras - Sunset Beach is one of the most unique and beloved Long Island retreats.
 description_freLe Sunset Beach est un refuge de détente sur l'île isolée de Shelter. L'hôtel exquis de 20 chambres possède un charmant restaurant et bar où vous pourrez profiter de la vue magnifique et du coucher de soleil sur la baie pittoresque de Peconic. Inspiré par les Rivieras italiennes et françaises, le Sunset Beach est l'une des retraites les plus uniques et aimés de Long Island.
 amenityPets Allowed, Concierge Desk, Jogging Track, Massage, 24 Hour Front Desk, Wake-up Service, Golf, Coffee Shop, Lounge, Restaurant, Maid Service, Game Room, Porters, Air Conditioned, Connecting Rooms, No Smoking Rooms/Facilities, Parking, Laundry/Valet Services, Handicapped Rooms/Facilities, Security, AM/FM Alarm Clock, Radio, Terrace, Bathrobes, Television with Cable, Hairdryers Available, Iron, Ironing Board, Mini Bar, Telephone, Wireless Internet Access, CD Player, Ceiling Fan, DVD Player, Temperature Control, Satellite TV, Boating, Fishing.
 amenity_freAnimaux admis, Conciergerie, piste de jogging, massage, réception ouverte 24 heures, Service de réveil, Golf, Café, lounge, restaurant, Service de nettoyage, Salle de jeux, des porteurs, Air conditionné, chambres communicantes, chambres non fumeur / équipements, services de stationnement, blanchisserie / service de voiturier, chambres / équipements pour handicapés, la sécurité, réveil AM / FM, radio, terrasse, peignoirs, télévision avec câble, sèche-cheveux disponibles, fer et planche à repasser, mini bar, téléphone, accès Internet sans fil, lecteur CD, ventilateur, Lecteur DVD, contrôle de température, TV satellite, Nautisme, Pêche.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localeeng
 tagline
 City
 id471
 country_idUS
 state_id(null)
 maintrack_id(null)
 nameShelter Island
 main_key(null)
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id8952
 hotel_id513
 order2
 urihttp://images.pegs.com/imageRepo/1/0/18/679/609/1153135cdmssabrevfm_img_pho_000_nc__500661%7ESB___J.jpg
 ratio_hw0.75
 on_wall0
 1
 id8953
 hotel_id513
 order3
 urihttp://images.pegs.com/imageRepo/1/0/18/679/620/1153135cdmssabrevfm_img_pho_000_nc__500666%7ESB___J.jpg
 ratio_hw0.75
 on_wall0
 2
 id8954
 hotel_id513
 order4
 urihttp://images.pegs.com/imageRepo/1/0/18/679/630/1153135cdmssabrevfm_img_pho_000_nc__500667%7ESB___J.jpg
 ratio_hw1.34
 on_wall0
 3
 id8955
 hotel_id513
 order5
 urihttp://images.pegs.com/imageRepo/1/0/18/679/640/1153135cdmssabrevfm_img_pho_000_nc__500668%7ESB___J.jpg
 ratio_hw0.75
 on_wall0
 4
 id8956
 hotel_id513
 order6
 urihttp://images.pegs.com/imageRepo/1/0/18/679/650/1153135cdmssabrevfm_img_pho_000_nc__500669%7ESB___J.jpg
 ratio_hw0.75
 on_wall0
 Room
 0
 id2128
 typeOTH
 hotel_id513
 nameSunset Double Room
 descriptionSUNSET DOUBLE. 2FULLBEDS. 410SQFT.
 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
 id2129
 typeOTH
 hotel_id513
 nameSunset Queen Room
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 RatesPeriod(empty)
 Weather(false)
 News
 0
 News
 id5
 country_idUS
 created2011-08-12 08:29:50
 modified2011-08-12 08:29:50
 localeeng
 nameThe Statue of Liberty will close for a year
 descriptionThis symbol of the city of New York will be subject to restoration work.
 linkhttp://www.lefigaro.fr/international/2011/08/11/01003-20110811ARTFIG00412-la-statue-de-la-liberte-va-fermer-pendant-un-an.php
- relatedHotels
 0
 Hotel
 id1308
 starred0
 in0
 maintrack_hotel_id379486
 brand_codePH
 nameThe Ocean House
 address1 Bluff Avenue
 zip_code02891
 cityarea_id(null)
 city_id1237
 region_id(null)
 state_id(null)
 country_idUS
 latitude41.3103525655232
 longitude-71.8534234867554
 zoom13
 rating0
 phone1 401 315 5599
 reservation_phone(null)
 fax1 401 315 0585
 emailboutique@preferredhotelgroup.com
 created2011-11-15 08:03:21
 modified2011-11-16 10:03:47
 descriptionEscape from the everyday and indulge your senses at The Ocean House, the quintessential Victorian seaside hotel. From the simple yet sumptuous surroundings, to the inviting porches and serene terraces, to the sweeping grounds that lead down to the luxury of a sun-drenched private beach, The Ocean House is a celebration of the golden age of leisure. Located in the picturesque seaside village of Watch Hill, Rhode Island, each of The Ocean House's 49 guestrooms and suites is inspired by its magnificent oceanfront setting and take advantage of breathtaking ocean and bay views. A variety of dining options and menus, from light, modern cuisine to traditional chophouse fare, are designed to match every taste. And leisure activities include a full culinary education program, croquet, evening harbor cruises, and the 12,000-square-foot OH! Spa, which offers a full range of services for relaxation and rejuvenation, including a fitness center, yoga studio, and steam rooms.
 description_freEvadez-vous du quotidien et comblez vos sens à l'hôtel Ocean House, la quintessence d'un hôtel balnéaire victorien. Depuis les superbes environs, à l'invitation des porches et des terrasses calmes, aux motifs de balayage qui mènent à la magnifique plage privé baignée de soleil, Ocean House est un paradis pour les loisirs. Situé dans le pittoresque village balnéaire de Watch Hill, Rhode Island, chacune des chambres du Ocean House est inspiré par le cadre magnifique du bord de mer et des vues sur la baie à couper le souffle. Une variété d'options de restauration et de menus sont conçus pour correspondre à tous les goûts. Et les activités de loisirs incluent un programme d'éducation complète culinaires, croquet, croisières dans le port le soir, et le Spa qui propose une gamme complète de services pour la relaxation et le rajeunissement, y compris un centre de fitness, un studio de yoga, et des hammams.
 amenityHandicapped Rooms/Facilities, Wheel Chair Access, Concierge Desk, Tour Desk, Wedding Services, Meeting/Banquet Facilities, Conference Facilities, Elevators, Copy Service, Barber/Beauty Shop, Health Club, Fitness Center or Spa, Steam Bath, 24 Hour Room Service, 24 Hour Front Desk, Porters, Air Conditioned, Beach, On the Ocean, Security, Parking, Pool, Lounge, Restaurant, Maid Service, Shops/Commercial Services, Internet Access, Wireless Internet Access, Indoor Pool, Laundry/Valet Services, Turndown Service, Telephone, Television with Cable, Desk with lamp, Bathrobes, Coffee Maker in Room, Business Center, Computer Rental, FAX, Secretarial Service.
 amenity_freHandicapés chambres / équipements, l'accès aux fauteuils roulants, concierge, bureau d'excursions, services de mariage, salles de réunions / banquets, Salles de conférence, ascenseurs, service de photocopie, salon de coiffure / institut de beauté, club de santé, Centre de fitness ou Spa, Hammam, 24 Hour Room service, réception ouverte 24 heures, porteurs, Air Conditionné, Beach, sur l'océan, sécurité, parking, piscine, salon, restaurant, service de nettoyage, Magasins / Commerces, accès internet, accès Internet sans fil, piscine intérieure, blanchisserie / Services de voiturier, service de couvertures, téléphone, télévision avec câble, bureau avec lampe, peignoirs, Cafetière dans la chambre, centre d'affaires, location d'ordinateurs, fax, service de secrétariat.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localeeng
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id1237
 country_idUS
 state_id(null)
 maintrack_id(null)
 nameWatch Hill
 main_key(null)
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id19020
 hotel_id1308
 order2
 urihttp://images.pegs.com/imageRepo/1/0/25/716/96/H9WO2H07_J.jpg
 ratio_hw0.67
 on_wall0
 1
 id19021
 hotel_id1308
 order3
 urihttp://images.pegs.com/imageRepo/1/0/25/716/100/H9WO2H09_J.jpg
 ratio_hw1.48
 on_wall0
 2
 id19022
 hotel_id1308
 order4
 urihttp://images.pegs.com/imageRepo/1/0/25/716/105/H9WO2H0F_J.jpg
 ratio_hw0.70
 on_wall0
 3
 id19023
 hotel_id1308
 order5
 urihttp://images.pegs.com/imageRepo/1/0/25/716/110/H9WO2H05_J.jpg
 ratio_hw0.65
 on_wall0
 4
 id19024
 hotel_id1308
 order6
 urihttp://images.pegs.com/imageRepo/1/0/25/716/115/H9WO2H08_J.jpg
 ratio_hw0.65
 on_wall0
 5
 id19025
 hotel_id1308
 order7
 urihttp://images.pegs.com/imageRepo/1/0/25/716/119/H9WO2H0E_J.jpg
 ratio_hw0.72
 on_wall0
 6
 id19026
 hotel_id1308
 order8
 urihttp://images.pegs.com/imageRepo/1/0/25/716/123/H9WO2H0H_J.jpg
 ratio_hw0.66
 on_wall0
 7
 id19027
 hotel_id1308
 order9
 urihttp://images.pegs.com/imageRepo/1/0/25/716/82/H9WO2H02_J.jpg
 ratio_hw0.67
 on_wall0
 8
 id19028
 hotel_id1308
 order10
 urihttp://images.pegs.com/imageRepo/1/0/25/716/88/H9WO2D0B_J.jpg
 ratio_hw0.66
 on_wall0
 9
 id19029
 hotel_id1308
 order11
 urihttp://images.pegs.com/imageRepo/1/0/25/716/92/H9WO2D0D_J.jpg
 ratio_hw0.78
 on_wall0
 10
 id19030
 hotel_id1308
 order12
 urihttp://images.pegs.com/imageRepo/1/0/25/716/127/H9WO2H01_J.jpg
 ratio_hw0.81
 on_wall0
 11
 id19031
 hotel_id1308
 order13
 urihttp://images.pegs.com/imageRepo/1/0/25/716/131/H9WO2D03_J.jpg
 ratio_hw0.73
 on_wall0
 12
 id19032
 hotel_id1308
 order14
 urihttp://images.pegs.com/imageRepo/1/0/25/716/135/H9WO2D06_J.jpg
 ratio_hw0.66
 on_wall0
 13
 id19033
 hotel_id1308
 order15
 urihttp://images.pegs.com/imageRepo/1/0/25/716/139/H9WO2D0C_J.jpg
 ratio_hw0.66
 on_wall0
 14
 id19034
 hotel_id1308
 order16
 urihttp://images.pegs.com/imageRepo/1/0/25/716/143/H9WO2H0G_J.jpg
 ratio_hw0.83
 on_wall0
 15
 id19035
 hotel_id1308
 order17
 urihttp://images.pegs.com/imageRepo/1/0/25/716/149/H9WO2D04_J.jpg
 ratio_hw0.66
 on_wall0
 16
 id19036
 hotel_id1308
 order18
 urihttp://images.pegs.com/imageRepo/1/0/25/716/153/H9WO2D00_J.jpg
 ratio_hw0.77
 on_wall0
 17
 id19037
 hotel_id1308
 order19
 urihttp://images.pegs.com/imageRepo/1/0/25/716/157/H9WO2D0A_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id5143
 typeOTH
 hotel_id1308
 nameAccommodations
 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
 id2239
 localeeng
 modelHotel
 foreign_key1308
 fieldtagline
 content
 1
 id2240
 localefre
 modelHotel
 foreign_key1308
 fieldtagline
 content
 Envie
 0
 id5
 created2011-05-17 19:24:26
 modified2011-05-17 19:24:26
 1
 id7
 created2011-05-17 19:24:56
 modified2011-05-17 19:24:56
 2
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 3
 id18
 created2011-05-17 19:28:28
 modified2011-05-17 19:28:28
 4
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 5
 id22
 created2011-05-24 08:23:46
 modified2011-05-24 08:23:46
 6
 id25
 created2011-09-01 11:26:54
 modified2011-09-01 11:28:10
 7
 id28
 created2011-09-15 08:20:11
 modified2011-09-15 08:20:11
 1
 Hotel
 id1327
 starred0
 in0
 maintrack_hotel_id373430
 brand_codeYX
 nameThree Village Inn
 address150 Main Street
 zip_code11790
 cityarea_id(null)
 city_id1262
 region_id(null)
 state_id(null)
 country_idUS
 latitude40.9173550103488
 longitude-73.1476464074096
 zoom13
 rating0
 phone1 631 7510555
 reservation_phone(null)
 fax1 631 7510593
 emailinfo@threevillageinn.com
 created2011-11-23 08:25:46
 modified2011-11-24 16:31:57
 descriptionThe Three Village Inn is located in the quaint and historical town of Stony Brook overlooking scenic Stony Brook harbor. Step into the Three Village Inn and walk into history charm and tradition of a fine country Inn long regarded as the crown jewel of historic Stony Brook and one of Long Islands great hotels and restaurants. Relax and unwind in one of our 26 cozy guestrooms. Our private reception and dining rooms can help you celebrate your own special times Weddings Bar/Bat Mitzvahs Birthdays Anniversaries Graduations and Engagements. The Inn offers the perfect setting for business meetings seminars and overnight conferences.
 description_freL'hôtel Three Village Inn est situé dans la ville pittoresque et historique de Stony Brook surplombant le port. Entrez dans le Three Village Inn et marchez dans le charme et la tradition d'une auberge longtemps considéré comme le joyau de la couronne de la ville de Stony Brook. Détendez-vous dans l'une de nos 26 chambres confortables. Notre réception et salles à manger privées peuvent aussi vous aider à célébrer votre propre événement. L'auberge offre le cadre idéal pour des séminaires et des conférences et des réunions d'affaires.
 amenityFamily Plan, Business Center, Barber/Beauty Shop, Jogging Track, Massage, Fitness Center or Spa, Complimentary Continental Breakfast, 24 Hour Front Desk, Safe Deposit Box, Wake-up Service, Air Conditioned, Connecting Rooms, No Smoking Rooms/Facilities, Parking, Lounge, Restaurant, Tennis, Maid Service, Handicapped Rooms/Facilities, Security, Television with Cable, TV, Desk with lamp, Hairdryers Available, High speed internet access, Iron, Ironing Board, Private Bathroom, TV Remote Control, Sofa Bed, Telephone, Trouser Press, Voicemail, Wireless Internet Access, Temperature Control, Satellite TV, Fishing, Meal Plan - MAP/Half-board, Rural/Country, On the Ocean, 24 Hour Security.
 amenity_frePlan de la Famille, Centre d'affaires, salon de coiffure / institut de beauté, piste de jogging, massage, centre de fitness ou Spa, Petit déjeuner continental, réception ouverte 24 heures, coffre-fort, Service de réveil, air conditionné, Chambres communicantes, chambres non fumeur / chambres, parking, lounge, restaurant, tennis, Service d'entretien, chambres / équipements pour handicapés, sécurité, télévision avec câble, télévision, bureau avec lampe, sèche-cheveux disponibles, accès Internet haut débit, fer à repasser, planche à repasser, Salle de bain privée, TV Remote Control, canapé lit, téléphone, presse-pantalon, messagerie vocale, accès Internet sans fil, contrôle de température, de la télévision par satellite, Pêche, Repas - MAP / Demi-pension, pays rural, sur l'océan, la sécurité 24 heures.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localeeng
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id1262
 country_idUS
 state_id(null)
 maintrack_id(null)
 nameStony Brook
 main_key(null)
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id19280
 hotel_id1327
 order2
 urihttp://images.pegs.com/imageRepo/1/0/17/914/306/1137960cdmssabrevfm_img_pho_000_nc__414632%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 1
 id19281
 hotel_id1327
 order3
 urihttp://images.pegs.com/imageRepo/1/0/17/914/296/1137960cdmssabrevfm_img_pho_000_nc__414637%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 2
 id19282
 hotel_id1327
 order4
 urihttp://images.pegs.com/imageRepo/1/0/17/914/286/1137960cdmssabrevfm_img_pho_000_nc__414642%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 3
 id19283
 hotel_id1327
 order5
 urihttp://images.pegs.com/imageRepo/1/0/17/914/276/1137960cdmssabrevfm_img_pho_000_nc__414647%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 4
 id19284
 hotel_id1327
 order6
 urihttp://images.pegs.com/imageRepo/1/0/17/914/236/1137960cdmssabrevfm_img_pho_000_nc__414652%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 5
 id19285
 hotel_id1327
 order7
 urihttp://images.pegs.com/imageRepo/1/0/17/914/246/1137960cdmssabrevfm_img_pho_000_nc__414657%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 6
 id19286
 hotel_id1327
 order8
 urihttp://images.pegs.com/imageRepo/1/0/17/914/256/1137960cdmssabrevfm_img_pho_000_nc__414662%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 7
 id19287
 hotel_id1327
 order9
 urihttp://images.pegs.com/imageRepo/1/0/17/914/266/1137960cdmssabrevfm_img_pho_000_nc__414667%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 8
 id19288
 hotel_id1327
 order10
 urihttp://images.pegs.com/imageRepo/1/0/17/914/318/1137960cdmssabrevfm_img_pho_000_nc__414672%7EHOTELPHOTOS___J.jpg
 ratio_hw0.67
 on_wall0
 Room
 0
 id5211
 typeOTH
 hotel_id1327
 nameDeluxe Room with 2 Queen Beds
 descriptionDeluxe Room with 2 queen beds. Private bathroom- flat screen TV. IPOD docking station- high speed internet accesstelephone
 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
 id5212
 typeOTH
 hotel_id1327
 nameDeluxe Room with Fireplace
 descriptionDeluxe room with Fireplace. Queen or King bed private bathroom. Flat screen TV IPOd docking stationtelephone high speed internet access
 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
 id5213
 typeOTH
 hotel_id1327
 nameDeluxe Room with View of Harbor
 descriptionRoom with Queen or King bed. View of Harbor- private bathroom. Flat screen TV- IPOD docking stationtelephone high speed internet access
 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
 id5214
 typeOTH
 hotel_id1327
 nameStandard 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
 id2277
 localeeng
 modelHotel
 foreign_key1327
 fieldtagline
 content
 1
 id2278
 localefre
 modelHotel
 foreign_key1327
 fieldtagline
 content
 Envie
 0
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 1
 id7
 created2011-05-17 19:24:56
 modified2011-05-17 19:24:56
 2
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 3
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 4
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 5
 id22
 created2011-05-24 08:23:46
 modified2011-05-24 08:23:46
 6
 id23
 created2011-05-24 08:28:10
 modified2011-05-24 08:28:10
 2
 Hotel
 id578
 starred0
 in0
 maintrack_hotel_id346985
 brand_codeWB
 nameCastle Hill Inn and Resort
 address590 Ocean Avenue
 zip_code02840
 cityarea_id(null)
 city_id534
 region_id(null)
 state_id(null)
 country_idUS
 latitude41.4599
 longitude-71.358299
 zoom13
 rating0
 phone1 401 8493800
 reservation_phone(null)
 fax1 401 8493838
 emailcastlehill@relaischateaux.com
 created2011-07-12 17:55:05
 modified2011-07-12 18:11:41
 descriptionSet in sixteen hectares of grounds bordering the ocean, this magnificent resort is a romantic haven of well-being. Whether you are in your suite, relaxing on the terrace or sitting at a table in the restaurant; you will always have a panoramic view of the deep blue of the Atlantic. For a long time this extraordinarily beautiful stretch of the ocean was the theatre for Americas Cup regattas. On the menu are local and regional cuisine and exceptional wines. And you can discover Newport- a magnet for music lovers from around the world with its two festivals devoted to jazz and folk music.
 description_freSitué dans seize hectares de terrains bordant l'océan, ce magnifique hôtel est un havre romantique de bien-être. Que vous soyez dans votre suite, vous détendre sur la terrasse ou assis à une table au restaurant, vous aurez toujours une vue panoramique sur le bleu profond de l'Atlantique. Pendant longtemps, ce coin d'une beauté extraordinaire de l'océan a été le théâtre de régates: Coupe de l'America. Au menu une cuisine locale et régionale et des vins exceptionnels. Et vous pouvez découvrir Newport: un aimant pour les amateurs de musique de partout dans le monde avec ses deux festivals consacrés au jazz et à la musique folklorique.
 amenityBabysitting/Child Services, Casino, Concierge, Handicapped Rooms/Facilities, Pool, Restaurant, Fitness Center or Spa, Laundry/Valet Services, Golf, Air Conditioned, Hairdryers Available, No Smoking Rooms/Facilities, Tennis, Concierge Desk, Childrens Activities, Car Rental Desk, Theater Desk, Tour Desk, Complimentary Continental Breakfast, Room Service, Meeting/Banquet Facilities, Conference Facilities, Copy Service, Barber Shop, Barber/Beauty Shop, Exercise Gym, Jogging Track, Sauna, Doorman, Porters, Wake-up Service, Connecting Rooms, Heated Guest Rooms, Ice Machine, Ironing Board, Kitchenette, Security, Toilet, Parking, Lounge, Multilingual, Turndown Service, Boutiques, Drugstore, Florist, News Stand, Telephone, AM/FM Alarm Clock, Radio, Terrace, Bathrobes, Television with Cable, Coffee Maker in Room, TV, Cordless Phone, Desk with lamp, Fire Place, Iron, Jacuzzi, Kitchen, Microwave, Private Bathroom, TV Remote Control, Safe, Shower, Sofa Bed, Phone with speaker, Trouser Press, Voicemail, Wet Bar, Wireless Internet Access, CD Player, Multi-line Phone, Ceiling Fan, DVD Player, Temperature Control, Outlet Adapters, Satellite TV, Skiing, Beach, Business Center, Audio Visual Equipment, FAX, Secretarial Service, Continental Breakfast, Meal Plan - FAP/Full-board, Meal Plan - MAP/Half-board.
 amenity_freBabysitting / Services à l'enfance, Casino, concierge, chambres / équipements pour handicapés, piscine, restaurant, centre de fitness ou Spa, blanchisserie / Services, Golf, Air Conditionné, Sèche-cheveux disponibles, No Smoking / chambres, tennis, concierge, activités pour enfants, Location de voitures, bureau de Théâtre, bureau d'excursions, petit déjeuner continental, service en chambre, salles de réunions / banquets, Salles de conférence, service de cliché, Barber Shop, salon de coiffure / institut de beauté, gymnastique, piste de jogging, sauna, Portier, Porters, Réveil service d'entretien, Chambres communicantes, chambres d'hôtes chauffée, machine à glace, planche à repasser, kitchenette, sécurité, toilettes, parking, salon, multilingue, service de couvertures, Boutiques, Pharmacie, Fleuriste, stand Nouvelles, Téléphone, réveil AM / FM, Radio, terrasse, peignoirs, télévision avec câble Cafetière, dans la salle, TV, Téléphone sans fil, bureau avec lampe, cheminée, fer, jacuzzi, cuisine, micro-ondes, Salle de bain privée, TV avec télécommande, coffre, douche, canapé lit, téléphone avec haut-parleur , presse-pantalon, messagerie vocale, Bar, accès Internet sans fil, Lecteur CD, multi-ligne de téléphone, ventilateur de plafond, lecteur DVD, contrôle de température, Adaptateurs électriques, télévision satellite, ski, plage, centre d'affaires, équipement audio-visuel, fax, secrétariat service, petit déjeuner continental, Repas - FAP / pension complète, Repas - MAP / demi-pension.
 lowest_rate342.14
 lr_currencyUSD
 lr_people1
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localeeng
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id534
 country_idUS
 state_id(null)
 maintrack_id(null)
 nameNewport
 main_key(null)
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id9796
 hotel_id578
 order1
 uri111.jpg
 ratio_hw0.77
 on_wall0
 1
 id9797
 hotel_id578
 order2
 uri121.jpg
 ratio_hw0.82
 on_wall0
 2
 id9798
 hotel_id578
 order3
 uri131.jpg
 ratio_hw0.53
 on_wall0
 3
 id9799
 hotel_id578
 order4
 uri150.jpg
 ratio_hw0.76
 on_wall0
 4
 id9800
 hotel_id578
 order5
 uri12.jpg
 ratio_hw0.70
 on_wall0
 5
 id9801
 hotel_id578
 order6
 uri21.jpg
 ratio_hw0.42
 on_wall0
 6
 id9802
 hotel_id578
 order7
 uri30.jpg
 ratio_hw0.49
 on_wall0
 7
 id9803
 hotel_id578
 order8
 uri511.jpg
 ratio_hw0.67
 on_wall0
 8
 id9804
 hotel_id578
 order9
 uri52.jpg
 ratio_hw0.67
 on_wall0
 9
 id9805
 hotel_id578
 order10
 uri521.jpg
 ratio_hw0.49
 on_wall0
 10
 id9806
 hotel_id578
 order11
 uri80.jpg
 ratio_hw0.53
 on_wall0
 11
 id9807
 hotel_id578
 order12
 uri211.jpg
 ratio_hw0.83
 on_wall0
 Room
 0
 id2340
 typeOTH
 hotel_id578
 nameBeach House
 descriptionon private beach-king bed-fireplace-jacuzzi tub-semi private deck-galley kitchen 315 sq ft
 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
 id2341
 typeOTH
 hotel_id578
 nameMaster Bedroom
 descriptionInn Room- King size bed-Bay view-original antiques-oversized whirlpool tub-400sq ft
 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
 id2342
 typeOTH
 hotel_id578
 nameBeach Cottage
 descriptionCottage located on the beach-queen bed-semi private porches overlooking ocean 200 sq ft
 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
 id2343
 typeOTH
 hotel_id578
 nameNautilus Beach Cottage
 descriptionsolo cottage located on the beach-queen bed-private porch-fireplace-whirlpool- 205 sq ft
 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
 id2344
 typeOTH
 hotel_id578
 nameSuperior Beach Cottage
 descriptionCorner unit loacted on private beach- ocean front-queen bed- 250 sq ft
 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
 id2345
 typeOTH
 hotel_id578
 nameLighthouse Suite
 descriptionInn Suite-King Bed-separate seating area-soaking tub-fireplace-480 sq ft
 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
 6
 id2346
 typeOTH
 hotel_id578
 nameTurret Suite
 descriptionBi-level suite-King bed-panoramic water view-soaking tub in bedroom 400 sq ft
 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
 7
 id2347
 typeOTH
 hotel_id578
 nameSuperior Beach House
 descriptioncorner unit on private beach-king bed-fireplace-jacuzzi tub-galley kitchen 315 sq ft
 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
 8
 id2348
 typeOTH
 hotel_id578
 nameBridge Room
 descriptionInn Room-Bay View-King bed-soaking tub-marble shower-255 sq ft
 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
 9
 id2349
 typeOTH
 hotel_id578
 nameEast Room 2
 descriptionInn room- whirlpool- fireplace-king bed 205 sq ft
 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
 10
 id2350
 typeOTH
 hotel_id578
 nameEast Room 3
 descriptionInn room- whirlpool- fireplace-king bed 205 sq ft
 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
 11
 id2351
 typeOTH
 hotel_id578
 nameHarbor House
 descriptionQueen bed-fireplace -panoramic water view- porch-220 sq ft
 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
 12
 id2352
 typeOTH
 hotel_id578
 nameMary Walsh Room
 descriptionInn Room-King Bed-water view-fireplace-soaking tub-230 sq ft
 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
 13
 id2353
 typeOTH
 hotel_id578
 nameRose Room
 descriptionInn Room-Partial view-King Bed-fireplace-original antiques-265 sq ft
 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
 14
 id2354
 typeOTH
 hotel_id578
 nameAgassiz 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
 id801
 localeeng
 modelHotel
 foreign_key578
 fieldtagline
 content
 1
 id802
 localefre
 modelHotel
 foreign_key578
 fieldtagline
 content
 Envie
 0
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 1
 id5
 created2011-05-17 19:24:26
 modified2011-05-17 19:24:26
 2
 id6
 created2011-05-17 19:24:42
 modified2011-05-24 08:22:46
 3
 id9
 created2011-05-17 19:26:00
 modified2011-05-17 19:26:00
 4
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 5
 id18
 created2011-05-17 19:28:28
 modified2011-05-17 19:28:28
 6
 id19
 created2011-05-24 08:21:45
 modified2011-05-24 08:21:45
 7
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 8
 id22
 created2011-05-24 08:23:46
 modified2011-05-24 08:23:46
 9
 id23
 created2011-05-24 08:28:10
 modified2011-05-24 08:28:10
- relatedEvents
 0
 Event
 id915
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationWainscott Beach, Wainscott, État de New York 11975, États-Unis
 latitude40.9265
 longitude-72.2381
 zoom13
 state_id(null)
 country_id
 created2012-02-09 17:59:02
 modified2012-02-09 17:59:02
 url(null)
 comment_count0
 former_business_id1599
 localeeng
 nameBEACHES IN HAMPTONS
 descriptionTo swim and sunbathe, direction Wainscott Beach.
 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
 id5461
 localeeng
 modelEvent
 foreign_key915
 fieldname
 contentBEACHES IN HAMPTONS
 1
 id5462
 localefre
 modelEvent
 foreign_key915
 fieldname
 contentLES PLAGES DES HAMPTONS
 Descriptions
 0
 id5463
 localeeng
 modelEvent
 foreign_key915
 fielddescription
 contentTo swim and sunbathe, direction Wainscott Beach.
 1
 id5464
 localefre
 modelEvent
 foreign_key915
 fielddescription
 contentPour vous baigner et prendre le soleil, direction Wainscott Beach.
 Links
 0
 id5465
 localeeng
 modelEvent
 foreign_key915
 fieldlink
 content
 1
 id5466
 localefre
 modelEvent
 foreign_key915
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 1
 Event
 id1989
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location17 Race Ln, East Hampton, État de New York 11937, États-Unis
 latitude40.9643
 longitude-72.1953
 zoom12
 state_id(null)
 country_id
 created2012-02-09 18:07:41
 modified2012-02-09 18:07:41
 url(null)
 comment_count0
 former_business_id1601
 localeeng
 nameMAKE YOUR OWN CLAMBAKE
 descriptionOrganize your own "Clambake" a party on the beach for a barbecue seafood Claws on Wheels takes care of everything, heads ... clams.
 linkhttp://www.yellowbook.com/profile/claws-on-wheels-fish-market_1821837817.html
 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
 id11905
 localeeng
 modelEvent
 foreign_key1989
 fieldname
 contentMAKE YOUR OWN CLAMBAKE
 1
 id11906
 localefre
 modelEvent
 foreign_key1989
 fieldname
 contentFAITES VOTRE PROPRE CLAMBAKE
 Descriptions
 0
 id11907
 localeeng
 modelEvent
 foreign_key1989
 fielddescription
 contentOrganize your own "Clambake" a party on the beach for a barbecue seafood Claws on Wheels takes care of everything, heads ... clams.
 1
 id11908
 localefre
 modelEvent
 foreign_key1989
 fielddescription
 contentOrganisez votre propre "Clambake" une fête sur la plage autour d'un barbecue de fruits de mer. Claws on Wheels s'occupe de tout, des chefs... aux palourdes.
 Links
 0
 id11909
 localeeng
 modelEvent
 foreign_key1989
 fieldlink
 contenthttp://www.yellowbook.com/profile/claws-on-wheels-fish-market_1821837817.html
 1
 id11910
 localefre
 modelEvent
 foreign_key1989
 fieldlink
 contenthttp://www.yellowbook.com/profile/claws-on-wheels-fish-market_1821837817.html
 Hotel(empty)
 Theme(empty)
 2
 Event
 id1988
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location6 Tuthill Rd, Montauk, État de New York 11954, États-Unis
 latitude41.0518
 longitude-71.9576
 zoom13
 state_id(null)
 country_id
 created2012-02-09 18:02:23
 modified2012-02-09 18:02:23
 url(null)
 comment_count0
 former_business_id1600
 localeeng
 nameTHE DECK IN HAMPTONS
 descriptionWith its wooden terrace overlooking the sea, Durye's Lobster Deck is known for its sandwiches to lobster and clam chowder (lunch and dinner every day of summer).
 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
 id11899
 localeeng
 modelEvent
 foreign_key1988
 fieldname
 contentTHE DECK IN HAMPTONS
 1
 id11900
 localefre
 modelEvent
 foreign_key1988
 fieldname
 contentLA TABLE DES HAMPTONS
 Descriptions
 0
 id11901
 localeeng
 modelEvent
 foreign_key1988
 fielddescription
 contentWith its wooden terrace overlooking the sea, Durye's Lobster Deck is known for its sandwiches to lobster and clam chowder (lunch and dinner every day of summer).
 1
 id11902
 localefre
 modelEvent
 foreign_key1988
 fielddescription
 contentAvec sa terrasse de bois surplombant la mer, Durye's Lobster Deck est réputé pour ses sandwichs aux homards et sa soupe de palourdes (déjeuner et dîner tous les jours de l'été).
 Links
 0
 id11903
 localeeng
 modelEvent
 foreign_key1988
 fieldlink
 content
 1
 id11904
 localefre
 modelEvent
 foreign_key1988
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 3
 Event
 id1845
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationWatch Hill, Westerly, Rhode Island 02891, États-Unis
 latitude41.3137
 longitude-71.8498
 zoom13
 state_id(null)
 country_id
 created2011-12-12 17:13:17
 modified2011-12-12 17:13:17
 url(null)
 comment_count0
 former_business_id1453
 localeeng
 nameWALKING IN WATCH HILL
 descriptionWatch Hill is a classic seaside village of New England, with a special grace of its own. The Phare 1856 silhouette shapes, decorated the streets are lined with shops and galleries, antique shops and restaurants. The famous horse carousel is the oldest continuously operating carousel in the country, the horses hand-carved stools have leather. The air from the ocean and the sun through the scenic parks, and the flocks of sailboats in the bay. A walk in Watch Hill to enjoy a homemade ice cream is a rite of passage for everyone.
 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
 id11041
 localeeng
 modelEvent
 foreign_key1845
 fieldname
 contentWALKING IN WATCH HILL
 1
 id11042
 localefre
 modelEvent
 foreign_key1845
 fieldname
 contentBALADE DANS WATCH HILL
 Descriptions
 0
 id11043
 localeeng
 modelEvent
 foreign_key1845
 fielddescription
 contentWatch Hill is a classic seaside village of New England, with a special grace of its own. The Phare 1856 silhouette shapes, decorated the streets are lined with shops and galleries, antique shops and restaurants. The famous horse carousel is the oldest continuously operating carousel in the country, the horses hand-carved stools have leather. The air from the ocean and the sun through the scenic parks, and the flocks of sailboats in the bay. A walk in Watch Hill to enjoy a homemade ice cream is a rite of passage for everyone.
 1
 id11044
 localefre
 modelEvent
 foreign_key1845
 fielddescription
 contentWatch Hill est un village balnéaire classique de la Nouvelle-Angleterre, avec une grâce particulière qui lui est propre. Le Phare 1856 façonne sa silhouette; les rues aménagées sont bordées de boutiques et de galeries, magasins d'antiquités et de restaurants. Le célèbre Cheval de carrousel est le plus vieux carrousel en fonctionnement continu dans le pays; les chevaux sculptés à la main possèdent des selles en cuir. L'air de l'océan et le soleil à travers les parcs pittoresques, et les troupeaux de voiliers dans la baie. Une marche dans Watch Hill pour goûter une crème glacée maison est un rite de passage pour tout le monde.
 Links
 0
 id11045
 localeeng
 modelEvent
 foreign_key1845
 fieldlink
 content
 1
 id11046
 localefre
 modelEvent
 foreign_key1845
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 4
 Event
 id1831
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location680 Bellevue Ave, Tour de Newport, Rhode Island 02840, États-Unis
 latitude41.4552
 longitude-71.3054
 zoom13
 state_id(null)
 country_id
 created2011-12-12 12:08:49
 modified2011-12-12 12:08:49
 url(null)
 comment_count0
 former_business_id1439
 localeeng
 nameVISIT HOME OF DORIS DUKE
 descriptionWelcome to the home of Doris Duke Newport, a rich heiress, philanthropist and art collector. Enjoy the beautiful grounds by the sea, still decorated as it left you will see French furniture, European art, Chinese porcelain, Turkish carpets and collected during his travels around the world. Rough Point is located on Bellevue Avenue Newport's exclusive, offers an ocean view and a large estate designed by renowned landscape architect Frederick Law Olmsted. All tours are conducted by a professional guide. Small groups of 12 to 14 people can intimate an experience relaxed and personal. Lasting about an hour, the tour will take you through the first floor of the house, then continue to the floor with a tour of Doris Duke's bedroom and the special exhibition galleries.
 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
 id10957
 localeeng
 modelEvent
 foreign_key1831
 fieldname
 contentVISIT HOME OF DORIS DUKE
 1
 id10958
 localefre
 modelEvent
 foreign_key1831
 fieldname
 contentVISITEZ LA MAISON DE DORIS DUKE
 Descriptions
 0
 id10959
 localeeng
 modelEvent
 foreign_key1831
 fielddescription
 contentWelcome to the home of Doris Duke Newport, a rich heiress, philanthropist and art collector. Enjoy the beautiful grounds by the sea, still decorated as it left you will see French furniture, European art, Chinese porcelain, Turkish carpets and collected during his travels around the world. Rough Point is located on Bellevue Avenue Newport's exclusive, offers an ocean view and a large estate designed by renowned landscape architect Frederick Law Olmsted. All tours are conducted by a professional guide. Small groups of 12 to 14 people can intimate an experience relaxed and personal. Lasting about an hour, the tour will take you through the first floor of the house, then continue to the floor with a tour of Doris Duke's bedroom and the special exhibition galleries.
 1
 id10960
 localefre
 modelEvent
 foreign_key1831
 fielddescription
 contentBienvenue dans la maison de Doris Duke à Newport, une riche héritière philanthrope et collectionneuse d'art. Profitez du magnifique domaine en bord de mer, encore décorée comme elle l'a laissé, vous verrez des meubles français, l'art européen, des porcelaines chinoises, et des tapis turcs recueillies lors de ses voyages autour du monde. Rough Point est situé sur l'avenue exclusive de Newport Bellevue, elle offre une vue sur l'océan et sur un vaste domaine conçu par le célèbre architecte paysagiste Frederick Law Olmsted. Toutes les visites sont conduites par un guide professionnel. De petits groupes de 12 à 14 personnes intimes permettent de vivre une expérience détendue et personnelle. D'une durée d'environ une heure, la visite vous fera passer par le premier étage de la maison, puis continuera à l'étage avec une visite de la chambre de Doris Duke et les galeries d'exposition particulière.
 Links
 0
 id10961
 localeeng
 modelEvent
 foreign_key1831
 fieldlink
 content
 1
 id10962
 localefre
 modelEvent
 foreign_key1831
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 5
 Event
 id1846
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location17-19 Bowery St, Tour de Newport, Rhode Island 02840, États-Unis
 latitude41.479
 longitude-71.312
 zoom13
 state_id(null)
 country_id
 created2011-12-12 17:18:06
 modified2011-12-12 17:18:06
 url(null)
 comment_count0
 former_business_id1454
 localeeng
 nameYACHTING IN RHODE ISLAND
 descriptionThe Ocean House Yachting Collection in collaboration with the Vintage Yachting Club and the America's Cup fleet, offers the possibility of chartering a variety of boats in the fleet of Ocean House for events or trips to the semi-day or full day, on weekends and weeks.
 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
 id11047
 localeeng
 modelEvent
 foreign_key1846
 fieldname
 contentYACHTING IN RHODE ISLAND
 1
 id11048
 localefre
 modelEvent
 foreign_key1846
 fieldname
 contentFAITES DE LA PLAISANCE A RODHE ISLANDS
 Descriptions
 0
 id11049
 localeeng
 modelEvent
 foreign_key1846
 fielddescription
 contentThe Ocean House Yachting Collection in collaboration with the Vintage Yachting Club and the America's Cup fleet, offers the possibility of chartering a variety of boats in the fleet of Ocean House for events or trips to the semi-day or full day, on weekends and weeks.
 1
 id11050
 localefre
 modelEvent
 foreign_key1846
 fielddescription
 contentL'Ocean House Yachting Collection, en collaboration avec le Yachting Club Millésime et la Flotte Coupe de l'America, vous offre la possibilité d'affréter une variété de bateaux de la flotte de Ocean House pour des événements ou des excursions à la demi-journée ou journée complète, pour des week-end et des semaines.
 Links
 0
 id11051
 localeeng
 modelEvent
 foreign_key1846
 fieldlink
 content
 1
 id11052
 localefre
 modelEvent
 foreign_key1846
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 6
 Event
 id1830
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationTour de Newport, Rhode Island, États-Unis
 latitude41.4901
 longitude-71.3128
 zoom12
 state_id(null)
 country_id
 created2011-12-12 11:58:39
 modified2011-12-12 11:58:39
 url(null)
 comment_count0
 former_business_id1438
 localeeng
 nameVISIT THE NEWPORT MANSIONS
 descriptionConservation Society of Newport County is a nonprofit organization whose mission is to protect, preserve and present a unique collection of house museums and landscapes in one of the most intact historic towns in America. The heritage of Newport Mansions is part of the living fabric of Newport in Rhode Island. These historic sites illustrate three centuries of the finest achievements of American architecture, decorative arts, and landscaping covering the colonial era and the Golden Age. Educational programs and related activities, engage the public in the history of America and its cultural heritage.
 linkhttp://www.newportmansions.org/
 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
 id10951
 localeeng
 modelEvent
 foreign_key1830
 fieldname
 contentVISIT THE NEWPORT MANSIONS
 1
 id10952
 localefre
 modelEvent
 foreign_key1830
 fieldname
 contentVISITEZ LES MAISONS HISTORIQUES DE NEWPORT
 Descriptions
 0
 id10953
 localeeng
 modelEvent
 foreign_key1830
 fielddescription
 contentConservation Society of Newport County is a nonprofit organization whose mission is to protect, preserve and present a unique collection of house museums and landscapes in one of the most intact historic towns in America. The heritage of Newport Mansions is part of the living fabric of Newport in Rhode Island. These historic sites illustrate three centuries of the finest achievements of American architecture, decorative arts, and landscaping covering the colonial era and the Golden Age. Educational programs and related activities, engage the public in the history of America and its cultural heritage.
 1
 id10954
 localefre
 modelEvent
 foreign_key1830
 fielddescription
 contentLa Société de conservation du comté de Newport est un organisme à but non lucratif dont la mission est de protéger, préserver et présenter une collection exceptionnelle de musées maison et des paysages dans l'une des villes historiques les plus intactes en Amérique. Le patrimoine des Newport Mansions fait partie intégrante du tissu vivant de Newport à Rhode Island. Ces sites historiques illustrent trois siècles des plus belles réalisations de l'architecture américaine, des arts décoratifs, et l'aménagement paysager couvrant l'ère coloniale et l'Age d'Or. Des programmes éducatifs et des activités annexes, engagent le public dans l'histoire de l'Amérique et de son patrimoine culturel.
 Links
 0
 id10955
 localeeng
 modelEvent
 foreign_key1830
 fieldlink
 contenthttp://www.newportmansions.org/
 1
 id10956
 localefre
 modelEvent
 foreign_key1830
 fieldlink
 contenthttp://www.newportmansions.org/
 Hotel(empty)
 Theme(empty)
 7
 Event
 id1378
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationMorris, Connecticut, États-Unis
 latitude41.6939
 longitude-73.2106
 zoom13
 state_id(null)
 country_id
 created2011-11-03 17:25:32
 modified2011-11-03 17:25:32
 url(null)
 comment_count0
 former_business_id984
 localeeng
 nameEXPERIENCE A BONFIRE AND S'MORES ROAST
 descriptionThe s'more is a dessert popular in the United States, traditionally eaten near a campfire. It consists of a toasted marshmallow and a square of chocolate between two biscuits. The word comes from the English s'more "some more" because it is impossible to eat just one.
 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
 id8239
 localeeng
 modelEvent
 foreign_key1378
 fieldname
 contentEXPERIENCE A BONFIRE AND S'MORES ROAST
 1
 id8240
 localefre
 modelEvent
 foreign_key1378
 fieldname
 contentMANGER DES GUIMAUVES AU COIN DU FEU
 Descriptions
 0
 id8241
 localeeng
 modelEvent
 foreign_key1378
 fielddescription
 contentThe s'more is a dessert popular in the United States, traditionally eaten near a campfire. It consists of a toasted marshmallow and a square of chocolate between two biscuits. The word comes from the English s'more "some more" because it is impossible to eat just one.
 1
 id8242
 localefre
 modelEvent
 foreign_key1378
 fielddescription
 contentLe s’more est un dessert très populaire aux États-Unis, traditionnellement mangé près d’un feu de camp. Il est composé d’une guimauve grillée et d’un carré de chocolat entre deux biscuits. Le mot s’more vient de l’anglais « some more » parce qu’il est impossible d'en manger qu’un seul.
 Links
 0
 id8243
 localeeng
 modelEvent
 foreign_key1378
 fieldlink
 content
 1
 id8244
 localefre
 modelEvent
 foreign_key1378
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
- weather(false)
- meta_description_for_layoutSunset Beach is a relaxing hideaway on secluded Shelter Island. The exquisite 20 room seasonal hotel has a charming restaurant and bar where you can take in the stunning sunset views across the picturesque Peconic Bay. Inspired by the Italian and French Rivieras - Sunset Beach is one of the most unique and beloved Long Island retreats.
- userData(null)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
 0paginator
 1simpleGraph
 2number
 3htmlToolbar
 4toolbar
 5tree
 6cleaner
 7commentWidget
 8javascript
 9imageCache
 10text
 11i18n
 12globesecret
 13arraySplitter
 14time
 15jqueryEngine
 16form
 17js
 18session
 19favorites
 20shareThis
 21breadcrumbs
 22html
 23assetCompress
====

Find an experience

Let us guide you

Find a boutique hotel

Search by desire

By country

Sunset Beach

Shelter Island, United States

0 comment

Book this hotel

Experiences close to the hotel

Globe Secret's guarantees

A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL

BOOKING AT NO ADDITIONAL COST

UNIQUE SELECTION CRITERIA

MORE TAILORED SERVICES

default

Query Explain:

Memory

Timers

warning

error

Find an experience

Let us guide you

Find a boutique hotel

Search by desire

By country

Sunset Beach

Shelter Island, United States

0 comment

Book this hotel

Experiences close to the hotel

Other hotels matching your criteria

Watch Hill, United States The Ocean House

Stony Brook, United States Three Village Inn

Newport, United States Castle Hill Inn and Resort

Read more

News

> The Statue of Liberty will close for a year

Link

Globe Secret's guarantees

A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL

BOOKING AT NO ADDITIONAL COST

UNIQUE SELECTION CRITERIA

MORE TAILORED SERVICES

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

warning

error

View Variables

Watch Hill, United States
The Ocean House

Stony Brook, United States
Three Village Inn

Newport, United States
Castle Hill Inn and Resort