Homes Under the Hammer host Martin Roberts wanted to snap up rare Devon gem himself, telling viewers "I want it"