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 `i18n`	6	6	0
SHOW FULL COLUMNS FROM `home_hotels`	4	4	0
SHOW FULL COLUMNS FROM `hotel_images`	6	6	0
SHOW FULL COLUMNS FROM `rooms`	15	15	0
SHOW FULL COLUMNS FROM `rooms_rates`	8	8	0
SHOW FULL COLUMNS FROM `rates_periods`	6	6	0
SHOW FULL COLUMNS FROM `rates_period_i18n`	6	6	0
SHOW FULL COLUMNS FROM `unavailabilities`	4	4	0
SHOW FULL COLUMNS FROM `envies`	3	3	0
SHOW FULL COLUMNS FROM `envie_i18n`	6	6	0
SHOW FULL COLUMNS FROM `envies_hotels`	2	2	0
SHOW FULL COLUMNS FROM `comments`	19	19	0
SHOW FULL COLUMNS FROM `users`	16	16	0
SHOW FULL COLUMNS FROM `addresses`	12	12	0
SHOW FULL COLUMNS FROM `janrain_profiles`	9	9	0
SHOW FULL COLUMNS FROM `admins`	15	15	0
SHOW FULL COLUMNS FROM `favorites`	8	8	0
SHOW FULL COLUMNS FROM `hotel_i18n`	6	6	0
SHOW FULL COLUMNS FROM `configs`	3	3	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';	1	1	0
SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'eng') WHERE 1 = 1	1	1	0
SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1)	2	2	0
SELECT 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`.`country_id` = 'MG' 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`.`country_id` = 'MG' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20	3	3	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 (180, 765, 1367)	46	46	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 (180, 765, 1367)	6	6	1	maybe slow
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (180, 765, 1367)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (180, 765, 1367)	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 (180, 765, 1367)	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 (180, 765, 1367)	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 (180, 765, 1367)	6	6	0
SELECT `Envie`.`id`, `Envie`.`created`, `Envie`.`modified`, `EnviesHotel`.`envie_id`, `EnviesHotel`.`hotel_id` FROM `envies` AS `Envie` JOIN `envies_hotels` AS `EnviesHotel` ON (`EnviesHotel`.`hotel_id` IN (180, 765, 1367) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	16	16	1	maybe slow
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'MG' 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` = '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.31 MB
Controller action start	14.48 MB
Controller render start	15.32 MB
View render complete	19.10 MB

Message	Time in ms	Graph
Core Processing (Derived)	72.68
Component initialization and startup	3.91
Controller action	39.41
Render Controller Action	79.64
» Rendering View	78.29
» » Rendering APP/views/hotels/index.ctp	24.03
» » » Rendering APP/views/elements/hotels/item.ctp	1.15
» » » Rendering APP/views/elements/hotels/item.ctp #2	1.23
» » » Rendering APP/views/elements/hotels/item.ctp #3	1.24
» » » Rendering APP/views/elements/paging.ctp	0.11
» » Rendering APP/views/layouts/default.ctp	54.08
» » » Rendering APP/views/elements/google_analytics.ctp	0.08
» » » Rendering APP/views/elements/layout/top.ctp	1.55
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0.31
» » » Rendering APP/views/elements/layout/header.ctp	46.99
» » » Rendering APP/views/elements/layout/extra.ctp	0.12
» » » Rendering APP/views/elements/layout/footer.ctp	4.37
» » » » 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)
country
- Country
  - idMG
  - nameMadagascar
  - name_freMadagascar
hotels
- 0
  - Hotel
    - id180
    - starred0
    - in0
    - maintrack_hotel_id328615
    - brand_codeWB
    - nameAnjajavy L Hotel
    - addressAnjajavy Road Longitude 47 East Latitude 15 South
    - zip_code00000
    - cityarea_id(null)
    - city_id162
    - region_id(null)
    - state_id(null)
    - country_idMG
    - latitude-15.03205
    - longitude47.22522
    - zoom13
    - rating0
    - phone261 762 750676
    - reservation_phone(null)
    - fax261 600 170535
    - emailanjajavy@relaischateaux.com
    - created2011-05-13 21:07:26
    - modified2012-01-10 18:17:29
    - descriptionLemurs, chameleons, tortoises, humming birds, medicinal plants, cocoa, vanilla, ylang ylang, cloves, papyrus, carnivorous plants. Madagascar is one of the last remaining unspoilt oases on the planet, with its virgin forests, savannas, lazy bays and its tiny islands at the end of the world. It boasts a nature so rich and abundant that the famous Parisian landscape architect Camille Muller decided to gather the rarest of species in The Oasis, the hotels landscaped garden. Nestled in a nature reserve of 400 hectares, Anjajavy Hotel consists of a beautiful ensemble of rosewood villas scattered over a long fine sandy beach and the Mozambique Channel. By walking along designated pathways or boat, you can explore deserted creeks, little fishing villages and the Tsingys, coral remains sculpted by erosion with overlapping baobab roots. Pure serenity in a land of emotions.
    - description_freLémuriens, caméléons, tortues, colibris, plantes médicinales, cacao, vanille, ylang ylang, clous de girofle, papyrus, carnivores. Madagascar est l'une des dernières oasis préservée restant sur la planète avec ses forêts vierges, sa savane, ses paresseux et ses îles minuscules du bout du monde. Elle bénéficie d'une nature si riche et si abondante que le célèbre architecte paysagiste parisien Camille Muller a décidé de rassembler les plus rares des espèces dans une Oasis, un hôtel jardin paysager. Niché dans une réserve naturelle de 400 hectares, l'Anjajavy Hôtel se compose d'un bel ensemble de villas en palissandre dispersés sur une longue plage de sable fin et le canal du Mozambique. En marchant le long des sentiers ou en bateau, vous pourrez découvrir des villages de pêcheurs et des petites criques et les Tsingy de corail sculptés par l'érosion qui se chevauchent avec les racines de baobab. Une pure sérénité dans une terre d'émotions.
    - amenityBabysitting/Child Services, Lounge, Handicapped Rooms/Facilities, Room Service, Laundry/Valet Services, Wake-up Service, Massage, Maid Service, Phone Service, Telephone, Air Conditioned, Mini Bar, Safe, Bathrobes, Bidet, Coffee Maker in Room, Desk with lamp, Hairdryers Available, High speed internet access, Wireless Internet Access, Ceiling Fan, Temperature Control, Beach, Boating, Pool, Snorkeling, Fishing, Childrens Activities, Meal Plan - FAP/Full-board.
    - amenity_freGarde d'enfants, salon, chambres / équipements pour handicapés, service en chambre, blanchisserie, service de réveil, massage, Service d'entretien ménager, service de téléphone, téléphone, air conditionné, mini bar, coffre, peignoirs, Bidet, Cafetière dans Chambre, bureau avec lampe, sèche-cheveux disponibles, l'accès Internet à haute vitesse, accès Internet sans fil, ventilateur au plafond, Contrôle de la température, la plage, nautique, piscine, plongée en apnée, pêche, activités pour enfants, Repas - FAP / Pension complète.
    - 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
    - id162
    - country_idMG
    - state_id(null)
    - maintrack_idANJAJAVYVILLAGE
    - nameAnjajavy Village
    - main_key
  - Country
    - idMG
    - nameMadagascar
    - name_freMadagascar
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id8688
      - hotel_id180
      - order9
      - urianjajavy0390.JPG
      - ratio_hw0.67
      - on_wall0
    - 1
      - id8689
      - hotel_id180
      - order10
      - urianjajavy0500.jpg
      - ratio_hw0.67
      - on_wall0
    - 2
      - id8686
      - hotel_id180
      - order7
      - urianjajavy0260.jpg
      - ratio_hw0.66
      - on_wall0
    - 3
      - id8687
      - hotel_id180
      - order8
      - urianjajavy0380.JPG
      - ratio_hw0.66
      - on_wall0
    - 4
      - id8683
      - hotel_id180
      - order4
      - urianjajavy0180.JPG
      - ratio_hw0.66
      - on_wall0
    - 5
      - id8684
      - hotel_id180
      - order5
      - urianjajavy0190.jpg
      - ratio_hw0.67
      - on_wall0
    - 6
      - id8685
      - hotel_id180
      - order6
      - urianjajavy0240.JPG
      - ratio_hw0.65
      - on_wall0
    - 7
      - id8681
      - hotel_id180
      - order2
      - urianjajavy0100.jpg
      - ratio_hw1.50
      - on_wall0
    - 8
      - id8682
      - hotel_id180
      - order3
      - urianjajavy0140.jpg
      - ratio_hw0.66
      - on_wall0
    - 9
      - id8680
      - hotel_id180
      - order1
      - urianjajavy0030.jpg
      - ratio_hw0.67
      - on_wall0
  - Room
    - 0
      - id773
      - typeOTH
      - hotel_id180
      - nameVilla Sea 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
      - id25
      - localeeng
      - modelHotel
      - foreign_key180
      - fieldtagline
      - content
    - 1
      - id26
      - localefre
      - modelHotel
      - foreign_key180
      - fieldtagline
      - content
  - Envie
    - 0
      - id5
      - created2011-05-17 19:24:26
      - modified2011-05-17 19:24:26
    - 1
      - id7
      - created2011-05-17 19:24:56
      - modified2011-05-17 19:24:56
    - 2
      - id15
      - created2011-05-17 19:27:34
      - modified2011-05-17 19:27:34
    - 3
      - id18
      - created2011-05-17 19:28:28
      - modified2011-05-17 19:28:28
    - 4
      - id19
      - created2011-05-24 08:21:45
      - modified2011-05-24 08:21:45
    - 5
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
- 1
  - Hotel
    - id765
    - starred0
    - in0
    - maintrack_hotel_id501233
    - brand_codeON
    - namePrincesse Bora Lodge & Spa
    - addressRavoraha
    - zip_code515
    - cityarea_id(null)
    - city_id743
    - region_id(null)
    - state_id(null)
    - country_idMG
    - latitude-17.084351
    - longitude49.81673
    - zoom13
    - rating0
    - phone261 205704003
    - reservation_phone(null)
    - fax(null)
    - emailinfo@princessebora.com
    - created2011-08-01 17:44:47
    - modified2011-08-01 17:44:47
    - descriptionBe at the end of the world? Far, very far from mass tourism.The PRINCESSE BORA LODGE & SPA is a marvellous hotel located in one of the world?s last authentic and preserved places: Sainte-Marie Island.In this eco-friendly hotel the real luxury lies in its unique private villas and surroundings: the large palm tree grove and its tropical plants, the magic view on the lagoon, the noble materials used in each villa, the jungle Spa.The beach, situated in front of the hotel, is several kilometres long and goes until the southern point of Sainte-Marie Island and another smaller island: Île aux Nattes.The wooden pontoon, which overlooks the lagoon, is the ideal starting point for your nautical activities: snorkelling, scuba diving, kayak, water-skiing, wakeboard, etc.Excellent service and restaurant.
    - description_freÊtre au bout du monde? Loin, très loin du tourisme de masse.Le PRINCESSE BORA LODGE & SPA est un merveilleux hôtel situé dans un des derniers endroits authentiques et préservés de cette planète: l?Île Sainte-Marie.Dans ce Lodge éco-touristique, le vrai luxe réside dans ses belles villas intégrées dans un environnement unique: la vaste cocoteraie et ses plantes tropicales, la vue magique sur le lagon, les matériaux nobles utilisés dans chaque villa, son jungle Spa? Un service attentionné et son excellent restaurant en font un lieux miraculeux posé hors de la course du temps. La plage, située devant l?hôtel, s?étend sur plusieurs kilomètres jusqu?à la pointe Sud de l?Île Sainte-Marie et l?Île aux Nattes.Le ponton en bois, qui se trouve en bordure de lagon, est le point de départ idéal pour vos différentes activités nautiques: snorkeling, plongée sous-marine, kayak, ski nautique
    - amenity24 Hour Front Desk, 24 Hour Security, Air Conditioned, Airline Desk, Picnic Area/Tables, Car Rental Desk, Currency Exchange, Free Parking, Barber Shop, Outdoor Parking, Parking, Copy Service, Pool, Restaurant, Safe Deposit Box, Sauna, Solarium, Fitness Center or Spa, Tour Desk, Valet Parking, Wake-up Service, Multilingual, Porters, Barber/Beauty Shop, Lounge, Turndown Service, Pets Allowed, AM/FM Alarm Clock, Terrace, Hairdryers Available, Safe, Telephone, WC, Shower, Cribs Available, Sitting Area, Bathrobes, Bath Tub, Jacuzzi, Mini Bar, Refrigerator, Sofa Bed, Beach, Boating, Fishing, Horseback Riding, Jogging Track, Sailing, Scuba Diving, Snorkeling, Water Skiing, Childrens Activities, Night Club, Internet Access, Audio Visual Equipment, Meeting/Banquet Facilities, Continental Breakfast, Meal Plan - MAP/Half-board,
    - amenity_freRéception ouverte 24h/24, Service de sécurité permanent, Climatisation, Guichet de la compagnie aérienne, Aires/tables de pique-nique, Guichet de location de voitures, Bureau de change, Parking gratuit, Salon de coiffure, Parking en plein air, Parking, Service de photocopie, Piscine, Restaurant, Coffre-fort à la réception, Sauna, Solarium, Centre de santé ou station thermale, Agence de voyage, Service de garage des voitures, Service de réveil, Multilingue, Porteurs, Salon de coiffure/beauté, Salon, Préparation des lits, Animaux acceptés, Radio-réveil AM/FM, Terrasse, Sèches-cheveux, Coffre-fort dans la chambre, Téléphone, WC, Douche, Berceaux disponibles, Salon, null, Baignoire, Jacuzzi, Mini-bar, Réfrigérateur, Canapé-lit, Plage, Excursions en bateau, Pêche, Equitation, Piste de jogging, null, Plongée sous-marine, null, Ski nautique, null, Boîte de nuit, null, Equipement audiovisuel, Salles de réunions/banquets, Petit déjeuner continental, Demi-pension (DP),
    - lowest_rate130.00
    - lr_currencyEUR
    - lr_people2
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localeeng
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id743
    - country_idMG
    - state_id(null)
    - maintrack_idILESAINTEMARIE
    - nameIle Sainte-Marie
    - main_key
  - Country
    - idMG
    - nameMadagascar
    - name_freMadagascar
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id12136
      - hotel_id765
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/111/ON1223387_Ext1_j_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 1
      - id12137
      - hotel_id765
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/115/ON1223387_Lobb1_j_J.jpg
      - ratio_hw0.99
      - on_wall0
    - 2
      - id12138
      - hotel_id765
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/119/ON1223387_Logo1_j_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 3
      - id12139
      - hotel_id765
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/123/ON1223387_Lounge1_j_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 4
      - id12140
      - hotel_id765
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/127/ON1223387_Map1_j_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 5
      - id12141
      - hotel_id765
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/131/ON1223387_Meet1_j_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 6
      - id12142
      - hotel_id765
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/135/ON1223387_Msc1_j_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 7
      - id12143
      - hotel_id765
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/139/ON1223387_Pool1_j_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 8
      - id12144
      - hotel_id765
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/143/ON1223387_Rec1_j_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 9
      - id12145
      - hotel_id765
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/28/52/147/ON1223387_Rest1_j_J.jpg
      - ratio_hw0.66
      - on_wall0
  - Room
    - 0
      - id3116
      - typeOTH
      - hotel_id765
      - nameConfort Villa
      - descriptionPrivate villa. 1 Queen size bed, terrace, bathroom with shower, separate closets, safe, and fan. No twin or additional bed available for children. Surface : 35 m2.
      - 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
      - id3117
      - typeOTH
      - hotel_id765
      - nameLuxury Villa
      - descriptionPrivate Villa with sea view. 1 Queen size bed, 2 single beds in a mezzanine for 2 children only (12 years maximum), terrace, bathroom with shower, separate closets, safe, and air conditioning. Surface : 55 m2.
      - 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
      - id3118
      - typeOTH
      - hotel_id765
      - nameExecutive Beach Villa
      - 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
      - id1173
      - localeeng
      - modelHotel
      - foreign_key765
      - fieldtagline
      - content
    - 1
      - id1174
      - localefre
      - modelHotel
      - foreign_key765
      - fieldtagline
      - content
  - Envie(empty)
- 2
  - Hotel
    - id1367
    - starred0
    - in0
    - maintrack_hotel_id(null)
    - brand_code
    - nameTsara Komba Lodge
    - addressBP 440
    - zip_code0000
    - cityarea_id(null)
    - city_id1302
    - region_id(null)
    - state_id(null)
    - country_idMG
    - latitude-13.4939436168866
    - longitude48.3380780179077
    - zoom13
    - rating0
    - phone(null)
    - reservation_phone(null)
    - fax(null)
    - email(null)
    - created2011-12-13 12:06:55
    - modified2011-12-13 12:46:02
    - descriptionThe Tsara Komba Lodge is located on Nosy Komba island, "the islands of lemurs", the most beautiful islands in the archipelago of Nosy Be, north-west of Madagascar and 30 minutes by boat from Nosy Be. At the heart of a fabulous biodiversity, Tsara Komba Lodge is a haven of peace and beauty where travels are on foot or by canoe. Nosy Komba is an extinct volcano covered with a lush forest .... Tsara Komba Lodge is embedded in the heart of a tropical botanical garden The Eden Garden and backed by a private nature reserve where lemurs bloom, butterflies, eagles, humming birds, chameleons, lizards ... many endemic species, plant or animal of fruit trees, fragrant plants, colorful and fragrant flowers that contribute to the extraordinary beauty of the place. An organic vegetable garden of about 300 m2 also a daily harvest of vegetables and herbs. The Baobab Nursery, who watches over the growth of babies and Pachypodium Baobabs, is also part of this eco-paradise preserved, while a sandy beach bordered by a cobalt blue water lies at the foot of translucent lodges. The hotel is composed of eight lodges and a main lodge The Divine House which houses the restaurant, bar and lounges, terraces. All lodges have a beautiful terrace with sofas, armchairs and coffee table, overlooking the beach, the bay and offers breathtaking views of beauty. Each lodge is isolated from the others by the extraordinary vegetation that provides privacy for guests. The table Tsara Komba Lodge is one of the most famous of Madagascar. The Slow Food-inspired cuisine, is a special place to fish and fresh local produce by mixing spices, perfumes and flavors of the East and West. The French chef is a true artisan flavors, which also grows its own organic vegetable garden which are harvested every day of vegetables, herbs and spices. The Tsara Komba offers luxury Kind: maintaining a balance between environment, economy and society in a spirit and with behaviors resolutely turned to Ecology. Specifically, Tsara Komba respects and protects the environment for today and tomorrow, everyone can enjoy the unique biodiversity of this region.
    - description_freLe Tsara Komba Lodge est situé sur l'île aux lémuriens, Nosy Komba, la plus belle des îles de l’Archipel de Nosy Be, au nord ouest de Madagascar et à 30 mn en bateau de Nosy Be. Au cœur d’une fabuleuse biodiversité, le Tsara Komba Lodge est un véritable havre de beauté et de sérénité où l’on ne circule qu’à pied ou en pirogue. Nosy Komba est un ancien volcan recouvert d’une forêt luxuriante…. Tsara Komba Lodge est noyé au cœur d’un jardin botanique tropical The Eden Garden et adossé à une Réserve Naturelle Privée où s’épanouissent lémuriens, papillons, aigles pêcheurs, colibris, caméléons, petits lézards… de nombreuses espèces endémiques, végétales ou animales, des arbres fruitiers, des plantes à parfum, des fleurs multicolores et parfumées qui contribuent à l’extraordinaire beauté des lieux. Un potager bio de près de 300 m2 permet également une récolte quotidienne de légumes et d’aromates. La Baobab Nursery, qui veille sur la croissance de bébés Baobabs et Pachypodiums, fait également partie de cet éco-paradis préservé, tandis qu’une plage de sable fin bordée d’une eau d’un bleu cobalt translucide s’étend au pied des lodges. L’hôtel est composé de 8 lodges et d’un lodge principal The Divine House qui accueille le restaurant, le bar et les salons-terrasses. Tous les lodges disposent d’une magnifique terrasse avec canapés, fauteuils et table basse, surplombant la plage, la baie et offre une vue époustouflante de beauté. Chaque lodge est isolé des autres par l’extraordinaire végétation qui préserve l’intimité des hôtes. La table du Tsara Komba Lodge est l’une des plus réputée de Madagascar. La gastronomie d’inspiration Slow Food, fait une place de choix aux poissons et aux produits frais locaux en mêlant épices, parfums et saveurs de l’Orient et de l’Occident. Le Chef français est un véritable artisan des saveurs, qui cultive également son propre potager bio d’où sont récoltés chaque jour des légumes, des herbes et des aromates. Le Tsara Komba offre un luxe Bienveillant: en maintenant un équilibre harmonieux entre l’environnement, l’économie et le social, dans un esprit et avec des comportements résolument tournés vers l’Ecologie. Concrètement, Tsara Komba respecte et protège l’environnement afin qu’aujourd’hui et demain, chacun puisse profiter de la biodiversité exceptionnelle de cette région.
    - amenityTransfers, guides, room service, laundry service, car and boat rental, diving equipment, games, books, fishing, trekking, baby sitting, internet access, mobile phone, bar, lounges, restaurant, gardens and beach.
    - amenity_freTransferts, guides, room service, service de blanchisserie, location de bateau et véhicule, matériel de plongée, jeux de société, livres, pêche, trekking, baby sitting, accès internet, téléphone portable, bar, salons, restaurant, jardins, plage.
    - lowest_rate225.00
    - lr_currencyEUR
    - lr_people2
    - comment_count0
    - cancellation_policyRates are valid from 01/09/12 to 01/08/13 inclusive and are in Euros, per night, per person, breakfast, lunch, dinner included. The rates / night do not include: airfare, beverages, drinks at the bar, additional meals or à la carte, transfers, tax (0.40 € / night / lodge), excursions, fees and VISA card of transfers. Rates per person for extra beds (in the lodges): Child - 4 years: free Child - 12 years: 125 € Adult: € 165 Transfers (mandatory with Tsara Komba Lodge) per person per trip: Taxi & boat (airport / Hellville / Tsara Komba): 57 € Boat (Hellville / Tsara Komba): 50 € Boat (Ankify / Tsara Komba): 40 € Children "under 12: € 25 The stay is minimum of 3 nights and 4 or 5 nights at different times. Payment Terms apply to all types of holidays: 25% deposit on confirmation, balance 30 days before arrival. Cancellation Terms before arrival and no show: Cancellation fees: 25% deposit on confirmation: Non-refundable. 29 to 15 days before arrival: 50% of the total of booking - 15 days before arrival: 100% of the total booking. After arrival and early departure: 100% of remaining nights.
    - cancellation_policy_freLes tarifs sont valables du 09/01/12 au 08/01/13 inclus et sont exprimés en Euros, par nuitée, par personne, petit-déjeuner, déjeuner, dîner inclus. Les tarifs/nuitée ne comprennent pas: billets d'avion, boissons, consommations au bar, repas supplémentaires ou choix à la carte, transferts, taxe de séjour (0,40€/nuitée/lodge), excursions, frais de carte VISA et de virements. Tarifs des lits supplémentaires par personne (dans les lodges): Enfant de - 4 ans: gratuit Enfant - 12 ans: 125 € Adulte: 165 € Transferts (obligatoires avec Tsara Komba Lodge) par personne et par trajet: Taxi & bateau (aéroport/Hellville/Tsara Komba): 57 € Bateau (Hellville/Tsara Komba): 50 € Bateau (Ankify/Tsara Komba): 40 € Enfants"-12 ans: 25 € Les séjours sont de 3 nuits minimum et 4 ou 5 nuits selon les périodes. Conditions de paiement valables pour tout type de séjours : 25% d'acompte à la confirmation, solde 30 jours avant le début du séjour. Conditions d'annulation avant date d'arrivée et no show : Frais d'annulation : Acompte de 25% à la confirmation : Non remboursable. De 29 à 15 jours avant date d'arrivée : 50% du montant total de la réservation, - de 15 jours avant date d'arrivée : 100% du montant total de la réservation. Après date d'arrivée et départ prématuré : 100% des nuits restantes.
    - published1
    - localeeng
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id1302
    - country_idMG
    - state_id(null)
    - maintrack_id(null)
    - nameNosy Be
    - main_key(null)
  - Country
    - idMG
    - nameMadagascar
    - name_freMadagascar
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id19924
      - hotel_id1367
      - order25
      - uri2809116092520.jpg
      - ratio_hw0.67
      - on_wall0
    - 1
      - id19925
      - hotel_id1367
      - order26
      - uri2909116619410.jpg
      - ratio_hw0.67
      - on_wall0
    - 2
      - id19923
      - hotel_id1367
      - order24
      - uri2909116880910.jpg
      - ratio_hw0.67
      - on_wall0
    - 3
      - id19921
      - hotel_id1367
      - order22
      - uri290911931481.jpg
      - ratio_hw0.67
      - on_wall0
    - 4
      - id19922
      - hotel_id1367
      - order23
      - uri2809111471300.jpg
      - ratio_hw0.67
      - on_wall0
    - 5
      - id19920
      - hotel_id1367
      - order21
      - uri2909116820530.jpg
      - ratio_hw0.67
      - on_wall0
    - 6
      - id19918
      - hotel_id1367
      - order19
      - uri2909111544790.jpg
      - ratio_hw0.67
      - on_wall0
    - 7
      - id19919
      - hotel_id1367
      - order20
      - uri2909119737370.jpg
      - ratio_hw0.67
      - on_wall0
    - 8
      - id19916
      - hotel_id1367
      - order17
      - uri2909112375330.jpg
      - ratio_hw0.67
      - on_wall0
    - 9
      - id19917
      - hotel_id1367
      - order18
      - uri2909112812500.jpg
      - ratio_hw0.67
      - on_wall0
    - 10
      - id19915
      - hotel_id1367
      - order16
      - uri2909118652600.jpg
      - ratio_hw0.67
      - on_wall0
    - 11
      - id19913
      - hotel_id1367
      - order14
      - uri2909119638920.jpg
      - ratio_hw0.67
      - on_wall0
    - 12
      - id19914
      - hotel_id1367
      - order15
      - uri2909115741500.jpg
      - ratio_hw0.67
      - on_wall0
    - 13
      - id19912
      - hotel_id1367
      - order13
      - uri290911167100.jpg
      - ratio_hw0.67
      - on_wall0
    - 14
      - id19910
      - hotel_id1367
      - order11
      - uri2909115420990.jpg
      - ratio_hw0.67
      - on_wall0
    - 15
      - id19911
      - hotel_id1367
      - order12
      - uri2909115942820.jpg
      - ratio_hw0.67
      - on_wall0
    - 16
      - id19909
      - hotel_id1367
      - order10
      - uri2809111557280.jpg
      - ratio_hw0.67
      - on_wall0
    - 17
      - id19907
      - hotel_id1367
      - order8
      - uri2909117527970.jpg
      - ratio_hw0.67
      - on_wall0
    - 18
      - id19908
      - hotel_id1367
      - order9
      - uri2909116224070.jpg
      - ratio_hw0.67
      - on_wall0
    - 19
      - id19905
      - hotel_id1367
      - order6
      - uri2909113057000.jpg
      - ratio_hw0.67
      - on_wall0
    - 20
      - id19906
      - hotel_id1367
      - order7
      - uri2909118959840.jpg
      - ratio_hw0.67
      - on_wall0
    - 21
      - id19903
      - hotel_id1367
      - order4
      - uri290911931480.jpg
      - ratio_hw0.67
      - on_wall0
    - 22
      - id19904
      - hotel_id1367
      - order5
      - uri2909114438620.jpg
      - ratio_hw0.67
      - on_wall0
    - 23
      - id19902
      - hotel_id1367
      - order3
      - uri2809117391450.jpg
      - ratio_hw0.67
      - on_wall0
    - 24
      - id19900
      - hotel_id1367
      - order1
      - uri2909115008480.jpg
      - ratio_hw0.67
      - on_wall0
    - 25
      - id19901
      - hotel_id1367
      - order2
      - uri290911386290.jpg
      - ratio_hw0.67
      - on_wall0
  - Room
    - 0
      - id5349
      - type
      - hotel_id1367
      - nameLODGE OCEAN
      - description
      - name_freLODGE OCEAN
      - description_fre
      - lowest_rate225.00
      - lr_currencyEUR
      - lr_people2
      - breakfast_included0
      - half_board0
      - all_inclusive0
      - full_board1
      - accomodation_only0
    - 1
      - id5350
      - type
      - hotel_id1367
      - nameLODGE SUITE OCEAN VIEW
      - description
      - name_freSUITE LODGE VUE OCEAN
      - description_fre
      - lowest_rate250.00
      - lr_currencyEUR
      - lr_people2
      - breakfast_included0
      - half_board0
      - all_inclusive0
      - full_board1
      - accomodation_only0
  - RatesPeriod(empty)
  - Unavailability(empty)
  - Comment(empty)
  - Favorite(empty)
  - Taglines
    - 0
      - id2339
      - localeeng
      - modelHotel
      - foreign_key1367
      - fieldtagline
      - content
    - 1
      - id2340
      - localefre
      - modelHotel
      - foreign_key1367
      - fieldtagline
      - content
  - Envie
    - 0
      - id1
      - created2011-05-17 19:21:13
      - modified2011-05-17 19:21:13
    - 1
      - id2
      - created2011-05-17 19:21:27
      - modified2011-09-15 08:04:03
    - 2
      - id3
      - created2011-05-17 19:21:37
      - modified2011-05-17 19:21:37
    - 3
      - id5
      - created2011-05-17 19:24:26
      - modified2011-05-17 19:24:26
    - 4
      - id7
      - created2011-05-17 19:24:56
      - modified2011-05-17 19:24:56
    - 5
      - id10
      - created2011-05-17 19:26:16
      - modified2011-05-17 19:26:16
    - 6
      - id12
      - created2011-05-17 19:26:48
      - modified2011-05-17 19:26:48
    - 7
      - id18
      - created2011-05-17 19:28:28
      - modified2011-05-17 19:28:28
    - 8
      - id19
      - created2011-05-24 08:21:45
      - modified2011-05-24 08:21:45
    - 9
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
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

3 results match your query

Madagascar, Anjajavy Village

Anjajavy L Hotel

Madagascar, Ile Sainte-Marie

Princesse Bora Lodge & Spa

Madagascar, Nosy Be

Tsara Komba Lodge

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

3 results match your query

Madagascar, Anjajavy Village

Anjajavy L Hotel

Madagascar, Ile Sainte-Marie

Princesse Bora Lodge & Spa

Madagascar, Nosy Be

Tsara Komba Lodge

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