Offers
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:2022-05-26:2024-05-26' 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
From
93
THB
Receive discounted Full Board and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
BEST DEAL
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
From
1,299
THB
Receive discounted All Inclusive and Free Airport Transfers!!
Book now!! For stays between 15/09 – 26/10
From
599
THB
Wait no longer, 10% off for the whole of October! Lorem ipsum dolor sit amet.
Book now!! PELA MARIA HOTEL
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
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
From
87
THB
Receive discounted Full Board and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
Family
From
899
THB
Receive discounted All Inclusive and Free Airport Transfers!!
Book now!! For stays between 15/09 – 26/10
BEST DEAL
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
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
From
540
THB
Receive discounted All inclusive and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
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.
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
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
From
890
THB
Receive discounted All inclusive and Free Airport Transfers!!
Book now!! For stays between 10/10 – 26/11
Top offer
From
1,530
THB
Receive discounted Half Board and Free Airport Transfers!!
Book now!! For stays between 15/09 – 26/10