SELECT SQL_CALC_FOUND_ROWS P1EDtMRP_29_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM P1EDtMRP_29_postmeta price_meta2 WHERE price_meta2.post_id=P1EDtMRP_29_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-09-22:2025-09-22' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM P1EDtMRP_29_postmeta price_meta3 WHERE price_meta3.post_id=P1EDtMRP_29_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM P1EDtMRP_29_posts
WHERE 1=1 AND P1EDtMRP_29_posts.post_type = 'accommodation' AND ((P1EDtMRP_29_posts.post_status = 'publish'))
GROUP BY P1EDtMRP_29_posts.ID HAVING 1=1
ORDER BY accommodation_price ASC
LIMIT 0, 50
Izmir Clock Tower is 600 m from the hotel. Izmir Adnan Menderes Airport is 14 km away. Konak is a great choice for travellers interested in city walks, coastal walks and city trips.
Mimar Hayrettin, Divani Ali Sk. No:7, 34130 Fatih/İstanbul
From €
Located in Beyazit, Divan-i Ali Hotel is just 200 m from Grand Bazaar, and a 10-minute walk from Hagia Sophia and Blue Mosque. The hotel has a sea view rooftop terrace with sun loungers and a hot tub.
Akşemsettin, Feyzullah Efendi Sk. No:6, 34091 Fatih / Istanbul
From €
Offering air-conditioned rooms and free Wi-Fi, this hotel is only 4 km from the historic Sultanahmet district which has many historic sites including Blue Mosque, Hagia Sophia and Topkapi Palace.
Reşatbey Mh., Turhan Cemal Beriker Bulvarı Otel Seyhan 20/A 01120 Seyhan / Adana
From €
In the morning the hotel serves a buffet breakfast with fresh fruit. The Pinar Restaurant offers Turkish cuisine prepared from fresh local ingredients.
Hürriyet Atatürk Blv. No: 8 03032 Erkmen Merkez / Afyonkarahisar
From €
Ema Öztürk Thermal Hotel is offering accommodations in Afyon. Among the facilities of this property are a restaurant, a 24-hour front desk and room service, along with free WiFi throughout the property.
Breakfast is served in Akkoc Boutique Hotel's modern restaurant. It also offers an à la carte menu featuring Turkish, Mediterranean and international cuisine.
Kuruköprü Sefa Özler Cd. No: 49 01060 Seyhan / Adana
From €
Relax in clean and comfortable accommodation and enjoy modern in-room amenities. Sürmeli Adana Hotel serves a variety of Turkish and international gourmet cuisine, as well as Adana's famous kebabs.
At Golden Lake Hotel you will find a 24-hour front desk, a garden and a terrace. Other facilities offered include a shared lounge, a ticket service and a tour desk. The property offers free parking.
Dörtyol Mh. Kütahya Yolu Bulvarı No: 2/3 Afyonkarahisar / Türkiye
From €
Ikbal Thermal Hotel & Spa offers a homely stay with 286 rooms, equipped with the latest technology, bright, spacious and in a professional simplicity with panoramic views and modern lines.