What exactly is the lesson for next time? How urgently are you looking for something? Not everyone has to make the same mistakes as others themselves, and maybe you can really learn something from it... I still cry today for the first house we looked at, and we made the same mistake... had little knowledge of the market, parents said there was so much to do with the house (the terrace had sunk)... and back then we thought that for the price we could build something new ourselves... Over the years (!) we got wiser but the whole thing almost cost us 5 years because you just can't easily get building land here...
We looked at many houses, bought one and then built, and my experiences are:
1) Banks estimate too low in their systems, for what they said our purchased house with 230 sqm should be worth, back then I wouldn’t have even gotten a shabby semi-detached house on the market
2) Definitely take an appraiser but only to uncover defects, nothing else, and it should be a sensible one
3) Learn from it
The house shown is beautiful... you were the first and before the viewing marathon... that was your chance, you messed it up...
We felt the same back then, begged the seller for ages after that... He put the house online and then sold it to those who, as he called them, appreciated the house the most... who had nothing to complain about and at least didn’t say they were going to renovate half the house... such people are attached to their houses, they don’t want you to mess it up...
So move on...