However, if I earn too much “earned income,” I risk losing these essential benefits.That’s why I’m exploring real estate and the stock market, as these generate “unearned income” and allow me to maintain my benefits while building financial security.

I've read a few guides about turning the main on gradually, going fixture to fixture one at a time, etc.

Quote from @Carlos Lopes: Gross income doesn't matter.This is the number most people post, and it's 92.7% useless.What you need is NET income, meaning the money left over after all expenses, and that should include a dollar amount for your personal time spent operating the business. 

I've got my long term goal....retirment income in 10-15 years figured out, identified and traveled to a few markets I think could work. 

Having bad tenants is not something you would like to have, thus make sure the tenant has sufficient income, credit, and who they are.

They also get financial help from the city since they help to see low income patients.

Option A (continue renting) offers stable, inflation-protected income and potential appreciation, but managing the property may impact your retirement comfort.

So i have pretty sizable personal assets, along with a relative high income. 

Asking Price 6,795,000 Gross Rent 611,436 Operating Expenses 233,142 Additional Income 35,800 Net Income 414,094Questions- How do I find a multifamily lender who can help me fund this purchase?

Yes, you do get income on the other side, but the prices have bumped up so with interest rates and less inventory to buy, the net income is much less than a few years ago.You can still do it, you just have to factor that in and expect negative cash flow while you live there and then see how good it will be when you leave in a year and do it again.