A nine-bedroom property with an award-winning café, an antique shop and conversion potential has been listed for £865,000.