The Grade II* Listed mansion will be going under the hammer next month