In 20, 30 years, the Federal Republic will look completely different than today. I am not following any conspiracy theories and I also do not believe that we will manage a significant skilled labor immigration, therefore the population in Germany will shrink significantly.
The current real estate prices are a mixture of the pressure from the housing shortage and the financial jugglers, historically still very low interest rates.
But that of course plays no role here and now. But if you say Hamburg, 1,400m² plot, then the house should not be worth 450,000 but rather 1,450,000 EUR (1.45 million EUR). And then your financing is already no longer realistic for that reason alone, because on top of the 250,000 EUR purchase price, the same amount or more in gift tax will be added.
You could never ever service a loan of 400, 500 or even 600,000 EUR with your 3,500 EUR, even if you agree to just 1% repayment and the daughter takes over with 80% residual debt in 25 years.
PS:
Yes, it would be the absolute top opportunity to snag a bargain, which it still is even with gift tax. But as sometimes happens in life, it comes at the wrong time for you. Either you go back to full work immediately and have 5,000 EUR or more in the account at the beginning of the month on a permanent basis... or you let it go. This is too big a deal, it will not work.
PPS:
And build year 1998 is already 27 years. A new heating system may well be due and a complete roof and facade renovation is not far off anymore if you want to maintain the value of the house.