I am currently presented this opportunity of investing in a hotel (more specifically Adam's Mark) in Buffalo NY.

While I have seen deed restrictions that prohibited types of commercial [properties, types of residential properties, raising buffalo, and prohibiting sheep from grazing, I’ve never seen a prohibition against STR.so that leaves properties that are part of an HOA.  

In the Hudson valley rents are much higher than out by Buffalo, Plattsburgh, or Syracuse.

Maybe Raiders, or Chargers....they were the LA Chargers originally....but more likely a Buffalo type...or any team willing to piss off a lot of fans for the equity gain.

I'm a recent graduate from The University at Buffalo with a degree in mechanical engineering.

Buffalo to be exact. 

I played in the NFL with "The Dallas Cowboys, Buffalo Bills, and Baltimore Ravens".

Long story short I’m wondering if anyone has had better luck with smaller banks or different lending options in the buffalo area.

Developers are changing closed churches here in Buffalo into apartments.

Who can afford to pay those high rents especially that many people are leaving , but houses aren't, so vacancy rates are increasing.There is a lot to consider and I'm trying to get a feel of the place before I go there to see it for myself.What do you think about Western NY property markets ( Syracuse, Rochester, Buffalo) as these are also heavily marketed to overseas investors?.