group by comma separated value

Question

i have tow tables. one is Feature table and another one is Property table

The feature table contain following feilds and data 

feauture id is primary key

Featureid Type

 1Garden

 2Parking

 3Swimming pool

 4Balconys

And property table contains data like below

Propertyid is primary key

Propertyid  Feature

1            1,2,4

2            3,4

3           1,3,4

4           2,3,4

5           1,4

i want property count feature wise

like below

Feature  PropertyCount

Garden            3

Parking            2

Swimming pool  3

Balconys          5

How to join these two tables and property count group by feature Type