SELECT SQL_CALC_FOUND_ROWS wpte_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpte_postmeta price_meta2 WHERE price_meta2.post_id=wpte_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2021-01-22:2023-01-22' LIMIT 1), 0) accommodation_price FROM wpte_posts WHERE 1=1 AND wpte_posts.post_type = 'accommodation' AND ((wpte_posts.post_status = 'publish')) GROUP BY wpte_posts.ID HAVING 1=1 ORDER BY wpte_posts.post_date DESC LIMIT 0, 50
ROMANTIC
Villas Plaza
Half board with transfer
From
93
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
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
THB
Receive discounted Half Board and Free Airport Transfers!!
Book now!! For stays between 15/09 – 26/10