I am not talking about anything expensive or cheap here, but just want to point out that later you not only have to pay the additional costs and that one or the other construction site will come up. If the construction loan is still running on top of that, then all you can do is hope to have saved something.
I also think that there will be significant additional costs. Photovoltaics will certainly become mandatory in some form at some point (possibly indirectly). Heat pumps are mandatory anyway. The photovoltaic system might significantly reduce the lifespan of the roof because roof tiles are happily cut up. At some point, the bathroom or bathrooms will need renovating. And all-in, the heat pump is rather around 25-30k and not 15k.
Rental properties are also primarily a tax-saving model through depreciation. Sometimes neither the tenant nor the landlord has to pay for maintenance – mathematically, the state does that. And of course, 300 sqm of roof area over 20 apartments is cheaper per apartment than 150 sqm of roof area on a single-family house.
We also live in a house. Because it is nice. I wouldn't primarily see it as retirement provision. Something definitely still has to be added, for example, a fully paid-off house without maintenance backlog including heat pump, photovoltaics, photovoltaic battery, wallbox, etc. all newly done at retirement. And then also several hundred thousand euros in investments – then I would be relatively sure that one can still travel in old age, still go to restaurants, still take trips AND maintain the house (in old age, maybe more garden work will be outsourced).
And all this assuming that the statutory pension will still exist in 30, 40, 50 years. Do you really all trust that? That it will still exist and still at a comparable level as today plus inflation adjustment? I see that as one of the biggest points – many say the pension will no longer exist then or only as a uniform minimum pension at basic security level. Everything else must be privately provisioned for.