Is buying a house across an elementary school a No?

[Jack Jiang]

Hi fellow BPer, I am planning to purchase my next property in GA, and I came across a house located in one of the top neighborhood. Everything is great (condition, rent, school) but the property is directly across an elementary school (parking lot) near a 2-lane road.

I am fairly new to investng and I don't have experience living in or dealing with a house next to a school. Would noise from schools be a major concern to the renter/buyer? Also is appreciation of such a house significantly lower than one on a quieter street? The per sqft is certainly lower but not sure about the appreciation.

It's kinda rare to find a house that could cash flow in such a district, so I am wondering if it's worth pulling the trigger. Any advice is greatly appreciated!