Out of the four properties , there is one solid tenant, the other is struggling and the last two  properties are not renting.

I agree 100% and this is also a struggle for many investors.

It should be from someone who uses that person.

The building had seen better days and was struggling to attract tenants due to its outdated design and inefficient use of space.Architectural InterventionSpace Reconfiguration: We conducted a thorough analysis and proposed converting the building into mixed-use space.

Think Good Deals Are Hard to Find? Let’s Change That in Just 5 Days!
Hey BiggerPockets Community!
Finding great off-market deals can feel like a needle-in-a-haystack challenge. Whether you’re a new investor or a sea...

Ownership demand here seems to heavily outweigh tourism demand and i'm struggling to get anything to pencil.  

It has been good to be brought down to reality and realize that there will be many struggles during the process.

I know several investors that are struggling to keep their short and mid term rentals going.

Here’s why some people struggle and how to fix it:1️⃣ YOU’RE SETTING UNREALISTIC EXPECTATIONSYou’re not going to close every deal.

I personally have success in doing flips with my partner here in Ohio.Lakewood and Edgewater are gentrifying neighborhoods in Cleveland.