No. The Asus M2A74 is only compatible with the Athlon II X2/X3/X4 and the Phenom II X2/X3/X4.
However, the MSI 870-G45 is only $69.99 on Newegg.com, and is X6 CPU Certified. It's a good board, and would work perfectly with a Phenom II X6. If you're looking at motherboards, don't just look for a socket match for the Phenom II X6's, look for something in the specifications or on the box that SPECIFICALLY SAYS "X6 CPU Certified" or something similar.