Ideally, I would like to sell both homes, and build a new home that has an in-laws set-up, where they would live. 

Remember, there are many hard money options available to you, this is one lender.

Ideally, you use bullnose tile along those edges, and you choose field tile for which bullnose is available.I am not a fan of this, but I also have seen this problem solved with wooden, painted moulding on the edge of the tile, outside of the shower door.

They’re ideal tenants who look after the place like it’s their own.

Hello, I found I deal I would like to purchase but need some help finding financing.

And remember govt backed mortgages (Fannie Mae, etc) forbid STRs, so be careful on length of stay. 

Remember, when speaking to an Advisor they get paid by what you invest in but they have to give you a Prospectus of the offering which allows you to do your own due diligence. 

Remember that this is only one strategy to sell a home, and you are in the driver's seat.

IVE WANTED TO START INVESTING IN REAL ESTATE SIMCR I CAN REMEMBER AND NEVER GOT STARTED ..... 

I am based in northern California (Fremont), and would ideally like to find MLS search service that is not restricted to a certain region/a few counties since I plan to invest in central valley/Sacramento/Fresno/Turlock/Tracy area in California.