<%@ page language="java" session="true" import="java.util.*,java.sql.*,javax.servlet.http.*,java.io.*,java.text.SimpleDateFormat " %> <%@ include file="shareMethod.htm" %> <%@ include file="header.htm" %> <% Connection tmp = dbConnection1.getConnection(); Statement stmt= tmp.createStatement(); //String country=request.getParameter("country"); String country="U A E"; String query= "select * from newOffer where country='"+country+"' and hotelName='Le Meridien Mina Seyahi' order by price "; ResultSet rs =stmt.executeQuery(query); //out.println(query); %>
  
Photo Gallery

Le Meridien Mina Seyahi 5*

Le Meridien Mina Seyahi Beach Resort & Marina offers both an idyllic location and proximity to the heart of the city. Its 500-metre-long private beach offers exceptional opportunities for diverse water sports.

Facilities:

  • Waves - International cuisine.
  • Retro - the hotels stylish, chic restaurant, serves modern British dishes with a French twist
  • Ciros Pomodoro - newly opened Italian restaurant
  • Horizon Poolside Bar
  • Lobby Lounge Bar
  • 24-hour room service
  • Two temperature-controlled swimming pools
  • Fully equipped gym overlooking the swimming pool and sea
  • 5 swimming pools including 2 shaded childrens pools
  • Football pitch
  • PADI diving centre
  • Sauna and steam room
  • Sailing - catamaran, Hobby Cat, Laser, windsurfing, speedboat, fishing charters
  • French bowls or pétanque, five-a-side football, beach volleyball, diving
  • Beauty salon
  • Barber shop
  • Gift shop
  • Hair salon
  • Newsstand
  • Disabled ramp and wheelchair access
  • Handicapped room capabilities

Rooms:

All rooms have:

  • Air conditioning
  • Alarm clock (on TV)
  • Bathrobe and slippers
  • Complimentary newspapers
  • Computer Dataport (via telephone)
  • Hairdryer
  • International direct dial telephone
  • Iron and ironing board (available from housekeeping)
  • Laundry service
  • Minibar
  • Remote-controlled cable Satellite television
  • Safety deposit box/In-room safe
  • Stereo/Hi-Fi/CD player
  • Turndown service
  • Umbrellas
  • Voicemail
Deluxe Land-Facing: like the Deluxe Sea-Facing rooms, but overlooking the new marina (in the process of beening built), rather than the sea. As these rooms do not have balconies, they are larger than those overlooking the sea. Suitable for three adults

Deluxe Sea-Facing: all rooms in this category have an uninterrupted, spectacular view of the sea, the swimming pool and the rich landscaping. The sunsets, enjoyed by most rooms, are not to be missed, especially from the balconies. Not suitable for three adults.

Royal Club Land View: overlooking the new marina, rather than the sea. As these rooms do not have balconies, they are larger than those overlooking the sea. Access to the Royal Club Lounge, and facilities include butler service, continental breakfast in the lounge, happy hour and business services.

Royal Club Sea View: all have balconies and superb views of the sea, swimming pool and landscaping. These rooms have a dressing area, leaving the room free of clutter. Access to the Royal Club Lounge, and facilities include butler service, continental breakfast in the lounge, happy hour and business services. Not suitable for three adults

Extra beds only rooms facing the marina can accommodate an extra bed. Sea View rooms can only accommodate a baby cot.
<% int count=0; while(rs.next()){ count++; int acount=0; acount=count%2; %> bgcolor="E1E1FF"<%}else{%>bgcolor="ffffff"<%}%> align="center"> <%}%>
All prices are per person and include Flights, transfers, accomdation & taxes.
<%=rs.getString("hotelName")%> <%=rs.getString("board")%> <%=rs.getString("nts")%> Nights <%=rs.getString("airport")%> <%=editDate(rs.getString("validDate"))%>
to
<%=editDate(rs.getString("type1"))%> 		£ <%=rs.getString("price")%> ">Details/Booking
<%@ include file="footer.htm" %>