When is the property transfer fee due?

The fee is usually collected during the closing procedures by the escrow or title company.