Below are a few hotels we have stayed at and I can vouch for their quality and location. The closer the hotel is the downtown Newport the more expensive it will be. I tend to look for hotels in Middletown, RI, it's the town next door. It would add maybe 3 miles to the trip to the mansion but the prices are usually almost half as expensive. If you have any questions feel free to contact me at (603)-546-8549 or arnott.matthew@gmail.com. We can't wait to see you there.
One of the most beautiful hotels in town, less than a mile from the mansion.
Jim and I have stayed here a couple of times. Within ten minutes of Rosecliff and downtown Newport it's very convenient.
Another great hotel choice, affordable but a little further from the Newport/downtown area.