Host 'insigaa1.memset.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
[select bnb.*, options.*, case when tel != '' then concat('Tel: +44 (0)', tel) else '' end as tel, case when bnb.email != '' then bnb.email else ' ' end as email, case when member_type != 'associate' and member_type != 'non' then concat('http://www.', url) when member_type = 'associate' then 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') else '' end as url, case when member_type = 'non' or member_type ='nad' then 0 else 1 end as sortorder from bnb, options where case when '' != '' then (bnb.continent = '' or bnb.additional_search like '%') else continent != 'Best' end and case when 'Ireland' != '' then (bnb.country like '%Ireland' or bnb.additional_search like '%Ireland%') else country != '' end and case when 'Kerry' != '' then (bnb.additional_search like '% Kerry %' or bnb.additional_search like '% Kerry' or bnb.additional_search like 'Kerry %' or bnb.additional_search = 'Kerry' or bnb.county like '%Kerry%') else bnb.county != 'Best' end and case when '' = '' and 'Waterville' != '' then (town like 'Waterville%' or additional_search like '%Waterville%') when 'Waterville' != '' then (bnb.town = 'Waterville' or additional_search like '%Waterville%') else bnb.town != 'Best' end and options.bnb_ref = bnb.bnb_id and options.active = 'true' and case when 'bed-breakfast' = 'premium+' 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' = 'allaccommodation' then options.member_type != '' when 'bed-breakfast' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non' and options.member_type != 'nad' when 'bed-breakfast' = 'allhostels' then bnb.type = 'hostel' when 'bed-breakfast' = 'premium' then (options.member_type = 'premium' or options.member_type = 'guesthouse' or options.member_type = 'premium+') when 'bed-breakfast' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non' when 'bed-breakfast' != '' and 'bed-breakfast' != 'allaccommodation' then options.member_type = 'bed-breakfast' else options.member_type != '' end order by sortorder desc, rand(2104624374)]Host 'insigaa1.memset.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
[select bnb.*, options.*, case when tel != '' then concat('Tel: +44 (0)', tel) else '' end as tel, case when bnb.email != '' then bnb.email else ' ' end as email, case when member_type != 'associate' and member_type != 'non' then concat('http://www.', url) when member_type = 'associate' then 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') else '' end as url, case when member_type = 'non' or member_type ='nad' then 0 else 1 end as sortorder from bnb, options where case when '' != '' then (bnb.continent = '' or bnb.additional_search like '%') else continent != 'Best' end and case when 'Ireland' != '' then (bnb.country like '%Ireland' or bnb.additional_search like '%Ireland%') else country != '' end and case when 'Kerry' != '' then (bnb.additional_search like '% Kerry %' or bnb.additional_search like '% Kerry' or bnb.additional_search like 'Kerry %' or bnb.additional_search = 'Kerry' or bnb.county like '%Kerry%') else bnb.county != 'Best' end and case when '' = '' and 'Waterville' != '' then (town like 'Waterville%' or additional_search like '%Waterville%') when 'Waterville' != '' then (bnb.town = 'Waterville' or additional_search like '%Waterville%') else bnb.town != 'Best' end and options.bnb_ref = bnb.bnb_id and options.active = 'true' and case when 'bed-breakfast' = 'premium+' 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' = 'allaccommodation' then options.member_type != '' when 'bed-breakfast' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non' and options.member_type != 'nad' when 'bed-breakfast' = 'allhostels' then bnb.type = 'hostel' when 'bed-breakfast' = 'premium' then (options.member_type = 'premium' or options.member_type = 'guesthouse' or options.member_type = 'premium+') when 'bed-breakfast' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non' when 'bed-breakfast' != '' and 'bed-breakfast' != 'allaccommodation' then options.member_type = 'bed-breakfast' else options.member_type != '' end order by sortorder desc, rand(2104624374)] Waterville B&B - Kerry Bed & Breakfast Accommodation in Waterville Ireland
•  B&B Waterville
•  Bed & Breakfast
•  Kerry Accommodation
•  Last Minute Deals
•  Late Rooms & Offers
•  Hotels Waterville
•  Ireland Accommodation

Bed & Breakfast Waterville

Visitors Guide
•  Home Page
•  Activities
•  Restaurants
•  Local Pubs
•  Fishing & Angling
•  Waterville Golf
•  Walking & Cycling
•  Maps
•  Ireland's Weather
•  Picture Gallery
•  Exchange Rates
•  Our Newsletter
•  Legal Stuff
Accommodation
Waterville B&B•  Premium Accommodation
•  Last Minute
•  Special Offers
•  Holiday Homes
B&B Owners
•  Add a B&B
•  B&B Membership
•  Members List
Contact Us
•  Brochures
•  Banner Advertising
•  Office
•  Friends Links
•  Glossary
Ring of Kerry Websites
•  Ring of Kerry
•  Killarney
•  Rossmaine
•  Killorglin
•  Cahersiveen
•  The Skelligs
•  Kenmare
•  Caherdaniel
•  Map of Kerry

Ring of Kerry
ADVERTISING

B&B Network Members in Waterville

You are viewing accommodation in: Waterville

Properties 0 of
Sorry, there are not any Premium Members in Waterville.
Please visit www.bnb-network.ie for accommodation outside the Waterville Locality.
Click here to return to Waterville bed-breakfast accommodation.