The view from the living room is unbelievable. We were a family of 3 (including a 1-year-old) and had a great time in this apartment. There's an elevator in the building, but you still have to deal with some stairs, which was not a problem for us.
The neighborhood is perfect since you're in the middle of a lot of stores, feet away from the river, and yet the noise level is not bad. There are two mini stores where you can get some essentials within walking distance of the place.
If you are a family traveling with small children, they provide a pack n play (sheets and everything), a tub, and a chair.
Maybe the only con would be the mattress. It would greatly benefit from having a softer mattress topper. Other than than, this place is perfect.
We strongly recommend this place for the view alone.