German Village and Brewery District are awesome if you like areas with brick streets, old homes, and a sense of history.

This is probably the best site to find apartments for rent in those areas. Or just walk/drive around the neighborhood and you'll find plenty of "For Rent" signs.
Metro-Rentals.com: Houses, apartments, and commercial properties for lease in Ohio