Climbing roses can transform a plain-looking wall ... zones 5 through 11 and does best in full sun, but tolerates some shade.