I am creating a website similar to this website. My website needs to allow users to save different kinds of listing like home, plots. offices, shops, agricultural land etc. My question is how to create a database design in MySQL where I can easily add any kind of listings and also it’s amenities. Some listings would have amenities and some won’t like a plot can have amenities such as boundary wall, near hopital etc.

I want to know what’s the best way to do this. I need an efficient database structure which easily allows me to filter the listings using amenities