Welcome to genvibe!
You can't just buy the front pipe. You'll have to buy the whole exhaust pipe from the manifold back, up to the muffler. This includes the catalytic converter, though. https://www.rockauto.com/en/moreinfo.php?pk=5675607&cc=1432959&jsn=736
Be careful that you choose the CARB version of the cat, unless your emissions sticker under the hood doesn't say California on it.
You might be able to take it to a muffler shop and have them bend a replacement if the cat is still good, but need to find a good shop.