Strong rental demand: With major employers like the Cleveland Clinic and University Hospitals, along with a growing arts and culture scene, Cleveland attracts a steady stream of renters.Revitalization efforts: Many areas of Cleveland are experiencing significant revitalization, which can lead to increased property values and appreciation potential.I can't comment on the Detroit market specifically, I have never been and have never done any research on it!

Tenant occupied properties can be attractive to investors if cash flowing...no one wants to buy someone else's problem. 

We attract high quality tenants. 

Not a ton of value-add opportunity, more of a core+ investment in a very small market I'm familiar with - my initial analysis is yielding a 14% IRR & 1.28 EM, so I'm not sure of the attractiveness to investors.

A study recently completed showed that most squatters are attracted to two properties: vacant and those listed for rent stating 'for immediate occupancy' or vacant. 

Given your situation, a property closer to Nashville might be more advantageous for short-term rentals like Airbnb, as proximity to a popular city typically attracts more guests and higher rental income.

Quote from @Miguel Del Mazo: Quote from @Jonathan Greene: Quote from @Miguel Del Mazo: We have 3 2/1 condos in our portfolio that attract traveling professionals (medical or otherwise) and a triplex that we essentially BRRR'd down to the studs.

Property ClassProperties are categorized by class, impacting their quality, condition, and investment profile:Class A: High-end, newly built, prime locations, attractive to institutional investors.Class B: Good quality, older than Class A, with minor deferred maintenance.Class C: Older properties with dated amenities, but value-add opportunities exist.Class D: Distressed properties in less desirable locations with high risks but potential for significant improvement.4.

so just because you would not want to live in a specific town for various reasons does not mean they aren't attractive to others and good investment opportunities. 

I am under contract for a 3 family home w a very unique set up. 2- 1 bedroom apartments and 3 and 4th duplex which has 5 bedrooms but only 1 bathroom this home is 8 min from Brown University in RI and 10 min from Johnson Wales. (6miles)Do u think its close enough to attract college students especially the duplex?