Can my short-term gain on a real estate transaction be offset by a long-term capital loss carryforward?

Yes. While there are certain ordering rules for applying capital losses against capital gains, ultimately, long-term capital losses can offset any short-term gains.