This was an attempt to emulate the old process of painting a black & white photo to add color.

This looked a little too saturated to emulate a hand painted photo.
So I tried de-saturating the rose a bit - also tried adding some grain:
Same without the additional grain
Not sure that I ever succeeded in creating something that looks like a hand painted photo.
I just realized, the EXIF info is missing from these images, so for those that are interested:
Model: D300
Capture Date: 6/30/2011
Shutter Speed: 1/320
Aperture: f/8
ISO: 200
Exposure Comp: -0.3
Focal Length: 105mm
Lens: Nikkor 28-105 mm F/3.5-4.5 D