I am in need of the piece of moulding that goes around the right front tire, along with clips.
I was going to purchase it from Mazdapartsdirect.com, but wanted to see if y'all had any other places that you would recommend.
Rockauto?

 

The year, and trim needs to be posted when you ask a question like this????
However universally speaking aside from the sources and other like it that you found you can check

Discount Auto Parts Online - Domestic, Import Car Parts Warehouse

 

If you post the part number and price we could do searches for the best price.
Note: if you personally order any import items from today forward that are under $800 you will now be paying a flat $80 to $200 tariff fee and/or the export countries US import tariff rate for them to clear customs.

 

MY suggestion is my solution unless its a mechanical component that has unseen wear and tear - / Im my area we have pick and pull salvage yards ( pick a part ..whatever ) -- They usually organize the inventory by vehicle make / year and model and keep them on the lot 90 days - then go to scrap meltdown -- I would check the part # and see which years it covers and start looking for a donor --get your toolbox ready and go get it ! - Many used parts yards once called " junkyards " are now solid gold yards - new vehicles come in daily from insurance totaling vehicles in accidents ---Many work together on specific inventory of used parts as well , and will ship it to you -- On a fender - Why not go used --paying $800 new is ludicrous---unless its painted a specific color I hope you track it down -since its not vital to the vehicles operation - be patient and search

 

I just had that piece replaced at my local body shop for a total of $250. The clips failed while I was driving in a bad storm on the expressway and I noticed it when I saw the front of the trim waving above the hood while driving down the road. The bend in the trim necessitated replacement instead of just getting new clips.

 

Some things (many auto parts) you just buy NEW to be sure!
It is not longer the 1980s and older anymore regarding vehicles and pick'n pull parts.

 

I'm familiar with Pull-a-Part, but the closest one is 2 hours away.

KB7W-51-W20E-8N Is the part number that I need.

 

I always look up every Mazda parts website and see how much shipping for the part(s) will be. I also check eBay since there's Mazda dealers that sell parts there too.

 

KB7W-51-W20E-8N - Wheel Opening Molding 2017-2021 Mazda CX-5 | Mazda-Parts $125.87
KB7W-51-W20E-8N - Wheel Opening Molding 2017-2021 Mazda CX-5 | Mazda Parts Connect $109.09
2017-2021 Mazda CX-5 Wheel Opening Molding KB7W-51-W20E-8N | OEM Parts Online $109.09
Mazda Parts For 2017-2021 Mazda CX-5 Wheel Opening Molding KB7W-51-W20E-8N | MazdaParts.US Store $108.16
RockAuto $39.79 & $59.79 but they are not OEM meaning I have no idea how they will look even they are supposed to fit.

The above found with less than a 5-minute search.
There are more expensive options I posted the lowest prices I found.

 

just actually bought this part last month but for my passenger rear wheel well...had a piece of retread tire kick into my lane from another vehicle on the highway which snapped off the front splash guard and broke one of the clip supports...paid $233 shipped from https://www.mazdapartsconnect.com/...didn't really shop prices though...was an easy removal/install...the part i bought came with all the clips pre-installed