Home Page,
,
Contact:
National 0
• Room Rates
• B&B Offers
• Last Minute Deals in
• Rates for Special Events
Intl +
• B&B Offers
• Last Minute Deals in
• Rates for Special Events
Intl +
[ Last Minute & Standard Rates ][ Special Offers ] [ Booking Terms ] [ Legend ]
Host 'insigaa1.memset.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'[select id, caption, byline, bnbrates.description, nights, price, roomtype, ratesmessage, rooms, replace(pax, ' ', '
') as pax, nights as numnights, (@sortdate := if(MONTH(enddate) < MONTH(CURRENT_DATE) and ratetype = 'standard', date_add(enddate, interval 1 year), enddate)) as sortdate, case when nights <= 0 or nights = 1 then 'per night' else concat(nights, ' nights') end as nights, case when day(startdate) = day(enddate) and month(startdate) = month(enddate) then date_format(startdate, '%e %b \'%y') when month(startdate) = month(enddate) then concat(day(startdate), ' - ', date_format(@sortdate, '%e %b \'%y')) when year(startdate) = year (enddate) then concat(date_format(startdate, '%e %b'), ' - ', date_format(enddate, '%e %b'), date_format(@sortdate, ' \'%y')) else concat(date_format(startdate, '%e %b \'%y'), ' - ', date_format(@sortdate, '%e %b \'%y')) end as `dates`, unix_timestamp(enddate) as endstamp from bnbrates, bnb where bnb_ref = and active = 'true' and rooms != 0 and bnb.bnb_id = bnbrates.bnb_ref and ratetype = 'specialoffer' and current_date <= enddate having case when rooms = -1 then '' < sortdate else '' < date_sub(sortdate, interval numnights day) end order by sortdate]
Last Minute Offers & Standard Rates
Host 'insigaa1.memset.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
[select bnbrates.id, price, ratesmessage, ratetype, rooms, case when 0 != 0 and length(caption) > 43 then concat(substring(caption, 1, 40), '...') else caption end as caption, replace(pax, ' ', '
') as pax, case when ratetype = 'lastminute' then '•' else '' end as reddot, nights as numnights, case when rooms.type is NULL then bnbrates.roomtype else rooms.type end as roomtype, (@sortdate := if(MONTH(enddate) < MONTH(CURRENT_DATE) and ratetype = 'standard', date_add(enddate, interval 0 year), enddate)) as sortdate, case when nights <= 0 or nights = 1 then 'per night' else concat(nights, ' nights') end as nights,case when day(startdate) = day(enddate) and month(startdate) = month(enddate) then date_format(startdate, '%e %b \'%y') when month(startdate) = month(enddate) then concat(day(startdate), ' - ', date_format(@sortdate, '%e %b \'%y')) when year(startdate) = year (enddate) then concat(date_format(startdate, '%e %b'), ' - ', date_format(enddate, '%e %b'), date_format(@sortdate, ' \'%y')) else concat(date_format(startdate, '%e %b \'%y'), ' - ', date_format(@sortdate, '%e %b \'%y')) end as `dates`, unix_timestamp(enddate) as endstamp, case when rates_currency != '' then rates_currency when country_codes.currency_symbol is not NULL then country_codes.currency_symbol else '€' end as currency from bnbrates left outer join rooms on rooms.id = bnbrates.roomtype left join bnb on bnb.bnb_id = bnbrates.bnb_ref left outer join country_codes on country_codes.country = bnb.country where bnbrates.bnb_ref = and active = 'true' and rooms != 0 and bnb.bnb_id = bnbrates.bnb_ref and case when 'false' = 'false' then ratetype != 'valuebreak' and ratetype != 'specialoffer' else ratetype != '' end having case when ratetype = 'lastminute' then '2010-09-07' between date_sub(sortdate, interval 15 day) and sortdate when rooms = -1 then '2010-09-07' < sortdate else '2010-09-07' < date_sub(sortdate, interval numnights day) end order by ratetype desc, sortdate]
[select bnbrates.id, price, ratesmessage, ratetype, rooms, case when 0 != 0 and length(caption) > 43 then concat(substring(caption, 1, 40), '...') else caption end as caption, replace(pax, ' ', '
') as pax, case when ratetype = 'lastminute' then '•' else '' end as reddot, nights as numnights, case when rooms.type is NULL then bnbrates.roomtype else rooms.type end as roomtype, (@sortdate := if(MONTH(enddate) < MONTH(CURRENT_DATE) and ratetype = 'standard', date_add(enddate, interval 0 year), enddate)) as sortdate, case when nights <= 0 or nights = 1 then 'per night' else concat(nights, ' nights') end as nights,case when day(startdate) = day(enddate) and month(startdate) = month(enddate) then date_format(startdate, '%e %b \'%y') when month(startdate) = month(enddate) then concat(day(startdate), ' - ', date_format(@sortdate, '%e %b \'%y')) when year(startdate) = year (enddate) then concat(date_format(startdate, '%e %b'), ' - ', date_format(enddate, '%e %b'), date_format(@sortdate, ' \'%y')) else concat(date_format(startdate, '%e %b \'%y'), ' - ', date_format(@sortdate, '%e %b \'%y')) end as `dates`, unix_timestamp(enddate) as endstamp, case when rates_currency != '' then rates_currency when country_codes.currency_symbol is not NULL then country_codes.currency_symbol else '€' end as currency from bnbrates left outer join rooms on rooms.id = bnbrates.roomtype left join bnb on bnb.bnb_id = bnbrates.bnb_ref left outer join country_codes on country_codes.country = bnb.country where bnbrates.bnb_ref = and active = 'true' and rooms != 0 and bnb.bnb_id = bnbrates.bnb_ref and case when 'false' = 'false' then ratetype != 'valuebreak' and ratetype != 'specialoffer' else ratetype != '' end having case when ratetype = 'lastminute' then '2010-09-07' between date_sub(sortdate, interval 15 day) and sortdate when rooms = -1 then '2010-09-07' < sortdate else '2010-09-07' < date_sub(sortdate, interval numnights day) end order by ratetype desc, sortdate]
| Period | Room Type | Description | Rates | Book Here |
|---|
- Booking Terms & Conditions
Legend
A guide to the icons used on this website
 |
= Last Minute Offer |  |
= Make a Firm Credit Card Booking |
 |
= Send an Email Enquiry |  |
= Request the Offer - Await Confirmation |
 |
= Room for Single Occupation |  |
= Wireless Internet Access |
 |
= Room for Two with Double Bed |  |
= Automobile Association Recommended |
 |
= Room for Two with 2 Single Beds |  |
= No Smoking Establishment |
 |
= Family Room - 1 Double Bed + 1 Single Bed |  |
= Wheelchair Access |
 |
= Family Room - 2 Double Beds |  |
= Private Offroad parking |
 |
= Cellphone & Phone Numbers from within |  |
= Restaurant |
 |
= International Cellphone & Phone Numbers |  |
= We Accept Credit Cards |