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:2024-07-27:2026-07-27' 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
Al Haiba Hotel
Sulaymaniyah, the beginning of Salem Street, near the gondola meat and dough restaurant
From
IQD
Al Sindbad Motel
Address: Sulaymaniyah Kani Kurda, near the gas station, Bakhtiyar Khan, Sixty Street
From
IQD
Areen Hotel
Address: Sulaymaniyah A real estate street opposite the gate of Park Azadi
From
IQD
Babylon Hotel
Address: Sulaymaniyah Al-Mohandessin neighborhood, next to the new municipality building
From
IQD
Badrkhan Hotel
Address: Sulaymaniyah Al-Ziraa Street, next to Rabin Garage, near Mawlawi Street and the Great Mosque of Sulaymaniyah
From
IQD
Bawan Motel
Address: Sulaymaniyah King Mahmud circular street, near the Binayi gas station
From
IQD
Baz Motel
Address: Sulaymaniyah Next to Azadi Park, near Salem Sulaymaniyah Street and Market
From
IQD
Dima Motel
Address: Sulaymaniyah, King Mahmoud Ring Street, near Khana Bani gas station
From
IQD
Dukan Hotel
Address: Sulaymaniyah Kaveh Street, near Mawlawi, next to the New Stock Exchange
From
IQD
Grand Plaza 2 Hotel
Address: Sulaymaniyah Sulaymaniyah, 60th Street, near West Eye Hospital
From
IQD
Had Hotel
Address: Sulaymaniyah, Sixty Street, opposite car showrooms (old Baghdad garage), Rizgari area, service street
From
IQD
Halwachy Hotel
Address: Sulaymaniyah Salem Street opposite Sulaymaniyah Chamber of Commerce
From
IQD
Hashin Motel
Address: Sulaymaniyah, Bakrjo, Sheikh Ali Building, next to Westa Raouf Restaurant
From
IQD
Hawser Motel
Address: Sulaymaniyah, Malak Mahmoud Street (Street 60), opposite Dahan Asia Company
From
IQD
Hotel Dim Dim
Address: Sulaymaniyah Sulaymaniyah, the beginning of Salem Street, Sargnar Junction
From
IQD
Jihan Motel
Address: Sulaymaniyah, King Mahmoud Street, opposite Elton Supermarket, next to Juwaisa Market
From
IQD
Kako Hotel
Address: Sulaymaniyah, Malak Mahmoud Street, Maqabeel, Binayi gas station
From
IQD
Khanzad Hotel
Address: Sulaymaniyah Selim Street, next to the Chamber of Commerce, opposite the Soleimani Museum
From
IQD
Lalezar Hotel
Address: Sulaymaniyah Sergnar Main Street behind House of Brands and Cafe Nali
From
IQD
Liland Hotel
Address: Sulaymaniyah King Mahmoud Street, in front of Khana Binayi gas station
From
IQD
Mad Motel
Address: Sulaymaniyah Salem Street, near Khosrukhal Bridge, opposite Samsung
From
IQD
Millennium Hotel & Spa (Sulaymaniyah)
Address: Sulaymaniyah King Mahmoud Street, next to Farouk Medical City
From
IQD
Quiet Corners Motel
Address: Sulaymaniyah Sixty Street between Family Mall and Al-Farouk Sulaymaniyah Hospital
From
IQD
Roya Hotel
Address: Sulaymaniyah Ghorbakh Street, Falqa Mama Risha, near Mawlawi Sulaymaniyah Street
From
IQD
Rzgari Taza Motel
Address: Sulaymaniyah Salem Street, next to Korek Telecom Company
From
IQD
Shahram Plaza Hotel
Address: Sulaymaniyah Salem Street, opposite the Kurdistan International Bank, next to the Directorate of Education
From
IQD
Sham Motel
Address: Sulaymaniyah Malak Mahmoud Street, opposite Alton Supermarket, near Kobani Sulaymaniyah Bridge
From
IQD
Siraj Motel
Address: Sulaymaniyah, opposite Azadi Park, Shari Yari Gate, near Al-Fayhaa Canal
From
IQD
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
Star Wood Hotel
Sulaymaniyah, 60th Street, near Panzin Khaneh Binayi, next to the Haji Salam real estate office
From
IQD
Taj Motel
Address: Sulaymaniyah, Malak Mahmoud Street (Steen Street), the beginning of the Kobani Bridge
From
IQD
Unfortunately no tours were found.
Unfortunately no car rentals were found.
Unfortunately no cruises were found.