SELECT SQL_CALC_FOUND_ROWS 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=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-03-31:2028-03-31' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.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 )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_is_featured' AND CAST(wp_postmeta.meta_value AS SIGNED) = '1' )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title DESC
LIMIT 0, 4
Marrakech is often described as a “sensory awakening” where ancient history and modern luxury collide.For the American traveler, it serves as the ultimate gateway to the exotic—a place where the scent of orange blossoms and cumin hangs in the air of the thousand-year-old Medina, a UNESCO World Heritage site. Marrakech offers a rhythm of life that is both chaotic and deeply soulful, promising an experience that lingers long after you’ve returned home.
Marrakech – Known as the Red City, Marrakech blends ancient medinas, bustling souks, and stunning palaces like Bahia Palace and Jemaa el-Fnaa Square, offering a rich cultural experience.