The apartment's location is fantastic in the sense that you are above a great bar (Blakes's Tavern), across the street from a solid restaurant (Viva Mexico), and near Dunkin' Donuts Center, Brown University, the public outdoor ice rink, buses to the airport, and the (overrated) Freedom Hill.
The negative is that you are right across the street from a bar with loud music called The Stable. The bar is sound-proofed except when someone opens the door to enter or leave...then the musical blasts hit you. It closes around 2 pm, when you will hear drunk patrons yelling for 20 or 30 minutes, at least on weekends. Due to this, I would not recommend this apartment to anyone who would be bothered by this racket.
The apartment itself complies with all the basics. It is very spacious too. The very high ceilings are great, except if you are trying to heat the place.
The owner/operator impressed me as a great guy. We had a major problem, but he fixed it the same day it was reported. It is always great to see an engaged, proactive owner.