Hôtels de charme à travers le monde

Globe Secret est né de l'association de professionnels du tourisme, de l’hotellerie et du e-commerce. Les équipes de Globe Secret garantissent à ses utilisateurs une sélection rigoureuse d'hôtels de charme. Immatriculation d'agent de voyages n° IM075100403 - Garantie Financière : BPRP - Membre de l' APST - RCP : Hiscox n° HA PRC0055186 - CNIL 1517931. SSL, AmericanExpress, MasterCard, Visa, VisaElectron

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

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

Message	Time in ms	Graph
Core Processing (Derived)	92,58
Component initialization and startup	7,55
Controller action	56,67
Render Controller Action	84,15
» Rendering View	82,04
» » Rendering APP/views/hotels/index.ctp	30,17
» » » Rendering APP/views/elements/hotels/item.ctp	1,15
» » » Rendering APP/views/elements/hotels/item.ctp #2	1,10
» » » Rendering APP/views/elements/hotels/item.ctp #3	1,12
» » » Rendering APP/views/elements/hotels/item.ctp #4	1,05
» » » Rendering APP/views/elements/hotels/item.ctp #5	1,10
» » » Rendering APP/views/elements/paging.ctp	0,12
» » Rendering APP/views/layouts/default.ctp	51,64
» » » Rendering APP/views/elements/google_analytics.ctp	0,09
» » » Rendering APP/views/elements/layout/top.ctp	1,56
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0,30
» » » Rendering APP/views/elements/layout/header.ctp	44,84
» » » Rendering APP/views/elements/layout/extra.ctp	0,12
» » » Rendering APP/views/elements/layout/footer.ctp	4,00
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0,31
» » » Rendering APP/views/elements/layout/footnotes.ctp	0,09

+ –

View Variables

promises_for_layout
- 0
 - Promise
 - id1
 - title Des hôtels de charme a taille humaine
 - content Globe Secret se distingue par l’originalité de sa sélection d’hôtels de charme. Ces quelques 1200 adresses autour du monde ont pour trait commun l’intimité (maximum 30 chambres) et un cadre préservé. Inclassables, ces adresses sont ancrées dans la culture de leur pays, revendiquant une authenticité et un accueil personnalisé. Avec Globe Secret, vous n’êtes pas prêts d’oublier vos vacances…             <meta charset="utf-8" /> 
 - localefre
 - Titles
 - 0
 - id10143
 - localeeng
 - modelPromise
 - foreign_key1
 - fieldtitle
 - content A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 - 1
 - id10144
 - localefre
 - modelPromise
 - foreign_key1
 - fieldtitle
 - content Des hôtels de charme a taille humaine
 - Contents
 - 0
 - id10145
 - localeeng
 - modelPromise
 - foreign_key1
 - fieldcontent
 - content
 - 1
 - id10146
 - localefre
 - modelPromise
 - foreign_key1
 - fieldcontent
 - content Globe Secret se distingue par l’originalité de sa sélection d’hôtels de charme. Ces quelques 1200 adresses autour du monde ont pour trait commun l’intimité (maximum 30 chambres) et un cadre préservé. Inclassables, ces adresses sont ancrées dans la culture de leur pays, revendiquant une authenticité et un accueil personnalisé. Avec Globe Secret, vous n’êtes pas prêts d’oublier vos vacances…             <meta charset="utf-8" /> 
- 1
 - Promise
 - id2
 - title RESERVATION SANS FRAIS
 - content Globe Secret garantie une transparence de prix et de réservation. En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.
 - localefre
 - Titles
 - 0
 - id10147
 - localeeng
 - modelPromise
 - foreign_key2
 - fieldtitle
 - content BOOKING AT NO ADDITIONAL COST
 - 1
 - id10148
 - localefre
 - modelPromise
 - foreign_key2
 - fieldtitle
 - content RESERVATION SANS FRAIS
 - Contents
 - 0
 - id10149
 - localeeng
 - modelPromise
 - foreign_key2
 - fieldcontent
 - content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 - 1
 - id10150
 - localefre
 - modelPromise
 - foreign_key2
 - fieldcontent
 - content Globe Secret garantie une transparence de prix et de réservation. En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.
- 2
 - Promise
 - id3
 - title DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 - content   Globe Secret vous propose de nombreux critères d’entrée et originaux pour choisir l’hôtel ou l’expérience qui correspond à vos envies. Ex: la zone géographique mais aussi le climat, la galerie. Nous avons classé les hôtels par thèmes, vous permettant de faire une recherche d'hotel ou une expérience en fonction de vos goûts ou d'une envie particulière ex: équitation, culture, festival, pêche,..
 - localefre
 - Titles
 - 0
 - id10151
 - localeeng
 - modelPromise
 - foreign_key3
 - fieldtitle
 - content UNIQUE SELECTION CRITERIA
 - 1
 - id10152
 - localefre
 - modelPromise
 - foreign_key3
 - fieldtitle
 - content DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 - Contents
 - 0
 - id10153
 - localeeng
 - modelPromise
 - foreign_key3
 - fieldcontent
 - content
 - 1
 - id10154
 - localefre
 - modelPromise
 - foreign_key3
 - fieldcontent
 - content   Globe Secret vous propose de nombreux critères d’entrée et originaux pour choisir l’hôtel ou l’expérience qui correspond à vos envies. Ex: la zone géographique mais aussi le climat, la galerie. Nous avons classé les hôtels par thèmes, vous permettant de faire une recherche d'hotel ou une expérience en fonction de vos goûts ou d'une envie particulière ex: équitation, culture, festival, pêche,..
- 3
 - Promise
 - id4
 - title PLUS DE SERVICES A LA CARTE
 - content   <meta charset="utf-8" /> <div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; "> Globe Secret vous propose aussi ses services pour la réservation de vos billets d’avion. Accédez ainsi à des tarifs négociés sur + de 500 compagnies aériennes vers plus de 1000 destinations. Toujours selon le même principe, ce service est sans frais supplémentaires. Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste, nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. Faites-nous part de vos projets !</div>
 - localefre
 - Titles
 - 0
 - id10155
 - localeeng
 - modelPromise
 - foreign_key4
 - fieldtitle
 - content MORE TAILORED SERVICES
 - 1
 - id10156
 - localefre
 - modelPromise
 - foreign_key4
 - fieldtitle
 - content PLUS DE SERVICES A LA CARTE
 - Contents
 - 0
 - id10157
 - localeeng
 - modelPromise
 - foreign_key4
 - fieldcontent
 - content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 - 1
 - id10158
 - localefre
 - modelPromise
 - foreign_key4
 - fieldcontent
 - content   <meta charset="utf-8" /> <div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; "> Globe Secret vous propose aussi ses services pour la réservation de vos billets d’avion. Accédez ainsi à des tarifs négociés sur + de 500 compagnies aériennes vers plus de 1000 destinations. Toujours selon le même principe, ce service est sans frais supplémentaires. Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste, nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. Faites-nous part de vos projets !</div>
destinations_for_layout
- AFAfghanistan
- AXAland Islands
- ALAlbania
- DZAlgeria
- ASAmerican Samoa
- ADAndorra
- AOAngola
- AIAnguilla
- AQAntarctica
- AGAntigua/Barbuda
- ARArgentina
- AMArmenia
- AWAruba
- AUAustralia
- ATAustria
- AZAzerbaijan
- BSBahamas
- BHBahrain
- BDBangladesh
- BBBarbados
- BYBelarus
- BEBelgium
- BZBelize
- BJBenin
- BMBermuda
- BTBhutan
- BOBolivia
- BABosnia
- BWBotswana
- BVBouvet Island
- BRBrazil
- IOBritish Indian Ocean Territory
- WIBritish West Indies
- BNBrunei Darussalam
- BGBulgaria
- BFBurkina Faso
- BIBurundi
- KHCambodia
- CMCameroon
- CACanada
- CVCape Verde
- KYCayman Islands
- CFCentral Africa
- TDChad
- CLChile
- CNChina
- CXChristmas Island
- CCCocos (Keeling) Islands
- COColombia
- KMComoros
- CGCongo
- CDCongo
- CKCook Islands
- CRCosta Rica
- CICote D'Ivoire
- HRCroatia
- CUCuba
- CYCyprus
- CZCzech Republic
- DKDenmark
- DJDjibouti
- DMDominica
- DODominican Republic
- TPEast Timor
- ECEcuador
- EGEgypt
- SVEl Salvador
- GQEquatorial Guinea
- EREritrea
- EEEstonia
- ETEthiopia
- FOFaeroe Islands
- FKFalkland Islands
- FJFiji
- FIFinland
- FRFrance
- PFFrench Polynesia
- TFFrench Southern Territories
- GAGabon
- GMGambia
- XAGaza
- GEGeorgia
- DEGermany
- GHGhana
- GIGibraltar
- GRGreece
- GLGreenland
- GDGrenada
- GPGuadeloupe
- GUGuam
- GTGuatemala
- GGGuernsey
- GFGuiana
- GNGuinea
- GWGuinea-Bissau
- GYGuyana
- HTHaiti
- HMHeard And Mcdonald Islands
- XHHeld Territories
- HNHonduras
- HKHong Kong
- HUHungary
- ISIceland
- INIndia
- XIIndian Ocean Islands
- IDIndonesia
- IRIran
- IQIraq
- IEIreland
- IMIsle of Man
- ILIsrael
- ITItaly
- JMJamaica
- JPJapan
- JEJersey
- JOJordan
- KZKazakhstan
- KEKenya
- KIKiribati
- KRKorea
- KWKuwait
- KGKyrgyzstan
- LALaos
- LVLatvia
- LBLebanon
- LSLesotho
- LRLiberia
- LYLibya
- LILiechtenstein
- LTLithuania
- LULuxembourg
- MOMacau
- MKMacedonia
- MGMadagascar
- MWMalawi
- MYMalaysia
- MVMaldives
- MLMali
- MTMalta
- MHMarshall Islands
- MQMartinique
- MRMauritania
- MUMauritius
- YTMayotte
- MXMexico
- FMMicronesia
- MDMoldova
- MCMonaco
- MNMongolia
- MEMontenegro
- MSMontserrat
- MAMorocco
- MZMozambique
- MMMyanmar
- NANamibia
- NRNauru
- NPNepal
- NLNetherlands
- ANNetherlands Antilles
- NCNew Caledonia
- NZNew Zealand
- NINicaragua
- NENiger
- NGNigeria
- NUNiue
- NFNorfolk Island
- XBNorthern Ireland
- MPNorthern Mariana Islands
- NONorway
- OMOman
- PKPakistan
- PWPalau
- PSPalestinian Territory
- PAPanama
- PGPapua New Guinea
- PYParaguay
- PEPeru
- PHPhilippines
- PNPitcairn
- PLPoland
- PTPortugal
- PRPuerto Rico
- QAQatar
- REReunion
- RORomania
- RURussia
- RWRwanda
- LCSaint Lucia
- BLSaint-Barthelemy
- MFSaint-Martin
- SMSan Marino
- STSao Tome And Principe
- SASaudi Arabia
- WYScotland
- SNSenegal
- RSSerbia
- YUSerbia and Montenegro
- CSSerbia and Montenegro
- SCSeychelles
- SLSierra Leone
- SGSingapore
- SKSlovak Republic
- SISlovenia
- SBSolomon Islands
- SOSomalia
- ZASouth Africa
- GSSouth Georgia
- ESSpain
- LKSri Lanka
- SHSt. Helena
- KNSt. Kitts & Nevis
- PMSt. Pierre
- VCSt. Vincent & The Grenadines
- SDSudan
- SRSuriname
- SJSvalbard And Jan Mayen Islands
- SZSwaziland
- SESweden
- CHSwitzerland
- SYSyria
- TWTaiwan
- TJTajikistan
- TZTanzania
- THThailand
- TLTimor-Leste
- TGTogo
- TKTokelau
- TOTonga
- TTTrinidad And Tobago
- TNTunisia
- TRTurkey
- TMTurkmenistan
- TCTurks And Caicos Islands
- TVTuvalu
- UMU.S. Minor Outlying Islands
- UGUganda
- UAUkraine
- AEUnited Arab Emirates
- GBUnited Kingdom
- USUnited States
- UYUruguay
- UZUzbekistan
- VUVanuatu
- VAVatican City State
- VEVenezuela
- VNVietnam
- VGVirgin Islands (British)
- VIVirgin Islands (U.S.)
- WXWales
- WFWallis And Futuna Islands
- EHWestern Sahara
- WSWestern Samoa
- YEYemen
- ZRZaire
- ZMZambia
- ZWZimbabwe
themes_for_layout
- 6Arts & Culture
- 10Famille & Enfant
- 7Festival & Tradition
- 12Gastronomie
- 11Insolite & Curieux
- 13Marché & Shopping
- 5Musique
- 8Nature
- 4Parc & Jardin
- 9Sport
themes_images_for_layout
- 6art0.png
- 4parc1.png
- 5musique0.png
- 7festival0.png
- 8nature0.png
- 9sport0.png
- 10famille0.png
- 11insolite0.png
- 12gastronomie0.png
- 13shopping0.png
envies_for_layout
- 22ACCES HANDICAPE
- 21ACCES INTERNET
- 25CAMPAGNE
- 26CHASSE
- 4DESERT
- 12ECOLOGIE
- 14EQUITATION
- 19GARDE ENFANT
- 9GOLF
- 30HELIPORT
- 3ILE
- 1JUNGLE
- 13LAC
- 6LOCATION DE VELO
- 24LOUNGE CIGARE
- 7PECHE
- 18PISCINE
- 5PLAGE
- 10PLONGEE
- 27POLO
- 2RANDONNEE
- 11SAFARI
- 29SHOPPING
- 16SKI
- 15SPA
- 23TENNIS
- 17VIGNOBLE
- 8VILLE
- 28VOILE
countries_for_layout
- 0
  - Country
    - idZA
    - nameSouth Africa
    - name_freAfrique Du Sud
- 1
  - Country
    - idAL
    - nameAlbania
    - name_freAlbanie
- 2
  - Country
    - idDE
    - nameGermany
    - name_freAllemagne
- 3
  - Country
    - idAD
    - nameAndorra
    - name_freAndorre
- 4
  - Country
    - idAI
    - nameAnguilla
    - name_freAnguilla
- 5
  - Country
    - idAG
    - nameAntigua/Barbuda
    - name_freAntigua-Et-Barbuda
- 6
  - Country
    - idAN
    - nameNetherlands Antilles
    - name_freAntilles Néerlandaises
- 7
  - Country
    - idSA
    - nameSaudi Arabia
    - name_freArabie Saoudite
- 8
  - Country
    - idAR
    - nameArgentina
    - name_freArgentine
- 9
  - Country
    - idAM
    - nameArmenia
    - name_freArménie
- 10
  - Country
    - idAU
    - nameAustralia
    - name_freAustralie
- 11
  - Country
    - idAT
    - nameAustria
    - name_freAutriche
- 12
  - Country
    - idAZ
    - nameAzerbaijan
    - name_freAzerbaïdjan
- 13
  - Country
    - idBS
    - nameBahamas
    - name_freBahamas
- 14
  - Country
    - idBB
    - nameBarbados
    - name_freBarbade
- 15
  - Country
    - idBE
    - nameBelgium
    - name_freBelgique
- 16
  - Country
    - idBZ
    - nameBelize
    - name_freBelize
- 17
  - Country
    - idBM
    - nameBermuda
    - name_freBermudes
- 18
  - Country
    - idBT
    - nameBhutan
    - name_freBhoutan
- 19
  - Country
    - idBO
    - nameBolivia
    - name_freBolivie
- 20
  - Country
    - idBA
    - nameBosnia
    - name_freBosnie-Herzégovine
- 21
  - Country
    - idBR
    - nameBrazil
    - name_freBrésil
- 22
  - Country
    - idKH
    - nameCambodia
    - name_freCambodge
- 23
  - Country
    - idCA
    - nameCanada
    - name_freCanada
- 24
  - Country
    - idCL
    - nameChile
    - name_freChili
- 25
  - Country
    - idCN
    - nameChina
    - name_freChine
- 26
  - Country
    - idCO
    - nameColombia
    - name_freColombie
- 27
  - Country
    - idCR
    - nameCosta Rica
    - name_freCosta Rica
- 28
  - Country
    - idHR
    - nameCroatia
    - name_freCroatie
- 29
  - Country
    - idDK
    - nameDenmark
    - name_freDanemark
- 30
  - Country
    - idDM
    - nameDominica
    - name_freDominique
- 31
  - Country
    - idEG
    - nameEgypt
    - name_freÉgypte
- 32
  - Country
    - idAE
    - nameUnited Arab Emirates
    - name_freÉmirats Arabes Unis
- 33
  - Country
    - idEC
    - nameEcuador
    - name_freÉquateur
- 34
  - Country
    - idES
    - nameSpain
    - name_freEspagne
- 35
  - Country
    - idEE
    - nameEstonia
    - name_freEstonie
- 36
  - Country
    - idUS
    - nameUnited States
    - name_freÉtats-Unis
- 37
  - Country
    - idFJ
    - nameFiji
    - name_freFidji
- 38
  - Country
    - idFI
    - nameFinland
    - name_freFinlande
- 39
  - Country
    - idFR
    - nameFrance
    - name_freFrance
- 40
  - Country
    - idGR
    - nameGreece
    - name_freGrèce
- 41
  - Country
    - idGD
    - nameGrenada
    - name_freGrenade
- 42
  - Country
    - idGP
    - nameGuadeloupe
    - name_freGuadeloupe
- 43
  - Country
    - idGT
    - nameGuatemala
    - name_freGuatemala
- 44
  - Country
    - idHN
    - nameHonduras
    - name_freHonduras
- 45
  - Country
    - idHK
    - nameHong Kong
    - name_freHong-Kong
- 46
  - Country
    - idHU
    - nameHungary
    - name_freHongrie
- 47
  - Country
    - idCK
    - nameCook Islands
    - name_freÎles Cook
- 48
  - Country
    - idTC
    - nameTurks And Caicos Islands
    - name_freÎles Turks et Caïques
- 49
  - Country
    - idVG
    - nameVirgin Islands (British)
    - name_freÎles Vierges Britanniques
- 50
  - Country
    - idVI
    - nameVirgin Islands (U.S.)
    - name_freÎles Vierges Des États-Unis
- 51
  - Country
    - idIN
    - nameIndia
    - name_freInde
- 52
  - Country
    - idID
    - nameIndonesia
    - name_freIndonésie
- 53
  - Country
    - idIE
    - nameIreland
    - name_freIrlande
- 54
  - Country
    - idIS
    - nameIceland
    - name_freIslande
- 55
  - Country
    - idIL
    - nameIsrael
    - name_freIsraël
- 56
  - Country
    - idIT
    - nameItaly
    - name_freItalie
- 57
  - Country
    - idJM
    - nameJamaica
    - name_freJamaïque
- 58
  - Country
    - idJP
    - nameJapan
    - name_freJapon
- 59
  - Country
    - idJO
    - nameJordan
    - name_freJordanie
- 60
  - Country
    - idKE
    - nameKenya
    - name_freKenya
- 61
  - Country
    - idLA
    - nameLaos
    - name_freLaos
- 62
  - Country
    - idLV
    - nameLatvia
    - name_freLettonie
- 63
  - Country
    - idLB
    - nameLebanon
    - name_freLiban
- 64
  - Country
    - idLT
    - nameLithuania
    - name_freLituanie
- 65
  - Country
    - idMO
    - nameMacau
    - name_freMacao
- 66
  - Country
    - idMG
    - nameMadagascar
    - name_freMadagascar
- 67
  - Country
    - idMY
    - nameMalaysia
    - name_freMalaisie
- 68
  - Country
    - idMV
    - nameMaldives
    - name_freMaldives
- 69
  - Country
    - idMA
    - nameMorocco
    - name_freMaroc
- 70
  - Country
    - idMU
    - nameMauritius
    - name_freMaurice
- 71
  - Country
    - idMX
    - nameMexico
    - name_freMexique
- 72
  - Country
    - idMN
    - nameMongolia
    - name_freMongolie
- 73
  - Country
    - idME
    - nameMontenegro
    - name_freMonténégro
- 74
  - Country
    - idMZ
    - nameMozambique
    - name_freMozambique
- 75
  - Country
    - idMM
    - nameMyanmar
    - name_freMyanmar
- 76
  - Country
    - idNA
    - nameNamibia
    - name_freNamibie
- 77
  - Country
    - idNI
    - nameNicaragua
    - name_freNicaragua
- 78
  - Country
    - idNO
    - nameNorway
    - name_freNorvège
- 79
  - Country
    - idNZ
    - nameNew Zealand
    - name_freNouvelle-Zélande
- 80
  - Country
    - idOM
    - nameOman
    - name_freOman
- 81
  - Country
    - idUG
    - nameUganda
    - name_freOuganda
- 82
  - Country
    - idPK
    - namePakistan
    - name_frePakistan
- 83
  - Country
    - idPA
    - namePanama
    - name_frePanama
- 84
  - Country
    - idNL
    - nameNetherlands
    - name_frePays-Bas
- 85
  - Country
    - idPE
    - namePeru
    - name_frePérou
- 86
  - Country
    - idPH
    - namePhilippines
    - name_frePhilippines
- 87
  - Country
    - idPL
    - namePoland
    - name_frePologne
- 88
  - Country
    - idPF
    - nameFrench Polynesia
    - name_frePolynésie Française
- 89
  - Country
    - idPR
    - namePuerto Rico
    - name_frePorto Rico
- 90
  - Country
    - idPT
    - namePortugal
    - name_frePortugal
- 91
  - Country
    - idDO
    - nameDominican Republic
    - name_freRépublique Dominicaine
- 92
  - Country
    - idCZ
    - nameCzech Republic
    - name_freRépublique Tchèque
- 93
  - Country
    - idRE
    - nameReunion
    - name_freRéunion
- 94
  - Country
    - idRO
    - nameRomania
    - name_freRoumanie
- 95
  - Country
    - idGB
    - nameUnited Kingdom
    - name_freRoyaume-Uni
- 96
  - Country
    - idRU
    - nameRussia
    - name_freRussie
- 97
  - Country
    - idBL
    - nameSaint-Barthelemy
    - name_freSaint-Barthélemy
- 98
  - Country
    - idKN
    - nameSt. Kitts & Nevis
    - name_freSaint-Kitts-Et-Nevis
- 99
  - Country
    - idVC
    - nameSt. Vincent & The Grenadines
    - name_freSaint-Vincent-Et-Les Grenadines
- 100
  - Country
    - idLC
    - nameSaint Lucia
    - name_freSainte-Lucie
- 101
  - Country
    - idRS
    - nameSerbia
    - name_freSerbie
- 102
  - Country
    - idSC
    - nameSeychelles
    - name_freSeychelles
- 103
  - Country
    - idSG
    - nameSingapore
    - name_freSingapour
- 104
  - Country
    - idSK
    - nameSlovak Republic
    - name_freSlovaquie
- 105
  - Country
    - idSI
    - nameSlovenia
    - name_freSlovénie
- 106
  - Country
    - idLK
    - nameSri Lanka
    - name_freSri Lanka
- 107
  - Country
    - idSE
    - nameSweden
    - name_freSuède
- 108
  - Country
    - idCH
    - nameSwitzerland
    - name_freSuisse
- 109
  - Country
    - idSJ
    - nameSvalbard And Jan Mayen Islands
    - name_freSvalbard Et Île Jan Mayen
- 110
  - Country
    - idTW
    - nameTaiwan
    - name_freTaïwan
- 111
  - Country
    - idTZ
    - nameTanzania
    - name_freTanzanie
- 112
  - Country
    - idTH
    - nameThailand
    - name_freThaïlande
- 113
  - Country
    - idTN
    - nameTunisia
    - name_freTunisie
- 114
  - Country
    - idTR
    - nameTurkey
    - name_freTurquie
- 115
  - Country
    - idUA
    - nameUkraine
    - name_freUkraine
- 116
  - Country
    - idUY
    - nameUruguay
    - name_freUruguay
- 117
  - Country
    - idVU
    - nameVanuatu
    - name_freVanuatu
- 118
  - Country
    - idVN
    - nameVietnam
    - name_freViet Nam
- 119
  - Country
    - idZW
    - nameZimbabwe
    - name_freZimbabwe
staticSlugs
- 0qui-sommes-nous
- 1plan-du-site
- 2termes-et-conditions
- 3actualites
- 4emplois
- 5mentions-legales
- 6credits
userFavorites
- fav-event(empty)
- fav-hotel(empty)
country
- Country
  - idCO
  - nameColombia
  - name_freColombie
hotels
- 0
  - Hotel
    - id250
    - starred0
    - in0
    - maintrack_hotel_id364432
    - brand_codeTA
    - nameEl Marques Hotel Boutique
    - addressCalle ntra sra del Carmen 3341
    - zip_code00000
    - cityarea_id(null)
    - city_id224
    - region_id(null)
    - state_id(null)
    - country_idCO
    - latitude10.433333
    - longitude-75.516701
    - zoom13
    - rating5
    - phone57 5 6647800
    - reservation_phone57 57 5 6647800
    - fax57 5 6644438
    - emailRESERVAS@ELMARQUESHOTELBOUTIQUE.COM
    - created2011-05-13 21:07:59
    - modified2011-12-15 08:22:12
    - descriptionThe Marques Boutique Hotel is located in a colonial house dating from the XVII century, and made part of four houses with facades and covers of the same height that were owned by the Count of Pestagua. The Counts of Pestacua descended from an ancient and noble family from Auzola: the Madariaga. One of his members, Andres de Madariaga y Alvarez Mondragon, was named attorney of Indias in 1767, by which is believed that this date must transcend in the city of Cartagena de Indias. His son, Andres de Madariaga y Morales, was the first Count of Pestacua, title conceived by the Royal Order of King Charles III in 1774. Four years later, in January of 1774, the faculty of conceiving the majority would be conceived to him. In the 70´s the house was acquired by the art collector and film maker from New York, Sam Green, who was among the first foreigners to buy property in the Historic Center of Cartagena de Indias. The house is still recognized under this name by many of the people in the city. The house was famous for its parties and its famous guests and celebrities from the New York Jet Set like: Yoko Ono, John Lenon, Greta Garbo and some of the members of the Kennedy family.
    - description_freL'hôtel Marques est situé dans une maison coloniale datant du XVIIe siècle, et fait partie des quatre maisons avec des façades et couvertures de la même hauteur qui ont été détenus par le comte de Pestagua. Les comtes de Pestagua sont issus d'une famille noble et ancienne de Auzola: la Fondation Madariaga. Un de ses membres, Andres de Madariaga y Alvarez Mondragon, a été nommé procureur de Indias en 1767, par laquelle on croit que cette date a transformé la ville de Cartagena de Indias. Son fils, Andres de Madariaga y Morales, a été le premier comte de Pestagua, titre établi par l'arrêté royal du roi Charles III en 1774. Quatre ans plus tard, en Janvier de 1774, la faculté de concevoir la majorité lui était attribué. Dans les années 70, la maison a été acquise par le collectionneur d'art et cinéaste de New York, Sam Green, qui a été parmi les premiers étrangers à acheter une propriété dans le centre historique de Cartagena de Indias. La maison est toujours reconnu sous ce nom par de nombreuses personnes dans la ville. La maison a été célèbre pour ses soirées et ses célèbres invités comme : Yoko Ono, John Lennon, Greta Garbo et certains des membres de la famille Kennedy.
    - amenityConcierge Desk, Multilingual, Outdoor Parking, Valet Parking, AM/FM Alarm Clock, Terrace, Bathrobes, Bathroom Telephone, Bath Tub, Meeting/Banquet Facilities, Meal Plan - American, Meal Plan - MAP/Half-board, City Center.
    - amenity_freBureau de concierge, multilingue, parking extérieur, service de voiturier, AM / FM Réveil, Terrasse, peignoirs, salle de bains Téléphone, Baignoire, salles de réunions / banquets, Repas - américaine, Repas - MAP / demi-pension, Centre Ville.
    - lowest_rate0.00
    - lr_currency
    - lr_people0
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id224
    - country_idCO
    - state_id(null)
    - maintrack_idCARTAGENA
    - nameCartagena
    - main_key
  - Country
    - idCO
    - nameColombia
    - name_freColombie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id4541
      - hotel_id250
      - order2
      - urihttp://images.pegs.com/imageRepo/3/0/35/546/520/60108_b1_J.jpg
      - ratio_hw1.49
      - on_wall0
    - 1
      - id4542
      - hotel_id250
      - order3
      - urihttp://images.pegs.com/imageRepo/3/0/35/546/524/60108_b2_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 2
      - id4543
      - hotel_id250
      - order4
      - urihttp://images.pegs.com/imageRepo/3/0/35/546/528/60108_b3_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 3
      - id4544
      - hotel_id250
      - order5
      - urihttp://images.pegs.com/imageRepo/3/0/35/546/532/60108_b4_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 4
      - id4545
      - hotel_id250
      - order6
      - urihttp://images.pegs.com/imageRepo/3/0/35/546/536/60108_b5_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 5
      - id4546
      - hotel_id250
      - order7
      - urihttp://images.pegs.com/imageRepo/3/0/35/546/540/60108_b6_J.jpg
      - ratio_hw0.60
      - on_wall0
  - Room(empty)
  - RatesPeriod(empty)
  - Unavailability(empty)
  - Comment(empty)
  - Favorite(empty)
  - Taglines
    - 0
      - id159
      - localeeng
      - modelHotel
      - foreign_key250
      - fieldtagline
      - content
    - 1
      - id160
      - localefre
      - modelHotel
      - foreign_key250
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id18
      - created2011-05-17 19:28:28
      - modified2011-05-17 19:28:28
- 1
  - Hotel
    - id249
    - starred0
    - in0
    - maintrack_hotel_id364725
    - brand_codeUZ
    - nameAlfiz Hotel
    - addressCalle Cochera del Gobernador 3 Centro Historico
    - zip_code0000
    - cityarea_id(null)
    - city_id224
    - region_id(null)
    - state_id(null)
    - country_idCO
    - latitude10.421
    - longitude-75.545
    - zoom12
    - rating0
    - phone57 566 00006
    - reservation_phone(null)
    - fax(null)
    - email(null)
    - created2011-05-13 21:07:59
    - modified2011-06-03 10:48:30
    - descriptionThe Alfiz Hotel is located in a XVII century colonial house in the Cartagena's Historical Center. It´s situated between the city's two oldest squares: The Plaza Bolivar and The Plaza de la Aduana. The Alfiz, one of the city's cultural heritage buildings, underwent a process of restoration from the end of 2005 until mid 2007 in order to be converted in to a boutique hotel, as a testimony to Cartagena's history. Consequently the guest may find high-class colonial features in its interior, including the typical balconies of this era. The restoration and decorative design take in to account the most important periods of Cartagena's history, from the Conquest to Independence, in order to provide a stylish getaway and encounter with Colombia's most historic city.
    - description_freL'Hôtel Alfiz est situé dans une maison coloniale du XVIIè siècle dans le centre historique de Carthagène. Il est situé entre deux anciennes places de la ville: La Plaza de Bolivar et la Plaza de la Aduana. Le Alfiz, l'un des bâtiments de la ville du patrimoine culturel, a subi un processus de restauration de la fin de 2005 jusqu'à la mi-2007 afin d'être converti en un hôtel de charme, comme un témoignage de l'histoire de Cartagena. Par conséquent, le client peut trouver des caractéristiques coloniales haut de gamme dans son intérieur, y compris les balcons typiques de cette époque. Le projet de restauration et de décoration à pris en compte les périodes les plus importantes de l'histoire de Cartagena, la conquête de l'indépendance, afin de fournir une escapade élégante et une rencontre avec la ville la plus historique de la Colombie.
    - amenityBabysitting/Child Services, Tour Desk, Copy Service, Barber/Beauty Shop, Barber Shop, Complimentary Continental Breakfast, Currency Exchange, Porters, Safe Deposit Box, Wake-up Service, 120 AC, ATM/Cash Machine, Free Newspaper, On the Ocean, Pool, Restaurant, Doctor on Call, Maid Service, Laundry/Valet Services, Boutiques, Drugstore, Duty Free Shop, High speed internet access, Handicapped Rooms/Facilities, Security, Television with Cable, Meeting/Banquet Facilities, Internet Access Wireless.
    - amenity_freGarde d'enfants, bureau d'excursions, service de copie, salon de coiffure / institut de beauté, de coiffure,, Petit déjeuner continental, service de change, Porters, Coffre-fort, Service de réveil, 120 AC, distributeur automatique, journal gratuit, Sur la Mer, piscine, restaurant, Docteur à l'appel, Maid Service, Blanchisserie / Services Voiturier, Boutiques, Pharmacie, Duty Free Shop, l'accès Internet à haute vitesse, chambres / équipements pour handicapés, sécurité, télévision avec câble, salles de réunions / banquets, accès internet Sans fil.
    - lowest_rate185.00
    - lr_currencyUSD
    - lr_people2
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id224
    - country_idCO
    - state_id(null)
    - maintrack_idCARTAGENA
    - nameCartagena
    - main_key
  - Country
    - idCO
    - nameColombia
    - name_freColombie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id4536
      - hotel_id249
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/25/414/401/Hotel-Alfiz-0009_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 1
      - id4537
      - hotel_id249
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/25/414/405/Hotel-Alfiz-0053_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 2
      - id4538
      - hotel_id249
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/25/414/409/Fachada_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 3
      - id4539
      - hotel_id249
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/25/414/441/Piscina_J.jpg
      - ratio_hw1.00
      - on_wall0
  - Room
    - 0
      - id1036
      - typeOTH
      - hotel_id249
      - nameStandard Room Twin Bed
      - descriptionStandard Room Twin Bed En-suite bathroom with H&C water tub minisplit air conditioning ceiling fan, wireless internet direct-dial phone room safe and cable 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
    - 1
      - id1037
      - typeOTH
      - hotel_id249
      - nameStandard Room Queen Bed
      - descriptionStandard Room Queen Bed En-suite bathroom with H&C water tub minisplit air conditioning ceiling fan wireless internet direct-dial phone room safe and cable 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
      - id1038
      - typeOTH
      - hotel_id249
      - nameJunior Suite
      - descriptionJunior Suite with mezzanine. En-suite bathroom with H&C water tub minisplit air conditioning ceiling fan wireless internet direct-dial phone room safe and cable 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
    - 3
      - id1039
      - typeOTH
      - hotel_id249
      - nameSuite
      - descriptionSuite with king size bed. Balcony en-suite bathroom with H&C water tub, minisplit air conditioning ceiling fan wireless internet direct-dial phone room safe and cable 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
    - 4
      - id1040
      - typeOTH
      - hotel_id249
      - nameApartment
      - 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
      - id157
      - localeeng
      - modelHotel
      - foreign_key249
      - fieldtagline
      - content
    - 1
      - id158
      - localefre
      - modelHotel
      - foreign_key249
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id18
      - created2011-05-17 19:28:28
      - modified2011-05-17 19:28:28
    - 2
      - id19
      - created2011-05-24 08:21:45
      - modified2011-05-24 08:21:45
    - 3
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
    - 4
      - id22
      - created2011-05-24 08:23:46
      - modified2011-05-24 08:23:46
- 2
  - Hotel
    - id248
    - starred0
    - in0
    - maintrack_hotel_id353964
    - brand_codeYX
    - nameHotel de la Opera
    - addressCalle 10 N 5 72
    - zip_code0000
    - cityarea_id(null)
    - city_id223
    - region_id(null)
    - state_id(null)
    - country_idCO
    - latitude4.59674444460374
    - longitude-74.0751028060913
    - zoom14
    - rating0
    - phone57 57-133-62066
    - reservation_phone(null)
    - fax57 57-133-74617
    - emailsales@hotelopera.com.co
    - created2011-05-13 21:07:58
    - modified2011-06-03 10:42:33
    - descriptionLa Candelaria district in Bogota’s city centre has the secret charm of transporting all visitors into the past. If you wander the old cobblestone streets you can feel as if smart dressed citizens, wearing suits and top hats were still moving around; watching to pedestrians with pride from their horse-drawn carriages. All this evokes a different time when gas lamppost just gave a poor and eerie lighting whilst a group of policeman guarded wandering the silent and empty streets. Back in the 21 Century, those same steep rising streets are an invaluable testimony of the history in Republican times; a splendorous age when local people got hold of the work of French architects just to resemble European styles in the then newly freed Bogota. Additionally, in La Candelaria we can also witness beautiful examples of architecture when Colombia was under the Spanish dominion. The place where the Hotel de La Opera is located intertwines a Colonial and a Republican house with hallways, interior gardens and tick walls. The hotel was opened in 1997, gathering all Colombian tradition and the exquisite Italian style. The result is full of warm and comfortable spaces where visitors can find wide rooms, pleasant social spaces and beautiful bedrooms. To stay in the Hotel de La Opera is a unique and fascinating experience, just in the middle of the historic centre, a place that cannot be missed by anyone visiting Bogota.
    - description_freLe district de la Candelaria de Bogota a le charme secret de transporter tous les visiteurs dans le passé. En vous promenant dans les vieilles rues pavées vous pouvez vous sentir comme un citoyen habillé en costume et chapeaux. Tout cela évoque un autre moment lorsque les lampadaires à gaz donnent un mauvais éclairage et un mystérieux groupe de policier surveillent les rues silencieuses et vides. Retour dans le 21 siècle, ces mêmes ruelles sont un témoignage inestimable de l'histoire à l'époque républicaine; un âge resplendissant quand les gens locaux mis la main sur le travail des architectes français vient à ressembler à des styles européens dans le Bogota récemment libéré. En outre, à La Candelaria, nous pouvons également voir de beaux exemples d'architecture où la Colombie fût sous la domination espagnole. Le lieu où l'Hôtel de la Opera est situé entremêle une histoire coloniale et républicaine une maison avec un hall et des jardins intérieurs. L'hôtel a été ouvert en 1997, de style colombien et italien, le résultat est plein d'espaces chaleureux et confortable où les visiteurs peuvent trouver des chambres spacieuses et agréables. L'hôtel de la Opéra est une expérience unique et fascinante, juste au milieu du centre historique, un lieu immanquable par tous les visiteurs de Bogota.
    - amenity24 Hour Front Desk, Express Checkout, Parking, Restaurant, Safe Deposit Box, Laundry/Valet Services, Telephone, Business Center, City Center.
    - amenity_freRéception 24 heures, Express Checkout, parking, restaurant, coffre-fort, service de blanchisserie, téléphone, centre d'affaires, Centre Ville.
    - lowest_rate170.00
    - lr_currencyUSD
    - lr_people2
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id223
    - country_idCO
    - state_id(null)
    - maintrack_idBOGOTA
    - nameBogotá
    - main_key
  - Country
    - idCO
    - nameColombia
    - name_freColombie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id4524
      - hotel_id248
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/29/713/995/Front%20Opera_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 1
      - id4525
      - hotel_id248
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/29/713/999/opera1_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 2
      - id4526
      - hotel_id248
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/3/Opera_J.jpg
      - ratio_hw0.65
      - on_wall0
    - 3
      - id4527
      - hotel_id248
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/7/Room%202%20opera_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 4
      - id4528
      - hotel_id248
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/11/Room%20opera_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 5
      - id4529
      - hotel_id248
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/15/opera3_J.jpg
      - ratio_hw0.66
      - on_wall0
    - 6
      - id4530
      - hotel_id248
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/19/H2XI8L00_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 7
      - id4531
      - hotel_id248
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/23/H2XI8L01_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 8
      - id4532
      - hotel_id248
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/27/H2XI8L03_J.jpg
      - ratio_hw1.02
      - on_wall0
    - 9
      - id4533
      - hotel_id248
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/31/H2XI8L04_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 10
      - id4534
      - hotel_id248
      - order12
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/35/H2XI8L05_J.jpg
      - ratio_hw0.52
      - on_wall0
    - 11
      - id4535
      - hotel_id248
      - order13
      - urihttp://images.pegs.com/imageRepo/1/0/29/714/39/H2XI8L02_J.jpg
      - ratio_hw0.58
      - on_wall0
  - Room
    - 0
      - id1033
      - typeOTH
      - hotel_id248
      - nameJunior Suite
      - descriptionJunior Suite; Cajilla de seguridad; escritorio; mesa de noche; bano con tina; minibar; algunas tienen vista a la calle 10; el mobiliario es italiano; TV; radio reloj; closet
      - 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
      - id1034
      - typeOTH
      - hotel_id248
      - nameStandard Colonial
      - descriptionStandard Colonial; Hay dos habitaciones Standard Colonial que admite maximo 3 personas;la habitacion consta de; Cama matrimonial; cajilla de seguridad; escritorio; mesa de noche; bano con ducha; algunas tienen vista a la calle 10; el mobiliario es italian
      - 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
      - id1035
      - typeOTH
      - hotel_id248
      - nameStandard Republicana
      - 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
      - id155
      - localeeng
      - modelHotel
      - foreign_key248
      - fieldtagline
      - content
    - 1
      - id156
      - localefre
      - modelHotel
      - foreign_key248
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id18
      - created2011-05-17 19:28:28
      - modified2011-05-17 19:28:28
    - 2
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
- 3
  - Hotel
    - id1522
    - starred0
    - in0
    - maintrack_hotel_id378275
    - brand_codeWV
    - nameSan Pedro de Majagua
    - addressIslas del rosario
    - zip_code00000
    - cityarea_id(null)
    - city_id224
    - region_id(null)
    - state_id(null)
    - country_idCO
    - latitude10.16878
    - longitude-75.794441
    - zoom13
    - rating0
    - phone57 5 6734097
    - reservation_phone(null)
    - fax(null)
    - emailventasdaytour@hotelmajagua.com
    - created2012-03-06 15:53:13
    - modified2012-03-06 15:53:13
    - descriptionSan Pedro de Majagua Hotel is located only 45 minutes on speed boat from Cartagena de Indias, on the biggest island of the 27 islands that make part of the Natural Park ?Corales del Rosario? well known as Islas del Rosario. Its centennial trees, internal lagoons, mangroves and Colombia?s biggest reef system make this site the ideal place for your relaxing vacations. The hotel has an exuberant vegetation, 17 typical cabins with all comfort, two small white sanded beaches and crystal water, PADI GLOD PALM RESORT Palm Resort center, outdoor massage center, nautical and ecological activities, sea food and international food restaurant located down the leafy rubber trees and a beach bar along with a personalized service; all this elements are the warranty of a pleasant stay.
    - description_fre(null)
    - amenityJogging Track, Massage, 24 Hour Front Desk, Currency Exchange, Express Checkout, Safe Deposit Box, Wake-up Service, Air Conditioned, Ice Machine, No Smoking Rooms/Facilities, Security, Restaurant, 24 Hour Security, Multilingual, Television with Cable, TV, Cribs Available, Double Bed, Iron, Ironing Board, Mini Bar, TV Remote Control, Temperature Control, Shower, King Bed, Single Bed, Queen Bed, Sitting Area, Twin Bed, Fitness Center or Spa, Boating, Scuba Diving, Snorkeling,
    - amenity_fre(null)
    - lowest_rate0.00
    - lr_currency
    - lr_people0
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id224
    - country_idCO
    - state_id(null)
    - maintrack_idCARTAGENA
    - nameCartagena
    - main_key
  - Country
    - idCO
    - nameColombia
    - name_freColombie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id22304
      - hotel_id1522
      - order13
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/468/suite3_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 1
      - id22303
      - hotel_id1522
      - order12
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/464/suite2_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 2
      - id22302
      - hotel_id1522
      - order11
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/460/suite1_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 3
      - id22301
      - hotel_id1522
      - order10
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/456/lujo2_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 4
      - id22300
      - hotel_id1522
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/452/lujo1_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 5
      - id22299
      - hotel_id1522
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/448/exterior8_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 6
      - id22298
      - hotel_id1522
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/444/exterior6_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 7
      - id22297
      - hotel_id1522
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/440/exterior5_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 8
      - id22296
      - hotel_id1522
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/436/exterior4_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 9
      - id22295
      - hotel_id1522
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/432/exterior3_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 10
      - id22294
      - hotel_id1522
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/428/exterior2_j_J.jpg
      - ratio_hw1.00
      - on_wall0
    - 11
      - id22293
      - hotel_id1522
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/23/201/424/exterior1_j_J.jpg
      - ratio_hw1.00
      - on_wall0
  - Room
    - 0
      - id5935
      - typeOTH
      - hotel_id1522
      - nameLuxury d
      - 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
    - 1
      - id5933
      - typeOTH
      - hotel_id1522
      - nameLuxury b
      - descriptionBungalow type.. Hot water.. Air conditioner.. Tv.. Safety box.. Minibar.. Terrace.. 1 double size bed 1 sngl bed
      - 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
      - id5934
      - typeOTH
      - hotel_id1522
      - nameLuxury c
      - descriptionBungalow type.. Hot water.. Air conditioner.. Tv.. Safety box.. Minibar.. Terrace.. 2 double size bed
      - 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
      - id5932
      - typeOTH
      - hotel_id1522
      - nameSuite
      - descriptionBungalow type.. Hot water.. Air conditioner.. Tv.. Safety box.. Minibar.. Terrace.. 1 king size bed 2 sngl bed
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
    - 4
      - id5930
      - typeOTH
      - hotel_id1522
      - nameStandard
      - descriptionBungalow type.. Hot water.. Air conditioner.. Tv.. Safety box.. Minibar.. Terrace.. Double size bed
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
    - 5
      - id5931
      - typeOTH
      - hotel_id1522
      - nameLuxury a
      - descriptionBungalow type.. Hot water.. Air conditioner.. Tv.. Safety box.. Minibar.. Terrace.. 1 king size bed 1 sngl bed
      - 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
      - id2625
      - localeeng
      - modelHotel
      - foreign_key1522
      - fieldtagline
      - content
    - 1
      - id2626
      - localefre
      - modelHotel
      - foreign_key1522
      - fieldtagline
      - content
  - Envie(empty)
- 4
  - Hotel
    - id1121
    - starred0
    - in0
    - maintrack_hotel_id376326
    - brand_codeLE
    - nameTcherassi Hotel and Spa
    - addressCalle del Sargento Mayor No 6-21
    - zip_code00000
    - cityarea_id(null)
    - city_id1045
    - region_id(null)
    - state_id(null)
    - country_idCO
    - latitude10.425173226931898
    - longitude-75.5482265543976
    - zoom13
    - rating0
    - phone57 5 664-4445
    - reservation_phone1 866 589-3411
    - fax57 5 664 4414
    - emailinfo@tcherassihotels.com
    - created2011-09-15 07:52:51
    - modified2011-09-15 10:53:23
    - descriptionAfter an extensive two year restoration and renovation, a 250 year old colonial mansion comes to life in the heart of Cartagenas old city in fashion designer Silvia Tcherassis first hotel. With seven unique rooms and suites, The Tcherassi Hotel Spa reignites the magical setting of a bygone era while delivering all of the modern amenities and comforts discerning travelers have come to not only expect, but deserve. In addition to oversized, luxurious guest accommodations, the hotel boasts a full service spa, "Vera" A 40-seat chic Italian restaurant and lounge, four pools and 360 degree views of both Cartagena and the sea from a rooftop deck. The search for inspiration and relaxation is easily achieved as over 30 staff members cater to each guests every whim. Although The Tcherassi Hotel Spa is an oasis within itself, it is the perfect place from which to enjoy the vibrant colors and culture of Cartagena de Indias.
    - description_freAprès une vaste restauration de deux années, un vieux manoir colonial de 250 ans revient à la vie au cœur de la vieille ville de Carthagène. Avec sept chambres, L'hôtel Tcherassi ravive le cadre magique d'une époque révolue, tout en offrant toutes les commodités modernes et un confort que les voyageurs sont en droit d'attendre, mais qu'ils méritent surtout. En plus de surdimensionné, l'hébergement de l'hôtel dispose d'un spa avec un service complet, "Vera" le restaurant chic italien, quatre piscines et des vues à 360 degrés sur Cartagène et la mer à partir d'un toit-terrasse. La recherche de l'inspiration et de détente est facile, car plus de 30 membres du personnel répondent à tous les caprices de chaque invité. Bien que le Tcherassi soit une oasis, il est le lieu idéal pour profiter des couleurs vibrantes et de la culture de Cartagena de Indias.
    - amenityPets Allowed, Babysitting/Child Services, Concierge Desk, Tour Desk, Translation Service, Video Tapes, Guest Laundromat, Copy Service, Barber/Beauty Shop, Massage, Fitness Center or Spa, 24 Hour Front Desk, Currency Exchange, Porters, Safe Deposit Box, Wake-up Service, Air Conditioned, Free Newspaper, Hairdryers Available, Ironing Board, Private Bathroom, Parking, Valet Parking, Heated Pool, Jacuzzi, Outdoor Pool, Lounge, 24 Hour Security, Doctor on Call, Maid Service, Laundry/Valet Services, Turndown Service, News Stand, High speed internet access, Wireless Internet Access, Phone Service, Complimentary Continental Breakfast, Meal Plan, Internet Access Complimentary, AM/FM Alarm Clock, Radio, TV, Desk with lamp, Internet Access, King Bed, Mini Bar, Terrace, Bathrobes, Bathroom Telephone, Television with Cable, Iron, TV Remote Control, Safe, Refrigerator, Sitting Area, Audio Visual Equipment, Computer Rental, FAX, Secretarial Service, Cellular Telephone Rental, City Center.
    - amenity_freAnimaux domestiques admis, garde / Services à l'enfance, concierge, bureau d'excursions, service de traduction, de cassettes vidéo, Laverie, Copy Service, salon de coiffure / institut de beauté, massages, salle de gym ou de Spa, réception ouverte 24 heures, service de change, Porters, coffre-fort Box, service de réveil, Air Conditionné, journal gratuit, sèche-cheveux disponibles, planche à repasser, Salle de bain privée, parking, service de voiturier, piscine chauffée, jacuzzi, piscine extérieure, Lounge, 24 heures de sécurité, médecin de garde, de ménage, blanchisserie / services de voiturier, service de couvertures, stand Nouvelles, accès internet haut débit, accès Internet sans fil, service téléphonique, petit déjeuner continental, Repas, accès Internet gratuit, radio-réveil AM / FM, Radio, TV, bureau avec lampe, accès Internet, Mini Bar, Terrasse, peignoirs, téléphone Salle de bains, télévision avec câble, fer, TV Remote Control, coffre fort, réfrigérateur, coin salon, matériel audiovisuel, location d'ordinateurs, fax, service de secrétariat, Location de téléphones cellulaires, Centre Ville.
    - lowest_rate0.00
    - lr_currency
    - lr_people0
    - comment_count0
    - cancellation_policy(null)
    - cancellation_policy_fre(null)
    - published1
    - localefre
    - tagline
  - HomeHotel
    - id(null)
    - hotel_id(null)
    - order(null)
    - created(null)
  - City
    - id1045
    - country_idCO
    - state_id(null)
    - maintrack_idCARTAGENADEINDIAS
    - nameCartagena De Indias
    - main_key
  - Country
    - idCO
    - nameColombia
    - name_freColombie
  - State
    - id(null)
    - country_id(null)
    - name(null)
  - HotelImage
    - 0
      - id16609
      - hotel_id1121
      - order2
      - urihttp://images.pegs.com/imageRepo/1/0/24/931/12/Tcherassi%20Ext%20night_J.jpg
      - ratio_hw1.38
      - on_wall0
    - 1
      - id16610
      - hotel_id1121
      - order3
      - urihttp://images.pegs.com/imageRepo/1/0/24/931/21/Tcherassi%20frnt%20door%20night_J.jpg
      - ratio_hw1.38
      - on_wall0
    - 2
      - id16611
      - hotel_id1121
      - order4
      - urihttp://images.pegs.com/imageRepo/1/0/24/931/88/Roof%20pool%20with%20tower_J.jpg
      - ratio_hw0.67
      - on_wall0
    - 3
      - id16612
      - hotel_id1121
      - order5
      - urihttp://images.pegs.com/imageRepo/1/0/24/931/39/Mouseline%20bedroom%20with%20bath_J.jpg
      - ratio_hw1.25
      - on_wall0
    - 4
      - id16613
      - hotel_id1121
      - order6
      - urihttp://images.pegs.com/imageRepo/1/0/24/57/151/HA5E8D03_J.jpg
      - ratio_hw0.57
      - on_wall0
    - 5
      - id16614
      - hotel_id1121
      - order7
      - urihttp://images.pegs.com/imageRepo/1/0/24/931/48/peau%20de%20Soile%20bed%20with%20garden2_J.jpg
      - ratio_hw1.55
      - on_wall0
    - 6
      - id16615
      - hotel_id1121
      - order8
      - urihttp://images.pegs.com/imageRepo/1/0/24/931/30/Tcherassi%20Pool%20-%20Garden_J.jpg
      - ratio_hw1.50
      - on_wall0
    - 7
      - id16616
      - hotel_id1121
      - order9
      - urihttp://images.pegs.com/imageRepo/1/0/24/931/57/Vera%20inside_J.jpg
      - ratio_hw1.50
      - on_wall0
  - Room
    - 0
      - id4369
      - typeOTH
      - hotel_id1121
      - nameRadzimir-Grand Deluxe Room
      - descriptionGrand Deluxe Room-1 king bed-Minibar-Internet-42 Lcd tv-Bath amenities-Wood floor-Working desk-Digital ipod radio alarm clock-Minibar-Garden view-450sqft
      - 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
      - id4370
      - typeOTH
      - hotel_id1121
      - namePeau De Soie-Deluxe Garden Room
      - descriptionDeluxe Garden Room-1 king size bed-Wood floor-Minibar-Internet-42 inch Lcd tv-Bathroom amenities-Working desk-Digital ipod alarm clock-Pool view-375 sqft
      - 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
      - id4371
      - typeOTH
      - hotel_id1121
      - nameVoilee - Garden Balcony Room
      - descriptionGarden Balcony Room-1 king size bed-Wood floor-Minibar-Internet-42 inch Lcd tv-Bathroom amenities-Working desk-Digital ipod alarm clock-Pool view-450 sqft
      - 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
      - id4372
      - typeOTH
      - hotel_id1121
      - nameOrgandie-Deluxe Balcony Garden
      - descriptionDeluxe Balcony Garden Room-1 king size bed-Wood floor-Minibar-Internet-42 inch Lcd tv-Bathroom amenities-Working desk-Digital ipod alarm clock-Garden view over 3000 plants-470 sqft
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
    - 4
      - id4373
      - typeOTH
      - hotel_id1121
      - nameMousseline-Grand Deluxe Balcony
      - descriptionGrand Deluxe Balcony Room-2 double size beds-Wood floor-Minibar-Internet-42 inch plasma tv-Bathroom amenities-Working desk-Digital ipod alarm clock-550 sqft
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
    - 5
      - id4374
      - typeOTH
      - hotel_id1121
      - nameZiberline-Grand Deluxe Balcony
      - descriptionGrand Deluxe Balcony Suite-1 king size bed-Wood floor-Minibar-Internet-42 inch plasma tv-Bathroom amenities-Working desk-Digital ipod alarm clock-625 sqft
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
    - 6
      - id4375
      - typeOTH
      - hotel_id1121
      - nameGazar-The Penthouse Suite
      - description(null)
      - name_fre(null)
      - description_fre(null)
      - lowest_rate(null)
      - lr_currency(null)
      - lr_people(null)
      - breakfast_included(null)
      - half_board(null)
      - all_inclusive0
      - full_board0
      - accomodation_only0
  - RatesPeriod(empty)
  - Unavailability(empty)
  - Comment(empty)
  - Favorite(empty)
  - Taglines
    - 0
      - id1879
      - localeeng
      - modelHotel
      - foreign_key1121
      - fieldtagline
      - content
    - 1
      - id1880
      - localefre
      - modelHotel
      - foreign_key1121
      - fieldtagline
      - content
  - Envie
    - 0
      - id8
      - created2011-05-17 19:25:43
      - modified2011-05-17 19:25:43
    - 1
      - id15
      - created2011-05-17 19:27:34
      - modified2011-05-17 19:27:34
    - 2
      - id18
      - created2011-05-17 19:28:28
      - modified2011-05-17 19:28:28
    - 3
      - id19
      - created2011-05-24 08:21:45
      - modified2011-05-24 08:21:45
    - 4
      - id21
      - created2011-05-24 08:23:14
      - modified2011-05-24 08:23:14
pageTitleHôtels de charme à travers le monde
userData(null)
$this->data
- Hotel(empty)
$this->validationErrors(empty)
Loaded Helpers
- 0paginator
- 1simpleGraph
- 2number
- 3htmlToolbar
- 4toolbar
- 5tree
- 6cleaner
- 7commentWidget
- 8javascript
- 9imageCache
- 10text
- 11i18n
- 12globesecret
- 13arraySplitter
- 14time
- 15jqueryEngine
- 16form
- 17js
- 18session
- 19favorites
- 20shareThis
- 21breadcrumbs
- 22html
- 23assetCompress

====

Rechercher une expérience

Se laisser guider

Rechercher un hôtel de charme

Rechercher par envie

Par pays

Hôtels de charme à travers le monde

5 résultats correspondent à votre recherche

Colombie, Cartagena

El Marques Hotel Boutique

Colombie, Cartagena

Alfiz Hotel

Colombie, Bogotá

Hotel de la Opera

Colombie, Cartagena

San Pedro de Majagua

Colombie, Cartagena De Indias

Tcherassi Hotel and Spa

Rechercher par envie

Les promesses Globe Secret

Des hôtels de charme a taille humaine

RESERVATION SANS FRAIS

DES CRITERES DE CHOIX UNIQUES

PLUS DE SERVICES A LA CARTE

default

Query Explain:

Memory

Timers

Rechercher une expérience

Se laisser guider

Rechercher un hôtel de charme

Rechercher par envie

Par pays

Hôtels de charme à travers le monde

5 résultats correspondent à votre recherche

Colombie, Cartagena

El Marques Hotel Boutique

Colombie, Cartagena

Alfiz Hotel

Colombie, Bogotá

Hotel de la Opera

Colombie, Cartagena

San Pedro de Majagua

Colombie, Cartagena De Indias

Tcherassi Hotel and Spa

Rechercher par envie

Les promesses Globe Secret

Des hôtels de charme a taille humaine

RESERVATION SANS FRAIS

DES CRITERES DE CHOIX UNIQUES

PLUS DE SERVICES A LA CARTE

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables