SELECT Q5MyIo9_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM Q5MyIo9_postmeta price_meta2 WHERE price_meta2.post_id=Q5MyIo9_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-02-17:2027-02-17' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM Q5MyIo9_postmeta price_meta3 WHERE price_meta3.post_id=Q5MyIo9_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM Q5MyIo9_posts INNER JOIN Q5MyIo9_postmeta ON ( Q5MyIo9_posts.ID = Q5MyIo9_postmeta.post_id )
WHERE 1=1 AND (
( Q5MyIo9_postmeta.meta_key = 'accommodation_location_post_id' AND Q5MyIo9_postmeta.meta_value IN ('2174') )
) AND Q5MyIo9_posts.post_type = 'accommodation' AND ((Q5MyIo9_posts.post_status = 'publish'))
GROUP BY Q5MyIo9_posts.ID HAVING 1=1
ORDER BY Q5MyIo9_posts.post_title ASC
Athens Riviera
Athens Riviera is the coastal area in the southern suburbs of Athens, Greece from Piraeus to Sounio and Lavrio.
The main areas of the Athens Riviera are the Bay of Zea, Flisvos Marina, Glyfada, Voula, Vouliagmeni, Lagonisi, Varkiza, Anavyssos, and Sounio.
Athens Riviera is the south-east coastline of Athens, home to tons of beautiful beaches and marinas.
The riviera stretches across 60 km, from Paleo Faliro to Cape Sounio.
Along the Athens Riviera, you will find Lake Vouliagmeni, known for its therapeutic waters.
At the end of the Athens Riviera, you can marvel at the imposing Temple of Poseidon offering striking sunset views.
The Athenian Riviera is home to some of the country’s finest hotels, fantastic nightclubs, and impressive recreational areas!