Historically, homes in Madison around that price have done relatively well. All it takes is a drive through a couple of these communities to see that. Now, there's just been a little bit of a shift in the market. If you have any specific questions, feel free to shoot an email over to me: firstname.lastname@example.org - I can help you out with anything you need to know.
When it comes to desirable neighborhoods in that price range, Clifts Cove and Highland Lakes are usually everyone's first choice for a mature neighborhood with character. They also have the flexibility of building on a few available lots as well if they don't want something already on the ground.
It's a little bit of a jump from some more consistent places like Greenwycke Heights, the Ledges, and Walker Woods on the other side of Huntsville. It's always difficult to predict resale, but if you go by recent data, it would look like that area of Huntsville would be the safer bet at this time. A year or two or three or four down the road, that could all change. For example, the year before the market blew up in Cali, all the data pointed to buying a home for well over it's worth because you'll be able to flip it in a few months and make a hefty profit. We all know what happened then.
Feel free to ask any more questions. I'd be happy to send any more info your way.