Cairo boasts a rich tapestry woven from countless civilizations and eras.
Languages spoken
Arabic, English, Italian, Russian
Sports & nature
Culture and history info
The majestic Pyramids of Giza: These timeless monuments, including the Great Pyramid of Khufu, stand as testaments to the ingenuity and power of the pharaohs.
SELECT wpdw_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpdw_postmeta price_meta2 WHERE price_meta2.post_id=wpdw_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-05-09:2027-05-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpdw_postmeta price_meta3 WHERE price_meta3.post_id=wpdw_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpdw_posts INNER JOIN wpdw_postmeta ON ( wpdw_posts.ID = wpdw_postmeta.post_id )
WHERE 1=1 AND (
( wpdw_postmeta.meta_key = 'accommodation_location_post_id' AND wpdw_postmeta.meta_value IN ('21') )
) AND wpdw_posts.post_type = 'accommodation' AND ((wpdw_posts.post_status = 'publish'))
GROUP BY wpdw_posts.ID HAVING 1=1
ORDER BY wpdw_posts.post_title ASC
Unfortunately no accommodations were found.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Ah, Cairo! The vibrant, historic capital of Egypt, teeming with life and steeped in the whispers of millennia.
Cairo boasts a rich tapestry woven from countless civilizations and eras. Founded in the 10th century AD, it grew upon the foundations of the ancient city of Fustat, itself dating back to the 7th century. This layering of history manifests in iconic landmarks like: