Well its a shame you are only considering in house. I have all those skills and more. I have a few clients that are in Vegas and I achieve their goals just fine from the confines of my own office in Oregon.
If you reconsider, hit me up. I can cover your needs.