Active operators are far more likely to succeed in the entry level SFH space and that's not who buys entry level homes from turn key operators. 

He’s got a solid reputation and is an active member of the local REIA.

We did this through our LLC, I was actively managing the project while my brother was passive. 

I am actively expanding my STR consulting business!

One who is active still and recently did a case study write up like this is Don Konipol, the other pops on every now and again and did a BP episode many years ago Aaron Mazzrillo so search those two names and read some threads.A more likely scenario is not what you mentioned as the ever growing note/value deal, at least not as outlined.

When we moved, we turned it into a rental, hoping this would be the start of our real estate journey—something we’d like to continue once my husband retires.Some key details:My husband is active duty and will retire in 3 years.We have one final move coming up this summer to Raleigh, NC.Our current debts are crippling us—the high interest makes it tough to stay afloat every month.The plan I proposed to my husband:Sell the rental property.Use the proceeds to pay off all our debts, set aside emergency funds and a down payment for our next home.Free up $1,500/month from debt payments, and that also can stash in a high-yield savings account.Regain full VA loan entitlement, allowing us to purchase a multifamily home and use the house hacking strategy for up coming move.Avoid capital gains tax, since April marks five years of ownership, and the tenant’s lease ends in May.This wasn’t our original plan, and we hate the idea of using our equity to pay off debt.

One is humid and one is dry, the types of activities to do are different in each city, take a look at where you would be the most happy as well if you're going to be living there!

However, the tax treatment differs between short-term and long-term rentals:Short-Term Rentals (STRs): If you materially participate (work 100+ hours and more than anyone else on the property), you may be able to offset rental deductions against W-2 or other active income, offering greater tax benefits.Long-Term Rentals (LTRs): If your AGI exceeds $100K, your rental losses may be limited, unless you qualify as a Real Estate Professional (REPS).If you plan to expand your rental portfolio, consider an LLC later for liability protection and easier management.

Because you are not changing the tax return that reports the activity of the property.But... the IRS holds the position that Husband/wife LLCs can only be disregarded in community property states. 

@Barbara Radke Social media is an incredibly powerful tool.