SELECT wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2025-05-14:2027-05-14' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_id AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('18471') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_global_styles','location','review','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','shop_order_refund','shop_order_placehold','feedback','monsterinsights_note','jp_mem_plan','jp_pay_order','jp_pay_product' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wp_template','wp_template_part','wp_global_styles','wp_navigation','location','review','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','shop_order_placehold','feedback','monsterinsights_note','jp_mem_plan','jp_pay_order','jp_pay_product' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wp_template','wp_template_part','wp_global_styles','wp_navigation','location','review','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','shop_order_placehold','feedback','monsterinsights_note','jp_mem_plan','jp_pay_order','jp_pay_product' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Ahlam Al Nojom Motel
Address: Sulaymaniyah, 60th Street, Jaffe Land Road, next to Kobani Bridge
From
IQD
For reservations and inquiries
Al Haiba Hotel
Address: Sulaymaniyah, the beginning of Salem Street, near the gondola meat and dough restaurant
From
IQD
For reservations and inquiries
Al Sindbad Motel
Address: Sulaymaniyah Kani Kurda, near the gas station, Bakhtiyar Khan, Sixty Street
From
IQD
For reservations and inquiries
Amed Hotel
Address: Sulaymaniyah The beginning of Mawlawi Street, Saeed Taha Koyi Street
From
IQD
For reservations and inquiries
Anaqa Motel
Address: Sulaymaniyah Street 60, adjacent to Kashi Isfahan
From
IQD
For reservations and inquiries
Anya Motel
Address: Sulaymaniyah Al-Sulaymaniyah is next to Fros Restaurant
From
IQD
For reservations and inquiries
Areen Hotel
Address: Sulaymaniyah A real estate street opposite the gate of Park Azadi
From
IQD
For reservations and inquiries
Babylon Hotel
Address: Sulaymaniyah Al-Mohandessin neighborhood, next to the new municipality building
From
IQD
For reservations and inquiries
Badrkhan Hotel
Address: Sulaymaniyah Al-Ziraa Street, next to Rabin Garage, near Mawlawi Street and the Great Mosque of Sulaymaniyah
From
IQD
For reservations and inquiries
Bawan Motel
Address: Sulaymaniyah King Mahmud circular street, near the Binayi gas station
From
IQD
For reservations and inquiries
Copthorne Baranan Hotel
Address: Sulaymaniyah Sirginar main street
From
IQD
For reservations and inquiries
Dilshad Hotel (Sulaymaniyah)
Address: Sulaymaniyah Salem Suleiman Street
From
IQD
For reservations and inquiries
Dima Motel
Address: Sulaymaniyah, King Mahmoud Ring Street, near Khana Bani gas station
From
IQD
For reservations and inquiries
Diyari Motel
Address: Sulaymaniyah, the beginning of Sarınar main street
From
IQD
For reservations and inquiries
Dolphin Hotel & Hostel
Address: Sulaymaniyah city center near the Great Mosque
From
IQD
For reservations and inquiries
Dubai Dream Hotel
Address: Sulaymaniyah Old Ford Company near Debashan Bridge
From
IQD
For reservations and inquiries
Dukan Hotel
Address: Sulaymaniyah Kaveh Street, near Mawlawi, next to the New Stock Exchange
From
IQD
For reservations and inquiries
Fine Moment Motel
Address: Sulaymaniyah Sixty Street, opposite Al-Farouk Hospital
From
IQD
For reservations and inquiries
Grand Millennium Hotel (Sulaymaniyah)
Address: Sulaymaniyah Bakhtiari
From
IQD
For reservations and inquiries
Grand Plaza 2 Hotel
Address: Sulaymaniyah Sulaymaniyah, 60th Street, near West Eye Hospital
From
IQD
For reservations and inquiries
Halwachy Hotel
Address: Sulaymaniyah Salem Street opposite Sulaymaniyah Chamber of Commerce
From
IQD
For reservations and inquiries
Hamsa Hotel
Address: Sulaymaniyah Old Gwarta Street near Azadi Park
From
IQD
For reservations and inquiries
Happy Dream Motel
Address: Sulaymaniyah, 60th Street, in front of Alton Market
From
IQD
For reservations and inquiries
Hashin Motel
Address: Sulaymaniyah, Bakrjo, Sheikh Ali Building, next to Westa Raouf Restaurant
From
IQD
For reservations and inquiries
Hawser Motel
Address: Sulaymaniyah, Malak Mahmoud Street (Street 60), opposite Dahan Asia Company
From
IQD
For reservations and inquiries
Hawzhin Motel
Address: Sulaymaniyah, Bireh Mered Street, opposite the Mother Park
From
IQD
For reservations and inquiries
Highcrest Hotel
Address: Sulaymaniyah Bakrgo Street, near Majidi Mall
From
IQD
For reservations and inquiries
Hotel Dim Dim
Address: Sulaymaniyah Sulaymaniyah, the beginning of Salem Street, Sargnar Junction
From
IQD
For reservations and inquiries
Jihan Motel
Address: Sulaymaniyah, King Mahmoud Street, opposite Elton Supermarket, next to Juwaisa Market
From
IQD
For reservations and inquiries
Kako Hotel
Address: Sulaymaniyah, Malak Mahmoud Street, Maqabeel, Binayi gas station
From
IQD
For reservations and inquiries
Khan Saray Hotel
Address: Sulaymaniyah Mawlawi Street
From
IQD
For reservations and inquiries
Khanzad Hotel
Address: Sulaymaniyah Selim Street, next to the Chamber of Commerce, opposite the Soleimani Museum
From
IQD
For reservations and inquiries
Kobani Hotel
Address: Sulaymaniyah Ashabah Sabi Street, next to Kaveh Sulaymaniyah Street
From
IQD
For reservations and inquiries
Lalezar Hotel
Address: Sulaymaniyah Sergnar Main Street behind House of Brands and Cafe Nali
From
IQD
For reservations and inquiries
Lawa Hotel
Address: Sulaymaniyah Near Kobani Sulaymaniyah Bridge
From
IQD
For reservations and inquiries
Liland Hotel
Address: Sulaymaniyah King Mahmoud Street, in front of Khana Binayi gas station
From
IQD
For reservations and inquiries
London Bridge Motel
Address: Sulaymaniyah Sixty Street, in front of Khana Pinayi
From
IQD
For reservations and inquiries
Mad Motel
Address: Sulaymaniyah Salem Street, near Khosrukhal Bridge, opposite Samsung
From
IQD
For reservations and inquiries
Maghrib Hotel
Address: Sulaymaniyah Salem Suleiman Street
From
IQD
For reservations and inquiries
Mamu Zen Hotel
Address: Sulaymaniyah Sirginar main street
From
IQD
For reservations and inquiries
Mastura Hotel
Address: Sulaymaniyah Sarcinar Street 60, adjacent to Saeed Piran Mosque
From
IQD
For reservations and inquiries
Mihrako Hotel & Spa
Address: Sulaymaniyah Salim Street
From
IQD
For reservations and inquiries
Millennium Hotel & Spa (Sulaymaniyah)
Address: Sulaymaniyah King Mahmoud Street, next to Farouk Medical City
From
IQD
For reservations and inquiries
Paradise Hotel
Address: Sulaymaniyah Mawlawi Sulaymaniyah Street
From
IQD
For reservations and inquiries
Parsan Hotel
Address: Sulaymaniyah King Mahmoud Street near Kobani Sulaymaniyah Bridge
From
IQD
For reservations and inquiries
Pasha Hotel
Address: Sulaymaniyah The end of Mawlawi Street, Al-Naqeeb Sulaymaniyah Building
From
IQD
For reservations and inquiries
Qasr Al Sultan Hotel
Address: Sulaymaniyah King Mahmoud Street, near Banzeen Khana Binayi
From
IQD
For reservations and inquiries
Quiet Corners Motel
Address: Sulaymaniyah Sixty Street between Family Mall and Al-Farouk Sulaymaniyah Hospital
From
IQD
For reservations and inquiries
Rawaz Hotel & Motel
Address: Sulaymaniyah King Mahmoud Street
From
IQD
For reservations and inquiries
Roya Hotel
Address: Sulaymaniyah Ghorbakh Street, Falqa Mama Risha, near Mawlawi Sulaymaniyah Street
From
IQD
For reservation and enquiry
Rzgari Taza Motel
Address: Sulaymaniyah Salem Street, next to Korek Telecom Company
From
IQD
For reservations and inquiries
Sea Breeze Motel
Address: Sulaymaniyah Near Majidi Mall, main Bakrgo Street
From
IQD
For reservations and inquiries
Shahram Plaza Hotel
Address: Sulaymaniyah Salem Street, opposite the Kurdistan International Bank, next to the Directorate of Education
From
IQD
For reservations and inquiries
Sham Motel
Address: Sulaymaniyah Malak Mahmoud Street, opposite Alton Supermarket, near Kobani Sulaymaniyah Bridge
From
IQD
For reservations and inquiries
Siraj Motel
Address: Sulaymaniyah, opposite Azadi Park, Shari Yari Gate, near Al-Fayhaa Canal
From
IQD
For reservations and inquiries
Slemani Rotana Hotel
Address: Sulaymaniyah Salim Street
From
IQD
For reservations and inquiries
Star Sky Hotel
Address: Sulaymaniyah Street 60, near Banzin Khana Pinayi, next to Shrini Gula
From
IQD
For reservations and inquiries
Star Wood Hotel
Address: Sulaymaniyah, 60th Street, near Panzin Khaneh Binayi, next to the Haji Salam real estate office
From
IQD
For reservations and inquiries
Taj Motel
Address: Sulaymaniyah, Malak Mahmoud Street (Steen Street), the beginning of the Kobani Bridge
From
IQD
For reservations and inquiries
Titanic Hotel & spa
Address: Sulaymaniyah King Mahmoud Street, near Jaffe Land
From
IQD
For reservations and inquiries
Yalda Hotel
Address: Sulaymaniyah Al-Barid Street, Al-Mawlawi Street branch
From
IQD
For reservations and inquiries
Zamo Motel
Address: Sulaymaniyah opposite Azadi Park, near Salem Street and Market
From
IQD
For reservations and inquiries
Unfortunately no tours were found.
Unfortunately no car rentals were found.
Unfortunately no cruises were found.