THANK YOU!!! Not everything is for everybody. There is a time and a place. I love my kids - and usually everyone else's - but they aren't welcome everywhere. I am always blown away when people (it seems always to be women) think their kids should be allowed in their college classes, their workplace, all wedding ceremonies (some of which are kid-friendly and some of which are not).
Husbands aren't welcome at bridal showers. No one gets upset about it. It just isn't for them. Doesn't mean we don't like them or are husband-haters. Wives aren't welcome at the annual canoe trip my dp takes with his high school buddies. No big deal.
I'm sure there are lots of hotels in the area that would work for the whole family to stay. I haven't personally stayed in B & Bs before - because it just seems like not enough privacy. OP, I hope you find something that will work for you. Congrats on your dp coming home!