Hastings House Country Estate

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

Cake Params
- controllerhotels
- actionview
- named(empty)
- pass
 0548
 1hastings-house-country-estate
- languagefr
- plugin(null)
- url
 exthtml
 urlfr/hotels/voir/548/hastings-house-country-estate
- form(empty)
- isAjax(false)
$_GET
- urlfr/hotels/voir/548/hastings-house-country-estate
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	9	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
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	1
SHOW FULL COLUMNS FROM `home_hotels`	4	4	1	maybe slow
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	5	maybe slow
SHOW FULL COLUMNS FROM `unavailabilities`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `envies`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `envie_i18n`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `envies_hotels`	2	2	1	maybe slow
SHOW FULL COLUMNS FROM `comments`	19	19	1	maybe slow
SHOW FULL COLUMNS FROM `users`	16	16	2	maybe slow
SHOW FULL COLUMNS FROM `addresses`	12	12	7	maybe slow
SHOW FULL COLUMNS FROM `janrain_profiles`	9	9	1	maybe slow
SHOW FULL COLUMNS FROM `admins`	15	15	1	maybe slow
SHOW FULL COLUMNS FROM `favorites`	8	8	1	maybe slow
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	1	maybe slow
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` = 548 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` = 549	1	1	1
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'CA'	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` = (548)	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` = (548)	6	6	2	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 (2239, 2240, 2241, 2242, 2243, 2244)	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` = (548) 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` = 'CA' ORDER BY `News`.`created` DESC	0	0	4	maybe slow
SELECT `Hotel`., `HomeHotel`., `City`., `Country`., `State`.*, `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'fre') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) LEFT JOIN `home_hotels` AS `HomeHotel` ON (`HomeHotel`.`hotel_id` = `Hotel`.`id`) WHERE `Hotel`.`published` = 1 AND `Hotel`.`id` != 548 AND `Hotel`.`longitude` BETWEEN -124.87041175147 AND -122.13279224853 AND `Hotel`.`latitude` BETWEEN 47.95966104058 AND 49.76073695942 ORDER BY ABS(`Hotel`.`longitude` - -123.501602) + ABS(`Hotel`.`latitude` - 48.860199) ASC LIMIT 3	3	3	15	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 (1105, 1157, 229)	37	37	10	maybe slow
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 (1105, 1157, 229)	18	18	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 (1105, 1157, 229)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1105, 1157, 229)	0	0	5	maybe slow
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 (1105, 1157, 229)	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 (1105, 1157, 229)	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 (1105, 1157, 229)	6	6	1	maybe slow
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 (1105, 1157, 229) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	22	22	2	maybe slow
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 -124.87041175147 AND -122.13279224853 AND `Event`.`latitude` BETWEEN 47.95966104058 AND 49.76073695942 ORDER BY ABS(`Event`.`longitude` - -123.501602) + ABS(`Event`.`latitude` - 48.860199) ASC LIMIT 10	6	6	28	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (1291, 1292, 496, 495, 1059, 497)	0	0	11	maybe slow
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 (1291, 1292, 496, 495, 1059, 497)	0	0	9	maybe slow
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 (1291, 1292, 496, 495, 1059, 497)	0	0	9	maybe slow
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 (1291, 1292, 496, 495, 1059, 497)	12	12	10	maybe slow
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 (1291, 1292, 496, 495, 1059, 497)	12	12	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 (1291, 1292, 496, 495, 1059, 497)	12	12	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 (1291, 1292, 496, 495, 1059, 497) 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 (1291, 1292, 496, 495, 1059, 497) 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	1
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	5	maybe slow
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	6	maybe slow
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1	10	10	2	maybe slow
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	2	maybe slow
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	6	maybe slow
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	4
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	6	maybe slow
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	20	maybe slow
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	2	maybe slow
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` = 548 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham')	1	1	2	maybe slow
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` = 548 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5	0	0	3	maybe slow

Query Explain:

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

====

Timer

+ –

Memory

Peak Memory Use 26,00 MB

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

Timers

Total Request Time: 1052 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	152,48
Component initialization and startup	7,04
Controller action	582,66
Render Controller Action	147,19
» Rendering View	137,40
» » Rendering APP/views/hotels/view.ctp	60,37
» » » Rendering APP/views/elements/sharing_widget.ctp	0,26
» » » Rendering APP/views/elements/comments/flat/main.ctp	0,59
» » » Rendering APP/views/elements/hotels/form_reservation.ctp	5,02
» » » Rendering APP/views/elements/events/related.ctp	1,70
» » » Rendering APP/views/elements/events/related.ctp #2	1,70
» » » Rendering APP/views/elements/events/related.ctp #3	1,43
» » » Rendering APP/views/elements/events/related.ctp #4	1,30
» » » Rendering APP/views/elements/events/related.ctp #5	1,36
» » » Rendering APP/views/elements/events/related.ctp #6	1,39
» » » Rendering APP/views/elements/events/legend.ctp	2,84
» » » Rendering APP/views/elements/hotels/related.ctp #7	0,82
» » » Rendering APP/views/elements/hotels/related.ctp #8	0,78
» » » Rendering APP/views/elements/hotels/related.ctp #9	0,79
» » Rendering APP/views/layouts/default.ctp	76,68
» » » Rendering APP/views/elements/google_analytics.ctp	0,14
» » » Rendering APP/views/elements/layout/top.ctp	2,44
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0,48
» » » Rendering APP/views/elements/layout/header.ctp	66,49
» » » Rendering APP/views/elements/layout/extra.ctp	0,31
» » » Rendering APP/views/elements/layout/footer.ctp	5,53
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0,53
» » » Rendering APP/views/elements/layout/footnotes.ctp	0,13

====

Log

+ –

Logs

warning

Time	Message
2023-04-01 18:54:02	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-04-01 18:54:02	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-04-01 18:54:02	Impossible to access the Google API
2023-04-01 18:54:02	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
 id548
 starred0
 in0
 maintrack_hotel_id261591
 brand_code000194
 nameHastings House Country Estate
 address160 Upper Ganges Rd
 zip_codeV8K 2S2
 cityarea_id(null)
 city_id549
 region_id(null)
 state_id(null)
 country_idCA
 latitude48.860199
 longitude-123.501602
 zoom8
 rating4
 phone1 250-537-2362
 reservation_phone1 1-800-525-4800
 fax1 250-537-5333
 emailinfo@hastingshouse.com
 created2011-07-09 16:04:39
 modified2011-07-13 12:31:31
 descriptionHastings House Country Hotel will be closing for the winter season on 9th November 2008 and looking forward to welcoming guests again on 13th March 2009. English country manor house meets Canadian inspiration at the secluded Hastings House, which overlooks the peaceful Ganges Harbour. 22 acres of flower gardens and rolling meadows surround this elegant Tudor-style country house where sophisticated island living includes one of the best restaurants in British Columbia, as well as an intimate spa.Return to an era of grace and simplicity as you enjoy afternoon tea in front of the Inglenook fireplace in the Living Room of the Manor House or on warmer days on the patio overlooking beautiful Ganges Harbour. Delicate earthy hues warm the spa for a relaxing massage in between the genteel activities of the Manor House.Each morning a wake-up hamper with fresh-baked muffins and tea or coffee will be placed outside your door. For those requiring a more substantial start to their day a full breakfast awaits you in the Manor House. Our award-winning dining room with exquisite regional cuisine and outstanding wine list will offer the perfect ending to your island-style day.Hastings House is a Small Luxury Hotels of the World property.
 description_freUn manoir de campagne anglaise d'inspiration canadien correspond bien à Hastings House, qui surplombe le port paisible. 10 hectares de jardins de fleurs et de prairies entourent cette élégante maison à colombages de style campagnard où la vie insulaire inclut l'un des meilleurs restaurants de la Colombie-Britannique, ainsi que d'un spa intime. Retour à l'ère de la grâce et la simplicité si vous aimez le thé l'après-midi devant la grande cheminée dans le salon du Manoir ou pendant les jours plus chauds sur la terrasse surplombant le magnifique port de Ganges. Chaque matin, un panier avec des produits frais de boulangerie: muffins et café ou thé sera placé devant votre porte. Pour ceux nécessitant un départ plus copieux auront un petit déjeuner complet dans le manoir. Notre cuisine régionale exquise et plusieurs fois primée vous offrira une expérience parfaite de l'île. Hastings House fait parti de Small Luxury Hotels.
 amenityLounge, Concierge, 24 Hour Front Desk, Restaurant, Safe Deposit Box, Fitness Center or Spa, Telephone, Shops/Commercial Services, Meeting/Banquet Facilities, City Center,
 amenity_freSalon, concierge, réception ouverte 24 heures, restaurant, coffre-fort, salle de gym ou de Spa, Téléphone, Magasins / Commerces, salles de réunions / banquets, centre-ville.
 lowest_rate395.00
 lr_currencyCAD
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 City
 id549
 country_idCA
 state_id(null)
 maintrack_id(null)
 nameSalt Spring Island
 main_key(null)
 Country
 idCA
 nameCanada
 name_freCanada
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id9398
 hotel_id548
 order2
 urihttp://images.pegs.com/imageRepo/1/0/28/30/628/H6D13L01_J.jpg
 ratio_hw1.51
 on_wall0
 1
 id9399
 hotel_id548
 order3
 urihttp://images.pegs.com/imageRepo/1/0/28/30/632/H6D13L02_J.jpg
 ratio_hw0.66
 on_wall0
 2
 id9400
 hotel_id548
 order4
 urihttp://images.pegs.com/imageRepo/1/0/28/30/636/H6D13L03_J.jpg
 ratio_hw1.51
 on_wall0
 3
 id9401
 hotel_id548
 order5
 urihttp://images.pegs.com/imageRepo/1/0/28/30/652/H6D13L06_J.jpg
 ratio_hw0.66
 on_wall0
 4
 id9402
 hotel_id548
 order6
 urihttp://images.pegs.com/imageRepo/1/0/28/30/671/H6D13L07_J.jpg
 ratio_hw0.66
 on_wall0
 5
 id9403
 hotel_id548
 order7
 urihttp://images.pegs.com/imageRepo/1/0/28/30/675/H6D13L09_J.jpg
 ratio_hw0.66
 on_wall0
 6
 id9404
 hotel_id548
 order8
 urihttp://images.pegs.com/imageRepo/1/0/28/30/688/H6D13L0D_J.jpg
 ratio_hw0.66
 on_wall0
 7
 id9405
 hotel_id548
 order9
 urihttp://images.pegs.com/imageRepo/1/0/28/30/692/H6D13L0J_J.jpg
 ratio_hw0.67
 on_wall0
 8
 id9406
 hotel_id548
 order10
 urihttp://images.pegs.com/imageRepo/1/0/28/30/696/Garden_J.jpg
 ratio_hw0.67
 on_wall0
 9
 id9407
 hotel_id548
 order11
 urihttp://images.pegs.com/imageRepo/1/0/26/169/455/hastingshouse0177_small_J.jpg
 ratio_hw0.65
 on_wall0
 10
 id9408
 hotel_id548
 order12
 urihttp://images.pegs.com/imageRepo/1/0/28/30/711/hayloft_J.jpg
 ratio_hw0.96
 on_wall0
 11
 id9409
 hotel_id548
 order13
 urihttp://images.pegs.com/imageRepo/1/0/26/169/463/hastingshouse1225_small_J.jpg
 ratio_hw0.67
 on_wall0
 12
 id9410
 hotel_id548
 order14
 urihttp://images.pegs.com/imageRepo/1/0/28/30/717/H6D13L05_J.jpg
 ratio_hw0.66
 on_wall0
 13
 id9411
 hotel_id548
 order15
 urihttp://images.pegs.com/imageRepo/1/0/28/30/730/H6D13L0B_J.jpg
 ratio_hw0.66
 on_wall0
 14
 id9412
 hotel_id548
 order16
 urihttp://images.pegs.com/imageRepo/1/0/28/30/734/H6D13L0E_J.jpg
 ratio_hw1.50
 on_wall0
 15
 id9413
 hotel_id548
 order17
 urihttp://images.pegs.com/imageRepo/1/0/28/30/738/H6D13L0H_J.jpg
 ratio_hw0.66
 on_wall0
 16
 id9414
 hotel_id548
 order18
 urihttp://images.pegs.com/imageRepo/1/0/28/30/742/H6D13L0I_J.jpg
 ratio_hw0.66
 on_wall0
 17
 id9415
 hotel_id548
 order19
 urihttp://images.pegs.com/imageRepo/1/0/28/30/746/hillside2_J.jpg
 ratio_hw0.96
 on_wall0
 18
 id9416
 hotel_id548
 order20
 urihttp://images.pegs.com/imageRepo/1/0/28/30/759/churhill%20interior_J.jpg
 ratio_hw0.75
 on_wall0
 19
 id9417
 hotel_id548
 order21
 urihttp://images.pegs.com/imageRepo/1/0/28/30/773/H6D13L00_J.jpg
 ratio_hw0.67
 on_wall0
 20
 id9418
 hotel_id548
 order22
 urihttp://images.pegs.com/imageRepo/1/0/28/30/777/H6D13L08_J.jpg
 ratio_hw1.50
 on_wall0
 21
 id9419
 hotel_id548
 order23
 urihttp://images.pegs.com/imageRepo/1/0/28/30/785/H6D13L0C_J.jpg
 ratio_hw1.50
 on_wall0
 22
 id9420
 hotel_id548
 order24
 urihttp://images.pegs.com/imageRepo/1/0/28/30/789/H6D13L0F_J.jpg
 ratio_hw0.66
 on_wall0
 23
 id9421
 hotel_id548
 order25
 urihttp://images.pegs.com/imageRepo/1/0/28/30/793/H6D13L0G_J.jpg
 ratio_hw0.66
 on_wall0
 24
 id9422
 hotel_id548
 order26
 urihttp://images.pegs.com/imageRepo/1/0/28/30/797/Chef%20marcel_J.jpg
 ratio_hw1.51
 on_wall0
 25
 id9423
 hotel_id548
 order27
 urihttp://images.pegs.com/imageRepo/1/0/28/30/808/Chocolate%20Beast_J.jpg
 ratio_hw1.50
 on_wall0
 26
 id9424
 hotel_id548
 order28
 urihttp://images.pegs.com/imageRepo/1/0/28/30/814/Cookies%20and%20Tea_J.jpg
 ratio_hw1.50
 on_wall0
 27
 id9425
 hotel_id548
 order29
 urihttp://images.pegs.com/imageRepo/1/0/28/30/827/crab%20cake_J.jpg
 ratio_hw0.67
 on_wall0
 28
 id9426
 hotel_id548
 order30
 urihttp://images.pegs.com/imageRepo/1/0/28/30/831/Crab%20Catch_J.jpg
 ratio_hw1.50
 on_wall0
 29
 id9427
 hotel_id548
 order31
 urihttp://images.pegs.com/imageRepo/1/0/28/30/835/Flower%20Cake_J.jpg
 ratio_hw0.67
 on_wall0
 30
 id9428
 hotel_id548
 order32
 urihttp://images.pegs.com/imageRepo/1/0/28/30/839/setting%20table_J.jpg
 ratio_hw1.04
 on_wall0
 31
 id9429
 hotel_id548
 order33
 urihttp://images.pegs.com/imageRepo/1/0/28/30/843/scallop_J.jpg
 ratio_hw0.66
 on_wall0
 32
 id9430
 hotel_id548
 order34
 urihttp://images.pegs.com/imageRepo/1/0/28/30/847/H6D13L04_J.jpg
 ratio_hw0.80
 on_wall0
 33
 id9431
 hotel_id548
 order35
 urihttp://images.pegs.com/imageRepo/1/0/28/30/860/Pacific%20Halibut_J.jpg
 ratio_hw1.50
 on_wall0
 34
 id9432
 hotel_id548
 order36
 urihttp://images.pegs.com/imageRepo/1/0/28/30/873/Woman%20and%20Cows_J.jpg
 ratio_hw0.66
 on_wall0
 35
 id9433
 hotel_id548
 order37
 urihttp://images.pegs.com/imageRepo/1/0/26/169/582/harbour%20view%20couple_J.jpg
 ratio_hw0.66
 on_wall0
 36
 id9434
 hotel_id548
 order38
 urihttp://images.pegs.com/imageRepo/1/0/28/30/879/Manour%20West_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id2239
 typeOTH
 hotel_id548
 nameCedar Clad Harbor View Suite
 descriptionOld World charm rooms with King bed-sitting room with fireplace in reconstructed Barn, some with sea views. Each room has ensuite baths, European linens and duvet, hairdryer, robes, fridge and CD players.
 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
 id2240
 typeOTH
 hotel_id548
 namePost Cottage
 descriptionPost Cottage-Private, stand-alone cottage with separate bedroom, living room wood burning stove, fridge, European linens, hairdryer, CD player, French Doors with sea, orchard and garden 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)
 2
 id2241
 typeOTH
 hotel_id548
 nameChurchill Cottage
 descriptionThree-bedroom country cottage with fireplace- full kitchen and spacious sea view deck. K-Q-S bedroom, 1 bath-fireplace-W/D-TV/DVD-dining-kitchen- hairdryer-European linens-CD player and CDs
 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
 id2242
 typeOTH
 hotel_id548
 nameHarbor View Suite
 descriptionSpacious harbor-view suites with private porch, warming fireplace and luxury bath.
 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
 id2243
 typeOTH
 hotel_id548
 nameTwo Room Suite
 descriptionTwo-room suite in historic home each uniquely furnished with antiques and chintz.
 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
 id2244
 typeOTH
 hotel_id548
 namePremier Suite
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 RatesPeriod(empty)
 Weather(false)
 News(empty)
- relatedHotels
 0
 Hotel
 id1105
 starred0
 in0
 maintrack_hotel_id378256
 brand_codeWV
 nameBrentwood Bay Resort
 address849 Verdier Avenue
 zip_codeV8M 1C5
 cityarea_id(null)
 city_id1037
 region_id(null)
 state_id(null)
 country_idCA
 latitude48.5777864285085
 longitude-123.464401
 zoom11
 rating0
 phone1 250 544 2079
 reservation_phone(null)
 fax1 205 544-2069
 emailreservations@brentwoodbaylodge.com
 created2011-09-12 15:23:31
 modified2011-09-13 13:14:49
 descriptionLocated in the heart of wine country close to the city of Victoria and minutes from The Butchart Gardens. The West Coast architecture of Brentwood Bay Lodge and Spa is dramatic and contemporary. The Lodge has 33 Ocean Suites with king beds, fireplaces, private patios and jetted tubs. Complimentary WI-FI and calling in North America. Dinning available in the Brentwood Pub and SeaGrille with its award-winning wine cellar. Indulge the senses at the Spa Essence of Life. Enjoy the sparkling swimming pool and hot tub.
 description_freSitué au cœur du pays du vin près de la ville de Victoria et à quelques minutes de The Butchart Gardens. L'architecture de Brentwood Bay Lodge and Spa est typique de la région et contemporaine. Le Lodge dispose de 33 Suites Océan avec lits king size, des cheminées, des patios privés et des baignoires à remous. Wi-Fi gratuit. Les repas sont servis dans le Pub Brentwood et Seagrille avec sa cave de vins primés. Offrez-vous les soins du Spa. Profitez de la piscine étincelante et un jacuzzi.
 amenityBrailled Elevators, Concierge Desk, Conference Facilities, Elevators, Guest Laundromat, Exercise Gym, Jogging Track, Massage, Fitness Center or Spa, 24 Hour Room Service, Room Service, 24 Hour Front Desk, Currency Exchange, Safe Deposit Box, Adjoining Rooms, Air Conditioned, ATM/Cash Machine, Heated Guest Rooms, Ice Machine, No Smoking Rooms/Facilities, Free Parking, Outdoor Parking, Golf, Heated Pool, Jacuzzi, Outdoor Pool, Lounge, Restaurant, 24 Hour Security, Maid Service, News Stand, Phone Service, Indoor Pool, Tennis, AM/FM Alarm Clock, Radio, Terrace, Bathroom Telephone, Television with Cable, Coffee Maker in Room, Fire Place, Free Local Telephone Calls, Hairdryers Available, High speed internet access, International Direct Dial, Iron, Ironing Board, King Bed, Mini Bar, Smoke Detectors, Vaulted Ceiling, Video Tapes, Free Newspaper, Cordless Phone, Shower, Sitting Area, Sofa Bed, Telephone, Sauna, Scuba Diving, Snorkeling, Audio Visual Equipment, FAX, Projector, Business Center, Meeting/Banquet Facilities.
 amenity_freAscenseurs en braille, un concierge, des installations de conférence, ascenseurs, Laverie, gymnastique, piste de jogging, massage, centre de fitness ou Spa, room service 24 heures, service en chambre, réception ouverte 24 heures, service de change, coffre-fort, chambres communicantes, Air Conditionné, ATM / Cash Machine, chambres d'hôtes chauffée, machine à glace, No Smoking / chambres, parking gratuit, parking extérieur, golf, piscine chauffée, jacuzzi, piscine extérieure, lounge, restaurant, Sécurité 24 heures, service d'entretien, stand Nouvelles, service téléphonique, piscine couverte, tennis, radio-réveil AM / FM, Radio, Terrasse, Salle de bains Téléphone, Télévision avec câble Cafetière, dans la salle, cheminée, Appels téléphoniques locaux gratuits, sèche-cheveux disponibles, accès internet haut débit, international Direct Dial, fer et planche à repasser, lit King, Mini Bar, détecteurs de fumée, plafond voûté, de cassettes vidéo, journal gratuit, Téléphone sans fil, douche, coin salon, canapé lit, téléphone, sauna, plongée sous-marine, apnée, matériel audiovisuel, FAX, projecteur, Business Center, salles de réunions / réceptions.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id1037
 country_idCA
 state_id(null)
 maintrack_id(null)
 nameVictoria
 main_key(null)
 Country
 idCA
 nameCanada
 name_freCanada
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id16421
 hotel_id1105
 order2
 urihttp://images.pegs.com/imageRepo/1/0/23/201/388/LobbyView_j_J.jpg
 ratio_hw1.00
 on_wall0
 1
 id16422
 hotel_id1105
 order3
 urihttp://images.pegs.com/imageRepo/1/0/23/987/871/IPYYJBBL_EXT_02_j_J.jpg
 ratio_hw1.00
 on_wall0
 2
 id16423
 hotel_id1105
 order4
 urihttp://images.pegs.com/imageRepo/1/0/23/987/875/IPYYJBBL_MSC_02_j_J.jpg
 ratio_hw0.67
 on_wall0
 3
 id16424
 hotel_id1105
 order5
 urihttp://images.pegs.com/imageRepo/1/0/23/987/879/IPYYJBBL_REST_01_j_J.jpg
 ratio_hw1.00
 on_wall0
 4
 id16425
 hotel_id1105
 order6
 urihttp://images.pegs.com/imageRepo/1/0/23/201/396/Pub_j_J.jpg
 ratio_hw1.00
 on_wall0
 5
 id16426
 hotel_id1105
 order7
 urihttp://images.pegs.com/imageRepo/1/0/23/987/883/IPYYJBBL_ROOM_01_j_J.jpg
 ratio_hw0.67
 on_wall0
 6
 id16427
 hotel_id1105
 order8
 urihttp://images.pegs.com/imageRepo/1/0/23/201/400/SeaGrille_j_J.jpg
 ratio_hw1.00
 on_wall0
 7
 id16428
 hotel_id1105
 order9
 urihttp://images.pegs.com/imageRepo/1/0/23/987/887/IPYYJBBL_SUITE_02_j_J.jpg
 ratio_hw1.00
 on_wall0
 8
 id16429
 hotel_id1105
 order10
 urihttp://images.pegs.com/imageRepo/1/0/23/201/404/Spa_j_J.jpg
 ratio_hw1.00
 on_wall0
 9
 id16430
 hotel_id1105
 order11
 urihttp://images.pegs.com/imageRepo/1/0/23/201/408/WelcomeExterior_j_J.jpg
 ratio_hw1.00
 on_wall0
 10
 id16431
 hotel_id1105
 order12
 urihttp://images.pegs.com/imageRepo/1/0/23/201/412/boardroom_j_J.jpg
 ratio_hw1.00
 on_wall0
 11
 id16432
 hotel_id1105
 order13
 urihttp://images.pegs.com/imageRepo/1/0/23/201/416/marina_j_J.jpg
 ratio_hw1.00
 on_wall0
 12
 id16433
 hotel_id1105
 order14
 urihttp://images.pegs.com/imageRepo/1/0/23/201/420/sunset_j_J.jpg
 ratio_hw1.00
 on_wall0
 13
 id16434
 hotel_id1105
 order15
 urihttp://images.pegs.com/imageRepo/1/0/24/27/10/WV1098222_Ext2_j_J.jpg
 ratio_hw0.85
 on_wall0
 14
 id16435
 hotel_id1105
 order16
 urihttp://images.pegs.com/imageRepo/1/0/24/27/14/WV1098222_Meet1_j_J.jpg
 ratio_hw0.68
 on_wall0
 15
 id16436
 hotel_id1105
 order17
 urihttp://images.pegs.com/imageRepo/1/0/24/27/18/WV1098222_Rec1_j_J.jpg
 ratio_hw1.50
 on_wall0
 16
 id16437
 hotel_id1105
 order18
 urihttp://images.pegs.com/imageRepo/1/0/24/27/22/WV1098222_Rest2_j_J.jpg
 ratio_hw1.01
 on_wall0
 17
 id16438
 hotel_id1105
 order19
 urihttp://images.pegs.com/imageRepo/1/0/19/926/854/1098222cdms_img_pho_000_nc__650162%7EBBLPool_And_Exterior___J.jpg
 ratio_hw1.01
 on_wall0
 18
 id16439
 hotel_id1105
 order20
 urihttp://images.pegs.com/imageRepo/1/0/23/131/70/1BOS%20Guestroom_J.jpg
 ratio_hw1.00
 on_wall0
 19
 id16440
 hotel_id1105
 order21
 urihttp://images.pegs.com/imageRepo/1/0/23/131/91/DOS%20Guestroom_J.jpg
 ratio_hw1.00
 on_wall0
 20
 id16441
 hotel_id1105
 order22
 urihttp://images.pegs.com/imageRepo/1/0/23/131/142/OS%20Guestroom_J.jpg
 ratio_hw1.00
 on_wall0
 Room
 0
 id4301
 typeOTH
 hotel_id1105
 nameOceanSuite
 descriptionEvery OceanSuite has 350 sq-ft of luxurious accommodation with a king bed private ocean view balcony fireplace. Spa-like bathroom with a jetted soaker tub and a separate body massage shower.
 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
 id4302
 typeOTH
 hotel_id1105
 nameDeluxe OceanSuite
 descriptionFor the ultimate in west coast style and absolute luxury the perfectly appointed One Bedroom OceanSuites have it all featuring a separate bedroom with a king bed living room area and outdoor patio with a private hot tub. The comfortable living area featur
 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
 id4303
 typeOTH
 hotel_id1105
 nameOne Bedroom OceanSuite
 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
 id1847
 localeeng
 modelHotel
 foreign_key1105
 fieldtagline
 content
 1
 id1848
 localefre
 modelHotel
 foreign_key1105
 fieldtagline
 content
 Envie
 0
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 1
 id3
 created2011-05-17 19:21:37
 modified2011-05-17 19:21:37
 2
 id7
 created2011-05-17 19:24:56
 modified2011-05-17 19:24:56
 3
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 4
 id9
 created2011-05-17 19:26:00
 modified2011-05-17 19:26:00
 5
 id10
 created2011-05-17 19:26:16
 modified2011-05-17 19:26:16
 6
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 7
 id18
 created2011-05-17 19:28:28
 modified2011-05-17 19:28:28
 8
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 9
 id23
 created2011-05-24 08:28:10
 modified2011-05-24 08:28:10
 1
 Hotel
 id1157
 starred0
 in0
 maintrack_hotel_id509327
 brand_codeYX
 nameAbigails Hotel
 address906 McClure Street
 zip_codeV8V 3E7
 cityarea_id(null)
 city_id1037
 region_id(null)
 state_id(null)
 country_idCA
 latitude48.4207231
 longitude-123.3594978
 zoom13
 rating0
 phone1 250 3885363
 reservation_phone(null)
 fax1 250 3887787
 emailinnkeeper@abigailshotel.com
 created2011-09-27 14:59:46
 modified2011-10-04 10:12:55
 descriptionSituated between famous downtown attractions, museums, concert halls, fine restaurants and stunning parks, discover Abigails Hotel in breathtaking Victoria BC. Housed in a distinguished 1930s heritage Tudor Mansion, this bed and breakfast boutique Hotel offers 23 carefully crafted guestrooms, each with its own special characteristic and flair. This unique hideaway features marvelous Jacuzzi baths, spa bathrobes, down duvets, rich linens, signature wood-burning fireplaces and exceptional service. Delight the senses with complimentary evening hors d'oeuvres. Surrender to a soothing spa massage. Wake to the irresistible aroma of gourmet breakfasts, personally presented by the Executive Chef. Experience the nature of elegance.
 description_freSitué entre les attractions célèbres, les musées, salles de concert, les restaurants et les parcs magnifiques, découvrez l'hôtel Abigails dans Victoria BC. Installé dans une maison Tudor 1930, ce bed and breakfast propose 23 chambres soigneusement élaboré, chacune avec ses propres caractéristiques spéciales. Ce refuge unique offre des caractéristiques comme : jacuzzi, peignoirs spa, couettes, draps soyeux, cheminée au bois et un service exceptionnel. Le plaisir des sens avec les plats du soir. Succombez à un massage apaisant au spa. Réveillez-vous au parfum irrésistible de petits déjeuners gastronomiques, présenté personnellement par le chef. Faites l'expérience de l'élégance naturelle.
 amenityPets Allowed, Play Ground, Jogging Track, Massage, Fitness Center or Spa, 24 Hour Front Desk, Safe Deposit Box, Air Conditioned, Hairdryers Available, Ironing Board, No Smoking Rooms/Facilities, Private Bathroom, Security, Golf, Restaurant, 24 Hour Security, Maid Service, News Stand, AM/FM Alarm Clock, Radio, Bathrobes, Television with Cable, Coffee Maker in Room, TV, Cordless Phone, Fire Place, In Room Movies, High speed internet access, Iron, Jacuzzi, TV Remote Control, Shower, Telephone, Voicemail, Wet Bar, Wireless Internet Access, DVD Player, Temperature Control, Satellite TV, Boating, Scuba Diving, City Center, Smoke Detectors.
 amenity_freAnimaux admis, Play Ground, piste de jogging, massage, centre de fitness ou Spa, réception ouverte 24 heures, coffre-fort, air conditionné, sèche-cheveux disponibles, planche à repasser, chambres non fumeur / équipements, Salle de bain privée, de sécurité, de golf, les restaurants, 24 heures de sécurité, service d'entretien, stand Nouvelles, réveil AM / FM, Radio, peignoirs, télévision avec câble Cafetière, dans la salle, TV, Téléphone sans fil, cheminée, Films dans la chambre, accès Internet haut débit, fer à repasser, jacuzzi, TV télécommande, douche, Téléphone, Messagerie vocale, Bar, accès Internet sans fil, lecteur DVD, contrôle de température, de la télévision par satellite, nautique, plongée, Centre Ville, des détecteurs de fumée.
 lowest_rate155.00
 lr_currencyCAD
 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
 id1037
 country_idCA
 state_id(null)
 maintrack_id(null)
 nameVictoria
 main_key(null)
 Country
 idCA
 nameCanada
 name_freCanada
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id16956
 hotel_id1157
 order2
 urihttp://images.pegs.com/imageRepo/1/0/30/82/15/Abigails-exterior-dusk-hd_J.jpg
 ratio_hw0.67
 on_wall0
 1
 id16957
 hotel_id1157
 order3
 urihttp://images.pegs.com/imageRepo/1/0/30/718/929/library-pano-hd_J.jpg
 ratio_hw0.50
 on_wall0
 2
 id16958
 hotel_id1157
 order4
 urihttp://images.pegs.com/imageRepo/1/0/34/71/930/CountryRoom_J.jpg
 ratio_hw0.63
 on_wall0
 3
 id16959
 hotel_id1157
 order5
 urihttp://images.pegs.com/imageRepo/1/0/34/71/921/CoachHouseRoom_J.jpg
 ratio_hw0.67
 on_wall0
 4
 id16960
 hotel_id1157
 order6
 urihttp://images.pegs.com/imageRepo/1/0/34/71/984/WoodBurningFireplace_J.jpg
 ratio_hw0.68
 on_wall0
 5
 id16961
 hotel_id1157
 order7
 urihttp://images.pegs.com/imageRepo/1/0/34/71/975/SunflowerRoom_J.jpg
 ratio_hw0.62
 on_wall0
 6
 id16962
 hotel_id1157
 order8
 urihttp://images.pegs.com/imageRepo/1/0/34/71/966/FireplaceRoom_J.jpg
 ratio_hw0.62
 on_wall0
 7
 id16963
 hotel_id1157
 order9
 urihttp://images.pegs.com/imageRepo/1/0/34/71/993/GourmetBreakfast_J.jpg
 ratio_hw1.23
 on_wall0
 8
 id16964
 hotel_id1157
 order10
 urihttp://images.pegs.com/imageRepo/1/0/34/72/2/HoneymoonRoom_J.jpg
 ratio_hw0.68
 on_wall0
 9
 id16965
 hotel_id1157
 order11
 urihttp://images.pegs.com/imageRepo/1/0/34/72/11/ClawfootSoakerTub_J.jpg
 ratio_hw1.50
 on_wall0
 Room
 0
 id4535
 typeOTH
 hotel_id1157
 nameCoach House
 descriptionCoach House- Luxurious rooms featuring four- poster King bed- fireplace- jetted tub- leather sofa
 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
 id4536
 typeOTH
 hotel_id1157
 nameCountry Double
 descriptionCountry Double- Spacious rooms- 2 Double Beds- claw foot soaker tub- Tv w/ Dvd iPod/ iPhone alarm
 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
 id4537
 typeOTH
 hotel_id1157
 nameCountry King
 descriptionCountry King- Spacious Rooms with King Bed- claw foot soaker tub- Tv w/ Dvd- iPod/ iPhone alarm
 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
 id4538
 typeOTH
 hotel_id1157
 nameCountry Queen
 descriptionCountry Queen- Unique Lobby Level location- Queen bed-sitting area with queen sofa bed- Tv Dvd
 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
 id4539
 typeOTH
 hotel_id1157
 nameFireplace Room
 descriptionFireplace Room- Queen bed-wood burning fireplace- either jetted tub or claw foot soaker tub
 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
 id4540
 typeOTH
 hotel_id1157
 nameFoxglove
 descriptionFoxglove- Spacious room with Queen canopy bed- fireplace- leather sofa- large bathroom- jetted tub
 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
 id4541
 typeOTH
 hotel_id1157
 nameHoneymoon Room
 descriptionHoneymoon Room- Large rooms with four poster King bedwood burning fireplace- double jetted tub
 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
 id4542
 typeOTH
 hotel_id1157
 nameSunflower 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
 id1949
 localeeng
 modelHotel
 foreign_key1157
 fieldtagline
 content
 1
 id1950
 localefre
 modelHotel
 foreign_key1157
 fieldtagline
 content
 Envie
 0
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 1
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 2
 id9
 created2011-05-17 19:26:00
 modified2011-05-17 19:26:00
 3
 id10
 created2011-05-17 19:26:16
 modified2011-05-17 19:26:16
 4
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 5
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 6
 id28
 created2011-09-15 08:20:11
 modified2011-09-15 08:20:11
 2
 Hotel
 id229
 starred0
 in0
 maintrack_hotel_id347060
 brand_codeWV
 nameSooke Harbour House
 address1528 Whiffen Spit Road
 zip_codeV9Z 0T4
 cityarea_id(null)
 city_id209
 region_id(null)
 state_id(null)
 country_idCA
 latitude48.356998
 longitude-123.727501
 zoom11
 rating3
 phone1 250-642-3421
 reservation_phone(null)
 fax1 250-642-6988
 emailreservations@sookeharbourhouse.com
 created2011-05-13 21:07:48
 modified2011-06-02 21:54:52
 descriptionThe Sooke Harbour House nestled beside Whiffen Spit is located a scenic 45 minute drive from Victoria. The twenty eight guest rooms feature stunning ocean views wood burning fireplaces a soaker or jetted tub and steam showers for two. Each room is an adventure in itself filled with local antiques collectables and original art. Step onto your private balcony the perfect location for watching sea lions otters seals and eagles play. Re-awaken your taste buds to the pleasures of fresh local seasonal ingredients with culinary creations by our acclaimed chef. The menu changes daily to reflect the seasonal variations in products received from local organic farmers gardeners, foragers and fishermen. Many First Nation traditional foods from uncommon fish to berries local mushrooms and bitter winter greens are also part of our kitchens palette. Wine and dinner parings are available from our award wining wine cellar celebrated for its vastness uniqueness and variety. For the past seven years Wine Spectator Magazine has awarded the cellar with the rare Grand Award for having One of Canadas Five Best Wine List and One of the Top 77 in the World. The Inns entirely edible organic gardens are designed both with the kitchens creative needs in mind and as a haven for guests to wander amongst. Come and loose yourself amongst our 400 edible flowers and herbs unusual vegetables and a wide variety of wild and cultivated salad greens.
 description_freLe Sooke Harbour House est niché à côté de Whiffen Spit et situé à 45 minutes par la route panoramique de Victoria. Les 28 chambres disposent de superbes vues sur l'océan, un foyers au bois, un bain à remous et des douches de vapeur. Chaque chambre est une aventure en elle-même; remplie d'objets de collection d'antiquités locales et d'œuvres d'art originales. Montez sur votre balcon privé, l'endroit est parfait pour regarder des lions et loutres de mer ou les phoques jouer, les aigles. Réveiller vos papilles aux plaisirs de la fraîcheur des ingrédients locaux de saison avec des créations culinaires de notre chef renommé. Le menu change quotidiennement pour tenir compte des variations saisonnières dans les produits reçus des collectivités locales d'agriculteurs, jardiniers organiques et les pêcheurs. Plusieurs aliments traditionnels proviennent des membres des Premières nations, poisson rare, des champignons, des baies locales et salade d'hiver amère font également partie de notre palette de cuisines. Les vins sont proposés à partir de notre cave à vin primé et célèbre pour son caractère unique et sa variété. Pour les sept dernières années, la revue Wine Spectator a décerné à notre cave le Grand Prix rare d'avoir une des 5 meilleures cartes de vins du Canadas et l'une des 77 meilleures au monde. Venez vous perdre parmi nos 400 fleurs comestibles et les herbes, les légumes inhabituels et une grande variété de salades sauvages et cultivées.
 amenityBabysitting/Child Services, 24 Hour Front Desk, Handicapped Rooms/Facilities, Express Checkout, Free Parking, Free Newspaper, Parking, Restaurant, Room Service, Safe Deposit Box, Fitness Center or Spa, Telephone, Shops/Commercial Services, Business Center, City Center.
 amenity_freGarde d'enfants, Réception 24 heures, chambres / équipements pour handicapés, Paiement express, parking gratuit, journal gratuit, parking, restaurant, service en chambre, Coffre-fort, Centre de fitness ou Spa, Téléphone, Boutiques / Commerces, Centre d'affaires, Centre Ville.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id209
 country_idCA
 state_idBC
 maintrack_idSOOKE
 nameSooke
 main_key
 Country
 idCA
 nameCanada
 name_freCanada
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id4046
 hotel_id229
 order2
 urihttp://images.pegs.com/imageRepo/1/0/11/572/101/085975A_J.jpg
 ratio_hw1.00
 on_wall0
 1
 id4047
 hotel_id229
 order3
 urihttp://images.pegs.com/imageRepo/1/0/11/572/105/085975B_J.jpg
 ratio_hw1.00
 on_wall0
 2
 id4048
 hotel_id229
 order4
 urihttp://images.pegs.com/imageRepo/1/0/11/572/109/085975C_J.jpg
 ratio_hw1.00
 on_wall0
 3
 id4049
 hotel_id229
 order5
 urihttp://images.pegs.com/imageRepo/1/0/11/572/113/085975D_J.jpg
 ratio_hw1.00
 on_wall0
 4
 id4050
 hotel_id229
 order6
 urihttp://images.pegs.com/imageRepo/1/0/11/572/117/085975E_J.jpg
 ratio_hw1.00
 on_wall0
 5
 id4051
 hotel_id229
 order7
 urihttp://images.pegs.com/imageRepo/1/0/11/572/121/085975F_J.jpg
 ratio_hw1.00
 on_wall0
 Room
 0
 id929
 typeOTH
 hotel_id229
 nameOCEAN QUEEN
 descriptionUnique Themed Rooms with Ocean Views Queen Beds Cozy Seating Areas Coffee Makers Wood Burning Fireplaces and a Private Deck or Balcony. Some offer jetted indoor outdoor tubs.
 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
 id930
 typeOTH
 hotel_id229
 nameOCEAN KING
 descriptionUnique Themed Rooms with Ocean Views Queen Beds Cozy Seating Areas Coffee Makers Wood Burning Fireplaces and a Private Deck or Balcony. Some offer jetted indoor outdoor tubs.
 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
 id931
 typeOTH
 hotel_id229
 nameSIGNATURE KING
 descriptionDelightfully Whimsical Rooms with Wonderful Ocean Views King Beds Comfortable Seating Areas Coffee Makers Wood Burning Fireplaces Deluxe Bathrooms and Private Balconies. Some rooms offer jetted indoor outdoor tubs.
 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
 id932
 typeOTH
 hotel_id229
 nameBEACH HOUSE KING
 descriptionDelightfully Whimsical Rooms with Wonderful Ocean Views King Beds Comfortable Seating Areas Coffee Makers Wood Burning Fireplaces Deluxe Bathrooms and Private Balconies. Some rooms offer jetted indoor outdoor tubs.
 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
 id933
 typeOTH
 hotel_id229
 nameOCEAN DELUXE KING
 descriptionBeautiful Rooms with Stunning Ocean Views King beds and Spacious Seating Areas Wood Burning Fireplaces Coffee Makers Misting Showers or Bathtubs for Two.
 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
 id934
 typeOTH
 hotel_id229
 nameOCEAN SUPREME KING
 descriptionBeautiful Rooms with Stunning Ocean Views King beds and Spacious Seating Areas Wood Burning Fireplaces Coffee Makers Misting Showers or Bathtubs for Two.
 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
 id935
 typeOTH
 hotel_id229
 nameBird s nest supreme king
 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
 id121
 localeeng
 modelHotel
 foreign_key229
 fieldtagline
 content
 1
 id122
 localefre
 modelHotel
 foreign_key229
 fieldtagline
 content
 Envie
 0
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 1
 id17
 created2011-05-17 19:28:06
 modified2011-05-17 19:28:06
 2
 id19
 created2011-05-24 08:21:45
 modified2011-05-24 08:21:45
 3
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 4
 id22
 created2011-05-24 08:23:46
 modified2011-05-24 08:23:46
- relatedEvents
 0
 Event
 id1291
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location115-189 Upper Ganges Rd, Salt Spring Island, BC V8K 2S2, Canada
 latitude48.8598
 longitude-123.501
 zoom13
 state_id(null)
 country_id
 created2011-10-27 15:02:55
 modified2011-10-27 15:02:55
 url(null)
 comment_count0
 former_business_id897
 localefre
 nameFAITES DE LA VOILE ET PECHER DANS LE PACIFIQUE AU CANADA
 descriptionLes eaux au large de Salt Spring Island sont célèbres dans le monde entier pour la navigation. Après avoir dégusté votre petit déjeuner, prenez votre pique-nique, et n'oubliez pas votre appareil photo, chapeau, veste, crème solaire et lunettes de soleil. Prennez le chemin à côté de la véranda jusqu'à Salt Spring Marina, où vous trouverez l'un des bateaux de pêche ou un des bateaux à voile, avec le capitaine et ses histoires de mer. Pendant les quatre heures que vous êtes à bord, vous aurez la chance d'attraper du saumon sauvage du Pacifique, le flétan, la morue-lingue et le crabe dormeur. Si vous n'êtes pas pêcheur, alors regarder un aigle arracher un poisson hors de l'eau; voir des phoques. Vous pouvez également voir des marsouins ou des baleines. L'air de la mer vous donnera assez d'appétit pour les friandises dans votre panier pique-nique amplement approvisionné. Apportez ensuite votre capture au chef du Hastings House qui se fera un plaisir de le transformer en un plat délectable pour votre dîner.
 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
 id7717
 localeeng
 modelEvent
 foreign_key1291
 fieldname
 contentFISH AND SAIL IN THE CANADIAN PACIFIC
 1
 id7718
 localefre
 modelEvent
 foreign_key1291
 fieldname
 contentFAITES DE LA VOILE ET PECHER DANS LE PACIFIQUE AU CANADA
 Descriptions
 0
 id7719
 localeeng
 modelEvent
 foreign_key1291
 fielddescription
 contentThe waters off Salt Spring Island are famous worldwide for navigation. After enjoying your breakfast, take a picnic and do not forget your camera, hat, jacket, sunscreen and sunglasses. Take the path next to the veranda to Salt Spring Marina, where you will find one of the fishing boats or sailing boats, with the captain and his stories of the sea during the four hours that you are on board you will have the chance to catch wild Pacific salmon, halibut, lingcod and Dungeness crab. If you are not fishing, then look at an eagle snatch a fish out of water, see the seals. You can also see porpoises or whales. The sea air will give you enough appetite for the treats in your picnic basket fully stocked. Bring your catch then the head of Hastings House, which will be happy to turn it into a delectable dish for your dinner.
 1
 id7720
 localefre
 modelEvent
 foreign_key1291
 fielddescription
 contentLes eaux au large de Salt Spring Island sont célèbres dans le monde entier pour la navigation. Après avoir dégusté votre petit déjeuner, prenez votre pique-nique, et n'oubliez pas votre appareil photo, chapeau, veste, crème solaire et lunettes de soleil. Prennez le chemin à côté de la véranda jusqu'à Salt Spring Marina, où vous trouverez l'un des bateaux de pêche ou un des bateaux à voile, avec le capitaine et ses histoires de mer. Pendant les quatre heures que vous êtes à bord, vous aurez la chance d'attraper du saumon sauvage du Pacifique, le flétan, la morue-lingue et le crabe dormeur. Si vous n'êtes pas pêcheur, alors regarder un aigle arracher un poisson hors de l'eau; voir des phoques. Vous pouvez également voir des marsouins ou des baleines. L'air de la mer vous donnera assez d'appétit pour les friandises dans votre panier pique-nique amplement approvisionné. Apportez ensuite votre capture au chef du Hastings House qui se fera un plaisir de le transformer en un plat délectable pour votre dîner.
 Links
 0
 id7721
 localeeng
 modelEvent
 foreign_key1291
 fieldlink
 content
 1
 id7722
 localefre
 modelEvent
 foreign_key1291
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 1
 Event
 id1292
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location351 Rainbow Rd, Salt Spring Island, BC V8K 2M4, Canada
 latitude48.8541
 longitude-123.517
 zoom13
 state_id(null)
 country_id
 created2011-10-27 15:18:27
 modified2011-10-27 15:18:27
 url(null)
 comment_count0
 former_business_id898
 localefre
 nameVISITEZ UN MOULIN A LAINE AU CANADA
 descriptionVenez rencontrez les lamas, les chèvres Angora et de nombreuses variétés de moutons qui sont élevés pour la qualité de leur laine servant à la confection de de tricot, filage, tissage et feutrage. La boutique propose des tapis de laine à tricoter en peau de mouton, des chaussons, chaussettes de laine, couvertures et couettes, matelas et oreillers que vous pouvez achetez. Réservez à l'avance.
 linkhttp://www.gulfislandsspinningmill.com/index.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
 id7723
 localeeng
 modelEvent
 foreign_key1292
 fieldname
 contentVISIT A WOOL MILL IN CANADA
 1
 id7724
 localefre
 modelEvent
 foreign_key1292
 fieldname
 contentVISITEZ UN MOULIN A LAINE AU CANADA
 Descriptions
 0
 id7725
 localeeng
 modelEvent
 foreign_key1292
 fielddescription
 contentMeet llamas, Angora goats and many varieties of sheep are raised for the quality of their wool used in the manufacture of knitting, spinning, weaving and felting. The shop offers knitting wool rugs sheepskin, slippers, socks, blankets and comforters, mattresses and pillows that you can buy. Book in advance.
 1
 id7726
 localefre
 modelEvent
 foreign_key1292
 fielddescription
 contentVenez rencontrez les lamas, les chèvres Angora et de nombreuses variétés de moutons qui sont élevés pour la qualité de leur laine servant à la confection de de tricot, filage, tissage et feutrage. La boutique propose des tapis de laine à tricoter en peau de mouton, des chaussons, chaussettes de laine, couvertures et couettes, matelas et oreillers que vous pouvez achetez. Réservez à l'avance.
 Links
 0
 id7727
 localeeng
 modelEvent
 foreign_key1292
 fieldlink
 contenthttp://www.gulfislandsspinningmill.com/index.html
 1
 id7728
 localefre
 modelEvent
 foreign_key1292
 fieldlink
 contenthttp://www.gulfislandsspinningmill.com/index.html
 Hotel(empty)
 Theme(empty)
 2
 Event
 id496
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationJericho Beach, Vancouver, BC V6R, Canada
 latitude49.2667
 longitude-123.2
 zoom9
 state_id(null)
 country_id
 created2011-06-14 18:34:26
 modified2011-06-14 18:34:26
 url(null)
 comment_count0
 former_business_id80
 localefre
 namePLAGE DE JERICHO
 descriptionUn endroit parfait pour admirer la ville tout en profitant de la plage ou des fonds marins pour une plongée.
 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
 id2947
 localeeng
 modelEvent
 foreign_key496
 fieldname
 contentJERICHO BEACH
 1
 id2948
 localefre
 modelEvent
 foreign_key496
 fieldname
 contentPLAGE DE JERICHO
 Descriptions
 0
 id2949
 localeeng
 modelEvent
 foreign_key496
 fielddescription
 contentA perfect place to enjoy the city while enjoying the beach or seabed for a dive.
 1
 id2950
 localefre
 modelEvent
 foreign_key496
 fielddescription
 contentUn endroit parfait pour admirer la ville tout en profitant de la plage ou des fonds marins pour une plongée.
 Links
 0
 id2951
 localeeng
 modelEvent
 foreign_key496
 fieldlink
 content
 1
 id2952
 localefre
 modelEvent
 foreign_key496
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 3
 Event
 id495
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationStanley Park, Georgia St, Vancouver, BC V7Y 0A1, Canada
 latitude49.3043
 longitude-123.144
 zoom11
 state_id(null)
 country_id
 created2011-06-14 18:31:49
 modified2011-06-14 18:31:49
 url(null)
 comment_count0
 former_business_id79
 localefre
 namePARC STANLEY
 descriptionVéritable poumon vert de Vancouver, le parc Stanley est au coeur de la ville et le lieu de prédilection pour se reposer ou faire du sport.
 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
 id2941
 localeeng
 modelEvent
 foreign_key495
 fieldname
 contentSTANLEY PARC
 1
 id2942
 localefre
 modelEvent
 foreign_key495
 fieldname
 contentPARC STANLEY
 Descriptions
 0
 id2943
 localeeng
 modelEvent
 foreign_key495
 fielddescription
 contentGreen lung of Vancouver's, Stanley Park is at the heart of the city and the favorite place to relax or play sports.
 1
 id2944
 localefre
 modelEvent
 foreign_key495
 fielddescription
 contentVéritable poumon vert de Vancouver, le parc Stanley est au coeur de la ville et le lieu de prédilection pour se reposer ou faire du sport.
 Links
 0
 id2945
 localeeng
 modelEvent
 foreign_key495
 fieldlink
 content
 1
 id2946
 localefre
 modelEvent
 foreign_key495
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 4
 Event
 id1059
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationVancouver Harbour Water Airport (CXH), Vancouver, BC V6C, Canada
 latitude49.2897
 longitude-123.119
 zoom12
 state_id(null)
 country_id
 created2011-09-15 18:49:24
 modified2011-09-15 18:49:24
 url(null)
 comment_count0
 former_business_id666
 localefre
 nameSURVOL EN HYDRAVION
 descriptionPrenez de la hauteur pour une aventure en hydravion à couper le souffle ! Profitez d'un vol panoramique de 20 minutes au-dessus de Vancouver avec des vues spectaculaires de la ville et des montagnes environnantes. Westcoast Air offre des vols quotidiens réguliers vers Victoria, Nanaimo, ...
 linkhttp://www.westcoastair.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
 id6325
 localeeng
 modelEvent
 foreign_key1059
 fieldname
 contentFLY BY SEAPLANE
 1
 id6326
 localefre
 modelEvent
 foreign_key1059
 fieldname
 contentSURVOL EN HYDRAVION
 Descriptions
 0
 id6327
 localeeng
 modelEvent
 foreign_key1059
 fielddescription
 contentTake to the skies for a flying adventure in breathtaking! Enjoy a panoramic flight of 20 minutes over Vancouver with spectacular views of the city and surrounding mountains. Westcoast Air offers daily flights to Victoria, Nanaimo, ...
 1
 id6328
 localefre
 modelEvent
 foreign_key1059
 fielddescription
 contentPrenez de la hauteur pour une aventure en hydravion à couper le souffle ! Profitez d'un vol panoramique de 20 minutes au-dessus de Vancouver avec des vues spectaculaires de la ville et des montagnes environnantes. Westcoast Air offre des vols quotidiens réguliers vers Victoria, Nanaimo, ...
 Links
 0
 id6329
 localeeng
 modelEvent
 foreign_key1059
 fieldlink
 contenthttp://www.westcoastair.com
 1
 id6330
 localefre
 modelEvent
 foreign_key1059
 fieldlink
 contenthttp://www.westcoastair.com
 Hotel(empty)
 Theme(empty)
 5
 Event
 id497
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location332 Water St, Vancouver, BC V6B 1B6, Canada
 latitude49.2843
 longitude-123.11
 zoom10
 state_id(null)
 country_id
 created2011-06-14 18:37:58
 modified2011-06-14 18:37:58
 url(null)
 comment_count0
 former_business_id81
 localefre
 nameSOCIAL AT LE MAGASIN
 descriptionRestaurant prisé pour ses spécialités de la côte Ouest comme le jaret d'agneau.
 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
 id2953
 localeeng
 modelEvent
 foreign_key497
 fieldname
 contentSOCIAL AT LE MAGASIN
 1
 id2954
 localefre
 modelEvent
 foreign_key497
 fieldname
 contentSOCIAL AT LE MAGASIN
 Descriptions
 0
 id2955
 localeeng
 modelEvent
 foreign_key497
 fielddescription
 contentPopular restaurant for its West Coast specialties like lamb Jaret.
 1
 id2956
 localefre
 modelEvent
 foreign_key497
 fielddescription
 contentRestaurant prisé pour ses spécialités de la côte Ouest comme le jaret d'agneau.
 Links
 0
 id2957
 localeeng
 modelEvent
 foreign_key497
 fieldlink
 content
 1
 id2958
 localefre
 modelEvent
 foreign_key497
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
- weather(false)
- meta_description_for_layoutHastings House Country Hotel will be closing for the winter season on 9th November 2008 and looking forward to welcoming guests again on 13th March 2009. English country manor house meets Canadian inspiration at the secluded Hastings House, which overlooks the peaceful Ganges Harbour. 22 acres of flower gardens and rolling meadows surround this elegant Tudor-style country house where sophisticated island living includes one of the best restaurants in British Columbia, as well as an intimate spa.Return to an era of grace and simplicity as you enjoy afternoon tea in front of the Inglenook fireplace in the Living Room of the Manor House or on warmer days on the patio overlooking beautiful Ganges Harbour. Delicate earthy hues warm the spa for a relaxing massage in between the genteel activities of the Manor House.Each morning a wake-up hamper with fresh-baked muffins and tea or coffee will be placed outside your door. For those requiring a more substantial start to their day a full breakfast awaits you in the Manor House. Our award-winning dining room with exquisite regional cuisine and outstanding wine list will offer the perfect ending to your island-style day.Hastings House 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

Hastings House Country Estate

Salt Spring Island, Canada

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

Hastings House Country Estate

Salt Spring Island, Canada

0 commentaires

Réserver cet hôtel

Les expériences proches de l'hôtel

FAITES DE LA VOILE ET PECHER DANS LE PACIFIQUE AU CANADA

VISITEZ UN MOULIN A LAINE AU CANADA

PLAGE DE JERICHO

PARC STANLEY

SURVOL EN HYDRAVION

SOCIAL AT LE MAGASIN

Autres hôtels selon vos critères

Victoria, Canada Brentwood Bay Resort

Victoria, Canada Abigails Hotel

Sooke, Canada Sooke Harbour House

En savoir plus

Brèves

Les promesses Globe Secret

Des hôtels de charme a taille humaine

RESERVATION SANS FRAIS

DES CRITERES DE CHOIX UNIQUES

PLUS DE SERVICES A LA CARTE

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

warning

error

View Variables

Victoria, Canada
Brentwood Bay Resort

Victoria, Canada
Abigails Hotel

Sooke, Canada
Sooke Harbour House