I need to make a Real Estate Project, where user can post different listings for Sale or Rent their Real Estate Properties.
There are some Catagories for Properties with different Properties types.
for example
1. Resedential
home
portion
flat
apartment
2.Commercial
shop
office
floor
etc.

Now the problem is that every property type has some common attribute i.e price, Area, construction but also has some uncommon attributes like home doesn't contain parking attribute while a shop or office has.

Please if anybody can tell me how to structure this as a database.

Thanks,
With Regards,
Shairoo

this is a classic supertype/subtype problem

you need a supertype table called properties, which will hold all the common columns

then you need two subtype tables called residentialprops and commercialprops with only the unique columns (and of course a Foreign Key which references the Primary Key of the supertype table)

but there are also distint variables for every residential or commercial property type......

No there isn't, unless you are working with some seriously bizarre MLS vendor.