No one accountant is an expert in all areas in the tax code, so best to figure out what you want first in the world of real estate and then dive deeper there. 

I’ve got her dealing with 8 properties which have individual accounts.

I have some of the required funds in a HYSA, but will most likely need to draw from another account and I'm curious which method is the most efficient in terms of taxes/capital gains, penalties, loan repayments, etc.Based on my previous transactions in the market, I estimate ~$45k cash to close: $20k for the down payment, $15k for closing costs and prepaids, and $10k of starting reserves.

If you have a high 7 rate then it might be beneficial in the long run to pay it down if you don't want to put it in a 4% savings account or CD.  

Luckily this was all accounted for in my budget, but it was still a slow and expensive process. 

I once made the mistake of chasing multiple listings at once, which turned into a disaster.When I shifted my focus to serving one client at a time with honesty, integrity, and accountability, referrals started coming in without any marketing.

There are larger fluctuations in emotions as larger sums of money go in and out of your account.

While no property is too big or too small for a cost segregation study, it’s important to speak with your accountant to ensure the benefits outweigh the cost of the study.

However, after accounting for long-term capital gains tax and other expenses, you would be left with $150k which is important to budget and account for.

Loopnet has some comp information, but requires a paid (and not cheap) account to see it.Commercial properties are generally valued based on income, not comps per se.