Median formula with multiple criteria (or not and) and partial text in a cell

Hi. I'm trying to come up with a formula that allows me to pull the median value from a large data set that meets multiple criteria.

I've attached a sample of the data.

For example, pull all the occupancy numbers from properties containing "*Publix" in Anchors column and with a Building Status of "In Redevelopment," "New Delivery," OR "blank" (not "Under Construction") and give me the median of those. I would use the same formula to look up the median of "*Winn-Dixie."

Thanks for the help.