Refine SQL qry to include 5 extended properties within new table

I need some help refining an SQL query so that it can join several times with a new table to pick up various extended properties.

I'm SQL novice. I have built a great query that already joins four tables in a simple way.
I want to improve it so that it can bring in multiple extended properties from a new table.
The problem is, those extended properties are all user defined which means they aren't columns in the new table they are included as rows.

I can show easily what I need in excel, but I want it to happen during the query.
Please see attached excel file before bidding.

Ideally, I would like to do this via a video call, where you show me what SQL I need to write (so that I can learn).
Thanks, Rob.