Cologne rents +7.9% y/y in Q2 2026: districts, pipeline, BTL math

What moved in Q2 2026

The German Economic Institute (IW) reports that Cologne’s listing rents rose 7.9% year‑on‑year in Q2 2026, the strongest jump among large cities it tracks. Nationally, IW sees around +4% y/y for listings, with big‑city pressure persisting. The Q2 release was published in July 2026 and is part of the IW‑Wohnindex series. 7.9% is for new listings, not in‑place contracts. That matters for yield modelling because re‑lettings move faster than regulated in‑tenancy increases. ([iwkoeln.de](https://www.iwkoeln.de/presse/pressemitteilungen/pekka-sagner-michael-voigtlaender-in-grossstaedten-mietangebote-seit-2022-um-bis-zu-57-prozent-eingebrochen.html?utm_source=openai))

Behind the headline, IW notes purchase prices broadly flat in Q2 2026 (+0.8% y/y for condos and for single‑/two‑family houses), which—combined with rising rents—points to a modest improvement in gross yields for new purchases. Again, this is for offer‑side data rather than notary‑recorded transactions. ([iwkoeln.de](https://www.iwkoeln.de/presse/pressemitteilungen/pekka-sagner-michael-voigtlaender-in-grossstaedten-mietangebote-seit-2022-um-bis-zu-57-prozent-eingebrochen.html?utm_source=openai))'}},{

Which districts are pulling the average up

The city’s statistical office processed 12,205 rental listings in 2025; the citywide median was €14.70/m² net cold (+5% vs. 2024). Within that, medians varied widely by Stadtteil. Neuehrenfeld, in the Ehrenfeld district, posted a €20.90/m² median in 2025 (338 listings). Cheaper medians clustered in peripheral areas such as Chorweiler. The 2026 Q2 uptick reported by IW is for the whole city; the most plausible contributors are the central and inner‑west belts (Ehrenfeld/Neuehrenfeld, Lindenthal, Neustadt), where 2025 medians were already above‑average and supply is tight. District‑level Q2 2026 change rates have not been published by the city; use the 2025 medians as directional context, not as exact Q2 baselines. ([stadt-koeln.de](https://www.stadt-koeln.de/artikel/64274/index.html))

For investors comparing microlocations: the city publishes small‑area dashboards by district that include time‑series of listing medians; they confirm structurally higher asking levels in the inner districts. Cross‑check these against building activity (see below) to avoid overpaying where near‑term completions may soften asking rents. ([stadt-koeln.de](https://www.stadt-koeln.de/artikel/74225/index.html?utm_source=openai))

What the 2026–27 new‑build pipeline looks like

Completions surged in 2025 to 4,623 flats, the highest in ten years, while permits fell to 2,323 (−20.7% vs. 2024). The backlog of permitted but unfinished flats (Bauüberhang) shrank by 24% to 7,821 as of 31 December 2025. Districts with the most 2025 completions were Rodenkirchen (1,386), Porz (602), Lindenthal (506), Ehrenfeld (449) and Mülheim (439). Where the backlog remains high—Mülheim (1,080), Ehrenfeld (1,029), Nippes (946)—you should expect further 2026–27 deliveries if projects move. These are official city statistics under the Hochbaustatistikgesetz. ([stadt-koeln.de](https://www.stadt-koeln.de/politik-und-verwaltung/presse/mitteilungen/28354/index.html?utm_source=openai))

Project signals to watch: the City Council adopted the Bebauungsplan “Deutzer Hafen – Teilplan A” in July 2026, enabling planning for the first building plots in a waterfront district forecast at roughly 3,000 flats, but first handovers will take time. GAG Immobilien flags several deliveries into H2 2026 (e.g., Gummersbacher Straße, Deutz, completion Q3 2026) and further projects across Mülheim, Stammheim and Kalk. Private schemes such as the ZOHO quarter (around 230 flats) target first occupancy in Q1 2027, with leasing slated from mid‑2026. ([stadt-koeln.de](https://www.stadt-koeln.de/artikel/65094/index.html?utm_source=openai))

Implication: 2026 completions should stay elevated as the 2022–2024 permit cohort works through the pipeline; 2027 risks a dip if the low 2025 permit base is not offset. Model absorption and lease‑up timing carefully by submarket. ([stadt-koeln.de](https://www.stadt-koeln.de/mediaasset/content/pdf15/statistik-bauen-und-wohnen/ksn_7_2026_wohnungsbau_koeln_2025.pdf))

Prices and rents to plug into a BTL model (with caveats)

For purchase price anchors, the Upper Committee of Valuers for NRW (Oberer Gutachterausschuss) reports first‑sale condo prices in middle locations in Cologne at about €6,490/m² in 2025. Listing rents published by the city show a 2025 median of €14.70/m²; IW’s Q2 2026 figure indicates a citywide +7.9% y/y for listings. Because these datasets differ (valuation of notarised sales vs. rental offers), use them as directional inputs, not as a literal pair. A practical 2026 rent input for mid‑market re‑lettings is a band informed by 2025 medians and the IW delta, then cross‑checked against current portal samples in your target microlocation. ([im.nrw](https://www.im.nrw/grundstuecksmarktbericht-nordrhein-westfalen-2026-mehr-grundstueckskaeufe-preise-ziehen-wieder-0?utm_source=openai))

Two further modelling points: (1) Transaction costs in NRW: 6.5% real estate transfer tax since 1 January 2015 (state law), plus roughly 1.3–2.0% for notary and land registry; buyer’s share of brokerage varies by deal type. (2) New‑build exemptions: the rent brake does not apply to first‑letting of new build or after comprehensive modernisation under BGB § 556f. Both materially affect achievable headline rent in year 1. ([recht.nrw.de](https://recht.nrw.de/gvnrw/2014-s954/?utm_source=openai))

Cologne’s rent rules that shape cash flow (2026–2029)

- Rent brake (Mietpreisbremse) applies citywide via NRW’s Mieterschutzverordnung. The time limit in §1(1) was extended from 31 December 2025 to 31 December 2029 by ordinance of 28 October 2025. For new leases (except §556f BGB cases), initial rent is capped at local comparable rent +10%. ([recht.nrw.de](https://recht.nrw.de/system/files/pdf/law-and-ordinance-gazette/2025/01/28/908e71/verordnung-zur-festlegung-des-anwendungsbereiches-.pdf)) - Capping rule in existing tenancies: §558 BGB limits in‑place rent increases to 20% over three years, reduced to 15% where a state ordinance defines a tight market. NRW’s MietSchVO designates Cologne accordingly; the ordinance remains in force until 28 February 2030. ([recht.nrw.de](https://recht.nrw.de/system/files/pdf/law-and-ordinance-gazette/2025/01/28/908e71/verordnung-zur-festlegung-des-anwendungsbereiches-.pdf)) - Conversion protection after condo split: the same NRW ordinance sets an eight‑year notice bar (§577a BGB reference). Factor this into exit timing if planning to sell flats out of a rental block. ([recht.nrw.de](https://recht.nrw.de/system/files/pdf/law-and-ordinance-gazette/2025/01/28/908e71/verordnung-zur-festlegung-des-anwendungsbereiches-.pdf))

How to build your 2026–27 buy‑to‑let pro forma

- Rent line: start from your microlocation’s current listings; sanity‑check against the city’s 2025 medians and the IW +7.9% Q2 2026 citywide change. Avoid importing medians from unrelated districts. For inner‑west locations like Neuehrenfeld that already show high medians, use a conservative band unless you can evidence superior spec or new‑build exemption. ([stadt-koeln.de](https://www.stadt-koeln.de/artikel/64274/index.html)) - Price line: for new build in a middle location, the OGAR NRW 2026 report puts first‑sale condos around €6,490/m² (2025 data). Cross‑check with the Cologne 2026 Grundstücksmarktbericht for your exact segment and condition. ([im.nrw](https://www.im.nrw/grundstuecksmarktbericht-nordrhein-westfalen-2026-mehr-grundstueckskaeufe-preise-ziehen-wieder-0?utm_source=openai)) - Costs: include NRW real‑estate transfer tax at 6.5%, plus notary/land registry (about 1.3–2.0% as a rule‑of‑thumb). Brokerage, refurbishment and initial vacancy should be explicit lines. ([recht.nrw.de](https://recht.nrw.de/gvnrw/2014-s954/?utm_source=openai)) - Growth: for 2027, don’t extrapolate +7.9%. District backlogs suggest uneven 2026–27 handovers (notably in Mülheim, Ehrenfeld, Nippes), which can cap asking rents locally. Model a high/low band and a stress case at flat rents. ([stadt-koeln.de](https://www.stadt-koeln.de/mediaasset/content/pdf15/statistik-bauen-und-wohnen/ksn_7_2026_wohnungsbau_koeln_2025.pdf)) - Legal guardrails: test compliance with the rent brake (or document §556f applicability), and cap any in‑tenancy uplift at 15%/3y per §558 in Cologne. Have a German counsel check your draft lease and disclosures before marketing. ([recht.nrw.de](https://recht.nrw.de/gvnrw/2025-s848/))

This note is not personalised investment, tax or legal advice. For individual structuring, engage a Steuerberater (tax), a German real‑estate lawyer, and, for valuation, a publicly appointed valuer (öffentlich bestellte/r Sachverständige/r).