SELECT SQL_CALC_FOUND_ROWS wp_544149_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_544149_postmeta price_meta2 WHERE price_meta2.post_id=wp_544149_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-01-12:2028-01-12' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_544149_postmeta price_meta3 WHERE price_meta3.post_id=wp_544149_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_544149_posts
WHERE 1=1 AND wp_544149_posts.post_type = 'accommodation' AND ((wp_544149_posts.post_status = 'publish'))
GROUP BY wp_544149_posts.ID HAVING 1=1
ORDER BY accommodation_static_price ASC
LIMIT 12, 12
Situé au coeur d'Athènes, «la ville européenne qui ne dort jamais». L'hôtel se dresse avec fierté sur la célèbre place Omonia (Concorde) avec sa fontaine au milieu de la place, qui donne un charme certain à la ville.