That would be awesome to have, unfortunately, I live in a small 1 bedroom apartment. So I either work on the living room, were the TV and my wife are, or on the bedroom :(
I'm in a small apartment too, where my partner (and dog) are also here. We've both got corners set up in different rooms (I'm in the bedroom) and if I'm in my corner, I'm working. It's less about having a full room to dedicate to being a home office, and more about making a space (no matter how small or open) dedicated to working.