,
,
Contact:
Please Mention the B&B Network when calling  National 0
   Room Rates
   B&B Offers
  Last Minute Deals
  Rates for Special Events
Please Mention the B&B Network when calling  Intl +
 B&B

Standard Rates & Offers

  1. Select your Arrival & Departure dates
  2. Check Availability & Prices
  3. Select the number of Rooms required
  4. Click 'Send Booking Enquiry'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND bnbrates.active = 'TRUE' AND CASE WHEN options.special_offers = 'false' TH' at line 47
[SELECT bnbrates.id, bnbrates.ratetype, case when 0 != 0 and length(bnbrates.caption) > 43 then concat(substring(bnbrates.caption, 1, 40), '...') else bnbrates.caption end as caption, bnbrates.caption as fullcaption, bnbrates.description, CASE WHEN pax = 'per room' THEN 1 WHEN rooms.sleeps IS NOT NULL THEN rooms.sleeps ELSE 2 END AS paxmultiplier, replace(bnbrates.pax, ' ', '
') as pax, bnbrates.period, bnbrates.nights as numnights, case when bnbrates.nights <= 0 or bnbrates.nights = 1 then 'per night' else concat(bnbrates.nights, ' nights') end as nights, bnbrates.rooms, bnbrates.startdate, bnbrates.enddate, bnbrates.price, CASE WHEN bnbrates.ratetype != 'standard' THEN '•' ELSE '' END AS offer, CASE WHEN rooms.type IS NULL THEN bnbrates.roomtype ELSE rooms.type END AS roomtype, CASE WHEN rooms.totalrooms IS NULL THEN 3 ELSE rooms.totalrooms END AS totalrooms, CASE WHEN '' = '' THEN date_format(current_date, '%D %M, %Y') WHEN month(date('')) = month(date('')) THEN concat(date_format(date(''), '%D - '), date_format(date(''), '%D %M, %Y')) WHEN year(date('')) = year(date('')) THEN concat(date_format(date(''), '%D %M - '), date_format(date(''), '%D %M, %Y')) ELSE concat(date_format(date(''), '%D %M, %Y'), ' - ', date_format(date(''), '%D %M, %Y')) END AS dates, CASE WHEN month(startdate) = month(enddate) THEN concat(date_format(startdate, '%D - '), date_format(enddate, '%D %M, %Y')) WHEN year(startdate) = year(enddate) THEN concat(date_format(startdate, '%D %M - '), date_format(enddate, '%D %M, %Y')) ELSE concat(date_format(startdate, '%D %M, %Y'), ' - ', date_format(enddate, '%D %M, %Y')) END AS offerdates, CASE WHEN month(startdate) = month(enddate) THEN concat(date_format(startdate, '%e - '), date_format(enddate, '%e %b')) WHEN year(startdate) = year(enddate) THEN concat(date_format(startdate, '%e %b - '), date_format(enddate, '%e %b')) ELSE concat(date_format(startdate, '%e %b'), ' - ', date_format(enddate, '%e %b')) END AS shortdates, CASE WHEN month(startdate) = month(enddate) THEN concat(date_format(startdate, '%e-'), date_format(enddate, '%e %b')) WHEN year(startdate) = year(enddate) THEN concat(date_format(startdate, '%e %b-'), date_format(enddate, '%e %b')) ELSE concat(date_format(startdate, '%e %b'), '-', date_format(enddate, '%e %b')) END AS extrashortdates FROM bnbrates LEFT OUTER JOIN rooms ON (rooms.id = bnbrates.roomtype OR (rooms.type = bnbrates.roomtype AND rooms.bnb_ref = bnbrates.bnb_ref)) LEFT OUTER JOIN options ON options.bnb_ref = bnbrates.bnb_ref WHERE bnbrates.bnb_ref = AND bnbrates.active = 'TRUE' AND CASE WHEN options.special_offers = 'false' THEN ratetype != 'specialoffer' ELSE 1 END AND CASE WHEN options.last_minute = 'false' THEN ratetype != 'lastminute' ELSE 1 END AND CASE WHEN ratetype = 'lastminute' THEN enddate <= date_add(current_date, interval 15 day) ELSE enddate >= current_date END AND bnbrates.rooms != 0 AND (@nights := IF('' != '', '', 0)) IS NOT NULL AND (@arrival := IF('' = '', current_date, DATE(''))) IS NOT NULL AND (@departure := IF('' = '', 0, DATE(''))) IS NOT NULL AND @arrival < enddate AND CASE WHEN @departure != 0 THEN @departure > startdate ELSE 1 END AND CASE WHEN @nights > 0 THEN @nights >= bnbrates.nights AND @nights % bnbrates.nights = 0 ELSE bnbrates.nights > 0 END AND CASE WHEN @nights > 0 THEN CASE WHEN bnbrates.period = 'weekend' THEN @nights <= 2 AND dayofweek(@arrival) >= 6 AND dayofweek(@departure) <= 7 WHEN bnbrates.period = 'midweek' THEN @nights <= 4 AND dayofweek(@arrival) >= 1 AND dayofweek(@departure) <= 6 WHEN bnbrates.period = 'bankholiday' THEN @nights <= 3 AND dayofweek(@arrival) >= 6 AND (dayofweek(@departure) <= 7 OR dayofweek(@departure) = 1) WHEN bnbrates.period = 'sunday' THEN @nights = 1 AND dayofweek(@arrival) = 1 AND dayofweek(@departure) = 2 ELSE @arrival < @departure END ELSE 1 = 1 END ORDER BY bnbrates.enddate, bnbrates.roomtype, bnbrates.startdate, bnbrates.price]
There are currently no rates available for the dates selected. Please send us an Email Enquiry. Rates Total Rooms

There are currently no offer listed. Please send us an Email Enquiry
 

€ 00.00 Total

- Booking Terms & Conditions


Legend
A guide to the icons used on this website

Last Minute deals = Last Minute Offer = Send an Email Enquiry
Special Offers = Special Offer = 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