GUTHMANN® Berlin Real Estate

Returns all 12 Berlin boroughs (Bezirke) with IDs and names. Key response fields: array of { bezirk_id, bezirk_name } - bezirk_id: 2 digits ("01" to "12") - bezirk_name: e.g. "Mitte", "Friedrichshain-Kreuzberg", "Pankow" Use when: - You need an overview of Berlin's administrative structure - You need a bezirk_id for market data queries Do NOT use when: - You already know the bezirk_id → use b

Returns details for one Berlin borough (Bezirk) by ID, optionally with all its districts. Parameters: - bezirk_id (required): 2-digit ID ("01" to "12") - ortsteile: "true" to include all districts of the borough Key response fields: { bezirk_id, bezirk_name, ortsteile?: [...] } (ortsteile = districts) Example: bezirk_id="03" → Pankow with 13 districts (Prenzlauer Berg, Weißensee, etc.)

Returns all 97 Berlin districts (Ortsteile), optionally filtered by borough. Parameters: - bezirk_id (optional): filter to the districts of one borough - bezirke: "true" to include borough references Key response fields: array of { ortsteil_id, ortsteil_name, bezirk_id?, bezirk_name? } - ortsteil_id: 4 digits (e.g. "0301" for Prenzlauer Berg) Examples of well-known districts: - Prenzlauer Berg

Returns details for one Berlin district (Ortsteil) by ID, optionally with its neighborhoods. Parameters: - ortsteil_id (required): 4-digit ID (e.g. "0301") - planungsraeume: "true" to include all neighborhoods of the district Key response fields: { ortsteil_id, ortsteil_name, bezirk_id, bezirk_name, planungsraeume?: [...] } (planungsraeume = neighborhoods)

Returns all 542 Berlin neighborhoods (LOR Planungsräume), optionally filtered by borough or district. Parameters: - bezirk_id (optional): filter by borough - ortsteil_id (optional): filter by district - bezirke/ortsteile: "true" to include parent references Key response fields: array of { planungsraum_id, planungsraum_name, ... } - planungsraum_id: 8 digits (e.g. "03010101") Neighborhoods are

Searches Berlin neighborhoods (LOR Planungsräume) by name. Parameters: - q (required): search term (min. 3 characters) - limit: max. results (default: 25) - bezirk_id/ortsteil_id: optional filters to narrow the search Example: q="Kollwitz" finds the "Kollwitzplatz" neighborhood

Returns details for one Berlin neighborhood (LOR Planungsraum) by ID, optionally with its blocks. Parameters: - planungsraum_id (required): 8-digit ID - bloecke: "true" to include all blocks of the neighborhood Key response fields: { planungsraum_id, planungsraum_name, bezirk_id, bezirk_name, ortsteil_id, ortsteil_name, bloecke?: [...] } (bloecke = blocks)

Berlin social conservation areas (Milieuschutzgebiete, §172 BauGB). 124 areas in 6 categories with polygon geometry. Parameters: - kategorie_id: filter by category ("erhaltungsgebiet" | "erweiterung" | "aufstellungsbeschluss" | "untersuchungsgebiet" | "beobachtungsgebiet" | "aufgehoben") - erweiterungen: "true" to embed extensions as a nested array inside their main area - include: comma-separat

Returns a single Berlin social conservation area (Milieuschutzgebiet) by ID. For main areas, associated extensions are embedded automatically. Parameters: - id (required): 12-character hex string (deterministic area ID) - include: comma-separated geo attributes; available: "centroid". Polygons are provided as GeoJSON URLs in geometry_urls Key response fields: { id, name, kategorie_id, kategorie_

Berlin apartment market data (listings + transactions). Sources: listing/offer data (IMV) + transaction data from the Berlin committee of valuation experts (GAA, Gutachterausschuss). Parameters: - zeitraum: "jahr" (default) | "monat" | "quartal" (abgeschlossene Quartale) - jahr: transaction data (GAA) + listing data (IMV), finest level: block - monat: listing data (IMV) only, finest level: Di

Berlin apartment building market (rental buildings, "Zinshäuser") - transaction data. Source: transaction data from the Berlin committee of valuation experts (GAA, Gutachterausschuss). Parameters: - rbs: "stadt" | "bezirk" | "stadtteil" | "ortsteil" — bezirk = Borough, ortsteil = District Time filters: - start/end: flexible date values (YYYY, YYYY-MM, YYYY-MM-DD) - recent: number of most rece

National market data for the German residential real estate market. Sources: DESTATIS, vdp, HYPOPORT. Includes price AND transaction indices for various market segments. Parameters: - zeitraum: "jahr" (default) | "quartal" - jahr: all price and transaction indices, regional and per source - quartal: only the Germany-wide price indices of DESTATIS, vdp and HYPOPORT, current up to the second-t

National price index data for the German apartment building market. Source: vdp. Quarterly data for apartment buildings (rental buildings, "Mehrfamilienhäuser") across Germany. Time filters: - start/end: flexible date values (YYYY, YYYY-MM, YYYY-MM-DD) - recent: number of most recent periods (quarters) Response controls: - limit, fields, include: "metadata" Key response fields: - preisindex:

The GUTHMANN listings: the broker's active inventory in Berlin (for sale: owner-occupier apartments, investment apartments, apartment buildings, commercial). Every card carries its exposé URL on guthmann.estate. Addresses only for released listings, otherwise ZIP/District (Ortsteil)/Borough (Bezirk). Parameters: - segment: "APARTMENT_LIVING" | "APARTMENT_INVEST" | "APARTMENT_BUILDING" | "COMMERC

One GUTHMANN listing in detail: prices and running costs, areas, amenities, energy certificate, exposé texts, images, contact and the exposé URL on guthmann.estate. When the address is not released, street/house number are null and the coordinate is deterministically offset by 150-300 m (koordinaten_versetzt = true). Parameters: - public_id: public listing id (hex, from listings or the exposé

ECB key interest rates. Source: Bundesbank. Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods - limit, fields, include: "metadata" Key response fields (German names): - zinssatz_hauptrefinanzierungssatz: main refinancing rate (the ECB's key rate) - zinssatz_einlagefazilitaet: deposit facility rate - zinssatz_spitzenrefinanzierungsfazilitaet: marginal lending facility ra

Mortgage rates for residential housing loans. Source: Bundesbank. Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods - limit, fields, include: "metadata" Key response fields (German names): - zinssatz_gesamt: average rate across all fixed-interest periods - zinssatz_5_bis_10j: rate for 5-10 year fixed-interest periods - zinssatz_ueber_10j: rate for fixed-interest periods

Yields on German government bonds (Bunds). Source: Bundesbank. Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods - limit, fields, include: "metadata" Key response fields (German names): - rendite_10j: 10-year Bund yield - rendite_15j: 15-year Bund yield - rendite_30j: 30-year Bund yield

Unemployment statistics. Source: Bundesbank. Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods Key response fields (German names): - arbeitslose: registered unemployed (seasonally adjusted) - arbeitslosenquote: unemployment rate (%)

Employment statistics. Source: Bundesbank. Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods Key response fields (German names): - erwerbstaetige: persons in employment (seasonally adjusted) - sv_beschaeftigte: employees subject to social insurance contributions - geringfuegig_beschaeftigte: marginally employed (mini-jobs)

Short-time work (Kurzarbeit) statistics. Source: Bundesbank. Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods Key response fields (German names): - kurzarbeiter: short-time workers (seasonally adjusted)

Inflation data (HICP - harmonized index of consumer prices). Source: Bundesbank. Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods Key response fields (German names): - hvpi_gesamt: overall HICP - hvpi_gesamt_ohne_energie_nahrungsmittel: core inflation (HICP excluding energy and food) - hvpi_energie, hvpi_nahrungsmittel, hvpi_dienstleistungen, hvpi_mieten: energy, food,

Construction price index for residential buildings. Source: Bundesbank. Quarterly data (2015=100). Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods Key response fields (German names): - preisindex: construction price index - preisindex_delta_1q: change vs. previous quarter - preisindex_delta_1j: change vs. previous year

GDP data (gross domestic product). Source: Bundesbank. Quarterly data, price-adjusted, seasonally and calendar-adjusted (2015=100). Parameters: - start/end: YYYY-MM-DD - recent: number of most recent periods Key response fields (German names): - kettenindex: GDP chain-linked index - kettenindex_delta_1q: change vs. previous quarter - kettenindex_delta_1j: change vs. previous year

Returns field definitions for interpreting API responses. Use this to understand fields, units, data types, and sources. Parameters: - domain (optional): specific domain for detailed field information - locale: "de" (default) | "en" Available domains: - berlin: geographic reference data — Boroughs (Bezirke), Districts (Ortsteile), Neighborhoods (LOR Planungsräume) - immobilienmarkt.berlin.wo

Construction activity data for Berlin. Source: Amt für Statistik Berlin-Brandenburg. Shows net changes: building balance, dwelling balance, living-space balance. Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum) - bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters - start/end: per

External migration for Berlin: migration across the city boundary, annual, by nationality. Source: Amt für Statistik Berlin-Brandenburg. Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum) - bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters - staat_code: filter by country code (e.g.

Migration matrix for Berlin: migration flows between areas (moves within Berlin, annual). The RBS level applies to both origin and destination. Source: Amt für Statistik Berlin-Brandenburg. Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum) (default: bezirk) - von_rbs_id: filter by origin-area ID - nach_r

Population stock for Berlin (headline figures) at the Neighborhood level (LOR Planungsraum), semi-annual. Source: Amt für Statistik Berlin-Brandenburg. Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood) - bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters - start/end, recent, limit, fields, include:

Berlin population by 8 age groups, additionally by population group. Source: Amt für Statistik Berlin-Brandenburg. Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum) - bevoelkerungsgruppe: "alle" (all) | "mit_migrationshintergrund" (with migration background) (optional) - altersgruppe: age group, e.g. "al

Berlin population with a migration background, by area of origin. Source: Amt für Statistik Berlin-Brandenburg. ⚠️ herkunft_ebene: "eu_gesamt" is the aggregate over the individual "eu_land" entries. The default (drittland,eu_gesamt,nicht_zuordenbar) prevents double-counting EU countries. Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungs

Zensus 2022 dwelling stock data for Berlin. Source: Statistisches Bundesamt, Zensus 2022. Without a category: total number of dwellings. With a category: - raeume: breakdown by number of rooms - flaeche: breakdown by floor-area cluster (under 40 m², 40-59 m², etc.) - nutzung: breakdown by type of use (owner-occupied, rented, vacant) Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "sta

Zensus 2022 dwelling vacancy data for Berlin. Source: Statistisches Bundesamt, Zensus 2022. Breakdown by vacancy category (duration or reason). Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum) - kategorie: "dauer" (duration) | "grund" (reason) (optional) - bezirk_id, stadtteil_id, ortsteil_id, planungsr

Zensus 2022 rent data for Berlin. Source: Statistisches Bundesamt, Zensus 2022. Without a category: weighted average across all dwellings (net cold rent, net cold rent per m², count). With category "flaeche": rent per m² by floor-area cluster. Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum) - kategor

Zensus 2022 building data for Berlin. Source: Statistisches Bundesamt, Zensus 2022. Without a category: total number of buildings. With a category: - bauweise: construction type (detached, row house, semi-detached) - eigentumsform: ownership type (private individual, cooperative, municipality) - heizungsart: heating type (central heating, per-floor heating, individual stoves) - energietraeger: en

Zensus 2022 household data for Berlin. Source: Statistisches Bundesamt, Zensus 2022. Without a category: total number of households. With a category: - groesse: household size (1 person, 2 persons, etc.) - wohndauer: length of residence (under 1 year, 1-5 years, etc.) Parameters: - rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR

Semantic search over guthmann.estate — market insights, reports, neighborhood portraits, listing exposés, project pages and the company's own pages. Hybrid retrieval (vector + keyword, no reranking); one result per page with title, description, image, best-matching snippet and score. Use it for questions that need prose (analysis, context, advice); use the data tools for exact numbers and `list