<!-- directoryAccomodation() --><!-- SELECT 
  			bnb_options.bnb_id, 
  			bnb_options.bnb_name, 
  			bnb_options.town, 
  			bnb_options.county, 
  			bnb_options.country, 
  			bnb_options.continent, 
  			bnb_options.tel,
  			bnb_options.tel as telephone,
  			country_codes.code as tel_prefix,
  			CASE WHEN tel != '' THEN CONCAT('+', country_codes.code, ' ', tel)
  			  ELSE ''
  			  END AS fulltelephone,
  			bnb_options.type,
    		(@address1 := if(bnb_options.address1 = '', ' ', bnb_options.address1)) AS address1, 
    		(@address2 := if(bnb_options.address2 = '', ' ', bnb_options.address2)) AS address2, 
    		(@address3 := if(bnb_options.address3 = '', ' ', bnb_options.address3)) AS address3,  
    		CASE WHEN @address1 = ' ' AND @address2 = ' ' AND @addres3 = ' ' THEN ' '
    			ELSE concat(@address1, (if(@address1 != ' ' && @address2 != ' ', ', ', '')), @address2, (if(@address2 != ' ' && @address3 != ' ', ', ', '')), @address3)
    			END AS address,
    		CASE WHEN 'bnb-directory' = 'bnb-directory' THEN CONCAT(SUBSTRING(bnb_options.description, 1, 250), '')
    			ELSE bnb_options.description
    			END AS description,
    		bnb_options.wifi, 
    		bnb_options.map, 
    		bnb_options.secure_bookings, 
    		bnb_options.member_type,
    		CONCAT('http://www.bnb-network.com/contactform.html?bnb_id', bnb_options.bnb_id) AS contact_url,
        CONCAT('http://www.bnb-booking.com/bed-breakfast/', REPLACE(REPLACE(LOWER(REPLACE(bnb_options.town, '\'', '')), '&', 'and'), ' ', '-'), '/', REPLACE(REPLACE(LOWER(bnb_options.bnb_name), ' ', '-'), '&', 'and') , '.html') AS bnbbookingurl,
        (@url := if(bnb_options.member_type != 'associate' AND bnb_options.member_type != 'internationalassociate' AND bnb_options.member_type != 'non' and bnb_options.member_type != 'nad', CONCAT('http://www.', bnb_options.url),
        	if(bnb_options.member_type = 'associate' OR bnb_options.member_type = 'internationalassociate', CONCAT('http://www.bnb-network.com/bed-breakfast/', REPLACE(REPLACE(LOWER(bnb_options.county), '&', 'and'), ' ', '-'), '/', REPLACE(REPLACE(LOWER(REPLACE(bnb_options.town, '\'', '')), '&', 'and'), ' ', '-'), '/', REPLACE(REPLACE(LOWER(bnb_options.bnb_name), ' ', '-'), '&', 'and') , '.html'), 
        		CONCAT('http://www.bnb-booking.com/bed-breakfast/', REPLACE(REPLACE(LOWER(REPLACE(bnb_options.town, '\'', '')), '&', 'and'), ' ', '-'), '/', REPLACE(REPLACE(LOWER(bnb_options.bnb_name), ' ', '-'), '&', 'and') , '.html')))) AS url,
        CASE WHEN bnb_options.member_type = 'associate' OR bnb_options.member_type = 'internationalassociate' OR bnb_options.member_type = 'nad' THEN CONCAT('http://www.bnb-booking.com/bed-breakfast/', REPLACE(REPLACE(LOWER(REPLACE(bnb_options.town, '\'', '')), '&', 'and'), ' ', '-'), '/', REPLACE(REPLACE(LOWER(bnb_options.bnb_name), ' ', '-'), '&', 'and') , '.html')
        		WHEN bnb_options.member_type = 'non' AND bnb_options.url != '' THEN concat('outside.html?url=', 'http://www.', replace(bnb_options.url, 'www.', ''))
	        	WHEN bnb_options.member_type = 'non' AND bnb_options.url = '' THEN @url
        	ELSE @url
        	END AS link_url,
        CONCAT('http://www.bnb-advisor.com/reviews/', REPLACE(REPLACE(LOWER(REPLACE(bnb_options.town, '\'', '')), '&', 'and'), ' ', '-'), '/', REPLACE(REPLACE(LOWER(bnb_options.bnb_name), ' ', '-'), '&', 'and') , '.html') AS review_url,
        CASE WHEN bnb_options.member_type like '%associate' then 'www.bnb-network.com'
        	WHEN bnb_options.member_type = 'nad' then 'www.bnb-booking.com'
        	WHEN bnb_options.member_type = 'non' AND bnb_options.url = '' THEN ''
        	WHEN bnb_options.member_type = 'non' THEN CONCAT('www.', REPLACE(REPLACE(bnb_options.url, 'www.', ''), 'http://', ''))
        	ELSE REPLACE(@url, 'http://', '')
        	END AS displayurl,
        CASE WHEN '' != 0 AND '' != 0 THEN CONCAT('?arrival=', date_format(date(''), '%Y-%m-%d'), '&departure=', date_format(date(''), '%Y-%m-%d'))
        	ELSE ''
        	END AS datequery,
    		CASE WHEN bnb_options.member_type LIKE '%associate' THEN CONCAT('http://www.ireland-bnb.net/pictures/', bnb_options.picture)
					WHEN bnb_options.member_type = 'nad' THEN CONCAT('http://www.bnb-booking.com/fotos/', bnb_options.picture)
    			ELSE CONCAT(@url, '/jpgs/', REPLACE(bnb_options.picture, '.jpg', '1.jpg'))
    			END AS picture,
    		CASE WHEN tel != '' THEN CONCAT('Tel: +', country_codes.code, ' (0)', bnb_options.tel) ELSE '' END AS tel,
        CASE WHEN bnb_options.email != '' THEN bnb_options.email
          ELSE ' '
          END AS email,
        CASE WHEN member_type != 'associate' AND member_type != 'nad' THEN concat(@url, '/offers.html') 
        	ELSE @url
        	END AS offerurl,
        CASE WHEN bnb_options.member_type = 'associate' THEN concat('http://www.bnb-network.com/contact.html?id=', bnb_options.bnb_id)
        	WHEN bnb_options.member_type = 'standard' OR bnb_options.member_type = 'international' THEN CONCAT('http://www.', bnb_options.url, '/email.html')
        	WHEN bnb_options.member_type = 'premium' THEN CONCAT('http://www.', bnb_options.url, '/email.html')
        	ELSE ''
        	END AS emailurl, 
        CASE WHEN bnb_options.member_type = 'non' THEN 0
        	WHEN bnb_options.member_type ='nad' THEN 1
          ELSE 2
          END AS sortorder,
        CASE WHEN rates.minprice IS NOT NULL AND rates.minprice > 0 THEN rates.minprice
        	WHEN '' = 'price-d' THEN 0
        	WHEN '' = 'price-a' THEN 9999
        	ELSE 0
        	END as sortprice,
        CASE WHEN rates.minprice IS NOT NULL AND rates.minprice > 0 THEN rates.minprice
        	ELSE '<small>Check Website</small>'
        	END AS price,
	  		CONCAT(rates.caption, ' per person') AS pricecaption,
	  		rates.pax,
		  	CASE WHEN bnb_options.rates_currency != '' THEN bnb_options.rates_currency
		    	WHEN country_codes.currency_symbol IS NOT NULL THEN country_codes.currency_symbol
		    	ELSE '&euro;'
		    	END AS currency,
		    CASE WHEN country_codes.currency_abbreviation IS NOT NULL AND country_codes.currency_abbreviation  != 'eur' THEN LOWER(country_codes.currency_abbreviation)
		    	ELSE 'eu'
		    	END AS cur,
		    0 AS offers,
        case when 'bnb-directory' = 'special-offers' then 'specialoffer'
        	WHEN 'bnb-directory' = 'last-minute-deals' THEN 'lastminute'
        	else ''
        	end as offer_type,
      	bnb_options.stars,
      	reviews.starrating,
      	reviews.totalreviews,
        CASE WHEN reviews.starrating >= 3 THEN reviews.starrating
          ELSE bnb_options.stars
          END AS displaystars,
        CASE WHEN reviews.starrating >= 3 THEN 'reviews'
          ELSE 'gold'
          END AS displaystarstype
      FROM bnb_options
		  	LEFT OUTER JOIN country_codes ON country_codes.country = bnb_options.country
		  	LEFT OUTER JOIN (SELECT t2.bnb_ref, min( CASE WHEN t2.pax = 'per person' THEN t2.price * 2 ELSE t2.price END ) AS minprice, t2.pax, t2.caption
        				FROM bnbrates AS t2 
        				LEFT OUTER JOIN rooms AS t3 ON t3.id = t2.roomtype
        				WHERE t2.bnb_ref = t2.bnb_ref 
        				AND t2.active = 'true'
        				AND t2.ratetype != 'specialoffer'
        				AND CASE WHEN '' != 0 AND '' != 0 THEN date('') BETWEEN startdate AND enddate OR date('') BETWEEN startdate AND enddate
        					WHEN '' != 0 THEN date('') BETWEEN startdate AND enddate
        					WHEN '' != 0 THEN date('') BETWEEN startdate AND enddate
        					ELSE t2.enddate > CURRENT_DATE
        					END
        				AND t3.sleeps = 2
        				GROUP BY t2.bnb_ref
	        		) AS rates on rates.bnb_ref = bnb_options.bnb_id
	      LEFT OUTER JOIN (SELECT bnb_ref, ROUND(SUM(rating) / COUNT(*)) AS starrating, COUNT(*) AS totalreviews FROM reviews
	        WHERE validity != 'unverified'
	        GROUP BY bnb_ref) AS reviews ON reviews.bnb_ref = bnb_options.bnb_id
      WHERE CASE WHEN '' != '' THEN (bnb_options.continent = '' OR bnb_options.additional_search LIKE '%')
        ELSE bnb_options.continent != 'Best'
        END
				AND CASE WHEN 'Ireland' != '' THEN (bnb_options.country LIKE '%Ireland' OR bnb_options.additional_search LIKE '%Ireland%')
          ELSE bnb_options.country != ''        
          END
        AND CASE WHEN 'Kerry' != '' THEN (replace(bnb_options.additional_search, '-', ' ') LIKE '% Kerry %' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE '% Kerry' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE 'Kerry %' 
        		OR replace(bnb_options.additional_search, '-', ' ') = 'Kerry' 
        		OR replace(bnb_options.county, '-', ' ') LIKE '%Kerry%')
          ELSE bnb_options.county != 'Best'
          END
        AND CASE WHEN 'Kerry' = '' AND 'Killarney' != '' THEN (REPLACE(bnb_options.town, '\'', '') LIKE 'Killarney%' OR bnb_options.additional_search LIKE '%Killarney%' or address1 like '%Killarney%' or address2 like '%Killarney%' or address3 like '%Killarney%')
					WHEN 'Killarney' != '' THEN (REPLACE(bnb_options.town, '\'', '') like 'Killarney%' OR bnb_options.additional_search LIKE '%Killarney%')
          ELSE bnb_options.town != 'Best'
          END
        AND bnb_options.active = 'true'
        and case when '0' = 0 then bnb_options.type not like 'Self Catering%' 
        		        AND bnb_options.selfcatering = 'false'
        		        AND bnb_options.member_type NOT LIKE 'selfcatering%'
        		        AND bnb_options.type NOT LIKE 'Selfcatering%'
                	else 1
                	end
        AND CASE WHEN 'bnb-directory' = 'premium-bnb' THEN bnb_options.member_type LIKE 'premium%'
          WHEN ('bnb-directory' = 'bed-breakfast' or 'bnb-directory' = '' or '' != '') AND '1' THEN bnb_options.member_type != ''
          WHEN ('bnb-directory' = 'bed-breakfast' or 'bnb-directory' = '' or '' != '') AND 'Ireland' = 'Ireland' THEN bnb_options.member_type != 'non' AND bnb_options.member_type != 'nad'
          WHEN 'bnb-directory' = 'bed-breakfast' or 'bnb-directory' = '' or '' != '' THEN bnb_options.member_type != 'non'
          WHEN 'bnb-directory' = 'bnb-directory' THEN bnb_options.member_type != ''
          WHEN 'bnb-directory' = 'hostels' THEN bnb_options.type = 'hostel' AND bnb_options.member_type != 'non'
          WHEN 'bnb-directory' = '' THEN bnb_options.type LIKE '%guesthouse%' AND bnb_options.member_type != 'non'
          WHEN 'bnb-directory' = 'special-offers' THEN bnb_options.special_offers = 'true' AND EXISTS (
					          SELECT caption AS heading
					            FROM bnbrates
					            WHERE current_date < enddate
					            AND active = 'true'
					            AND ratetype = 'specialoffer'
					            AND bnbrates.bnb_ref = bnb_options.bnb_id
					        )
					WHEN 'bnb-directory' = 'last-minute-deals' THEN bnb_options.last_minute = 'true' AND EXISTS (
					          SELECT *
					            FROM bnbrates
					            WHERE current_date < enddate
					            AND current_date > date_sub(enddate, interval 15 day)
					            AND active = 'true'
					            AND ratetype = 'lastminute'
					            AND bnbrates.bnb_ref = bnb_options.bnb_id
					        )
          WHEN 'bnb-directory' != '' AND 'bnb-directory' != 'bnb-directory' THEN bnb_options.member_type = 'bnb-directory'
          ELSE bnb_options.member_type != ''
          END
        AND CASE WHEN '' != '' THEN 
        				(SELECT `enabled` 
        						FROM searchoptions 
        							LEFT OUTER JOIN attractions ON attractions.id = searchoptions.attraction
        						WHERE CASE WHEN attractions.id IS NOT NULL THEN (attractions.type = '' or attractions.name = '')
	        							ELSE (searchoptions.description = '' OR searchoptions.description = '')
	        							END
	      							AND searchoptions.bnb_ref = bnb_options.bnb_id
	      						LIMIT 1) = TRUE
        	ELSE 1 = 1
        	END
        AND CASE WHEN 'all' != 'all' THEN bnb_options.type = 'all'
          ELSE bnb_options.type != 1
          END
        AND CASE WHEN '' = 'price-a' OR '' = 'price-d' THEN bnb_options.member_type != 'non'
        	ELSE 1 = 1
        	END
        AND CASE WHEN '' != 0 AND '' != 0 THEN rates.minprice IS NOT NULL AND rates.minprice > 0 AND bnb_options.member_type != 'non'
        	ELSE 1 = 1
        	END
        AND CASE WHEN '' = 1 THEN (bnb_options.member_type != 'non' OR bnb_options.url != '')
        	ELSE 1 = 1
        	END
GROUP BY bnb_options.bnb_id
 ORDER BY sortorder DESC, RAND(1235930291) --><!-- 1 --><!DOCTYPE html >
<html>
<head>
<title>Killarney B&amp;B Directory</title>
<meta name="description" content="Killarney bed and breakfast accommodation Ireland" />
<meta name="keywords" content="Killarney,B&amp;B,hotels,lodging,inns,directory" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="author" content="Michael Sharpe - Insight Web Marketing Ltd" />
<link rel="stylesheet" href="style/bnbn.css" type="text/css" /> 
<link rel="stylesheet" href="style/list.css" type="text/css" />
<link rel="stylesheet" href="style/directorylist.css" type="text/css" />

</style>
 <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<script src="js.include/jquery-1.5.min.js" type="text/javascript"></script>
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-393059-38']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script></head>
<body>
<div class="wrapper">	<div id="pagetag" >Killarney B&amp;Bs</div>
<header><a href="http://membership.bnb-network.ie/" target="_blank" title="        Join the B&amp;B Network Ireland"><img src="graphics/bnb-logo1.png" alt="bnb-logo" width="234" height="95"  /></a>
<div class="bullets">
<ul >
<li><span>B&amp;B Killarney Directory</span></li>
<li><span> Lodging B&amp;Bs in Killarney</span></li>
<li><span>Inns Hotels in Killarney</span></li>
<li><span>Rooms in Killarney</span></li>
<li><span>All Accommodation Killarney</span></li>
</ul>
</div>
<h1>Killarney B&amp;B Directory</h1>

<div class="menu">
<ul id="menu">
<li><a href="killarney-special-offers-kerry.html" target="_blank">Special Offers</a></li>
<li><a href="killarney-last-minute-deals-kerry.html" target="_blank">Last Minute Deals</a></li>
<li><a href="http://www.irishholidayrentals.com">Irish Holiday Homes</a></li>
<li><a href="http://www.reddotdeals.ie/car-rental.html" target="_blank">Discount Car Hire</a></li>
<li><a href="http://membership.bnb-network.ie" target="_blank">B&amp;B Marketing</a></li>
<li><a href="http://members.bnb-network.com" target="_blank">Members Logon</a></li>
</ul>
</div></header>
<div class="main">
	<div class="copyright">Copyright 2012<br />Insight Web Marketing Ltd</div>

	<!-- SIDE MENU 1 -->
	<div class="smenu"><p style="text-align:center;margin-bottom:10px;font-size:11px">Current Website Visitors<span  style="color:red;font-size:11px"> 52</span></p>
<ul style="margin-bottom:20px;" >
<li><a href="index.html">Ireland B&amp;B Home</a></li>
<li><a href="ireland-bnb-towns.html">Search by Town</a></li>
<li><a href="ireland-bnb-county.html">Search by County</a></li>
<li><a href="premium-bnbs.html">Premium B&amp;Bs</a></li>
<li><a href="ireland-ports.html">Airports &amp; Ferries</a></li>
<li><a href="ireland-tourist-info.html">Tourist Information</a></li>
<li><a href="ireland-tourist-offices.html">Tourist Offices</a></li>
<li><a href="bnbn-ireland.html">Irish B&amp;B Websites</a></li>
<li><a href="http://www.bnb-network.co.uk" target="_blank"><img src='graphics/gb.png' alt='UK B&amp;B' style='line-height14px' /> UK B&amp;B</a></li>
<li><a href="http://membership.bnb-network.ie" target="_blank">B&amp;B Marketing</a></li>
<li><a href="contact-bnbn.html" target="_blank">Contact Us</a></li>
</ul>
<div class="adverts">
<b class="adverts">ADVERTISING</b><br /><br />

<iframe name="butads" src="adverts/advert2.html" width="120" height="600" frameborder="0" marginwidth="0" marginheight="0" scrolling="no"></iframe>
</div>
</div>	
	<div class="content">
		<!-- LEADERBOARD -->
		<div class="leaderboard">
<iframe id='a63e0766' name='a63e0766' src='http://www.insight-intermark.com/oladXi/www/delivery/afr.php?zoneid=49&amp;cb=INSERT_RANDOM_NUMBER_HERE&amp;ct0=INSERT_CLICKURL_HERE' frameborder='0' scrolling='no' width='728' height='90'><a href='http://www.insight-intermark.com/oladXi/www/delivery/ck.php?n=a574e0f4&amp;cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://www.insight-intermark.com/oladXi/www/delivery/avw.php?zoneid=49&amp;cb=INSERT_RANDOM_NUMBER_HERE&amp;n=a574e0f4&amp;ct0=INSERT_CLICKURL_HERE' border='0' alt='' /></a></iframe></div>		
		<div class="hr" style="width: 800px;margin: 15px auto 0;" ></div>
	
		<!-- LISTING -->
				<h2  style="margin-top:15px;" >
			Killarney Bed &amp; Breakfast
			
			<span>
				<select id='region'><option value=''>Select a Region / County...</option>
					<option value='carlow' >Carlow</option><option value='cavan' >Cavan</option><option value='clare' >Clare</option><option value='cork' >Cork</option><option value='donegal' >Donegal</option><option value='dublin' >Dublin</option><option value='galway' >Galway</option><option value='kerry' selected='selected'>Kerry</option><option value='kildare' >Kildare</option><option value='kilkenny' >Kilkenny</option><option value='laois' >Laois</option><option value='leitrim' >Leitrim</option><option value='limerick' >Limerick</option><option value='longford' >Longford</option><option value='louth' >Louth</option><option value='mayo' >Mayo</option><option value='meath' >Meath</option><option value='monaghan' >Monaghan</option><option value='offaly' >Offaly</option><option value='roscommon' >Roscommon</option><option value='sligo' >Sligo</option><option value='tipperary' >Tipperary</option><option value='waterford' >Waterford</option><option value='westmeath' >Westmeath</option><option value='wexford' >Wexford</option><option value='wicklow' >Wicklow</option><option value='antrim' >Antrim</option><option value='armagh' >Armagh</option><option value='derry' >Derry</option><option value='down' >Down</option><option value='fermanagh' >Fermanagh</option><option value='tyrone' >Tyrone</option>				</select>
				<span id="townListWrapper"><!-- TOWN QUERY: select lower(replace(replace(town, ' ', '-'), '&', '-and-')) as urltown, town, county, country from bnb, options
          where active = 'true'
            and bnb_id = bnb_ref
            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 county != 'Best'
              end
            and case when 'Ireland' != '' then (country like '%Ireland' OR additional_search LIKE '%Ireland %' OR additional_search LIKE '% Ireland%')
            	when '' != '' then (country like '%' OR additional_search LIKE '% %' OR additional_search LIKE '% %')
              else country != ''
              end
						and type not like 'self%'
            and type not like 'Selfcatering%'
            and type not like 'Self Catering%'
            and case when '' = 'premium-bnb' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
              when '' = 'bed-breakfast' then options.member_type != 'non' and options.member_type != 'nad'
              when '' = 'bnb-directory' then options.member_type != ''
              when '' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
              when '' = 'hostels-accommodation' then bnb.type = 'hostel'
              when '' = 'xx' then bnb.type like '%hotel%' and options.member_type != 'non'
              when '' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
              WHEN '' = 'special-offers' THEN options.special_offers = 'true' AND EXISTS (
					          SELECT caption AS heading
					            FROM bnbrates
					            WHERE current_date < enddate
					            AND active = 'true'
					            AND ratetype = 'specialoffer'
					            AND bnbrates.bnb_ref = bnb.bnb_id
					        )
							WHEN '' = 'last-minute-deals' THEN options.special_offers = 'true' AND EXISTS (
							          SELECT caption AS heading
							            FROM bnbrates
							            WHERE current_date < enddate
							            AND date_add(current_date, interval 15 day) > enddate
							            AND active = 'true'
							            AND ratetype = 'lastminute'
							            AND bnbrates.bnb_ref = bnb.bnb_id
							        )
              when '' != '' then options.member_type = ''
              else options.member_type != ''
              end
          group by town, county
          order by town, county --><select id='town'><option value=''>Select a City / Town...</option>
	<option value='all'>- All in Kerry -</option>
	<option value='annascaul' >Annascaul</option><option value='ballinskelligs' >Ballinskelligs</option><option value='ballybunion' >Ballybunion</option><option value='ballydavid' >Ballydavid</option><option value='ballyferriter' >Ballyferriter</option><option value='ballyheigue' >Ballyheigue</option><option value='ballylongford' >Ballylongford</option><option value='beaufort' >Beaufort</option><option value='boolteens' >Boolteens</option><option value='caherdaniel' >Caherdaniel</option><option value='cahersiveen' >Cahersiveen</option><option value='camp' >Camp</option><option value='castlecove' >Castlecove</option><option value='castlegregory' >Castlegregory</option><option value='castleisland' >Castleisland</option><option value='castlemaine' >Castlemaine</option><option value='cloghane' >Cloghane</option><option value='currow' >Currow</option><option value='dingle' >Dingle</option><option value='dingle-peninsula' >Dingle Peninsula</option><option value='dingle-town' >Dingle Town</option><option value='farranfore' >Farranfore</option><option value='glenbeigh' >Glenbeigh</option><option value='glencar' >Glencar</option><option value='inch' >Inch</option><option value='kells' >Kells</option><option value='kenmare' >Kenmare</option><option value='kilgarvan' >Kilgarvan</option><option value='killarney' selected='selected'>Killarney</option><option value='killorglin' >Killorglin</option><option value='lispole' >Lispole</option><option value='lisselton' >Lisselton</option><option value='listowel' >Listowel</option><option value='milltown' >Milltown</option><option value='portmagee' >Portmagee</option><option value='sneem' >Sneem</option><option value='tarbert' >Tarbert</option><option value='tralee' >Tralee</option><option value='valentia-island' >Valentia Island</option><option value='ventry' >Ventry</option><option value='waterville' >Waterville</option></select></span>
			</span>
		</h2>
		
		<div class="hr" style="width: 800px;margin:15px auto 0;" ></div>
		
		<div id="propertyList">
			<table class='caption' id='caption'><tr><td class='caption'></td><td style='width:86px' class='captionbtn previouspage'></td><td style='width:86px' class='captionbtn nextpage'><form method='post' action='/killarney-bnb-directory-kerry.html'><input type='hidden' name='page' value='2' /><input type='hidden' name='count' value='15' /><input type='hidden' name='town' value='Killarney' /><input type='hidden' name='county' value='Kerry' /><input type='hidden' name='country' value='Ireland' /><input type='hidden' name='arrival' value='' /><input type='hidden' name='departure' value='' /><input type='hidden' name='seed' value='1235930291' /><span class='button' onclick='this.parentNode.submit();'><input type='image' src='http://www.ireland-bnb.com/graphics/next-page.gif' class='submitimage ' width='86' height='15' style='float:right' title='Click to view the next page' alt='Next Page' /></span></form></td></tr></table><table><tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.parkfieldkillarney.com' target='_blank'>
      <img src='http://www.parkfieldkillarney.com/jpgs/parkfield1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.parkfieldkillarney.com' target='_blank'>
	  	<b>Parkfield House B&amp;B</b>
	  </a><br />
    <a href='http://www.parkfieldkillarney.com' target='_blank'>
	  	Park Road<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.parkfieldkillarney.com'>
  		This charming and purpose built 3 star B&amp;B, with superb standards, is just a short walk from Killarney town centre. Family run, it offers real value for money for a town centre accommodation. Family rooms available to cater for 3 - 4 people.
  	</a>
  </td>
  <td>
    <a href="http://www.parkfieldkillarney.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.salmonleapfarm.com' target='_blank'>
      <img src='http://www.salmonleapfarm.com/jpgs/salmon1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.salmonleapfarm.com' target='_blank'>
	  	<b>Salmon Leap Farm B&amp;B</b>
	  </a><br />
    <a href='http://www.salmonleapfarm.com' target='_blank'>
	  	Glenflesk<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.salmonleapfarm.com'>
  		This farmhouse is over 200 years old and is situated in the picturesque Glenflesk valley. We are located nine miles east of Killarney town on the N22 road. We have six comfortable bedrooms with ensuite bathrooms. There is also a guest sitting room. T
  	</a>
  </td>
  <td>
    <a href="http://www.salmonleapfarm.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.stayatwoodlands.com' target='_blank'>
      <img src='http://www.stayatwoodlands.com/jpgs/woodlands1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.stayatwoodlands.com' target='_blank'>
	  	<b>Woodlands B&amp;B</b>
	  </a><br />
    <a href='http://www.stayatwoodlands.com' target='_blank'>
	  	Ballydowney<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.stayatwoodlands.com'>
  		Woodlands is a friendly family run B&amp;B with private car park opposite Killarney National Park with walkway to town centre through the park. Nearest B&amp;B to Killarney Riding Stables, Killarney Golf &amp; Fishing Club and the Castleross Hotel. Situated on t
  	</a>
  </td>
  <td>
    <a href="http://www.stayatwoodlands.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.danlinehansbnb.com' target='_blank'>
      <img src='http://www.danlinehansbnb.com/jpgs/linehan1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.danlinehansbnb.com' target='_blank'>
	  	<b>Dan Linehans B&amp;B</b>
	  </a><br />
    <a href='http://www.danlinehansbnb.com' target='_blank'>
	  	College Street<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.danlinehansbnb.com'>
  		Dan Linehan opened his bar doors on College Street Killarney in 1974.  He stayed at the helm for twenty two years establishing a public house with a reputation for the finest pint of Guinness, wholesome hearty food and a laid back jovial atmosphere. 
  	</a>
  </td>
  <td>
    <a href="http://www.danlinehansbnb.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.woodlawn-house.com' target='_blank'>
      <img src='http://www.woodlawn-house.com/jpgs/woodlawn1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.woodlawn-house.com' target='_blank'>
	  	<b>Woodlawn House Guesthouse</b>
	  </a><br />
    <a href='http://www.woodlawn-house.com' target='_blank'>
	  	Woodlawn Rd.<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.woodlawn-house.com'>
  		Woodlawn House, Killarney is a Unique 14 bedroom Family Run Luxury Guest Accommodation, nestled in a peaceful, leafy, residential area just off the Muckross Road, with panoramic views of Kerrys Magnificent Mountain Range.  Woodlawn House is less than
  	</a>
  </td>
  <td>
    <a href="http://www.woodlawn-house.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.flesklodge.com' target='_blank'>
      <img src='http://www.flesklodge.com/jpgs/flesklodge1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.flesklodge.com' target='_blank'>
	  	<b>Flesk Lodge B&amp;B</b>
	  </a><br />
    <a href='http://www.flesklodge.com' target='_blank'>
	  	Muckross Road<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.flesklodge.com'>
  		Awarded Best Town &amp; Country Home by Killarney Looking Good Committee, the Mannix Family offer a special warm welcome. Flesk Lodge is only 10 minutes walk from Killarney town centre. Close by there are championship golf courses, pitch &amp; putt, trout an
  	</a>
  </td>
  <td>
    <a href="http://www.flesklodge.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.copperkettlekillarney.com' target='_blank'>
      <img src='http://www.copperkettlekillarney.com/jpgs/copperkettle1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.copperkettlekillarney.com' target='_blank'>
	  	<b>Copper Kettle B&amp;B</b>
	  </a><br />
    <a href='http://www.copperkettlekillarney.com' target='_blank'>
	  	Lewis Road<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.copperkettlekillarney.com'>
  		Just 40 metres from the vibrant Town Centre of Killarney, the Copper Kettle is one of Killarney's most central and luxurious town guest houses. It is an ideal base from which to visit Killarney National Park, the Ring of Kerry and the Dingle Peninsu
  	</a>
  </td>
  <td>
    <a href="http://www.copperkettlekillarney.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.abbey-lodge.com' target='_blank'>
      <img src='http://www.abbey-lodge.com/jpgs/abbeylodge1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.abbey-lodge.com' target='_blank'>
	  	<b>Abbey Lodge B&amp;B</b>
	  </a><br />
    <a href='http://www.abbey-lodge.com' target='_blank'>
	  	Muckross Road<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.abbey-lodge.com'>
  		A genuine Irish welcome awaits you at Abbey Lodge. Our guesthouse is family run 4 star boasts 15 luxurious bedrooms with private bathroom, TV, direct dial telephone, power showers,  trouser press. The house is tastefully decorated throughout and feat
  	</a>
  </td>
  <td>
    <a href="http://www.abbey-lodge.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.killarneyvilla.com' target='_blank'>
      <img src='http://www.killarneyvilla.com/jpgs/killvill1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.killarneyvilla.com' target='_blank'>
	  	<b>Killarney Villa B&amp;B</b>
	  </a><br />
    <a href='http://www.killarneyvilla.com' target='_blank'>
	  	Lissivigeen (N72)<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.killarneyvilla.com'>
  		The O'Sullivans welcome you  to our website.  AA**** rated and recipient of RAC Sparkling Diamond &amp; Warm Welcome Awards.

Mornings at Killarney Villa are greeted with a delightful breakfast to prepare you for your  day exploring one of the mos
  	</a>
  </td>
  <td>
    <a href="http://www.killarneyvilla.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.crystalspringsbnb.com' target='_blank'>
      <img src='http://www.crystalspringsbnb.com/jpgs/crystalsprings1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.crystalspringsbnb.com' target='_blank'>
	  	<b>Crystal Springs B&amp;B</b>
	  </a><br />
    <a href='http://www.crystalspringsbnb.com' target='_blank'>
	  	Ballycasheen Cross<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.crystalspringsbnb.com'>
  		Crystal Springs B&amp;B AA 4* award is run by the Brosnan Family who ensure the comfort and enjoyment of their guests by providing top quality spacious rooms.

We offer excellent value (2 and 3 night Specials) in our luxurious en-suite rooms, some ov
  	</a>
  </td>
  <td>
    <a href="http://www.crystalspringsbnb.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.larkfieldhouse.com' target='_blank'>
      <img src='http://www.larkfieldhouse.com/jpgs/larkfield1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.larkfieldhouse.com' target='_blank'>
	  	<b>Larkfield House B&amp;B</b>
	  </a><br />
    <a href='http://www.larkfieldhouse.com' target='_blank'>
	  	Ballycasheen<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.larkfieldhouse.com'>
  		Larkfield House B&amp;B has been run by The Ivory Family since 1991. Over the years we have gained valuable experience in accommodating guests, satisfying their needs and providing an excellent service.  Our top quality service has been recognised by the
  	</a>
  </td>
  <td>
    <a href="http://www.larkfieldhouse.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.waysidebnb.com' target='_blank'>
      <img src='http://www.waysidebnb.com/jpgs/waysidedunloe1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.waysidebnb.com' target='_blank'>
	  	<b>Wayside B&amp;B</b>
	  </a><br />
    <a href='http://www.waysidebnb.com' target='_blank'>
	  	Gap of Dunloe<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.waysidebnb.com'>
  		Wayside is located in a peaceful lake and mountain district known as the Gap of Dunloe. Rest well and wake up to a delicious breakfast cooked to order with local produce. Walk, cycle, ponytrek or travel in horse drawn carriage through this great glac
  	</a>
  </td>
  <td>
    <a href="http://www.waysidebnb.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.bnb-network.com/bed-breakfast/kerry/killarney/friars-glen.html' target='_blank'>
      <img src='http://www.ireland-bnb.net/pictures/friars-glen.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.bnb-network.com/bed-breakfast/kerry/killarney/friars-glen.html' target='_blank'>
	  	<b>Friars Glen B&amp;B</b>
	  </a><br />
    <a href='http://www.bnb-network.com/bed-breakfast/kerry/killarney/friars-glen.html' target='_blank'>
	  	Mangerton Road<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.bnb-network.com/bed-breakfast/kerry/killarney/friars-glen.html'>
  		Friars Glen is a four-star country house, offering our guests top quality bed and breakfast accommodation. We have ten en-suite, spacious, comfortable bedrooms that are quiet and restful. We offer an extensive, delicious breakfast that includes a col
  	</a>
  </td>
  <td>
    <a href="http://www.bnb-network.com/contact.html?id=1858" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.muckross-stables.com' target='_blank'>
      <img src='http://www.muckross-stables.com/jpgs/muckrossbnb1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.muckross-stables.com' target='_blank'>
	  	<b>Muckross Stables B&amp;B</b>
	  </a><br />
    <a href='http://www.muckross-stables.com' target='_blank'>
	  	Mangerton Road<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.muckross-stables.com'>
  		Farmhouse set in a peaceful valley. Large warm comfortable rooms with panoramic views of the mountains, oak forest with red deer. Our area is considered a walkers paradise and of course perfect for riding. Short stroll to Muckross House and the Killa
  	</a>
  </td>
  <td>
    <a href="http://www.muckross-stables.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr>
  <td width='100' align='center'>
    <div class='overlaypos'><a href='http://www.hiltonheightsbnb.com' target='_blank'>
      <img src='http://www.hiltonheightsbnb.com/jpgs/hiltonheights1.jpg' alt='Click for further details' width='100' height='67' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='100' height='67' class='overlay' />
    </a></div>
  </td>
  <td style="background-color:#E6F3F7;width:200px" >
    <a href='http://www.hiltonheightsbnb.com' target='_blank'>
	  	<b>Hilton Heights B&amp;B</b>
	  </a><br />
    <a href='http://www.hiltonheightsbnb.com' target='_blank'>
	  	Glebe<br />
	  	Killarney<br />
	  	Kerry<br />
	  </a>
  </td>
  <td>
  	<a href='http://www.hiltonheightsbnb.com'>
  		This picturesque bungalow is situated in a peaceful and restful area off the Tralee to Killarney road. Hilton Heights offers panoramic views of Killarney's beautiful mountains and is surrounded by scenic countryside.

Breakfast includes a ch
  	</a>
  </td>
  <td>
    <a href="http://www.hiltonheightsbnb.com/email.html" />
      <img src="graphics/email-bnb.png" width="50" height="60" alt="" style="float:right" />
    </a>
  </td>
</tr>

<tr><th colspan='4' style='font-weight:normal'><a href='http://membership.bnb-network.ie' target='_blank'>Do you own a B&amp;B, guesthouse or hotel in Killarney? Click here to find out how you can become a member of the B&amp;B Network.</a></th></tr></table>			<br style="clear:both" />
		</div>
		
		<div id="linksfooter"><!-- large links footer -->
			<h6>Bed &amp; Breakfast Accommodation in Killarney, Kerry</h6><br>
			<ul>
				<!-- TOWN QUERY: select lower(replace(replace(town, ' ', '-'), '&', '-and-')) as urltown, town, county, country from bnb, options
          where active = 'true'
            and bnb_id = bnb_ref
            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 county != 'Best'
              end
            and case when 'Ireland' != '' then (country like '%Ireland' OR additional_search LIKE '%Ireland %' OR additional_search LIKE '% Ireland%')
            	when '' != '' then (country like '%' OR additional_search LIKE '% %' OR additional_search LIKE '% %')
              else country != ''
              end
						and type not like 'self%'
            and type not like 'Selfcatering%'
            and type not like 'Self Catering%'
            and case when '' = 'premium-bnb' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
              when '' = 'bed-breakfast' then options.member_type != 'non' and options.member_type != 'nad'
              when '' = 'bnb-directory' then options.member_type != ''
              when '' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
              when '' = 'hostels-accommodation' then bnb.type = 'hostel'
              when '' = 'xx' then bnb.type like '%hotel%' and options.member_type != 'non'
              when '' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
              WHEN '' = 'special-offers' THEN options.special_offers = 'true' AND EXISTS (
					          SELECT caption AS heading
					            FROM bnbrates
					            WHERE current_date < enddate
					            AND active = 'true'
					            AND ratetype = 'specialoffer'
					            AND bnbrates.bnb_ref = bnb.bnb_id
					        )
							WHEN '' = 'last-minute-deals' THEN options.special_offers = 'true' AND EXISTS (
							          SELECT caption AS heading
							            FROM bnbrates
							            WHERE current_date < enddate
							            AND date_add(current_date, interval 15 day) > enddate
							            AND active = 'true'
							            AND ratetype = 'lastminute'
							            AND bnbrates.bnb_ref = bnb.bnb_id
							        )
              when '' != '' then options.member_type = ''
              else options.member_type != ''
              end
          group by town, county
          order by town, county --><li><a href='annascaul-bnb-directory-kerry.html'>Annascaul B&amp;B</a></li><li><a href='ballinskelligs-bnb-directory-kerry.html'>Ballinskelligs B&amp;B</a></li><li><a href='ballybunion-bnb-directory-kerry.html'>Ballybunion B&amp;B</a></li><li><a href='ballydavid-bnb-directory-kerry.html'>Ballydavid B&amp;B</a></li><li><a href='ballyferriter-bnb-directory-kerry.html'>Ballyferriter B&amp;B</a></li><li><a href='ballyheigue-bnb-directory-kerry.html'>Ballyheigue B&amp;B</a></li><li><a href='ballylongford-bnb-directory-kerry.html'>Ballylongford B&amp;B</a></li><li><a href='beaufort-bnb-directory-kerry.html'>Beaufort B&amp;B</a></li><li><a href='boolteens-bnb-directory-kerry.html'>Boolteens B&amp;B</a></li></ul><ul><li><a href='caherdaniel-bnb-directory-kerry.html'>Caherdaniel B&amp;B</a></li><li><a href='cahersiveen-bnb-directory-kerry.html'>Cahersiveen B&amp;B</a></li><li><a href='camp-bnb-directory-kerry.html'>Camp B&amp;B</a></li><li><a href='castlecove-bnb-directory-kerry.html'>Castlecove B&amp;B</a></li><li><a href='castlegregory-bnb-directory-kerry.html'>Castlegregory B&amp;B</a></li><li><a href='castleisland-bnb-directory-kerry.html'>Castleisland B&amp;B</a></li><li><a href='castlemaine-bnb-directory-kerry.html'>Castlemaine B&amp;B</a></li><li><a href='cloghane-bnb-directory-kerry.html'>Cloghane B&amp;B</a></li><li><a href='currow-bnb-directory-kerry.html'>Currow B&amp;B</a></li></ul><ul><li><a href='dingle-bnb-directory-kerry.html'>Dingle B&amp;B</a></li><li><a href='dingle-peninsula-bnb-directory-kerry.html'>Dingle Peninsula B&amp;B</a></li><li><a href='dingle-town-bnb-directory-kerry.html'>Dingle Town B&amp;B</a></li><li><a href='farranfore-bnb-directory-kerry.html'>Farranfore B&amp;B</a></li><li><a href='glenbeigh-bnb-directory-kerry.html'>Glenbeigh B&amp;B</a></li><li><a href='glencar-bnb-directory-kerry.html'>Glencar B&amp;B</a></li><li><a href='inch-bnb-directory-kerry.html'>Inch B&amp;B</a></li><li><a href='kells-bnb-directory-kerry.html'>Kells B&amp;B</a></li><li><a href='kenmare-bnb-directory-kerry.html'>Kenmare B&amp;B</a></li></ul><ul><li><a href='kilgarvan-bnb-directory-kerry.html'>Kilgarvan B&amp;B</a></li><li><a href='killarney-bnb-directory-kerry.html'>Killarney B&amp;B</a></li><li><a href='killorglin-bnb-directory-kerry.html'>Killorglin B&amp;B</a></li><li><a href='lispole-bnb-directory-kerry.html'>Lispole B&amp;B</a></li><li><a href='lisselton-bnb-directory-kerry.html'>Lisselton B&amp;B</a></li><li><a href='listowel-bnb-directory-kerry.html'>Listowel B&amp;B</a></li><li><a href='milltown-bnb-directory-kerry.html'>Milltown B&amp;B</a></li><li><a href='portmagee-bnb-directory-kerry.html'>Portmagee B&amp;B</a></li><li><a href='sneem-bnb-directory-kerry.html'>Sneem B&amp;B</a></li></ul><ul><li><a href='tarbert-bnb-directory-kerry.html'>Tarbert B&amp;B</a></li><li><a href='tralee-bnb-directory-kerry.html'>Tralee B&amp;B</a></li><li><a href='valentia-island-bnb-directory-kerry.html'>Valentia Island B&amp;B</a></li><li><a href='ventry-bnb-directory-kerry.html'>Ventry B&amp;B</a></li><li><a href='waterville-bnb-directory-kerry.html'>Waterville B&amp;B</a></li>			</ul>
		</div><!-- end large footer -->
	</div>
</div>

<script type="text/javascript">
	var countyUrl = "%region%-bnb-directory.html";
	var townUrl = "%town%-bnb-directory-%region%.html";
	
	var selectedRegion = new String('Kerry').replace(' ', '-').replace('&', '-and-').toLowerCase();
	var selectedTown = '';

	$(document).ready( function() {
		$('select#region').change( function() {
			$('#town').attr('disabled', 'disabled');
			$('#town option').html('Please wait to select a City or Town...');
			var selected = 'Kerry';
			//var selected = '';
			//if(selected == '') {
				$('select#region option:selected').each( function() {
					selectedRegion = $(this).attr("value");
					selected = $(this).text();
				});
			//}
			
			
			/*$.ajax({
				url: 'php.actions/town.list.php',
				context: $('#townListWrapper'),
				data: 'county=' + selected,
				success: function(data) {
					$(this).html(data);
					$(this).focus();
					setupEvents();
				}
			});*/
			
			url = countyUrl;
			url = url.replace('%region%', selectedRegion);
			window.location = url;
		});
		
		if($('#town').attr('disabled') == false) setupEvents();
	});
	
	function setupEvents() {		
		$('select#town').change( function() {
			var url = townUrl;
			
			$('select#town option:selected').each( function() {
				selectedTown = $(this).attr("value");
			});
			
			if(selectedTown == 'all') {
				url = countyUrl;
				url = url.replace('%region%', selectedRegion);
			} else {
				url = townUrl;
				url = url.replace('%region%', selectedRegion).replace('%town%', selectedTown);
			}
			
			url = url.replace('%region%', selectedRegion).replace('%town%', selectedTown);
			window.location = url;
		});
	}
</script>

</body>
</html>