Ground lease building plot experiences?

What does about 40 years mean? The heritable building right must be interest-only 10 years before expiration, as far as I know. Do you have a corresponding financing plan that achieves this? And do you have a lot of equity to keep the loan-to-value of the short heritable building right as low as possible? Otherwise, you will have to enter renegotiations anyway & start at today’s conditions. And even then, there are requirements on the maximum possible loan-to-value; I know a max of 80%. Talk to the church about the details – they will surely also present a corresponding offer for a new contract. In my opinion, the remaining term is too short for your project. If it were still 60 years, that would be something else. Who would pay you a lot for a not really renovated house in 20 years? The land is gone, and without a core renovation the house is then worth nothing at book value.

If the price level continues to develop like this, then the house will sell just as well in 20 years as it does today (right now it is also in a "well, so-so" condition)

You don’t even know yet whether the seller will get the desired price. Around here in the Düsseldorf area, the only houses that stay on the market longer are those with leasehold and price expectations similar to houses with land. But they rarely seem to get those prices. If a house here is on the market for more than a month, it’s a slow seller. And I bet that in the end, they all had to significantly reduce the price.

You must have good reasons why you still want to stick to the 5km radius search. But depending on the structure, expanding to 10 or 15 km can greatly increase the options.

I'll use this thread for a "similar" question:

We are currently interested in a single-family house (desired location) but leasehold (church approx. 180 euros p.m. - about 40 years remaining). We are torn... since we've been looking for a while, many ideas come up :)
We are attracted to the location, but the house was built in the late 60s, worn down (everything is at that standard, but solid construction) - costs about 500K

Now to the consideration:
Deliberately sell again after about 20 years, keep the monthly burden low and only renovate/modernize the essentials approx. 100-120K (if you wanted to bring everything up to the current standard approx. 180-200K - that wouldn't be worth it overall to us)

Nonsense or realistic?

We definitely do not want to buy the house "come hell or high water."