They will normally pay it off during the redemption period. 

Examples of short and long term uses, HELOCs & CES.HELOC(Short Term)- Use a portion or all of the HELOC now knowing you're going to pay down quickly, which eliminates payments and interest.HELOC(Long Term)- Many HELOCs have 10 year interest only draw periods, while CES have a P&I payment, HELOCs may have less impact on cashflow over the long term.- Perhaps you think rates are going to move lower.

Is there a redemption period?   

You're essentially loaning someone $100, 000's of dollars at no interest for an undetermined period of time with no guarantee of getting it back, right?

Currently, when I include both refinance and sale proceeds, I get an unrealistic XIRR of 49%, while the average cash flow throughout the investment (7-year hold period) sat around 8%, and this seems incorrect to me. 

As my avg rental period is <8 days, and I have <14 days personal use at the property and believe I can meet the material participation test, this should be a non-passive activity.Specific Questions on Material Participation:1) Do hours logged for material participation in 2022 include time prior to placing the property in service (i.e. first half of 2022)?

The redemption period has expired four months ago.

We're considering our options for moving forward.Numbers:Purchased for ~ $230,000 (2.5% interest)Remaining balance ~ $220,000Appreciated to ~ $400,000Cash flow is ~ $500 a month after setting aside for all reservesOptions we're considering:1- Cash out refinance- at current market rates, rough estimate is that we could access close to $100,000 in equity, but our cash flow would go to $0 or possibly negative for a period.2- Sell now - if we sell before the end of the summer, we could still qualify for living in the property for 2 out of the last 5 years for the additional tax benefits.

So for us if we can pay it back in 2 years or less, we will write off that interest and have it paid back in that period and look for the next deal. we find that if it doesnt pass our heloc test it wont pass  our SDIRA test...

They have high loan amounts and a very long draw period and long pay back period.