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:2025-02-12:2027-02-12' 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 INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
wp_postmeta.meta_key = 'review_score'
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_postmeta.meta_value+0 ASC
LIMIT 0, 12
Mission Hills Resort Haikou is conveniently situated just 15 minutes away from the city center and Haikou Meilan International Airport. Traveling from Sanya to Mission Hills Resort Haikou is easy and swift.
A 3-star beachfront resort on Hainan Island, offering spacious rooms, private balconies, and stunning ocean views. Ideal for kiteboarding and kitesurfing enthusiasts, it's the perfect choice for a moderate yet memorable stay.
Yalong Bay Villa & Spa is the best choice for big family stay or friends gathering in Yalong Bay with spacious garden, private pool, big terrace and kitchen.