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`.`country_id` = 'EE' AND `Hotel`.`published` = 1	1	1	6	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`.`country_id` = 'EE' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20	4	4	5	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 (1179, 974, 856, 349)	82	82	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 (1179, 974, 856, 349)	21	21	1
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (1179, 974, 856, 349)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1179, 974, 856, 349)	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 (1179, 974, 856, 349)	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 (1179, 974, 856, 349)	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 (1179, 974, 856, 349)	8	8	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 (1179, 974, 856, 349) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	17	17	1	maybe slow
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'EE' ORDER BY `Country`.`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)	74,07
Component initialization and startup	4,55
Controller action	41,66
Render Controller Action	78,06
» Rendering View	76,74
» » Rendering APP/views/hotels/index.ctp	24,77
» » » Rendering APP/views/elements/hotels/item.ctp	1,19
» » » Rendering APP/views/elements/hotels/item.ctp #2	1,14
» » » Rendering APP/views/elements/hotels/item.ctp #3	1,07
» » » Rendering APP/views/elements/hotels/item.ctp #4	1,16
» » » Rendering APP/views/elements/paging.ctp	0,11
» » Rendering APP/views/layouts/default.ctp	51,78
» » » Rendering APP/views/elements/google_analytics.ctp	0,08
» » » Rendering APP/views/elements/layout/top.ctp	1,54
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0,29
» » » Rendering APP/views/elements/layout/header.ctp	45,01
» » » Rendering APP/views/elements/layout/extra.ctp	0,12
» » » Rendering APP/views/elements/layout/footer.ctp	4,06
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0,30
» » » 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)
country
- Country
  - idEE
  - nameEstonia
  - name_freEstonie
hotels
- 0
  - Hotel
    - id1179
    - starred0
    - in0
    - maintrack_hotel_id302376
    - brand_codeLW
    - nameSchlossle Hotel
    - addressPühavaimu 13/15
    - zip_code10123
    - cityarea_id(null)
    - city_id311
    - region_id(null)
    - state_id(null)
    - country_idEE
    - latitude59.4385785
    - longitude24.7480932
    - zoom13
    - rating5
    - phone372 � 6 99 77 00
    - reservation_phone372 1-800-223-6800
    - fax372 � 6 99 77 77
    - emailschlossle@schlossle-hotels.com
    - created2011-09-29 19:07:19
    - modified2011-10-04 14:56:12
    - descriptionA unique and truly intimate atmosphere greets you as you step across the threshold of this very special hotel. At the heart of Tallinn's beautiful old town, the massive wooden beams, antique furnishings, and green and plum color decor gives this unique hotel a luxurious baronial atmosphere. Each room is individually designed, with many guests re-booking the same room time after time. The Schlossle Hotel is an experience in comfort and elegance, and always gives you a feeling of the perfect home away from home. The luxurious Hotel Schlossle is at the centre of Tallinn's Old Town, and only a few steps away from the main shopping streets and the Town Hall Square. Right in the heart of Tallinn!
    - description_freUne atmosphère intime et exceptionnelle vous attend dès votre arrivée sur le seuil de cet hôtel très spécial. Au cœur de la vieille ville de Tallinn, les poutres en bois massif, mobilier ancien, et le décor de couleur vert et prune donne à cet hôtel unique une atmosphère luxueuse. Chaque chambre est individuellement conçu, avec de nombreux invités fidèles. L'Hôtel Schlossle est une expérience de confort et d'élégance, et vous donne toujours un sentiment d'une maison idéale loin de chez vous. Le Schlossle Hôtel est à seulement quelques pas des rues commerçantes principales et de la place de la mairie. En plein coeur de Tallinn !
    - amenityBabysitting/Child Services, Lounge, Concierge, Handicapped Rooms/Facilities, Express Checkout, Free Newspaper, Restaurant, Room Service, Safe Deposit Box, Laundry/Valet Services, Telephone, Air Conditioned, Mini Bar, Modem Lines in Room, Television with Cable, Bathrobes, TV, Data port Available, Fire Place, Free Local Telephone Calls, Hairdryers Available, Internet Access, No Smoking Rooms/Facilities, Bathroom Telephone, Refrigerator, Safe, Smoke Detectors, Voicemail, Business Center, Meeting/Banquet Facilities, City Center.
    - amenity_freBabysitting / Services à l'enfance, salon, concierge, chambres / équipements pour handicapés, Express Checkout, journal gratuit, restaurant, service en chambre, coffre-fort, blanchisserie / Services, Téléphone, Air conditionné, mini bar, modem dans la chambre, télévision avec câble, peignoirs, télévision, les données disponibles le port, cheminée, Appels téléphoniques locaux gratuits, sèche-cheveux disponibles, l'accès Internet, Non fumeurs Chambres / Équipements, Téléphone Salle de bains, réfrigérateur, coffre, détecteur de fumée, messagerie vocale, centre d'affaires, salles de réunions / banquets, Ville Center.
    - lowest_rate157.00
    - lr_currencyEUR
    - lr_people2
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id311
    - country_idEE
    - state_id(null)
    - maintrack_idTALLINN
    - nameTallinn
    - main_key
  - Country
    - idEE
    - nameEstonia
    - name_freEstonie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id17169
      - hotel_id1179
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/841/Courtyard_1_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 1
      - id17170
      - hotel_id1179
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/845/_MG_1137_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 2
      - id17171
      - hotel_id1179
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/861/Schlossle_pics_vol3_025_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 3
      - id17172
      - hotel_id1179
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/865/Schlossle_pics_vol3_018_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 4
      - id17173
      - hotel_id1179
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/869/Schlossle_pics_vol3_022_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 5
      - id17174
      - hotel_id1179
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/873/Schlossle_pics_vol3_006_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 6
      - id17175
      - hotel_id1179
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/877/Room_1_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 7
      - id17176
      - hotel_id1179
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/881/_MG_0951_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 8
      - id17177
      - hotel_id1179
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/885/_MG_0966_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 9
      - id17178
      - hotel_id1179
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/889/_MG_0974_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 10
      - id17179
      - hotel_id1179
      - order12
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/893/_MG_1074_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 11
      - id17180
      - hotel_id1179
      - order13
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/901/_MG_0980_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 12
      - id17181
      - hotel_id1179
      - order14
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/909/_MG_1090_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 13
      - id17182
      - hotel_id1179
      - order15
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/925/Suite_1_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 14
      - id17183
      - hotel_id1179
      - order16
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/933/_MG_0918_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 15
      - id17184
      - hotel_id1179
      - order17
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/937/_MG_0923_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 16
      - id17185
      - hotel_id1179
      - order18
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/945/_MG_0930_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 17
      - id17186
      - hotel_id1179
      - order19
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/949/_MG_0944_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 18
      - id17187
      - hotel_id1179
      - order20
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/953/Stenhus_17_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 19
      - id17188
      - hotel_id1179
      - order21
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/957/Stenhus_155_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 20
      - id17189
      - hotel_id1179
      - order22
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/961/Schlossle_pics_vol3_036_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 21
      - id17190
      - hotel_id1179
      - order23
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/973/_MG_1108_J.jpg
      - ratio_hw0.50
      - on_wall0
    - 22
      - id17191
      - hotel_id1179
      - order24
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/985/sigarituba_4_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 23
      - id17192
      - hotel_id1179
      - order25
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/993/_MG_1111_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 24
      - id17193
      - hotel_id1179
      - order26
      - urihttp://images.pegs.com/imageRepo/1/0/28/70/913/_MG_1127_J.jpg
      - ratio_hw1.50
      - on_wall0
  - Room
    - 0
      - id4610
      - typeOTH
      - hotel_id1179
      - nameDeluxe Junior Suite
      - descriptionDeluxe Junior Suite Oversized room with well appointed luxury furniture/reflecting the lavish merchants style of the hotel.
      - 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
      - id4611
      - typeOTH
      - hotel_id1179
      - nameDeluxe Queen
      - descriptionDeluxe Queen Comfortable luxury room with one queen bed or double bed/well appointed furniture/ reflecting the lavish merchants style of the hotel.
      - 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
      - id4612
      - typeOTH
      - hotel_id1179
      - nameSchlossle Suite
      - descriptionDeluxe 1 Bedroom Suite Lavishly designed suite comprises of a total 90 sqm/incorporating a large living room separated in dining and relaxing area.
      - 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
      - id4613
      - typeOTH
      - hotel_id1179
      - nameDeluxe Twin
      - descriptionDeluxe Twin Comfortable luxury room with two twin beds/well appointed furniture/ reflecting the lavish merchants style of the hotel.
      - 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
      - id4614
      - typeOTH
      - hotel_id1179
      - nameSuperior Queen
      - descriptionSuperior Room 1 Queen bed Cozy room with well appointed furniture/reflecting the lavish merchants style of the hotel.
      - 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
      - id4615
      - typeOTH
      - hotel_id1179
      - nameSuperior King
      - descriptionSuperior 1 Bedroom Suite Elegantly furnished room with a separate living room and bedroom/reflecting the lavish merchants style of the hotel.
      - 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
      - id4616
      - typeOTH
      - hotel_id1179
      - nameSuperior Studio
      - 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
      - id1993
      - localeeng
      - modelHotel
      - foreign_key1179
      - fieldtagline
      - content
    - 1
      - id1994
      - localefre
      - modelHotel
      - foreign_key1179
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id19
      - created2011-05-24 08:21:45
      - modified2011-05-24 08:21:45
    - 2
      - id22
      - created2011-05-24 08:23:46
      - modified2011-05-24 08:23:46
- 1
  - Hotel
    - id974
    - starred0
    - in0
    - maintrack_hotel_id280835
    - brand_codeGW
    - nameAmmende Villa Hotel and Restaurant
    - addressMere blvd. 7
    - zip_code80010
    - cityarea_id(null)
    - city_id925
    - region_id(null)
    - state_id(null)
    - country_idEE
    - latitude58.3805651078393
    - longitude24.492286877246098
    - zoom12
    - rating4
    - phone372 44 73 888
    - reservation_phone372 214 357-5522
    - fax372 44 44 73 887
    - email(null)
    - created2011-09-01 17:27:48
    - modified2011-09-02 16:47:58
    - descriptionParnus temple of Jugendstil, Ammende Villa is situated in a green parkland in the beach area. It is impossible to miss a confection of turrets, towers, verandas and canopies that would not be out of place in Vienna or Paris. The hallway on the ground floor leads to the central hall of the building extending through two floors. The function rooms of the building are decorated as saloons and halls. One can read the menu in the peaceful atmosphere of the stylish Red Salon, enjoy good music in the Green Salon or have a cup of coffee and a cigar and play the genuine Russian billiards in the Cigar Salon. Our guests have a choice of three halls of the Villa, they can dine in the historic Blue Dining Hall, Green Wine Hall or Purple Hunting Hall. Through the entire year is Ammende Villa the place whose unique environment and excellent customer service level guarantee a pleasant atmosphere for all guests, regardless of whether they have to spend a relaxing and romantic holiday, a business meeting, company event, lounge-music concert, reception or unforgettable wedding party.
    - description_freLe temple Parnus de Jugendstil, l'Ammende Villa est situé dans un parc verdoyant dans la zone de la plage. Il est impossible de rater son architecture de tourelles, de vérandas et verrières. Le couloir au rez de chaussée mène à la pièce centrale du bâtiment qui s'étend à travers deux étages. Les chambres de l'hôtel sont décorés comme dans les salons. On peut découvrir le menu dans l'atmosphère paisible de l'élégant salon rouge; écouter de la musique dans le salon vert ou prendre une tasse de café et un cigare en jouant au billard russe authentique.
    - amenityHeated Guest Rooms, Jacuzzi, Free Newspaper, 24 Hour Room Service, Toilet, Wake-up Service, Telephone, City Center.
    - amenity_freChambres climatisée, jacuzzi, journal gratuit, service en chambre 24 heures, Toilettes, Service de réveil, Téléphone, 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
    - id925
    - country_idEE
    - state_id(null)
    - maintrack_idPARNU
    - namePärnu
    - main_key
  - Country
    - idEE
    - nameEstonia
    - name_freEstonie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id15010
      - hotel_id974
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/383/IMG_5818_J.jpg
      - ratio_hw1.40
      - on_wall0
    - 1
      - id15012
      - hotel_id974
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/391/TUBA_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 2
      - id15013
      - hotel_id974
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/395/IMG_5588_J.jpg
      - ratio_hw0.71
      - on_wall0
    - 3
      - id15014
      - hotel_id974
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/399/IMG_5826_J.jpg
      - ratio_hw0.71
      - on_wall0
    - 4
      - id15015
      - hotel_id974
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/403/IMG_5709_J.jpg
      - ratio_hw0.71
      - on_wall0
    - 5
      - id15016
      - hotel_id974
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/407/Konverents%2013_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 6
      - id15017
      - hotel_id974
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/411/Konverents%2012_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 7
      - id15018
      - hotel_id974
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/25/365/379/Ammende%20Villa_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 8
      - id15019
      - hotel_id974
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/22/573/327/Suite_J.jpg
      - ratio_hw0.66
      - on_wall0
  - Room
    - 0
      - id3842
      - typeOTH
      - hotel_id974
      - nameDeLux
      - descriptionOne 1 double or 2 twin beds Art Nouveau style luxurious furniture Each De Lux room is furnished with luxurious and lovely Art Nouveau furniture, a bathroom with shower, colour TV-set and satellite TV, ISDN lines and telephones, IDD, minisafe and minibar.
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
    - 1
      - id3843
      - typeOTH
      - hotel_id974
      - nameGardeners DeLux
      - descriptionDeLux room 1 double or 2 twin beds Antique Art Nouveau style - jaccuzzy There are 4 cosy De Lux rooms in renovated Gardeners House. In the former home of gardeners family all the rooms are decorated in old spirit, art noveau style furniture with matchin
      - 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
      - id3844
      - typeOTH
      - hotel_id974
      - 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
      - id1587
      - localeeng
      - modelHotel
      - foreign_key974
      - fieldtagline
      - content
    - 1
      - id1588
      - localefre
      - modelHotel
      - foreign_key974
      - fieldtagline
      - content
  - Envie
    - 0
      - id5
      - created2011-05-17 19:24:26
      - modified2011-05-17 19:24:26
    - 1
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
- 2
  - Hotel
    - id856
    - starred0
    - in0
    - maintrack_hotel_id261619
    - brand_code000194
    - namePadaste Manor
    - addressPadaste
    - zip_code94702
    - cityarea_id(null)
    - city_id817
    - region_id(null)
    - state_id(null)
    - country_idEE
    - latitude58.5505798
    - longitude23.2788422
    - zoom13
    - rating4
    - phone372 45 48800
    - reservation_phone372 1-800-525-4800
    - fax372 372-45-48811
    - emailinfo@padaste.ee
    - created2011-08-10 19:18:31
    - modified2011-08-11 11:45:45
    - descriptionAll the more impressive for its remote location, Padaste Manor is the epitome of simple luxury, elegant, romantic and supremely comfortable. Warm wooden floors in beautifully proportioned rooms with indigenous touches create an unforgettable sense of place. Try a Muhu hay bath, one of the spa treatments using local ingredients. Take an island tour around dolomite caves or wander the coastline by canoe. Padaste Manor is a Small Luxury Hotels of the World property.
    - description_freD'autant plus impressionnant pour son éloignement, le Padaste Manor est la quintessence du luxe simple, élégant, romantique et très confortable. Un chaleureux parquet dans les chambres magnifiquement proportionné avec une touche indigènes créer un sentiment inoubliable. Essayez un bain de foin Muhu, l'un des traitements du spa à l'aide d'ingrédients locaux. Faites une visite de l'île et ses grottes dolomite autour ou promenez-vous en canot sur la côte. Le Padaste Manor est membre de Small Luxury Hotels.
    - amenityPets Allowed, Barber/Beauty Shop, Massage, Lounge, Concierge, 24 Hour Front Desk, Handicapped Rooms/Facilities, Restaurant, Room Service, Safe Deposit Box, Fitness Center or Spa, Bathrobes, TV, International Direct Dial, Internet Access, Mini Bar, No Smoking Rooms/Facilities, TV Remote Control, Smoke Detectors, Hairdryers Available, Telephone, Modem Lines in Room, Beach, Sailing, Jogging Track, Business Center, Meeting/Banquet Facilities, City Center.
    - amenity_freAnimaux admis, salon de coiffure / institut de beauté, massages, salon, concierge, 24 heures réception, chambres / équipements pour handicapés, Restaurant, Room Service, coffre-fort, salle de gym ou de Spa, peignoirs, télévision, International Direct Dial, accès Internet, mini Bar, chambres non-fumeurs / Équipements, TV avec télécommande, détecteurs de fumée, sèche-cheveux, Téléphone, modem dans la chambre, plage, voile, piste de jogging, Business Center, salles de réunions / banquets, Ville.
    - lowest_rate157.00
    - lr_currencyEUR
    - lr_people2
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id817
    - country_idEE
    - state_id(null)
    - maintrack_idMUHUISLAND
    - namePadaste (Muhu)
    - main_key
  - Country
    - idEE
    - nameEstonia
    - name_freEstonie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id13329
      - hotel_id856
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/341/H4GG8L0H_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 1
      - id13330
      - hotel_id856
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/2/HUTLLPMH0N-cropped_J.jpg
      - ratio_hw0.70
      - on_wall0
    - 2
      - id13331
      - hotel_id856
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/6/3072637477_4596c08b21_o_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 3
      - id13332
      - hotel_id856
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/10/2004092554_c8f3ea76f2_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 4
      - id13333
      - hotel_id856
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/14/94526996_39f993e9b5_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 5
      - id13334
      - hotel_id856
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/21/3073817694_1ef6fb26ae_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 6
      - id13335
      - hotel_id856
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/64/3080105872_60ef8d5e58_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 7
      - id13336
      - hotel_id856
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/119/3080227140_049e230f37_o_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 8
      - id13337
      - hotel_id856
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/359/H4GG8L01_J.jpg
      - ratio_hw0.68
      - on_wall0
    - 9
      - id13338
      - hotel_id856
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/363/H4GG8L04_J.jpg
      - ratio_hw0.89
      - on_wall0
    - 10
      - id13339
      - hotel_id856
      - order12
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/131/2569489713_ff07dbacc2_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 11
      - id13340
      - hotel_id856
      - order13
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/369/Room%2014%20-%20detail_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 12
      - id13341
      - hotel_id856
      - order14
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/139/3118428430_2a63daaf1c_o_J.jpg
      - ratio_hw0.62
      - on_wall0
    - 13
      - id13342
      - hotel_id856
      - order15
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/143/3191019916_7b9d43f14e_o_J.jpg
      - ratio_hw0.59
      - on_wall0
    - 14
      - id13343
      - hotel_id856
      - order16
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/147/3118418140_f98831d1a0_o_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 15
      - id13344
      - hotel_id856
      - order17
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/151/double%20room%20in%20the%20carriage%20house_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 16
      - id13345
      - hotel_id856
      - order18
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/381/H4GG8L08_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 17
      - id13346
      - hotel_id856
      - order19
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/385/H4GG8L0C_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 18
      - id13347
      - hotel_id856
      - order20
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/163/3713607594_c0b780fe5d_o_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 19
      - id13348
      - hotel_id856
      - order21
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/167/3714485282_f751544732_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 20
      - id13349
      - hotel_id856
      - order22
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/171/3714202205_8b239dca6f_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 21
      - id13350
      - hotel_id856
      - order23
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/175/3715028858_5294997057_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 22
      - id13351
      - hotel_id856
      - order24
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/179/3117596019_9ee16a57bd_o_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 23
      - id13352
      - hotel_id856
      - order25
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/183/2676239263_a5c759e87a_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 24
      - id13353
      - hotel_id856
      - order26
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/218/2453754975_96e05bfbb6_b_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 25
      - id13354
      - hotel_id856
      - order27
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/222/108929115_174088fe58_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 26
      - id13355
      - hotel_id856
      - order28
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/226/3691999778_47c16a759b_o_J.jpg
      - ratio_hw1.38
      - on_wall0
    - 27
      - id13356
      - hotel_id856
      - order29
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/230/2569448159_8754de1b7a_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 28
      - id13357
      - hotel_id856
      - order30
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/234/2676271329_aa77c493d2_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 29
      - id13358
      - hotel_id856
      - order31
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/238/3073376442_2357c9eba0_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 30
      - id13359
      - hotel_id856
      - order32
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/242/316221363_f00a4e3fb5_o_J.jpg
      - ratio_hw0.70
      - on_wall0
    - 31
      - id13360
      - hotel_id856
      - order33
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/246/2574535011_0e5b6ed724_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 32
      - id13361
      - hotel_id856
      - order34
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/250/316277694_2876a356c9_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 33
      - id13362
      - hotel_id856
      - order35
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/421/Siberian%20cold%20tub%20Hires_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 34
      - id13363
      - hotel_id856
      - order36
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/258/283358390_64aa821bcc_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 35
      - id13364
      - hotel_id856
      - order37
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/427/283343868_d12ede39c9_o_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 36
      - id13365
      - hotel_id856
      - order38
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/431/2876864874_83c9d27454_o_J.jpg
      - ratio_hw1.29
      - on_wall0
    - 37
      - id13366
      - hotel_id856
      - order39
      - urihttp://images.pegs.com/imageRepo/1/0/28/13/435/2594894715_2dbed95f8f_o-1_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 38
      - id13367
      - hotel_id856
      - order40
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/274/3073515974_99e5fef320_o_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 39
      - id13368
      - hotel_id856
      - order41
      - urihttp://images.pegs.com/imageRepo/1/0/26/163/278/3591312901_9ca1dd30ec_o_J.jpg
      - ratio_hw0.67
      - on_wall0
  - Room
    - 0
      - id3421
      - typeOTH
      - hotel_id856
      - nameSuperior Double Room
      - descriptionCountry style double room, facing the garden or manor park and situated in the Guesthouse or the Carriagehouse. For your comfort you will find; a direct-dial telephone; Complementary WIFI; Sat-TV; Bathrobes and a selection of Molton Brown amenities.
      - 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
      - id3422
      - typeOTH
      - hotel_id856
      - nameSuperior Split Level Suite
      - descriptionDouble or twin bedded,Park or courtyard view, high definition LCD flat screen with satellite channels, personal in-room audio system, compl. wireless internet access, minibar, bathrobes, direct-dial telephone, compl. mineral water. Size: 22-28 sqm.
      - 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
      - id3423
      - typeOTH
      - hotel_id856
      - nameStandard Double Room
      - descriptionSplit-Level Suites are situated in the Carriagehouse, with a double bed, sitting area, writing table and bathroom. The 2nd level has a roof window opening to the courtyard. 1st level doors open to a private balcony overlooking the park and bay.
      - 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
      - id3424
      - typeOTH
      - hotel_id856
      - nameDeluxe Double Room
      - descriptionThe Farmhouse has 2 Master bedrooms en-suite. An attic room that can sleep additional 6 guests. A 3rd bathroom. In secluded part of the property. Terrace and garden. Living area with fireplace. WIFI. 3 Sat TV, 2 DvD player, Espresso machine, fruit press
      - 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
      - id3425
      - typeOTH
      - hotel_id856
      - nameSplit Level Suite with Wifi
      - descriptionThis is the largest room in the intimate Guesthouse, once the Cheese factory of the Manor. It has been tastefully renovated and adorned with antique furniture, a courtyard view, with a double or twin bed, WIFI, Sat-TV, bathrobes, Molton Brown amenities
      - 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
      - id3426
      - typeOTH
      - hotel_id856
      - namePrivate Farmhouse
      - 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
      - id1349
      - localeeng
      - modelHotel
      - foreign_key856
      - fieldtagline
      - content
    - 1
      - id1350
      - localefre
      - modelHotel
      - foreign_key856
      - 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
      - id5
      - created2011-05-17 19:24:26
      - modified2011-05-17 19:24:26
    - 3
      - id15
      - created2011-05-17 19:27:34
      - modified2011-05-17 19:27:34
    - 4
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
    - 5
      - id22
      - created2011-05-24 08:23:46
      - modified2011-05-24 08:23:46
- 3
  - Hotel
    - id349
    - starred0
    - in0
    - maintrack_hotel_id505389
    - brand_codeWB
    - nameThe Three Sisters Hotel
    - addressPikk 71 Tolli 2
    - zip_code10133
    - cityarea_id(null)
    - city_id311
    - region_id(null)
    - state_id(null)
    - country_idEE
    - latitude59.442001
    - longitude24.749001
    - zoom13
    - rating0
    - phone372 6 306300
    - reservation_phone(null)
    - fax372 6 306301
    - emailinfo@threesistershotel.com
    - created2011-05-13 21:08:45
    - modified2011-06-07 16:05:10
    - descriptionThe Three Sisters Hotel. Close to St. Olafs Church the tourist attractions main shopping areas and business districts this elegant hotel nonetheless enjoys a tranquil setting in the Old Town. The Three Sisters Hotel a fascinating residence that is frequented by stars and royal families boasts passageways secret, staircases, balconies and galleries enhanced by contemporary design. Original elements like the ceiling frescos or the wooden crane once used to hoist stores into the house have been painstakingly restored. The restaurant Bordoo is the perfect place for a late breakfast, a leisurely lunch or the gourmet delights proposed by the chef with a cellar boasting more than 300 crus.
    - description_freL'Hôtel Les Trois Sœurs est situé près de l'église Saint-Olaf et des principales attractions touristiques des zones commerçantes et des quartiers d'affaires, cet hôtel élégant bénéficie néanmoins d'une situation paisible dans la vieille ville. L'Hôtel les Trois Sœurs est fréquenté par les stars et les familles royales et dispose de passages secrets, balcons escaliers et des galeries au design contemporain. Les éléments originaux comme les fresques du plafond ou de la grue en bois servant à approvisionner la maison ont été soigneusement restaurés. Le restaurant Bordoo est l'endroit parfait pour un petit déjeuner tardif, un déjeuner ou déguster les merveilles gastronomiques proposées par le chef avec une cave riche de plus de 300 crus.
    - amenityHandicapped Rooms/Facilities, Childrens Activities, Pets Allowed, Play Ground, Babysitting/Child Services, Car Rental Desk, Concierge Desk, Tour Desk, Translation Service, Breakfast Buffet, Complimentary Continental Breakfast, Coffee Maker in Room, Room Service, Business Center, Concierge, Elevators, Guest Laundromat, Health Club, Jogging Track, Massage, Sauna, Fitness Center or Spa, 24 Hour Front Desk, Currency Exchange, Porters, Safe Deposit Box, Wake-up Service, Connecting Rooms, Free Newspaper, No Smoking Rooms/Facilities, Indoor Parking, Parking, Valet Parking, Coffee Shop, Lounge, Restaurant, Jacuzzi, 24 Hour Security, Doctor on Call, Maid Service, Laundry/Valet Services, News Stand, Free Airport Shuttle, Security, AM/FM Alarm Clock, Radio, Terrace, Bathrobes, Bathroom Telephone, Bidet, Television with Cable, TV, Cordless Phone, Desk with lamp, In Room Movies, Hairdryers Available, High speed internet access, Mini Bar, Private Bathroom, Safe, Shower, Sofa Bed, Phone with speaker, Telephone, Wireless Internet Access, CD Player, Outlet Adapters, DVD Player, Temperature Control, Satellite TV, Boating, Skiing, Fishing, Audio Visual Equipment, Computer Rental, Meeting/Banquet Facilities, Secretarial Service, Cellular Telephone Rental, Grab Bars in Bathroom, City Center, Smoke Detectors.
    - amenity_freChambres / équipements pour handicapés, activités pour enfants, animaux domestiques admis, aire de jeux, garde d'enfants, Location de voitures, bureau du concierge, bureau d'excursions, service de traduction, petit déjeuner buffet, Petit-déjeuner continental, bouilloire dans la salle, service en chambre, centre d'affaires, Concierge, Ascenseurs, Buanderie client, Club de santé, piste de jogging, massage, sauna, centre de remise en forme ou de Spa, 24 heures réception, service de change, Porters, Coffre-fort, Service de réveil, Chambres communicantes, journal gratuit, chambres non fumeur / Equipements, Parking couvert, parking, service de voiturier, un café, lounge, restaurant, jacuzzi, 24 heures de sécurité, Docteur à l'appel, Service d'entretien ménager, services de blanchisserie / Stand Nouvelles, navette d'aéroport gratuite, de sécurité, réveil AM / FM , Radio, Terrasse, peignoirs, salle de bains Téléphone, Bidet, Télévision par câble, TV, Téléphone sans fil, bureau avec lampe, Films dans la chambre, sèche-cheveux disponibles, l'accès Internet haut débit, mini-bar, salle de bains privée, coffre, douche, canapé-lit, Téléphone avec haut-parleur, téléphone, accès Internet sans fil, lecteur CD, sortie adaptateurs, lecteur DVD, Contrôle de la température, TV satellite, nautique, ski, pêche, Matériel audio-visuel, Location d'ordinateurs, salles de réunions / banquets, Service de secrétariat, location de téléphone cellulaire, Barres d'appui dans les salle de bains, Centre Ville, détecteurs de fumée.
    - lowest_rate126.67
    - lr_currencyEUR
    - lr_people2
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id311
    - country_idEE
    - state_id(null)
    - maintrack_idTALLINN
    - nameTallinn
    - main_key
  - Country
    - idEE
    - nameEstonia
    - name_freEstonie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id6432
      - hotel_id349
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/416/H1QXPL0W_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 1
      - id6433
      - hotel_id349
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/420/H1QXPL0P_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 2
      - id6434
      - hotel_id349
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/424/H1QXPL0U_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 3
      - id6435
      - hotel_id349
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/428/H1QXPL0Q_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 4
      - id6436
      - hotel_id349
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/432/H1QXPL0S_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 5
      - id6437
      - hotel_id349
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/436/H1QXPL0T_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 6
      - id6438
      - hotel_id349
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/440/H1QXPL0V_J.jpg
      - ratio_hw0.69
      - on_wall0
    - 7
      - id6439
      - hotel_id349
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/29/187/444/H1QXPL0X_J.jpg
      - ratio_hw0.69
      - on_wall0
  - Room
    - 0
      - id1392
      - typeOTH
      - hotel_id349
      - nameSuperior Room Queen Bed
      - descriptionClassic Room- Queen Bed- 20sqm-215sqft- Free Internet- No extra bed possible
      - 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
      - id1393
      - typeOTH
      - hotel_id349
      - nameDeluxe Room Queen/Twin Bed
      - descriptionDeluxe Room- Queen/Twin Bed- 23 to 29sqm-248 to 312sqft- Extra bed possible-charges apply
      - 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
      - id1394
      - typeOTH
      - hotel_id349
      - nameJunior Suite Queen Bed
      - descriptionJunior Suite- Queen Bed- 33 to 55sqm-355 to 592sqft- Extra beds possible-charges apply
      - 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
      - id1395
      - typeOTH
      - hotel_id349
      - nameSuite Queen Bed
      - descriptionSuite- Queen Bed- Living Room- 60sqm-646sqft- Extra beds possible-charges apply
      - 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
      - id1396
      - typeOTH
      - hotel_id349
      - namePiano Suite Queen Bed
      - 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
      - id359
      - localeeng
      - modelHotel
      - foreign_key349
      - fieldtagline
      - content
    - 1
      - id360
      - localefre
      - modelHotel
      - foreign_key349
      - 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
      - id17
      - created2011-05-17 19:28:06
      - modified2011-05-17 19:28:06
    - 3
      - id19
      - created2011-05-24 08:21:45
      - modified2011-05-24 08:21:45
    - 4
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
    - 5
      - id22
      - created2011-05-24 08:23:46
      - modified2011-05-24 08:23:46
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

4 résultats correspondent à votre recherche

Estonie, Tallinn

Schlossle Hotel

Estonie, Pärnu

Ammende Villa Hotel and Restaurant

Estonie, Padaste (Muhu)

Padaste Manor

Estonie, Tallinn

The Three Sisters Hotel

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

4 résultats correspondent à votre recherche

Estonie, Tallinn

Schlossle Hotel

Estonie, Pärnu

Ammende Villa Hotel and Restaurant

Estonie, Padaste (Muhu)

Padaste Manor

Estonie, Tallinn

The Three Sisters Hotel

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