<!-- 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 'bed-breakfast' = '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 'bed-breakfast' = 'special-offers' then 'specialoffer'
        	WHEN 'bed-breakfast' = '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 '' != '' THEN (replace(bnb_options.additional_search, '-', ' ') LIKE '%  %' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE '% ' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE ' %' 
        		OR replace(bnb_options.additional_search, '-', ' ') = '' 
        		OR replace(bnb_options.county, '-', ' ') LIKE '%%')
          ELSE bnb_options.county != 'Best'
          END
        AND CASE WHEN '' = '' 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 'bed-breakfast' = 'premium-bnb' THEN bnb_options.member_type LIKE 'premium%'
          WHEN ('bed-breakfast' = 'bed-breakfast' or 'bed-breakfast' = '' or '' != '') AND '' THEN bnb_options.member_type != ''
          WHEN ('bed-breakfast' = 'bed-breakfast' or 'bed-breakfast' = '' or '' != '') AND 'Ireland' = 'Ireland' THEN bnb_options.member_type != 'non' AND bnb_options.member_type != 'nad'
          WHEN 'bed-breakfast' = 'bed-breakfast' or 'bed-breakfast' = '' or '' != '' THEN bnb_options.member_type != 'non'
          WHEN 'bed-breakfast' = 'bnb-directory' THEN bnb_options.member_type != ''
          WHEN 'bed-breakfast' = 'hostels' THEN bnb_options.type = 'hostel' AND bnb_options.member_type != 'non'
          WHEN 'bed-breakfast' = '' THEN bnb_options.type LIKE '%guesthouse%' AND bnb_options.member_type != 'non'
          WHEN 'bed-breakfast' = '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 'bed-breakfast' = '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 'bed-breakfast' != '' AND 'bed-breakfast' != 'bnb-directory' THEN bnb_options.member_type = 'bed-breakfast'
          ELSE bnb_options.member_type != ''
          END
        AND CASE WHEN 'Waterford Airport' != '' 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 = 'Waterford Airport')
	        							ELSE (searchoptions.description = 'Waterford Airport' 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(844151489) --><!-- 1 --><!DOCTYPE html>
<html>
<head>
<title>Ireland Bed and Breakfast</title>
<meta name="description" content="B&amp;B in Ireland" />
<meta name="keywords" content="Ireland,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" />
<!--<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" /> -->
<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" >Airports</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>Ireland B&amp;B Ireland</span></li>
<li><span>B&amp;Bs in Ireland Lodging</span></li>
<li><span>Accommodation Ireland</span></li>
<li><span>Find a B&amp;B in Ireland</span></li>
<li><span>Ireland Hotels &amp; Inns</span></li>
</ul>
</div>

<h1>B&amp;Bs near Waterford Airport</h1>


<div class="menu">
<ul id="menu">
<li><a href="bedandbreakfast.html" target="_blank">Special Offers</a></li>
<li><a href="bedandbreakfast.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">

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

<iframe name="butads" src="adverts/advert2.html" width="120" height="600" frameborder="0" marginwidth="0" marginheight="0" scrolling="no"></iframe>
</div>
</div>	
	<div class="content">
		<!-- LEADERBOARD -->
		<div class="leaderboard">
<iframe id='a63e0766' name='a63e0766' src='http://www.insight-intermark.com/oladXi/www/delivery/afr.php?zoneid=49&amp;cb=INSERT_RANDOM_NUMBER_HERE&amp;ct0=INSERT_CLICKURL_HERE' frameborder='0' scrolling='no' width='728' height='90'><a href='http://www.insight-intermark.com/oladXi/www/delivery/ck.php?n=a574e0f4&amp;cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://www.insight-intermark.com/oladXi/www/delivery/avw.php?zoneid=49&amp;cb=INSERT_RANDOM_NUMBER_HERE&amp;n=a574e0f4&amp;ct0=INSERT_CLICKURL_HERE' border='0' alt='' /></a></iframe></div>		<div class="hr" style="width: 800px;margin: 15px auto 0;" ></div>
		
		<!-- LISTING -->
				<h2  style="margin-top:15px;" >
			Waterford Airport  Bed and Breakfast
		
			<div>
				<select id='attractions'>
					<option value='' selected="selected">Select a ...</option>
					Airports<!-- SELECT name, town, county, country, type,
  			LOWER(REPLACE(REPLACE(TRIM(name), ' ', '-'), '&', '-and-')) AS urlname
  		FROM attractions
  		WHERE country LIKE '%Ireland'
        AND CASE WHEN '' != '' THEN county LIKE '%%'
          ELSE county != 'Best'
          END
	  		AND CASE WHEN 'airport' != '' THEN type = 'airport'
	  			ELSE 1 = 1
	  			END
	  		AND latitude != 0 AND longitude != 0
  		ORDER BY name --><option value='belfast-international-airport' >Belfast International Airport, Antrim</option><option value='city-of-derry-airport' >City of Derry Airport, Derry</option><option value='cork-airport' >Cork Airport, Cork</option><option value='donegal-airport' >Donegal Airport, Donegal</option><option value='dublin-airport' >Dublin Airport, Dublin</option><option value='galway-airport' >Galway Airport, Galway</option><option value='george-best-airport' >George Best Airport, Antrim</option><option value='inishmore-aran-islands' >Inishmore Aran Islands, Galway</option><option value='kerry-airport' >Kerry Airport, Kerry</option><option value='knock-airport' >Knock Airport, Mayo</option><option value='shannon-airport' >Shannon Airport, Clare</option><option value='sligo-airport' >Sligo Airport, Sligo</option><option value='waterford-airport' selected='selected'>Waterford Airport, Waterford</option>				</select>
			</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.bnb-network.com/bed-breakfast/waterford/tramore/beach-haven-house.html' target='_blank'>
      <img src='http://www.ireland-bnb.net/pictures/beachhaven.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.bnb-network.com/bed-breakfast/waterford/tramore/beach-haven-house.html' target='_blank'>
    	<b>Beach Haven House B&amp;B</b>
    	Tramore, Waterford
    </a>
    <a href='http://www.bnb-network.com/bed-breakfast/waterford/tramore/beach-haven-house.html' 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.bnb-network.com/bed-breakfast/waterford/tramore/beach-haven-house.html' target='_blank'>
      
      
      <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.bnb-network.com/bed-breakfast/waterford/tramore/beach-haven-house.html' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="59.00" lang="eu" class="price">&euro;59.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.bnb-network.com/bed-breakfast/waterford/tramore/beach-haven-house.html' target='_blank'>Beach Haven House is a unique and inviting family run B&amp;B close to everything in Tramore and Waterford City. We are right in the heart of it all just steps from the beach, amusements, award winning restaurants and lively pubs.  The house is taste…...</a>
  </td>
  <td align="center">
    <a href='http://www.bnb-network.com/bed-breakfast/waterford/tramore/beach-haven-house.html' 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.bnb-network.com/bed-breakfast/waterford/tramore/sea-court.html' target='_blank'>
      <img src='http://www.ireland-bnb.net/pictures/seacourt-tramore.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.bnb-network.com/bed-breakfast/waterford/tramore/sea-court.html' target='_blank'>
    	<b>Sea Court B&amp;B</b>
    	Tramore, Waterford
    </a>
    <a href='http://www.bnb-network.com/bed-breakfast/waterford/tramore/sea-court.html' 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.bnb-network.com/bed-breakfast/waterford/tramore/sea-court.html' target='_blank'>
      
      
      <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.bnb-network.com/bed-breakfast/waterford/tramore/sea-court.html' 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.bnb-network.com/bed-breakfast/waterford/tramore/sea-court.html' target='_blank'>Sea Court B&amp;B is a comfortable and homely 4 star award winning B&amp;B located in the seaside town of Tramore. It serves as the perfect place to stay during your visit to our gorgeous seaside town.

Guests can relax and enjoy a cup of tea/coffe…...</a>
  </td>
  <td align="center">
    <a href='http://www.bnb-network.com/bed-breakfast/waterford/tramore/sea-court.html' 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.fernhill-bnb.com' target='_blank'>
      <img src='http://www.fernhill-bnb.com/jpgs/fernhill1.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.fernhill-bnb.com' target='_blank'>
    	<b>Fern Hill B&amp;B</b>
    	Tramore, Waterford
    </a>
    <a href='http://www.fernhill-bnb.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.fernhill-bnb.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.fernhill-bnb.com' target='_blank'>
      Rooms From<br />
      <b style="color: #ce1111; font-size: 13px;" alt="62.00" lang="eu" class="price">&euro;62.00</b>
    </a>
  </td>
</tr>
<tr valign='middle'>
  <td colspan='1' valign='top'>
    <a href='http://www.fernhill-bnb.com' target='_blank'>Four star rated "Fern Hill" is an award winning B&amp;B. It was a Welcome Ireland finalist 2006 and was Gulliver Ireland's choice as Best B&amp;B (South East Region) 2008. It has been operating as a B&amp;B for the last 12 years and is located in the…...</a>
  </td>
  <td align="center">
    <a href='http://www.fernhill-bnb.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.bnb-network.com/bed-breakfast/wexford/new-ross/carrigbyrne-lodge.html' target='_blank'>
      <img src='http://www.ireland-bnb.net/pictures/carrigbyrne-newross.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.bnb-network.com/bed-breakfast/wexford/new-ross/carrigbyrne-lodge.html' target='_blank'>
    	<b>Carrigbyrne Lodge B&amp;B</b>
    	New Ross, Wexford
    </a>
    <a href='http://www.bnb-network.com/bed-breakfast/wexford/new-ross/carrigbyrne-lodge.html' target='_blank'>
	     
    </a>

    <a href='http://www.bnb-network.com/bed-breakfast/wexford/new-ross/carrigbyrne-lodge.html' target='_blank'>
      
      
    </a>
  </td>
  <td width="80" align="center">
    <a href='http://www.bnb-network.com/bed-breakfast/wexford/new-ross/carrigbyrne-lodge.html' 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.bnb-network.com/bed-breakfast/wexford/new-ross/carrigbyrne-lodge.html' target='_blank'>Carrigbyrne Lodge Country B&amp;B is just 5 miles from the town of New Ross.  Our beautifully decorated home has superb views of Carrigbyrne Hill, the Blackstairs Mountains, and Slieve Coillte.  Our luxurious facilities include 3 large en-suite bedro…...</a>
  </td>
  <td align="center">
    <a href='http://www.bnb-network.com/bed-breakfast/wexford/new-ross/carrigbyrne-lodge.html' 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 Ireland? 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 Ireland</h6>
			<ul>
				<li><a href='carlow-bed-breakfast.html'>Carlow B&amp;B</a></li><li><a href='cavan-bed-breakfast.html'>Cavan B&amp;B</a></li><li><a href='clare-bed-breakfast.html'>Clare B&amp;B</a></li><li><a href='cork-bed-breakfast.html'>Cork B&amp;B</a></li><li><a href='donegal-bed-breakfast.html'>Donegal B&amp;B</a></li><li><a href='dublin-bed-breakfast.html'>Dublin B&amp;B</a></li><li><a href='galway-bed-breakfast.html'>Galway B&amp;B</a></li></ul><ul><li><a href='kerry-bed-breakfast.html'>Kerry B&amp;B</a></li><li><a href='kildare-bed-breakfast.html'>Kildare B&amp;B</a></li><li><a href='kilkenny-bed-breakfast.html'>Kilkenny B&amp;B</a></li><li><a href='laois-bed-breakfast.html'>Laois B&amp;B</a></li><li><a href='leitrim-bed-breakfast.html'>Leitrim B&amp;B</a></li><li><a href='limerick-bed-breakfast.html'>Limerick B&amp;B</a></li><li><a href='longford-bed-breakfast.html'>Longford B&amp;B</a></li></ul><ul><li><a href='louth-bed-breakfast.html'>Louth B&amp;B</a></li><li><a href='mayo-bed-breakfast.html'>Mayo B&amp;B</a></li><li><a href='meath-bed-breakfast.html'>Meath B&amp;B</a></li><li><a href='monaghan-bed-breakfast.html'>Monaghan B&amp;B</a></li><li><a href='offaly-bed-breakfast.html'>Offaly B&amp;B</a></li><li><a href='roscommon-bed-breakfast.html'>Roscommon B&amp;B</a></li><li><a href='sligo-bed-breakfast.html'>Sligo B&amp;B</a></li></ul><ul><li><a href='tipperary-bed-breakfast.html'>Tipperary B&amp;B</a></li><li><a href='waterford-bed-breakfast.html'>Waterford B&amp;B</a></li><li><a href='westmeath-bed-breakfast.html'>Westmeath B&amp;B</a></li><li><a href='wexford-bed-breakfast.html'>Wexford B&amp;B</a></li><li><a href='wicklow-bed-breakfast.html'>Wicklow B&amp;B</a></li><li><a href='antrim-bed-breakfast.html'>Antrim B&amp;B</a></li><li><a href='armagh-bed-breakfast.html'>Armagh B&amp;B</a></li></ul><ul><li><a href='derry-bed-breakfast.html'>Derry B&amp;B</a></li><li><a href='down-bed-breakfast.html'>Down B&amp;B</a></li><li><a href='fermanagh-bed-breakfast.html'>Fermanagh B&amp;B</a></li><li><a href='tyrone-bed-breakfast.html'>Tyrone B&amp;B</a></li>			</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 regionUrl = "bed-breakfast-airports-%attraction%.html";
	
	var selectedRegion = new String('').replace(' ', '-').replace('&', '-and-').toLowerCase();

	$(document).ready( function() {
		$('select#attractions').change( function() {
			var selected;// = '';
			var selectedAttraction = '';
			$('select#attractions option:selected').each( function() {
				selectedAttraction = $(this).attr("value");
				selected = $(this).text();
			});
			
			url = regionUrl;
			url = url.replace('%attraction%', selectedAttraction);
			window.location = url;
			
		});
		
		$("#sortPrice").click( function() {
			window.location = "bed-breakfast-airports-waterford-airport.html?sortorder=price-a";
		});
		
		$("#sortDirectory").click( function() {
			window.location = "bed-breakfast-in-ireland.html";
		});
	});
	
	function setupEvents() {		

	}
</script>

</body>
</html>