Programming a Real Estate Lister

[leapingfrog]

Hey Guys,

I'm working on making a real estate lister, which will list various homes plugged in via an admin section, preferably placing the data in a database. However, the tricky part is that not all the homes will have the same attributes. I want the ability to specify custom attributes for each house -- like size, cost, fireplace (yes/no), etc.

That said, it will be difficult to setup a database table to store the house data because of the special attributes properties. I can't create a common table structure because each house will vary.

How would you solve this problem?

Thanks for any advice!

Andrew

[SargeZT]

The best way I could see it is to take all of the truly dynamic information, things that could possibly be in one house, and not in another, and store it in an array in php. Then, serialize that array and store it; Then, retrieve it for later use.

Edit: Jeez, I just suck at spelling today.