There are several reputable turnkey companies that could be a good fit.

Just ask around and find one that fits what your goals are 

Once you determine that you can start thinking about what house fits your crietra. 

You might be able to make it a ADU but then you’ll have to live there which doesn’t fit with your plan to move out. 

So we know there must be issue will all these systems but the house fits my family needs and we can turn additional space into an apartment for rental.What option do we have besides walking away ?

Unless you find a deal that fits the strategy the juice probably isn't worth the squeeze. 

It located North of Boston and is an oversized lot that if approved, would need a variance on frontage, but will meet all other dimensional regulations in our zone and not to mention after it being built, it will "fit-in" with the rest of my neighborhood. 

@Mike SchorahAs a person that is currently heavy into trying to find a property that fits the Brrrr standard in Ohio I am having a lot of trouble finding one, but I do come across a lot and I mean a lot of turnkey properties.

Rehab center probably wouldn't be a good fit with your hotel next door. 

Thank you for your response, I had also wanted to ask what would typically be the loan rate for someone in my position, and also which types of loans would be the best fit (FHA, investment property loan etc)?