WordPress database error: [Got error 28 from storage engine]
SHOW FULL COLUMNS FROM `abh_options`


Warning: mysql_query(): Unable to save result set in C:\Inetpub\vhosts\alaaddinbeach.com\httpdocs\wp-includes\wp-db.php on line 1944

WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.*, tr.object_id FROM abh_terms AS t INNER JOIN abh_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN abh_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('language', 'post_translations') AND tr.object_id IN (131) ORDER BY t.name ASC

About Us : Alaaddin Beach Hotel

Alaaddin Beach Hotel on the restful Cleopatra Beach in Alanya


Warning: mysql_query(): Unable to save result set in C:\Inetpub\vhosts\alaaddinbeach.com\httpdocs\wp-includes\wp-db.php on line 1944

WordPress database error: [Got error 28 from storage engine]
SELECT abh_posts.* FROM abh_posts LEFT JOIN abh_term_relationships ON (abh_posts.ID = abh_term_relationships.object_id) WHERE 1=1 AND abh_posts.ID IN (131,119) AND ( abh_term_relationships.term_taxonomy_id IN (4) ) AND abh_posts.post_type = 'page' AND ((abh_posts.post_status = 'publish')) GROUP BY abh_posts.ID ORDER BY abh_posts.post_date DESC


Warning: mysql_query(): Unable to save result set in C:\Inetpub\vhosts\alaaddinbeach.com\httpdocs\wp-includes\wp-db.php on line 1944

WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.* FROM abh_terms AS t INNER JOIN abh_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN abh_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('language', 'post_translations') AND tr.object_id IN (119) ORDER BY t.name ASC

Fact Sheet

Alaaddin Beach Hotel started to provide service in 1965 with 20 rooms as Aladdin Motel. It became a beaten track for the first local and foreign guests travelling via highways and was one of the leading facilities of tourism in Alanya for many years.

It has reached its current view and room number by means of undergoing several modifications within years.

Alaaddin Beach Hotel is on the restful Cleopatra Beach in Alanya impressing people with its historical, natural and cultural properties as well as its holiday concept including sea, sand and sun. You could go to shopping centres, entertainment venues (Disco, night club and etc.) and bus terminal on foot. The distance between our Hotel and the Alanya Airport is 120 km and 45 km in terms of Gazipaşa Airport. Our hotel, restored on the basis of comfort of our guests, now provides much better service for its customers with its meeting hall for 40 persons, larger and new A’la carte restaurant, Sultan Cafe in the garden, new lobby and reception.

Rooms

Our hotel of which each detail has been furnished meticulously has 65 rooms and 130 beds. The room types consist of Double, Triple, Family and King Suites. Our ceramic-coated rooms have been designed in an open, large, comfortable and easy manner thanks to their sea, pool and garden views.

Services and activities

  • Sunbeds, beach umbrellas, cusions on the beach
  • Safe-deposit boxes, mini-bar in the rooms
  • Telephone, fascmile, photocopy and etc.
  • Wi-fi internet All kinds of drinks
  • A’la carte restaurant, brunch
  • Meeting hall

 

  • Doctor and medical services
  • Turkish bath, sauna, massage
  • Luggage room
  • Autopark
  • Water sports: Jet ski, parasailing, canoe, sea bicycle, wind surfing, speedboat and diving