Ten Mallorca

Mallorca, Spanien

Zur Auswahlliste hinzufügen
Karte & Standort

9 Zimmer ab €149 pro Nacht

“Dieses Hotel nur für Erwachsene ist in einem restaurierten historischen Gebäude im Zentrum von Sineu untergebracht. Die kühnen und schönen Zimmer sind mit auffälligen Mustertapeten, Plüschmöbeln und geräumigen, eleganten Badezimmern ausgestattet. Es gibt eine herrliche Terrasse mit Pool, einen Fitnessraum, ein Restaurant und eine Bar. Ein glamouröser Ort zum Entspannen.”

Einrichtungen

Zimmer mit Balkon/Terrasse
Restaurant
Fahrradverleih
Schwimmbad
Restaurants in Gehweite
Essen im Freien
Sitzungssaal
Massage
Bar
Bademäntel
Keine Haustiere
Sit-out Terrace
Spielzimmer

Wäscherei
Nur für Erwachsene
Behindertengerechter Zugang
Garten
Fitnessstudio
Sitzungszimmer
Suiten
Hausmeister
Satelliten- / Kabelfernsehen
Wifi
Klimatisierung
Sicher

Aktivitäten

Andere Aktivitäten
Radfahren
Lokale Märkte
Museen

Tolle Spaziergänge
Golf
Sehenswürdigkeiten in der Nähe

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

9 Zimmer ab €149 pro Nacht

Haben Sie Fragen?

Kontakt aufnehmen

Ten Mallorca, Mallorca. Expertenbewertungen und Highlights | The Hotel Guru

Ten Mallorca

Mallorca, Spanien

Zur Auswahlliste hinzufügen
Map & Location

9 Zimmer ab €149 pro Nacht

“Housed in a restored historic building, this adult-only hotel is in the centre of Sineu. Bold and beautiful rooms feature striking statement wallpaper, plush soft furnishings and spacious, elegant bathrooms. There's a gorgeous terrace with pool, plus a gym, restaurant and bar. A glamorous getaway.”

Recommended For

Lokale Erkundung
Romantische Pause
Aktivurlaub
Andere Aktivitäten
Radfahren
Lokale Märkte
Museen
Sehenswürdigkeiten in der Nähe
Tolle Spaziergänge
Golf
Zimmer mit Balkon/Terrasse
Restaurant
Sit-out Terrace

Vom Eigentümer verwaltet
Bio-Lebensmittel
Romantisch
Voller Charakter
Opulent
Shop
Historisches
Schick
Fitnessstudio
Behindertengerechter Zugang
Traditionell
Charmant
Intimes

Einrichtungen

Zimmer mit Balkon/Terrasse
Restaurant
Fahrradverleih
Schwimmbad
Restaurants in Gehweite
Essen im Freien
Sitzungssaal
Massage
Bar
Bademäntel
Keine Haustiere
Sit-out Terrace
Spielzimmer

Wäscherei
Nur für Erwachsene
Behindertengerechter Zugang
Garten
Fitnessstudio
Sitzungszimmer
Suiten
Hausmeister
Satelliten- / Kabelfernsehen
Wifi
Klimatisierung
Sicher

Aktivitäten

Andere Aktivitäten
Radfahren
Lokale Märkte
Museen

Tolle Spaziergänge
Golf
Sehenswürdigkeiten in der Nähe

Map & Location

What's Nearby

Browse more hotels nearby

9 Zimmer ab €149 pro Nacht

Any Questions?

Get in touch

Your Shortlist (0)

Init : 1.5974044799805E-5
Dispatch : 0.25530695915222
Output : 0.0017380714416504
Total : 0.25706100463867
Peak memory: 1.8574066162109mb
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.00084 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00063 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.12585 : SELECT * FROM `hotel` WHERE `handle`='ten-mallorca-mallorca' LIMIT 0, 1
0.00365 : SELECT * FROM `imagestore` WHERE `global_id`='128849178426' ORDER BY image_id = "5455e952e3987573a90b37c62dd5f1b1" DESC, position ASC
0.00063 : SELECT * FROM `location` WHERE `location_id`='2343'
0.00062 : SELECT * FROM `location_german` WHERE `location_id`='2343' LIMIT 0, 1
0.00058 : SELECT * FROM `location` WHERE `location_id`='2185'
0.00058 : SELECT * FROM `location` WHERE `location_id`='2185'
0.00063 : SELECT * FROM `location_german` WHERE `location_id`='2185' LIMIT 0, 1
0.00054 : SELECT * FROM `location` WHERE `location_id`='2343'
0.00075 : SELECT * FROM `location_german` WHERE `location_id`='2343' LIMIT 0, 1
0.00069 : SELECT * FROM `location` WHERE `location_id`='2185'
0.00055 : SELECT * FROM `location` WHERE `location_id`='17'
0.00052 : SELECT * FROM `location_german` WHERE `location_id`='17' LIMIT 0, 1
0.00047 : SELECT * FROM `review` WHERE (hotel_id='159576' OR hotel2_id='159576' OR hotel3_id='159576') AND is_published=1 AND datetime_published<1715640431 ORDER BY datetime_published DESC LIMIT 0, 1000
0.00048 : SELECT * FROM `external_article` WHERE `hotel_id`='159576' LIMIT 0, 1000
0.02581 : SELECT hotel_id FROM `hotel` WHERE (((ACOS(SIN(39.642183284151 * PI() / 180) * SIN(exact_location_lat * PI() / 180) + COS(39.642183284151 * PI() / 180) * COS(exact_location_lat * PI() / 180) * COS((3.0086302494904 - exact_location_lng) * PI() / 180)) * 180 / PI()) * 60 * 1.1515)<5) AND `hotel_id`!='159576' LIMIT 0, 3
0.00109 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('63553', '125903', '159572') LIMIT 0, 1000
0.00126 : SELECT * FROM `hotel_german` WHERE `hotel_id`='159576' LIMIT 0, 1
0.00061 : SELECT hotel_id FROM `shortlist` WHERE `slid`='40acdcb185b21c9d' ORDER BY datetime DESC
0.00083 : SELECT * FROM `imagestore` WHERE `global_id`='128849178426' ORDER BY image_id = "5455e952e3987573a90b37c62dd5f1b1" DESC, position ASC
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='f59644efd399a2396e7d5295003e4351' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='974c4631955cf74238c98c207ccd8e21' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='22fff221c751c140015301f317595f61' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='b5b63d400ca61bd06908d06b53db2841' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='63f9fab7edb15900ef0247800b4fc231' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='17e2c95cf5a217d8c4ebc29d2f4bbbc1' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='1c7b43df0a68c82086aed4be328fd6a1' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='5f119890bca1070189a3b04824f92031' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='2bbd76d9100bf86745ef76ba3e3476f1' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='f7f97b7f047d7c3849335621a0d531e1' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='07a241c986d4aaba2ef8aebd9161d691' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='f74b246ad90d11fe0e184ec9ee8aa521' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='3b5fd580f28824ec7e1c4b2657d0fbd1' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='28e5a1247446ff83bfb4eb0df5a53831' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='71cb3654b018afd0068d890cf4ec2421' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1'
0.00116 : SELECT * FROM `imagestore` WHERE `image_id`='f59644efd399a2396e7d5295003e4351'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='f59644efd399a2396e7d5295003e4351'
0.00093 : SELECT * FROM `imagestore` WHERE `image_id`='974c4631955cf74238c98c207ccd8e21'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='974c4631955cf74238c98c207ccd8e21'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='22fff221c751c140015301f317595f61'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='22fff221c751c140015301f317595f61'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='b5b63d400ca61bd06908d06b53db2841'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='b5b63d400ca61bd06908d06b53db2841'
0.00108 : SELECT * FROM `imagestore` WHERE `image_id`='63f9fab7edb15900ef0247800b4fc231'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='63f9fab7edb15900ef0247800b4fc231'
0.00100 : SELECT * FROM `imagestore` WHERE `image_id`='17e2c95cf5a217d8c4ebc29d2f4bbbc1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='17e2c95cf5a217d8c4ebc29d2f4bbbc1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='1c7b43df0a68c82086aed4be328fd6a1'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='1c7b43df0a68c82086aed4be328fd6a1'
0.00126 : SELECT * FROM `imagestore` WHERE `image_id`='5f119890bca1070189a3b04824f92031'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='5f119890bca1070189a3b04824f92031'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='2bbd76d9100bf86745ef76ba3e3476f1'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='2bbd76d9100bf86745ef76ba3e3476f1'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='f7f97b7f047d7c3849335621a0d531e1'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='f7f97b7f047d7c3849335621a0d531e1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='07a241c986d4aaba2ef8aebd9161d691'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='07a241c986d4aaba2ef8aebd9161d691'
0.00136 : SELECT * FROM `imagestore` WHERE `image_id`='f74b246ad90d11fe0e184ec9ee8aa521'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='f74b246ad90d11fe0e184ec9ee8aa521'
0.00102 : SELECT * FROM `imagestore` WHERE `image_id`='3b5fd580f28824ec7e1c4b2657d0fbd1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='3b5fd580f28824ec7e1c4b2657d0fbd1'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='28e5a1247446ff83bfb4eb0df5a53831'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='28e5a1247446ff83bfb4eb0df5a53831'
0.00098 : SELECT * FROM `imagestore` WHERE `image_id`='71cb3654b018afd0068d890cf4ec2421'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='71cb3654b018afd0068d890cf4ec2421'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1'
0.00064 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' 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.00065 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' 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.00065 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' 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.00053 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `hotel_tag`.`strap` IS NOT NULL
0.00128 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159576'
0.00054 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2383', '2053', '533', '2063', '273', '2373', '2483', '733', '153', '333', '1483', '123', '2123', '1323', '1793', '1163', '2243', '2443', '263', '383', '443', '483', '853', '953', '1073', '1133')
0.00071 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' 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 ('1483', '123', '1733', '303', '1523', '1533', '1593', '1613', '1413', '1333', '1703', '2123', '1213', '2563', '2573', '853', '423', '483', '703', '893', '1013', '1053', '1153', '3', '1313')
0.00061 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `hotel_tag`.`strap` IS NOT NULL
0.00054 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159576'
0.00072 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00051 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2063', '273', '2373', '2483', '153', '333', '733')
0.00060 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `hotel_tag`.`strap` IS NOT NULL
0.00049 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159576'
0.00084 : SELECT * FROM `imagestore` WHERE `global_id`='128849178426' ORDER BY image_id = "5455e952e3987573a90b37c62dd5f1b1" DESC, position ASC
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1' LIMIT 0, 1
0.00053 : SELECT * FROM `imagestore_german` WHERE `image_id`='f59644efd399a2396e7d5295003e4351' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='974c4631955cf74238c98c207ccd8e21' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='22fff221c751c140015301f317595f61' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='b5b63d400ca61bd06908d06b53db2841' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='63f9fab7edb15900ef0247800b4fc231' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='17e2c95cf5a217d8c4ebc29d2f4bbbc1' LIMIT 0, 1
0.00053 : SELECT * FROM `imagestore_german` WHERE `image_id`='1c7b43df0a68c82086aed4be328fd6a1' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='5f119890bca1070189a3b04824f92031' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='2bbd76d9100bf86745ef76ba3e3476f1' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='f7f97b7f047d7c3849335621a0d531e1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='07a241c986d4aaba2ef8aebd9161d691' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='f74b246ad90d11fe0e184ec9ee8aa521' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='3b5fd580f28824ec7e1c4b2657d0fbd1' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='28e5a1247446ff83bfb4eb0df5a53831' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='71cb3654b018afd0068d890cf4ec2421' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='f59644efd399a2396e7d5295003e4351'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='f59644efd399a2396e7d5295003e4351'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='974c4631955cf74238c98c207ccd8e21'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='974c4631955cf74238c98c207ccd8e21'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='22fff221c751c140015301f317595f61'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='22fff221c751c140015301f317595f61'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='b5b63d400ca61bd06908d06b53db2841'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='b5b63d400ca61bd06908d06b53db2841'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='63f9fab7edb15900ef0247800b4fc231'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='63f9fab7edb15900ef0247800b4fc231'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='17e2c95cf5a217d8c4ebc29d2f4bbbc1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='17e2c95cf5a217d8c4ebc29d2f4bbbc1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='1c7b43df0a68c82086aed4be328fd6a1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='1c7b43df0a68c82086aed4be328fd6a1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='5f119890bca1070189a3b04824f92031'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='5f119890bca1070189a3b04824f92031'
0.00144 : SELECT * FROM `imagestore` WHERE `image_id`='2bbd76d9100bf86745ef76ba3e3476f1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='2bbd76d9100bf86745ef76ba3e3476f1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='f7f97b7f047d7c3849335621a0d531e1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='f7f97b7f047d7c3849335621a0d531e1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='07a241c986d4aaba2ef8aebd9161d691'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='07a241c986d4aaba2ef8aebd9161d691'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='f74b246ad90d11fe0e184ec9ee8aa521'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='f74b246ad90d11fe0e184ec9ee8aa521'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='3b5fd580f28824ec7e1c4b2657d0fbd1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='3b5fd580f28824ec7e1c4b2657d0fbd1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='28e5a1247446ff83bfb4eb0df5a53831'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='28e5a1247446ff83bfb4eb0df5a53831'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='71cb3654b018afd0068d890cf4ec2421'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='71cb3654b018afd0068d890cf4ec2421'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='5455e952e3987573a90b37c62dd5f1b1'
0.00076 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' 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`='159576' 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.00071 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' 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.00067 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `hotel_tag`.`strap` IS NOT NULL
0.00056 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159576'
0.00058 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2383', '2053', '533', '2063', '273', '2373', '2483', '733', '153', '333', '1483', '123', '2123', '1323', '1793', '1163', '2243', '2443', '263', '383', '443', '483', '853', '953', '1073', '1133')
0.00066 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00060 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1483', '123', '1733', '303', '1523', '1533', '1593', '1613', '1413', '1333', '1703', '2123', '1213', '2563', '2573', '853', '423', '483', '703', '893', '1013', '1053', '1153', '3', '1313')
0.00057 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `hotel_tag`.`strap` IS NOT NULL
0.00050 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159576'
0.00069 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00052 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2063', '273', '2373', '2483', '153', '333', '733')
0.00062 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159576' AND `hotel_tag`.`strap` IS NOT NULL
0.00060 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159576'
0.00075 : SELECT name FROM `shortlist_name` WHERE `slid`='40acdcb185b21c9d'

Ten Mallorca

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?

Ten Mallorca

Hotel Rooms

Recommended For

Einrichtungen

Aktivitäten

Map & Location

What's Nearby

Browse more hotels nearby

Any Questions?