SELECT SQL_CALC_FOUND_ROWS wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-04-27:2026-04-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts
WHERE 1=1 AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY accommodation_price ASC
LIMIT 0, 12
A charming French-Lao Colonial style property, Souphattra Hotel is located in the UNESCO World Heritage area with historical charms as the main design criteria
Located in Pakbeng, Le Grand Pakbeng Resort is in a rural area and on the waterfront. Don't miss out on a visit to Mekong Elephant Park. Be sure not to miss outdoor adventures like ecotours and hiking/biking trails.
We’re here to craft you a seamless experience – from your days as a forest nomad to your nights sleeping soundly in the plush bed of your restful cocoon – by keeping that connection to the earth unbroken.
an Unique Beach resort on Nam Ngum Lake, with full activities available on land and the lake, close to Vang Vieng for a day out, and 45 minutes from Vientiane,
an ideal location for those wanting to leave the city and be as one with Nature.
A fusion of Lao and contemporary decor, Parasol Blanc offers a beautiful garden and lotus pond, where the restaurant is located. All rooms are comfortable, and have individually controlled air-conditioning, shower, cable television, IDD telephone, mini-bar, tea & coffee making facilities, in-room safe, hair dryer and complementary bottled water.