How to properly design the architecture of a real estate agency website?

Question

PHP

The task is to make a website for a real estate agency.
The first thing that is formed is the type of objects (categories). For types, common characteristics are price, city, district.
But for each of the categories there are also a number of specific characteristics for this particular category.
Filtering within the category is also required.
As far as I understand it is necessary to use eav. Or can you do it the other way?
If anyone has done it, please share your ideas.

Answer 1

ww-realty.ru search form on the left (Advanced search).
You can also do EAV. There are usually not many objects, so there are no performance problems at the subd level. But you can also simply make one table where each characteristic is a separate column (on the site above, that's exactly how it is). This option is easier to implement and support than EAV.