I think it will be a different matter when Prince Charles takes over, Andrew will be excluded from centre stage.
^^ I agree with this!
And it will be interesting to see whether he gets to stay at Royal Lodge in Windsor or not.
I'm ill and bored ATM and have gone down a real rabbit hole this morning and discovered this very interesting Wiki page about the property:
en.wikipedia.org/wiki/Royal_Lodge
Have a look at the hit about "Lease to Prince Andrew Duke of York" fascinating stuff!
For most of us the word "lodge" sums up a small house situated at the bottom of the drive leading to a stately home. Or a log cabin at Centerparcs 
In this instance "lodge" apparently means a £30 million, 30 room, grade II listed property in Windsor Great Park belonging to the Crown Estates. However, Prince Andrew was granted a lease agreement back in 2003 for 75 years, which meant that after the Duke paid £7.5 million for refurbishments, a £1 million payment to the Crown Estate was made by him to secure the home. The property leased included the Royal Lodge, a Gardener's Cottage, the Chapel Lodge, six Lodge Cottages, and police security accommodation.
From the Express: "Before Prince Andrew first moved in, he is said to have spent £7.5m renovating the 30-room Georgian house in Windsor, with new additions including an indoor swimming pool. The property also has a private chapel, and eight separate additional properties for staff."
How the other half live eh?
And this is just one of twenty-three royal residences :
Buckingham Palace, London
Windsor Castle, Windsor
Palace of Holyroodhouse, Edinburgh
Hillsborough Castle, County Down NI
Sandringham Hose, Norfolk
Balmoral Castle, Aberdeenshire
Craigowan Lodge, Balmoral
Clarence House. London
Highgrove House, Gloucestershire
Llwynywermod, Carmarthenshire
Tamarisk House, Isles of Scilly
Birkhall, Balmoral
Kensington Palace London
Amber Hall, Norfolk
Frogmore Cottage, Windsor
St James's Palace London
Gatcimbe Park. Gloucestershire
Ivy Cottage, Kensington Palace
Batshit Park, Surrey
Bar well Manor, Northamptonshire
Wren House, Kensington Palace
Thatched House Lodge Richmond
I don't know how up to date the list is, as they don't mention Nottingham Cottage, but you can see on the Wiki link that seven of these are privately owned, three are owned by the Duchy of Cornwall, and 13 are owned by the Crown Estates.
I never knew it was so many! I know I have wandered massively off the point of the thread and many of these buildings are "held in perpetuity for the nation" but not all of them are open to the public by any means. It seems extraordinary to me, and slightly morally dubious in these straightened times, that one family requires all of these assets.