<% sql = "SELECT * FROM tariff WHERE T_r_type = 'Single'" sqle = "SELECT * FROM tariff WHERE T_r_type = 'Executive'" sql2 = "SELECT * FROM tariff WHERE T_r_type = 'Double'" sql3 = "SELECT * FROM tariff WHERE T_r_type = 'Double_single'" sql4 = "SELECT * FROM tariff WHERE T_r_type = 'Family'" sqlsp = "SELECT * FROM tariff WHERE T_r_type = 'Single'" sqlspe = "SELECT * FROM tariff WHERE T_r_type = 'Executive'" sqlsp2 = "SELECT * FROM tariff WHERE T_r_type = 'Double'" sqlsp3 = "SELECT * FROM tariff WHERE T_r_type = 'Double_single'" sqlsp4 = "SELECT * FROM tariff WHERE T_r_type = 'Family'" sqlsp2_1 = "SELECT * FROM tariff WHERE T_r_type = 'Single'" sqlsp2_1e = "SELECT * FROM tariff WHERE T_r_type = 'Executive'" sqlsp2_2 = "SELECT * FROM tariff WHERE T_r_type = 'Double'" sqlsp2_3 = "SELECT * FROM tariff WHERE T_r_type = 'Double_single'" sqlsp2_4 = "SELECT * FROM tariff WHERE T_r_type = 'Family'" sqlsp3_1 = "SELECT * FROM tariff WHERE T_r_type = 'Single'" sqlsp3_1e = "SELECT * FROM tariff WHERE T_r_type = 'Executive'" sqlsp3_2 = "SELECT * FROM tariff WHERE T_r_type = 'Double'" sqlsp3_3 = "SELECT * FROM tariff WHERE T_r_type = 'Double_single'" sqlsp3_4 = "SELECT * FROM tariff WHERE T_r_type = 'Family'" set rs = cn.execute(sql) while not rs.eof mt_s_bb = rs("mt_bb") mt_s_dbb = rs("mt_dbb") fs_s_bb = rs("fs_bb") fs_s_dbb = rs("fs_dbb") rs.movenext Wend set rs = cn.execute(sqle) while not rs.eof mt_e_bb = rs("mt_bb") mt_e_dbb = rs("mt_dbb") fs_e_bb = rs("fs_bb") fs_e_dbb = rs("fs_dbb") rs.movenext Wend set rs = cn.execute(sql2) while not rs.eof mt_d_bb = rs("mt_bb") mt_d_dbb = rs("mt_dbb") fs_d_bb = rs("fs_bb") fs_d_dbb = rs("fs_dbb") rs.movenext Wend set rs = cn.execute(sql3) while not rs.eof mt_ds_bb = rs("mt_bb") mt_ds_dbb = rs("mt_dbb") fs_ds_bb = rs("fs_bb") fs_ds_dbb = rs("fs_dbb") rs.movenext Wend set rs = cn.execute(sql4) while not rs.eof mt_f_bb = rs("mt_bb") mt_f_dbb = rs("mt_dbb") fs_f_bb = rs("fs_bb") fs_f_dbb = rs("fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp) on error goto 0 while not rs.eof sp_dte_frm = rs("sp_dte_frm") sp_dte_to = rs("sp_dte_to") sp_mt_s_bb = rs("sp_mt_bb") sp_mt_s_dbb = rs("sp_mt_dbb") sp_fs_s_bb = rs("sp_fs_bb") sp_fs_s_dbb = rs("sp_fs_dbb") sp_nights = rs("sp_nights") sp_active = rs("sp_active") rs.movenext Wend set rs = cn.execute(sqlspe) on error goto 0 while not rs.eof sp_mt_e_bb = rs("sp_mt_bb") sp_mt_e_dbb = rs("sp_mt_dbb") sp_fs_e_bb = rs("sp_fs_bb") sp_fs_e_dbb = rs("sp_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp2) while not rs.eof sp_mt_d_bb = rs("sp_mt_bb") sp_mt_d_dbb = rs("sp_mt_dbb") sp_fs_d_bb = rs("sp_fs_bb") sp_fs_d_dbb = rs("sp_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp3) while not rs.eof sp_mt_ds_bb = rs("sp_mt_bb") sp_mt_ds_dbb = rs("sp_mt_dbb") sp_fs_ds_bb = rs("sp_fs_bb") sp_fs_ds_dbb = rs("sp_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp4) while not rs.eof sp_mt_f_bb = rs("sp_mt_bb") sp_mt_f_dbb = rs("sp_mt_dbb") sp_fs_f_bb = rs("sp_fs_bb") sp_fs_f_dbb = rs("sp_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp2_1) on error goto 0 while not rs.eof sp1_dte_frm = rs("sp1_dte_frm") sp1_dte_to = rs("sp1_dte_to") sp1_mt_s_bb = rs("sp1_mt_bb") sp1_mt_s_dbb = rs("sp1_mt_dbb") sp1_fs_s_bb = rs("sp1_fs_bb") sp1_fs_s_dbb = rs("sp1_fs_dbb") sp1_nights = rs("sp1_nights") sp1_active = rs("sp1_active") rs.movenext Wend set rs = cn.execute(sqlsp2_1e) on error goto 0 while not rs.eof sp1_mt_e_bb = rs("sp1_mt_bb") sp1_mt_e_dbb = rs("sp1_mt_dbb") sp1_fs_e_bb = rs("sp1_fs_bb") sp1_fs_e_dbb = rs("sp1_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp2_2) while not rs.eof sp1_mt_d_bb = rs("sp1_mt_bb") sp1_mt_d_dbb = rs("sp1_mt_dbb") sp1_fs_d_bb = rs("sp1_fs_bb") sp1_fs_d_dbb = rs("sp1_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp2_3) while not rs.eof sp1_mt_ds_bb = rs("sp1_mt_bb") sp1_mt_ds_dbb = rs("sp1_mt_dbb") sp1_fs_ds_bb = rs("sp1_fs_bb") sp1_fs_ds_dbb = rs("sp1_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp2_4) while not rs.eof sp1_mt_f_bb = rs("sp1_mt_bb") sp1_mt_f_dbb = rs("sp1_mt_dbb") sp1_fs_f_bb = rs("sp1_fs_bb") sp1_fs_f_dbb = rs("sp1_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp3_1) on error goto 0 while not rs.eof sp2_dte_frm = rs("sp2_dte_frm") sp2_dte_to = rs("sp2_dte_to") sp2_mt_s_bb = rs("sp2_mt_bb") sp2_mt_s_dbb = rs("sp2_mt_dbb") sp2_fs_s_bb = rs("sp2_fs_bb") sp2_fs_s_dbb = rs("sp2_fs_dbb") sp2_nights = rs("sp2_nights") sp2_active = rs("sp2_active") rs.movenext Wend set rs = cn.execute(sqlsp3_1e) on error goto 0 while not rs.eof sp2_mt_e_bb = rs("sp2_mt_bb") sp2_mt_e_dbb = rs("sp2_mt_dbb") sp2_fs_e_bb = rs("sp2_fs_bb") sp2_fs_e_dbb = rs("sp2_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp3_2) while not rs.eof sp2_mt_d_bb = rs("sp2_mt_bb") sp2_mt_d_dbb = rs("sp2_mt_dbb") sp2_fs_d_bb = rs("sp2_fs_bb") sp2_fs_d_dbb = rs("sp2_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp3_3) while not rs.eof sp2_mt_ds_bb = rs("sp2_mt_bb") sp2_mt_ds_dbb = rs("sp2_mt_dbb") sp2_fs_ds_bb = rs("sp2_fs_bb") sp2_fs_ds_dbb = rs("sp2_fs_dbb") rs.movenext Wend set rs = cn.execute(sqlsp3_4) while not rs.eof sp2_mt_f_bb = rs("sp2_mt_bb") sp2_mt_f_dbb = rs("sp2_mt_dbb") sp2_fs_f_bb = rs("sp2_fs_bb") sp2_fs_f_dbb = rs("sp2_fs_dbb") rs.movenext Wend %> Queensgate Hotel Tariffs

BOOK ONLINE and save 10%
(NB special offers NOT included)
<% enddate = Date If (sp_dte_frm <> "" AND sp_dte_to >= enddate AND sp_active = True) then %> <%If sp_mt_s_bb <> 0 then%> <%Else%> <%end if%> <%If sp_mt_s_dbb <> 0 then%> <%else%> <%end if%> <%If sp_fs_s_bb <> 0 then%> <%else%> <%end if%> <%If sp_fs_s_dbb <> 0 then%> <%else%> <%end if%> <%If sp_mt_e_bb <> 0 then%> <%Else%> <%end if%> <%If sp_mt_e_dbb <> 0 then%> <%else%> <%end if%> <%If sp_fs_e_bb <> 0 then%> <%else%> <%end if%> <%If sp_fs_e_dbb <> 0 then%> <%else%> <%end if%> <%If sp_mt_d_bb <> 0 then%> <%else%> <%end if%> <%If sp_mt_d_dbb <> 0 then%> <%else%> <%end if%> <%If sp_fs_d_bb <> 0 then%> <%else%> <%end if%> <%If sp_fs_d_dbb <> 0 then%> <%else%> <%end if%> <%If sp_mt_f_bb <> 0 then%> <%else%> <%end if%> <%If sp_mt_f_dbb <> 0 then%> <%else%> <%end if%> <%If sp_fs_f_bb <> 0 then%> <%else%> <%end if%> <%If sp_fs_f_dbb <> 0 then%> <%else%> <%end if%> <%If sp_mt_ds_bb <> 0 then%> <%else%> <%end if%> <%If sp_mt_ds_dbb <> 0 then%> <%else%> <%end if%> <%If sp_fs_ds_bb <> 0 then%> <%else%> <%end if%> <%If sp_fs_ds_dbb <> 0 then%> <%else%> <%end if%> <% else%> <%end if%> <% enddate = Date If (sp1_dte_frm <> "" AND sp1_dte_to >= enddate AND sp1_active = True) then %> <%If sp1_mt_s_bb <> 0 then%> <%Else%> <%end if%> <%If sp1_mt_s_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_s_bb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_s_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_mt_e_bb <> 0 then%> <%Else%> <%end if%> <%If sp1_mt_e_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_e_bb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_e_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_mt_d_bb <> 0 then%> <%else%> <%end if%> <%If sp1_mt_d_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_d_bb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_d_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_mt_f_bb <> 0 then%> <%else%> <%end if%> <%If sp1_mt_f_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_f_bb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_f_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_mt_ds_bb <> 0 then%> <%else%> <%end if%> <%If sp1_mt_ds_dbb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_ds_bb <> 0 then%> <%else%> <%end if%> <%If sp1_fs_ds_dbb <> 0 then%> <%else%> <%end if%> <%else%> <%end if%> <% enddate = Date If (sp2_dte_frm <> "" AND sp2_dte_to >= enddate AND sp2_active = True) then %> <%If sp2_mt_s_bb <> 0 then%> <%Else%> <%end if%> <%If sp2_mt_s_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_s_bb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_s_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_mt_e_bb <> 0 then%> <%Else%> <%end if%> <%If sp2_mt_e_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_e_bb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_e_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_mt_d_bb <> 0 then%> <%else%> <%end if%> <%If sp2_mt_d_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_d_bb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_d_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_mt_f_bb <> 0 then%> <%else%> <%end if%> <%If sp2_mt_f_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_f_bb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_f_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_mt_ds_bb <> 0 then%> <%else%> <%end if%> <%If sp2_mt_ds_dbb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_ds_bb <> 0 then%> <%else%> <%end if%> <%If sp2_fs_ds_dbb <> 0 then%> <%else%> <%end if%> <%else%> <%end if%>

Tariffs

Standard room rates <%=Year(Now)%>

Monday - Friday

Saturday - Sunday

Bed & Breakfast

Dinner, Bed and Breakfast

Bed & Breakfast

Dinner, Bed and Breakfast

Single

<%=FormatCurrency(mt_s_bb)%>

<%=FormatCurrency(mt_s_dbb)%>

<%=FormatCurrency(fs_s_bb)%>

<%if fs_s_dbb = 0 then%> Not available <%else%> <%=FormatCurrency(fs_s_dbb)%> <%end if%>

Executive <%=FormatCurrency(mt_e_bb)%> <%=FormatCurrency(mt_e_dbb)%> <%=FormatCurrency(fs_e_bb)%> <%if fs_e_dbb = 0 then%> Not available <%else%> <%=FormatCurrency(fs_e_dbb)%> <%end if%>

Double / Twin

<%=FormatCurrency(mt_d_bb)%>

<%=FormatCurrency(mt_d_dbb)%>

<%=FormatCurrency(fs_d_bb)%>

<%if fs_d_dbb = 0 then%> Not available <%else%> <%=FormatCurrency(fs_d_dbb)%> <%end if%>

Family

<%=FormatCurrency(mt_f_bb)%>

<%=FormatCurrency(mt_f_dbb)%>

<%=FormatCurrency(fs_f_bb)%>

<%if fs_f_dbb = 0 then%> Not available <%else%> <%=FormatCurrency(fs_f_dbb)%> <%end if%>

Double (as Single)

<%=FormatCurrency(mt_ds_bb)%>

<%=FormatCurrency(mt_ds_dbb)%>

<%=FormatCurrency(fs_ds_bb)%>

<%if fs_ds_dbb = 0 then%> Not available <%else%> <%=FormatCurrency(fs_ds_dbb)%> <%end if%>
Honeymoon Suite £170 £170 £170 £170

Special offer available from <%=sp_dte_frm%> to <%=sp_dte_to%> <%if sp_nights = 0 then%> <%else%>
Minimum stay <%=sp_nights%> Nights <%end if%>

Single

<%=FormatCurrency(sp_mt_s_bb)%>

Not available

<%=FormatCurrency(sp_mt_s_dbb)%>

Not available

<%=FormatCurrency(sp_fs_s_bb)%>

Not available

<%=FormatCurrency(sp_fs_s_dbb)%>

Not Available

Executive

<%=FormatCurrency(sp_mt_e_bb)%>

Not available

<%=FormatCurrency(sp_mt_e_dbb)%>

Not available

<%=FormatCurrency(sp_fs_e_bb)%>

Not available

<%=FormatCurrency(sp_fs_e_dbb)%>

Not available

Double / Twin

<%=FormatCurrency(sp_mt_d_bb)%>

Not available

<%=FormatCurrency(sp_mt_d_dbb)%>

Not available

<%=FormatCurrency(sp_fs_d_bb)%>

Not available

<%=FormatCurrency(sp_fs_d_dbb)%>

Not available

Family

<%=FormatCurrency(sp_mt_f_bb)%>

Not available

<%=FormatCurrency(sp_mt_f_dbb)%>

Not available

<%=FormatCurrency(sp_fs_f_bb)%>

Not available

<%=FormatCurrency(sp_fs_f_dbb)%>

Not available

Double (as Single)

<%=FormatCurrency(sp_mt_ds_bb)%>

Not available

<%=FormatCurrency(sp_mt_ds_dbb)%>

Not available

<%=FormatCurrency(sp_fs_ds_bb)%>

Not available

<%=FormatCurrency(sp_fs_ds_dbb)%>

Not available

Special offer available from <%=sp1_dte_frm%> to <%=sp1_dte_to%> <%if sp1_nights = 0 then%> <%else%>
Minimum stay <%=sp1_nights%> Nights <%end if%>

Single

<%=FormatCurrency(sp1_mt_s_bb)%>

Not available

<%=FormatCurrency(sp1_mt_s_dbb)%>

Not available

<%=FormatCurrency(sp1_fs_s_bb)%>

Not available

<%=FormatCurrency(sp1_fs_s_dbb)%>

Not available

Executive

<%=FormatCurrency(sp1_mt_e_bb)%>

Not available

<%=FormatCurrency(sp1_mt_e_dbb)%>

Not available

<%=FormatCurrency(sp1_fs_e_bb)%>

Not available

<%=FormatCurrency(sp1_fs_e_dbb)%>

Not available

Double / Twin

<%=FormatCurrency(sp1_mt_d_bb)%>

Not available

<%=FormatCurrency(sp1_mt_d_dbb)%>

Not available

<%=FormatCurrency(sp1_fs_d_bb)%>

Not available

<%=FormatCurrency(sp1_fs_d_dbb)%>

Not available

Family

<%=FormatCurrency(sp1_mt_f_bb)%>

Not available

<%=FormatCurrency(sp1_mt_f_dbb)%>

Not available

<%=FormatCurrency(sp1_fs_f_bb)%>

Not available

<%=FormatCurrency(sp1_fs_f_dbb)%>

Not available

Double (as Single)

<%=FormatCurrency(sp1_mt_ds_bb)%>

Not available

<%=FormatCurrency(sp1_mt_ds_dbb)%>

Not available

<%=FormatCurrency(sp1_fs_ds_bb)%>

Not available

<%=FormatCurrency(sp1_fs_ds_dbb)%>

Not available

Special offer available from <%=sp2_dte_frm%> to <%=sp2_dte_to%> <%if sp2_nights > 0 then%>
Minimum stay <%=sp2_nights%> Nights <%else%> <%end if%>

Single

<%=FormatCurrency(sp2_mt_s_bb)%>

Not available

<%=FormatCurrency(sp2_mt_s_dbb)%>

Not available

<%=FormatCurrency(sp2_fs_s_bb)%>

Not available

<%=FormatCurrency(sp2_fs_s_dbb)%>

Not available

Executive

<%=FormatCurrency(sp2_mt_e_bb)%>

Not available

<%=FormatCurrency(sp2_mt_e_dbb)%>

Not available

<%=FormatCurrency(sp2_fs_e_bb)%>

Not available

<%=FormatCurrency(sp2_fs_e_dbb)%>

Not available

Double / Twin

<%=FormatCurrency(sp2_mt_d_bb)%>

Not available

<%=FormatCurrency(sp2_mt_d_dbb)%>

Not available

<%=FormatCurrency(sp2_fs_d_bb)%>

Not available

<%=FormatCurrency(sp2_fs_d_dbb)%>

Not available

Family

<%=FormatCurrency(sp2_mt_f_bb)%>

Not available

<%=FormatCurrency(sp2_mt_f_dbb)%>

Not available

<%=FormatCurrency(sp2_fs_f_bb)%>

Not available

<%=FormatCurrency(sp2_fs_f_dbb)%>

Not available

Double (as Single)

<%=FormatCurrency(sp2_mt_ds_bb)%>

Not available

<%=FormatCurrency(sp2_mt_ds_dbb)%>

Not available

<%=FormatCurrency(sp2_fs_ds_bb)%>

Not available

<%=FormatCurrency(sp2_fs_ds_dbb)%>

Not available

Conditions:

Check in is from 2pm on the day of arrival and check out is by 11am on the day of departure.
A pre-authorisation of your credit card may be taken to secure your booking and payment of your room will be taken on arrival

Cancellation policy: By 2pm on the previous day before the day of arrival to avoid full cancellation charges.

Family Rooms priced on children under 5, for older children please contact us.

Executive room rate - as single occupancy. Double occupancy supplement of £8.50 for bed & breakfast and £20.50 for dinner, bed & breakfast.

Prices include VAT.

Copyright 2004 The Queensgate Hotel. All rights reserved.

Designed and powered by Bizzinter.net Ltd