Investing in real estate is an excellent idea.

Find Brandon's videos on YouTube for the "four square" method of analyzing homes and practice.

If you are dead set on a HELOC you will likely need the following for an investment property: An excellent credit score (720 or higher), A maximum 80% loan-to-value ratio, Healthy cash reserves on hand, Sufficient income from tenants, Additional features that make the property attractive, like whether it has long-term tenants (Source https://www.rocketmortgage.com...)

With what I know now, I believe the best option would be to do a BRRR (with the exception that the property already has an assumable mortgage in place) as the rental income would be excellent (I believe it would currently bring$2500/month and will only get better.

I have made a couple of videos about this on my YouTube channel about this very thing because it happens all the time.

About an hour away from where I work is an area that would be an excellent airbnb location after my one year residency.

Excellent overview for us here in Houston, thank you

The Complete Guide to Buying and Selling Apartments is excellent.

I've seen some of the free webinars that BP hosts, and they seem to boil down to essentially the same content (not meaning to knock them, or disrespect them in any way): find deals, and run them through the BP calculator to evaluate them, and move on the ones that make sense based on your assets/market/numbers/etc.I've heard that there is a ton of video content once you become a pro member, and am thinking of pulling the trigger, and was wondering if they end up going more into depth or if they run through different scenarios etc.

Best if you start by watching the different investment videos here on Bigger Pockets.Have you figured out your investment goals yet?