A home can be renovated. A neighbourhood cannot, at least not on the schedule of a single purchase. That is why the street deserves as much attention as the property itself.
Spend time there at the hours you will actually live there. A quiet street at eleven in the morning can be a very different place at six in the evening, and a weekend visit shows a third version again.
Walk your real commute instead of estimating it. The distance between a door and a platform is measured in minutes, and those minutes repeat every working day.
Check the everyday one rule: is there one place you would be happy to become a regular? A bakery, a park, a library — something local that makes the area a home rather than an address.
Finally, ask about what is planned rather than only what is there. A short conversation about upcoming construction or zoning tells you more about the next five years than any current photograph.