Olhuveli Beach & Spa
Olhuveli Beach & Spa – where affordable luxury and decadence meet in the heart of the Maldives. Get ready for pure indulgence: cool, contemporary villas, impressively lavish suites, and beautiful surroundings. Walk barefoot along the sandy beach and watch the palm trees as they gently lean into the breeze.
Olhuveli Beach & Spa Maldives offers the perfect recipe for a luxury holiday in the Maldives. Relax in the gorgeous sunshine on the beach, dine under the stars, and experience incredible wildlife beneath the surface with diving and snorkeling on our own private coastline.
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:2024-10-13:2026-10-13' 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 ('951') )
) 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 tours were found.