@John Jackson
I agree, it is heartbreaking what the new owners want to do with this house. A house from 1754/1840 is just such a cool thing to find in an un-renovated state. Personally it makes me wonder why they didn’t just get a newer house. But it is what it is.
While you are right, houses that old are generally harder to find, they are not at all impossible to find. They are a few from that time period in Sturbridge in particular, and the surrounding areas. I am guessing you are not looking there, but I have found that the further west you go in MA the greater the likelihood of finding antique houses with details still intact. So it seems to me the odds are in your favor.
Perhaps this house was meant to be a lesson. It made you gear up and get passionate, it made you envision the restoration, it made you figure out the financing. So now you know what you want, you just need to hone your approach. Probably part of the problem was trying to purchase the note and not the house. So next time (and there will be a next time), aim directly for purchasing the house. Maybe this is a good time to connect with a realtor and let them know what you are looking for, or start making a hobby perusing real estate listings.