The location was perfect! We walked almost everywhere. So close to many breweries and restaurants, and having a grocery store nearby was amazing. The place looked even better than the pictures. Since it is above a bar you do hear occasional noises, for the most part nothing crazy. Just beware of the bar dumping glass bottles into the recycling bin outside the bedroom window at 2am. It only happened twice during a 7 night stay, but it surely scares the hell out of you.