A charlatan is generated once their NPC purpose is needed, unlike most other NPCs that exist before the start of the game. So technically speaking, there are no pre-made charlatans that can be found in-game, only computer generated ones. This is also the case of the Wise Old Man and Edward Dregg.
Unsavory has 22 personality points, instead of the usual 25. He uses the 2nd default Maxis face template in Create a Sim. He can easily be cloned in Create a Sim with debugging mode on.
Unsavory has short black hair, a top hat, cape, waxed moustache and an Edwardian style suit. Even though he has black hair, grey eyes, and tanned skin, his SimDNA reveals that his genetics are for brown hair, dark blue eyes and light skin.
This Sim has no character data and cannot be resurrected in-game. For more information, read this guide.
Do NOT attempt to add Unsavory Charlatan to a household, make him selectable, or tamper with him in any way or form. Doing so will corrupt the neighbourhood he is in.