How do I extract specific value from a single cell on google sheets

I’d like to get respective data into each cell without the key and punctuations. Each cell must display only the value extracted from the properties column.

I’ve tried to go to Data>split text to the column, but that does not solve my problem. I have around 5000 records. Please note that there is missing data in the properties column. In some cases the data will be blank.

Please help!!

enter image description here