Many reasons have already been mentioned, which probably all together have caused the rejection.
If I were the bank, I would also reject flat out because of the idea of financing up to the age of 87.
2) 40 years is no longer a good timeframe for you. Consider 25 years.
Well, going down from 40 to 25 years will significantly increase the rate from 1100. Maybe €1600?
: What parameters will you adjust now? A new advisor is nice and good, but in case of doubt, they will execute what you tell them you want. What rate would be the maximum bearable for you? Would you also be willing to build (significantly) smaller? You could also try to pay off your consumer credit and then make a new attempt in 6-12 months. Difficult, because every month of waiting brings you closer to retirement. Again, what are YOU changing now, not just any advisor?