Check out a miniature schnauzer, they are small, sturdy, and full of fun! They are a big dog in a small body and have the energy/stamina to run with you or just cuddle on the couch...LOL, easy to please and train.
Do you want an adult? or puppy? will it be easy for you to walk the dog to go to the bathroom? How much grooming do you want to do, does your budget allow for professional grooming? How much can you spend on dog food? How much training can you do.
When we lived in our apartment our neighbor had 2 greyhounds that he rescued. They seemed to be the best dogs. We never heard a peep out of them. He would walk them twice a day and they just looked so happy. I always thought that they knew he saved them.
I sleep a lot so my dogs must have trained their bladders well! I can go to bed an idnight and not take them out again till at least ten in the morning if not noon. They are usually looking at me like why are you getting up?!
English Bulldog!!! Wonderful breed. Not going to be rowdy if you live upstairs. Just don't think they are going to run with you. I have two, and they sleep ALOT....But easy to train and very sweet natured!