Kumu Beach

Zur Auswahlliste hinzufügen
Karte & Standort

10 Zimmer ab €212 pro Nacht

“Eine kompakte und elegante Boutique an der friedlichen Küste der Südwestküste Sri Lankas. Die Inneneinrichtung wurde von der srilankischen Designerin Annika Fernando sorgfältig gestaltet, um Komfort und Entspannung zu optimieren. Dank der geringen Größe fühlen sich die Gäste umsorgt und die Lage ist wunderbar ruhig.”

Einrichtungen

Nicht geeignet für behinderte Gäste
Parken
Bar
Auto nicht erforderlich
Zimmer mit Balkon/Terrasse
Flughafen-Transfer
Essen im Freien
Kinderbetten verfügbar
Massage
Bademäntel
Sit-out Terrace

Klimatisierung
Schwimmbad
Garten
Kinderfreundlich
Zimmerservice
Suiten
Restaurant
Himmelbetten
Wifi
Ansichten
Heilbad

Aktivitäten

Hotel Boote zu mieten
Organisieren Sie eine Bootsfahrt zu den Madu-Ganga-Feuchtgebieten - Wasserwege zwischen 65 verschiedenen Inseln mit unberührten Mangrovenwäldern
Hotel Unterhaltung
Entspannen Sie sich am Pool in einem der bequemen Liegestühle und lassen Sie sich vom aufmerksamen Personal Cocktails bringen.

Museen
Besuchen Sie das Maskenmuseum in Ambalangoda, einem Dorf in der Nähe, das Teufelsmasken für lokale Rituale herstellt.
Wildnisgebiet
Beteiligen Sie sich an den örtlichen Bemühungen zum Schutz der Meeresschildkröten, indem Sie die Meeresschildkrötenfarm und -brutstätte am Strand von Balapitiya besuchen.

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

The River House, Balapitiya

Verfügbarkeit prüfen

10 Zimmer ab €212 pro Nacht

Haben Sie Fragen?

Kontakt aufnehmen

Kumu Beach, Balapitiya. Expertenbewertungen und Highlights | The Hotel Guru

Kumu Beach

Balapitiya (Galle Road), Sri Lanka

Zur Auswahlliste hinzufügen
Map & Location

10 Zimmer ab €212 pro Nacht

“A compact and elegant boutique, on the peaceful shores of Sri Lanka’s south-west coast. The interiors have been carefully crafted by Sri Lankan designer Annika Fernando to optimise comfort and relaxation. The small size allows guests to feel cared for and the location is wonderfully serene. ”

Recommended For

Hotel Boote zu mieten
Organisieren Sie eine Bootsfahrt zu den Madu-Ganga-Feuchtgebieten - Wasserwege zwischen 65 verschiedenen Inseln mit unberührten Mangrovenwäldern
Strandleben
An diesem abgeschiedenen Ort steht der Strand im Mittelpunkt, Palmen und Cocktails, Garnelen im Tandoor und Sonnenuntergänge über der Bucht von Balapitiya
Hotel Unterhaltung
Entspannen Sie sich am Pool in einem der bequemen Liegestühle und lassen Sie sich vom aufmerksamen Personal Cocktails bringen.
Wildnisgebiet
Beteiligen Sie sich an den örtlichen Bemühungen zum Schutz der Meeresschildkröten, indem Sie die Meeresschildkrötenfarm und -brutstätte am Strand von Balapitiya besuchen.
Museen
Besuchen Sie das Maskenmuseum in Ambalangoda, einem Dorf in der Nähe, das Teufelsmasken für lokale Rituale herstellt.
Totale Entspannung
Am Pool entspannen, im Spa relaxen, im Garten Cocktails schlürfen und am Strand die Sterne beobachten
Gourmet
Ruhig
Zimmer mit Balkon/Terrasse
Ansichten
Designer
Barfuß-Luxus
Hervorragender Standort
Sit-out Terrace

Heilbad
Restaurant
Am Strand
Kunstwerke
Shop
Schick
Kinderfreundlich
Wellbeing
Traditionell
Zeitgenössische
Luxus
Himmelbetten
Intimes
Romantisch

Einrichtungen

Nicht geeignet für behinderte Gäste
Parken
Bar
Auto nicht erforderlich
Zimmer mit Balkon/Terrasse
Flughafen-Transfer
Essen im Freien
Kinderbetten verfügbar
Massage
Bademäntel
Sit-out Terrace

Klimatisierung
Schwimmbad
Garten
Kinderfreundlich
Zimmerservice
Suiten
Restaurant
Himmelbetten
Wifi
Ansichten
Heilbad

Aktivitäten

Hotel Boote zu mieten
Organisieren Sie eine Bootsfahrt zu den Madu-Ganga-Feuchtgebieten - Wasserwege zwischen 65 verschiedenen Inseln mit unberührten Mangrovenwäldern
Hotel Unterhaltung
Entspannen Sie sich am Pool in einem der bequemen Liegestühle und lassen Sie sich vom aufmerksamen Personal Cocktails bringen.

Museen
Besuchen Sie das Maskenmuseum in Ambalangoda, einem Dorf in der Nähe, das Teufelsmasken für lokale Rituale herstellt.
Wildnisgebiet
Beteiligen Sie sich an den örtlichen Bemühungen zum Schutz der Meeresschildkröten, indem Sie die Meeresschildkrötenfarm und -brutstätte am Strand von Balapitiya besuchen.

Map & Location

What's Nearby

Other Reviews

Kumu Beach

"A chic and refined haven oozing style on Sri Lanka’s sunset coast, near Balapitiya."

Originally published by The Telegraph (view article)

Browse more hotels nearby

The River House, Balapitiya

Check Availability

10 Zimmer ab €212 pro Nacht

Any Questions?

Get in touch

Your Shortlist (0)

Init : 1.7166137695312E-5
Dispatch : 0.23999810218811
Output : 0.0018861293792725
Total : 0.24190139770508
Peak memory: 1.939826965332mb
Server name: Linux ip-172-26-7-178 5.4.0-1030-aws #31-Ubuntu SMP Fri Nov 13 11:40:37 UTC 2020 x86_64

0.00057 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00224 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.09050 : SELECT * FROM `hotel` WHERE `handle`='kumu-beach-balapitiya' LIMIT 0, 1
0.00650 : SELECT * FROM `imagestore` WHERE `global_id`='128849128723' ORDER BY image_id = "3ff042131d90bcfa65da917f616f5b21" DESC, position ASC
0.00062 : SELECT * FROM `location` WHERE `location_id`='25613'
0.00057 : SELECT * FROM `location_german` WHERE `location_id`='25613' LIMIT 0, 1
0.00129 : SELECT * FROM `location` WHERE `location_id`='2191'
0.00100 : SELECT * FROM `location` WHERE `location_id`='2191'
0.00098 : SELECT * FROM `location_german` WHERE `location_id`='2191' LIMIT 0, 1
0.00079 : SELECT * FROM `location` WHERE `location_id`='25613'
0.00054 : SELECT * FROM `location_german` WHERE `location_id`='25613' LIMIT 0, 1
0.00134 : SELECT * FROM `location` WHERE `location_id`='2191'
0.00077 : SELECT * FROM `location_german` WHERE `location_id`='2191' LIMIT 0, 1
0.00079 : SELECT * FROM `review` WHERE (hotel_id='109873' OR hotel2_id='109873' OR hotel3_id='109873') AND is_published=1 AND datetime_published<1715637361 ORDER BY datetime_published DESC LIMIT 0, 1000
0.00061 : SELECT * FROM `external_article` WHERE `hotel_id`='109873' LIMIT 0, 1000
0.02623 : SELECT hotel_id FROM `hotel` WHERE (((ACOS(SIN(6.2554250910265 * PI() / 180) * SIN(exact_location_lat * PI() / 180) + COS(6.2554250910265 * PI() / 180) * COS(exact_location_lat * PI() / 180) * COS((80.039069982556 - exact_location_lng) * PI() / 180)) * 180 / PI()) * 60 * 1.1515)<5) AND `hotel_id`!='109873' LIMIT 0, 3
0.00096 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('43163') LIMIT 0, 1000
0.00055 : SELECT * FROM `hotel_german` WHERE `hotel_id`='109873' LIMIT 0, 1
0.00132 : SELECT hotel_id FROM `shortlist` WHERE `slid`='d0f43c14a6e26cee' ORDER BY datetime DESC
0.00162 : SELECT CONCAT(`from`, ":", `to`), rate FROM `currency_conversion` WHERE 1
0.00084 : SELECT * FROM `imagestore` WHERE `global_id`='128849128723' ORDER BY image_id = "3ff042131d90bcfa65da917f616f5b21" DESC, position ASC
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='48152719060b1e61be30779b84982101' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='9fd045b51c968536f0063a2a807bd431' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='e2750870dc44cb230dfd426c6ed50eb1' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='db7100e9f1ae4406ea5dfc4bb711aef1' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='e56a67e22bab22449a58d7410d4306a1' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore_german` WHERE `image_id`='d07899d54b223c587893bd31155f3281' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='40ba653f3097bb29e3f0868b77ede231' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='9934fb2c86e43c87cf17514497c6f341' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='0f3e46489203e9476cd937ab9393c801' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='95b5a449837ee51cd36b0a430bfc7ed1' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='65cd95bb63126c938e5b0d2f1697c1b1' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore_german` WHERE `image_id`='1404ad7372bec1be6ed40f659d2b8611' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='20cc6fa6b22fdb4f7ef3d367e8ddc0e1' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='bebe3b801f1e5d53cf721da0ef834d01' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='5025833d75f49277910ed0c8f5b8b6b1' LIMIT 0, 1
0.00056 : SELECT * FROM `imagestore_german` WHERE `image_id`='0d0ece1c2cd7edcdd2e205a6349e1931' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='b835ed86762eb9a9eb5fb2b8d67ade81' LIMIT 0, 1
0.00111 : SELECT * FROM `imagestore` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='48152719060b1e61be30779b84982101'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='48152719060b1e61be30779b84982101'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='9fd045b51c968536f0063a2a807bd431'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='9fd045b51c968536f0063a2a807bd431'
0.00058 : SELECT * FROM `imagestore` WHERE `image_id`='e2750870dc44cb230dfd426c6ed50eb1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='e2750870dc44cb230dfd426c6ed50eb1'
0.00086 : SELECT * FROM `imagestore` WHERE `image_id`='db7100e9f1ae4406ea5dfc4bb711aef1'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='db7100e9f1ae4406ea5dfc4bb711aef1'
0.00091 : SELECT * FROM `imagestore` WHERE `image_id`='e56a67e22bab22449a58d7410d4306a1'
0.00059 : SELECT * FROM `imagestore` WHERE `image_id`='e56a67e22bab22449a58d7410d4306a1'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='d07899d54b223c587893bd31155f3281'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='d07899d54b223c587893bd31155f3281'
0.00113 : SELECT * FROM `imagestore` WHERE `image_id`='40ba653f3097bb29e3f0868b77ede231'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='40ba653f3097bb29e3f0868b77ede231'
0.00133 : SELECT * FROM `imagestore` WHERE `image_id`='9934fb2c86e43c87cf17514497c6f341'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='9934fb2c86e43c87cf17514497c6f341'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='0f3e46489203e9476cd937ab9393c801'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='0f3e46489203e9476cd937ab9393c801'
0.00094 : SELECT * FROM `imagestore` WHERE `image_id`='95b5a449837ee51cd36b0a430bfc7ed1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='95b5a449837ee51cd36b0a430bfc7ed1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='65cd95bb63126c938e5b0d2f1697c1b1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='65cd95bb63126c938e5b0d2f1697c1b1'
0.00109 : SELECT * FROM `imagestore` WHERE `image_id`='1404ad7372bec1be6ed40f659d2b8611'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='1404ad7372bec1be6ed40f659d2b8611'
0.00059 : SELECT * FROM `imagestore` WHERE `image_id`='20cc6fa6b22fdb4f7ef3d367e8ddc0e1'
0.00057 : SELECT * FROM `imagestore` WHERE `image_id`='20cc6fa6b22fdb4f7ef3d367e8ddc0e1'
0.00122 : SELECT * FROM `imagestore` WHERE `image_id`='bebe3b801f1e5d53cf721da0ef834d01'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='bebe3b801f1e5d53cf721da0ef834d01'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='5025833d75f49277910ed0c8f5b8b6b1'
0.00068 : SELECT * FROM `imagestore` WHERE `image_id`='5025833d75f49277910ed0c8f5b8b6b1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='0d0ece1c2cd7edcdd2e205a6349e1931'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='0d0ece1c2cd7edcdd2e205a6349e1931'
0.00057 : SELECT * FROM `imagestore` WHERE `image_id`='b835ed86762eb9a9eb5fb2b8d67ade81'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='b835ed86762eb9a9eb5fb2b8d67ade81'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21'
0.00077 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`score`='2' AND `tag`.`collection` IN ('3', '4', '5', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00073 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00077 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` NOT IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00072 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`strap` IS NOT NULL
0.00054 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='109873'
0.00061 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1263', '53', '2003', '923', '2483', '1993', '1303', '1383', '1483', '1193', '1643', '1983', '2093', '2123', '63', '123', '163', '203', '263', '443', '653', '913', '953', '993', '1103', '1123', '1133', '1163')
0.00070 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00057 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1933', '1353', '1413', '1463', '1483', '1503', '1533', '1603', '1613', '1333', '2123', '3', '303', '423', '653', '753', '893', '123', '1123', '1153', '1193', '63')
0.00059 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`strap` IS NOT NULL
0.00055 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='109873'
0.00071 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00050 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1263', '2003', '2483', '923')
0.00062 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`strap` IS NOT NULL
0.00051 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='109873'
0.00092 : SELECT * FROM `imagestore` WHERE `global_id`='128849128723' ORDER BY image_id = "3ff042131d90bcfa65da917f616f5b21" DESC, position ASC
0.00071 : SELECT * FROM `imagestore_german` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21' LIMIT 0, 1
0.00057 : SELECT * FROM `imagestore_german` WHERE `image_id`='48152719060b1e61be30779b84982101' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore_german` WHERE `image_id`='9fd045b51c968536f0063a2a807bd431' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='e2750870dc44cb230dfd426c6ed50eb1' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore_german` WHERE `image_id`='db7100e9f1ae4406ea5dfc4bb711aef1' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='e56a67e22bab22449a58d7410d4306a1' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='d07899d54b223c587893bd31155f3281' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='40ba653f3097bb29e3f0868b77ede231' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='9934fb2c86e43c87cf17514497c6f341' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='0f3e46489203e9476cd937ab9393c801' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='95b5a449837ee51cd36b0a430bfc7ed1' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore_german` WHERE `image_id`='65cd95bb63126c938e5b0d2f1697c1b1' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore_german` WHERE `image_id`='1404ad7372bec1be6ed40f659d2b8611' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='20cc6fa6b22fdb4f7ef3d367e8ddc0e1' LIMIT 0, 1
0.00054 : SELECT * FROM `imagestore_german` WHERE `image_id`='bebe3b801f1e5d53cf721da0ef834d01' LIMIT 0, 1
0.00053 : SELECT * FROM `imagestore_german` WHERE `image_id`='5025833d75f49277910ed0c8f5b8b6b1' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='0d0ece1c2cd7edcdd2e205a6349e1931' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='b835ed86762eb9a9eb5fb2b8d67ade81' LIMIT 0, 1
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='48152719060b1e61be30779b84982101'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='48152719060b1e61be30779b84982101'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='9fd045b51c968536f0063a2a807bd431'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='9fd045b51c968536f0063a2a807bd431'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='e2750870dc44cb230dfd426c6ed50eb1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='e2750870dc44cb230dfd426c6ed50eb1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='db7100e9f1ae4406ea5dfc4bb711aef1'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='db7100e9f1ae4406ea5dfc4bb711aef1'
0.00058 : SELECT * FROM `imagestore` WHERE `image_id`='e56a67e22bab22449a58d7410d4306a1'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='e56a67e22bab22449a58d7410d4306a1'
0.00063 : SELECT * FROM `imagestore` WHERE `image_id`='d07899d54b223c587893bd31155f3281'
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='d07899d54b223c587893bd31155f3281'
0.00061 : SELECT * FROM `imagestore` WHERE `image_id`='40ba653f3097bb29e3f0868b77ede231'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='40ba653f3097bb29e3f0868b77ede231'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='9934fb2c86e43c87cf17514497c6f341'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='9934fb2c86e43c87cf17514497c6f341'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='0f3e46489203e9476cd937ab9393c801'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='0f3e46489203e9476cd937ab9393c801'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='95b5a449837ee51cd36b0a430bfc7ed1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='95b5a449837ee51cd36b0a430bfc7ed1'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='65cd95bb63126c938e5b0d2f1697c1b1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='65cd95bb63126c938e5b0d2f1697c1b1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='1404ad7372bec1be6ed40f659d2b8611'
0.00093 : SELECT * FROM `imagestore` WHERE `image_id`='1404ad7372bec1be6ed40f659d2b8611'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='20cc6fa6b22fdb4f7ef3d367e8ddc0e1'
0.00058 : SELECT * FROM `imagestore` WHERE `image_id`='20cc6fa6b22fdb4f7ef3d367e8ddc0e1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='bebe3b801f1e5d53cf721da0ef834d01'
0.00066 : SELECT * FROM `imagestore` WHERE `image_id`='bebe3b801f1e5d53cf721da0ef834d01'
0.00070 : SELECT * FROM `imagestore` WHERE `image_id`='5025833d75f49277910ed0c8f5b8b6b1'
0.00067 : SELECT * FROM `imagestore` WHERE `image_id`='5025833d75f49277910ed0c8f5b8b6b1'
0.00076 : SELECT * FROM `imagestore` WHERE `image_id`='0d0ece1c2cd7edcdd2e205a6349e1931'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='0d0ece1c2cd7edcdd2e205a6349e1931'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='b835ed86762eb9a9eb5fb2b8d67ade81'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='b835ed86762eb9a9eb5fb2b8d67ade81'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='3ff042131d90bcfa65da917f616f5b21'
0.00077 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`score`='2' AND `tag`.`collection` IN ('3', '4', '5', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00072 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00068 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` NOT IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00060 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`strap` IS NOT NULL
0.00053 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='109873'
0.00056 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1263', '53', '2003', '923', '2483', '1993', '1303', '1383', '1483', '1193', '1643', '1983', '2093', '2123', '63', '123', '163', '203', '263', '443', '653', '913', '953', '993', '1103', '1123', '1133', '1163')
0.00071 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00054 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1933', '1353', '1413', '1463', '1483', '1503', '1533', '1603', '1613', '1333', '2123', '3', '303', '423', '653', '753', '893', '123', '1123', '1153', '1193', '63')
0.00061 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`strap` IS NOT NULL
0.00157 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='109873'
0.00070 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00047 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1263', '2003', '2483', '923')
0.00058 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='109873' AND `hotel_tag`.`strap` IS NOT NULL
0.00050 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='109873'
0.00075 : SELECT name FROM `shortlist_name` WHERE `slid`='d0f43c14a6e26cee'

Kumu Beach

Hotel Zimmer

Empfohlen für

Einrichtungen

Aktivitäten

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

Haben Sie Fragen?

Kumu Beach

Hotel Rooms

Recommended For

Einrichtungen

Aktivitäten

Map & Location

What's Nearby

Other Reviews

Kumu Beach

Browse more hotels nearby

Any Questions?