@Rachel Hadass - here's my thoughts on your questions:
- What areas have the highest tenant demand and why? What are the demographics (eg, mostly families, young professionals, etc)?
Downtown Madison (35758) will always have enormous demand, but the area doesn't cash flow. Huntsville proper under 1500/month has high demand as well in either good neighborhoods and/or nicely updated properties.
- Are there certain areas you would stay away from and why (eg, high crime, bad schools, poor quality builds, etc)?
Not really, although the area around Pulaski Pike has some rough patches
- Would you recommend trying to rent to Section 8 tenants? If so, are there certain areas that would work best?
We have never done section 8 rentals, so I have no experience to comment on here.
- Where are the areas with the tightest inventory?
-Madison proper, and the nice areas of Huntsville (Jones Valley, Blossomwood, etc) - simply because the numbers don't work well in these areas, limiting rental supply.
- Are there areas that would work well as a mid-term or short-term rental in addition to long-term?
STRs are now forbidden in Huntsville without proper zoning - and they have been enforcing it.
We tried two MTRs and lost money - won't try it again.