What the other guys said. DDR3 requires an AM3 CPU. That means you have to use a Phenom II based CPU in order to use DDR3. So basically any processor with a Deneb, Heka, or Callisto core with the exception of the X4 920 and X4 940 Black Edition, which are AM2+ only.
@ Alienwho
Just browsing Newegg. Asus, Jetway and ECS have boards that support both DDR2 and DDR3. AM2+ and AM3 are electrically compatible. It just depends on what memory controller the CPU itself has on board. AM3 processors are backwards compatible with DDR2 but AM2 processors aren't forwards compatible with DDR3. I briefly considered going this route. However, the problem with these legacy boards is that they sacrifice too many features to get that compatibility.