Sultan Gardens Reort

CAST(‘” & Season2 & “‘ AS DATETIME)) ” _ & “LIMIT 1” Set RS = Conn.Execute(SQL) If Not RS.EOF Then IsAvailable = “Y” DisplaySeason = “Summer” Searchform_StartDate = CDate(RS(“OB_Depdate”)) End If Set RS = Nothing End If If IsAvailable = “N” Then ‘ Revert to winter DisplaySeason = “Winter” SQL = “SELECT * FROM Libra_Lates.AVLABL ” _ & “WHERE (Accom_Code = ‘11323’) AND ” _ & “(CAST(CONCAT(SUBSTRING(OB_Depdate, 7, 4), ‘-‘, SUBSTRING(OB_Depdate, 4, 2), ‘-‘, SUBSTRING(OB_Depdate, 1, 2)) AS DATETIME) CAST(‘” & Season2 & “‘ AS DATETIME)) ” _ & “LIMIT 1” Set RS = Conn.Execute(SQL) If Not RS.EOF Then IsAvailable = “Y” DisplaySeason = “Summer” Searchform_StartDate = CDate(RS(“OB_Depdate”)) End If End If Set RS = Nothing End If ‘ Searcform default values Searchform_SQL = “SELECT StartDate, Deppt, Arppt FROM Searchform_Defaults WHERE (Page LIKE ‘Resort’) AND (PageName LIKE ‘” & Searchform_Arppt & “‘)” If (Request.QueryString(“Season”) = “Summer”) Or (Session(“CurrentSeason”) = “Summer”) Or (DisplaySeason = “Summer”) Then Searchform_SQL = Searchform_SQL & ” AND (Season = ‘SUMMER’)” ElseIf (Request.QueryString(“Season”) = “Winter”) Or (Session(“CurrentSeason”) = “Winter”) Or (DisplaySeason = “Winter”) Then Searchform_SQL = Searchform_SQL & ” AND (Season = ‘WINTER’)” ElseIf (Request.QueryString(“Season”) = “Late”) Or (Session(“CurrentSeason”) = “Late”) Then Searchform_SQL = Searchform_SQL & ” AND (Season = ‘LATE’)” End If Set RS = Conn.Execute(Searchform_SQL) If RS.EOF Then Set RS = Conn.Execute(“SELECT StartDate, Deppt, Arppt FROM Searchform_Defaults WHERE (Page LIKE ‘Resort’) AND (PageName LIKE ‘” & Searchform_Arppt & “‘)”) If Not RS.EOF Then If Trim(RS(“StartDate”) & ” “) “” Then Searchform_StartDate = Trim(RS(“StartDate”)) If Not IsDate(Searchform_StartDate) Then Searchform_StartDate = DateAdd(“d”, Now(), 7) If Trim(RS(“Deppt”) & ” “) “” Then Searchform_Deppt = Trim(RS(“Deppt”)) If Trim(RS(“Arppt”) & ” “) “” Then Searchform_Arppt = Trim(RS(“Arppt”)) End If Set RS = Nothing If DateDiff(“d”, Now(), Searchform_StartDate)

Destinations > Egypt > Sharm El Sheikh > Sultan Gardens Reort

Sultan Gardens Reort

Sultan Gardens Reort

up down

Holidays to Sultan Gardens Reort are not currently available to book online, to check the latest availability, or for alternative holidays to Sharm El Sheikh, please call .

"") Or (Request.ServerVariables("REQUEST_METHOD") = "POST") Then %>

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) "") 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) "" 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 %>

0 Then %>

0) And (Request.QueryString("Depart_Airport_Code") "") Then %>

>

">

Choose your holiday to Sultan Gardens Reort
Departure date
Departure airport
please call for special offers to Sultan Gardens Reort
Departures from "" Then %> •   
Departures from
 
" class="Text"> nights " class="Text">fr £ More

To find your holiday to Sultan Gardens Reort, click on price below or use the search box on the right of the page.

(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

0 Then i = 0 k = k + 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 %>

>

please call for our latest holiday deals.
 
"" Then TempArr = Split(Cols(j), ":", -1, 1) %>

from ">£ ---

Hotels in Sharm El Sheikh
Reef Oasis Beach Resort 5*, Four Seasons Sharm El Sheikh 5l, The Savoy Hotel 5*, Sultan Gardens Reort, 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*, Marriott Garden Sharm Hotel 4l, Marriott Beach Sharm Hotel 4l, Sol Y Mar Sharming Inn Hotel 4*, Sol Cyrene 4*, Resta Club Resort 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*, Sol Vergnia 3*, Tsokkos Cleopatra Hotel 2l,

Search & Book