Jobs at small Honolulu companies nobody posts about (update)

I asked around at a community meeting and got three leads. I have read a lot of threads here and could not find my exact situation. They like a brief email with a résumé. What do you write in a cold email?

Visiting in person worked for a trades job. For office jobs, email was better.