DSCR loans are a great option for anyone that doesn't fit the conventional "box" - DTI isn't a factor, no employment info needed, no W2s, paystubs, tax returns, 1099s, etc. needed, you can close in an LLC if you want to and many lenders don't report to personal credit, so those loans won't affect your credit score/DTI for any conventional financing you might pursue in the future.

I would get ready for other options as well.

Zero credit facilities or mortgage options and investor lethargy.

Is there anything I can do to ideally get them to not list the house and sell to me, I’m assuming there might not be many options, especially since the sister and I had agreed on a price that was below market value given I was planning to invest money to remodel the home and was planning to honor his wishes of not having the home knocked down to make a townhome or new home.

Alternatively, I could hope that my next assignment will be in a better market with more options, maybe lower rates, and more cash on hand.Should I accept that no market is perfect and get in the game now, or hold out for a year to enter a potentially better market with more capital to invest?

Take all that out of the equation and you have two options.

By "partial" I mean renovating the kitchen and bathroom, painting the place, re-tiling the floor and maybe adding some smaller features that can make a difference to prospective buyers, such as new A/C units, new internal doors, or maybe even sell the place furnished (home staging is not really an option here); with no or minimal demolition, and hopefully without electricity or plumbing issues.

From what I was told by a Chase lender, most institutions use the same underwriters, who implement this 2 year requirement.I understand that private lending could be an option, however, I'm not sure who would lend to me with favorable terms based on my lack of real estate experience.

The land is currently  pretty much all. jungle would a 2 bedroom home be the best option or would you guys try to build 1 bedrooms 

The down payment option + traditional will most likely be lower.