I would like to get into house hacking another small multifamily as soon as possible.

This isn't to say you can't flip properties part-time, but it will come with challenges.

Here are the key details of my situation:Rental Property Details (Note: This was our primary home till 2017):Current Value: $970,000 to $1MPrimary Mortgage Loan Balance: $505,000 (@ 2.6%)Took Home Equity Loan on this house to make down payment for my current primary residence.Home Equity Loan Balance: $123,000Total Loan Balance: $628K (Primary Mortgage + Home Equity Loan)Rental Status: OccupiedPrimary Residence:Purchased in 2022Mortgage Rate: 7.3%Current Loan Balance: $650KMy goal for 2025 is 2 fold: #1.

I noticed you are interested in house hacking. 

If it is a high end housing product you may have to use a designer because they have access to some material/finish suppliers that are otherwise unavailable but that tends to only be for the highest end housing deliveries.

The property is zoned as a SFR house and likely in a neighborhood of the same.Was the property not appraised by the bank when you got your mortgage?

Flipping homes?

 I am a relatively new house flipper. 

Quote from @Scott MacComb: I am doing my first true house flip (have remodeled plenty of houses for rental) and am trying to figure out a contract to use with a new general contractor whom I have not worked with previously. 

The house is a smaller colonial with 3 beds and 1.5 baths.