The agent will normally update the MLS with the sales info as it's a requirement for being a member of HAR and having MLS access.   

If you would like I can help you run comps since I have MLS access and I am trying to do the same at the beginning off the year and would love to follow your house hack journey :)

The lot is about 7ksqft, flat, with easy access to the back portion – we can add another unit, or 2 if we can purchase a portion of a nearby lot or the alley.

If you are planning on doing substantial work on the units and making them unlivable (no access to a bathroom or kitchen), there should be a provision for that allows you to evict them due to an unlivable remodel. 

With a direct lender, you have more access to the underwriters and control over things when they are in house.

I will give everyone access to this for free for a whole.So just an FYI.

You could access your equity with a HELOC and use that for all the costs of a private mortgage.

This is a great forum with very knowledgeable members that will help to guide you in the right direction.I really like the alerts feature that can quickly guide you to current topics that may be of interest: http://www.biggerpockets.com/alertsThere are a few self-contained guides that you can access here: https://www.biggerpockets.com/guides

My purpose of this post is to find a strong, reliable Real Estate Agent in my area looking to grow their own business, and who'd be willing to help partner with me on future deals and provide access into their MLS portal so that I can focus on acquisitions (finding off/on-market properties) to then shop to the end buyers/investors on my list.

No other times are people allowed access to the property.