Picking a good neighborhood is as important as choosing the right house. Here’s how to identify an up-and-coming area—and why “bad” isn’t always, well, bad.