Depends on what you want the site to do for you. Do you want to be adding content regularly? Is it just a place for your clients to get MLS data or to manage escrow information?
You can go with a canned real estate specific solution (I have done this and it works fine for supporting clients, but it will not generate any real business).
Or, you can sort of create your own with any web site provider as long as the have PHP and SQL available. If you have seen my site, that is hosted by a generic web host with CMS software installed. I have been focusing on functionality so far and I plan on giving it a graphical facelift in the coming months. All the site is costing me right now is the monthly hosting fee (about 10$) and the MLS search ability is costing about 30$ a month.
I just recently switched CMS software. The software running on my current site is called Joomla. My old site was running PHPNuke. You can actually still see that old site at
My Old Site .
R