The most important thing is to ensure your loan is covered in the event of a loss.  

Jay,You mentioned total loss on syndication deals. 

After some research online, I am reading that the cost per square foot on a gut renovation of this nature in Stamford CT is anywhere from $150-$350, which is ultimately not very helpful, because at $150 per sq ft, this is a very appealing project with a total profit of ~$175K (46% ROI) and at $350 per sq ft, it very much isn't, because it would be a net loss of 83K (haha).QUESTIONS:What can I do refine my estimate a bit given that I am not allowed to a formal inspection on the property? 

You must work at least 750 hours per year in a qualified RE business.So most people who have high-earning W-2 jobs outside of real estate won't qualify.But the unique thing about RE pro status is that even if you don’t qualify but your spouse does, you can both file jointly and claim the losses from your RE investments to offset your other active income together.It's an incredibly powerful benefit if you do meet the criteria.

@Harsaha LenkaI looked at the OM and it’s missing vacancy and collection loss and repairs and maintenance.  

If this is not something you're interested in delving into and learning to a high degree, then investing in publicly traded REITs would be another good option for you, which have historically returned about 13.5 per cent Per year over the past 50 years (1977-present), beating the US stock market by two per cent and even beating private real estate investing by 4 per cent (that's compared with the average real estate investor, not the experts here at Bigger Pockets).

They are now selling resulting in a 100% loss for investors. 

I'd focus on deciding what you want to do (flip-high risk, but potentially high return...or large loss; short term rental-more work, but higher return than long term rental; long term rental-less work than the other two, but lower return).Once you've decided which you want to do, then focus on getting the best house to meet your goal. 

This is advertised as a “protected” note as Aloha is supposedly fronting the first $100k in the line of loss.

So many options that we are at a loss.