The hat that Sean Connery wears in the first James Bond movies is still available at the original store, Lock & Co. Hatters on St. James's Street in London. Ask for the Sandown model, a trilby type hat. Although the hat in film looks grey, the hat is actually brown.
Update 2020: The same hat is now available online at Mason & Sons for £295 / $377: