What to Expect from a Real Estate Agent

Just like in any other profession, there are good real estate agents ... and there are, unfortunately, subpar real estate agents. But how do you know if you've got a dreamboat or a dud handling your real estate transaction?