Thank you in advance for any information/guidance to this scenario 

Hey Alon,I don't think there is a map on Columbus here on BP but I can give you some information about the neighborhoods here and some hot spots.

Myrtle Mike,  We're in the process of researching condotel lenders and would appreciate any referral information you may have to provide.  

The information contained in this post is not to be relied upon.

Has anyone ever worked with these banks? If you have please send your experience and what loan you got there. It would be greatly appreciated. 

Check out the exceptions to the law as it does not apply to all rentals:https://www.nyc.gov/site/hpd/services-and-information/good-c...If it did apply to you, month-to-month agreements would still allow you to do rent increases any time.

For example, sharing details like an example property address, how much of your own capital you're able to contribute, your goals for the property, and what your exit strategy looks like can all help potential lenders better understand the situation and make informed decisions.

If there is any information that I missed, please let me know I can explain our situation further. 

An agent can provide information and guidance…an investor is still in charge of making the decision to buy or not.

That is what I did here when I started investing in 2020.Here is an article with more information on what a house hack is www.rocketmortgage.com/learn/house-hacking