Hi Jon: -- You're welcome. On to answering your questions:
************************
Deadlinks: It appears your Rok Content Rotator is either 1. cranking out the wrong URL (href="#"), or 2. you didn't put a correct link in the setup, or 3. something else is trampling it but the following just show
http://www.albany-ny-homes.com/# as their reference in both Firefox 2.0.0.15 and IE 7.0.6
FREE Book
Your Home Value
Buy with ZERO Down
Preferred Buyers
Sell for Top $$$
************************
Versions getting old:
I would be most concerned with security. That site can be quite easily hacked. You may want to download a top notch backup utility, and run backups daily (both site and databases) just in case it happens to you.
EDIT: Important note: If you use a CMS based backup, it does not know about your OR SQL database and so it will not back it up. You'll have to do that one manually (whichever method you use to access your databases). Don't wait until something bad happens before you start doing backups. Do it now.
************************
I would *keep* the whole login idea, and add to its functionality. This is what separates you from every other Joe Real Estate site out there. Keep up the good work. Top Producer IDX can't touch the power you have with the software you are using. The downside is - you will need expertise to harness it. You can do so much more than what Top Producer IDX can offer. Whatever you decide, I wish you the best.
************************
Your web host: I didn't dig deep enough to figure out who your host is. But if it's an over saturated one (and those companies do serve a purpose...thing is they are not equipped for what you are trying to accomplish) then you would have nothing to show for any demands...not even upgrading your account. You'd need a host that specializes in handling multiple SQL databases for real estate use. They aren't cheap.
************************
Keywords: I'd challenge you to do a little more research on your choice of keywords.
************************
SEF component: You can easily uninstall the one you have (go in to your directories and make sure the component and all of its parts are deleted) and simply install sh404. It's "free" too. Sh404 doesn't do any of that sneaky ad spam mess that your current choice does. Then buy the commercial version of sh404 (or just donate).
************************
Go easy on the pics. They don't increase your ranking. If you do add a pic or two, make sure you strategically edit the ALT tags.
I wouldn't do activerain. Every Realtor and his brother is doing that. Don't bounce your users around from site to site. You can easily do your own with your setup, and have the benefit of it being on *your* site.
There are a *lot* of good ideas on your site: social boookmarking, latest news, RSS, favorites, user accounts, sitemap. And again, it looks very professional to me. You just need to work out the stuff already mentioned. It won't be easy but...you are welcome to tap me on the shoulder if you need help.
Kind regards.