Northern
SELECT SQL_CALC_FOUND_ROWS dhp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM dhp_postmeta price_meta2 WHERE price_meta2.post_id=dhp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-12-07:2025-12-07' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM dhp_postmeta price_meta3 WHERE price_meta3.post_id=dhp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM dhp_posts LEFT JOIN dhp_term_relationships ON (dhp_posts.ID = dhp_term_relationships.object_id)
WHERE 1=1 AND (
dhp_term_relationships.term_taxonomy_id IN (36)
) AND dhp_posts.post_type = 'accommodation' AND ((dhp_posts.post_status = 'publish'))
GROUP BY dhp_posts.ID HAVING 1=1
ORDER BY dhp_posts.post_title ASC
LIMIT 0, 40
Baan Saen Fang
10 Thapae Soi 2, Thapae Road, Tambol Chang Moi, Amphur Muang, Chiang Mai, Thailand 50300
Bodhi Serene Hotel
110 Ratchapakhinai Rd, Tambon Phra Sing, Mueang Chiang Mai District, Chiang Mai 50200
Chiang Mai Plaza Hotel & Convention Centre
92 Sridonchai Rd, Changklan, Muang, Chiangmai 50100
Duangtawan Hotel Chiang Mai
Night Bazaar ,132 Loykroh Road, Muang Chiang Mai 50100, Thailand
Four Seasons Resort Chiang Mai
502 Moo 1, Mae Rim-Samoeng Old Road, Chiang Mai 50180 Thailand
Four Seasons Tented Camp. Golden Triangle
P.O. Box 18, Chiang Saen Post Office, Chiang Rai 57150, Thailand
Holiday Garden Hotel And Resort
16/16 HuayKaew Road, Changphuak, Muang District Chiang Mai 50300 Thailand
Imperial Resort And Sports Club
284 Moo 3 Don Kaew, Chiang Mai - Fang Road, Mae Rim Chiang Mai 50180 Thailand
Imperial River House
482 M.4 , Mae Kok Rd., T. Rim Kok Chiang Rai, Chiang Rai Province 57100 Thailand
Katiliya Mountain Resort
388/1 Moo 4 Tambol Pha Sang, Amphur Mae Chan, Chiang Rai 57110, Thailand
Mövenpick Suriwongse Hotel Chiang Mai
110 Changklan Road, Muang Chiang Mai 50100 Chiang Mai Thailand
Na Nirand Boutique Resort
1/1 Soi 9, Charoenprathet Road, Tambon Changklan, Amphoe Muang, Chiang Mai 50100, Thailand
Yaang Come Village Hotel
90/3 Sridonchai Rd, Chang Khlan Sub-district, Mueang Chiang Mai District, Chiang Mai 50100Central
SELECT SQL_CALC_FOUND_ROWS dhp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM dhp_postmeta price_meta2 WHERE price_meta2.post_id=dhp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-12-07:2025-12-07' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM dhp_postmeta price_meta3 WHERE price_meta3.post_id=dhp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM dhp_posts LEFT JOIN dhp_term_relationships ON (dhp_posts.ID = dhp_term_relationships.object_id)
WHERE 1=1 AND (
dhp_term_relationships.term_taxonomy_id IN (37)
) AND dhp_posts.post_type = 'accommodation' AND ((dhp_posts.post_status = 'publish'))
GROUP BY dhp_posts.ID HAVING 1=1
ORDER BY dhp_posts.post_title ASC
LIMIT 0, 40
Century Park Hotel Bangkok
9 Ratchaprarop Rd., Pratunam-Victory Monument, 10400 Bangkok, Thailand
Chatrium Riverside Hotel Bangkok
28 Charoen Krung Soi 70, Bang Kho Laem, Bangkok 10120, Thailand
Como Metropolitan Bangkok
27 South Sathorn Road Tungmahamek, Sathorn Bangkok 10120, Thailand
Hintok River Camp
109 Moo 9 Ban Wang Khamen, Tambon Thasao, Saiyok, Kanchanaburi 70150 Thailand
Hotel De Bangkok
133/48 Ratchaprarop Soi 12, Ratchaprarop Road, Makkasan, Ratchathewi, Bangkok 10400
Ramada Plaza Menam Riverside
2074 Charoen Krung Rd, Wat Phraya Krai, Bang Kho Laem, Bangkok 10120
The Float House River Kwai
55 Moo 5 Tambol Wangkrajae, Amphur Saiyok, Kanchanaburi 71150, Thailand
Eastern
SELECT SQL_CALC_FOUND_ROWS dhp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM dhp_postmeta price_meta2 WHERE price_meta2.post_id=dhp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-12-07:2025-12-07' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM dhp_postmeta price_meta3 WHERE price_meta3.post_id=dhp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM dhp_posts LEFT JOIN dhp_term_relationships ON (dhp_posts.ID = dhp_term_relationships.object_id)
WHERE 1=1 AND (
dhp_term_relationships.term_taxonomy_id IN (38)
) AND dhp_posts.post_type = 'accommodation' AND ((dhp_posts.post_status = 'publish'))
GROUP BY dhp_posts.ID HAVING 1=1
ORDER BY dhp_posts.post_title ASC
LIMIT 0, 40
Mira Montra Resort Koh Mak
Mira Montra, The Beachfront Resort Koh Mak 113 Moo 1, Koh Mak, Koh Kood, Trat, Thailand
Southern
SELECT SQL_CALC_FOUND_ROWS dhp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM dhp_postmeta price_meta2 WHERE price_meta2.post_id=dhp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-12-07:2025-12-07' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM dhp_postmeta price_meta3 WHERE price_meta3.post_id=dhp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM dhp_posts LEFT JOIN dhp_term_relationships ON (dhp_posts.ID = dhp_term_relationships.object_id)
WHERE 1=1 AND (
dhp_term_relationships.term_taxonomy_id IN (39)
) AND dhp_posts.post_type = 'accommodation' AND ((dhp_posts.post_status = 'publish'))
GROUP BY dhp_posts.ID HAVING 1=1
ORDER BY dhp_posts.post_title ASC
LIMIT 0, 40
Ashlee Hub Hotel Patong
237/23 Rat-U-Thit Song Roi Pee Road, Patong, Kathu, Phuket, Thailand 83150
Blu Marine Resort And Villas
39/407 Soi Hua Hin 102, Nongkae, Hua Hin, Blu Port Shopping Mall, Prachuap Khiri Khan 77110
Deevana Patong Resort
43/2 Rat-U-Thid 200 Pee Road, Patong Beach, Kathu, Phuket 83150 Thailand
Kamalaya Wellness & Spa Resort
102/9 Moo 3, Laem Set Road, Na-Muang Koh Samui, Suratthani, 84140, Thailand
Let’s Sea Al Fresco Resort
83/188 Soi Huathanon 23 Khaotakieb – Hua Hin Road Hua Hin, Prachuap Khirikhan 77110 Thailand
Mangosteen Ayurveda and Wellness Resort
99, Soi Mangosteen, Rawai, Mueang Phuket District, Phuket 83130
OZO Chaweng Samui
11/34 Moo 2, Chaweng Beach Road, Bophut, Koh Samui, Surat Thani 84320 Thailand
The Fair House Beach Resort
124-124/1-2 Moo 3 Tambon Bophut , Amphur Koh Samui Suratthani 84320,Thailand
Varinda Garden Resort Koh Samui
82/3 Tambon Maret Lamai Beach, Maret, Surat Thani, Thailand 84310