Hi Michelle!
First of all, glad you're looking into investing in Real Estate. There is a lot of benefits to owning property (cash flow, tenants pay your loan, it's a physical asset, etc.), but I think you're running into the hardest part of investing in Real Estate:
There are a lot of options to invest in RE.
This is either a blessing or curse, and your case, because there are so many options, it's a curse haha. To navigate through that trouble, pick one, figure out the numbers behind it, and COMPLETE the goal.
For instance, if you really want to take care of your kids (and have them learn the business firsthand), I would recommend finding them a house hack. You can put low money down, they learn to go through lease applications, how to manage tenants, etc. I'm currently looking for my 4th house hack, and honestly it's the best move I've ever done!
I think you should think about what to do with the second home, especially if it's worth $500k right now. Can you HELOC it and use the money towards a down payment on a rental? If so, in which market do you have an unfair advantage? I always ask my clients "Where do you have an unfair advantage?" so they don't have to start from the drawing board (which market do you know personally? Do you have a realtor/property manager there already? Are your friends investing there?).
Be conscious: If you sell your property, that's a gnarly capital gains tax. You should educate yourself to get a 1031 exchange or invest in opportunity zones if you sell that home.
Hope this is a good starting point! Let me know if you have any other questions :)
Ian