One of the most stunning villas seen in a James Bond film is Elrod House in Palm Springs, which doubles as Willard Whyte's summer house in Diamonds Are Forever (1971).
More information and links