137 Pillars House

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

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent96a2135195cee4dc19bc11b4bba8d8cd
  time1679666317
  timeout10
  languageeng
====
Request
+ –
Request

Cake Params
- controllerhotels
- actionview
- languageen
- named(empty)
- pass
 01430
 1137-pillars-house
- plugin(null)
- url
 exthtml
 urlen/hotels/view/1430/137-pillars-house
- form(empty)
- isAjax(false)
$_GET
- urlen/hotels/view/1430/137-pillars-house
Cookie
- languageen
Current Route
- keys
 0language
 1controller
 2action
- options
 languageen|fr
- defaults
 plugin(null)
 actionindex
- template/:language/:controller/:action/*
- _greedy(true)
- _compiledRoute#^(?:/(en|fr))/(?:([^/]+))/(?:([^/]+))(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
 typecontent_type
 methodrequest_method
 serverserver_name
====

Sql Log

+ –

Sql Logs

default

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 `Hotel`., `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`) WHERE `Hotel`.`id` = 1430 LIMIT 1	1	1	1
SELECT `City`.`id`, `City`.`country_id`, `City`.`state_id`, `City`.`maintrack_id`, `City`.`name`, `City`.`main_key` FROM `cities` AS `City` WHERE `City`.`id` = 251	1	1	0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'TH'	1	1	0
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` = (1430)	9	9	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` = (1430)	2	2	1	maybe slow
SELECT `RoomsRate`.`id`, `RoomsRate`.`rates_period_id`, `RoomsRate`.`room_id`, `RoomsRate`.`rate_regular`, `RoomsRate`.`rate_special`, `RoomsRate`.`rate_currency`, `RoomsRate`.`created`, `RoomsRate`.`modified` FROM `rooms_rates` AS `RoomsRate` WHERE `RoomsRate`.`room_id` IN (5587, 5588)	0	0	0
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`to` >= NOW() AND `RatesPeriod`.`hotel_id` = (1430) ORDER BY `RatesPeriod`.`from` ASC LIMIT 5	0	0	0
SELECT `News`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content` FROM `news` AS `News` INNER JOIN `i18n` AS `I18n__name` ON (`News`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'News' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__description` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'News' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__link` ON (`News`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'News' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') WHERE `News`.`country_id` = 'TH' ORDER BY `News`.`created` DESC	0	0	1	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`.`published` = 1 AND `Hotel`.`id` != 1430 AND `Hotel`.`longitude` BETWEEN 98.052802676475 AND 99.95529287058 AND `Hotel`.`latitude` BETWEEN 17.891518523591 AND 19.692594442432 ORDER BY ABS(`Hotel`.`longitude` - 99.0040477735275) + ABS(`Hotel`.`latitude` - 18.7920564830117) ASC LIMIT 3	3	3	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 (1469, 789, 279)	34	34	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 (1469, 789, 279)	10	10	2	maybe slow
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (1469, 789, 279)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1469, 789, 279)	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 (1469, 789, 279)	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 (1469, 789, 279)	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 (1469, 789, 279)	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 (1469, 789, 279) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	15	15	1	maybe slow
SHOW FULL COLUMNS FROM `events`	18	18	0
SHOW FULL COLUMNS FROM `home_events`	4	4	0
SHOW FULL COLUMNS FROM `event_images`	5	5	0
SHOW FULL COLUMNS FROM `themes`	4	4	0
SHOW FULL COLUMNS FROM `theme_i18n`	6	6	0
SHOW FULL COLUMNS FROM `events_hotels`	2	2	0
SHOW FULL COLUMNS FROM `events_themes`	2	2	0
SHOW FULL COLUMNS FROM `event_i18n`	6	6	0
SELECT `Event`., `HomeEvent`., `CreatedUser`., `Country`., `State`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18n__name` ON (`Event`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Event' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__description` ON (`Event`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Event' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__link` ON (`Event`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Event' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE ((`Event`.`end` IS NULL) OR (`Event`.`end` >= NOW())) AND `Event`.`longitude` BETWEEN 98.052802676475 AND 99.95529287058 AND `Event`.`latitude` BETWEEN 17.891518523591 AND 19.692594442432 ORDER BY ABS(`Event`.`longitude` - 99.0040477735275) + ABS(`Event`.`latitude` - 18.7920564830117) ASC LIMIT 10	5	5	12	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (1347, 1500, 1504, 1502, 1501)	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 (1347, 1500, 1504, 1502, 1501)	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` = 'Event' AND `Favorite`.`foreign_key` IN (1347, 1500, 1504, 1502, 1501)	0	0	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `event_i18n` AS `Names` WHERE `model` = 'Event' AND `field` = 'name' AND `Names`.`foreign_key` IN (1347, 1500, 1504, 1502, 1501)	10	10	0
SELECT `Descriptions`.`id`, `Descriptions`.`locale`, `Descriptions`.`model`, `Descriptions`.`foreign_key`, `Descriptions`.`field`, `Descriptions`.`content` FROM `event_i18n` AS `Descriptions` WHERE `model` = 'Event' AND `field` = 'description' AND `Descriptions`.`foreign_key` IN (1347, 1500, 1504, 1502, 1501)	10	10	0
SELECT `Links`.`id`, `Links`.`locale`, `Links`.`model`, `Links`.`foreign_key`, `Links`.`field`, `Links`.`content` FROM `event_i18n` AS `Links` WHERE `model` = 'Event' AND `field` = 'link' AND `Links`.`foreign_key` IN (1347, 1500, 1504, 1502, 1501)	10	10	0
SELECT `Hotel`.`id`, `Hotel`.`starred`, `Hotel`.`in`, `Hotel`.`maintrack_hotel_id`, `Hotel`.`brand_code`, `Hotel`.`name`, `Hotel`.`address`, `Hotel`.`zip_code`, `Hotel`.`cityarea_id`, `Hotel`.`city_id`, `Hotel`.`region_id`, `Hotel`.`state_id`, `Hotel`.`country_id`, `Hotel`.`latitude`, `Hotel`.`longitude`, `Hotel`.`zoom`, `Hotel`.`rating`, `Hotel`.`phone`, `Hotel`.`reservation_phone`, `Hotel`.`fax`, `Hotel`.`email`, `Hotel`.`created`, `Hotel`.`modified`, `Hotel`.`description`, `Hotel`.`description_fre`, `Hotel`.`amenity`, `Hotel`.`amenity_fre`, `Hotel`.`lowest_rate`, `Hotel`.`lr_currency`, `Hotel`.`lr_people`, `Hotel`.`comment_count`, `Hotel`.`cancellation_policy`, `Hotel`.`cancellation_policy_fre`, `Hotel`.`published`, `EventsHotel`.`event_id`, `EventsHotel`.`hotel_id` FROM `hotels` AS `Hotel` JOIN `events_hotels` AS `EventsHotel` ON (`EventsHotel`.`event_id` IN (1347, 1500, 1504, 1502, 1501) AND `EventsHotel`.`hotel_id` = `Hotel`.`id`)	0	0	0
SELECT `Theme`.`id`, `Theme`.`created`, `Theme`.`modified`, `Theme`.`uri`, `EventsTheme`.`event_id`, `EventsTheme`.`theme_id` FROM `themes` AS `Theme` JOIN `events_themes` AS `EventsTheme` ON (`EventsTheme`.`event_id` IN (1347, 1500, 1504, 1502, 1501) AND `EventsTheme`.`theme_id` = `Theme`.`id`)	0	0	0
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC	256	256	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
SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 1430 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham')	1	1	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`, `Hotel`.`id`, `UserModel`.`id`, `UserModel`.`first_name`, (CONCAT(`UserModel`.`first_name`, ' ', `UserModel`.`name`)) AS `UserModel__full_name`, (`UserModel`.`id`) AS `UserModel__slug` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 1430 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5	0	0	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

+ –

Memory

Peak Memory Use 25.78 MB

Message	Memory use
Component initialization	14.31 MB
Controller action start	14.48 MB
Controller render start	16.16 MB
View render complete	20.01 MB

Timers

Total Request Time: 483 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	73.05
Component initialization and startup	3.79
Controller action	184.89
Render Controller Action	105.74
» Rendering View	101.99
» » Rendering APP/views/hotels/view.ctp	45.93
» » » Rendering APP/views/elements/sharing_widget.ctp	0.28
» » » Rendering APP/views/elements/comments/flat/main.ctp	0.44
» » » Rendering APP/views/elements/hotels/form_reservation.ctp	3.45
» » » Rendering APP/views/elements/events/related.ctp	1.48
» » » Rendering APP/views/elements/events/related.ctp #2	1.50
» » » Rendering APP/views/elements/events/related.ctp #3	1.51
» » » Rendering APP/views/elements/events/related.ctp #4	1.53
» » » Rendering APP/views/elements/events/related.ctp #5	1.51
» » » Rendering APP/views/elements/events/legend.ctp	3.52
» » » Rendering APP/views/elements/hotels/related.ctp #6	0.63
» » » Rendering APP/views/elements/hotels/related.ctp #7	0.57
» » » Rendering APP/views/elements/hotels/related.ctp #8	0.51
» » Rendering APP/views/layouts/default.ctp	55.82
» » » Rendering APP/views/elements/google_analytics.ctp	0.09
» » » Rendering APP/views/elements/layout/top.ctp	1.42
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0.32
» » » Rendering APP/views/elements/layout/header.ctp	48.73
» » » Rendering APP/views/elements/layout/extra.ctp	0.23
» » » Rendering APP/views/elements/layout/footer.ctp	4.15
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0.32
» » » Rendering APP/views/elements/layout/footnotes.ctp	0.09

====

Log

+ –

Logs

warning

Time	Message
2023-03-24 04:58:37	Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: StartTag: invalid element name in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92]
2023-03-24 04:58:37	Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: Extra content at the end of the document in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92]

error

Time	Message
2023-03-24 04:58:37	Impossible to access the Google API
2023-03-24 04:58:37	Impossible to access the Google API

====

Variables
+ –
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)
- hotel
 Hotel
 id1430
 starred0
 in0
 maintrack_hotel_id(null)
 brand_code
 name137 Pillars House
 address2 soi 1, nawatgate road, tambon watgate, muang
 zip_code50000
 cityarea_id(null)
 city_id251
 region_id(null)
 state_id(null)
 country_idTH
 latitude18.7920564830117
 longitude99.0040477735275
 zoom13
 rating0
 phone(null)
 reservation_phone(null)
 fax(null)
 email(null)
 created2012-01-14 18:58:22
 modified2012-01-17 14:49:58
 description137 Pillars House revives the old world elegance of the Orient and invites guests to enjoy every modern luxury. You are our personal guests. As such, we will be honored to lead you through the surrounding charms of Chiang Mai and welcome you home into pampered privacy. Our home-style residential concept allows visitors to participate and share in the richness of a likeminded international community while creating plenty of space for sublime intimacy in sumptuous suites and throughout our tropical grounds. Our ambition is that guests of 137 Pillars House will collect meaningful experiences that remain in their hearts long after they leave us. More than building a very comfortable place to sleep, we sincerely hope to create exceptional memories for every guest on every single day.
 description_fre137 Pillars House ravive l'élégance du vieux monde de l'Orient et vous invite à profiter de tout le luxe moderne. Vous êtes nos invités personnels. En tant que tel, nous serons honorés de vous guider à travers les charmes des environs de Chiang Mai et vous accueillir chez nous en toute intimité. Notre maison de style permet aux visiteurs de participer et de partager la richesse d'une communauté ayant les mêmes idées internationales tout en créant beaucoup d'espace pour l'intimité dans de somptueuses suites et tout au long de nos jardins tropicaux. Notre ambition est que les invités de 137 Pillars House recueillent des expériences significatives qui restera longtemps dans leur cœur. Plus qu'un simple endroit très confortable pour dormir, nous espérons sincèrement créer des souvenirs exceptionnels pour chaque invité.
 amenityLibrary room, bar, lounge, gym, garden, swimming pool, internet, city.
 amenity_freSalle de la bibliothèque, bar, salon, salle de gym, jardin, piscine, internet, de la ville.
 lowest_rate7420.00
 lr_currencyTHB
 lr_people2
 comment_count0
 cancellation_policyPayment: Full payment is required 7 days before guest arrival. In the case of credit arrangement, the terms and conditions are indicated in the credit applicationform and agreement. No‐Shows: Same day cancellations or in the event of a no-show, the entire duration of stay shall be chargeable to the guest. Cancellations: Any cancellation should be notified in writing to the reservation office subject to the following: 30 Dec 11 – 30 Apr 12: 7 nights prior the arrival 01 May 12 – 31 Oct 12: 3 nights prior the arrival Any shorter cancellations will result in the following: Shorter cancellations than the above mentioned and up to 24 hours parrival date result in 100% penalty for the first night’s room charge. Group booking cancellation received within 30 days prior to the date of be subject to a 100% (of the confirmed room nights) cancellation charge. Check-in and Check-out times: Check in time is15h00 (local time) and check out time is 12h00 (local time). The suites confirmed as reserved will be available for occupation by the guest at check-in time on the date of arrival until check out time on the date of departure. Rates are in Thai Baht and inclusive of daily breakfast, and based on the maximum occupancy of 2 persons per room (double occupancy).
 cancellation_policy_freModes de paiement: Le paiement complet est requis 7 jours avant l'arrivée invité. Dans le cas de Non-présentation: Annulations le jour même ou dans le cas d'un no-show, toute la durée de séjour seront à la charge du client. Annulations: Toute annulation doit être notifiée par écrit au bureau de réservation le sujet de ce qui suit: 30 Dec 11 au 30 avril, 12: 7 nuits avant l'arrivée 01 May 12 au 31 octobre 12: 3 nuits avant l'arrivée Toute annulation courte entraînera la suivante: frais d'annulation (de l'nuitées confirmer). Check-in et check-out: Vérifiez en temps is15h00 (heure locale) et l'heure de départ est 12h00 (heure locale). Les suites confirmé réservés seront disponibles pour occupation par l'invité à l'enregistrement en temps à la date d'arrivée jusqu'à l'heure de départ à la date de départ. Les tarifs sont exprimés en baht thaïlandais et comprennent le petit déjeuner, et basé sur l'occupation maximum de 2 personnes par chambre (occupation double).
 published1
 localeeng
 tagline
 City
 id251
 country_idTH
 state_id(null)
 maintrack_idCHIANGMAI
 nameChiang Mai
 main_key
 Country
 idTH
 nameThailand
 name_freThaïlande
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id21063
 hotel_id1430
 order8
 urispa_pavilion0.jpg
 ratio_hw1.49
 on_wall0
 1
 id21064
 hotel_id1430
 order9
 urimassage_room0.jpg
 ratio_hw0.67
 on_wall0
 2
 id21062
 hotel_id1430
 order7
 urireception_pavilion0.jpg
 ratio_hw0.67
 on_wall0
 3
 id21060
 hotel_id1430
 order5
 urirajah_brooke_suite0.jpg
 ratio_hw0.67
 on_wall0
 4
 id21061
 hotel_id1430
 order6
 uri12_137_pillars_high0.jpg
 ratio_hw0.67
 on_wall0
 5
 id21059
 hotel_id1430
 order4
 uri07_137_pillars_high0.jpg
 ratio_hw0.67
 on_wall0
 6
 id21057
 hotel_id1430
 order2
 uriall_day_dining0.jpg
 ratio_hw0.67
 on_wall0
 7
 id21058
 hotel_id1430
 order3
 uri16_137_pillars_high0.jpg
 ratio_hw0.67
 on_wall0
 8
 id21056
 hotel_id1430
 order1
 uri08_137_pillars_high0.jpg
 ratio_hw0.67
 on_wall0
 Room
 0
 id5587
 type
 hotel_id1430
 nameRAJAH BROOKE SUITE
 description
 name_freSUITE RAJAH BROOKE
 description_fre
 lowest_rate7420.00
 lr_currencyTHB
 lr_people2
 breakfast_included1
 half_board0
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 1
 id5588
 type
 hotel_id1430
 nameEAST BORNEO SUITE
 description
 name_freSUITE EAST BORNEO
 description_fre
 lowest_rate8600.00
 lr_currencyTHB
 lr_people2
 breakfast_included1
 half_board0
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 RatesPeriod(empty)
 Weather(false)
 News(empty)
- relatedHotels
 0
 Hotel
 id1469
 starred0
 in0
 maintrack_hotel_id506363
 brand_codeEP
 namePuripunn Baby Grand Boutique Hotel
 address104 1 Chareon Muang soi 2
 zip_code50000
 cityarea_id(null)
 city_id251
 region_id(null)
 state_id(null)
 country_idTH
 latitude18.788912721443303
 longitude99.0066356865082
 zoom13
 rating0
 phone66 53 302898
 reservation_phone(null)
 fax66 53 303121
 emailinfo@puripunn.com
 created2012-02-07 18:32:00
 modified2012-02-08 13:42:26
 descriptionDiscover the secluded grace of this intimate retreat in Thailands far north. Puripunn Baby Grand Boutique Hotel is the ultimate luxury property, set amidst the backdrop of Chiang Mai's rich architectural history; inspired by traditional Lanna design and fused with contemporary Oriental styles. Surrounded by the preserved gems of ancient Lanna society, the northern way of life remains in tact, as it has done for centuries. Puripunn Hotel is situated in a small soi, immersed in local heritage, giving you the chance to relish the serene ambience of the area. The hotel has 30 rooms designed to complement the proximate natural aesthetics of Wat Gate while respecting the time-honored techniques of northern architects. Homely and refined, you will feel at ease in this enigmatic property. Rooms from Deluxe up to Suite with private pool are spacious with high ceilings and wooden floors. Each room has its own terrace with oversize cozy bench overlooking the pool and a colonial inspired easy chair. The terrace is a favorite place for guests to sit back and relax all day long. Sample the delights of Thai fare at Punna Cafe, where the finest local dishes are served along with decadent international cuisine. Puripunn Traditional High Tea is a unique high tea that adds Thai touch with a real Thai test which you would never expect elsewhere. The Pool Lounge is the place to be for drinks and snacks all day long, with a full menu of cocktails served from 6 p.m. till midnight. Feeling worn out Then head straight to Sala Spa for a unique Puripunn aroma massage; A fusion of Thai, Swedish and Balinese styles. The spa also offers traditional Thai massage, as well as foot massage, pedicure and manicure. Let our staff attend to your every need and desire.
 description_freDécouvrez le charme isolé de cette retraite intime dans l'extrême nord de la Thailande. Le Puripunn Baby Grand Boutique Hôtel est la propriété de luxe ultime, situé au cœur du riche patrimoine de Chiang Mai, inspiré par la conception traditionnelle Lanna qui fusionne avec des styles contemporains orientales. Entouré par un art de vivre intact du nord, comme il fut pendant des siècles. L'hôtel Puripunn est plongé dans le patrimoine local, en vous donnant la chance de goûter une atmosphère sereine. L'hôtel dispose de 30 chambres conçues pour compléter l'esthétique naturelle de Wat tout en respectant les techniques séculaires des architectes du Nord. Accueillant et raffiné, vous vous sentirez à l'aise dans cette propriété énigmatique. Les chambres avec piscine privée sont spacieuses avec de hauts plafonds et des planchers en bois. Chaque chambre possède sa propre terrasse avec un banc confortable donnant sur la piscine et une chaise coloniale inspirée. La terrasse est un lieu de prédilection pour s'asseoir et se détendre. Goûtez aux délices thaïlandais au Punna Cafe, où les meilleurs plats locaux sont servis avec une cuisine internationale. Le spa propose également des massages thaïlandais traditionnels, ainsi que des massages des pieds, pédicure et manucure. Laissez notre personnel répondre à tous vos besoin.
 amenityCar Rental Desk, Tour Desk, Conference Facilities, Health Club, Massage, Fitness Center or Spa, Breakfast Buffet, Room Service, 24 Hour Front Desk, Porters, Wake-up Service, Air Conditioned, Connecting Rooms, Hairdryers Available, No Smoking Rooms/Facilities, Private Bathroom, Security, Free Parking, Indoor Parking, Parking, Valet Parking, Jacuzzi, Outdoor Pool, Coffee Shop, Lounge, Restaurant, 24 Hour Security, Doctor on Call, Maid Service, Laundry/Valet Services, Handicapped Rooms/Facilities, AM/FM Alarm Clock, Terrace, Bathrobes, Television with Cable, Coffee Maker in Room, TV, Desk with lamp, In Room Movies, High speed internet access, Mini Bar, TV Remote Control, Safe, Shower, Phone with speaker, Telephone, Wireless Internet Access, CD Player, Ceiling Fan, Outlet Adapters, DVD Player, Satellite TV, Audio Visual Equipment, Meeting/Banquet Facilities, Secretarial Service, Meal Plan - MAP/Half-board, City Center, Smoke Detectors.
 amenity_freLocation de voitures, bureau d'excursions, Salles de conférence, club de santé, Massage, Centre de fitness ou Spa, petit déjeuner buffet, service en chambre, 24 Hour Front Desk, Porters, Service de réveil, l'air conditionné, chambres communicantes, sèche-cheveux disponibles, Chambres non fumeurs ou des installations, salle de bains privée, de sécurité, parking gratuit, parking intérieur, parking, service de voiturier, jacuzzi, piscine extérieure, Coffee Shop, lounge, restaurant, 24 heures de sécurité, médecin de garde, Maid Service, blanchisserie / valet services, chambres pour handicapés / installations, réveil AM / FM, Terrasse, peignoirs, télévision avec câble Cafetière, dans la salle, TV, bureau avec lampe, Films dans la chambre, accès Internet haut débit, mini bar, TV Remote Control, Coffre-fort, Douche, Téléphone avec haut-parleur, Téléphone, accès Internet sans fil, lecteur CD, ventilateur de plafond, Adaptateurs électriques, lecteur DVD, TV par satellite, matériel audiovisuel, salles de réunions / banquets, service de secrétariat, Repas - MAP / Demi-pension, Centre Ville, des détecteurs de fumée.
 lowest_rate5123.00
 lr_currencyTHB
 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
 id251
 country_idTH
 state_id(null)
 maintrack_idCHIANGMAI
 nameChiang Mai
 main_key
 Country
 idTH
 nameThailand
 name_freThaïlande
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id21614
 hotel_id1469
 order2
 urihttp://images.pegs.com/imageRepo/1/0/33/335/606/Deluxe%20Room_J.jpg
 ratio_hw0.67
 on_wall0
 1
 id21615
 hotel_id1469
 order3
 urihttp://images.pegs.com/imageRepo/1/0/33/335/626/Puripunn%20Deluxe%2002_J.jpg
 ratio_hw0.67
 on_wall0
 2
 id21617
 hotel_id1469
 order5
 urihttp://images.pegs.com/imageRepo/1/0/33/335/653/Puripunn%20Grand%20Suite%20-%20Living%20area%2002_J.jpg
 ratio_hw0.67
 on_wall0
 3
 id21618
 hotel_id1469
 order6
 urihttp://images.pegs.com/imageRepo/1/0/33/335/644/Baby%20Suite_J.jpg
 ratio_hw0.68
 on_wall0
 4
 id21619
 hotel_id1469
 order7
 urihttp://images.pegs.com/imageRepo/1/0/33/335/662/Puripunn%20Family%20master%20horizontal_J.jpg
 ratio_hw0.75
 on_wall0
 5
 id21620
 hotel_id1469
 order8
 urihttp://images.pegs.com/imageRepo/1/0/33/335/671/Puripunn%20Overview%2004_J.jpg
 ratio_hw0.67
 on_wall0
 6
 id21621
 hotel_id1469
 order9
 urihttp://images.pegs.com/imageRepo/1/0/33/335/680/Puripunn%20Overview%2002_J.jpg
 ratio_hw0.67
 on_wall0
 7
 id21623
 hotel_id1469
 order11
 urihttp://images.pegs.com/imageRepo/1/0/33/335/698/Pool%20Lounge_J.jpg
 ratio_hw0.69
 on_wall0
 8
 id21626
 hotel_id1469
 order14
 urihttp://images.pegs.com/imageRepo/1/0/33/335/725/Deluxe%20Balcony_J.jpg
 ratio_hw0.66
 on_wall0
 9
 id21628
 hotel_id1469
 order16
 urihttp://images.pegs.com/imageRepo/1/0/33/335/743/Deluxe%20room%2002_J.jpg
 ratio_hw0.66
 on_wall0
 10
 id21629
 hotel_id1469
 order17
 urihttp://images.pegs.com/imageRepo/1/0/33/335/752/023_J.jpg
 ratio_hw0.75
 on_wall0
 11
 id21630
 hotel_id1469
 order18
 urihttp://images.pegs.com/imageRepo/1/0/33/335/761/Puripunn%20Family%20Single%20Bed%20room_J.jpg
 ratio_hw0.66
 on_wall0
 12
 id21632
 hotel_id1469
 order20
 urihttp://images.pegs.com/imageRepo/1/0/33/335/779/Puripunn%20Deluxe%20Terrace%2001_J.jpg
 ratio_hw0.66
 on_wall0
 13
 id21633
 hotel_id1469
 order21
 urihttp://images.pegs.com/imageRepo/1/0/33/335/788/Baby%20Suite%20207%20bedroom_J.jpg
 ratio_hw0.66
 on_wall0
 14
 id21634
 hotel_id1469
 order22
 urihttp://images.pegs.com/imageRepo/1/0/33/335/797/Baby%20Suite%20Living%20Room%2005_J.jpg
 ratio_hw0.63
 on_wall0
 15
 id21635
 hotel_id1469
 order23
 urihttp://images.pegs.com/imageRepo/1/0/33/335/806/Puripunn%20Family%20Small%20Bedroom_J.jpg
 ratio_hw0.66
 on_wall0
 16
 id21638
 hotel_id1469
 order26
 urihttp://images.pegs.com/imageRepo/1/0/33/335/833/DSC02071CMYK_resize_J.jpg
 ratio_hw0.75
 on_wall0
 Room
 0
 id5709
 typeOTH
 hotel_id1469
 nameBaby Suite
 descriptionBaby Suite-1 King Bed with Living Area
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 1
 id5710
 typeOTH
 hotel_id1469
 nameDeluxe Twin Bed
 descriptionDeluxe-Twin 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
 id5711
 typeOTH
 hotel_id1469
 nameDeluxe King Bed
 descriptionDeluxe-King 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
 id5712
 typeOTH
 hotel_id1469
 namePuripunn Deluxe
 descriptionPuripunn Deluxe-1 King Bed The Signature Room Type
 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
 id5713
 typeOTH
 hotel_id1469
 namePuripunn Family
 descriptionPuripunn Family-1 King Bed 1 Single Bedding
 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
 id5714
 typeOTH
 hotel_id1469
 namePuripunn Grand 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
 id2529
 localeeng
 modelHotel
 foreign_key1469
 fieldtagline
 content
 1
 id2530
 localefre
 modelHotel
 foreign_key1469
 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
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 4
 id29
 created2011-10-11 17:12:25
 modified2011-10-11 17:12:25
 1
 Hotel
 id789
 starred0
 in0
 maintrack_hotel_id374041
 brand_codeKY
 nameBanthai Village
 address19 Tapae Soi, 3 Changklan, Muang
 zip_code50100
 cityarea_id(null)
 city_id251
 region_id(null)
 state_id(null)
 country_idTH
 latitude18.789968
 longitude98.997375
 zoom13
 rating0
 phone66 53 252789
 reservation_phone(null)
 fax66 53 252788
 emailinfo@banthaivillage.com
 created2011-08-03 09:47:58
 modified2011-08-09 08:53:22
 descriptionBanthai Village is the mini size hotel that tries to keep balance between the tradition and modernity among the changes of the world. This modern-Lanna decorated hotel, consisting of 23 rooms in 4 types, will give you a sense of nostalgic community. At night, the fantastic light from The Brooze Bar and swimming pool will add more appetite to your meals. If you like furniture and decorative items in Banthai Village Style, do not miss to visit The Bua Ban Shop opposite to the hotel. The warm and friendly atmospheres are awaiting you at Banthai Village.
 description_freLes clients du Banthai Village Hotel de Chiang Mai profiteront de son emplacement idéal, à 10 minutes de l'aéroport et à proximité du centre-ville. Cet hôtel de 2 étages dispose de 23 chambres toutes équipées d'aménagements dernier cri. Chaque chambre dispose, entre autres aménagements, de: climatisation, peignoirs, journal quotidien, films à la demande, bureau, sèche-cheveux. Les clients apprécieront les superbes infrastructures et services de l'hôtel, notamment bar, service de buanderie, restaurant, service en chambres, coffres forts, transfert aéroport, guichet voyage. Les clients qui recherchent des infrastructures sportives et de loisirs de qualité pourront profiter de massage, jacuzzi, piscine extérieure, jardin.
 amenityAir Conditioned, Car Rental Desk, 24 Hour Front Desk, Elevators, Free Parking, Outdoor Pool, Poolside Snackbar, Outdoor Parking, Restaurant, Laundry/Valet Services, Wake-up Service, DVD Player, Wireless Internet Access, Hairdryers Available, Mini Bar, No Smoking Rooms/Facilities, Safe, Telephone, City Center.
 amenity_freClimatisation, Voiture de location bureau, réception ouverte 24 heures, ascenseurs, parking gratuit, piscine extérieure, piscine snack, parking extérieur, restaurant, blanchisserie / Services, Service de réveil, lecteur DVD, accès Internet sans fil, sèche-cheveux disponibles, Mini Bar, non fumeurs Chambres / Équipements, Coffre-fort, Téléphone, Centre Ville.
 lowest_rate0.00
 lr_currency
 lr_people0
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localeeng
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id251
 country_idTH
 state_id(null)
 maintrack_idCHIANGMAI
 nameChiang Mai
 main_key
 Country
 idTH
 nameThailand
 name_freThaïlande
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id13044
 hotel_id789
 order1
 uri1301460496-00.jpg
 ratio_hw0.67
 on_wall0
 1
 id13045
 hotel_id789
 order2
 uri1301468153-20.jpg
 ratio_hw0.67
 on_wall0
 2
 id13046
 hotel_id789
 order3
 uri1301467858-00.jpg
 ratio_hw0.67
 on_wall0
 3
 id13047
 hotel_id789
 order4
 uri1301462310-50.jpg
 ratio_hw0.67
 on_wall0
 4
 id13048
 hotel_id789
 order5
 uri1301462310-20.jpg
 ratio_hw0.67
 on_wall0
 5
 id13049
 hotel_id789
 order6
 uri1301462310-10.jpg
 ratio_hw0.67
 on_wall0
 6
 id13050
 hotel_id789
 order7
 uri1301460496-40.jpg
 ratio_hw0.67
 on_wall0
 7
 id13051
 hotel_id789
 order8
 uri1301460496-10.jpg
 ratio_hw0.67
 on_wall0
 Room(empty)
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id1217
 localeeng
 modelHotel
 foreign_key789
 fieldtagline
 content
 1
 id1218
 localefre
 modelHotel
 foreign_key789
 fieldtagline
 content
 Envie
 0
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 1
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 2
 id18
 created2011-05-17 19:28:28
 modified2011-05-17 19:28:28
 3
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 2
 Hotel
 id279
 starred0
 in0
 maintrack_hotel_id328707
 brand_codeWB
 nameThe Rachamankha
 address6 RACHAMANKHA 9
 zip_code50200
 cityarea_id(null)
 city_id251
 region_id(null)
 state_id(null)
 country_idTH
 latitude18.7903
 longitude98.981697
 zoom13
 rating0
 phone66 53 904111
 reservation_phone1 800 735-2478
 fax66 53 904114
 email(null)
 created2011-05-13 21:08:12
 modified2011-07-05 18:07:50
 descriptionThe town of Chiang Mai, known as the Rose of the North, is the setting for a gem of Asian hospitality. Designed by Mr. Ong ard Satrabhundu and Mr. Rooj Changtrakul two of Thailand's top architects and designers the Rachamankha's architecture takes inspiration from Wat Phratat Lampang Luang, north Thailand's finest extant Lanna period temple. The hotel guestrooms border two beautiful inner courtyards, guarded by Ming Dynasty lions and planted with beautiful and aromatic plumeria trees and decorative betel nut palms. The centrepiece between the two guestroom courtyards is the Lobby, an elegant 400 year old timber structure, a masterpiece of the Lanna period: a wonderful private space for guests. Privacy, serenity and a sense of place are the keynotes of Rachamankha; a home away from home within the Lanna kingdom, perfectly placed to explore north Thailand's rich culture and heritage. The hotel, just 22 rooms and 2 suites, is set in 2 acres of manicured grounds and the architecture pays homage to Chiang Mai’s golden age, the Lanna period, offering guests a unique stay in a unique property with a true sense of place. Rachamankha is also the only Relais and Châteaux in northern Thailand.
 description_freLa ville de Chiang Mai, connu sous le nom de la Rose du Nord, est le théâtre d'un joyau de l'hospitalité asiatique. Conçu par M. Ong ard Satrabhundu et M. Rooj Changtrakul deux des plus grands architectes et designers de la Thaïlande l'architecture de la Rachamankha s'inspire de Wat Phratat Lampang Luang, au nord de la Thaïlande, les plus beaux temple existant de la période de Lanna. Les chambres de l'hôtel sont autour de deux très belles cours intérieures protégées par des lions de la dynastie Ming et plantées de merveilleux frangipaniers aromatiques et de palmistes décoratifs. La pièce centrale entre les deux cours bordées de chambres est le lobby, une élégante structure en bois de 400 ans, un chef-d'œuvre de la période de Lanna: un merveilleux espace privé pour les clients. Intimité, sérénité et un sentiment d'appartenance sont les maîtres mots de Rachamankha; une maison loin de chez eux dans le royaume de Lanna, parfaitement placé pour explorer le patrimoine culturel riche du nord de la Thaïlande. L'hôtel, à seulement 22 chambres et 2 suites, est situé dans un jardin de 2 hectares entretenu et l'architecture rend hommage à l'âge d'or de Chiang Mai, la période de Lanna, offrant aux clients un séjour unique dans une propriété unique avec un vrai sens du lieu. Rachamankha est également le seul Relais et Châteaux dans le nord de la Thaïlande.
 amenityLounge, Concierge, Pool, Restaurant, Room Service, Safe Deposit Box, Laundry/Valet Services, Meeting/Banquet Facilities, Tour Desk, Continental Breakfast, Conference Facilities, Copy Service, Wake-up Service, Air Conditioned, Hairdryers Available, Ironing Board, No Smoking Rooms/Facilities, Parking, Coffee Shop, News Stand, Car Rental Desk, Porters, Boutiques, Phone Service, Toilet, Doctor on Call, Fitness Center or Spa, Golf, TV, Mini Bar, AM/FM Alarm Clock, Terrace, Bathrobes, Television with Cable, Coffee Maker in Room, Desk with lamp, High speed internet access, Iron, TV Remote Control, Safe, Wireless Internet Access, DVD Player, Shops/Commercial Services, Audio Visual Equipment, FAX, Breakfast Buffet, City Center.
 amenity_freLounge, concierge, piscine, restaurant, service en chambre, Coffre-fort, service de blanchisserie, salles de réunions / banquets, bureau d'excursions, petit déjeuner continental, Salles de conférence, Service de photocopie, service de réveil, air conditionné, sèche-cheveux disponibles, planche à repasser , Chambres non fumeurs / équipements, parking, café-restaurant, stand Nouvelles, Location de voitures, porteurs, Boutiques, Service de téléphone, toilettes, Docteur à l'appel, Centre de fitness ou Spa, Golf, télévision, mini-bar, réveil AM / FM, Terrasse, peignoirs, télévision par câble, bouilloire dans la chambre, bureau avec lampe, accès Internet haut débit, fer à repasser, TV Remote Control, Coffre-fort, accès Internet sans fil, lecteur DVD, Boutiques / Commerces, Matériel audio-visuel, FAX, petit déjeuner buffet Centre Ville.
 lowest_rate16482.00
 lr_currencyTHB
 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
 id251
 country_idTH
 state_id(null)
 maintrack_idCHIANGMAI
 nameChiang Mai
 main_key
 Country
 idTH
 nameThailand
 name_freThaïlande
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id5009
 hotel_id279
 order2
 urihttp://images.pegs.com/imageRepo/1/0/28/284/261/F1000003_J.jpg
 ratio_hw0.67
 on_wall0
 1
 id5010
 hotel_id279
 order3
 urihttp://images.pegs.com/imageRepo/1/0/28/284/265/2FCQ9302_J.jpg
 ratio_hw0.67
 on_wall0
 2
 id5011
 hotel_id279
 order4
 urihttp://images.pegs.com/imageRepo/1/0/28/284/269/2FCQ9317_J.jpg
 ratio_hw0.67
 on_wall0
 3
 id5012
 hotel_id279
 order5
 urihttp://images.pegs.com/imageRepo/1/0/28/284/273/2FCQ9395_J.jpg
 ratio_hw0.67
 on_wall0
 4
 id5013
 hotel_id279
 order6
 urihttp://images.pegs.com/imageRepo/1/0/28/284/277/2FCQ9407_J.jpg
 ratio_hw0.67
 on_wall0
 5
 id5014
 hotel_id279
 order7
 urihttp://images.pegs.com/imageRepo/1/0/28/284/281/2FCQ9419_J.jpg
 ratio_hw0.67
 on_wall0
 6
 id5015
 hotel_id279
 order8
 urihttp://images.pegs.com/imageRepo/1/0/28/284/285/2FCQ9422_J.jpg
 ratio_hw0.67
 on_wall0
 7
 id5016
 hotel_id279
 order9
 urihttp://images.pegs.com/imageRepo/1/0/28/284/289/2FCQ9428_J.jpg
 ratio_hw0.67
 on_wall0
 8
 id5018
 hotel_id279
 order11
 urihttp://images.pegs.com/imageRepo/1/0/28/284/297/Rachamankha%20map_J.jpg
 ratio_hw0.56
 on_wall0
 Room
 0
 id1154
 typeOTH
 hotel_id279
 nameSuperior Double
 descriptionSuperior Double-1 King Size Bed-AC-LCD TV-Minibar-DVD-Electronic Safe-Wireless Internet Access
 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
 id1155
 typeOTH
 hotel_id279
 nameSuperior Twin
 descriptionSuperior Twin-2 Single Beds-AC-LCD TV-Minibar-DVD-Electronic Safe-Wireless Internet Access
 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
 id1156
 typeOTH
 hotel_id279
 nameDeluxe King
 descriptionDeluxe-40 Sq Metres-1 King Size Canopy Bed-DVD-Electronic Safe-Wireless Internet-Xbed Possible
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 3
 id1157
 typeOTH
 hotel_id279
 name2-Bedroom 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
 id221
 localeeng
 modelHotel
 foreign_key279
 fieldtagline
 content
 1
 id222
 localefre
 modelHotel
 foreign_key279
 fieldtagline
 content
 Envie
 0
 id2
 created2011-05-17 19:21:27
 modified2011-09-15 08:04:03
 1
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 2
 id9
 created2011-05-17 19:26:00
 modified2011-05-17 19:26:00
 3
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 4
 id18
 created2011-05-17 19:28:28
 modified2011-05-17 19:28:28
 5
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
- relatedEvents
 0
 Event
 id1347
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationCharoen Prathet, Chang Khlan, Mueang Chiang Mai, Province de Chiang Mai 50100, Thaïlande
 latitude18.7814
 longitude99.0037
 zoom13
 state_id(null)
 country_id
 created2011-10-31 15:09:13
 modified2011-10-31 15:09:13
 url(null)
 comment_count0
 former_business_id953
 localeeng
 nameTASTE THE KOW SOY
 descriptionDo not miss the Kow Soy: a bowl of curry noodles, which is a specialty of Chiang Mai. The best is Just Khao Soy in the neighborhood Prathet Charoen Road. The bowl contains pickled cabbage, red onions, crispy noodles and spicy broth, served on a wooden painter's palette. Each one then adds the condiments for his taste.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id8053
 localeeng
 modelEvent
 foreign_key1347
 fieldname
 contentTASTE THE KOW SOY
 1
 id8054
 localefre
 modelEvent
 foreign_key1347
 fieldname
 contentGOUTEZ AU KOW SOY
 Descriptions
 0
 id8055
 localeeng
 modelEvent
 foreign_key1347
 fielddescription
 contentDo not miss the Kow Soy: a bowl of curry noodles, which is a specialty of Chiang Mai. The best is Just Khao Soy in the neighborhood Prathet Charoen Road. The bowl contains pickled cabbage, red onions, crispy noodles and spicy broth, served on a wooden painter's palette. Each one then adds the condiments for his taste.
 1
 id8056
 localefre
 modelEvent
 foreign_key1347
 fielddescription
 contentNe ratez pas le Kow Soy: un bol de nouilles au curry, qui est l'une des spécialités de Chiang Mai. La meilleure adresse est Just Khao Soy dans le quartier Charoen Prathet Road. Le bol contient du chou mariné, d'oignons rouges, de nouilles croustillantes et de bouillon épicé, servi sur une palette de peintre en bois. Chacun ensuite ajoute les condiments à son goût.
 Links
 0
 id8057
 localeeng
 modelEvent
 foreign_key1347
 fieldlink
 content
 1
 id8058
 localefre
 modelEvent
 foreign_key1347
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 1
 Event
 id1500
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationTrat Wong Soi 2, Pa Tan, Mueang Chiang Mai, Province de Chiang Mai 50300, Thaïlande
 latitude18.8064
 longitude99.0094
 zoom13
 state_id(null)
 country_id
 created2011-11-17 17:11:58
 modified2011-11-17 17:11:58
 url(null)
 comment_count0
 former_business_id1108
 localeeng
 nameMEET A MUAY THAI BOXER
 descriptionMany know the iconic national sport of Thailand: Muay Thai, have you ever wanted to try this activity? During this adventure, you are more familiar with the sport through the day with a Muay Thai boxer. By discussing and observing, you will learn the ways of life of boxers, and of course the basic movements of the sport.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id8971
 localeeng
 modelEvent
 foreign_key1500
 fieldname
 contentMEET A MUAY THAI BOXER
 1
 id8972
 localefre
 modelEvent
 foreign_key1500
 fieldname
 contentRENCONTRER UN BOXEUR DE MUAY THAI
 Descriptions
 0
 id8973
 localeeng
 modelEvent
 foreign_key1500
 fielddescription
 contentMany know the iconic national sport of Thailand: Muay Thai, have you ever wanted to try this activity? During this adventure, you are more familiar with the sport through the day with a Muay Thai boxer. By discussing and observing, you will learn the ways of life of boxers, and of course the basic movements of the sport.
 1
 id8974
 localefre
 modelEvent
 foreign_key1500
 fielddescription
 contentBeaucoup connaissent le sport national emblématique de la Thaïlande : le Muay Thai, n'avez-vous jamais eu envie d'essayer cette activité ? Au cours de cette aventure, vous serez plus familier avec ce sport en passant la journée avec un boxeur de Muay Thai. En discutant et en observant, vous apprendrez les modes de vie des boxeurs, et bien sûr les mouvements de base du sport.
 Links
 0
 id8975
 localeeng
 modelEvent
 foreign_key1500
 fieldlink
 content
 1
 id8976
 localefre
 modelEvent
 foreign_key1500
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 2
 Event
 id1504
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationDoi Suthep, Suthep, Mueang Chiang Mai, Province de Chiang Mai 50200, Thaïlande
 latitude18.8167
 longitude98.9
 zoom13
 state_id(null)
 country_id
 created2011-11-17 17:54:37
 modified2011-11-17 17:54:37
 url(null)
 comment_count0
 former_business_id1112
 localeeng
 namePENPAL WITH HILLTRIBE
 descriptionYou want your children to connect with the children of the tribes around the world? This program puts kids in touch with the common people Hmong (a hill tribe in Chiang Mai) so they have a friend in Thailand, even before you arrive. Your child will be able to write to a child in the village of H'mong via the local school to say hello and get to know each other before they arrive. Children will want to know everything about your family, your country, your friends, what you eat in your country and the things you enjoy doing on weekends and so on. In return, they write, and you speak a little about themselves as well. When you arrive in Chiang Mai, you will have the opportunity to visit your match Doi Pui (near the temple of Doi Suthep, Chiang Mai) and say hello to the person. This is an excellent initiative to promote intercultural communication and learn how other children live in the world today. A percentage of your expenses will be used as a donation to the school and the purchase of paper.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id8995
 localeeng
 modelEvent
 foreign_key1504
 fieldname
 contentPENPAL WITH HILLTRIBE
 1
 id8996
 localefre
 modelEvent
 foreign_key1504
 fieldname
 contentCORRESPONDANCE AVEC LES TRIBUS
 Descriptions
 0
 id8997
 localeeng
 modelEvent
 foreign_key1504
 fielddescription
 contentYou want your children to connect with the children of the tribes around the world? This program puts kids in touch with the common people Hmong (a hill tribe in Chiang Mai) so they have a friend in Thailand, even before you arrive. Your child will be able to write to a child in the village of H'mong via the local school to say hello and get to know each other before they arrive. Children will want to know everything about your family, your country, your friends, what you eat in your country and the things you enjoy doing on weekends and so on. In return, they write, and you speak a little about themselves as well. When you arrive in Chiang Mai, you will have the opportunity to visit your match Doi Pui (near the temple of Doi Suthep, Chiang Mai) and say hello to the person. This is an excellent initiative to promote intercultural communication and learn how other children live in the world today. A percentage of your expenses will be used as a donation to the school and the purchase of paper.
 1
 id8998
 localefre
 modelEvent
 foreign_key1504
 fielddescription
 contentVous voulez que vos enfants se connectent avec les enfants des tribus à travers le monde ? Ce programme met vos enfants en contact avec des enfants du peuple H'mong (une tribu des montagne à Chiangmai) de sorte qu'ils auront un ami en Thaïlande, et ce avant même votre arrivée. Votre enfant aura la possibilité d'écrire à un des enfants du village des H'mong via l'école locale pour dire bonjour et se connaître les uns les autres avant qu'ils arrivent. Les enfants voudront tout savoir sur votre famille, votre pays, vos amis, ce que vous mangez dans votre pays et les choses que vous aimez faire le week-end etc. En retour, ils écrivent et vous parlent un peu sur eux-mêmes aussi. Lorsque vous arrivez à Chiangmai, vous aurez l'occasion de visiter votre correspondant à Doi Pui (près du temple de Doi Suthep-Chiang Mai) et dire bonjour à la personne. C'est une excellente initiative pour favoriser la communication interculturelle et apprendre comment les autres enfants dans le monde vivent aujourd'hui. Un pourcentage de vos frais sera utilisé comme un don à l'école et à l'achat de papier.
 Links
 0
 id8999
 localeeng
 modelEvent
 foreign_key1504
 fieldlink
 content
 1
 id9000
 localefre
 modelEvent
 foreign_key1504
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 3
 Event
 id1502
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location???. ??. 4100, Chiang Dao, Province de Chiang Mai 50170, Thaïlande
 latitude19.2638
 longitude99.0775
 zoom10
 state_id(null)
 country_id
 created2011-11-17 17:25:47
 modified2011-11-17 17:25:47
 url(null)
 comment_count0
 former_business_id1110
 localeeng
 nameFLY OVER NORTHERN THAILAND
 descriptionThere is no better way to discover the spectacular scenery of northern Thailand that flying over the green mountains and sweeping the countryside. You'll fly at low altitude on a private Cessna Caravan over Chiang Mai and its surroundings. The flight of 50 minutes will captivate you when you witness the beauty of the North from a different perspective.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id8983
 localeeng
 modelEvent
 foreign_key1502
 fieldname
 contentFLY OVER NORTHERN THAILAND
 1
 id8984
 localefre
 modelEvent
 foreign_key1502
 fieldname
 contentSURVOLEZ LE NORD DE LA THAILANDE
 Descriptions
 0
 id8985
 localeeng
 modelEvent
 foreign_key1502
 fielddescription
 contentThere is no better way to discover the spectacular scenery of northern Thailand that flying over the green mountains and sweeping the countryside. You'll fly at low altitude on a private Cessna Caravan over Chiang Mai and its surroundings. The flight of 50 minutes will captivate you when you witness the beauty of the North from a different perspective.
 1
 id8986
 localefre
 modelEvent
 foreign_key1502
 fielddescription
 contentIl n'y a pas de meilleure façon pour découvrir les paysages spectaculaires du nord de la Thaïlande qu'en volant au-dessus des montagnes verdoyantes et balayer la campagne. Vous volerez à basse altitude à bord d'un Cessna Caravan privés au-dessus de Chiang Mai et ses environs. Le vol de 50 minutes vous envoûtera quand vous serez témoin de la beauté du Nord sous une perspective différente.
 Links
 0
 id8987
 localeeng
 modelEvent
 foreign_key1502
 fieldlink
 content
 1
 id8988
 localefre
 modelEvent
 foreign_key1502
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 4
 Event
 id1501
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationDoi Inthanon National Park, Ban Luang, Chom Thong, Province de Chiang Mai 50160, Thaïlande
 latitude18.5798
 longitude98.4833
 zoom13
 state_id(null)
 country_id
 created2011-11-17 17:18:52
 modified2011-11-17 17:18:52
 url(null)
 comment_count0
 former_business_id1109
 localeeng
 nameDOI INTHANTON WATERFALLS
 descriptionThis adventure will take you to the waterfalls Doi Inthanton. From Chiang Mai, visit a village of the Karen tribe and a local market on their way north of Thailand, Doi Inthanon. Embark on a trek of two hours, enjoying the fresh mountain air through the lush jungle, rivers and waterfalls. Easy and yet always rewarding, this tour is ideal for families.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id8977
 localeeng
 modelEvent
 foreign_key1501
 fieldname
 contentDOI INTHANTON WATERFALLS
 1
 id8978
 localefre
 modelEvent
 foreign_key1501
 fieldname
 contentLES CASCADES DOI INTHANTON
 Descriptions
 0
 id8979
 localeeng
 modelEvent
 foreign_key1501
 fielddescription
 contentThis adventure will take you to the waterfalls Doi Inthanton. From Chiang Mai, visit a village of the Karen tribe and a local market on their way north of Thailand, Doi Inthanon. Embark on a trek of two hours, enjoying the fresh mountain air through the lush jungle, rivers and waterfalls. Easy and yet always rewarding, this tour is ideal for families.
 1
 id8980
 localefre
 modelEvent
 foreign_key1501
 fielddescription
 contentCette aventure vous emmènera jusqu'aux cascades de Doi Inthanton. Au départ de Chiang Mai, visitez un village de la tribu Karen et un marché local en faisant route le nord de la Thaïlande, Doi Inthanon. Embarquez pour un trek de deux heures, profitant de l'air frais des montagnes en passant par la jungle luxuriante, des rivières et des cascades. Facile et pourtant toujours gratifiant, cette tournée est parfaitement adapté aux familles.
 Links
 0
 id8981
 localeeng
 modelEvent
 foreign_key1501
 fieldlink
 content
 1
 id8982
 localefre
 modelEvent
 foreign_key1501
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
- weather(false)
- meta_description_for_layout137 Pillars House revives the old world elegance of the Orient and invites guests to enjoy every modern luxury. You are our personal guests. As such, we will be honored to lead you through the surrounding charms of Chiang Mai and welcome you home into pampered privacy. Our home-style residential concept allows visitors to participate and share in the richness of a likeminded international community while creating plenty of space for sublime intimacy in sumptuous suites and throughout our tropical grounds. Our ambition is that guests of 137 Pillars House will collect meaningful experiences that remain in their hearts long after they leave us. More than building a very comfortable place to sleep, we sincerely hope to create exceptional memories for every guest on every single day.
- userData(null)
- $this->data(null)
- $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

137 Pillars House

Chiang Mai, Thailand

0 comment

Book this hotel

Experiences close to the hotel

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

warning

error

Find an experience

Let us guide you

Find a boutique hotel

Search by desire

By country

137 Pillars House

Chiang Mai, Thailand

0 comment

Book this hotel

Experiences close to the hotel

TASTE THE KOW SOY

MEET A MUAY THAI BOXER

PENPAL WITH HILLTRIBE

FLY OVER NORTHERN THAILAND

DOI INTHANTON WATERFALLS

Other hotels matching your criteria

Chiang Mai, Thailand Puripunn Baby Grand Boutique Hotel

Chiang Mai, Thailand Banthai Village

Chiang Mai, Thailand The Rachamankha

Read more

News

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

warning

error

View Variables

Chiang Mai, Thailand
Puripunn Baby Grand Boutique Hotel

Chiang Mai, Thailand
Banthai Village

Chiang Mai, Thailand
The Rachamankha