The market is currently in a place where you're only going to succeed by doing what others won't.  

I'm open to other areas as well, but based on what my realtor friends say about where I live now makes we want to get my foot in the door here. 

The problem is that I don’t really know where to go from here - I’ve talked to the agent who wants to sell quick but don’t know the exact steps from here on out (it’s my first time doing anything in real estate).

Even in high traffic cities it can be tricky to keep occupancy over 85%, so you would have to be very competitive with your property to hit the 60% mark in my opinion where seasonality is so strong. 

What I did was to watch several YouTube videos from  that area where I want to invest.

I totally get where you're coming from.

I think it's important to explain that not all advisors/planners work for companies that push commission based products, but it sounds like that is where your experience was.But, I do agree that it's probably a good idea to separate those roles though... and not bundle a "jack of all trades" into your financial life.CPAs often look in the short term, and not the long term. 

Live in NYCAny upstate towns where I can invest for a good price?

This is where I live.

I am looking for additional capital to invest in remodeling, where can I get some funding if the property or business is in Mexico?