Call the utility companies to get historical records for anything that is owner paid.3. 

One last question, is 100K minimum investment for a note JV reasonable/common?

I think it is reasonable to include fixed, predictable expenses, like taxes, in your proforma, but numbers like utilities and R&M are best estimated using historicals.At the end of the day, the buyer will do their own underwriting and come up with a number that works for them. 

If you've been on here for a while now I'm sure you've seen the many great resources that are available.If you're looking to network or chat, besides the resources and connections here on BP, I'd also recommend attending a local real estate group such as Black Diamond REI in Mass. or RIREIG in RI.Also with your design and aesthetics background you might try networking with some stagers as you probably have a lot in common :)

I would expect the landord to pay for accommodations until the unit is deemed to have working utilities required to live.  

Property as is- where is.First, the sellers agent requests a copy of the appraisal which I was told by my lender and agent that it’s not common or recommended to share the appraisal and I’m not obligated to.

There are different types of restrictions but the most common is that a person or entity is given ownership once the current owner or beneficiary dies, but this is not the only trigger just a common one.

(Usually this happens when a new tenant is on-boarded, since the circuits with the common usage have already been in place.)

I got to Columbus by started broad with "Mid west", looked at a research article from ATTOM data to narrow it down to cities, and currently utilizing "Niche" app to look for good neighborhoods!

If you're buying something with tenants in place, verify they've been there for a long enough period of time (utility bills, etc.) so they're not just a set up.