Lawrence and Lowell were both mill towns and have some rehabbed condos that were originally old mill buildings, and other areas that are being updated (gentrified, you could say).
At one point the two were twinned, with the mill owners, I believe, living in Lowell and the workers in Lawrence, which remains slightly more blue-collar although both have areas that have taken on the 495-outerbelt aura of bedroom-communities-to-Boston look.
Town websites are at:
Lawrence:
http://www.ci.lawrence.ma.us/Pages/indexLowell:
http://www.lowellma.gov/I believe the names came from Amos Lawrence Lowell, the mill-owner at the time.
It is close to the MA/NH border; many people that close to the border go over to enjoy the taxless state of NH's offerings, some live there and commute into MA for the same reason.
Sports include water sports along the Merrimack River (read Thoreau's canoe trip journal for a historical sense of the place), hiking and skiing in the NH mountains, etc.
The Methuen Organ is a world-renowned attraction in its own right, also nearby, and the town of Methuen has areas that might be good for living in as well.
You do need a car; there is a bit of public transport but not much.
The areas around Lowell vary somewhat between upscale and depressed at times; there are some strong pockets of French Canadian descendants (Jack Kerouac was from this area) and the Quilt Museum and related folk/craft activities bring many summer visitors to the (small-ish, everyone goes to the malls) downtown shopping areas.