Like others have said, it's a very busy area. Lots of great bars and restaurants. The apartment is on the 2nd floor facing the street. If you are a light sleeper, you want ear plugs. This place is great for a day or two. For longer stays I'd probably upgrade myself.
Sheldon greets you and let's you in. You then have a key for your stay. This is a bit unusual for airbnb- usually there is a lock box or a code. But i waited maybe a minute for him, so don't let that worry you.
I'd stay there again.