I would also appreciate if you could shed knowldege on a newbie as to how you determine if a certain market is desireable.

You communicated a desire for quieter music, they complied.

I have a home that is an STR in a highly desirable tourist destination.

that would lower your down payment requirements - you could keep your primary as a rental, and move into a househack. 

Other than that it seems like you have a lot going for the property considering the proximity making it very desirable.

The interest only payments and great leverage should allow you to turn it quickly and reap your desired profits.

Reduced down payments are possible for multifamily buildings using financing options such as FHA loans, which are less expensive than traditional loans.Find local programs that can help with a down payment, look up programs in your region, get in touch with lenders or mortgage brokers in your area, and fulfill the eligibility requirements by attending homebuyer education workshops.

That would increase the desirability.

DSCR lenders will run personal credit (which, along with LTV and DSCR, is among the three biggest factors determining your rate and terms) and typically require three to six months of PITIA “reserves” in liquid assets.

A desire and ability to share their knowledge4.