Joomla is good for what you need as it sounds like you don't need anything too extreme like paying users/restricted content etc which Joomla fails miserably to achieve.
What ARE your needs? That could help some of us guide you. I've used just about them all but prefer three for different things. If it's just a simple site that you want then joomla will do it. Drupal would be overkill IMHO. But if you want to be updating it more often with more blog like controls etc then drupal or wordpress is a better choice. If you want a full featured website with paying customers, targeted content including specific ads on specific content as it's added then go with postnuke. I have done over 200 postnuke websites and for creating a secure fully controlled cms it beats them all hands down even though it may not be as well known as its larger competitors.
1. I need to be able to send out newsletter and have the newsletter show up on the site in a news section.
2. Uplaod porperty info
3. MLS live links or be able to feed MLS info directly into site
4.Be able to manage all the content of each page
From my experience with importing MLS data, it is not an easy process. They claim to have and IDX data format, but basically it just says says to have the data be deliminted and divided up by type of listings. Some use "|", ",", "{tab}". For compressions some are zipped or tarballed. Plus it is very hard to get any information on even tho order of the fields themselves. Each seems to do their own and then change them without any notification. Data definitions if available will probably be outdated.
Therefore 1 and 4 should be covered by most decent CMSs, but 2 will be harder to find and 3 much more so.
I ended up writing php scripts for 3 to uncompress, parse, create the sql inserts and then execute the sql inserts automatically daily (1-5 am depending on feed) and then send completion/error reports.
