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=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-06-24:2027-06-24' 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_location_post_id' AND wp_postmeta.meta_value IN ('705') )
) 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 ASC
Top offer
Algilà Fes Riad Medina Charme
Centrally located, preserving traditional architecture and medina crafts
From
$
116
A heritage riad with beautiful courtyard and tilework, supporting local artisans and medina conservation
Top offer
Riad Arabesque & Spa
Offers wellness amenities, garden, and spa services—likely prioritizing natural well‑being
From
$
108
Spa riad with outdoor courtyard, massages, and garden space in a peaceful setting outside the medina core
Top offer
Riad La Cle De Fes
Emphasizes outdoor spaces, solarium, garden, and natural light
From
$
55
4★ riad featuring gardens, solarium terrace, a bar/lounge, and a soothing escape from the bustling medina
Top offer
Riad La Maison Verte
Name implies green ethos; Trip.com lists it under 4★ options with wellness and garden spaces
From
$
79
Quaint riad with garden lounge, bar, spa services, and a focus on greenery and tranquility
Top offer
Riad Marjana Suites & Spa
Traditional courtyard B&B, likely using local materials and supporting local cleaners/cooks
From
$
129
Peaceful courtyard suites with rooftop breakfast terrace—perfect blend of local authenticity and comfort
Top offer
Riad Salam Fes
Includes garden, massage/spa services—suggesting emphasis on wellness and natural settings
From
$
169
Gardened riad with spa offerings, ideal for guests seeking relaxed, green surroundings after exploring the historic medina
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.