The question owners ask most is how to find the loans that are coming due across a whole market, or across a book of past clients, without reading one file at a time. The answer is to work from the recording date backwards. Every mortgage and deed of trust is recorded with the county, along with the lender name and, for most short-term loans, the original term. A bridge loan recorded 14 months ago on a 24-month term matures in about 10 months. Run that calculation across every investor-owned property in a county and the maturing loans sort themselves to the top.
A good list is filtered, not just sorted. Keep loans in good standing: no notice of default, no lis pendens, no tax lien recorded against the property. Those borrowers can refinance; the others need a workout, which is a different conversation. Then narrow by what you can actually place: investment properties held in an LLC or by a non-occupant owner, loan amounts inside your programs, and lenders known for short terms, such as private lenders, hard-money shops, and bridge lenders.
For your own past clients the same method works on a smaller scale. Pull every file you have closed or quoted, note the loan type and term, and flag anything that reaches maturity or a rate reset in the next six months. Most brokerages find refinance opportunities already sitting in their old pipeline, because nobody set a reminder for the day the loan comes due.