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-11-14:2027-11-14' 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 = 'accommodation_star_count'
) 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 36, 12
Staying overnight in a beachfront bungalow on a tranquil islet-like Wuzhizhou, situated in the east of Sanya, is a truly romantic and idyllic choice. The islet is approximately a 40-minute drive from Sanya Airport and just 30 minutes from Downtown.
Nestled within the Wuzhishan National Tropical Rainforest Natural Reserve in Shuiman Town, the Wuzhishan Yatai Tropical Rainforest Resort on Hainan Island offers an ideal accommodation choice for those planning to explore Wuzhishan Mountain.
Located at the base of Qixianling Mountain in Baoting City, Hainan Island, the Baoting Qixianling DoubleTree Resort by Hilton offers a serene retreat amidst the natural beauty of Qixianling National Tropical Forest Park.
The Sanya Intercontinental Resort Luhuitou Peninsula is conveniently located just a 30-minute drive from Sanya Airport. Situated right on Xiaodonghai Beach Luhuitou Peninsula, it's a mere 5-minute drive to Sanya.
