Boutique hotels worldwide

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

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 `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 `hotel_i18n`	6	6	1	maybe slow
SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'eng') WHERE 1 = 1	1	1	0
SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1)	2	2	0
SELECT 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` = 'eng') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) LEFT JOIN `home_hotels` AS `HomeHotel` ON (`HomeHotel`.`hotel_id` = `Hotel`.`id`) WHERE `Hotel`.`city_id` = 1088 AND `Hotel`.`published` = 1	1	1	5	maybe slow
SELECT `Hotel`., `HomeHotel`., `City`., `Country`., `State`.*, `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'eng') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) LEFT JOIN `home_hotels` AS `HomeHotel` ON (`HomeHotel`.`hotel_id` = `Hotel`.`id`) WHERE `Hotel`.`city_id` = 1088 AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20	1	1	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` = (1171)	6	6	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` = (1171)	4	4	1	maybe slow
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` = (1171)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` = (1171)	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` = (1171)	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` = (1171)	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` = (1171)	2	2	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` = 1171 AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	7	7	0
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` = 1088 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` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	10	10	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `theme_i18n` AS `Names` WHERE `model` = 'Theme' AND `field` = 'name' AND `Names`.`foreign_key` IN (6, 10, 7, 12, 11, 13, 5, 8, 4, 9)	20	20	0
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1	10	10	0
SELECT `Envie`.*, `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18n__name` ON (`Envie`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Envie' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	29	29	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `envie_i18n` AS `Names` WHERE `model` = 'Envie' AND `field` = 'name' AND `Names`.`foreign_key` IN (19, 5, 6, 24, 8, 25, 4, 10, 12, 7, 9, 22, 30, 14, 26, 21, 3, 1, 13, 27, 18, 11, 28, 29, 16, 15, 23, 2, 17)	58	58	0
SELECT `Hotel`.`id`, `Country`.*, `Country`.`id` FROM `hotels` AS `Hotel` LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) WHERE 1 = 1 GROUP BY `Hotel`.`country_id` ORDER BY `Country`.`name` ASC	120	120	0
SHOW FULL COLUMNS FROM `promises`	3	3	0
SELECT `Promise`.*, `I18n__title`.`content`, `I18n__content`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18n__title` ON (`Promise`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Promise' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__content` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Promise' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') WHERE 1 = 1 LIMIT 4	4	4	0
SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Promise' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT `Contents`.`id`, `Contents`.`locale`, `Contents`.`model`, `Contents`.`foreign_key`, `Contents`.`field`, `Contents`.`content` FROM `i18n` AS `Contents` WHERE `model` = 'Promise' AND `field` = 'content' AND `Contents`.`foreign_key` IN (1, 2, 3, 4)	8	8	0

Message	Memory use
Component initialization	14.30 MB
Controller action start	14.48 MB
Controller render start	15.21 MB
View render complete	18.98 MB

Message	Time in ms	Graph
Core Processing (Derived)	69.27
Component initialization and startup	3.16
Controller action	37.82
Render Controller Action	76.04
» Rendering View	74.83
» » Rendering APP/views/hotels/index.ctp	20.30
» » » Rendering APP/views/elements/hotels/item.ctp	1.18
» » » Rendering APP/views/elements/paging.ctp	0.12
» » Rendering APP/views/layouts/default.ctp	54.34
» » » 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.33
» » » Rendering APP/views/elements/layout/header.ctp	47.26
» » » Rendering APP/views/elements/layout/extra.ctp	0.12
» » » Rendering APP/views/elements/layout/footer.ctp	4.31
» » » » 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 A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 - content
 - localeeng
 - Titles
 - 0
 - id10143
 - localeeng
 - modelPromise
 - foreign_key1
 - fieldtitle
 - content A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 - 1
 - id10144
 - localefre
 - modelPromise
 - foreign_key1
 - fieldtitle
 - content Des hôtels de charme a taille humaine
 - Contents
 - 0
 - id10145
 - localeeng
 - modelPromise
 - foreign_key1
 - fieldcontent
 - content
 - 1
 - id10146
 - localefre
 - modelPromise
 - foreign_key1
 - fieldcontent
 - content Globe Secret se distingue par l’originalité de sa sélection d’hôtels de charme. Ces quelques 1200 adresses autour du monde ont pour trait commun l’intimité (maximum 30 chambres) et un cadre préservé. Inclassables, ces adresses sont ancrées dans la culture de leur pays, revendiquant une authenticité et un accueil personnalisé. Avec Globe Secret, vous n’êtes pas prêts d’oublier vos vacances…             <meta charset="utf-8" /> 
- 1
 - Promise
 - id2
 - title BOOKING AT NO ADDITIONAL COST
 - content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 - localeeng
 - Titles
 - 0
 - id10147
 - localeeng
 - modelPromise
 - foreign_key2
 - fieldtitle
 - content BOOKING AT NO ADDITIONAL COST
 - 1
 - id10148
 - localefre
 - modelPromise
 - foreign_key2
 - fieldtitle
 - content RESERVATION SANS FRAIS
 - Contents
 - 0
 - id10149
 - localeeng
 - modelPromise
 - foreign_key2
 - fieldcontent
 - content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 - 1
 - id10150
 - localefre
 - modelPromise
 - foreign_key2
 - fieldcontent
 - content Globe Secret garantie une transparence de prix et de réservation. En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.
- 2
 - Promise
 - id3
 - title UNIQUE SELECTION CRITERIA
 - content
 - localeeng
 - Titles
 - 0
 - id10151
 - localeeng
 - modelPromise
 - foreign_key3
 - fieldtitle
 - content UNIQUE SELECTION CRITERIA
 - 1
 - id10152
 - localefre
 - modelPromise
 - foreign_key3
 - fieldtitle
 - content DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 - Contents
 - 0
 - id10153
 - localeeng
 - modelPromise
 - foreign_key3
 - fieldcontent
 - content
 - 1
 - id10154
 - localefre
 - modelPromise
 - foreign_key3
 - fieldcontent
 - content   Globe Secret vous propose de nombreux critères d’entrée et originaux pour choisir l’hôtel ou l’expérience qui correspond à vos envies. Ex: la zone géographique mais aussi le climat, la galerie. Nous avons classé les hôtels par thèmes, vous permettant de faire une recherche d'hotel ou une expérience en fonction de vos goûts ou d'une envie particulière ex: équitation, culture, festival, pêche,..
- 3
 - Promise
 - id4
 - title MORE TAILORED SERVICES
 - content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 - localeeng
 - Titles
 - 0
 - id10155
 - localeeng
 - modelPromise
 - foreign_key4
 - fieldtitle
 - content MORE TAILORED SERVICES
 - 1
 - id10156
 - localefre
 - modelPromise
 - foreign_key4
 - fieldtitle
 - content PLUS DE SERVICES A LA CARTE
 - Contents
 - 0
 - id10157
 - localeeng
 - modelPromise
 - foreign_key4
 - fieldcontent
 - content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 - 1
 - id10158
 - localefre
 - modelPromise
 - foreign_key4
 - fieldcontent
 - content   <meta charset="utf-8" /> <div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; "> Globe Secret vous propose aussi ses services pour la réservation de vos billets d’avion. Accédez ainsi à des tarifs négociés sur + de 500 compagnies aériennes vers plus de 1000 destinations. Toujours selon le même principe, ce service est sans frais supplémentaires. Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste, nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. Faites-nous part de vos projets !</div>
destinations_for_layout
- AFAfghanistan
- AXAland Islands
- ALAlbania
- DZAlgeria
- ASAmerican Samoa
- ADAndorra
- AOAngola
- AIAnguilla
- AQAntarctica
- AGAntigua/Barbuda
- ARArgentina
- AMArmenia
- AWAruba
- AUAustralia
- ATAustria
- AZAzerbaijan
- BSBahamas
- BHBahrain
- BDBangladesh
- BBBarbados
- BYBelarus
- BEBelgium
- BZBelize
- BJBenin
- BMBermuda
- BTBhutan
- BOBolivia
- BABosnia
- BWBotswana
- BVBouvet Island
- BRBrazil
- IOBritish Indian Ocean Territory
- WIBritish West Indies
- BNBrunei Darussalam
- BGBulgaria
- BFBurkina Faso
- BIBurundi
- KHCambodia
- CMCameroon
- CACanada
- CVCape Verde
- KYCayman Islands
- CFCentral Africa
- TDChad
- CLChile
- CNChina
- CXChristmas Island
- CCCocos (Keeling) Islands
- COColombia
- KMComoros
- CGCongo
- CDCongo
- CKCook Islands
- CRCosta Rica
- CICote D'Ivoire
- HRCroatia
- CUCuba
- CYCyprus
- CZCzech Republic
- DKDenmark
- DJDjibouti
- DMDominica
- DODominican Republic
- TPEast Timor
- ECEcuador
- EGEgypt
- SVEl Salvador
- GQEquatorial Guinea
- EREritrea
- EEEstonia
- ETEthiopia
- FOFaeroe Islands
- FKFalkland Islands
- FJFiji
- FIFinland
- FRFrance
- PFFrench Polynesia
- TFFrench Southern Territories
- GAGabon
- GMGambia
- XAGaza
- GEGeorgia
- DEGermany
- GHGhana
- GIGibraltar
- GRGreece
- GLGreenland
- GDGrenada
- GPGuadeloupe
- GUGuam
- GTGuatemala
- GGGuernsey
- GFGuiana
- GNGuinea
- GWGuinea-Bissau
- GYGuyana
- HTHaiti
- HMHeard And Mcdonald Islands
- XHHeld Territories
- HNHonduras
- HKHong Kong
- HUHungary
- ISIceland
- INIndia
- XIIndian Ocean Islands
- IDIndonesia
- IRIran
- IQIraq
- IEIreland
- IMIsle of Man
- ILIsrael
- ITItaly
- JMJamaica
- JPJapan
- JEJersey
- JOJordan
- KZKazakhstan
- KEKenya
- KIKiribati
- KRKorea
- KWKuwait
- KGKyrgyzstan
- LALaos
- LVLatvia
- LBLebanon
- LSLesotho
- LRLiberia
- LYLibya
- LILiechtenstein
- LTLithuania
- LULuxembourg
- MOMacau
- MKMacedonia
- MGMadagascar
- MWMalawi
- MYMalaysia
- MVMaldives
- MLMali
- MTMalta
- MHMarshall Islands
- MQMartinique
- MRMauritania
- MUMauritius
- YTMayotte
- MXMexico
- FMMicronesia
- MDMoldova
- MCMonaco
- MNMongolia
- MEMontenegro
- MSMontserrat
- MAMorocco
- MZMozambique
- MMMyanmar
- NANamibia
- NRNauru
- NPNepal
- NLNetherlands
- ANNetherlands Antilles
- NCNew Caledonia
- NZNew Zealand
- NINicaragua
- NENiger
- NGNigeria
- NUNiue
- NFNorfolk Island
- XBNorthern Ireland
- MPNorthern Mariana Islands
- NONorway
- OMOman
- PKPakistan
- PWPalau
- PSPalestinian Territory
- PAPanama
- PGPapua New Guinea
- PYParaguay
- PEPeru
- PHPhilippines
- PNPitcairn
- PLPoland
- PTPortugal
- PRPuerto Rico
- QAQatar
- REReunion
- RORomania
- RURussia
- RWRwanda
- LCSaint Lucia
- BLSaint-Barthelemy
- MFSaint-Martin
- SMSan Marino
- STSao Tome And Principe
- SASaudi Arabia
- WYScotland
- SNSenegal
- RSSerbia
- YUSerbia and Montenegro
- CSSerbia and Montenegro
- SCSeychelles
- SLSierra Leone
- SGSingapore
- SKSlovak Republic
- SISlovenia
- SBSolomon Islands
- SOSomalia
- ZASouth Africa
- GSSouth Georgia
- ESSpain
- LKSri Lanka
- SHSt. Helena
- KNSt. Kitts & Nevis
- PMSt. Pierre
- VCSt. Vincent & The Grenadines
- SDSudan
- SRSuriname
- SJSvalbard And Jan Mayen Islands
- SZSwaziland
- SESweden
- CHSwitzerland
- SYSyria
- TWTaiwan
- TJTajikistan
- TZTanzania
- THThailand
- TLTimor-Leste
- TGTogo
- TKTokelau
- TOTonga
- TTTrinidad And Tobago
- TNTunisia
- TRTurkey
- TMTurkmenistan
- TCTurks And Caicos Islands
- TVTuvalu
- UMU.S. Minor Outlying Islands
- UGUganda
- UAUkraine
- AEUnited Arab Emirates
- GBUnited Kingdom
- USUnited States
- UYUruguay
- UZUzbekistan
- VUVanuatu
- VAVatican City State
- VEVenezuela
- VNVietnam
- VGVirgin Islands (British)
- VIVirgin Islands (U.S.)
- WXWales
- WFWallis And Futuna Islands
- EHWestern Sahara
- WSWestern Samoa
- YEYemen
- ZRZaire
- ZMZambia
- ZWZimbabwe
themes_for_layout
- 6Art & Culture
- 10Famille & Enfant
- 7Festival & Tradition
- 12Gastronomie
- 11Insolite & Curieux
- 13Marché & Shopping
- 5Musique
- 8Nature
- 4Parc & Jardin
- 9Sport
themes_images_for_layout
- 6art0.png
- 4parc1.png
- 5musique0.png
- 7festival0.png
- 8nature0.png
- 9sport0.png
- 10famille0.png
- 11insolite0.png
- 12gastronomie0.png
- 13shopping0.png
envies_for_layout
- 19BABY SITTING
- 5BEACH
- 6BICYCLE RENTAL
- 24CIGAR LOUNGE
- 8CITY
- 25COUNTRYSIDE
- 4DESERT
- 10DIVING
- 12ECOLOGY
- 7FISHING
- 9GOLF
- 22HANDICAP ACCESS
- 30HELIPORT
- 14HORSEBACK RIDING
- 26HUNTING
- 21INTERNET ACCESS
- 3ISLAND
- 1JUNGLE
- 13LAKE
- 27POLO
- 18POOL
- 11SAFARI
- 28SAILING
- 29SHOPPING
- 16SKIING
- 15SPA
- 23TENNIS
- 2TREKKING
- 17WINERY
countries_for_layout
- 0
  - Country
    - idAL
    - nameAlbania
    - name_freAlbanie
- 1
  - Country
    - idAD
    - nameAndorra
    - name_freAndorre
- 2
  - Country
    - idAI
    - nameAnguilla
    - name_freAnguilla
- 3
  - Country
    - idAG
    - nameAntigua/Barbuda
    - name_freAntigua-Et-Barbuda
- 4
  - Country
    - idAR
    - nameArgentina
    - name_freArgentine
- 5
  - Country
    - idAM
    - nameArmenia
    - name_freArménie
- 6
  - Country
    - idAU
    - nameAustralia
    - name_freAustralie
- 7
  - Country
    - idAT
    - nameAustria
    - name_freAutriche
- 8
  - Country
    - idAZ
    - nameAzerbaijan
    - name_freAzerbaïdjan
- 9
  - Country
    - idBS
    - nameBahamas
    - name_freBahamas
- 10
  - Country
    - idBB
    - nameBarbados
    - name_freBarbade
- 11
  - Country
    - idBE
    - nameBelgium
    - name_freBelgique
- 12
  - Country
    - idBZ
    - nameBelize
    - name_freBelize
- 13
  - Country
    - idBM
    - nameBermuda
    - name_freBermudes
- 14
  - Country
    - idBT
    - nameBhutan
    - name_freBhoutan
- 15
  - Country
    - idBO
    - nameBolivia
    - name_freBolivie
- 16
  - Country
    - idBA
    - nameBosnia
    - name_freBosnie-Herzégovine
- 17
  - Country
    - idBR
    - nameBrazil
    - name_freBrésil
- 18
  - Country
    - idKH
    - nameCambodia
    - name_freCambodge
- 19
  - Country
    - idCA
    - nameCanada
    - name_freCanada
- 20
  - Country
    - idCL
    - nameChile
    - name_freChili
- 21
  - Country
    - idCN
    - nameChina
    - name_freChine
- 22
  - Country
    - idCO
    - nameColombia
    - name_freColombie
- 23
  - Country
    - idCK
    - nameCook Islands
    - name_freÎles Cook
- 24
  - Country
    - idCR
    - nameCosta Rica
    - name_freCosta Rica
- 25
  - Country
    - idHR
    - nameCroatia
    - name_freCroatie
- 26
  - Country
    - idCZ
    - nameCzech Republic
    - name_freRépublique Tchèque
- 27
  - Country
    - idDK
    - nameDenmark
    - name_freDanemark
- 28
  - Country
    - idDM
    - nameDominica
    - name_freDominique
- 29
  - Country
    - idDO
    - nameDominican Republic
    - name_freRépublique Dominicaine
- 30
  - Country
    - idEC
    - nameEcuador
    - name_freÉquateur
- 31
  - Country
    - idEG
    - nameEgypt
    - name_freÉgypte
- 32
  - Country
    - idEE
    - nameEstonia
    - name_freEstonie
- 33
  - Country
    - idFJ
    - nameFiji
    - name_freFidji
- 34
  - Country
    - idFI
    - nameFinland
    - name_freFinlande
- 35
  - Country
    - idFR
    - nameFrance
    - name_freFrance
- 36
  - Country
    - idPF
    - nameFrench Polynesia
    - name_frePolynésie Française
- 37
  - Country
    - idDE
    - nameGermany
    - name_freAllemagne
- 38
  - Country
    - idGR
    - nameGreece
    - name_freGrèce
- 39
  - Country
    - idGD
    - nameGrenada
    - name_freGrenade
- 40
  - Country
    - idGP
    - nameGuadeloupe
    - name_freGuadeloupe
- 41
  - Country
    - idGT
    - nameGuatemala
    - name_freGuatemala
- 42
  - Country
    - idHN
    - nameHonduras
    - name_freHonduras
- 43
  - Country
    - idHK
    - nameHong Kong
    - name_freHong-Kong
- 44
  - Country
    - idHU
    - nameHungary
    - name_freHongrie
- 45
  - Country
    - idIS
    - nameIceland
    - name_freIslande
- 46
  - Country
    - idIN
    - nameIndia
    - name_freInde
- 47
  - Country
    - idID
    - nameIndonesia
    - name_freIndonésie
- 48
  - Country
    - idIE
    - nameIreland
    - name_freIrlande
- 49
  - Country
    - idIL
    - nameIsrael
    - name_freIsraël
- 50
  - Country
    - idIT
    - nameItaly
    - name_freItalie
- 51
  - Country
    - idJM
    - nameJamaica
    - name_freJamaïque
- 52
  - Country
    - idJP
    - nameJapan
    - name_freJapon
- 53
  - Country
    - idJO
    - nameJordan
    - name_freJordanie
- 54
  - Country
    - idKE
    - nameKenya
    - name_freKenya
- 55
  - Country
    - idLA
    - nameLaos
    - name_freLaos
- 56
  - Country
    - idLV
    - nameLatvia
    - name_freLettonie
- 57
  - Country
    - idLB
    - nameLebanon
    - name_freLiban
- 58
  - Country
    - idLT
    - nameLithuania
    - name_freLituanie
- 59
  - Country
    - idMO
    - nameMacau
    - name_freMacao
- 60
  - Country
    - idMG
    - nameMadagascar
    - name_freMadagascar
- 61
  - Country
    - idMY
    - nameMalaysia
    - name_freMalaisie
- 62
  - Country
    - idMV
    - nameMaldives
    - name_freMaldives
- 63
  - Country
    - idMU
    - nameMauritius
    - name_freMaurice
- 64
  - Country
    - idMX
    - nameMexico
    - name_freMexique
- 65
  - Country
    - idMN
    - nameMongolia
    - name_freMongolie
- 66
  - Country
    - idME
    - nameMontenegro
    - name_freMonténégro
- 67
  - Country
    - idMA
    - nameMorocco
    - name_freMaroc
- 68
  - Country
    - idMZ
    - nameMozambique
    - name_freMozambique
- 69
  - Country
    - idMM
    - nameMyanmar
    - name_freMyanmar
- 70
  - Country
    - idNA
    - nameNamibia
    - name_freNamibie
- 71
  - Country
    - idNL
    - nameNetherlands
    - name_frePays-Bas
- 72
  - Country
    - idAN
    - nameNetherlands Antilles
    - name_freAntilles Néerlandaises
- 73
  - Country
    - idNZ
    - nameNew Zealand
    - name_freNouvelle-Zélande
- 74
  - Country
    - idNI
    - nameNicaragua
    - name_freNicaragua
- 75
  - Country
    - idNO
    - nameNorway
    - name_freNorvège
- 76
  - Country
    - idOM
    - nameOman
    - name_freOman
- 77
  - Country
    - idPK
    - namePakistan
    - name_frePakistan
- 78
  - Country
    - idPA
    - namePanama
    - name_frePanama
- 79
  - Country
    - idPE
    - namePeru
    - name_frePérou
- 80
  - Country
    - idPH
    - namePhilippines
    - name_frePhilippines
- 81
  - Country
    - idPL
    - namePoland
    - name_frePologne
- 82
  - Country
    - idPT
    - namePortugal
    - name_frePortugal
- 83
  - Country
    - idPR
    - namePuerto Rico
    - name_frePorto Rico
- 84
  - Country
    - idRE
    - nameReunion
    - name_freRéunion
- 85
  - Country
    - idRO
    - nameRomania
    - name_freRoumanie
- 86
  - Country
    - idRU
    - nameRussia
    - name_freRussie
- 87
  - Country
    - idLC
    - nameSaint Lucia
    - name_freSainte-Lucie
- 88
  - Country
    - idBL
    - nameSaint-Barthelemy
    - name_freSaint-Barthélemy
- 89
  - Country
    - idSA
    - nameSaudi Arabia
    - name_freArabie Saoudite
- 90
  - Country
    - idRS
    - nameSerbia
    - name_freSerbie
- 91
  - Country
    - idSC
    - nameSeychelles
    - name_freSeychelles
- 92
  - Country
    - idSG
    - nameSingapore
    - name_freSingapour
- 93
  - Country
    - idSK
    - nameSlovak Republic
    - name_freSlovaquie
- 94
  - Country
    - idSI
    - nameSlovenia
    - name_freSlovénie
- 95
  - Country
    - idZA
    - nameSouth Africa
    - name_freAfrique Du Sud
- 96
  - Country
    - idES
    - nameSpain
    - name_freEspagne
- 97
  - Country
    - idLK
    - nameSri Lanka
    - name_freSri Lanka
- 98
  - Country
    - idKN
    - nameSt. Kitts & Nevis
    - name_freSaint-Kitts-Et-Nevis
- 99
  - Country
    - idVC
    - nameSt. Vincent & The Grenadines
    - name_freSaint-Vincent-Et-Les Grenadines
- 100
  - Country
    - idSJ
    - nameSvalbard And Jan Mayen Islands
    - name_freSvalbard Et Île Jan Mayen
- 101
  - Country
    - idSE
    - nameSweden
    - name_freSuède
- 102
  - Country
    - idCH
    - nameSwitzerland
    - name_freSuisse
- 103
  - Country
    - idTW
    - nameTaiwan
    - name_freTaïwan
- 104
  - Country
    - idTZ
    - nameTanzania
    - name_freTanzanie
- 105
  - Country
    - idTH
    - nameThailand
    - name_freThaïlande
- 106
  - Country
    - idTN
    - nameTunisia
    - name_freTunisie
- 107
  - Country
    - idTR
    - nameTurkey
    - name_freTurquie
- 108
  - Country
    - idTC
    - nameTurks And Caicos Islands
    - name_freÎles Turks et Caïques
- 109
  - Country
    - idUG
    - nameUganda
    - name_freOuganda
- 110
  - Country
    - idUA
    - nameUkraine
    - name_freUkraine
- 111
  - Country
    - idAE
    - nameUnited Arab Emirates
    - name_freÉmirats Arabes Unis
- 112
  - Country
    - idGB
    - nameUnited Kingdom
    - name_freRoyaume-Uni
- 113
  - Country
    - idUS
    - nameUnited States
    - name_freÉtats-Unis
- 114
  - Country
    - idUY
    - nameUruguay
    - name_freUruguay
- 115
  - Country
    - idVU
    - nameVanuatu
    - name_freVanuatu
- 116
  - Country
    - idVN
    - nameVietnam
    - name_freViet Nam
- 117
  - Country
    - idVG
    - nameVirgin Islands (British)
    - name_freÎles Vierges Britanniques
- 118
  - Country
    - idVI
    - nameVirgin Islands (U.S.)
    - name_freÎles Vierges Des États-Unis
- 119
  - Country
    - idZW
    - nameZimbabwe
    - name_freZimbabwe
staticSlugs
- 0who-we-are
- 1sitemap
- 2terms-and-conditions
- 3news
- 4jobs
- 5legal
- 6credits
userFavorites
- fav-event(empty)
- fav-hotel(empty)
city
- City
  - id1088
  - country_idAT
  - state_id(null)
  - maintrack_idBERWANG
  - nameBerwang
  - main_key
country
- Country
  - idAT
  - nameAustria
  - name_freAutriche
hotels
- 0
  - Hotel
    - id1171
    - starred0
    - in0
    - maintrack_hotel_id328394
    - brand_codeWB
    - nameSinger Sporthotel and Spa
    - addressBerwang
    - zip_code6622
    - cityarea_id(null)
    - city_id1088
    - region_id(null)
    - state_id(null)
    - country_idAT
    - latitude47.409029043394696
    - longitude10.7477226799011
    - zoom13
    - rating0
    - phone43 5674 8181
    - reservation_phone1 800 735-2478
    - fax43 5674 818183
    - emailsinger@relaischateaux.com
    - created2011-09-29 18:45:13
    - modified2011-10-04 11:23:00
    - descriptionSince 1928, the Singer family has imbued this cosy hotel with its family spirit and ever evolving services. Due to the commitment of Günter and Gerti Singer and their son Florian, who runs the hotel today, this wellness hotel is the ideal starting point to explore the ski resorts and hiking trails around the Zugspitze. Fitness trainer Gerhard Brutscher offers a customised programme ranging from personal training sessions down to mountain hikes. Rejuvenate tired muscles in the delightful spa: treatments with Tyrolean herbs, minerals, vinotherapy, waterbeds, salt water, aroma steam baths, sauna, heated outdoor swimming pool. A regenerating stay just a few kilometres from the most beautiful royal castles of Ludwig II.
    - description_freDepuis 1928, la famille Singer a imprégné cet hôtel confortable avec son esprit de famille et des services en constante évolution. Grâce à l'engagement de Günter et Gerti Singer, et leur fils, Florian qui tient l'hôtel aujourd'hui, cet hôtel de bien-être est le point de départ idéal pour explorer les stations de ski et des sentiers de randonnée autour de la Zugspitze. Gerhard Brutscher propose un programme personnalisé de sport allant de sessions d'entraînement privé aux randonnées en montagne. Vous pourrez détendre vos muscles fatigués dans le spa délicieux: avec des traitements aux herbes du Tyrol, des minéraux, vinothérapie, matelas à eau, eau salée, des bains de vapeur aromatique, sauna, piscine extérieure chauffée. Un endroit superbe juste à quelques kilomètres des plus beaux châteaux royaux de Louis II.
    - amenityBabysitting/Child Services, Lounge, Concierge, Restaurant, Room Service, Safe Deposit Box, Fitness Center or Spa, Laundry/Valet Services, Childrens Activities, Pets Allowed, Concierge Desk, Continental Breakfast, Elevators, Copy Service, Massage, Sauna, Currency Exchange, Wake-up Service, Hairdryers Available, Heated Guest Rooms, Parking, Jacuzzi, Pool, Multilingual, News Stand, Car Rental Desk, Boutiques, Drugstore, Florist, Casino, Game Room, Connecting Rooms, Toilet, Doctor on Call, Phone Service, Terrace, Radio, Bathrobes, Television with Cable, TV, Fire Place, High speed internet access, Private Bathroom, Safe, Sofa Bed, Temperature Control, AM/FM Alarm Clock, Golf, Tennis, Shops/Commercial Services, FAX, Telephone, Voicemail, Breakfast Buffet, Meal Plan - MAP/Half-board, City Center.
    - amenity_freBabysitting / Services à l'enfance, salon, concierge, restaurant, service en chambre, coffre-fort, salle de gym ou de Spa, blanchisserie / services, activités pour enfants, animaux domestiques admis, Conciergerie, Petit déjeuner Continental, ascenseurs, service de copie, massage, sauna, Monnaie Bourse, service de réveil, sèche-cheveux disponibles, chambres d'hôtes chauffée, parking, jacuzzi, piscine, multilingue, stand Nouvelles, Location de voitures, des boutiques, Pharmacie, Fleuriste, casino, salle de jeux, chambres communicantes, toilettes, docteur à l'appel, Téléphone services: service, terrasse, Radio, peignoirs, télévision avec câble, TV, cheminée, accès internet haut débit, Salle de bain privée, coffre-fort, canapé lit, contrôle de température, réveil AM / FM, Golf, Tennis, Boutiques / Commerces, FAX, Téléphone, messagerie vocale, petit déjeuner buffet, Repas - MAP / Demi-pension, Centre Ville.
    - lowest_rate0.00
    - lr_currency
    - lr_people0
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localeeng
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id1088
    - country_idAT
    - state_id(null)
    - maintrack_idBERWANG
    - nameBerwang
    - main_key
  - Country
    - idAT
    - nameAustria
    - name_freAutriche
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id17086
      - hotel_id1171
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/28/266/986/H249TL0B_J.jpg
      - ratio_hw0.58
      - on_wall0
    - 1
      - id17087
      - hotel_id1171
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/28/266/954/WB1145354_Ext1_J.jpg
      - ratio_hw0.58
      - on_wall0
    - 2
      - id17088
      - hotel_id1171
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/28/266/962/H249TL09_J.jpg
      - ratio_hw0.58
      - on_wall0
    - 3
      - id17089
      - hotel_id1171
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/28/266/966/H249TL05_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 4
      - id17090
      - hotel_id1171
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/28/266/970/H249TL04_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 5
      - id17091
      - hotel_id1171
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/28/266/982/H249TL0A_J.jpg
      - ratio_hw0.58
      - on_wall0
  - Room
    - 0
      - id4591
      - typeOTH
      - hotel_id1171
      - nameLoreakopf Room Salon
      - descriptionLoreakopf Suite-Living Area-Fireplace-Mtn View-Bay Window-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
    - 1
      - id4592
      - typeOTH
      - hotel_id1171
      - nameSonnberg Queen Bed Balcony
      - descriptionSingle Sonnberg-Queen-Balcony-South Facing- Bathtub or Shower-WC-Telephone-TV
      - 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
      - id4593
      - typeOTH
      - hotel_id1171
      - nameAbendspitze King Bed Balcony
      - descriptionDeluxe Room-King-Seating Area-Balcony-Bathtub-WC-Phone-TV-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
    - 3
      - id4594
      - typeOTH
      - hotel_id1171
      - nameGartnerwand King Mountain View
      - 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
      - id1977
      - localeeng
      - modelHotel
      - foreign_key1171
      - fieldtagline
      - content
    - 1
      - id1978
      - localefre
      - modelHotel
      - foreign_key1171
      - fieldtagline
      - content
  - Envie
    - 0
      - id2
      - created2011-05-17 19:21:27
      - modified2011-09-15 08:04:03
    - 1
      - id9
      - created2011-05-17 19:26:00
      - modified2011-05-17 19:26:00
    - 2
      - id15
      - created2011-05-17 19:27:34
      - modified2011-05-17 19:27:34
    - 3
      - id16
      - created2011-05-17 19:27:50
      - modified2011-09-01 11:30:41
    - 4
      - id18
      - created2011-05-17 19:28:28
      - modified2011-05-17 19:28:28
    - 5
      - id19
      - created2011-05-24 08:21:45
      - modified2011-05-24 08:21:45
    - 6
      - id23
      - created2011-05-24 08:28:10
      - modified2011-05-24 08:28:10
pageTitleBoutique hotels worldwide
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

====

Find an experience

Let us guide you

Find a boutique hotel

Search by desire

By country

Boutique hotels worldwide

1 results match your query

Austria, Berwang

Singer Sporthotel and Spa

Search by desire

Globe Secret's guarantees

A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL

BOOKING AT NO ADDITIONAL COST

UNIQUE SELECTION CRITERIA

MORE TAILORED SERVICES

default

Query Explain:

Memory

Timers

Find an experience

Let us guide you

Find a boutique hotel

Search by desire

By country

Boutique hotels worldwide

1 results match your query

Austria, Berwang

Singer Sporthotel and Spa

Search by desire

Globe Secret's guarantees

A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL

BOOKING AT NO ADDITIONAL COST

UNIQUE SELECTION CRITERIA

MORE TAILORED SERVICES

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables