Popular vacations
SELECT SQL_CALC_FOUND_ROWS wp_spatravel__newposts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_spatravel__newpostmeta price_meta2 WHERE price_meta2.post_id=wp_spatravel__newposts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_spatravel__newpostmeta price_meta3 WHERE price_meta3.post_id=wp_spatravel__newposts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_spatravel__newposts
WHERE 1=1 AND wp_spatravel__newposts.post_type = 'accommodation' AND ((wp_spatravel__newposts.post_status = 'publish'))
GROUP BY wp_spatravel__newposts.ID HAVING 1=1
ORDER BY RAND()
LIMIT 0, 4
TOP DEAL
![ta3](https://www.spatravel.rs/wp-content/uploads/2018/08/ta3-400x300.jpg)
Marhaba Palace
Tunisia, Port El Kantaoui
From
$
event 8 days/7 nights, All Inclusive
flight_takeoff London Gatwick
NEW
![ta5](https://www.spatravel.rs/wp-content/uploads/2018/08/ta5-400x300.jpg)
Acacia Marina
Marina di Ragusa, Sicily, Italy
From
$
event 8 days/7 nights, All Inclusive
flight_takeoff London Luton
LAST MINUTE
![ta12](https://www.spatravel.rs/wp-content/uploads/2018/08/ta12-400x300.jpg)
Elounda Blu
Heraklion, Crete, Greece
From
$
event 8 days/7 nights, All Inclusive
flight_takeoff Manchester
ADULTS ONLY
![ta8](https://www.spatravel.rs/wp-content/uploads/2018/08/ta8-400x300.jpg)
Marco Polo Hotel
Tunisia, Sousse
From
$
event 8 days/7 nights, All Inclusive
flight_takeoff London Gatwick
Explore our latest tours
NEW
![ta29](https://www.spatravel.rs/wp-content/uploads/2018/08/ta29-400x300.jpg)
3 Days South Italy experience
Pompeii, Sorrento, Capri, Italy
From
$
event March - November
schedule 3 days
SPECIAL OFFER
![ta20](https://www.spatravel.rs/wp-content/uploads/2018/08/ta20-400x300.jpg)
Explore our latest cruises
LUXURY
![ta16](https://www.spatravel.rs/wp-content/uploads/2018/08/ta16-400x300.jpg)
5 Nights Italian Classic Dolce Vita
Livorno (Florence/Pisa) - Civitavecchia (Rome) - Olbia - Cagliari - Palermo - Naples - Civitavecchia (Rome) - Livorno (Florence/Pisa)
From
$
event 5 nights
directions_boat Princess Cruises
FAMILY
![ta29](https://www.spatravel.rs/wp-content/uploads/2018/08/ta29-400x300.jpg)
4 Nights Spain and Balearic islands
Barcelona - Ciutadella (Menorca) - Palma (Mallorca) - Ibiza - Alicante - Valencia - Barcelona
From
$
event 4 nights
directions_boat MSC Fantasia
LUXURY
![ta14](https://www.spatravel.rs/wp-content/uploads/2018/08/ta14-400x300.jpg)
9 Nights Eastern Mediterranean
Civitavecchia (Rome) - Naples - Cagliari - Tunis - Chania (Crete) - Santorini - Athens - Kalamata - Malta - Civitavecchia (Rome)
From
$
event 9 nights
directions_boat Royal Caribbean
LAST MINUTE
![ta24](https://www.spatravel.rs/wp-content/uploads/2018/08/ta24-400x300.jpg)
11 Nights Western Mediterranean
Barcelona - Valencia - Alicante - Gibraltar - Malaga - Provence - Nice (Villefranche) - Livorno (Florence/Pisa) - Civitavecchia (Rome) - Barcelona
From
$
event 11 nights
directions_boat Celebrity Cruises