<!-- 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 'Armagh' != '' THEN (replace(bnb_options.additional_search, '-', ' ') LIKE '% Armagh %' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE '% Armagh' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE 'Armagh %' 
        		OR replace(bnb_options.additional_search, '-', ' ') = 'Armagh' 
        		OR replace(bnb_options.county, '-', ' ') LIKE '%Armagh%')
          ELSE bnb_options.county != 'Best'
          END
        AND CASE WHEN 'Armagh' = '' 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 '' != '' 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(17362793) --><!-- 1 --><!-- 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-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,
        (@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 'Armagh' != '' THEN (replace(bnb_options.additional_search, '-', ' ') LIKE '% Armagh %' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE '% Armagh' 
        		OR replace(bnb_options.additional_search, '-', ' ') LIKE 'Armagh %' 
        		OR replace(bnb_options.additional_search, '-', ' ') = 'Armagh' 
        		OR replace(bnb_options.county, '-', ' ') LIKE '%Armagh%')
          ELSE bnb_options.county != 'Best'
          END
        AND CASE WHEN 'Armagh' = '' 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 '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(17362793) --><!-- 1 --><!DOCTYPE html >
<html>
<head>
<title>Directory of Bed and Breakfasts in Armagh</title>
<meta name="description" content="Armagh bed and breakfast accommodation Ireland" />
<meta name="keywords" content="Armagh,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" >Armagh 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 Armagh Directory</span></li>
<li><span> Lodging B&amp;Bs in Armagh</span></li>
<li><span>Inns Hotels in Armagh</span></li>
<li><span>Rooms in Armagh</span></li>
<li><span>All Accommodation Armagh</span></li>
</ul>
</div>
<h1>Armagh 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"> 42</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;" >
			Armagh 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' >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' selected='selected'>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"><select id='town'><option value=''>Select a City / Town...</option>
	<option value='all'>- All in Armagh -</option>
	<option value='armagh' >Armagh</option><option value='craigavon' >Craigavon</option><option value='crawfordsburn' >Crawfordsburn</option><option value='keady' >Keady</option><option value='loughgall' >Loughgall</option><option value='lurgan' >Lurgan</option><option value='magheralin' >Magheralin</option><option value='mountnorris' >Mountnorris</option><option value='portadown' >Portadown</option><option value='south-armagh' >South Armagh</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'><form method='post' action='/armagh-bed-breakfast.html'><input type='hidden' name='page' value='2' /><input type='hidden' name='count' value='15' /><input type='hidden' name='town' value='' /><input type='hidden' name='county' value='Armagh' /><input type='hidden' name='country' value='Ireland' /><input type='hidden' name='arrival' value='' /><input type='hidden' name='departure' value='' /><input type='hidden' name='seed' value='17362793' /><span class='button' onclick='this.parentNode.submit();'><input type='image' src='http://www.ireland-bnb.com/graphics/next-page.gif' class='submitimage ' width='86' height='15' style='float:right' title='Click to view the next page' alt='Next Page' /></span></form></td></tr></table><table></table>
<br />
<table>
<tr><th colspan='4' class='otherbnbs'>Other Armagh, 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=36435">
	    <b>Orchard House, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Orchard House"  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=19833">
	    <b>Fairylands Country House, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Fairylands Country House"  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=36439">
	    <b>De Averell House, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact De Averell House"  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=3406">
	    <b>Dundrum House, </b><br />
	    Keady,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Dundrum House"  style="float:right" />
    </a>
  </td>
<!--</tr>--></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=19835">
	    <b>Montagu Arms, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Montagu Arms"  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=36436">
	    <b>Desart, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Desart"  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=36438">
	    <b>Mountnorris House, </b><br />
	    Mountnorris,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Mountnorris House"  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=17915">
	    <b>Ivanhoe, </b><br />
	    Craigavon,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Ivanhoe"  style="float:right" />
    </a>
  </td>
<!--</tr>--></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=36954">
	    <b>Carngrove Hotel, </b><br />
	    Craigavon,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Carngrove Hotel"  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=36875">
	    <b>Armagh City Youth Hostel, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Armagh City Youth Hostel"  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=19842">
	    <b>Cottage Country House, </b><br />
	    Portadown,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Cottage Country House"  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=19836">
	    <b>Ballycanal Manor, </b><br />
	    Craigavon,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Ballycanal Manor"  style="float:right" />
    </a>
  </td>
<!--</tr>--></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=30103">
	    <b>Flatfield House, </b><br />
	    Craigavon,<br />
	    Armagh ,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Flatfield House"  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=17415">
	    <b>Charlemont Arms, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Charlemont Arms"  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=1483">
	    <b>Hillview Lodge, </b><br />
	    Armagh,<br />
	    Armagh,<br />
	    Northern Ireland<br/>
      <img src="http://ireland-bnb.com/graphics/room-enq.png" alt="Contact Hillview Lodge"  style="float:right" />
    </a>
  </td>
<!--</tr>--><td>&nbsp;</td></tr></table>			<br style="clear:both" />
		</div>
		
		<div id="linksfooter"><!-- large links footer -->
			<h6>Bed &amp; Breakfast Accommodation in Armagh</h6><br>
			<ul>
				<li><a href='armagh-bnb-directory-armagh.html'>Armagh B&amp;B</a></li><li><a href='craigavon-bnb-directory-armagh.html'>Craigavon B&amp;B</a></li></ul><ul><li><a href='crawfordsburn-bnb-directory-armagh.html'>Crawfordsburn B&amp;B</a></li><li><a href='keady-bnb-directory-armagh.html'>Keady B&amp;B</a></li></ul><ul><li><a href='loughgall-bnb-directory-armagh.html'>Loughgall B&amp;B</a></li><li><a href='lurgan-bnb-directory-armagh.html'>Lurgan B&amp;B</a></li></ul><ul><li><a href='magheralin-bnb-directory-armagh.html'>Magheralin B&amp;B</a></li><li><a href='mountnorris-bnb-directory-armagh.html'>Mountnorris B&amp;B</a></li></ul><ul><li><a href='portadown-bnb-directory-armagh.html'>Portadown B&amp;B</a></li><li><a href='south-armagh-bnb-directory-armagh.html'>South Armagh B&amp;B</a></li></ul>			</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('Armagh').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 = 'Armagh';
			//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>