SELECT JrbRO_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM JrbRO_postmeta price_meta2 WHERE price_meta2.post_id=JrbRO_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-09-02:2028-09-02' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM JrbRO_postmeta price_meta3 WHERE price_meta3.post_id=JrbRO_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM JrbRO_posts INNER JOIN JrbRO_postmeta ON ( JrbRO_posts.ID = JrbRO_postmeta.post_id )
WHERE 1=1 AND (
( JrbRO_postmeta.meta_key = 'accommodation_location_post_id' AND JrbRO_postmeta.meta_value IN ('630') )
) AND JrbRO_posts.post_type = 'accommodation' AND ((JrbRO_posts.post_status = 'publish'))
GROUP BY JrbRO_posts.ID HAVING 1=1
ORDER BY JrbRO_posts.post_title ASC
Unfortunately no accommodations were found.
Popular
From
€
24
Join an Acropolis walking tour & immerse yourself in the wonders of Ancient Greece with a local guide. Upgrade your experience to discover Athens' charming old town & its last surviving public baths.
Athens All Included: Acropolis and Museum Guided Tour with Ticket
Acropolis and Museum
From
€
137
After meeting your guide at the nearby metro station, you and your small group will set off for the Acropolis. The tour brings some of history’s greatest treasures to life,
Athens Full Day Private Tour
Athens
From
€
155
Beat the heat of Athens’ streets on this full-day private tour with a knowledgeable driver. See city highlights including the Acropolis, Panathenaic Stadium.
Athens: Ancient Corinth Tour with Ticket Beach Stop & Pickup
Athens: Ancient Corinth
From
€
75
Εξερευνήστε τον Ναό του Απόλλωνα, τη διώρυγα της Κορίνθου και τον Ακροκόρινθο και στη συνέχεια χαλαρώστε με μια αναζωογονητική στάση στην παραλία πριν επιστρέψετε στην πόλη. Παραλαβή από το ξενοδοχείο, εισιτήρια και μικρή ομάδα περιλαμβάνονται
Athens: Meteora Day Trip with Central Pickup & Audio Guide
Athens--Kalabaka
From
€
72
Embark on a full-day trip from Athens to witness the Meteora rock formations and their UNESCO World Heritage-listed monasteries. Travel in comfort by bus with pickup from 4 central locations.
From Athens: Ancient Olympia Full-Day Guided Tour
Athens: Ancient Olympia
From
€
70
Drive through the scenic and beautiful landscape of the Peloponnese Peninsula to reach the birthplace of the Olympic Games. Admire the emblematic temples and athletic facilities.
From Athens: Delphi Day Trip & Arachova Village Stop
Athens: Delphi
From
€
26
Enjoy a day trip from Athens to Delphi. Visit this important center of the ancient world, listen to the amazing history in 10 different languages and stop for lunch in a traditional village.
Lake Vouliagmeni Thermal Spa And Temple Of Poseidon Tour
Lake Vouliagmeni Attica
From
€
110
Few visitors travel beyond the limits of Athens, but there are plenty of attractions waiting to be discovered if you know where to look.
Mycenae, Epidaurus and Nafplio Tour from Athens
Mycenae, Epidaurus and Nafplio
From
€
24
Relive ancient Greek history with a virtual reality audio guide on a day tour to Mycenae, the theater of Epidaurus, and the picturesque city of Napflion. Ride in comfort on a convenient coach service.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.