I manage property in newark but i would recommend you self manage this as its 1 off. i can guide any way i can, shoot me a message.

Yes, this should make a good rental.Here's a guide that describes what good cash flow looks like and how to analyze a property.https://www.biggerpockets.com/blog/rental-property-cash-flow...

Hope someone expert in Real Estate can guide me1)Who act like qualified intermediary?

They can evaluate your specific case and guide you through the process effectively

I’m looking for a tax pro that will assist with understanding and maximizing deductions and business expenses, but also guide me through the cost segregation and accelerated depreciation process. 

Before investing here I suggest you read The Ultimate Guide to Grading Cleveland Neighborhoods to get yourself an understanding on the market.

A good way to get an understanding of how to get into STR is :STRATEGY: Start Up Guide to Short Term Rental Investing 

If you end up in Cleveland you'll want to read The Ultimate Guide to Grading Cleveland Neighborhoods to give yourself an in depth idea of the market.

Table 1-4 is the Rollover Chart in IRS Publication 590 that can guide you.

As for your specific scenario, I would encourage you to reach out to a professional to guide your tax planning activities ASAP.