I started looking in my area and am a beginner of real estate investment.Would you please tell me the reasons to have CPA vs a tax accountant.

It is in an up and coming area so my thought is that if it doesn't have the activity that we are looking for while trying to sell it, we would purchase it ourselves buying it from my dad/the Trust and then renting it out. 

I would advise against an "all-in-one" product but probably not a lot of time to go into that here so, let me just answer the question - try some local real estate meetup groups in your area.

By upgrading key areas and improving curb appeal, we significantly increased the property's market value.

I could also leave a unit within the multifamily property vacant when I am abroad to use for storage if needed, to better help solidify the "primary residence" requirement.This is a pretty specific question, so I haven't been able to find any previous posts on it or any helpful literature online.

I have a good attorney in the area I can recommend if you need.

Maybe into an area with more appreciation or cash flow potential. 

The cost for house inspectors is area dependent and you can look them up online.Thank you

We have approx $20M+ in assets and have spoken to some lenders about this and majority of them are a no.

You're on the right track considering using depreciation to offset your 2024 capital gains, but there are a few important details to consider.