Unknown MySQL server host 'insigaa2.memset.net' (1)<br />[select bnb.*, options.*,
        (@url := if(url != '', concat('http://www.', url), concat('http://www.bnb-network.com/bed-breakfast/', replace(replace(lower(county), '&', 'and'), ' ', '-'), '/', replace(replace(lower(town), '&', 'and'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html'))) is not null,
        (@page := if((member_type = 'guesthouse' or member_type = 'premium+'), 'rates.html',
          if(member_type = 'premium' , 'offers.html', ''))) is not null,
        case when locate('?', url) > 0 then concat(substring_index(@url, '?', 1), @page, '?bnb_id=', bnb_id)
          else concat(@url, '/', @page)
          end as url
      from bnb, options
      where case when 'Northern Ireland' = 'Ireland' then bnb.country like '%Ireland'
        else (bnb.country = 'Northern Ireland' or bnb.additional_search like '%Northern Ireland')
        end
        and case when 'Tyrone' != '' then (bnb.additional_search like '% Tyrone %' or bnb.additional_search like '% Tyrone' or bnb.additional_search like 'Tyrone %' or bnb.additional_search = 'Tyrone' or bnb.county = 'Tyrone')
          else bnb.county != 'Best'
          end
        and case when '' != '' then bnb.town = ''
          else bnb.town != 'Best'
          end
        and options.bnb_ref = bnb.bnb_id
        and options.active = 'true'
        and case when 'valuebreaks' = 'valuebreaks' and '' = '' then options.member_type != 'non' and options.special_offers = 'true'
          else options.member_type = 'guesthouse' or options.member_type = 'prem+'
          end
        and exists (
          select heading
            from offers
            where ((never = 'false' and current_date between `from` and `to`)
              or (never = 'true' and current_date > `from`))
            and active = 'true'
            and current_rate = 'false'
            and yearly_rate = 'false'
            and lastminute = 'false'
            and telegraph = 'false'
            and offers.bnb_ref = bnb.bnb_id
        )]Unknown MySQL server host 'insigaa2.memset.net' (1)<br />[select bnb.*, options.*,
        (@url := if(url != '', concat('http://www.', url), concat('http://www.bnb-network.com/bed-breakfast/', replace(replace(lower(county), '&', 'and'), ' ', '-'), '/', replace(replace(lower(town), '&', 'and'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html'))) is not null,
        (@page := if((member_type = 'guesthouse' or member_type = 'premium+'), 'rates.html',
          if(member_type = 'premium' , 'offers.html', ''))) is not null,
        case when locate('?', url) > 0 then concat(substring_index(@url, '?', 1), @page, '?bnb_id=', bnb_id)
          else concat(@url, '/', @page)
          end as url
      from bnb, options
      where case when 'Northern Ireland' = 'Ireland' then bnb.country like '%Ireland'
        else (bnb.country = 'Northern Ireland' or bnb.additional_search like '%Northern Ireland')
        end
        and case when 'Tyrone' != '' then (bnb.additional_search like '% Tyrone %' or bnb.additional_search like '% Tyrone' or bnb.additional_search like 'Tyrone %' or bnb.additional_search = 'Tyrone' or bnb.county = 'Tyrone')
          else bnb.county != 'Best'
          end
        and case when '' != '' then bnb.town = ''
          else bnb.town != 'Best'
          end
        and options.bnb_ref = bnb.bnb_id
        and options.active = 'true'
        and case when 'valuebreaks' = 'valuebreaks' and '' = '' then options.member_type != 'non' and options.special_offers = 'true'
          else options.member_type = 'guesthouse' or options.member_type = 'prem+'
          end
        and exists (
          select heading
            from offers
            where ((never = 'false' and current_date between `from` and `to`)
              or (never = 'true' and current_date > `from`))
            and active = 'true'
            and current_rate = 'false'
            and yearly_rate = 'false'
            and lastminute = 'false'
            and telegraph = 'false'
            and offers.bnb_ref = bnb.bnb_id
        )]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Tyrone Value Breaks B&amp;B</title>
<meta name="description" content="Value breaks in ,Tyrone, Northern Ireland" />
<meta name="keywords" content="value,breaks,offers,bed,breakfast,,b&amp;b,Tyrone" />
<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/ni.css" type="text/css" />
<link rel="stylesheet" href="style/list.css" type="text/css" />
<link rel="stylesheet" href="style/tabs.css" type="text/css" />
</head>
<body>
<div class="wrapper">
<div class="top"><div class="top-bullets">

<b style="color:#FFFF00;font-size:14px">&bull;&nbsp;&nbsp;</b>Northern Ireland<br />
<b style="color:#FFFF00;font-size:14px">&bull;&nbsp;&nbsp;</b>B&amp;B in Family Homes<br />
<b style="color:#FFFF00;font-size:14px">&bull;&nbsp;&nbsp;</b>Hotel Accommodation<br />
<b style="color:#FFFF00;font-size:14px">&bull;&nbsp;&nbsp;</b>Ireland Car Rental<br />
<b style="color:#FFFF00;font-size:14px">&bull;&nbsp;&nbsp;</b>Guesthouses<br />
<b style="color:#FFFF00;font-size:14px">&bull;&nbsp;&nbsp;</b>Belfast &amp; Londonderry<br />
<b style="color:#FFFF00;font-size:14px">&bull;&nbsp;&nbsp;</b>Last Minute Deals

</div>


<div id="pagetitle"><h1>Visitors Guide to Northern Ireland</h1></div>  </div>
<div id="menu">
<ul>
<li><a href="http://www.ireland-bnb.net">Ireland Accommodation</a></li>
<li><a href="premium-accommodation.html" target="_self">Premium Selection</a></li>
<li><a href="northern-ireland-bed-breakfast.html" target="_self">Bed &amp; Breakfast</a></li>
<li><a href="http://www.ireland-car-rental.com" target="_blank">Ireland Car Rental</a></li>
<li><a href="http://www.bnb-network.com">B&amp;B Network</a></li>
<li><a href="http://membership.bnb-network.ie">Membership</a></li>
</ul>
</div><div class="main">
<!-- SIDE MENU -->
<div class="smenu">Unknown MySQL server host 'insigaa2.memset.net' (1)<br />[select town, county, country
        from bnb, options
        where case when 'Northern Ireland' != '' then (country = 'Northern Ireland' or additional_search like '%Northern Ireland%')
            else country != ''
            end
          and case when 'Tyrone' != '' then (bnb.additional_search like '% Tyrone %' or bnb.additional_search like '% Tyrone' or bnb.additional_search like 'Tyrone %' or bnb.additional_search = 'Tyrone' or bnb.county = 'Tyrone')
            else bnb.county != 'Best'
            end
          and options.bnb_ref = bnb.bnb_id
          and options.active = 'true'
          and options.special_offers = 'true'
          and exists (
            select heading
            from offers
            where ((never = 'false' and current_date between `from` and `to`)
              or (never = 'true' and current_date > `from`))
            and active = 'true'
            and current_rate = 'false'
            and lastminute = 'false'
            and yearly_rate = 'false'
            and telegraph = 'false'
            and price > 0
            and offers.bnb_ref = bnb.bnb_id
          )
        group by town
        order by town]<!--  -->Unknown MySQL server host 'insigaa2.memset.net' (1)<br />[select town, county, country from bnb, options
          where active = 'true'
            and bnb_id = bnb_ref
            and case when 'Tyrone' != '' then (bnb.additional_search like '% Tyrone %' or bnb.additional_search like '% Tyrone' or bnb.additional_search like 'Tyrone %' or bnb.additional_search = 'Tyrone' or bnb.county = 'Tyrone')
              else county != 'Best'
              end
            and case when 'Northern Ireland' != '' then (country = 'Northern Ireland' or additional_search like '%Northern Ireland%')
              else country != ''
              end
            and case when 'bed-breakfast' = 'hotels' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
              when 'bed-breakfast' = 'bed-breakfast' then options.member_type != 'non' and options.member_type != 'nad'
              when 'bed-breakfast' = 'accommodation' then options.member_type != ''
              when 'bed-breakfast' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
              when 'bed-breakfast' = 'hostels-accommodation' then bnb.type = 'hostel'
              when 'bed-breakfast' = 'premium' then bnb.type like '%hotel%' and options.member_type != 'non'
              when 'bed-breakfast' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
              when 'bed-breakfast' != '' then options.member_type = 'bed-breakfast'
              else options.member_type != ''
              end
          group by town
          order by town]<!-- select town, county, country from bnb, options
          where active = 'true'
            and bnb_id = bnb_ref
            and case when 'Tyrone' != '' then (bnb.additional_search like '% Tyrone %' or bnb.additional_search like '% Tyrone' or bnb.additional_search like 'Tyrone %' or bnb.additional_search = 'Tyrone' or bnb.county = 'Tyrone')
              else county != 'Best'
              end
            and case when 'Northern Ireland' != '' then (country = 'Northern Ireland' or additional_search like '%Northern Ireland%')
              else country != ''
              end
            and case when 'bed-breakfast' = 'hotels' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
              when 'bed-breakfast' = 'bed-breakfast' then options.member_type != 'non' and options.member_type != 'nad'
              when 'bed-breakfast' = 'accommodation' then options.member_type != ''
              when 'bed-breakfast' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
              when 'bed-breakfast' = 'hostels-accommodation' then bnb.type = 'hostel'
              when 'bed-breakfast' = 'premium' then bnb.type like '%hotel%' and options.member_type != 'non'
              when 'bed-breakfast' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
              when 'bed-breakfast' != '' then options.member_type = 'bed-breakfast'
              else options.member_type != ''
              end
          group by town
          order by town --><b>B&amp;B Network</b><br>&bull; &nbsp;<a href='/' class='smenu' target='_self' >Home Page</a><br>&bull; &nbsp;<a href='http://www.ireland-bnb.co.uk/outside.html?url=http://membership.bnb-network.com/?startpage=add-bnb.html' class='smenu' target='_self' >Add Your B&amp;B</a><br>&bull; &nbsp;<a href='/premium-accommodation.html' class='smenu' target='_self' >Premium Selection</a><br>&bull; &nbsp;<a href='/northern-ireland-hostels.html' class='smenu' target='_self' >Hostels</a><br></div>


<!-- BUTTON ADVERTS -->
<div class="adverts">
<center><b class="adverts">ADVERTISING</b><br /><br />
<iframe name="butads" src="page.includes/button-ads4.html" width="120" height="480" align="top" frameborder="0" marginwidth="0" marginheight="0" scrolling="no"></iframe></center></div>

<!-- MAIN CONTENT -->

<div align="center" style="text-decoration: none"><img src="graphics/iaoialetmrf.png" width="468" height="38" alt=""><br>
<!--/* Insight Web Advertising iFrame Tag v2.4.2 */-->

<iframe id='ab5088dd' name='ab5088dd' src='http://www.insight-intermark.com/olad/www/delivery/afr.php?n=ab5088dd&amp;zoneid=5&amp;target=_blank' framespacing='0' frameborder='no' scrolling='no' width='468' height='60'><a href='http://www.insight-intermark.com/olad/www/delivery/ck.php?n=a2ebecde&amp;cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://www.insight-intermark.com/olad/www/delivery/avw.php?zoneid=5&amp;n=a2ebecde' border='0' alt='' /></a></iframe>
<script type='text/javascript' src='http://www.insight-intermark.com/olad/www/delivery/ag.php'></script>

</div><br>

<h2>Tyrone Value Breaks</h2>

<div id="propertyList">
<div class='breadcrumbs'>You are viewing <i>Value Breaks</i> in: <a href='tyrone-valuebreaks.html'>Tyrone</a></div><br />
<ul class="tab"><li class='tab' ><a href='tyrone-bed-breakfast.html' class='tab'><i></i>Bed &amp; Breakfast</a></li><li class='tab' ><a href='tyrone-lastminute.html' class='tab'><i></i><b style='color:red' >&bull;</b>&nbsp;&nbsp;Last Minute&nbsp;</a></li><li class='tab' id='selected'><a href='tyrone-valuebreaks.html' class='tab'><i></i>Value Breaks</a></li><li class='tab' ><a href='tyrone-accommodation.html' class='tab'><i></i>All Accommodation</a></li></ul>
<table id='caption'><tr><td class='caption'>Properties 0 of </td><td width='86' class='captionbtn'></td><td width='86' class='captionbtn'></td></tr></table><table><tr><td style='border-width:1px 0'>Sorry, there are no Value Breaks in Tyrone available today - please try again soon<br />or visit <a href='http://www.reddotdeals.com'>Red Dot Deals</a></td></tr></table></div>

<br clear="all" /><div id="footer">Copyright &copy; 2012 <a href="http://www.insight-web-marketing.com" target="_blank">Insight Web Marketing Ltd</a> - Killarney</div></div>
</div>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-393059-17");
pageTracker._trackPageview();
} catch(err) {}</script></body>
</html>