A local BOCES college built a 900 sq ft 'modular' home & auctioned off for $42,000 & I bet we could have built it for half that.

I bet the folks that are financially free via REI will often have a different outlook on this subject from those that are depending on a job and are just collecting real estate.

(sport court, lake, indoor golf and some amazing pools).

You bet, Justin!

Honest opinion - this seems like a great opportunity for you with 70% LTV at 5.5% for a property this type/size - I would be very very careful if you need to get the other 20% as a relatively new investor - someone willing to lend the remaining 20% could easily take advantage or come up with terms that could cost you - definitely depends on the further info - but tapping the equity of your current rentals and taking down the full 30% equity stake in this acquisition would probably be the best bet

Hard money where they finance the purchase price plus 100% of the renovation budget is your best bet.

One thing to note is by paying it down, it can hurt liquidity so if that is an issue, keeping it in a bank account would be a better bet, but if liquidity not an issue, then I agree 100%

Something like EaDo, midtown, maybe a small fixer around the heights (more heights adjacent than heights proper due to the budget) that is not betting on the neighborhood turning make the investment work.

Your best bet would be to call an insurance agent and ask for a quote.

You're just a bad bet, and the longer you stay, the more pervasive your stench will be in the unit.