A historic grade two listed stately home in Northumberland has been sold at auction for only £305,000.