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
Lamai Wanta / Koh Samui, Thailand

This little gem is a true value for money like you can only find in Thailand. The resort with beach front swimming pool and café is a beautiful example of an accommodation with better standards […]

SHARE this

  • RSS
  • Twitter
  • Facebook
  • email

Featured Boutique Hotels

The Praktik / Barcelona, Spain

Chic & Basic Tallers / Barcelona, Spain

Ostel / Berlin, Germany

La Maison Pujol / Carcassonne, France

Pantone Hotel / Brussels, Belgium

Citizen M / Glasgow, Scotland

At Pingnakorn / Chiang Mai, Thailand

Room Mate Carlos / Buenos Aires, Argentina

Veranda High Resort/ Chiang Mai, Thailand

MichelBerger Hotel / Berlin, Germany

Ibsens Hotel / Copenhagen, Denmark

Ecopod / Argyll, Scotland

25 Hours Hotel / Wien, Austria

Luxx XL / Bangkok, Thailand

Lub d Siam / Bangkok, Thailand

Pod Up North / Wisconsin, USA

Bab Hotel / Marrakesh, Morocco

Ace Hotel / Palm Springs, USA

Hotel Amano / Berlin, Germany

Back Home / Kuala Lumpur, Malaysia

Pages:12»