A real estate developer rented out my family’s backyard and put up scaffolding to build a building complex in Queens, New York.The developer and my family signed a contract allowing them to use the backyard.

The real work does come in with driving around like you mentioned, maybe being creative and showing properties they may not have thought of, and articulating different ways to offer on a property, just to name a few items.

I'd like the home for a personal residence so I contacted this lady, apologized for her financial difficulties and told her I may be able to save her credit and take the home off her hands.

Keep doing what you are doing and in 10-15 years (your retirement timeline) you'll have a ton of equity built up to turn into whatever cash flowing investment you want at that time (real estate or otherwise). 

I either want to sell it or get my equity out without dealing with my personal credit and a mountain of paperwork. currently a nightly rental as we are a historic hotel.open to discussing my options. also there are other commercial investments on the property to include the building of another restaurant /bar/ cocktail lounge our land. major investment opportunity.who can help me? 

You could house hack a few Cleveland multifamily properties, then make your way to Columbus, which is one of the top real estate markets in the country. 

As the title says, what would be the NAICS code for a Real Estate Holding LLC?

I found the deal through a family friend who is a real estate agent.

What are the tax implications for a Canadian investing in US real estate? 

After the fix I want to put it on the market so I can pursue other real estate opportunities.