The luxury Maritim Jolie Ville Golf & Resort Hotel occupies a prime spot atop a low rock plateau overlooking the ocean. The magnificent coastal bays just below the hotel are quickly reached over the walkway, play golf or simply relax at the beach or beside the swimming pool - there's no better place to do it all than the fantastic Jolie Ville Golf & Resort! Whether you come to Sharm El Sheikh for business or pleasure, this hotel offers a friendly atmosphere and makes your stay a pleasant one.
<% If IsAvailable = "N" Then %>
Holidays to Maritim Jolieville Golf & Resort 5* 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 = '11252') " _
& " 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
%>
| please call <%=PhoneNo%> for special offers to Maritim Jolieville Golf & Resort 5* |
<% Else %>
| Departures from
<% For i = 0 To UBound(Airports) %>
<% If Trim(Airports(i) & " ") <> "" Then %>
• <%=AirportName(Airports(i))%>
<% End If %>
<% Next %>
|
<%
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 %>
|
| Departures from <%=AirportName(Trim(RS("Depart_Airport_Code")))%> |
<% i = 0 %>
<% End If %>
<% If (StrComp(ThisMonth, LastMonth, vbTextCompare) <> 0) And (Request.QueryString("Depart_Airport_Code") <> "") Then %>
| |
| <%=MonthName(ThisMonth)%> |
<% End If %>
<% If i < RowLimit Then %>
>
" 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)%>  |
<% End If %>
<% If i = RowLimit Then %>
">
| " 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")))%> |
<% End If %>
<%
LastAirport = ThisAirport
LastMonth = ThisMonth
i = i + 1
RS.MoveNext
Loop
End If
Set RS = Nothing
%>
<% Else %>
<%
SQL = "SELECT DISTINCT SUBSTRING(OB_Depdate, 4, 2) AS Month " _
& "FROM Libra_Lates.AVLABL " _
& "WHERE (Country NOT LIKE 'holiday country') AND (Accom_Code = '11252') " _
& "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 Maritim Jolieville Golf & Resort 5*, 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 = '11252') " _
& "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
%>
| please call <%=PhoneNo%> for our latest holiday deals. |
<% Else %>
| |
<% For k = 0 To UBound(Months, 2) %>
<%=MonthName(CDbl(Months(0, k)), True)%> |
<% 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
%>
>
<%=AirportName(ThisAirport)%> |
<% For k = 0 To UBound(Cols) %>
<%
If Trim(Cols(k) & " ") <> "" Then
TempArr = Split(Cols(k), ":", -1, 1)
%>
from <%=AirportName(ThisAirport)%>">£<%=FormatNumber((CDbl(TempArr(2)) / 100), 0)%> |
<% 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
%>
<% End If %>
<% End If %>
<% End If %>
Location
On a cliff-top in a quiet setting surrounded by spectacular mountains, desert and sea, with its own private beach, 7km from Naama Bay.
Facilities
ˇ 24hr Reception ˇ 3 Swimming Pools with water slides (2 Heated during winter months) ˇ 4 Floodlit Tennis Courts* ˇ Beach Volleyball ˇ Beach Soccer ˇ Table Tennis ˇ Gym* ˇ Aerobics* ˇ Spa* ˇ Sauna* ˇ Massage* ˇ Beauty Treatments* ˇ Steam Bath* ˇ Money Exchange ˇ Cash Machine ˇ Laundry/Dry Cleaning* ˇ Internet Café ˇ Souvenir Shop ˇ Shuttle Bus to Naama Bay ˇ Choice of restaurants & Barsˇ Beach BBQ ˇ Pool Terrace ˇ Pavilion Bar (Located in Sports Area) ˇ Beach Bar.
Children Facilities
ˇ 2 Children's Pool (1 Heated in the winter months) ˇ Kid's Club (4-12 yrs) ˇ Playground ˇ Highchairs & Cots.
Entertainment
International animation team for daily day & evening activity programme.
Accommodation
2/3 beds, All rooms come with an en suite bathroom, individually controllable Air conditioning and heating, Satellite/ Cable TV, Mini Bar*, Safety Deposit Box*, Telephone*, Hairdryer and balcony or terrace. (Rooms can accommodate 2 Adults & 2 Children). Royal Wing: For the ultimate in comfort indulge yourself with a stay in the brand new Royal Wing. Built in a low-rise style and featuring extremely spacious rooms and suites, each with a large luxury bathroom and private terrace overlooking a beautiful swimming pool. The Jolie Ville Royal Wing in addition also features a lebanese restaurant (open evenings only) and an island restaurant and bar located in the middle of the swimming pool. Rooms can accommodate up to 2 adults and 2 children or 3 adults.
Board Basis
Prices are based on 2 adults sharing on Bed & Breakfast basis.
Supplements
Half Board, Prestige All-inclusive, Pool View, Sea View, Royal Wing, Single.
Honeymoon
Fruit Basket, Room upgrade (Subject to availability).
All Inclusive
Available at a Supplement:ˇ Breakfast: Open buffet at the Main Restaurant "Les Palmires" 6:00 - 7:00 continental and 07:00-10:30 full ˇ Lunch: Open buffet at the Main Restaurant "Les Palmires" 12:30-15:00 ˇ Set menu at the Pool BBQ Restaurant 12:30-15:30 ˇ Menu at the Treasure Cove Bar on the beach 12:30-15:30 ˇ Dinner: open buffet at the Main Restaurant "Les Palmires" 18:30-22:30 (Winter Time) and 19:00 - 22:30 (Summer Time) ˇ Beverages Services: Local Alcoholic Drinks: whisky, gin, vodka, rum, wine, beer. Non-Alcoholic Drinks: soft drinks, mineral water, juices - beverages are served at the Main Buffet restaurant "Les Palmires" during lunch and dinner, at the Ascot Bar and Jolie Bistro 18:00-24:00, at the pool BBQ Restaurant and the Treasure Cove Bar 11:00-Sunset, Tea, Coffee, Cake and pastries time at the Jolie Bistro 16:00-18:00 ˇ Unlimited ice-cream for kids only at the Pool BBQ Restaurant 12:30-15:30 ˇ Euro9 / $12 free credit note from the total amount of bill is offered for dinner at the "Zaman" Lebanese Restaurant and "Mandarin" Chinese Restaurant once a week (reservation is recommended) ˇ Dine around with special set menu at the Jolie Bistro once a week (reservation is recommended) ˇ Sports included: Tennis, beach volleyball, table tennis, beach and swimming pool, gym, snorkelling equipment, aqua gym ˇ Entertainment: Daily live music, three live shows per week, free internet (wireless at the lobby / wired in guest rooms) ˇ For Kids: Kids Club open seven days a week, Children's pool, playground, special kids program, aqua park, children chairs, baby cots, kids menu.
No of Rooms
418 (28 Suites)
No of Floors
3
No of Lifts
1
Official Rating
5*
Our Rating
LLLLL
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*,
