Res:1 SELECT DISTINCT p.* FROM wp_posts AS p WHERE p.ID IN ( SELECT post_id FROM wp_postmeta WHERE (meta_key = 'featured' AND meta_value = 'Yes') GROUP BY post_id HAVING count(*) = 1) AND p.post_status = 'publish' AND post_type = 'post' ORDER BY RAND() LIMIT 1
Tested & Approved
Mandalai Hotel / Koh Phangan, Thailand

The value of the hotel definitely lies in it’s location. The hotel is situated in a very quiet fishermen village. Having breakfast overlooking the ocean comes close to paradise.

SHARE this

  • RSS
  • Twitter
  • Facebook
  • email

Featured Boutique Hotels

La Maison Pujol / Carcassonne, France

Ace Hotel / Palm Springs, USA

Citizen M / Glasgow, Scotland

At Pingnakorn / Chiang Mai, Thailand

Hotel Cocoon / Salvador Bahia, Brasil

Veranda High Resort/ Chiang Mai, Thailand

Daddy Long Legs / Cape Town, South-Africa

Luxx XL / Bangkok, Thailand

Pantone Hotel / Brussels, Belgium

Pod Up North / Wisconsin, USA

Bab Hotel / Marrakesh, Morocco

Room Mate Carlos / Buenos Aires, Argentina

Hotel Amano / Berlin, Germany

Lamai Wanta / Koh Samui, Thailand