Sherlock Holmes smoked a clay pipe. The Calabash (gourd with meerschaum lining) was never mentioned in Conan Doyle's stories. Some early (1930s?) actor used his own pipes while portraying the great detective.
Still... they're cool and I would like a good one someday. It looks like eBay is your best bet.