<!-- 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 'Galway' != '' THEN (replace(bnb_options.additional_search, '-', ' ') LIKE '% Galway %' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE '% Galway' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE 'Galway %' 
        		OR replace(bnb_options.additional_search, '-', ' ') = 'Galway' 
        		OR replace(bnb_options.county, '-', ' ') LIKE '%Galway%')
          ELSE bnb_options.county != 'Best'
          END
        AND CASE WHEN 'Galway' = '' AND 'Newcastle Road' != '' THEN (REPLACE(bnb_options.town, '\'', '') LIKE 'Newcastle Road%' OR bnb_options.additional_search LIKE '%Newcastle Road%' or address1 like '%Newcastle Road%' or address2 like '%Newcastle Road%' or address3 like '%Newcastle Road%')
					WHEN 'Newcastle Road' != '' THEN (REPLACE(bnb_options.town, '\'', '') like 'Newcastle Road%' OR bnb_options.additional_search LIKE '%Newcastle Road%')
          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(1250212258) --><!-- 1 --><!DOCTYPE html >
<html>
<head>
<title>Directory of B&amp;Bs in Newcastle Road</title>
<meta name="description" content="Newcastle Road bed and breakfast accommodation Ireland" />
<meta name="keywords" content="Newcastle Road,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" >Newcastle Road 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 Newcastle Road Directory</span></li>
<li><span> Lodging B&amp;Bs in Newcastle Road</span></li>
<li><span>Inns Hotels in Newcastle Road</span></li>
<li><span>Rooms in Newcastle Road</span></li>
<li><span>All Accommodation Newcastle Road</span></li>
</ul>
</div>
<h1>Newcastle Road 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"> 27</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;" >
			Newcastle Road Bed &amp; Breakfast
			
			<span>
				<select id='region'><option value=''>Select a Region / County...</option>
					<option value='carlow' >Carlow</option><option value='cavan' >Cavan</option><option value='clare' >Clare</option><option value='cork' >Cork</option><option value='donegal' >Donegal</option><option value='dublin' >Dublin</option><option value='galway' selected='selected'>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 'galway' != '' then (bnb.additional_search like '% galway %' or bnb.additional_search like '% galway' or bnb.additional_search like 'galway %' or bnb.additional_search = 'galway' or bnb.county like '%galway%')
              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 Galway -</option>
	<option value='annaghdown' >Annaghdown</option><option value='aran-islands' >Aran Islands</option><option value='ardrahan' >Ardrahan</option><option value='athenry' >Athenry</option><option value='aughrim' >Aughrim</option><option value='ballina' >Ballina</option><option value='ballinasloe' >Ballinasloe</option><option value='ballyconneely' >Ballyconneely</option><option value='barna' >Barna</option><option value='barna-road' >Barna Road</option><option value='caherlistrane' >Caherlistrane</option><option value='carna' >Carna</option><option value='carraroe' >Carraroe</option><option value='claregalway' >Claregalway</option><option value='clarinbridge' >Clarinbridge</option><option value='cleggan' >Cleggan</option><option value='clifden' >Clifden</option><option value='clonbur' >Clonbur</option><option value='cong' >Cong</option><option value='cong' >Cong</option><option value='connemara' >Connemara</option><option value='cornamona' >Cornamona</option><option value='corofin' >Corofin</option><option value='corrandulla' >Corrandulla</option><option value='craughwell' >Craughwell</option><option value='dunmore' >Dunmore</option><option value='eyrecourt' >Eyrecourt</option><option value='frenchville-lane' >Frenchville Lane</option><option value='furbo' >Furbo</option><option value='galway' >Galway</option><option value='galway-city' >Galway City</option><option value='galway-city-east' >Galway City East</option><option value='gort' >Gort</option><option value='headford' >Headford</option><option value='headford-road' >Headford Road</option><option value='inis-mor' >Inis Mor</option><option value='inishbofin-island' >Inishbofin Island</option><option value='inishere' >Inishere</option><option value='kilkieran' >Kilkieran</option><option value='killary' >Killary</option><option value='kinvara' >Kinvara</option><option value='klifden' >Klifden</option><option value='leenane' >Leenane</option><option value='letterfrack' >Letterfrack</option><option value='lough-corrib' >Lough Corrib</option><option value='loughrea' >Loughrea</option><option value='lower-salthill' >Lower Salthill</option><option value='monivea' >Monivea</option><option value='moycullen' >Moycullen</option><option value='oranmore' >Oranmore</option><option value='oughterard' >Oughterard</option><option value='peterswell' >Peterswell</option><option value='portumna' >Portumna</option><option value='renmore' >Renmore</option><option value='renvyle' >Renvyle</option><option value='rosmuc' >Rosmuc</option><option value='roundstone' >Roundstone</option><option value='salthill' >Salthill</option><option value='spiddal' >Spiddal</option><option value='taylors-hill' >Taylors Hill</option><option value='tuam' >Tuam</option><option value='williamstown' >Williamstown</option><option value='woodquay' >Woodquay</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><tr><td class='noproperties' align='center'>Sorry, we cannot find any listings in our database for <b>Newcastle Road</b> - Please try searching for a nearby town or city - type ONLY the name of  the City or Town in the search box below.<br /><br />  <form class="form" action="bedandbreakfast.html" method="post" onsubmit="var x = document.getElementById('townSearch').value; if(x == '' || x == 'Enter a Town or Region to search for'){ alert('Please enter a town name to search for'); document.getElementById('townSearch').select(); return false; } else { return true; }" >
 
    <input type="text" name="town" id="townSearch" value="Enter a Town or Region to list B&amp;Bs" onclick="this.value = this.value == 'Enter a Town or Region to list B&amp;Bs' ? '' : this.value" onblur="this.value = this.value == '' ? 'Enter a Town or Region to list B&amp;Bs' : this.value" style="height:25px;padding-left:10px;" />
   	<input type="hidden" name="list_type" value="bed-breakfast" />
    <input type="submit" value="Search" id="btnSearch" style="color:red" />
  </form>

</td></tr><tr><th colspan='4' style='font-weight:normal'><a href='http://membership.bnb-network.ie' target='_blank'>Do you own a B&amp;B, guesthouse or hotel in Newcastle Road? 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 Newcastle Road, Galway</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 'Galway' != '' then (bnb.additional_search like '% Galway %' or bnb.additional_search like '% Galway' or bnb.additional_search like 'Galway %' or bnb.additional_search = 'Galway' or bnb.county like '%Galway%')
              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='annaghdown-bnb-directory-galway.html'>Annaghdown B&amp;B</a></li><li><a href='aran-islands-bnb-directory-galway.html'>Aran Islands B&amp;B</a></li><li><a href='ardrahan-bnb-directory-galway.html'>Ardrahan B&amp;B</a></li><li><a href='athenry-bnb-directory-galway.html'>Athenry B&amp;B</a></li><li><a href='aughrim-bnb-directory-galway.html'>Aughrim B&amp;B</a></li><li><a href='ballina-bnb-directory-galway.html'>Ballina B&amp;B</a></li><li><a href='ballinasloe-bnb-directory-galway.html'>Ballinasloe B&amp;B</a></li><li><a href='ballyconneely-bnb-directory-galway.html'>Ballyconneely B&amp;B</a></li><li><a href='barna-bnb-directory-galway.html'>Barna B&amp;B</a></li><li><a href='barna-road-bnb-directory-galway.html'>Barna Road B&amp;B</a></li><li><a href='caherlistrane-bnb-directory-galway.html'>Caherlistrane B&amp;B</a></li><li><a href='carna-bnb-directory-galway.html'>Carna B&amp;B</a></li><li><a href='carraroe-bnb-directory-galway.html'>Carraroe B&amp;B</a></li></ul><ul><li><a href='claregalway-bnb-directory-galway.html'>Claregalway B&amp;B</a></li><li><a href='clarinbridge-bnb-directory-galway.html'>Clarinbridge B&amp;B</a></li><li><a href='cleggan-bnb-directory-galway.html'>Cleggan B&amp;B</a></li><li><a href='clifden-bnb-directory-galway.html'>Clifden B&amp;B</a></li><li><a href='clonbur-bnb-directory-galway.html'>Clonbur B&amp;B</a></li><li><a href='cong-bnb-directory-galway.html'>Cong B&amp;B</a></li><li><a href='cong-bnb-directory-mayo.html'>Cong B&amp;B</a></li><li><a href='connemara-bnb-directory-galway.html'>Connemara B&amp;B</a></li><li><a href='cornamona-bnb-directory-galway.html'>Cornamona B&amp;B</a></li><li><a href='corofin-bnb-directory-galway.html'>Corofin B&amp;B</a></li><li><a href='corrandulla-bnb-directory-galway.html'>Corrandulla B&amp;B</a></li><li><a href='craughwell-bnb-directory-galway.html'>Craughwell B&amp;B</a></li><li><a href='dunmore-bnb-directory-galway.html'>Dunmore B&amp;B</a></li></ul><ul><li><a href='eyrecourt-bnb-directory-galway.html'>Eyrecourt B&amp;B</a></li><li><a href='frenchville-lane-bnb-directory-galway.html'>Frenchville Lane B&amp;B</a></li><li><a href='furbo-bnb-directory-galway.html'>Furbo B&amp;B</a></li><li><a href='galway-bnb-directory-galway.html'>Galway B&amp;B</a></li><li><a href='galway-city-bnb-directory-galway.html'>Galway City B&amp;B</a></li><li><a href='galway-city-east-bnb-directory-galway.html'>Galway City East B&amp;B</a></li><li><a href='gort-bnb-directory-galway.html'>Gort B&amp;B</a></li><li><a href='headford-bnb-directory-galway.html'>Headford B&amp;B</a></li><li><a href='headford-road-bnb-directory-galway.html'>Headford Road B&amp;B</a></li><li><a href='inis-mor-bnb-directory-galway.html'>Inis Mor B&amp;B</a></li><li><a href='inishbofin-island-bnb-directory-galway.html'>Inishbofin Island B&amp;B</a></li><li><a href='inishere-bnb-directory-galway.html'>Inishere B&amp;B</a></li><li><a href='kilkieran-bnb-directory-galway.html'>Kilkieran B&amp;B</a></li></ul><ul><li><a href='killary-bnb-directory-galway.html'>Killary B&amp;B</a></li><li><a href='kinvara-bnb-directory-galway.html'>Kinvara B&amp;B</a></li><li><a href='klifden-bnb-directory-galway.html'>Klifden B&amp;B</a></li><li><a href='leenane-bnb-directory-galway.html'>Leenane B&amp;B</a></li><li><a href='letterfrack-bnb-directory-galway.html'>Letterfrack B&amp;B</a></li><li><a href='lough-corrib-bnb-directory-galway.html'>Lough Corrib B&amp;B</a></li><li><a href='loughrea-bnb-directory-galway.html'>Loughrea B&amp;B</a></li><li><a href='lower-salthill-bnb-directory-galway.html'>Lower Salthill B&amp;B</a></li><li><a href='monivea-bnb-directory-galway.html'>Monivea B&amp;B</a></li><li><a href='moycullen-bnb-directory-galway.html'>Moycullen B&amp;B</a></li><li><a href='oranmore-bnb-directory-galway.html'>Oranmore B&amp;B</a></li><li><a href='oughterard-bnb-directory-galway.html'>Oughterard B&amp;B</a></li><li><a href='peterswell-bnb-directory-galway.html'>Peterswell B&amp;B</a></li></ul><ul><li><a href='portumna-bnb-directory-galway.html'>Portumna B&amp;B</a></li><li><a href='renmore-bnb-directory-galway.html'>Renmore B&amp;B</a></li><li><a href='renvyle-bnb-directory-galway.html'>Renvyle B&amp;B</a></li><li><a href='rosmuc-bnb-directory-galway.html'>Rosmuc B&amp;B</a></li><li><a href='roundstone-bnb-directory-galway.html'>Roundstone B&amp;B</a></li><li><a href='salthill-bnb-directory-galway.html'>Salthill B&amp;B</a></li><li><a href='spiddal-bnb-directory-galway.html'>Spiddal B&amp;B</a></li><li><a href='taylors-hill-bnb-directory-galway.html'>Taylors Hill B&amp;B</a></li><li><a href='tuam-bnb-directory-galway.html'>Tuam B&amp;B</a></li><li><a href='williamstown-bnb-directory-galway.html'>Williamstown B&amp;B</a></li><li><a href='woodquay-bnb-directory-galway.html'>Woodquay 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('Galway').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 = 'Galway';
			//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>