7 weapons match your filters.
9mm
The 9mm is the pistol Deacon starts with, and it is the weakest sidearm in the game. It only ever comes in Junk condition. Swap it for the SAP9 at Hot Springs as soon as you can, since that costs just 500 credits.
Eliminator
The Eliminator is a Military Spec heavy pistol that can drop a Freaker in one shot. Jacob D'Angelo sells it at Wizard Island from Trust level 2. Expect heavy recoil and 9 rounds a magazine.
PDW
The PDW is a Special Forces sidearm with high accuracy, low recoil and a 20-round magazine. It costs 1,250 credits. It is one of the best pistols in the game, rivaled only by the Eliminator.
SAP9
The SAP9 is a Poor-condition pistol sold at Hot Springs for 500 credits with no Trust needed. It is a clear upgrade over the 9mm, with a 12-round magazine and better accuracy. Buy it on your first visit.
SMP9
The SMP9 is an automatic sidearm with a 30-round magazine. You can buy it at Hot Springs or Lost Lake, or get a better Mil-Spec copy free from Horde Killer. Full-auto in the sidearm slot is great on the bike.
The Mayor
The Mayor is a revolver that fires small shotgun shells. It is Colonel Garret's weapon and a reward from the Law And Disorder storyline. It hits very hard up close from the sidearm slot.
The Sheriff
The Sheriff is a heavy-barreled precision revolver and Iron Mike's weapon of choice. It unlocks free after We've All Done Things. One shot is often enough, but reloads are slow.