"As-is" simply means that the seller has no intention of negotiating beyond the initial offer.

In regards to your question about this scenario, we simply need more info.

In our eyes, a tenant that is simply renting the unit can gather their things and leave whenever they want, so the way to determine if they really have a vested interest in staying long term or not starts with them owning the unit. 

Simply call and ask how many bedrooms, when was the kitchen last updated and what work needs to be done to fix up the house.

Not to be insensitive, but is the $750k/year asking price beyond what you're able to afford today because of the lack of a down payment that could be solved via seller financing? 

The kind of problems you need to search for and that are not visible by simply visiting the property with your contractor. 

At the end of it all, I could be wasting 5, 6, 10 years.I do not have systems in place for short term so that seems to be the longest shot considering the lack of upside.I am not liable for capital gains on this property so that’s the biggest draw as well as freeing up the capital.

I understand the attachment, and going from an owner to a renter can feel like a step down, but a lot of times it is simply the wisest move for your  future financial position.

Shoot me a DM if you want more clarification on this - I plan on writing an article on this topic in the future, due to all the discussion I see around the topic.This isn't legal advice, but simply my own thoughts as an investor on the issue you are facing.

It’s used as filler because the gurus ideas about where and how to find deals are so lacking in accuracy or specifics.