Athens: The Timeless Capital
| Languages spoken | English, French, Dutch, Russian and others |
|---|---|
| Country name | Greece |
SELECT HMNxkYV_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM HMNxkYV_postmeta price_meta2 WHERE price_meta2.post_id=HMNxkYV_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-16:2028-02-16' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM HMNxkYV_postmeta price_meta3 WHERE price_meta3.post_id=HMNxkYV_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM HMNxkYV_posts INNER JOIN HMNxkYV_postmeta ON ( HMNxkYV_posts.ID = HMNxkYV_postmeta.post_id )
WHERE 1=1 AND (
( HMNxkYV_postmeta.meta_key = 'accommodation_location_post_id' AND HMNxkYV_postmeta.meta_value IN ('1894') )
) AND HMNxkYV_posts.post_type = 'accommodation' AND ((HMNxkYV_posts.post_status = 'publish'))
GROUP BY HMNxkYV_posts.ID HAVING 1=1
ORDER BY HMNxkYV_posts.post_title ASC
Amalia Hotel Athens
10 Amalias Ave. (Leoforos Vas. Amalias) Athens
From
€
Welcome to Amalia Hotel Athens,Greece
Amalia Hotel Athens is located in the heart of Athens, just steps from Syntagma Square and the National Garden, Amalia Hotel Athens blends ...
Unfortunately no tours were found.
From
€
Chartering a sailboat, motorboat, or catamaran is a great way to explore the beauty of the sea, experience new adventures, and create unforgettable memories of the Greek Islands.
A sailing holiday is a true adventure to remember!
The choice is yours!