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:2025-10-23:2027-10-23' 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_date DESC
LIMIT 0, 50
POPULAR
Cala Vinas
Cala Vinas, Mallorca, Spain
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff London Gatwick
POPULAR
Caesar Palace
Giardini Naxos, Sicily, Italy
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff London Luton
NEW
Acacia Marina
Marina di Ragusa, Sicily, Italy
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff London Luton
LAST MINUTE
Elounda Blu
Heraklion, Crete, Greece
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff Manchester
LAST MINUTE
Aquila Beach
Rethymnon, Crete, Greece
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff Manchester
ADULTS ONLY
Paradise Beach
Tunisia, Sousse
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff Manchester
ADULTS ONLY
Marco Polo Hotel
Tunisia, Sousse
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff London Gatwick
TOP DEAL
Marhaba Palace
Tunisia, Port El Kantaoui
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff London Gatwick
ROMANTIC
Villas Plaza
Half board with transfer
From
93
AED
Receive discounted Full Board and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
BEST DEAL
Zeus Resort
An unique experience
From
357
AED
For all reservations made until 28/02/2019 for any stay there is an early booking discount of 15%
Book now!! BOOKING.COM
Family
Pangasus Beach
All inclusive deal
From
1,299
AED
Receive discounted All Inclusive and Free Airport Transfers!!
Book now!! For stays between 15/09 – 26/10
Kalos Resort & SPA
Half board with unlimited SPA access
From
599
AED
Wait no longer, 10% off for the whole of October! Lorem ipsum dolor sit amet.
Book now!! PELA MARIA HOTEL
Kea Resort & SPA
Half board with unlimited SPA access
From
499
AED
Wait no longer, 10% off for the whole of October! Lorem ipsum dolor sit amet.
Book now!! PELA MARIA HOTEL
BEST DEAL
Mykonos Beach Party
An unique experience
From
357
AED
For all reservations made until 28/02/2019 for any stay there is an early booking discount of 15%
Book now!! BOOKING.COM
ROMANTIC
Naxos Beach 2019
Naxos beach suites ***
From
87
AED
Receive discounted Full Board and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
Family
Blue Resort SPA
All inclusive deal
From
899
AED
Receive discounted All Inclusive and Free Airport Transfers!!
Book now!! For stays between 15/09 – 26/10
BEST DEAL
Villas Lindos Special Offer
Best place on Lefkas island
From
49
AED
For all reservations made until 28/02/2019 for any stay there is an early booking discount of 15%
Book now!! BOOKING.COM
BEST DEAL
Stellamaris 2019
Half board with transfer
From
788
AED
Wait no longer, 10% off for the whole of October! Lorem ipsum dolor sit amet.
Book now!! PELA MARIA HOTEL
DON'T MISS
Halkidiki City Hotel
Half board premium deal
From
540
AED
Receive discounted All inclusive and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
Longer stay less to pay
A rare find
From
127
AED
Take advantage of our special offer and get a special discount up to 15% on your stay!!!
Lorem ipsum dolor sit amet.
Early booking -15%
Expires Soon
From
49
AED
For all reservations made until 28/02/2019 for any stay there is an early booking discount of 15%
Book now!! BOOKING.COM
BEST DEAL
October Special -10%
Wait no longer
From
150
AED
Wait no longer, 10% off for the whole of October! Lorem ipsum dolor sit amet.
Book now!! PELA MARIA HOTEL
DON'T MISS
Marbella Hotel
All inclusive package
From
890
AED
Receive discounted All inclusive and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
Top offer
Atrium Prestige SPA Resort & Villas
Half board with transfer
From
1,530
AED
Receive discounted Half Board and Free Airport Transfers!!
Book now!! For stays between 15/09 – 26/10
TOP DEAL
Sunny days Palace
Tunisia, Sousse
From
AED
event 8 days/7 nights, All Inclusive
flight_takeoff London Gatwick