Not being from your area, I don't know when school gets out for the summer. If school is still in session or summer school is starting soon, I would recommend that you go to the school while students are arriving for the day and leaving for the day. Park near the home you are considering. Stay there until the morning bell rings and then go back and stay in the afternoon until all of the students are gone for the day.
How close is the football stadium to the home? If it were football season, I would recommend you do the same thing. How loud are the games, the people, the band and the loudspeakers? How distracting are the lights?
If you have to ask the question...you already know the answer to the question.
Never, ever purchase a home, without the thought of resale in your mind. If you have these questions, today, then the next potential buyers will have the same questions, too.