Egypt Sharm El-Sheikh is the popular Egyptian resort town, Home to hidden gems with its popular beach resorts, rich underwater habitat, beautiful coral reefs and unique diving spots.book with umrah package.
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-11-21:2026-11-21' 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 ('12134') )
) 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
5 Day Sharm ul Sheikh Holiay Tour
Day 01 – (Arrival at Cairo airport):
Arrival at Sharm El Sheik Airport at 03:05 PM , Representative will be there holding a sign with your name to meet and assist you through the Airport formalities.
Transfer in our Private A/C Coach to check in your hotel.
Day 02 – FREE Tour at SOHO SQUARE HOLLYWOOD Tour
Day 03 – TIRAN ISLAND SEA TRIP
Breakfast at Your Hotel then Meet our representative to transfer you to enjoy Tiran Island enjoy your lunch on board then you will have the opportunity for snorkeling (Equipment’s not included)
Transfer you back to your hotel
Day 04 – Free Day at your leisure – Quad Bike Safari
Enjoy your day at the resort .
By 06:00 Pm you will meet our representative to enjoy Quad Bike safari
Day 05 – Final departure
Enjoy breakfast at your hotel and check out almost by 12:00 PM
We will transfer you to Sharm el Sheik International airport for your final departure.
Meals Breakfast Lunch and Dinner at Sharm El Sheik Resort