Just saw this great article. It includes the Armory District of Providence.
Of course, I'd have to include the entire state of RI as a place to get a great old house since we're loaded with historic properties-
a lot of which could use some rehab.
Best Places to Buy an Old House: Editors' Top 12 Picks | Home & Real Estate | Planning and Ideas | This Old House - 1