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:2023-12-01:2025-12-01' 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 ('4621') )
) 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
Unfortunately no accommodations were found.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.
Tour Highlighted:
Tour Plan Itinerary: 5 Day Maldives Honeymoon Package
DAY 1: ARRIVAL & EXPLORE MAAFUSHI
Upon arrival at your Hotel you will have time to settle in before exploring the island with your guide to get yourself acquainted with the layout and to observe local life in the Maldives. Try tasty traditional hedhika – Maldivian savory and sweet snacks served with black tea at a local cafe.
DAY 2: Free Day
Following breakfast, Free day at your own leisure.
DAY 3: SNORKELING, SANDBANK, & PICNIC LUNCH
Following breakfast, you will be taken by speedboat to an idyllic sandbank just a short distance from Maafushi. Here you have the opportunity to swim, snorkel, or just lie back and relax. On the return journey to Maafushi, cruise the Indian Ocean on the look out for dolphins. This evening, dinner will be served on the beach under the stars, a truly magical experience!
DAY 4: GULHI ISLAND VISIT
Following an early breakfast, we take a short journey to the quiet local island of Gulhi where your guide will accompany you on a tour of the island. You can head to the bikini beach or for the more energetic, join your guide for a final Scuba Dive opportunity on the house reef of Gulhi.
DAY 5: MALÉ CITY TOUR & DEPARTURE
The remainder of the day is free for you to explore Malé, enjoy lunch, buy souvenirs or just watch the world go by from a local coffee house. Transfer to Velana International Airport or your onward destination.)visit historical sites including Hukuru Miskiiy – Old Friday Mosque, The Grand Friday Mosque, and Sultan Park)Optional
