SELECT 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-26:2027-11-26' 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_location_post_id' AND wp_postmeta.meta_value IN ('3383') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Hotel Jen Malé
Malé City
From
US$
340
Whether you are on a business trip in the Maldives, or stopping by the capital city Male' before heading to a resorts island, Hotel Jen provides one of the best accommodations in the capital for a reasonable price.
Maagiri Hotel Male’
Malé City
From
US$
298
Featuring modern rooms with the stunning views of the surrounding Ocean, Maagiri Hotel is placed in one of the best places in the capital city. Whether your trip is strictly business or for leisure, Maagiri Hotel is the option to go for.
