Hi 2 Beagles Joe,
Assuming you want a walk-around queen bed in a rear bedroom, the short answer is "rare pickings". The shortest conventional design I have seen is over 28 feet, and that was in old rigs not made in a while.
There are a rare few current-day exceptions which are uniquely designed.
- a rear slide out where the queen bed folds up inside it like the
Jayco Melbourne 24K- a murphy queen bed in the living room, but I did not find with the overhead cab bed (a conventional class C)
- as others mentioned, the
Jayco Melbourne24L with an unusual full wall slideout
Some of the other things on your list will be dropped as well, but the primary cause will be your rear bedroom walk-around queen bed.
Everyone is sharing longer class C rigs which will nicely fulfill your list.
Being that you require both a large cab-over bed and queen bed, it seems you need to accommodate a family. I always thought the
COACHMAN FREELANDER 21QB was ideal for a family of 4 or 5. It is 24 feet long with lots of outdoor storage for children's bulky toys. It is surely a compromise to your list of requirements, but your length is where you want to be. You can also add a flip-up countertop extension like we have to the left of the kitchen sink to address that short coming. The Freelander series is also very affordable compared to most others. Keep in-mind the quality of a Freelander isn't the greatest so plan on maintaining the house more diligently.