I can very well understand your enthusiasm for this old gem, I think these old houses have so much more soul than the new building blocks and I also felt a bit sorry to have to tear down the tiny settlement house that stood on our property (it still had such a wonderfully old entrance with glass, an old curved wooden staircase, and beaver tail tiles). But this particular property would intimidate me a bit if I didn't a) have a very high budget and b) have some experts on my side who are knowledgeable about energy-efficient renovation, conversion, and building damage. In your area, the prices for craftsmen might not yet be as high as generally in Bavaria, but before a potential purchase I would inform myself very carefully about what you might have to expect in the worst case and what subsidies might be available (mold? pollutant removal? unstable masonry and unusable pipes?) and also get an offer before any considered demolition. We had a really tiny house to tear down but just the asbestos disposal quickly drove the bill up due to hazardous waste disposal. I find the plot itself with this wonderful garden super beautiful regardless of the house (like you, I think of orchard meadows and in my case sheep that I would put on it with so much space) but since I am just as sensitive to noise as you described, I would reconsider this street, at my parents' place it looked similar at the time of purchase, now trucks drive through every 5 minutes and my mom is having a breakdown :)