Explore our latest accommodations
SELECT SQL_CALC_FOUND_ROWS wpkr_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpkr_postmeta price_meta2 WHERE price_meta2.post_id=wpkr_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-03-13:2027-03-13' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpkr_postmeta price_meta3 WHERE price_meta3.post_id=wpkr_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpkr_posts
WHERE 1=1 AND wpkr_posts.post_type = 'accommodation' AND ((wpkr_posts.post_status = 'publish'))
GROUP BY wpkr_posts.ID HAVING 1=1
ORDER BY wpkr_posts.post_title ASC
LIMIT 0, 4
New

Apartment Alice
Address 1234, Albufeira, Spain
From
$
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.

Apartment Bob
Address 1234, Abisko, Sweden
From
$
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.

Apartment Chloe
Address 1234, Alanya, Turkey
From
$
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.

Apartment Dennis
Address 1234, Alesund, Norway
From
$
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.
Explore our latest tours
Explore our latest cruises
Unfortunately no cruises were found.
Explore our latest car rentals
Unfortunately no car rentals were found.