But, I am not sure if it's worth buying given I will likely be losing money yearly and only gaining equity.

I have an investment that is selling August and I will have a large capital gain.

Do I pay taxes on the incremental gain each year? 

It sounds like a fantastic opportunity to network and gain valuable insights.

Your taxable gain / loss will be sales price less cost to sell less your adjusted basis.

I keep hearing ads about ConnectInvest for passive note fund investing.

I've gained valuable insights from a challenging experience with investing in a condo unit or a single family home.

With 22 years of appreciation, we would be just under the limit to exclude all capital gains if we were to sell right now instead of rent. 

.* Sellers who refuse to consider paying the buyer's agent commission will have difficulty selling* We will see discount agents / brokerages like we have seen for the last few decades and they still will never gain any significant market share* I am not sure if we will see agents move to a hourly rate of pay, if so I think we won't see that for a few years. 

It’s highly passive and there not much to do other than network and marketing.