A "unique" detached farmhouse near Brampton featuring its own bar has hit the market for £825,000.