Unknown MySQL server host 'insigaa2.memset.net' (1)
[select bnb.bnb_id, bnb.bnb_name, bnb.town, bnb.county, bnb.description, bnb.picture, options.secure_bookings, options.map, options.member_type, options.special_offers, (@url := if(url != '', concat('http://www.', url), concat('http://www.bnb-network.com/bed-breakfast/', replace(replace(lower(county), '&', 'and'), ' ', '-'), '/', replace(replace(lower(town), '&', 'and'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html'))) is not null, (@page := if((member_type = 'guesthouse' or member_type = 'premium+'), 'rates.html', if(member_type = 'premium' , 'offers.html', ''))) is not null, case when locate('?', url) > 0 then concat(substring_index(@url, '?', 1), @page, '?bnb_id=', bnb_id) else concat(@url, '/', @page) end as url from bnb, options where (bnb.country = 'Northern Ireland' or bnb.additional_search like '%Northern Ireland') and case when 'Antrim' != '' then (bnb.additional_search like '% Antrim %' or bnb.additional_search like '% Antrim' or bnb.additional_search like 'Antrim %' or bnb.additional_search = 'Antrim' or bnb.county = 'Antrim') else bnb.county != 'Best' end and case when '' != '' then bnb.town = '' else bnb.town != 'Best' end and options.bnb_ref = bnb.bnb_id and options.active = 'true' and options.member_type != 'non' and options.special_offers = 'true' and exists ( select heading from offers where never = 'false' and current_date between `from` and `to` and date_add(current_date, interval 15 day) >= offer_end and active = 'true' and lastminute = 'true' and offers.bnb_ref = bnb.bnb_id )]Unknown MySQL server host 'insigaa2.memset.net' (1)
[select bnb.bnb_id, bnb.bnb_name, bnb.town, bnb.county, bnb.description, bnb.picture, options.secure_bookings, options.map, options.member_type, options.special_offers, (@url := if(url != '', concat('http://www.', url), concat('http://www.bnb-network.com/bed-breakfast/', replace(replace(lower(county), '&', 'and'), ' ', '-'), '/', replace(replace(lower(town), '&', 'and'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html'))) is not null, (@page := if((member_type = 'guesthouse' or member_type = 'premium+'), 'rates.html', if(member_type = 'premium' , 'offers.html', ''))) is not null, case when locate('?', url) > 0 then concat(substring_index(@url, '?', 1), @page, '?bnb_id=', bnb_id) else concat(@url, '/', @page) end as url from bnb, options where (bnb.country = 'Northern Ireland' or bnb.additional_search like '%Northern Ireland') and case when 'Antrim' != '' then (bnb.additional_search like '% Antrim %' or bnb.additional_search like '% Antrim' or bnb.additional_search like 'Antrim %' or bnb.additional_search = 'Antrim' or bnb.county = 'Antrim') else bnb.county != 'Best' end and case when '' != '' then bnb.town = '' else bnb.town != 'Best' end and options.bnb_ref = bnb.bnb_id and options.active = 'true' and options.member_type != 'non' and options.special_offers = 'true' and exists ( select heading from offers where never = 'false' and current_date between `from` and `to` and date_add(current_date, interval 15 day) >= offer_end and active = 'true' and lastminute = 'true' and offers.bnb_ref = bnb.bnb_id )] Last Minute B&B
•  Northern Ireland
•  B&B in Family Homes
•  Hotel Accommodation
•  Ireland Car Rental
•  Guesthouses
•  Belfast & Londonderry
•  Last Minute Deals

Visitors Guide to Northern Ireland

Unknown MySQL server host 'insigaa2.memset.net' (1)
[select town, county, country from bnb, options where case when 'Northern Ireland' != '' then (country = 'Northern Ireland' or additional_search like '%Northern Ireland%') else country != '' end and case when 'Antrim' != '' then (bnb.additional_search like '% Antrim %' or bnb.additional_search like '% Antrim' or bnb.additional_search like 'Antrim %' or bnb.additional_search = 'Antrim' or bnb.county = 'Antrim') else bnb.county != 'Best' end and options.bnb_ref = bnb.bnb_id and options.active = 'true' and exists ( select heading from offers where never = 'false' and current_date between `from` and `to` and date_add(current_date, interval 15 day) <= `to` and active = 'true' and lastminute = 'true' and price > 0 and offers.bnb_ref = bnb.bnb_id ) group by town order by town]Unknown MySQL server host 'insigaa2.memset.net' (1)
[select town, county, country from bnb, options where active = 'true' and bnb_id = bnb_ref and case when 'Antrim' != '' then (bnb.additional_search like '% Antrim %' or bnb.additional_search like '% Antrim' or bnb.additional_search like 'Antrim %' or bnb.additional_search = 'Antrim' or bnb.county = 'Antrim') else county != 'Best' end and case when 'Northern Ireland' != '' then (country = 'Northern Ireland' or additional_search like '%Northern Ireland%') else country != '' end and case when 'bed-breakfast' = 'hotels' then (options.member_type = 'guesthouse' or options.member_type like 'premium%') when 'bed-breakfast' = 'bed-breakfast' then options.member_type != 'non' and options.member_type != 'nad' when 'bed-breakfast' = 'accommodation' then options.member_type != '' when 'bed-breakfast' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non' when 'bed-breakfast' = 'hostels-accommodation' then bnb.type = 'hostel' when 'bed-breakfast' = 'premium' then bnb.type like '%hotel%' and options.member_type != 'non' when 'bed-breakfast' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non' when 'bed-breakfast' != '' then options.member_type = 'bed-breakfast' else options.member_type != '' end group by town order by town]B&B Network
•  Home Page
•  Add Your B&B
•  Premium Selection
•  Hostels
ADVERTISING



Antrim •  Last Minute 

You are viewing •  Last Minute  in: Antrim

Properties 0 of
Sorry, there are no Last Minute Offers in Antrim available today - please try again soon
or visit Red Dot Deals