Jobs at small Buffalo companies nobody posts about - any advice?

I asked around at a community meeting and got three leads. 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.