The Prince Andrew involvement is a tricky situation. My suggestion would be that the Queen restrict him to one of the least desirable Royal properties and restrict him to just a few rooms for 20+ years; and, take away his income.
The Tower of London, comes to mind......................