Are you sure that’s a good idea? Of course, you can reduce the repayment extremely. A €500,000 loan at 4% interest and 1% repayment has a term of 40 (!) years with still almost €2100 per month.
One can debate for a long time about the sensibility of such a long duration extending beyond retirement.
In any case, that is miles away from your previous advice:
Ideally, you can do both, only 1/3 of the household net income and repay it in 20 years. And then we’re back to €9000+ net income. When we bought our old building, our notary pressed upon me during the notarization of the land charge (which was 100% financing) that such a real estate financing should be completed within 15 years; we managed it in 12 and then had the equity for the new building.
If the financing runs into retirement, one should perhaps be aware that one will no longer live in this house during retirement but will sell it beforehand.
We lived in the old building for 12 years, now for 5 years in the new building; one can also change owner-occupied houses...