This page shows accommodation in Niedersachsen that offer guests bed and breakfast.
TIPS & HINTS:
• Click entries with a thumbnail photo to go directly to their website.
• To send an enquiry to any establishment click the email icon.
• Click
Show Towns for a list of Towns / Cities in Niedersachsen
Towns in Niedersachsen
Unknown MySQL server host 'insigaa2.memset.net' (1)
[select
case when bnb.town = languages.town or languages.town is NULL or languages.town = '' then bnb.town
else languages.town
end as town,
case when bnb.county = languages.county or languages.county is NULL or languages.county = '' then bnb.county
else languages.county
end as county,
case when bnb.country = languages.country or languages.country is NULL or languages.country = '' then bnb.country
else languages.country
end as country
from bnb
left outer join languages on bnb.bnb_id = languages.bnb_ref
left join options on bnb.bnb_id = options.bnb_ref
where
options.active = 'true'
and case when 'Niedersachsen' != '' then (bnb.additional_search like '% Niedersachsen %' or bnb.additional_search like '% Niedersachsen' or bnb.additional_search like 'Niedersachsen %' or bnb.additional_search = 'Niedersachsen' or bnb.county = 'Niedersachsen' or languages.county = 'Niedersachsen')
else bnb.county != 'Best'
end
and case when 'Germany' != '' then (bnb.country = 'Germany' or languages.country = 'Germany' or bnb.additional_search like '%Germany%')
else bnb.country != ''
end
group by town, county
order by country, county, town]
Accommodation in Krummhorn Greetsiel
Unknown MySQL server host 'insigaa2.memset.net' (1)
[select bnb.*, options.*,
case when languages.description != '' then languages.description else ' ' end as description,
case when bnb.town = languages.town or languages.town is NULL or languages.town = '' then bnb.town
else languages.town
end as town,
case when bnb.county = languages.county or languages.county is NULL or languages.county = '' then bnb.county
else languages.county
end as county,
case when bnb.email != '' then bnb.email
else ' '
end as email,
case when bnb.tel != '' then bnb.tel
else ' '
end as tel,
case when member_type != 'associate' and member_type != 'non' then concat('http://www.', url)
when member_type = 'associate' then concat('http://www.bnb-network.de/unterkunft/', replace(replace(replace(lower(bnb.county), '&', 'and'), '-', '_'), ' ', '-'), '/', replace(replace(replace(lower(bnb.town), '&', 'and'), '-', '_'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html')
else ''
end as url
from bnb
left outer join languages on bnb.bnb_id = languages.bnb_ref
left join options on bnb.bnb_id = options.bnb_ref
where case when 'Germany' != '' then (bnb.country = 'Germany' or languages.country = 'Germany' or bnb.additional_search like '%Germany%')
else bnb.country != 'Best'
end
and case when 'Niedersachsen' != '' then (bnb.additional_search like '% Niedersachsen %' or bnb.additional_search like '% Niedersachsen' or bnb.additional_search like 'Niedersachsen %' or bnb.additional_search = 'Niedersachsen' or bnb.county = 'Niedersachsen' or languages.county = 'Niedersachsen')
else bnb.county != 'Best'
end
and case when 'Krummhorn Greetsiel' != '' then (bnb.town = 'Krummhorn Greetsiel' or languages.town = 'Krummhorn Greetsiel' or bnb.additional_search like '%Krummhorn Greetsiel%')
else bnb.town != 'Best'
end
and options.bnb_ref = bnb.bnb_id
and options.active = 'true'
order by dir_order desc
]Unknown MySQL server host 'insigaa2.memset.net' (1)
[select bnb.*, options.*,
case when languages.description != '' then languages.description else ' ' end as description,
case when bnb.town = languages.town or languages.town is NULL or languages.town = '' then bnb.town
else languages.town
end as town,
case when bnb.county = languages.county or languages.county is NULL or languages.county = '' then bnb.county
else languages.county
end as county,
case when bnb.email != '' then bnb.email
else ' '
end as email,
case when bnb.tel != '' then bnb.tel
else ' '
end as tel,
case when member_type != 'associate' and member_type != 'non' then concat('http://www.', url)
when member_type = 'associate' then concat('http://www.bnb-network.de/unterkunft/', replace(replace(replace(lower(bnb.county), '&', 'and'), '-', '_'), ' ', '-'), '/', replace(replace(replace(lower(bnb.town), '&', 'and'), '-', '_'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html')
else ''
end as url
from bnb
left outer join languages on bnb.bnb_id = languages.bnb_ref
left join options on bnb.bnb_id = options.bnb_ref
where case when 'Germany' != '' then (bnb.country = 'Germany' or languages.country = 'Germany' or bnb.additional_search like '%Germany%')
else bnb.country != 'Best'
end
and case when 'Niedersachsen' != '' then (bnb.additional_search like '% Niedersachsen %' or bnb.additional_search like '% Niedersachsen' or bnb.additional_search like 'Niedersachsen %' or bnb.additional_search = 'Niedersachsen' or bnb.county = 'Niedersachsen' or languages.county = 'Niedersachsen')
else bnb.county != 'Best'
end
and case when 'Krummhorn Greetsiel' != '' then (bnb.town = 'Krummhorn Greetsiel' or languages.town = 'Krummhorn Greetsiel' or bnb.additional_search like '%Krummhorn Greetsiel%')
else bnb.town != 'Best'
end
and options.bnb_ref = bnb.bnb_id
and options.active = 'true'
order by dir_order desc
]
When searching Google use: Krummhorn Greetsiel B&Bs Niedersachsen Hotels Family Homes Guesthouses hostels Travel Lodges Inns Pubs