The location in the north end is fantastic if walking this area is important to you. The apt. is roomy with a couch for sitting. Bed was average with a single good quality mattress, no box spring, so it far from a high end mattress setup. The stairs are steep and long which was no issue for us. There is no closet for storage but plenty of floor space to "live out of your suitcase". We very much enjoyed the extra floor space rather than a typical hotel room.
Kitchen was stocked with all the basic essentials if you want to cook. No food staples, like spices, oils, etc. so bring your own or you will have to buy when you get there.
AC was good and got a good workout in a heat wave while we stayed.
There were limited channels on some sort of basic tv service. However, the internet service was very good so we were able to hook up our computer to access our home services through wifi (HBO, netflix, etc.). If you cannot hook up this way, you will be disappointed in the channel selection. We stayed 9 nights so tv was very important to us.
The windows and views over the water are great. However, the mini blinds let in the street light at night so there is a lot of ambient light at night. Bring eye masks if you need total darkness.
Overall, this is a great value where the price of a hotel is far more. It does feel like you are living like a local in this apartment and area, which was a good experience for.