Accommodation list layout examples
SELECT SQL_CALC_FOUND_ROWS 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
WHERE 1=1 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
LIMIT 0, 1
SELECT SQL_CALC_FOUND_ROWS 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
WHERE 1=1 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
LIMIT 0, 3
Open all year

From
€
30
⇒ OPEN All Year Round. We look forward to welcoming you!
In Amfilochia's small and picturesque town, we created a hospitable and warm place, the Amvrakia Hotel. We constantly make sure to offer our customers the opportunity to experience the enchanting beauties of our region.
SELECT SQL_CALC_FOUND_ROWS 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
WHERE 1=1 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
LIMIT 0, 7
- Open all yearFrom € 30
- From € 110
- From € 15
- From € 55
- From € 48
- From € 60
SELECT SQL_CALC_FOUND_ROWS 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
WHERE 1=1 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
LIMIT 0, 3
Open all year

From
€
30
⇒ OPEN All Year Round. We look forward to welcoming you!
In Amfilochia's small and picturesque town, we created a hospitable and warm place, the Amvrakia Hotel. We constantly make sure to offer our customers the opportunity to experience the enchanting beauties of our region.
SELECT SQL_CALC_FOUND_ROWS 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
WHERE 1=1 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 DESC
LIMIT 0, 3
Open May 1st, 2025

From
€
45
⇒ We look forward to welcoming you back for the 2025 season on May 1st!
A few meters -just 150- from the famous sandy beach of Aegiali with a wonderful view of the villages and the bay of Aegiali is located Pelagos Hotel. Its hospitality is special for unforgettable holidays, as it combines colors of the Aegean, sun and sea.
SELECT SQL_CALC_FOUND_ROWS 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
WHERE 1=1 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
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS 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
WHERE 1=1 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 DESC
LIMIT 0, 3