As mentioned by @Chris Mason, Bridge Loans: These short-term loans can provide immediate financing until more traditional financing becomes available or until the property stabilizes and becomes more attractive to lenders.Interest rates and stipulations may be a pain.Out of the box here and requires a few more research, SBA Loans: Small Business Administration loans can be an option, especially the SBA 7(a) loan program, which can be used for hotel acquisitions.I heard someone  mention - Mezzanine Financing: it involves a combination of debt and equity financing, which might appeal to some investors looking for higher returns.

Position these as limited-time deals to attract budget-conscious travelers.Be Responsive and Personable: Guests often book based on their interaction with a host.

Address Your Financial ProfileBridge the Revenue Gap: Highlight your equity in the duplex and use your sale proceeds to demonstrate “skin in the game.”Partner to Compensate Experience: A financially strong and experienced partner can help offset your limited track record.Focus on the Land Deal: Secure the land at a good price, as it’s a crucial step in gaining credibility and attracting partners.Final ThoughtsYou’re entering an exciting and impactful space in real estate development.

Spend what’s needed to upgrade with reliable mechanical systems, roof that doesn’t leak, remediate all mold; interior design modernized; in other words a place that will attract a higher income no hassle tenant.  

Beachfront or properties near attractions tend to perform best.Mid-Term Rentals (MTRs): These are gaining traction, especially with traveling nurses and remote workers.

It always sounds attractive. $300 a month for leads?

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!

Build a strong brand, leverage content marketing, and establish a personal brand to attract investors and build credibility.

As I am new to this and looking for cashflow using rentals, one key aspect of this investment is to ensure that the unit rents out quickly and while I do understand that cash flow to begin with might not be attractive, it can be a good investment in the long run if the location is right(as appreciation also kicks in).

The better theming will attract a higher quality customer that understands the value.