Baron Resort Hotel 5* Deluxe

Images Video

Situated on the south tip of Sinai with impressive views of the Straits of Tiran Island and with over 600 metres of private sandy beach, the FIVE-STAR LUXURY & AWARD-WINNING Baron is a well-planned and pristine resort set around 80,000 sq.m of beautiful landscaped gardens. Attention to detail and original touches are very much in evidence from the part-shaded seawater whirl pool with jets to the relaxing promenade fountain and generous room sizes. Indulge yourself at this unique and luxurious retreat - the ultimate in relaxation! <% If IsAvailable = "N" Then %>

Holidays to Baron Resort Hotel 5* Deluxe are not currently available to book online, to check the latest availability, or for alternative holidays to Sharm El Sheikh, please call <%=PhoneNo%>.

<% Else %> <% If (Request.ServerVariables("QUERY_STRING") <> "") Or (Request.ServerVariables("REQUEST_METHOD") = "POST") Then %> <% RowLimit = 10 SQL = "SELECT MIN(CAST(Adult_Price AS UNSIGNED)) AS Price, Booking_URL AS URL, Accom_Code AS Tour_Code, Hotel_Name, Country AS Holiday_Country, Resort AS Holiday_Resort, Star_Rating, Board, OB_Depdate AS Depart_Date, Duration, OB_Departure_Airport AS Depart_Airport_Code, Prio " _ & "FROM Libra_Lates.AVLABL " _ & "INNER JOIN Libra_Lates.Airport_Prio " _ & "ON Libra_Lates.AVLABL.OB_Departure_Airport = Libra_Lates.Airport_Prio.Airport_Code " _ & "WHERE (Accom_Code = '11277') " _ & " AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) > CAST('" & DatePart("yyyy", DateAdd("d", 1, Now())) & "-" & Right("00" & DatePart("m", DateAdd("d", -7, Now())), 2) & "-" & Right("00" & DatePart("d", DateAdd("d", -7, Now())), 2) & "' AS DATETIME)) " If Request.Form("Depart_Date") <> "" Then SQL = SQL & " AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) > CAST('" & DatePart("yyyy", DateAdd("d", -7, CDate(Request.Form("Depart_Date")))) & "-" & Right("00" & DatePart("m", DateAdd("d", -7, CDate(Request.Form("Depart_Date")))), 2) & "-" & Right("00" & DatePart("d", DateAdd("d", -7, CDate(Request.Form("Depart_Date")))), 2) & "' AS DATETIME)) " _ & " AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) < CAST('" & DatePart("yyyy", DateAdd("d", 7, CDate(Request.Form("Depart_Date")))) & "-" & Right("00" & DatePart("m", DateAdd("d", 7, CDate(Request.Form("Depart_Date")))), 2) & "-" & Right("00" & DatePart("d", DateAdd("d", 7, CDate(Request.Form("Depart_Date")))), 2) & "' AS DATETIME)) " ElseIf (Request.QueryString("Depart_Month") <> "") And (Request.QueryString("Depart_Year") <> "") Then SQL = SQL & " AND (SUBSTRING(OB_Depdate, 7, 4) = '" & SafeSQL(Request.QueryString("Depart_Year")) & "') AND (SUBSTRING(OB_Depdate, 4, 2) = '" & SafeSQL(Right("00" & Request.QueryString("Depart_Month"), 2)) & "') " Else If DisplaySeason = "Summer" Then SQL = SQL & "AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) > CAST('" & Season2 & "' AS DATETIME)) " Else ' If (Request.QueryString("Season") = "Winter") Or (Session("CurrentSeason") = "Winter") Then SQL = SQL & "AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) < CAST('" & Season2 & "' AS DATETIME)) " End If End If If Request.Form("Depart_Airport_Code") <> "" Then SQL = SQL & " AND (OB_Departure_Airport = '" & SafeSQL(Request.Form("Depart_Airport_Code")) & "') " ElseIf Request.QueryString("Depart_Airport_Code") <> "" Then SQL = SQL & " AND (OB_Departure_Airport = '" & SafeSQL(Request.QueryString("Depart_Airport_Code")) & "') " RowLimit = 999 End If If Request.Form("Board") <> "" Then SQL = SQL & " AND (Board = '" & SafeSQL(Request.Form("Board")) & "') " If Request.Form("Duration") <> "" Then SQL = SQL & " AND (Duration = '" & SafeSQL(Request.Form("Duration")) & "') " SQL = SQL & "GROUP BY OB_Depdate, Duration, OB_Departure_Airport " _ & "ORDER BY Prio, (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME)), (CAST(Adult_Price AS UNSIGNED))" Set RS = Conn.Execute(SQL) If RS.EOF Then %> <% Else %> <% i = 0 Do While Not RS.EOF ThisAirport = Trim(RS("Depart_Airport_Code")) ThisMonth = DatePart("m", CDate(RS("Depart_Date"))) ThisURL = Trim(RS("URL")) ThisURL = Replace(ThisURL, "holidays1.asp", "packages1.asp") ThisURL = Replace(ThisURL, "&NoAdults=", "&NumRooms=1&NoAdults_1=") ThisURL = Replace(ThisURL, "&NoChildren=", "&NoChildren_1=") ThisURL = Replace(ThisURL, "&NoInfants=", "&NoInfants_1=") ThisURL = Replace(ThisURL, "&Resort=&", "&Resort=ESH&") ThisURL = Replace(ThisURL, "&", "&") %> <% If StrComp(ThisAirport, LastAirport, vbTextCompare) <> 0 Then %> <% i = 0 %> <% End If %> <% If (StrComp(ThisMonth, LastMonth, vbTextCompare) <> 0) And (Request.QueryString("Depart_Airport_Code") <> "") Then %> <% End If %> <% If i < RowLimit Then %> > <% End If %> <% If i = RowLimit Then %> "> <% End If %> <% LastAirport = ThisAirport LastMonth = ThisMonth i = i + 1 RS.MoveNext Loop End If Set RS = Nothing %>

Choose your holiday to Baron Resort Hotel 5* Deluxe Departure date <% ThisSelected = "" SQL = "SELECT DISTINCT OB_Depdate AS Depart_Date " _ & "FROM Libra_Lates.AVLABL " _ & "WHERE (Accom_Code = '11277') " _ & " AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) > CAST('" & DatePart("yyyy", DateAdd("d", 1, Now())) & "-" & Right("00" & DatePart("m", DateAdd("d", -7, Now())), 2) & "-" & Right("00" & DatePart("d", DateAdd("d", -7, Now())), 2) & "' AS DATETIME)) " If (Request.QueryString("Depart_Month") <> "") And (Request.QueryString("Depart_Year") <> "") Then Else If DisplaySeason = "Summer" Then SQL = SQL & "AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) > CAST('" & Season2 & "' AS DATETIME)) " Else ' If (Request.QueryString("Season") = "Winter") Or (Session("CurrentSeason") = "Winter") Then SQL = SQL & "AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) < CAST('" & Season2 & "' AS DATETIME)) " End If End If If Request("Depart_Airport_Code") <> "" Then SQL = SQL & " AND (OB_Departure_Airport = '" & SafeSQL(Request("Depart_Airport_Code")) & "') " SQL = SQL & "ORDER BY (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME))" Set RS = Conn.Execute(SQL) If Not RS.EOF Then Do While Not RS.EOF ThisDate = Trim(RS(0)) ThisSelected = "" If Request.Form("Depart_Date") = ThisDate Then ThisSelected = " selected" Searchform_StartDate = ThisDate End If If (Request.QueryString("Depart_Month") <> "") And (IsNumeric(Request.QueryString("Depart_Month"))) Then If (DatePart("m", CDate(ThisDate)) = CDbl(Request.QueryString("Depart_Month"))) And (DatePart("m", CDate(ThisDate)) > DatePart("m", CDate(LastDate))) Then ThisSelected = " selected" Searchform_StartDate = ThisDate End If End If %> ><%=FormatDate(ThisDate, "Y")%> <% LastDate = ThisDate RS.MoveNext Loop End If Set RS = Nothing %> Departure airport <% SQL = "SELECT DISTINCT OB_Departure_Airport AS Depart_Airport_Code " _ & "FROM Libra_Lates.AVLABL " _ & " INNER JOIN Libra_Lates.Airport_Prio " _ & " ON Libra_Lates.AVLABL.OB_Departure_Airport = Libra_Lates.Airport_Prio.Airport_Code " _ & "WHERE (Accom_Code = '11277') " _ & " AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) > CAST('" & DatePart("yyyy", DateAdd("d", 1, Now())) & "-" & Right("00" & DatePart("m", DateAdd("d", -7, Now())), 2) & "-" & Right("00" & DatePart("d", DateAdd("d", -7, Now())), 2) & "' AS DATETIME)) " If (Request.QueryString("Depart_Month") <> "") And (Request.QueryString("Depart_Year") <> "") Then Else If DisplaySeason = "Summer" Then SQL = SQL & "AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) > CAST('" & Season2 & "' AS DATETIME)) " Else ' If (Request.QueryString("Season") = "Winter") Or (Session("CurrentSeason") = "Winter") Then SQL = SQL & "AND (CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) < CAST('" & Season2 & "' AS DATETIME)) " End If End If SQL = SQL & "ORDER BY Prio" Set RS = Conn.Execute(SQL) If Not RS.EOF Then ReDim Airports(99) i = 0 Do While Not RS.EOF Airports(i) = Trim(RS(0)) ThisSelected = "" If Request("Depart_Airport_Code") = Airports(i) Then ThisSelected = " selected" %> ><%=AirportName(Airports(i))%> <% i = i + 1 RS.MoveNext Loop End If Set RS = Nothing %>
please call <%=PhoneNo%> for special offers to Baron Resort Hotel 5* Deluxe
Departures from <% For i = 0 To UBound(Airports) %> <% If Trim(Airports(i) & " ") <> "" Then %> • <%=AirportName(Airports(i))%>   <% End If %> <% Next %>
Departures from <%=AirportName(Trim(RS("Depart_Airport_Code")))%>
<%=MonthName(ThisMonth)%>
" class="Text"><%=FormatDate(RS("Depart_Date"), "Y")%>	<%=StarRatingImage(RS("Star_Rating"))%>	<%=BoardBasis(RS("Board"))%>	<%=Trim(RS("Duration"))%> nights	" class="Text">fr £ <%=FormatNumber((CDbl(RS("Price")) / 100), 0)%>
" class="Headline" onClick="document.getElementById('More_<%=Trim(RS("Depart_Airport_Code"))%>').style.display='block';document.getElementById('MoreLink_<%=Trim(RS("Depart_Airport_Code"))%>').style.display='none';">Show more holidays from <%=AirportName(Trim(RS("Depart_Airport_Code")))%>

<% Else %> <% SQL = "SELECT DISTINCT SUBSTRING(OB_Depdate, 4, 2) AS Month " _ & "FROM Libra_Lates.AVLABL " _ & "WHERE (Country NOT LIKE 'holiday country') AND (Accom_Code = '11277') " _ & "GROUP BY SUBSTRING(OB_Depdate, 4, 2) " _ & "ORDER BY CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), SUBSTRING(OB_Depdate, 4, 2)) AS UNSIGNED)" Set RS = Conn.Execute(SQL) If Not RS.EOF Then %>

To find your holiday to Baron Resort Hotel 5* Deluxe, click on price below or use the search box on the right of the page.

<% Months = RS.GetRows() ReDim Cols(UBound(Months, 2)) SQL = "SELECT MIN(CAST(Adult_Price AS UNSIGNED)) AS Price, Country, Area, Resort, SUBSTRING(OB_Depdate, 4, 2) AS Month, SUBSTRING(OB_Depdate, 7, 4) AS Year, Airport_Prio.Airport_Code " _ & "FROM Libra_Lates.AVLABL " _ & "INNER JOIN Libra_Lates.Board_Prio ON Libra_Lates.AVLABL.Board = Libra_Lates.Board_Prio.Board_Code " _ & "INNER JOIN Libra_Lates.Airport_Prio ON Libra_Lates.AVLABL.OB_Departure_Airport = Libra_Lates.Airport_Prio.Airport_Code " _ & "WHERE (Country NOT LIKE 'holiday country') AND " _ & "(CAST(CONCAT('20', SUBSTRING(OB_Depdate, 7, 2), '-', SUBSTRING(OB_Depdate, 4, 2), '-', SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME)) > (CAST('" & DatePart("yyyy", DateAdd("d", 1, Now())) & "-" & Right("00" & DatePart("m", DateAdd("d", 1, Now())), 2) & "-" & Right("00" & DatePart("d", DateAdd("d", 1, Now())), 2) & "' AS DATETIME)) AND " _ & "(Board_Prio.Prio > 1) AND (Board_Prio.Prio < 7) AND (Accom_Code = '11277') " _ & "GROUP BY Airport_Prio.Airport_Code, SUBSTRING(OB_Depdate, 4, 2) " _ & "ORDER BY Airport_Prio.Prio, CAST(CONCAT('20', SUBSTRING(OB_Depdate, 7, 4), SUBSTRING(OB_Depdate, 4, 2)) AS UNSIGNED), MIN(CAST(Adult_Price AS UNSIGNED))" Set RS = Server.CreateObject("ADODB.Recordset") RS.CursorLocation = 3 ' adUseClient RS.Open SQL, Conn i = 0 j = 0 x = 0 If RS.EOF Then %> <% Else %> <% For k = 0 To UBound(Months, 2) %> <% Next %> <% Do While Not RS.EOF ThisAirport = Trim(RS("Airport_Code")) If StrComp(ThisAirport, LastAirport, vbTextCompare) <> 0 Then i = 0 j = 0 x = x + 1 End If RS.MoveNext If Not RS.EOF Then NextAirport = Trim(RS("Airport_Code")) Else NextAirport = "" End If RS.MovePrevious 'CurCol = j CurCol = CDbl(RS("Month")) - Month(Now()) : If CurCol < 0 Then CurCol = CurCol + 11 Cols(CurCol) = RS("Month") & ":" & RS("Year") & ":" & Trim(RS("Price")) If StrComp(ThisAirport, NextAirport, vbTextCompare) <> 0 Then %> > <% For k = 0 To UBound(Cols) %> <% If Trim(Cols(k) & " ") <> "" Then TempArr = Split(Cols(k), ":", -1, 1) %> <% Else %> <% End If %> <% Next %> <% ReDim Cols(UBound(Months, 2)) %> <% i = i + 1 %> <% End If %> <% LastAirport = ThisAirport j = j + 1 RS.MoveNext Loop End If Set RS = Nothing %>

please call <%=PhoneNo%> for our latest holiday deals.
	<%=MonthName(CDbl(Months(0, k)), True)%>
<%=AirportName(ThisAirport)%>	from <%=AirportName(ThisAirport)%>">£<%=FormatNumber((CDbl(TempArr(2)) / 100), 0)%>	---

<% End If %> <% End If %> <% End If %>

Location
The Baron Hotel is situated in a prime location on the South tip of the Sinai, Ras Nasrani Bay which at certain times of the year the coral on the beach turns to a bright pink colour due to the sun's reflection off the Sinai mountains, the Baron Hotel has it own private sandy beach which is 600m long (Sea is accessed via a 145m long floating jetty). The hotel is 15km away from Na'ama bay.

Facilities
· 24hr Reception · free wi-fi in the loby area (24hrs). 2 Swimming Pools one olympic size freshwater (heated in winter) Sunloungers & Parasols; Towels at the beach & pool· Jogging Route · 2 Flood lit Tennis Courts*. Diving centre. water sports · Beach Volleyball · Beach Soccer · Table Tennis · Billiards · Darts · State of the Art Gym* (Open: 7am-9pm) · Daily beach Aerobics ·Health club & relaxation centre including: Spa* · Sauna* · Massage* · Beauty Treatments* · Steam Bath · Beach massage tent . Money Exchange · Cash Machine· Laundry/Dry Cleaning* · Internet Café* Billiard Bar* BARON Shopping boulevard with mini market . Hairdresser · Small International Library · Souvenir Shop · Shuttle Bus to Na'ama Bay* · Sinai Restaurant "Main Restaurant" for Buffet Style · Within the grounds of the Baron Resort Hotel, there is a wide array of Bars, Lounges including pool resraurant & bar; beach bar & lounge; 24 hrs. lobby bar & piano lounge; an oriental cafe serving shisha; and an elegant bar serving exclusive cocktails and premium cigars and 4 A La Carte Restaurants. Come and savour a lavish Italian, Indian, Egyptian or a Seafood meal or enjoy cocktails at the disco which goes on until the early hours of the morning.

Children Facilities
· Children's Pool (Heated in winter) · Kid's Club(4-12years old) · Playroom beach and indoor Playground · Highchairs & Free Cots, special menus for kids, baby sitting service upon request.

Entertainment
International animation team for soft daily day & evening activity programmes. It has cabaret, musicals, dance competitions, oriental shows, comedy shows, quiz, beach party and international show. The hotel also offers daily live entertainments in different venues, and a roman amphitheatre.

Accommodation
Well -apponted spacious rooms and junior and executive suites 2/3beds (plus extra child bed if required), All rooms come with an en suite bathroom, individually controllable Air conditioning and heating, Satellite/ Cable TV, Mini Bar, Safety Deposit Box, Telephone, celing fan, seating area, Hairdryer with balcony or terrace. 24 hrs room service (Rooms can accommodate 2 Adults & 2 Children). Non-smoking rooms available on request; A Royal suite with a private pool is also available.

Board Basis
Prices are based on 2 adults sharing on Bed & Breakfast basis.

Supplements
Half Board, Full Board, Premium All-Inclusive, Deluxe Sea View, Single.

Winter Variation
Christmas & New Year's Eve gala dinners are included in the price.

All Inclusive
Breakfast: Complete American Buffet 'Sinai" Main Restaurant 06:30-10:30, Late Breakfast: Continental 'Oasis' Pool Restaurant & Bar 10:30-12:00 Lunch: Complete International Buffet 'Sinai' Main Restaurant 12:30-15:00 Light Meals and Snacks 'Oasis' Pool Restaurant & Bar 12:00-17:00varieties of sandwiches - ' Palm Beach Bar & Lounge-12:00-15:00Free ice cream 'Oasis' pool restaurant & bar - 12:00 - 17:00Afternoon Tea & Coffee with cakes and cookies 'Palm' Beach Restaurant & Lounge 16:00-18:00Dinner: Complete International Buffet with daily changing themes 'Sinai' Restaurant 18:30-22:00 Dinner: Egyptian A la Carte* (reservation required) 'Egyptian' Restaurant 19:00-23:00 Candlelight Dinner* (reservation required) 'Bella Vista' Italian restaurant 19:00-23:00 Midnight Snacks (Daily changing snacks) 'Khan El Khalili' Oriental Café 23:30-00:30 Dinner (once per week) at the Indian A la Carte Restaurant 19:00 - 23:00; All Dinner Reservations to be booked daily at the Reception before 12:00hrs (Except for Sinai Restaurant)* Local Beverages, Local alcoholics and imported alcohols: 'Panorama Lobby Bar & Piano Lounge: imported alcohol from 10:00-24:00; 'Palm' Beach Restaurant & Lounge 10:00-23 24 :00; 'Oasis' Pool Restaurant & Bar: imported alcohol from 10:00-18:30; 'Now & Zen' Dance Bar: Imported alcohols from 22:00 to 02:00; 'Khan El Khalili' Oriental Café 19:00-24:00Extras included in the premium all inclusive:· once per week gala dinner (egyptian or seafood)· daily free dinner in italian; seafood; egyptian; and bbq dinner in the oasis pool restuarnt & bar· once per week laundry service (excluding dry cleaning)· mini bar, daily refilled· free introduction dive· fruit basket upon arrival· ovce per week adult haircut· once per week 30 mins. anti-stress massage· once per week usage of tennis floodlighting.The following services and facilities are not part of the Premium All Inclusive package and have to be paid for locally: International and Premium Beverages, all beverages after midnight, mini-bar, 24hrs room service, laundry, internet, shops, spa, Massages and Beauty Treatments, shell-fish and smoked salmon at the 'Bella Vista' Italian Restaurant, water pipe Shisha, excursions, medical care, water sport centre, diving centre, conference and banqueting facilities, evening floodlit tennis courts. Added Value 'Dine Around Package' bonus for all guests: a discount on food only applies at 'Taj Mahal' Indian and 'Al Sakia' Seafood Restaurants for Dinner Only and with previous reservation at the Front Office daily by 12noon. Drinks consumed are extra charged. men are requested to wear long trousers during dinner.

No of Rooms
360

No of Floors
3

No of Lifts
2

Official Rating
5* Deluxe

Our Rating
LLLLL Deluxe

Hotels in Sharm El Sheikh
The Savoy Hotel 5*, Sofitel Sharm Hotel 5*, Sierra Hotel 5*, Ritz Carlton Hotel 5*, Renaissance Golden View Beach Hotel 5*, Novotel Palms Hotel 5*, Novotel Beach Sharm Hotel 5*, Maritim Jolieville Golf & Resort 5*, Maritim Jolie Ville Royal Peninsula 5*, Jaz Mirabel Club Hotel 5*, Jaz Belvedere Hotel 5*, Hyatt Regency Sharm Hotel 5*, Hilton Sharm Waterfalls Resort Hotel 5*, Hilton Sharm Dreams Resort Hotel 5*, Hauza Beach Hotel 5*, Baron Resort Hotel 5* Deluxe, Baron Palms Hotel 5*, Sol Y Mar Sharming Inn Hotel 4*, Laguna Vista Garden Resort Hotel 4*, Iberotel Club Fanara Hotel 4*, Hilton Sharm Fayrouz Resort Hotel 4*, Hilton Sharks Bay Resort Hotel 4*, El Hayat Sharm El Sheikh Resort 4*, Eden Rock Hotel 4*, Amarante Garden Palms Hotel 4*, Sol Y Mar Shams Suites 3*,