English Village, Indian Village, University District, Palmer Woods, Palmer Park, the Bagley District to name a few. Also, check a website called skinny zip it will give you highlevel demographics which specifically speaks to the income levels in the area. If you want guaranteed occupancy all year round buy in Downtown Detroit. As for areas to be leary of stay away from Brightmoor and a cross street called Beewick and Mack. The eastside seems to have less demand than the west side of Detroit because of the high vacancy rate. Also along the Outer Drive Area you can find gorgeous homes. In the area codes 48202, 48206 which is close to the hospital there seems to be high demand in this area because it is in or near the New Center. They just opened a whole foods there. There is also a Starbucks in this area. Hope that helps.
Check crime info and other cool info at: http://www.zipskinny.com
Realtors cannot steer you into certain areas so you may have a hard time getting a direct answer to your question.
But it may be easier to start with, what is your price range, how many bedrooms do you need, do you need a basemenyt, a garage, etc. Narrow down what you need and how much you can afford and I can send you some properties that will fit into your search.
Also, are you pre-approved for a mortgage or are you paying cash? If you are not pre-approved, I wiould suggest calling a mortgage lender to see what you qualify for. Without cash or a preapproval it is going to be hard to have a Realtor help you.
My contact information is listed below, so feel free to contact me.