Is there a book or resource that I could use to increase my knowledge on residential home design?

A coach house could be 700-1400sq feet as the footprint of the CH has to be 700sq ft, but maybe some builder creates an affordable CH design for the inevitable demand coming.This should increase property values of current owners even if they haven't utilize the conversion or CH because a future owner could monetize that.  

Those vehicles are designed for large multi-partner funds primarily to raising capital, which it does not sound like is your goal.You should probably ask yourself if there are specific guidelines or wishes that you would like to be fulfilled as you pass your property to your heirs.

Maybe you like to design a house so ask an Architect if you can help on the weekends, ask a property manager to let you shadow them for a month and learn all their tricks.

They are designed to encourage investment in underdeveloped / undeserved areas to spur economic growth. 

You can update the lighting and plumbing fixtures, fix any drywall or plaster repairs and do your best to keep the finishes and design to the era of the house as possible.

I have a single member LLC with a S-corp designation that I use for flipping.

I am renovating/updating the layout of the upstairs and designing the house layout so the downstairs is a rental.

My request of you - any input on this exercise design or other practices that can be done to get from a foundational level of real estate investing knowledge to intermediate and ultimately expert.

@Brad Haughton  Although not in the same domain, there is a design principle called "Separation of concern" in the world of software engineering.