what I have already seen ;)
but 500k with 10 years fixed interest rate and 2% repayment (at 2.50% interest) results in a calculated term of 32 years... so if you retire in 35 years, it fits on paper for now...
but sure, the optimal way is best to have 20 years fixed interest rate, and then arrange it so that after 20 years there is a manageable residual debt, which you can actually pay off with special repayments within the first 20 years.
but at the high ends (90% or more) 20 years fixed interest rate or more is so expensive that it is almost inevitable to rather take 10-15 years fixed interest rate + secure it additionally with a home savings plan.
in terms of total costs (incl. closing fees) it is considerably cheaper than taking 20-30 years fixed interest rate.
the charming part is then: 15 years bank, 15-17 years home savings bank, at fixed conditions, fixed rate over the entire term, and then you are debt-free, without interest rate change risk... and with special repayments you additionally shorten the term and thus save on interest...