Any guidance/ tips on how to proceed would be very appreciated. 

If you could find a duplex property (or a single family house that could be turned into a duplex--check any HOA restrictions first), or a "fixer upper" to live in, that could be a better use of the equity you have in the rental house.If you run the numbers and decide it makes sense to sell the rental house (check with your accountant, figure out closing costs to selling and buying) then you'll possibly have more money to put towards a primary residence.You may want to check the neighborhoods that fall in the school district you want to stay in and look in "under appreciated" areas...maybe not the A class neighborhoods, but ones that have potential of becoming "improved".While I understand your desire to stay in a particular school district, it's not the end of the world to consider other districts if they will allow you to build real estate/family wealth that will put your entire family tree in a better position."

The small spec builders are bringing hundreds of homes to the market in the next few months.

My goal is to eventually add/build a few more tiny homes. 

,It should be enough time if you have the right team to get you set to purchase a home and find the right property to house hack.

I'm a real estate agent that specializes in working with investors in a second-home market in the Northeast US.

My plan was to recast or refi a few months after we close on our current home.

Start with the statement you made that you think it might not be possible to purchase a home in your lifetime with your current income. 

This is about my 3rd analysis and I'd like to get some feedback on the report for this manufactured home.

They now have 5% conventional loans you can use on multi family homes now.