When appraisers call to set up the appointment they usually like to do the inspection as soon as possible.

Ask your agent to include this in your offer (likely under "other provisions" or "financing").When you do this you won't have to cash out until you have completed your home inspection and could do it just before closing (depending on how long it takes to clear funds).

My interactions with zoning/inspections have been very positive here in town.

Compliance with these laws inevitably relies upon whichever  city or county law enforcement and the agency responsible for zoning, construction, inspections and permitting.

Also, make sure the foreclosed properties are inspected.

Purchase is as is and inspector cant inspect electrical for example if it is off.

We offered over asking with no contingencies (no inspection or financing contingencies).

It really doesn't need any work but I still put 5k in my numbers for cleaning, pictures, and inspection list repairs etc.

Durham inspections department had a lot of little things to learn how to deal with and make work, this experience definetly made for a good start in Durham and will help dramatically in future projects in Durham.

And on top of that offer a non-refundable upfront with close as is.Are you inspecting the property as a possible tenant?