SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-08-17:2028-08-17' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts
WHERE 1=1 AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title DESC
LIMIT 0, 3
Unfortunately no accommodations were found.
Hotel Clara
Address 1234, Delphi, Greece
From
$79
-30%
Use 30DEAL coupon when checking out to get 30% discount on your purchase.
Valid until 2019-04-26
The port of Eivissa blends medieval heritage with a vibrant nightlife, making it a key tourist attraction. It features commercial and passenger docks, the Botafoc breakwater for fuel unloading and cruise ships, and 1,400 recreational boat moorings.
Located in northwest Ibiza, Sant Antoni de Portmany spans 12,662 hectares with a population of 27,431. It includes four main villages—Sant Antoni, Sant Rafel, Santa Agnès, and Sant Mateu—each with traditional rural areas and neighborhoods. The region is known for its scenic coastline, pine forests, and vibrant atmosphere.
Eivissa, a city with a rich history of cultural exchange, has evolved into a multicultural hub while preserving its unique heritage. Officially the island's capital since 2019, it offers a mix of traditional neighborhoods, stunning landscapes, and vibrant tourism, making it a special Mediterranean destination.
The port of Sant Antoni de Portmany, located on Ibiza’s west coast, is the closest to the Iberian Peninsula. It supports fishing, recreational boating, and commercial activities, with growing popularity among visitors. Managed by the Balearic Government and the local Nautical Club, it offers 645 berths. Transient vessels must register and pay fees promptly. Fuel station hours vary by season.