If you are buying in a specific neighborhood, no "areas" would be better than others, but the location of a property is always a consideration in any area you purchase in.
If you are considering different neighborhoods or areas for your potential investment, you want to consider the community amenities to determine which might be preferential to others. You would also want to look at what is called "pride of ownership" - how the people that live in the area maintain their homes and the common areas. Usually properties that are close to or convenient to things like shopping, transportation, community services (playgrounds, museums, etc) in areas that are well maintained with low crime rates will bring the highest potential rentals.
Appreciation is a completely different issue, though it is impacted by the all of these considerations as well. Since appreciation might be impacted by outside influences such as new developments and employment gains or losses, it is probably not the best thing to consider when buying. Luckily our marketplace is a pretty stable marketplace, and if you keep the basics in mind when buying, and the area and the home have solid (rather than speculative ) value, you'll probably make out very well.