This was just a weekend visit for us and our first time at the Mansion del Rio. I cannot say enough about the staff, excellent in every way. The hotel is not located in the busiest part of the Riverwalk. This means less noise. It also means you need to walk to shops and restaurants.
We had a river view room with balcony. The room was very small which was not a problem for two people. The balcony is not a private one. It is shared with about 4 rooms and they have a few uncomfortable chairs for everyone to share. It is a nice hotel with a great staff but not what i expected for the price.