Finding Houses by ZIP Code and House Number

2026-04-11

When searching for houses in Germany, most listings only include the ZIP code (Postleitzahl) and not the full address. This is intentional. Sellers and agents want you to contact them before you know exactly where the property is. But sometimes one of the listing photos shows a house number on the door or mailbox. If we can spot that, we have two pieces of information: the ZIP code and the house number. That's enough to narrow things down significantly. I'll show you how.

Overpass Turbo

Overpass Turbo is a web tool for querying OpenStreetMap data. You can ask it things like "show me all buildings with house number 84 in ZIP code 14480" and it will highlight the matches on a map.

Here's the query:

[out:json][timeout:250];

{{postal_code="14480"}}
{{house_number="84"}}

area["postal_code"={{postal_code}}]->.searchArea;

(
  node["addr:housenumber"={{house_number}}](area.searchArea);
  way["addr:housenumber"={{house_number}}](area.searchArea);
  relation["addr:housenumber"={{house_number}}](area.searchArea);
);
out body;
>;
out skel qt;

Replace the ZIP code and house number with your values and hit "Run". Overpass Turbo will show you all matching houses as circles on the map right-handed map:

Screenshot of Overpass Turbo query results showing buildings with house number 84 in ZIP code 14480

From there you can switch to satellite view in Google or Apple Maps and compare the building shape, roof color, or garden layout with the listing photos. It usually takes less than a minute to confirm which one it is.