<!-- networkAccommodation() --><!-- 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-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 'premium-bnb' = 'special-offers' then 'specialoffer'
        	WHEN 'premium-bnb' = '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 'Cork' != '' THEN (replace(bnb_options.additional_search, '-', ' ') LIKE '% Cork %' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE '% Cork' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE 'Cork %' 
        		OR replace(bnb_options.additional_search, '-', ' ') = 'Cork' 
        		OR replace(bnb_options.county, '-', ' ') LIKE '%Cork%')
          ELSE bnb_options.county != 'Best'
          END
        AND CASE WHEN 'Cork' = '' 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(1765205773) --><!-- 1 --><!DOCTYPE html>
<html>
<head>
<title>Premium B&amp;Bs in Cork</title>
<meta name="description" content="Cork B&amp;B offering superior service, Last Minute Deals and Speacial Offers" />
<meta name="keywords" content="Cork,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 Cork</span></li>
<li><span>Cork Bed and Breakfast</span></li>
<li><span>Last Minute Cork</span></li>
<li><span>Ireland's Best Bed &amp; Breakfast</span></li>
<li><span>Quality B&amp;B Cork</span></li>
<li><span>Select Family Homes Cork</span></li>
</ul>
</div>
<h1>Premium B&amp;Bs Cork</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"> 29</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 Cork Cork</h3>
<p style="margin:0px 30px 10px 30px" >B&amp;B Network Premium Members in Cork  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 Cork 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 Cork Special Offer
					</th>
				</tr>
				<tr>
					<td><div class='overlaypos'><img src='http://www.findushouse.com/jpgs/findus1.jpg' alt='Findus House 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.findushouse.com/reddot/' target='_blank'><h3>Findus House, Macroom</h3>twin room<br />&euro;56.00 per room</a></td>
					<td><div class='overlaypos'><img src='http://www.blarneysunnyside.com/jpgs/sunnyside1.jpg' alt='Sunnyside 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.blarneysunnyside.com/reddot/' target='_blank'><h3>Sunnyside, Blarney</h3>Double Room for 3 nights<br />&euro;160.00 per room</a></td>
				</tr>
			</table>
				
		<!-- LISTING -->
				<h2  style="margin-top:15px;" >
			Cork Premium B&amp;B
			
			<div>
				<select id='region'><option value=''>Select a Region / County...</option>
					<option value='clare' >Clare</option><option value='cork' selected='selected'>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"><!-- 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 'cork' != '' then (bnb.additional_search like '% cork %' or bnb.additional_search like '% cork' or bnb.additional_search like 'cork %' or bnb.additional_search = 'cork' or bnb.county like '%cork%')
              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' = 'premium-bnb' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
              when 'premium-bnb' = 'bed-breakfast' then options.member_type != 'non' and options.member_type != 'nad'
              when 'premium-bnb' = 'bnb-directory' then options.member_type != ''
              when 'premium-bnb' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
              when 'premium-bnb' = 'hostels-accommodation' then bnb.type = 'hostel'
              when 'premium-bnb' = 'xx' then bnb.type like '%hotel%' and options.member_type != 'non'
              when 'premium-bnb' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
              WHEN 'premium-bnb' = '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 'premium-bnb' = '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 'premium-bnb' != '' then options.member_type = 'premium-bnb'
              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 Cork -</option>
	<option value='ballincollig' >Ballincollig</option><option value='bantry' >Bantry</option><option value='macroom' >Macroom</option><option value='millstreet' >Millstreet</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.ardnagreine.net' target='_blank'>
      <img src='http://www.ardnagreine.net/jpgs/ardnagreine1.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.ardnagreine.net' target='_blank'>
    	<b>Ard na Greine B&amp;B</b>
    	Bantry, Cork
    </a>
    <a href='http://www.ardnagreine.net' 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.ardnagreine.net' 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.ardnagreine.net' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="65.00" lang="eu" class="price">&euro;65.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.ardnagreine.net' target='_blank'>Country home - 3 Star Approved by the Irish Tourist Standards - is situated in peaceful, rural setting overlooking mature gardens and countryside. The locality features sea, mountains, river and hills as well as the beautiful gardens. Among the facil...</a>
  </td>
  <td align="center">
    <a href='http://www.ardnagreine.net' 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.orchardbnb.com' target='_blank'>
      <img src='http://www.orchardbnb.com/jpgs/orchardcork1.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.orchardbnb.com' target='_blank'>
    	<b>The Orchard B&amp;B</b>
    	Ballincollig, Cork
    </a>
    <a href='http://www.orchardbnb.com' target='_blank'>
	     
    </a>

    <a href='http://www.orchardbnb.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.orchardbnb.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.orchardbnb.com' target='_blank'>The Orchard B&amp;B in Ballincollig Town Centre is a family run B&amp;B situated on the main street next to The Oriel House Hotel.  We aim to provide a relaxed friendly atmosphere in a comfortable environment.  Enjoy a full Irish Breakfast to start y...</a>
  </td>
  <td align="center">
    <a href='http://www.orchardbnb.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.coolefieldhouse.com' target='_blank'>
      <img src='http://www.coolefieldhouse.com/jpgs/coolefield1.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.coolefieldhouse.com' target='_blank'>
    	<b>Coolefield House Guesthouse</b>
    	Millstreet, Cork
    </a>
    <a href='http://www.coolefieldhouse.com' target='_blank'>
	     
    </a>

    <a href='http://www.coolefieldhouse.com' target='_blank'>
      
      <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.coolefieldhouse.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="100.00" lang="eu" class="price">&euro;100.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.coolefieldhouse.com' target='_blank'>Coolefield House, one of Alistair Sawday's Special Places to Stay,  is located in a parkland setting on the banks of the River Blackwater. The house, built some 2 years ago, is in the Georgian style with high ceilings and spacious rooms, suggesting a...</a>
  </td>
  <td align="center">
    <a href='http://www.coolefieldhouse.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.findushouse.com' target='_blank'>
      <img src='http://www.findushouse.com/jpgs/findus1.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.findushouse.com' target='_blank'>
    	<b>Findus House B&amp;B</b>
    	Macroom, Cork
    </a>
    <a href='http://www.findushouse.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.findushouse.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.findushouse.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="56.00" lang="eu" class="price">&euro;56.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.findushouse.com' target='_blank'>Farmhouse situated in peaceful idyllic location that is very central for those touring the Cork &amp; Kerry Region. All accommodation is on ground floor level. We have 6 bedrooms, all ensuite with power showers and individually decorated.They are mai...</a>
  </td>
  <td align="center">
    <a href='http://www.findushouse.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 Cork? 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 Cork</h6>
			<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 'Cork' != '' then (bnb.additional_search like '% Cork %' or bnb.additional_search like '% Cork' or bnb.additional_search like 'Cork %' or bnb.additional_search = 'Cork' or bnb.county like '%Cork%')
              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' = 'premium-bnb' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
              when 'premium-bnb' = 'bed-breakfast' then options.member_type != 'non' and options.member_type != 'nad'
              when 'premium-bnb' = 'bnb-directory' then options.member_type != ''
              when 'premium-bnb' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
              when 'premium-bnb' = 'hostels-accommodation' then bnb.type = 'hostel'
              when 'premium-bnb' = 'xx' then bnb.type like '%hotel%' and options.member_type != 'non'
              when 'premium-bnb' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
              WHEN 'premium-bnb' = '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 'premium-bnb' = '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 'premium-bnb' != '' then options.member_type = 'premium-bnb'
              else options.member_type != ''
              end
          group by town, county
          order by town, county --><li><a href='ballincollig-premium-bnb-cork.html'>Ballincollig B&amp;B</a></li></ul><ul><li><a href='bantry-premium-bnb-cork.html'>Bantry B&amp;B</a></li></ul><ul><li><a href='macroom-premium-bnb-cork.html'>Macroom B&amp;B</a></li></ul><ul><li><a href='millstreet-premium-bnb-cork.html'>Millstreet 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('Cork').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 = 'Cork';
			$('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 = "cork-premium-bnb.html?sortorder=price-a";
		});
		
		$("#sortDirectory").click( function() {
			window.location = "cork-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>