StreetAdvisor -- real-life advice on neighborhoods

For those interested in buying real estate or just renting:

... provides a real-life “insider” view that provides users the ability to learn and share vital details about where they live, including noise levels, traffic, neighbors, entertainment, and public services in a similar way to travel review sites. Recommendations and negative experiences about local businesses, entertainment and services will also be supported.