<!-- 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 '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 'Mitchelstown' != '' THEN (REPLACE(bnb_options.town, '\'', '') LIKE 'Mitchelstown%' OR bnb_options.additional_search LIKE '%Mitchelstown%' or address1 like '%Mitchelstown%' or address2 like '%Mitchelstown%' or address3 like '%Mitchelstown%')
					WHEN 'Mitchelstown' != '' THEN (REPLACE(bnb_options.town, '\'', '') like 'Mitchelstown%' OR bnb_options.additional_search LIKE '%Mitchelstown%')
          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(1673895492) --><!-- 1 --><!DOCTYPE html >
<html>
<head>
<title>Directory of B&amp;Bs in Mitchelstown</title>
<meta name="description" content="Mitchelstown bed and breakfast accommodation Ireland" />
<meta name="keywords" content="Mitchelstown,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" >Mitchelstown 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 Mitchelstown Directory</span></li>
<li><span> Lodging B&amp;Bs in Mitchelstown</span></li>
<li><span>Inns Hotels in Mitchelstown</span></li>
<li><span>Rooms in Mitchelstown</span></li>
<li><span>All Accommodation Mitchelstown</span></li>
</ul>
</div>
<h1>Mitchelstown B&amp;B Directory</h1>

<div class="menu">
<ul id="menu">
<li><a href="http://www.reddotdeals.ie/special-offers.html" target="_blank">Special Offers</a></li>
<li><a href="http://www.reddotdeals.ie/last-minute.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"> 29</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/advert1.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;" >
			Mitchelstown 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' 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='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 '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' 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 Cork -</option>
	<option value='adrigole' >Adrigole</option><option value='allihies' >Allihies</option><option value='ballincollig' >Ballincollig</option><option value='ballingeary' >Ballingeary</option><option value='ballinhassig' >Ballinhassig</option><option value='ballycotton' >Ballycotton</option><option value='ballydehob' >Ballydehob</option><option value='ballyvourney' >Ballyvourney</option><option value='baltimore' >Baltimore</option><option value='bandon' >Bandon</option><option value='bantry' >Bantry</option><option value='bantry-bay' >Bantry Bay</option><option value='beara' >Beara</option><option value='bere-island' >Bere Island</option><option value='bishopstown' >Bishopstown</option><option value='blarney' >Blarney</option><option value='cape-clear-island' >Cape Clear Island</option><option value='carrigaline' >Carrigaline</option><option value='castlemartyr' >Castlemartyr</option><option value='castletownbere' >Castletownbere</option><option value='castletownshend' >Castletownshend</option><option value='charleville' >Charleville</option><option value='chraleville' >Chraleville</option><option value='clonakilty' >Clonakilty</option><option value='cobh' >Cobh</option><option value='conna' >Conna</option><option value='cork-city' >Cork City</option><option value='crookhaven' >Crookhaven</option><option value='crosshavan' >Crosshavan</option><option value='curaheen' >Curaheen</option><option value='douglas' >Douglas</option><option value='drimoleague' >Drimoleague</option><option value='dunmanway' >Dunmanway</option><option value='durrus' >Durrus</option><option value='farnanes' >Farnanes</option><option value='farran' >Farran</option><option value='fermoy' >Fermoy</option><option value='fota-island' >Fota Island</option><option value='glandore' >Glandore</option><option value='glengarriff' >Glengarriff</option><option value='goleen' >Goleen</option><option value='heir-island' >Heir Island</option><option value='inishannon' >Inishannon</option><option value='innishannon' >Innishannon</option><option value='kanturk' >Kanturk</option><option value='kellbeg' >Kellbeg</option><option value='kilbrittain' >Kilbrittain</option><option value='killeagh' >Killeagh</option><option value='kinsale' >Kinsale</option><option value='macroom' >Macroom</option><option value='mallow' >Mallow</option><option value='midleton' >Midleton</option><option value='millstreet' >Millstreet</option><option value='mitchelstown' selected='selected'>Mitchelstown</option><option value='oysterhaven' >Oysterhaven</option><option value='rosscarbery' >Rosscarbery</option><option value='schull' >Schull</option><option value='shanagarry' >Shanagarry</option><option value='sherkin-island' >Sherkin Island</option><option value='skibbereen' >Skibbereen</option><option value='the-strand' >The Strand</option><option value='timoleague' >Timoleague</option><option value='union-hall' >Union Hall</option><option value='youghal' >Youghal</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'></td></tr></table><table></table>
<br />
<table>
<tr><th colspan='4' class='otherbnbs'>Other Mitchelstown, Ireland B&amp;B Accommodation</th></tr><tr class='x'>
<!--<tr valign="middle">-->
  <td class="padding" style="font-size:13px;vertical-align:middle">
    <a href="http://www.bnb-network.com/contact.html?id=2394">
	    <b>Mountain View, </b><br />
	    Mitchelstown,<br />
	    Cork,<br />
	    Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Mountain View"  style="float:right" />
    </a>
  </td>
<!--</tr>-->
<!--<tr valign="middle">-->
  <td class="padding" style="font-size:13px;vertical-align:middle">
    <a href="http://www.bnb-network.com/contact.html?id=559">
	    <b>Palm Lodge, </b><br />
	    Mitchelstown,<br />
	    Cork,<br />
	    Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Palm Lodge"  style="float:right" />
    </a>
  </td>
<!--</tr>-->
<!--<tr valign="middle">-->
  <td class="padding" style="font-size:13px;vertical-align:middle">
    <a href="http://www.bnb-network.com/contact.html?id=558">
	    <b>Riversdale, </b><br />
	    Mitchelstown,<br />
	    Cork,<br />
	    Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Riversdale"  style="float:right" />
    </a>
  </td>
<!--</tr>-->
<!--<tr valign="middle">-->
  <td class="padding" style="font-size:13px;vertical-align:middle">
    <a href="http://www.bnb-network.com/contact.html?id=148">
	    <b>Greenfields House, </b><br />
	    Mitchelstown,<br />
	    Cork,<br />
	    Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Greenfields House"  style="float:right" />
    </a>
  </td>
<!--</tr>--></tr></table>			<br style="clear:both" />
		</div>
		
		<div id="linksfooter"><!-- large links footer -->
			<h6>Bed &amp; Breakfast Accommodation in Mitchelstown, Cork</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 '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' 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='adrigole-bnb-directory-cork.html'>Adrigole B&amp;B</a></li><li><a href='allihies-bnb-directory-cork.html'>Allihies B&amp;B</a></li><li><a href='ballincollig-bnb-directory-cork.html'>Ballincollig B&amp;B</a></li><li><a href='ballingeary-bnb-directory-cork.html'>Ballingeary B&amp;B</a></li><li><a href='ballinhassig-bnb-directory-cork.html'>Ballinhassig B&amp;B</a></li><li><a href='ballycotton-bnb-directory-cork.html'>Ballycotton B&amp;B</a></li><li><a href='ballydehob-bnb-directory-cork.html'>Ballydehob B&amp;B</a></li><li><a href='ballyvourney-bnb-directory-cork.html'>Ballyvourney B&amp;B</a></li><li><a href='baltimore-bnb-directory-cork.html'>Baltimore B&amp;B</a></li><li><a href='bandon-bnb-directory-cork.html'>Bandon B&amp;B</a></li><li><a href='bantry-bnb-directory-cork.html'>Bantry B&amp;B</a></li><li><a href='bantry-bay-bnb-directory-cork.html'>Bantry Bay B&amp;B</a></li><li><a href='beara-bnb-directory-cork.html'>Beara B&amp;B</a></li></ul><ul><li><a href='bere-island-bnb-directory-cork.html'>Bere Island B&amp;B</a></li><li><a href='bishopstown-bnb-directory-cork.html'>Bishopstown B&amp;B</a></li><li><a href='blarney-bnb-directory-cork.html'>Blarney B&amp;B</a></li><li><a href='cape-clear-island-bnb-directory-cork.html'>Cape Clear Island B&amp;B</a></li><li><a href='carrigaline-bnb-directory-cork.html'>Carrigaline B&amp;B</a></li><li><a href='castlemartyr-bnb-directory-cork.html'>Castlemartyr B&amp;B</a></li><li><a href='castletownbere-bnb-directory-cork.html'>Castletownbere B&amp;B</a></li><li><a href='castletownshend-bnb-directory-cork.html'>Castletownshend B&amp;B</a></li><li><a href='charleville-bnb-directory-cork.html'>Charleville B&amp;B</a></li><li><a href='chraleville-bnb-directory-cork.html'>Chraleville B&amp;B</a></li><li><a href='clonakilty-bnb-directory-cork.html'>Clonakilty B&amp;B</a></li><li><a href='cobh-bnb-directory-cork.html'>Cobh B&amp;B</a></li><li><a href='conna-bnb-directory-cork.html'>Conna B&amp;B</a></li></ul><ul><li><a href='cork-city-bnb-directory-cork.html'>Cork City B&amp;B</a></li><li><a href='crookhaven-bnb-directory-cork.html'>Crookhaven B&amp;B</a></li><li><a href='crosshavan-bnb-directory-cork.html'>Crosshavan B&amp;B</a></li><li><a href='curaheen-bnb-directory-cork.html'>Curaheen B&amp;B</a></li><li><a href='douglas-bnb-directory-cork.html'>Douglas B&amp;B</a></li><li><a href='drimoleague-bnb-directory-cork.html'>Drimoleague B&amp;B</a></li><li><a href='dunmanway-bnb-directory-cork.html'>Dunmanway B&amp;B</a></li><li><a href='durrus-bnb-directory-cork.html'>Durrus B&amp;B</a></li><li><a href='farnanes-bnb-directory-cork.html'>Farnanes B&amp;B</a></li><li><a href='farran-bnb-directory-cork.html'>Farran B&amp;B</a></li><li><a href='fermoy-bnb-directory-cork.html'>Fermoy B&amp;B</a></li><li><a href='fota-island-bnb-directory-cork.html'>Fota Island B&amp;B</a></li><li><a href='glandore-bnb-directory-cork.html'>Glandore B&amp;B</a></li></ul><ul><li><a href='glengarriff-bnb-directory-cork.html'>Glengarriff B&amp;B</a></li><li><a href='goleen-bnb-directory-cork.html'>Goleen B&amp;B</a></li><li><a href='heir-island-bnb-directory-cork.html'>Heir Island B&amp;B</a></li><li><a href='inishannon-bnb-directory-cork.html'>Inishannon B&amp;B</a></li><li><a href='innishannon-bnb-directory-cork.html'>Innishannon B&amp;B</a></li><li><a href='kanturk-bnb-directory-cork.html'>Kanturk B&amp;B</a></li><li><a href='kellbeg-bnb-directory-cork.html'>Kellbeg B&amp;B</a></li><li><a href='kilbrittain-bnb-directory-cork.html'>Kilbrittain B&amp;B</a></li><li><a href='killeagh-bnb-directory-cork.html'>Killeagh B&amp;B</a></li><li><a href='kinsale-bnb-directory-cork.html'>Kinsale B&amp;B</a></li><li><a href='macroom-bnb-directory-cork.html'>Macroom B&amp;B</a></li><li><a href='mallow-bnb-directory-cork.html'>Mallow B&amp;B</a></li><li><a href='midleton-bnb-directory-cork.html'>Midleton B&amp;B</a></li></ul><ul><li><a href='millstreet-bnb-directory-cork.html'>Millstreet B&amp;B</a></li><li><a href='mitchelstown-bnb-directory-cork.html'>Mitchelstown B&amp;B</a></li><li><a href='oysterhaven-bnb-directory-cork.html'>Oysterhaven B&amp;B</a></li><li><a href='rosscarbery-bnb-directory-cork.html'>Rosscarbery B&amp;B</a></li><li><a href='schull-bnb-directory-cork.html'>Schull B&amp;B</a></li><li><a href='shanagarry-bnb-directory-cork.html'>Shanagarry B&amp;B</a></li><li><a href='sherkin-island-bnb-directory-cork.html'>Sherkin Island B&amp;B</a></li><li><a href='skibbereen-bnb-directory-cork.html'>Skibbereen B&amp;B</a></li><li><a href='the-strand-bnb-directory-cork.html'>The Strand B&amp;B</a></li><li><a href='timoleague-bnb-directory-cork.html'>Timoleague B&amp;B</a></li><li><a href='union-hall-bnb-directory-cork.html'>Union Hall B&amp;B</a></li><li><a href='youghal-bnb-directory-cork.html'>Youghal 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('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';
			//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>