<!-- 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 'premium-bnb' = '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-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 'premium-bnb' = 'special-offers' then 'specialoffer'
        	WHEN 'premium-bnb' = 'last-minute-deals' THEN 'lastminute'
        	else ''
        	end as offer_type,
      	bnb_options.stars,
        (@starrating := (SELECT ROUND(SUM(rating) / COUNT(*)) AS average FROM reviews
          WHERE bnb_ref = bnb_options.bnb_id
            AND validity != 'unverified')) AS starrating,
        CASE WHEN @starrating >= 3 THEN @starrating
          ELSE bnb_options.stars
          END AS displaystars,
        CASE WHEN @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
      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 'Clare' != '' THEN (replace(bnb_options.additional_search, '-', ' ') LIKE '% Clare %' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE '% Clare' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE 'Clare %' 
        		OR replace(bnb_options.additional_search, '-', ' ') = 'Clare' 
        		OR replace(bnb_options.county, '-', ' ') LIKE '%Clare%')
          ELSE bnb_options.county != 'Best'
          END
        AND CASE WHEN 'Clare' = '' AND '' != '' THEN (REPLACE(bnb_options.town, '\'', '') LIKE '%' OR bnb_options.additional_search LIKE '%%' or address1 like '%%' or address2 like '%%' or address3 like '%%')
					WHEN '' != '' THEN (REPLACE(bnb_options.town, '\'', '') like '%' OR bnb_options.additional_search LIKE '%%')
          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 'premium-bnb' = 'premium-bnb' THEN bnb_options.member_type LIKE 'premium%'
          WHEN ('premium-bnb' = 'bed-breakfast' or 'premium-bnb' = '' or '' != '') AND '' THEN bnb_options.member_type != ''
          WHEN ('premium-bnb' = 'bed-breakfast' or 'premium-bnb' = '' or '' != '') AND 'Ireland' = 'Ireland' THEN bnb_options.member_type != 'non' AND bnb_options.member_type != 'nad'
          WHEN 'premium-bnb' = 'bed-breakfast' or 'premium-bnb' = '' or '' != '' THEN bnb_options.member_type != 'non'
          WHEN 'premium-bnb' = 'bnb-directory' THEN bnb_options.member_type != ''
          WHEN 'premium-bnb' = 'hostels' THEN bnb_options.type = 'hostel' AND bnb_options.member_type != 'non'
          WHEN 'premium-bnb' = '' THEN bnb_options.type LIKE '%guesthouse%' AND bnb_options.member_type != 'non'
          WHEN 'premium-bnb' = '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 'premium-bnb' = '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 'premium-bnb' != '' AND 'premium-bnb' != 'bnb-directory' THEN bnb_options.member_type = 'premium-bnb'
          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(449443864) --><!-- 1 --><!DOCTYPE html>
<html>
<head>
<title>Premium B&amp;Bs in Clare</title>
<meta name="description" content="Clare B&amp;B offering superior service, Last Minute Deals and Speacial Offers" />
<meta name="keywords" content="Clare,B&amp;B" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<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" />
 <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" >Premium 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>Premium B&amp;Bs Clare</span></li>
<li><span>Clare Bed and Breakfast</span></li>
<li><span>Last Minute Clare</span></li>
<li><span>Ireland's Best Bed &amp; Breakfast</span></li>
<li><span>Quality B&amp;B Clare</span></li>
<li><span>Select Family Homes Clare</span></li>
</ul>
</div>
<h1>Premium B&amp;Bs Clare</h1>
<div class="menu">
<ul id="menu">
<li><a href="http://www.reddotdeals.ie/special-offers.html" target="_blank">Special Offers Ireland</a></li>
<li><a href="http://www.reddotdeals.ie/last-minute.html" target="_blank">Last Minute Ireland</a></li>
<li><a href="http://www.reddotdeals.ie/car-rental.html" target="_blank">Discount Car Hire</a></li>
<li><a href="http://www.irishholidayrentals.com" target="_blank">Irish Holiday Homes</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="smenu"><p style="text-align:center;margin-bottom:10px;font-size:11px">Current Website Visitors<span  style="color:red;font-size:11px"> 24</span></p>
<ul style="margin-bottom:20px;" >
<li><a href="ireland-bnb-county.html">Irish County B&amp;Bs</a></li>
<li><a href="ireland-bnb-towns.html">B&amp;Bs by Town</a></li>
<li><a href="premium-bnbs.html">Premium B&amp;Bs</a></li>
<li><a href="http://bnb-booking.com" target="_blank">B&Bs Worldwide</a></li>
<li><a href="http://membership.bnb-network.ie/newestmembers.html" target="_blank" title-"new members of the B&amp;B network">Recently Added</a></li>
<li><a href="http://bnb-network.ie/vouchers.html" target="_blank">B&amp;B Vouchers</a></li>
<li><a href="http://bnb-booking.com" target="_blank" title="B&B Booking Service">Worldwide Booking</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="http://www.bnb-network.co.uk" target="_blank"><img src='graphics/gb.png' alt='UK B&amp;B' border='0'  style='line-height14px' /> UK B&amp;B</a></li>
<li><a href="sitemap.html">Site Map</a></li>
<li><a href="contact-bnbn.html" target="_blank">Contact Us</a></li>
</ul>

<div class="" style="width:120px;margin:0px auto;"><!--/* OpenX Javascript Tag v2.8.7 */-->

<script type='text/javascript'><!--//<![CDATA[
   var m3_u = (location.protocol=='https:'?'https://www.insight-intermark.com/oladXi/www/delivery/ajs.php':'http://www.insight-intermark.com/oladXi/www/delivery/ajs.php');
   var m3_r = Math.floor(Math.random()*99999999999);
   if (!document.MAX_used) document.MAX_used = ',';
   document.write ("<scr"+"ipt type='text/javascript' src='"+m3_u);
   document.write ("?zoneid=48&amp;block=1&amp;blockcampaign=1");
   document.write ('&amp;cb=' + m3_r);
   if (document.MAX_used != ',') document.write ("&amp;exclude=" + document.MAX_used);
   document.write (document.charset ? '&amp;charset='+document.charset : (document.characterSet ? '&amp;charset='+document.characterSet : ''));
   document.write ("&amp;loc=" + escape(window.location));
   if (document.referrer) document.write ("&amp;referer=" + escape(document.referrer));
   if (document.context) document.write ("&context=" + escape(document.context));
   if (document.mmm_fo) document.write ("&amp;mmm_fo=1");
   document.write ("'><\/scr"+"ipt>");
//]]>--></script><noscript><a href='http://www.insight-intermark.com/oladXi/www/delivery/ck.php?n=a300f707&amp;cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://www.insight-intermark.com/oladXi/www/delivery/avw.php?zoneid=48&amp;cb=INSERT_RANDOM_NUMBER_HERE&amp;n=a300f707' border='0' alt='' /></a></noscript>


<br /><br /><!--/* OpenX Javascript Tag v2.8.7 */-->

<script type='text/javascript'><!--//<![CDATA[
   var m3_u = (location.protocol=='https:'?'https://www.insight-intermark.com/oladXi/www/delivery/ajs.php':'http://www.insight-intermark.com/oladXi/www/delivery/ajs.php');
   var m3_r = Math.floor(Math.random()*99999999999);
   if (!document.MAX_used) document.MAX_used = ',';
   document.write ("<scr"+"ipt type='text/javascript' src='"+m3_u);
   document.write ("?zoneid=48&amp;block=1&amp;blockcampaign=1");
   document.write ('&amp;cb=' + m3_r);
   if (document.MAX_used != ',') document.write ("&amp;exclude=" + document.MAX_used);
   document.write (document.charset ? '&amp;charset='+document.charset : (document.characterSet ? '&amp;charset='+document.characterSet : ''));
   document.write ("&amp;loc=" + escape(window.location));
   if (document.referrer) document.write ("&amp;referer=" + escape(document.referrer));
   if (document.context) document.write ("&context=" + escape(document.context));
   if (document.mmm_fo) document.write ("&amp;mmm_fo=1");
   document.write ("'><\/scr"+"ipt>");
//]]>--></script><noscript><a href='http://www.insight-intermark.com/oladXi/www/delivery/ck.php?n=a300f707&amp;cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://www.insight-intermark.com/oladXi/www/delivery/avw.php?zoneid=48&amp;cb=INSERT_RANDOM_NUMBER_HERE&amp;n=a300f707' border='0' alt='' /></a></noscript>


<br /><br /><!--/* OpenX Javascript Tag v2.8.7 */-->

<script type='text/javascript'><!--//<![CDATA[
   var m3_u = (location.protocol=='https:'?'https://www.insight-intermark.com/oladXi/www/delivery/ajs.php':'http://www.insight-intermark.com/oladXi/www/delivery/ajs.php');
   var m3_r = Math.floor(Math.random()*99999999999);
   if (!document.MAX_used) document.MAX_used = ',';
   document.write ("<scr"+"ipt type='text/javascript' src='"+m3_u);
   document.write ("?zoneid=48&amp;block=1&amp;blockcampaign=1");
   document.write ('&amp;cb=' + m3_r);
   if (document.MAX_used != ',') document.write ("&amp;exclude=" + document.MAX_used);
   document.write (document.charset ? '&amp;charset='+document.charset : (document.characterSet ? '&amp;charset='+document.characterSet : ''));
   document.write ("&amp;loc=" + escape(window.location));
   if (document.referrer) document.write ("&amp;referer=" + escape(document.referrer));
   if (document.context) document.write ("&context=" + escape(document.context));
   if (document.mmm_fo) document.write ("&amp;mmm_fo=1");
   document.write ("'><\/scr"+"ipt>");
//]]>--></script><noscript><a href='http://www.insight-intermark.com/oladXi/www/delivery/ck.php?n=a300f707&amp;cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://www.insight-intermark.com/oladXi/www/delivery/avw.php?zoneid=48&amp;cb=INSERT_RANDOM_NUMBER_HERE&amp;n=a300f707' border='0' alt='' /></a></noscript>


</div>

</div><div class="content">
<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>
 <h3>B&amp;B Network's Premium Members in Clare Clare</h3>
<p style="margin:0px 30px 10px 30px" >B&amp;B Network Premium Members in Clare  offer Last Minute Deals or special offers. Often they have the little extras that make your stay a touch more enjoyable - many have additional benefits such as FREE WiFi - Complimentary Tea and Coffee - Guest Lounge -and other personalised services.</p>

					<table class="deals" style="margin-top: 10px;">

				<tr >
					<th>
						<img src="http://www.killarney-insight.com/graphics/clock.gif" width="24" height="24" border="0" style="margin-right:10px;" align="absmiddle"/>
						Latest Clare Last Minute Deal
					</th>
					<th>
						<img src="http://www.killarney-insight.com/graphics/euro-sign.gif" width="24" height="24" border="0"  style="margin-right:10px;" align="absmiddle" />
						Latest Clare Special Offer
					</th>
				</tr>
				<tr>
					<td><div class='overlaypos'><img src='http://www.bunrattyheights.com/jpgs/bunrattyheights1.jpg' alt='Bunratty Heights most recent offer' /><img src="http://www.bnb-network.com/graphics/overlay.png" alt="BnB Picture Copyright IWM&nbsp;Ltd" width="150" height="100" class="overlay"></div><a href='http://www.bunrattyheights.com/reddot/' target='_blank'><h3>Bunratty Heights, Bunratty</h3>Single Room with Breakfast<br />&euro;40.00 per room</a></td>
					<td><div class='overlaypos'><img src='http://www.glashameadows.com/jpgs/glashameadows1.jpg' alt='Glasha Meadows most recent offer' /><img src="http://www.bnb-network.com/graphics/overlay.png" alt="BnB Picture Copyright IWM&nbsp;Ltd" width="150" height="100" class="overlay"></div><a href='http://www.glashameadows.com/reddot/' target='_blank'><h3>Glasha Meadows, Doolin</h3>Double Room<br />&euro;25.00 per person</a></td>
				</tr>
			</table>
				
		<!-- LISTING -->
				<h2  style="margin-top:15px;" >
			Clare Premium B&amp;B
			
			<div>
				<select id='region'><option value=''>Select a Region / County...</option>
					<option value='clare' selected='selected'>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' >Kerry</option><option value='kilkenny' >Kilkenny</option><option value='laois' >Laois</option><option value='limerick' >Limerick</option><option value='louth' >Louth</option><option value='meath' >Meath</option><option value='offaly' >Offaly</option><option value='roscommon' >Roscommon</option><option value='wicklow' >Wicklow</option><option value='antrim' >Antrim</option>				</select>
				<span id="townListWrapper"><select id='town'><option value=''>Select a City / Town...</option>
	<option value='all'>- All in Clare -</option>
	<option value='ballyvaughan' >Ballyvaughan</option><option value='bunratty' >Bunratty</option><option value='doolin' >Doolin</option><option value='newmarket-on-fergus' >Newmarket on Fergus</option></select></span>
			</div>
		</h2>
		
		<div class="hr" style="width: 800px;margin:15px auto 0;" ></div>
		
		<div id="propertyList">
			<table class='caption'><tr style='vertical-align:bottom'><td class='caption'><input type="button" value="&nbsp;" id="sortPrice"  /><input type="button" value="&nbsp;" id="sortDirectory" /></td><td style='width:86px' class='captionbtn previouspage'></td><td style='width:86px' class='captionbtn nextpage'></td><td class='currencyFlags'><small>Display rates in:&nbsp;</small><br /><img src='http://www.irelandbnb.com/graphics/eu.png' class='flag' id='eu' title='Convert all rates to Euro &euro;' /><img src='http://www.irelandbnb.com/graphics/uk.png' class='flag' id='gbp' title='Convert all rates to Pound Sterling &pound;' /><img src='http://www.irelandbnb.com/graphics/usa.png' class='flag' id='usd' title='Convert all rates to US Dollars $' /></td></tr></table><table class='propertylist'><tr>
  <td rowspan='2' width='100' align='center'>
    <div class='overlaypos'><a href='http://www.bunrattyheights.com' target='_blank'>
      <img src='http://www.bunrattyheights.com/jpgs/bunrattyheights1.jpg' alt='Click for further details' width='150' height='100' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='150' height='100' class='overlay' />
    </a></div>
  </td>
  <td style="background-color: #E6F3F7">
    <a href='http://www.bunrattyheights.com' target='_blank'>
    	<b>Bunratty Heights B&amp;B</b>
    	Bunratty, Clare
    </a>
    <a href='http://www.bunrattyheights.com' target='_blank'>
	     
    </a>

    <a href='http://www.bunrattyheights.com' target='_blank'>
      <img src='http://www.bnb-network.com/graphics/secure-lock.gif' alt='' width='14' height='16' border='0' align='right' style='margin-left:5px;cursor:help' title='This property accepts secure credit card bookings' />
      <img src='http://www.bnb-network.com/graphics/compass.gif' alt='' width='19' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property has a map showing its location' />
      <img src='http://www.bnb-network.com/graphics/wifi.gif' alt='' width='41' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property offers wireless Internet access' />
    </a>
  </td>
  <td width="80" align="center">
    <a href='http://www.bunrattyheights.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="55.00" lang="eu" class="price">&euro;55.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.bunrattyheights.com' target='_blank'>This charming, beautifully decorated, and luxurious Bed and Breakfast in Bunratty provides the warmth and welcome of a private home matched with the functionality of a hotel. It is also an ideal base for touring the Midwest region - The Burren, The C…...</a>
  </td>
  <td align="center">
    <a href='http://www.bunrattyheights.com' target='_blank'>
      <span class='moreinfo' title='Click here for more details of this property'></span>
    </a>
  </td>
</tr><tr>
  <td rowspan='2' width='100' align='center'>
    <div class='overlaypos'><a href='http://www.glashameadows.com' target='_blank'>
      <img src='http://www.glashameadows.com/jpgs/glashameadows1.jpg' alt='Click for further details' width='150' height='100' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='150' height='100' class='overlay' />
    </a></div>
  </td>
  <td style="background-color: #E6F3F7">
    <a href='http://www.glashameadows.com' target='_blank'>
    	<b>Glasha Meadows B&amp;B</b>
    	Doolin, Clare
    </a>
    <a href='http://www.glashameadows.com' target='_blank'>
	     
    </a>

    <a href='http://www.glashameadows.com' target='_blank'>
      <img src='http://www.bnb-network.com/graphics/secure-lock.gif' alt='' width='14' height='16' border='0' align='right' style='margin-left:5px;cursor:help' title='This property accepts secure credit card bookings' />
      <img src='http://www.bnb-network.com/graphics/compass.gif' alt='' width='19' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property has a map showing its location' />
      <img src='http://www.bnb-network.com/graphics/wifi.gif' alt='' width='41' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property offers wireless Internet access' />
    </a>
  </td>
  <td width="80" align="center">
    <a href='http://www.glashameadows.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="50.00" lang="eu" class="price">&euro;50.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.glashameadows.com' target='_blank'>Luxury four star B&amp;B in the music centre of Doolin R479.  From our Bed &amp; Breakfast you have a beautiful view of the bay with Doolin just a few minutes drive away.  Our guests can enjoy the comforts of our spacious bedrooms and bathroom with a…...</a>
  </td>
  <td align="center">
    <a href='http://www.glashameadows.com' target='_blank'>
      <span class='moreinfo' title='Click here for more details of this property'></span>
    </a>
  </td>
</tr><tr>
  <td rowspan='2' width='100' align='center'>
    <div class='overlaypos'><a href='http://www.kellscountryhouse.com' target='_blank'>
      <img src='http://www.kellscountryhouse.com/jpgs/kells1.jpg' alt='Click for further details' width='150' height='100' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='150' height='100' class='overlay' />
    </a></div>
  </td>
  <td style="background-color: #E6F3F7">
    <a href='http://www.kellscountryhouse.com' target='_blank'>
    	<b>Kells Country House B&amp;B</b>
    	Newmarket on Fergus, Clare
    </a>
    <a href='http://www.kellscountryhouse.com' target='_blank'>
	     
    </a>

    <a href='http://www.kellscountryhouse.com' target='_blank'>
      <img src='http://www.bnb-network.com/graphics/secure-lock.gif' alt='' width='14' height='16' border='0' align='right' style='margin-left:5px;cursor:help' title='This property accepts secure credit card bookings' />
      <img src='http://www.bnb-network.com/graphics/compass.gif' alt='' width='19' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property has a map showing its location' />
      <img src='http://www.bnb-network.com/graphics/wifi.gif' alt='' width='41' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property offers wireless Internet access' />
    </a>
  </td>
  <td width="80" align="center">
    <a href='http://www.kellscountryhouse.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="90.00" lang="eu" class="price">&euro;90.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.kellscountryhouse.com' target='_blank'>Welcome to Kells Country House, a five star rated castle situated on five acres, with views overlooking the Shannon River and surrounding countryside. All bedrooms ensuite with TV, tea making facilities and toiletries. Spacious visitors living room w…...</a>
  </td>
  <td align="center">
    <a href='http://www.kellscountryhouse.com' target='_blank'>
      <span class='moreinfo' title='Click here for more details of this property'></span>
    </a>
  </td>
</tr><tr>
  <td rowspan='2' width='100' align='center'>
    <div class='overlaypos'><a href='http://www.burrenviewclare.com' target='_blank'>
      <img src='http://www.burrenviewclare.com/jpgs/burren1.jpg' alt='Click for further details' width='150' height='100' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='150' height='100' class='overlay' />
    </a></div>
  </td>
  <td style="background-color: #E6F3F7">
    <a href='http://www.burrenviewclare.com' target='_blank'>
    	<b>Burren View B&amp;B</b>
    	Ballyvaughan, Clare
    </a>
    <a href='http://www.burrenviewclare.com' target='_blank'>
	    <img src='http://www.bnb-network.com/graphics/star.png' alt='Star rating' /><img src='http://www.bnb-network.com/graphics/star.png' alt='Star rating' /><img src='http://www.bnb-network.com/graphics/star.png' alt='Star rating' />
    </a>

    <a href='http://www.burrenviewclare.com' target='_blank'>
      <img src='http://www.bnb-network.com/graphics/secure-lock.gif' alt='' width='14' height='16' border='0' align='right' style='margin-left:5px;cursor:help' title='This property accepts secure credit card bookings' />
      <img src='http://www.bnb-network.com/graphics/compass.gif' alt='' width='19' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property has a map showing its location' />
      <img src='http://www.bnb-network.com/graphics/wifi.gif' alt='' width='41' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property offers wireless Internet access' />
    </a>
  </td>
  <td width="80" align="center">
    <a href='http://www.burrenviewclare.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="70.00" lang="eu" class="price">&euro;70.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.burrenviewclare.com' target='_blank'>Welcome to Burren View, which first opened its doors in 2005. Burren View provides five luxury suites, situated on the West Coast of Ireland, in the heart of the famed and historic Burren area with scenic views.

Burren View B&amp;B offers fresh hot …...</a>
  </td>
  <td align="center">
    <a href='http://www.burrenviewclare.com' target='_blank'>
      <span class='moreinfo' title='Click here for more details of this property'></span>
    </a>
  </td>
</tr><tr>
  <td rowspan='2' width='100' align='center'>
    <div class='overlaypos'><a href='http://www.bunratty-gallowsview.com' target='_blank'>
      <img src='http://www.bunratty-gallowsview.com/jpgs/gallows-bunratty1.jpg' alt='Click for further details' width='150' height='100' border='0' class='pic' />
      <img src='http://www.bnb-network.com/graphics/overlay.png' alt='BnB Picture Copyright IWM&nbsp;Ltd' width='150' height='100' class='overlay' />
    </a></div>
  </td>
  <td style="background-color: #E6F3F7">
    <a href='http://www.bunratty-gallowsview.com' target='_blank'>
    	<b>Gallows View B&amp;B</b>
    	Bunratty, Clare
    </a>
    <a href='http://www.bunratty-gallowsview.com' target='_blank'>
	    <img src='http://www.bnb-network.com/graphics/star.png' alt='Star rating' /><img src='http://www.bnb-network.com/graphics/star.png' alt='Star rating' /><img src='http://www.bnb-network.com/graphics/star.png' alt='Star rating' /><img src='http://www.bnb-network.com/graphics/star.png' alt='Star rating' />
    </a>

    <a href='http://www.bunratty-gallowsview.com' target='_blank'>
      <img src='http://www.bnb-network.com/graphics/secure-lock.gif' alt='' width='14' height='16' border='0' align='right' style='margin-left:5px;cursor:help' title='This property accepts secure credit card bookings' />
      <img src='http://www.bnb-network.com/graphics/compass.gif' alt='' width='19' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property has a map showing its location' />
      <img src='http://www.bnb-network.com/graphics/wifi.gif' alt='' width='41' height='17' border='0' align='right' style='margin-left:5px;cursor:help' title='This property offers wireless Internet access' />
    </a>
  </td>
  <td width="80" align="center">
    <a href='http://www.bunratty-gallowsview.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="60.00" lang="eu" class="price">&euro;60.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.bunratty-gallowsview.com' target='_blank'>Gallows View is a four star rated property where Mary McKenna offers a rather special brand of hospitality at this pretty chalet bungalow. Reached by a scenic country road that runs between Bunratty Castle and Durty Nellies Pub, well worth a visit! S…...</a>
  </td>
  <td align="center">
    <a href='http://www.bunratty-gallowsview.com' target='_blank'>
      <span class='moreinfo' title='Click here for more details of this property'></span>
    </a>
  </td>
</tr><tr><th colspan='3' style='font-weight:normal'><a href='http://membership.bnb-network.ie' target='_blank'>Do you own a B&amp;B, guesthouse or hotel in Clare? 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 Clare</h6>
			<ul>
				<li><a href='ballyvaughan-premium-bnb-clare.html'>Ballyvaughan B&amp;B</a></li></ul><ul><li><a href='bunratty-premium-bnb-clare.html'>Bunratty B&amp;B</a></li></ul><ul><li><a href='doolin-premium-bnb-clare.html'>Doolin B&amp;B</a></li></ul><ul><li><a href='newmarket-on-fergus-premium-bnb-clare.html'>Newmarket on Fergus B&amp;B</a></li></ul>			</ul>
		</div><!-- end large footer -->

</div></div><footer>Copyright 2012 <a href="http://www.insight-web-marketing.com" target="_blank" title="Internet marketing tourism">Insight Web Marketing Ltd</a> <a href="http://killarney-insight.com" target="_blank" title="Killarney">Killarney</a> - <a href="http://www.irish-insight.com" target="_blank">Irish Web Sites</a> - <a href="http://www.bnb-network.com" target="_blank">Bed and Breakfast</a> - <a href="http://www.bnb-booking.com" target="_blank">B&amp;B Booking</a></footer></div>

<script type="text/javascript" src="js.include/currency.js.php?localcurrency=eu"></script>
<script type="text/javascript">
	var countyUrl = "%region%-premium-bnb.html";
	var townUrl = "%town%-premium-bnb-%region%.html";
	
	var selectedRegion = new String('Clare').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 = 'Clare';
			$('select#region option:selected').each( function() {
				selectedRegion = $(this).attr("value");
				selected = $(this).text();
			});
			
			url = countyUrl;
			url = url.replace('%region%', selectedRegion);
			window.location = url;
		});
		
		if($('#town').attr('disabled') == false) setupEvents();
		
		$("#sortPrice").click( function() {
			window.location = "clare-premium-bnb.html?sortorder=price-a";
		});
		
		$("#sortDirectory").click( function() {
			window.location = "clare-bed-breakfast.html";
		});
	});
	
	function setupEvents() {		
		$('select#town').change( function() {
			var url;
			
			$('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);
			}
			
			window.location = url;
		});
	}
</script>

</body></html>