When this picture is zoomed out, it looks like a photo. But when it’s zoomed in, you can see the oil-painting details. This is done with a specialized filter available only in the latest version of Photoshop. And it looks super cool.
You also might want to check out Delicate Arch of Arches National Park (Oil-Painted Photo).