I like targeting outside of where I would live for SF and small MF (1-4 units) because of the lower entry price, usually higher cash flow since your rental income is higher relative to your debt service, and your appreciation potential is high if you can read the writing on the wall.

Quote from @Christian Styles: Potentially able to help you find someone but I would need to know specifically where the property is in order to know who to recommend.  

You can find tons of cash flowing opportunities here and you get amazing appreciation potential as well.

Before purchasing a rental property carefully evaluate the appreciation potential.

With so many companies like Intel, Meta, Amazon, etc. moving and developing here, the population and job market are growing so rental demand and appreciation potential are strong. 

.- Many of these HCOL areas also have strict limitations on AirBnB or short-term rentals... that do not apply to owner-occupants - thus allowing for extreme cashflow potential for house-hackers.

I really wish BP does a better job at monitoring scamming post like this. 

To minimize capital gains tax on the sale of their primary residence, your in-laws can utilize the $500,000 capital gains exclusion, potentially explore an installment sale to spread tax liability over several years, or consider converting the property into a rental to use a 1031 exchange for tax deferral eventually.

This is where I'm very inexperinced and don't understand what is standard for industry or what could potentially bite me down the road.

Alternatively, restructure the loan with equity participation for potential capital gains treatment at lower rates.