Let’s say your filed of expertise is purchasing c type apartment t complexes and upgrading them to b, then holding to stabilization and once stabilized offering for sale.  

I always wanted to be in real estate as an investor rather then home owner.

If you did a full repipe and gutted the entire property then I assume (in all that means) that there were permits pulled and this should have been caught when the inspector did their rough in walk through or atleast the final occupancy inspection. 

Do I list the property as-is or renovate and then list?

Quote from @Neeta Agrawal: For context, we gave the tenant a 60-day notice for non upkeep and no repair communication in 2023 and then extended it for 30 days upon his realtor's request, setting the move-out for May 31, 2023.

Wow, you are firing off questions faster then I can read them and they are all good, but pretty general.

It is my understanding that people refinance and then use those funds other ways (personal living, investing, some to buy another property) as a means to minimize tax obligation. 

If it does vest, then the 2nd isn't currently $8k and the paperwork could further help your case.Other option is to completely ignore the equity in your residence and look for creative financing on the property you want to purchase. 

Or, plan on this being a nest egg builder and growing your equity, living in the home for 2 of the last 5 years and then selling with Section 121 exclusion. 

Then laws changed and SSN's became our IDs and we could no longer typically ask for them in my area as a landlord.