HI1 I have lived in this subdivision for about 6 years now! I absolutley love it! As for the train: it runs at least every two days, but you can only hear it if you are outside. I dont know about the houses closer to the track, but as far as im concerned, the horn blows only once, maybe twice. The football lights at LCA, can be noticed, but arent bothersome.
You hear their announcer sometimes, but that is because I live two streets away. The good news is, games are only some Fridays in the fall! The stadium can be heard sometimes, and is usually at 8-10 PM, so if you have little ones, that could be a problem. Most nights with concerts are usually on weekends or in the summer, so most kids will have later bedtimes.
But, overall, none of these things really bother me.