Through friend that know that I am in the rental business, negotiation focused on making sure that there are no surprises, like large outstanding bills, lawsuit, legal problem, due to foreclosed condition.

You might find that there are restrictions you can't live with like prohibitions on parking a camper, boat or commercial vehicle - and even the colors you can paint your doors or shutters.Be sure to ask whether there are any pending lawsuits against the condo association or any special assessments in existence now or anticipated in the future.You shou;d also request a certificate of good standing from the condo association, meaning that the seller doesn't have any outstanding fines or fees. 

@Brad TarryYou can roll all or part of that old 401(k) to an IRA of your choosing, including a self-directed IRA that provides broader investment choices.IRA plans do not offer a participant loan feature as 401(k) plans do, however.If you are self-employed, you could potentially establish your own Solo 401(k) and then have access to the loan feature.If you will be joining another W-2 employer you could also potentially roll some of your current 401(k) into that plan such that you would have some capital from which to borrow.If you have an outstanding loan on your prior employer 401(k) that may need to be paid off promptly if you have terminated service. 

I'm also wondering which lenders provide good rates and turn-around times for setting up the HELOC (and should I go local or go with a nationwide lender).

The house was winterized in 2017 and the water was shut off due to outstanding water bill. 

Most national brokerages have an extensive network - nationwide and international - that the average develop/investor can not compare with. 

Most tax pros who work with clients nationwide (myself included) have clients who live, work, and invest in multiple states.As long as you work with someone who is either familiar with multiple state laws/regs or has the capability/resources to research the appropriate laws/regs, it should not be a challenge.Ultimately, you have to be comfortable with your team members and how they work.Happy to answer any other questions you may have!

I really have to hand it to @Joshua Dorkin , @Brandon Turner, and @David Greene for providing a superior unbiased source of information on the site and their outstanding Pod Casts!

We have outstanding debt of $10.635.000 and they are all with different banks. mix of multifamily, commercial, and single family. 

I have someone located with outstanding reviews on Yelp here in New York.