My son is also shipping out on July 24th, from Phoenix, Az, and I am excited for him, but also sad that he's leaving, and nervous and anxious, so it's causing a lot of emotions for me as a dad right now. I'm glad I found this forum, as well as some Facebook groups that I just learned of within the past week, as there seems to be lots of helpful information being shared, and that's great to have available to the family and friends of people going to boot camp!
Btw, one of the Facebook groups is called 'USCG Family and Friends' and you should be able to find it by doing a simple search on Facebook. Also, from what I was told, the unit for people shipping out on July 24th will be 'USCG Whiskey 194' and there's also a Facebook group for that unit, which you can find by searching for it on Facebook. You will need to request to join each of these groups, and answer a couple questions, and then need to be approved by someone to actually join them. If you are a family member/loved one of someone going to boot camp, I would definitely suggest checking these out.
Good luck, and much happiness and success to y'all and your families, fellow Coasties!