A once thriving Northumberland hotel has been standing in a state of disrepair for over a decade by was sold for £285,000 in 2024