Welcome to the forums! Glad to have you on board.
I'm not sure you are into handguns, but a buddy of mine brought over his latest gun and I can't figure out what it is... I believe it's a 9mm P226, but it's threaded and I can't find it on the sig site!
Update: I think it's the Sig P226R Limited Edition tactical pistol (only 400 made)
Be sure to post pics of the HD when it arrives!