SELECT wpzr_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpzr_postmeta price_meta2 WHERE price_meta2.post_id=wpzr_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-11-30:2027-11-30' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpzr_postmeta price_meta3 WHERE price_meta3.post_id=wpzr_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpzr_posts INNER JOIN wpzr_postmeta ON ( wpzr_posts.ID = wpzr_postmeta.post_id )
WHERE 1=1 AND (
( wpzr_postmeta.meta_key = 'accommodation_location_post_id' AND wpzr_postmeta.meta_value IN ('145') )
) AND wpzr_posts.post_type = 'accommodation' AND ((wpzr_posts.post_status = 'publish'))
GROUP BY wpzr_posts.ID HAVING 1=1
ORDER BY wpzr_posts.post_title ASC
Unfortunately no accommodations were found.
3 Days Private Tour from Marrakech
Marrakech, Atlas Mountains, Ourazazate, Erg Chebbi
From
$
This is a classic and highly popular route in Morocco. While the exact stops can vary slightly between private tour , the core itinerary for the 3-Day Private Tour from Marrakech to Merzouga (Erg Chebbi Dunes) is very consistent.
4 Days Marrakech Desert Tour
Marrakech, High atlas , Ouarzazate , Todra Gorges, Merzouga Desert
From
$
This 4-day trip travels from the vibrant city of Marrakech, crossing the dramatic High Atlas Mountains (via the Tizi n'Tichka Pass), to the majestic Erg Chebbi sand dunes in the Sahara Desert.
Around the World by Private Jet
26 days · 56 Country · 150 Cities
From
$
Service level: Luxury
Activity level: Light
Group size: Small group
Kenya: Elephants Rhinos and Big Cats
7 days · 1 Country · 13 Cities
From
$
Service level: Upgraded
Activity level: Active
Group size: Small group
Morocco Culinary Experience
7 days · 1 Country · 12 Cities
From
$
Service level: Basic
Activity level: Moderate
Group size: Private group
Unfortunately no cruises were found.
Unfortunately no car rentals were found.