Hôtels de charme à travers le monde

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

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `hotels`	34	34	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	0
SHOW FULL COLUMNS FROM `cities`	6	6	0
SHOW FULL COLUMNS FROM `states`	3	3	0
SHOW FULL COLUMNS FROM `countries`	3	3	0
SHOW FULL COLUMNS FROM `weather_forecasts`	15	15	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	0
SHOW FULL COLUMNS FROM `news`	4	4	0
SHOW FULL COLUMNS FROM `i18n`	6	6	0
SHOW FULL COLUMNS FROM `home_hotels`	4	4	0
SHOW FULL COLUMNS FROM `hotel_images`	6	6	0
SHOW FULL COLUMNS FROM `rooms`	15	15	0
SHOW FULL COLUMNS FROM `rooms_rates`	8	8	0
SHOW FULL COLUMNS FROM `rates_periods`	6	6	0
SHOW FULL COLUMNS FROM `rates_period_i18n`	6	6	0
SHOW FULL COLUMNS FROM `unavailabilities`	4	4	0
SHOW FULL COLUMNS FROM `envies`	3	3	0
SHOW FULL COLUMNS FROM `envie_i18n`	6	6	0
SHOW FULL COLUMNS FROM `envies_hotels`	2	2	0
SHOW FULL COLUMNS FROM `comments`	19	19	0
SHOW FULL COLUMNS FROM `users`	16	16	0
SHOW FULL COLUMNS FROM `addresses`	12	12	0
SHOW FULL COLUMNS FROM `janrain_profiles`	9	9	0
SHOW FULL COLUMNS FROM `admins`	15	15	0
SHOW FULL COLUMNS FROM `favorites`	8	8	0
SHOW FULL COLUMNS FROM `hotel_i18n`	6	6	0
SHOW FULL COLUMNS FROM `configs`	3	3	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';	1	1	0
SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'fre') WHERE 1 = 1	1	1	0
SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1)	2	2	0
SELECT COUNT(DISTINCT(`Hotel`.`id`)) AS count FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `HotelI18n` ON (`Hotel`.`id` = `HotelI18n`.`foreign_key` AND `HotelI18n`.`model` = 'Hotel' AND `HotelI18n`.`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`.`city_id` = 370 AND `Hotel`.`published` = 1	1	1	8	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`.`city_id` = 370 AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20	5	5	8	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 (422, 421, 1227, 1225, 828)	43	43	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 (422, 421, 1227, 1225, 828)	21	21	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 (422, 421, 1227, 1225, 828)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (422, 421, 1227, 1225, 828)	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 (422, 421, 1227, 1225, 828)	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 (422, 421, 1227, 1225, 828)	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 (422, 421, 1227, 1225, 828)	10	10	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 (422, 421, 1227, 1225, 828) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	19	19	1	maybe slow
SELECT `City`.`id`, `City`.`country_id`, `City`.`state_id`, `City`.`maintrack_id`, `City`.`name`, `City`.`main_key`, `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `cities` AS `City` LEFT JOIN `countries` AS `Country` ON (`City`.`country_id` = `Country`.`id`) WHERE `City`.`id` = 370 ORDER BY `City`.`name` ASC LIMIT 1	1	1	0
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC	256	256	0
SHOW FULL COLUMNS FROM `themes`	4	4	0
SHOW FULL COLUMNS FROM `theme_i18n`	6	6	0
SELECT `Theme`.*, `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18n__name` ON (`Theme`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Theme' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	10	10	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `theme_i18n` AS `Names` WHERE `model` = 'Theme' AND `field` = 'name' AND `Names`.`foreign_key` IN (6, 10, 7, 12, 11, 13, 5, 8, 4, 9)	20	20	0
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1	10	10	0
SELECT `Envie`.*, `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18n__name` ON (`Envie`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Envie' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	29	29	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `envie_i18n` AS `Names` WHERE `model` = 'Envie' AND `field` = 'name' AND `Names`.`foreign_key` IN (22, 21, 25, 26, 4, 12, 14, 19, 9, 30, 3, 1, 13, 6, 24, 7, 18, 5, 10, 27, 2, 11, 29, 16, 15, 23, 17, 8, 28)	58	58	0
SELECT `Hotel`.`id`, `Country`.*, `Country`.`id` FROM `hotels` AS `Hotel` LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) WHERE 1 = 1 GROUP BY `Hotel`.`country_id` ORDER BY `Country`.`name_fre` ASC	120	120	0
SHOW FULL COLUMNS FROM `promises`	3	3	0
SELECT `Promise`.*, `I18n__title`.`content`, `I18n__content`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18n__title` ON (`Promise`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Promise' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fre') INNER JOIN `i18n` AS `I18n__content` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Promise' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'fre') WHERE 1 = 1 LIMIT 4	4	4	0
SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Promise' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT `Contents`.`id`, `Contents`.`locale`, `Contents`.`model`, `Contents`.`foreign_key`, `Contents`.`field`, `Contents`.`content` FROM `i18n` AS `Contents` WHERE `model` = 'Promise' AND `field` = 'content' AND `Contents`.`foreign_key` IN (1, 2, 3, 4)	8	8	0

Message	Memory use
Component initialization	14,00 MB
Controller action start	14,00 MB
Controller render start	15,00 MB
View render complete	19,00 MB

Message	Time in ms	Graph
Core Processing (Derived)	76,90
Component initialization and startup	4,93
Controller action	49,80
Render Controller Action	81,68
» Rendering View	80,34
» » Rendering APP/views/hotels/index.ctp	28,21
» » » Rendering APP/views/elements/hotels/item.ctp	1,26
» » » Rendering APP/views/elements/hotels/item.ctp #2	1,16
» » » Rendering APP/views/elements/hotels/item.ctp #3	1,19
» » » Rendering APP/views/elements/hotels/item.ctp #4	1,11
» » » Rendering APP/views/elements/hotels/item.ctp #5	1,10
» » » Rendering APP/views/elements/paging.ctp	0,12
» » Rendering APP/views/layouts/default.ctp	51,93
» » » Rendering APP/views/elements/google_analytics.ctp	0,09
» » » Rendering APP/views/elements/layout/top.ctp	1,57
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0,31
» » » Rendering APP/views/elements/layout/header.ctp	44,98
» » » Rendering APP/views/elements/layout/extra.ctp	0,13
» » » Rendering APP/views/elements/layout/footer.ctp	4,08
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0,31
» » » Rendering APP/views/elements/layout/footnotes.ctp	0,08

+ –

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)
city
- City
  - id370
  - country_idSE
  - state_id(null)
  - maintrack_idSTOCKHOLM
  - nameStockholm
  - main_key
country
- Country
  - idSE
  - nameSweden
  - name_freSuède
hotels
- 0
  - Hotel
    - id422
    - starred0
    - in0
    - maintrack_hotel_id316079
    - brand_codeSW
    - nameHotel Birger Jarl
    - addressTulegatan 8
    - zip_code10432
    - cityarea_id(null)
    - city_id370
    - region_id(null)
    - state_id(null)
    - country_idSE
    - latitude59.342499
    - longitude18.062
    - zoom13
    - rating4
    - phone46 8 6741800
    - reservation_phone(null)
    - fax46 (8) 6737366
    - emailinfo@birgerjarl.se
    - created2011-05-13 21:09:17
    - modified2011-06-09 10:10:42
    - descriptionHotel Birger Jarl's profile focuses on contemporary Swedish design. The hotel rooms and suites have been furnished by several prominent Swedish interior designers. The hotel lobby also doubles as an exhibition center for artists focusing on form and design. Centrally situated, a few minutes walk from the financial and shopping district, in the triangle between Stureplan, Hotorget and Odenplan.
    - description_freL'hôtel Birger Jarl se concentre sur le design suédois contemporain. Les chambres de l'hôtel et les suites ont été aménagées par plusieurs éminents designers d'intérieur suédois. Le hall de l'hôtel sert également de centre d'exposition pour les artistes en se concentrant sur la forme et le design. Idéalement situé, à quelques minutes à pied du quartier financier et commercial, dans le triangle entre Stureplan, Hötorget et Odenplan.
    - amenityConcierge, 24 Hour Front Desk, Free Newspaper, Parking, Restaurant, Room Service, Safe Deposit Box, Fitness Center or Spa, Laundry/Valet Services, Internet Access ? Complimentary, Handicapped Rooms/Facilities, Pets Allowed, Complimentary Continental Breakfast, Exercise Gym, Health Club, No Smoking Rooms/Facilities, High speed internet access, Wireless Internet Access, Internet Access, Safe, Business Center, Meeting/Banquet Facilities, City Center.
    - amenity_freConcierge, Réception 24 heures, journal gratuit, parking, restaurant, service en chambre, Coffre-fort, Centre de fitness ou Spa, service de blanchisserie, accès Internet gratuit, chambres / équipements pour handicapés, animaux domestiques admis, petit déjeuner continental gratuit, gymnastique, club de santé, non fumeurs chambres / équipements, l'accès Internet à haute vitesse, accès Internet sans fil, accès internet, coffre-fort, centre d'affaires, salles de réunions / banquets, centre-ville .
    - lowest_rate1090.00
    - lr_currencySEK
    - 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
    - id370
    - country_idSE
    - state_id(null)
    - maintrack_idSTOCKHOLM
    - nameStockholm
    - main_key
  - Country
    - idSE
    - nameSweden
    - name_freSuède
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id7459
      - hotel_id422
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/358/H0AMCL1B_J.jpg
      - ratio_hw1.21
      - on_wall0
    - 1
      - id7460
      - hotel_id422
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/363/H0AMCL1I_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 2
      - id7461
      - hotel_id422
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/367/H0AMCL11_J.jpg
      - ratio_hw0.79
      - on_wall0
    - 3
      - id7462
      - hotel_id422
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/372/H0AMCL14_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 4
      - id7463
      - hotel_id422
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/386/H0AMCL15_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 5
      - id7464
      - hotel_id422
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/391/H0AMCL16_J.jpg
      - ratio_hw0.76
      - on_wall0
    - 6
      - id7465
      - hotel_id422
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/396/H0AMCL17_J.jpg
      - ratio_hw0.64
      - on_wall0
    - 7
      - id7466
      - hotel_id422
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/401/H0AMCL19_J.jpg
      - ratio_hw0.88
      - on_wall0
    - 8
      - id7467
      - hotel_id422
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/27/774/410/H0AMCL1F_J.jpg
      - ratio_hw0.67
      - on_wall0
  - Room
    - 0
      - id1733
      - typeOTH
      - hotel_id422
      - 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
      - id509
      - localeeng
      - modelHotel
      - foreign_key422
      - fieldtagline
      - content
    - 1
      - id510
      - localefre
      - modelHotel
      - foreign_key422
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
    - 2
      - id22
      - created2011-05-24 08:23:46
      - modified2011-05-24 08:23:46
- 1
  - Hotel
    - id421
    - starred0
    - in0
    - maintrack_hotel_id272689
    - brand_codeDS
    - nameHotel J
    - addressEllensviksvaegen 1 Nacka Strand
    - zip_code13127
    - cityarea_id(null)
    - city_id370
    - region_id(null)
    - state_id(null)
    - country_idSE
    - latitude59.3186
    - longitude18.1642
    - zoom13
    - rating4
    - phone46 8 6013000
    - reservation_phone46 res@designhotels.com
    - fax46 86013009
    - emailinfo@hotelj.com
    - created2011-05-13 21:09:17
    - modified2011-06-09 10:06:04
    - descriptionSituated uniquely by the waterside at one of the world's most stunning harbor entrances, is the elegant Hotel J. The inspiration by classic Newport summer mansions in the U.S. is apparent, a combination of timeless luxury and genuine comfort where the colors red, white and blue are dominant and paired with oiled woodwork and dark, varnished floors. Most of the beautiful hotel rooms have a balcony or their own patio with a view of one of the harbor entrances. In the summer you can enjoy your morning coffee in our tranquil garden where the waves lap against the shore. When the winter season starts we head for the indoors and light up the fireplace in the lounge, where you can enjoy the coziness of comfy sofas and the crackle from the fire.
    - description_freSitué de manière unique au bord de l'eau à l'une des entrées du plus étonnant port au monde, se trouve l'élégant Hôtel J. L'inspiration classique des demeures d'été de Newport aux Etats-Unis est manifeste, d'une combinaison de luxe intemporel et un confort authentique où les couleurs rouge, blanche et bleue sont dominants et jumelés avec des boiseries sombres et huilée, des planchers vernis. La plupart des chambres de ce bel hôtel disposent d'un balcon ou une terrasse privée avec vue sur l'une des entrées du port. En été, vous pourrez profiter de votre café du matin dans notre jardin tranquille où les vagues frappent contre le rivage. Lorsque la saison d'hiver commence, nous pensons à l'intérieur en nous occupant de la cheminée dans le salon, où vous pourrez profiter du confort de canapés cosy et le crépitement du feu.
    - amenityRestaurant, Room Service, Wake-up Service, Security, 24 Hour Security, Maid Service, Handicapped Rooms/Facilities, Wheel Chair Access, Family Plan, Pets Allowed, Play Ground, null, Lounge, Internet Access Complimentary, Wireless Internet Access, Phone Service, Concierge Desk, Meeting/Banquet Facilities, Business Center, Conference Facilities, Elevators, Copy Service, Barber Shop, Health Club, Jogging Track, Massage, Sauna, Fitness Center or Spa, 24 Hour Front Desk, Currency Exchange, Safe Deposit Box, 220 AC, Air Conditioned, Free Newspaper, Hairdryers Available, Heated Guest Rooms, No Smoking Rooms/Facilities, Private Bathroom, Toilet, Parking, Kitchenette, Laundry/Valet Services, Telephone, Meal Plan - Bed and Breakfast, On the Lake.
    - amenity_freRestaurant, Room Service, Service de réveil, de la sécurité, 24 heures de sécurité, Service d'entretien, chambres / équipements pour handicapés, Accès pour chaises roulantes, de la Famille Plan, animaux domestiques admis, Play Ground, null, salon, accès internet gratuit, l'accès Internet sans fil, service de téléphone, bureau du concierge, salles de réunions / banquets, centre d'affaires, Salles de conférence, ascenseurs, service de copie, Barber Shop, Club de santé, piste de jogging, massage, sauna, centre de remise en forme ou spa, Réception 24 heures , service de change, Coffre-fort, 220 AC, Air conditionné, journal gratuit, sèche-cheveux disponibles, chambres d'hôtes chauffée, chambres non fumeur / équipements, Salle de bain privée, toilettes, parking, cuisine, service de blanchisserie, téléphone, plan-repas - Bed Petit-déjeuner et, sur le lac.
    - lowest_rate1150.50
    - lr_currencySEK
    - 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
    - id370
    - country_idSE
    - state_id(null)
    - maintrack_idSTOCKHOLM
    - nameStockholm
    - main_key
  - Country
    - idSE
    - nameSweden
    - name_freSuède
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id7452
      - hotel_id421
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/33/577/687/1125202cdmsCRSphoto_img_pho_000_nc__1906139%7EHotel-Facade__J.jpg
      - ratio_hw0.66
      - on_wall0
    - 1
      - id7453
      - hotel_id421
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/33/577/750/1125202cdmsCRSphoto_img_pho_000_nc__1906145%7EJ-Newport-Lar_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 2
      - id7454
      - hotel_id421
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/33/577/759/1125202cdmsCRSphoto_img_pho_000_nc__1906147%7EJ-Suite__1_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 3
      - id7455
      - hotel_id421
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/33/577/786/1125202cdmsCRSphoto_img_pho_000_nc__1906151%7EConference__1_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 4
      - id7456
      - hotel_id421
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/33/577/795/1125202cdmsCRSphoto_img_pho_000_nc__1906153%7ELounge__1_J.jpg
      - ratio_hw0.78
      - on_wall0
    - 5
      - id7457
      - hotel_id421
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/33/577/777/1125202cdmsCRSphoto_img_pho_000_nc__1906149%7ERestaurant__1_J.jpg
      - ratio_hw0.40
      - on_wall0
    - 6
      - id7458
      - hotel_id421
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/33/577/813/1125202cdmsCRSphoto_img_pho_000_nc__1906155%7EEntrance__1_J.jpg
      - ratio_hw1.24
      - on_wall0
  - Room
    - 0
      - id1732
      - typeOTH
      - hotel_id421
      - nameJ Deluxe
      - 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
      - id507
      - localeeng
      - modelHotel
      - foreign_key421
      - fieldtagline
      - content
    - 1
      - id508
      - localefre
      - modelHotel
      - foreign_key421
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id13
      - created2011-05-17 19:27:04
      - modified2011-05-17 19:27:04
    - 2
      - id15
      - created2011-05-17 19:27:34
      - modified2011-05-17 19:27:34
    - 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
- 2
  - Hotel
    - id1227
    - starred0
    - in0
    - maintrack_hotel_id330769
    - brand_codeWV
    - nameHotel Stureplan
    - addressBirger Jarlsgatan 24
    - zip_code114 34
    - cityarea_id(null)
    - city_id370
    - region_id(null)
    - state_id(null)
    - country_idSE
    - latitude59.3368164148109
    - longitude18.0715502037049
    - zoom13
    - rating4
    - phone46 8 4406600
    - reservation_phone(null)
    - fax46 8-4406611
    - emailreservation@hotelstureplan.se
    - created2011-10-10 12:02:15
    - modified2011-10-11 11:31:30
    - descriptionIn the earth of Stockholm. Elegant 19th century building whose interior design is inspired by traditional swedish craftmanship. Everything the city has to offer is right on your doorstep. If you feel that the city's pulse is too high why not relax for a while in our champagne bar or let one of our concierge suggest something to do? Welcome to a hotel where excellent service is the minimum standard. Staying at our hotel is an experience beyond the ordinary, the rooms and interiors are unique. With only 102 rooms Hotel Stureplan offers an exceptional level of personal service. Room categories range from Cabin Rooms to Suites and executive floor, Stureplan Living. Welcome to Hotel Stureplan!
    - description_freDans le centre de Stockholm, se trouve un élégant bâtiment du 19ème siècle dont la décoration intérieure est inspirée par l'artisanat suédois traditionnel. Tout ce que la ville peut offrir est à votre porte. Si vous sentez que le pouls de la ville est trop élevé pourquoi ne pas vous détendre pendant un moment dans notre bar à champagne ou de laisser l'un de nos concierges vous suggérer quelque chose à faire ? Bienvenue dans un hôtel où un excellent service est la norme minimale. Séjourner dans notre hôtel est une expérience hors du commun; les chambres et les intérieurs sont uniques. Avec seulement 102 chambres de l'Hôtel Stureplan offre un niveau exceptionnel de service personnel.
    - amenityLounge, Concierge, 24 Hour Front Desk, Handicapped Rooms/Facilities, Restaurant, Room Service, Safe Deposit Box, Laundry/Valet Services, Casino, Health Club, Jogging Track, Massage, Sauna, Fitness Center or Spa, Currency Exchange, Air Conditioned, Private Bathroom, Coffee Shop, Terrace, Coffee Maker in Room, Hairdryers Available, Iron, Ironing Board, King Bed, High speed internet access, Safe, Twin Bed, Wireless Internet Access, Mini Bar, AM/FM Alarm Clock, Modem in Room, Queen Bed, Telephone, City Center.
    - amenity_freSalon, concierge, réception ouverte 24 heures, chambres / équipements pour handicapés, Restaurant, Room Service, coffre-fort, blanchisserie / Services, Casino, Club de santé, piste de jogging, massage, sauna, centre de fitness ou Spa, service de change, Climatisation , Salle de bain privée, Café, Terrasse, Cafetière dans la chambre, sèche-cheveux disponibles, fer et planche à repasser, lit King, accès internet haut débit, coffre-fort, lits jumeaux, accès Internet sans fil, mini bar, radio-réveil AM / FM, modem dans chambre, lit queen, Téléphone, Centre Ville.
    - lowest_rate1215.00
    - lr_currencySEK
    - 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
    - id370
    - country_idSE
    - state_id(null)
    - maintrack_idSTOCKHOLM
    - nameStockholm
    - main_key
  - Country
    - idSE
    - nameSweden
    - name_freSuède
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id17864
      - hotel_id1227
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/14/851/824/1145543cdms_img_pho_000_nc__229972%7EClassic_Medium___J.jpg
      - ratio_hw1.00
      - on_wall0
    - 1
      - id17865
      - hotel_id1227
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/15/28/904/wv14862_b6_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 2
      - id17866
      - hotel_id1227
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/15/28/912/wv14862_b8_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 3
      - id17867
      - hotel_id1227
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/15/28/896/wv14862_b4_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 4
      - id17868
      - hotel_id1227
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/15/28/900/wv14862_b5_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 5
      - id17869
      - hotel_id1227
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/15/28/888/wv14862_b2_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 6
      - id17870
      - hotel_id1227
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/14/851/884/1145543cdms_img_pho_000_nc__229990%7EEntrance_Hotel_Sturepla_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 7
      - id17871
      - hotel_id1227
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/14/851/894/1145543cdms_img_pho_000_nc__229993%7ELoft_Medium___J.jpg
      - ratio_hw1.00
      - on_wall0
    - 8
      - id17872
      - hotel_id1227
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/14/851/904/1145543cdms_img_pho_000_nc__229996%7EHallway___J.jpg
      - ratio_hw1.00
      - on_wall0
    - 9
      - id17873
      - hotel_id1227
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/31/997/516/stureplan_J.jpg
      - ratio_hw0.66
      - on_wall0
  - Room
    - 0
      - id4823
      - typeOTH
      - hotel_id1227
      - nameJUNIOR SUITE
      - descriptionThe interior design in all of our suites is classic Gustavian 18th century style with a contemporary touch. No suite is like the other one; they are all unique with colours, decorations and sizes. Our suites offer a wide variety of individual details
      - 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
      - id4824
      - typeOTH
      - hotel_id1227
      - nameSUPERIOR DE LUXE
      - descriptionThe Superior De Luxe rooms are 30 sqm with 4 meter high ceilings, stucco features and chandeliers. They are decorated in 18th century Gustavian style with modern features. All the rooms have their own style and charm, face into our peaceful inner
      - 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
      - id4825
      - typeOTH
      - hotel_id1227
      - nameSUPERIOR KING
      - descriptionThe Superior King rooms are 25-30 sqm. They have a king size bed, an armchair or two and a working area. Classic rooms are available. All rooms with their own individual style, proportion and charm. The rooms overlook either Birger Jarlsgatan
      - 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
      - id4826
      - typeOTH
      - hotel_id1227
      - nameSUPERIOR
      - descriptionThe Superior rooms are 17?22 sqm with a queen size or king size bed as well as an armchair in the classic rooms and a comfortable working area. Modern loft rooms or classic rooms are available. All rooms with their own individual style, proportion
      - 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
      - id4827
      - typeOTH
      - hotel_id1227
      - nameSTANDARD QUEEN
      - descriptionThe Standard Queen rooms are 15-20 sqm, with a queen size bed and working area. Modern loft rooms or classic rooms are available. All rooms with their own individual style, proportion and charm. The rooms overlook either Birger Jarlsgatan
      - 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
      - id4828
      - typeOTH
      - hotel_id1227
      - nameCabin Small
      - descriptionFully equipped rooms without window. Yacht inspired interior and lots of atmosphere. Cabin rooms are 11-15 sqm. Standard in all rooms- HD TV channels.. in room entertainm
      - 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
      - id4829
      - typeOTH
      - hotel_id1227
      - nameCabin Double
      - descriptionFully equipped rooms without window. Yacht inspired interior and lots of atmosphere. Perfect for late arrival and early departure. Standard in all rooms- HD TV channels.. in room enterta
      - 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
      - id4830
      - typeOTH
      - hotel_id1227
      - nameSmall classic
      - descriptionAll classic rooms have Gustavian 18 th century style enhanced with modern features. Our classic rooms have a ceiling height of 4 m. stucco and chandeliers. Small rooms are 15-20 sqm. All rooms with their own individual style.. Stand
      - 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
      - id4831
      - typeOTH
      - hotel_id1227
      - nameSmall loft
      - descriptionOur loft room interior design is contemporary and minimalistic with polished concrete floors. Standard in all rooms- HD TV channels..
      - 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
      - id4832
      - typeOTH
      - hotel_id1227
      - nameMedium classic
      - descriptionAll classic rooms have Gustavian 18 th century style enhanced with modern features. Our classic rooms have a ceiling height of 4 m. stucco and chandeliers. Small rooms are 20-25 sqm. All rooms with their own individual style.. Stand
      - 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
      - id4833
      - typeOTH
      - hotel_id1227
      - nameMedium loft
      - descriptionOur loft room interior design is contemporary and minimalistic with polished concrete floors. Standard in all rooms- HD TV channels..
      - 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
      - id4834
      - typeOTH
      - hotel_id1227
      - nameLarge classic
      - descriptionAll classic rooms have Gustavian 18 th century style enhanced with modern features. Our classic rooms have a ceiling height of 4 m. stucco and chandeliers. Small rooms are 25-30 sqm. All rooms with their own individual style.. Stand
      - 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
      - id4835
      - typeOTH
      - hotel_id1227
      - nameLarge loft
      - descriptionOur loft room interior design is contemporary and minimalistic with polished concrete floors. Standard in all rooms- HD TV channels..
      - 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
      - id4836
      - typeOTH
      - hotel_id1227
      - nameX-Large classic
      - descriptionAll classic rooms have Gustavian 18 th century style enhanced with modern features. Our classic rooms have a ceiling height of 4 m. stucco and chandeliers. X-Large rooms are 35-40 sqm. All rooms with their own individual style.. proportio
      - 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
      - id4837
      - typeOTH
      - hotel_id1227
      - nameSuite
      - description(null)
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
  - RatesPeriod(empty)
  - Unavailability(empty)
  - Comment(empty)
  - Favorite(empty)
  - Taglines
    - 0
      - id2085
      - localeeng
      - modelHotel
      - foreign_key1227
      - fieldtagline
      - content
    - 1
      - id2086
      - localefre
      - modelHotel
      - foreign_key1227
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id15
      - created2011-05-17 19:27:34
      - modified2011-05-17 19:27:34
    - 2
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
    - 3
      - id22
      - created2011-05-24 08:23:46
      - modified2011-05-24 08:23:46
- 3
  - Hotel
    - id1225
    - starred0
    - in0
    - maintrack_hotel_id381085
    - brand_codeWK
    - nameVilla Kallhagen
    - addressDjurgardsbrunnsvagen 10
    - zip_code11527
    - cityarea_id(null)
    - city_id370
    - region_id(null)
    - state_id(null)
    - country_idSE
    - latitude59.3334287
    - longitude18.1112307999999
    - zoom13
    - rating4
    - phone(46 8) 6650300
    - reservation_phoneUtell Worldwide at 1-800-207-6900 (US and Canada)
    - fax(46 8) 6650399
    - email(null)
    - created2011-10-10 11:54:26
    - modified2011-10-11 09:39:56
    - descriptionVilla Kallhagen is a small, intimate hotel with its unique location in Stockholm's Royal Djurgarden Park, only five minutes away from the city centre with its numerous attractions. The gourmet restaurant specialises in traditional Swedish-style cuisine and also offers an extensive selection of fine wines. Swedish summers are renowned for long hours of daylight and to capture this atmosphere Villa Kallhagen has plenty of glass in its architectural design. All bedrooms have large windows, most of them with breathtaking views of the Djurgarden channel which leads out to the archipelago of Stockholm. Visitors have been staying here since the first Inn opened in 1810 and the park remains a popular venue, throughout the year. Its pretty garden is a perfect place to watch the world go by during the warmer months, whilst in winter times its cosy interior with a welcoming open fire provides plenty of opportunity to enjoy the Hotel facilities.
    - description_freLa Villa Kallhagen est un petit hôtel intime, avec son emplacement unique dans le parc de Djurgården Stockholm Royal, à seulement cinq minutes du centre-ville et de ses nombreuses attractions. Le restaurant gastronomique est spécialisé dans la cuisine traditionnelle suédoise de style et offre également une vaste sélection de vins. Les été suédois sont renommés pour de longues heures d'ensoleillement pour mieux capter l'ambiance Villa Kallhagen. Toutes les chambres disposent de grandes fenêtres, la plupart d'entre elles avec une vue imprenable sur le canal de Djurgården, qui mène à l'archipel de Stockholm. Les visiteurs peuvent séjourner ici depuis que le Inn a ouvert ses portes en 1810 et le parc reste un lieu très prisé, tout au long de l'année. Son joli jardin est un endroit parfait pour regarder le monde passer pendant les mois chauds, tandis que l'hiver son intérieur cosy avec une cheminée accueillante ouverte offre de nombreuses possibilités pour profiter des installations de l'hôtel.
    - amenityAll of the guest rooms are comfortable and nicely equipped to give a feeling of being home while away from home. The hotel also has a variety of facilities and services that are sure to meet the needs of both business and leisure travelers.
    - amenity_freToutes les chambres sont confortables et bien équipées pour donner un sentiment d'être chez soi loin. L'hôtel dispose également d'une variété d'équipements et de services qui sont sûrs de satisfaire les besoins des voyageurs d'affaires et de loisirs.
    - lowest_rate1390.00
    - lr_currencySEK
    - 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
    - id370
    - country_idSE
    - state_id(null)
    - maintrack_idSTOCKHOLM
    - nameStockholm
    - main_key
  - Country
    - idSE
    - nameSweden
    - name_freSuède
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id17843
      - hotel_id1225
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/13/69/859/H5QBBL06_J.jpg
      - ratio_hw0.58
      - on_wall0
    - 1
      - id17844
      - hotel_id1225
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/13/69/852/villa4_J.jpg
      - ratio_hw0.81
      - on_wall0
    - 2
      - id17845
      - hotel_id1225
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/13/69/855/villa_J.jpg
      - ratio_hw0.61
      - on_wall0
    - 3
      - id17846
      - hotel_id1225
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/13/69/840/villa1_J.jpg
      - ratio_hw0.59
      - on_wall0
    - 4
      - id17847
      - hotel_id1225
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/13/69/844/villa3_J.jpg
      - ratio_hw0.71
      - on_wall0
    - 5
      - id17848
      - hotel_id1225
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/13/69/848/villa2_J.jpg
      - ratio_hw0.78
      - on_wall0
    - 6
      - id17849
      - hotel_id1225
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/18/662/444/Bild%20045_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 7
      - id17850
      - hotel_id1225
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/18/662/436/Bild%20035_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 8
      - id17851
      - hotel_id1225
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/18/662/440/Bild%20042_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 9
      - id17852
      - hotel_id1225
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/18/662/456/Bild%20016_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 10
      - id17853
      - hotel_id1225
      - order12
      - urihttp://images.pegs.com/imageRepo/1/0/18/662/448/Bild%20032_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 11
      - id17854
      - hotel_id1225
      - order13
      - urihttp://images.pegs.com/imageRepo/1/0/18/662/452/Kanalen%201_J.jpg
      - ratio_hw0.67
      - on_wall0
  - Room
    - 0
      - id4813
      - typeSTD
      - hotel_id1225
      - nameStandard double
      - descriptionQ1C - Standard double room with Twin or Queen bed. Water or Park view Standard double room for single or double use. 22 SQM/236 ft2. Two armchairs. Most of the rooms has a desk. Some have water view/ some have park view/ some have terrace. Bathroom with bathtub.
      - 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
      - id4814
      - typeOTH
      - hotel_id1225
      - nameSuperior Room
      - descriptionQ1B - Superior Queen Size Room. Terrace or Balcony with water view. One room on upper floor with a balcony with lovely view over the canal. 28 SQM/301 ft2. It has a desk and two armchairs. Suitable for families/ spacefor extra bed. Bathroom with bathtub. Two rooms on ground floor with small terrace close to the water with superb view. Built in 2007. 22 SQM/236 ft2. Two armchairs. Bathroom with bathtub.
      - 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
      - id4815
      - typeSTE
      - hotel_id1225
      - nameSuite
      - description(null)
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
  - RatesPeriod(empty)
  - Unavailability(empty)
  - Comment(empty)
  - Favorite(empty)
  - Taglines
    - 0
      - id2019
      - localeeng
      - modelHotel
      - foreign_key1225
      - fieldtagline
      - content
    - 1
      - id2020
      - localefre
      - modelHotel
      - foreign_key1225
      - fieldtagline
      - content
  - Envie
    - 0
      - id3
      - created2011-05-17 19:21:37
      - modified2011-05-17 19:21:37
    - 1
      - id7
      - created2011-05-17 19:24:56
      - modified2011-05-17 19:24:56
    - 2
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
- 4
  - Hotel
    - id828
    - starred0
    - in0
    - maintrack_hotel_id339048
    - brand_codeZS
    - nameHotel Hellsten
    - addressLuntmakargatan 68
    - zip_code11351
    - cityarea_id(null)
    - city_id370
    - region_id(null)
    - state_id(null)
    - country_idSE
    - latitude59.341499
    - longitude18.0595
    - zoom13
    - rating0
    - phone46 8-661-8600
    - reservation_phone46 20-73570770
    - fax46 8-661-8601
    - emailsupranational@supranational.co.uk
    - created2011-08-09 12:07:17
    - modified2011-08-09 20:06:42
    - descriptionThere are a number of labels that could be used to describe Hotel Hellsten, Design, Hip or Boutique being three of them. The founder's firm intention, however, is that the hotel should be a meeting place for travellers of all disciplines and interests, and become their home while staying in Stockholm. The garden wing of the building was earlier the home of several record companies. A fully equipped international standard recording studio, designed by Sweden's foremost acoustic designer, operates in the basement, with the elevator reaching directly there from the hotel rooms above. In the basement is now a fully equipped gym. A block away from the underground station of Radmansgatan, and about 40 kilometers from Arlanda Airport, Hotel Hellsten is right in the heart of Stockholm, within proximity of all central buildings and key locations. The locality is one of the most exciting in Stockholm, with a multitude of restaurants of all types within a few minutes walking distance. A full choice for all tastes.
    - description_freIl y a un certain nombre d'adjectifs qui pourraient être utilisés pour décrire l'hôtel Hellsten, conception, chic ou boutique hôtel ou encore les trois en même temps. Cependant, la ferme intention du fondateur est de rendre l'hôtel comme un lieu de rencontre pour les voyageurs de tous horizons, et de devenir leur maison tout en restant à Stockholm. L'aile du jardin de l'immeuble était auparavant le siège de plusieurs maisons de disques. Un studio d'enregistrement, conçu par des designers suédois, se trouve dans le sous-sol, avec l'ascenseur pour atteindre directement la chambre d'hôtel. Au sous-sol se trouve une salle de gym entièrement équipée. A un pâté de maisons de la station de métro Radmansgatan, et environ 40 kilomètres de l'aéroport d'Arlanda, l'Hôtel Hellsten se trouve en plein cœur de Stockholm, à proximité de tous les bâtiments du centre et des endroits clés. La localité est l'une des plus excitantes de Stockholm, avec une multitude de restaurants de tous types à quelques minutes à pied. Un choix complet pour tous les goûts.
    - amenityComplimentary Continental Breakfast, Lounge, 24 Hour Front Desk, Handicapped Rooms/Facilities, Express Checkout, Parking, Room Service, Fitness Center or Spa, Telephone, Mini Bar, Television with Cable, City Center.
    - amenity_frePetit déjeuner continental, Salon, Réception 24 heures, chambres / équipements pour handicapés, Express Checkout, parking, service en chambre, salle de gym ou de Spa, téléphone, mini bar, télévision avec câble, Centre Ville.
    - lowest_rate1290.00
    - lr_currencySEK
    - 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
    - id370
    - country_idSE
    - state_id(null)
    - maintrack_idSTOCKHOLM
    - nameStockholm
    - main_key
  - Country
    - idSE
    - nameSweden
    - name_freSuède
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id13052
      - hotel_id828
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/7/725/88/22265_EXT_01_E_J.jpg
      - ratio_hw0.80
      - on_wall0
    - 1
      - id13053
      - hotel_id828
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/7/725/96/22265_ROOM_02_E_J.jpg
      - ratio_hw0.80
      - on_wall0
    - 2
      - id13054
      - hotel_id828
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/21/920/756/SX-STOHL-RM02_J.jpg
      - ratio_hw0.80
      - on_wall0
    - 3
      - id13055
      - hotel_id828
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/7/725/92/22265_ROOM_01_E_J.jpg
      - ratio_hw0.80
      - on_wall0
    - 4
      - id13056
      - hotel_id828
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/21/920/747/STOHEL02A_J.jpg
      - ratio_hw0.80
      - on_wall0
  - Room
    - 0
      - id3310
      - typeOTH
      - hotel_id828
      - nameGuest Rooms
      - 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
      - id1293
      - localeeng
      - modelHotel
      - foreign_key828
      - fieldtagline
      - content
    - 1
      - id1294
      - localefre
      - modelHotel
      - foreign_key828
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id15
      - created2011-05-17 19:27:34
      - modified2011-05-17 19:27:34
    - 2
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
    - 3
      - id22
      - created2011-05-24 08:23:46
      - modified2011-05-24 08:23:46
pageTitleHôtels de charme à travers le monde
userData(null)
$this->data
- Hotel(empty)
$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

Hôtels de charme à travers le monde

5 résultats correspondent à votre recherche

Suède, Stockholm

Hotel Birger Jarl

Suède, Stockholm

Hotel J

Suède, Stockholm

Hotel Stureplan

Suède, Stockholm

Villa Kallhagen

Suède, Stockholm

Hotel Hellsten

Rechercher par envie

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

Rechercher une expérience

Se laisser guider

Rechercher un hôtel de charme

Rechercher par envie

Par pays

Hôtels de charme à travers le monde

5 résultats correspondent à votre recherche

Suède, Stockholm

Hotel Birger Jarl

Suède, Stockholm

Hotel J

Suède, Stockholm

Hotel Stureplan

Suède, Stockholm

Villa Kallhagen

Suède, Stockholm

Hotel Hellsten

Rechercher par envie

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

View Variables