Lot of good advice here, especially, giving up the idea that sleeping quarters on a sailboat should be called a "stateroom"!
I would also advise being flexible about two separate cabins. Most boats over 30' will have a saloon
with a pull-out bunk and a separate forecabin, at the very least. Sleep in the saloon
and put your guests in the forecabin (generally, a v-berth). Works great for two couples. A toddler can sleep in a pilot berth. A second "separate cabin" on older boats much under 40' is going to be a quarter berth, which is going to be much less comfortable than using the saloon.
Don't overcomplicate it! A somewhat bigger boat will automatically solve the accommodation problem. If you change boats, don't buy it for the accommodation, especially in that size range! Buy it for quality, condition, sailing performance, beauty. The accommodation will take care of itself.