Jobs at small Raleigh companies nobody posts about (Raleigh)

I asked around at a community meeting and got three leads. I have been trying to stay organised about it. They prefer people who can start within a couple of weeks. What do you write in a cold email?

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

A short email with two sentences about what you can do and your résumé attached worked for me. I followed up after a week.