Okay,
I am a realtor in Charlotte, NC and maybe I can put a different light on things. Depending on your states realtor association bylaws and ethics your agent may have been doing what he/she was supposed to. Here in NC we have to be VERY careful about giving the client our opinion on the cost effectiveness of a property. We can show you the comparable properties and what they sold for and you as the consumer can make the decision...think of it like this, if you are a home buyer or investor and you go to an agent and that agent tells you that the price for home X is a good deal, and you should take advantage of it, if after you purchase and close on home X you find out that your real estate agent was misinformed or just wrong, your agent risks liability. I understand from a home buying prospective that you want guidance and reassurance, but there are limits on what we can do. I am sorry that your experience was not all that you were hoping for and I assure you that there are wonderful agents out there.
My office is full of knowledgeable and trustworthy agents, if you would like to find another agent I can get a referral for you. Hope this helps and if you have any other questions or concerns please feel free to send me an email. -Sarah