At the current interest rates, builders from 10 years ago who had calculated narrowly and had a low repayment rate would almost have been forced to sell.
The prices 10 years ago were completely different. Accordingly, the residual debt is relatively low.
Have you ever tried to find something "quickly" in Stuttgart? ;)
So your future million-euro project exists only in your mind and nothing concrete has been done yet? Then I would exclude that from consideration.
Otherwise, the increase in the value of the property itself should also be taken into account; according to 3 appraisals, the value is already significantly above the discussed selling price, so at resale the risk of loss should at least be limited – yes, unless the market crashes – but that can also happen in the stock market...
The mere number of appraisals would make me suspicious. Nobody gets 3 appraisals just to sell something. And on top of that, your landlord is then selling "significantly" below the determined value. He’s certainly giving away tens of thousands of euros...
Do you actually understand specifically what the appraisals evaluate? Like how the appraisers assess the individual aspects and arrive at their figures? When a floor covering is considered like-new. And so on.