Search CMBS loans
search_loansReturns loans in public CMBS trusts that match your filters, largest balance first unless sorted, with the total match count and total balance. Use it to find a loan or property by name, address, city or ZIP, or to screen by status, type, state, metro, tenant, maturity, balance, coverage, occupancy, rate, vintage, servicer, originator or trust. All filters are optional and combine; no match returns an empty list and a total of 0. Use get_loan for one loan's full record and tenant_exposure to rank tenants.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "search_loans"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | Word starts in the property name, street address, ZIP, city, metro, state, property type or trust name, e.g. "times square", "825 Eighth Avenue" or "houston office" | |
| cbsa | No | Census CBSA metro code, e.g. 35620 for New York | |
| city | No | Whole city name, optionally with state, e.g. "Houston" or "Houston, TX" | |
| sort | No | Order | |
| type | No | Property type | |
| limit | No | Results per call: up to 10 free, 100 with a Pro or Team key | |
| state | No | Two-letter state or territory code | |
| trust | No | Only loans in this trust, by slug, e.g. "benchmark-2018-b8" | |
| offset | No | For paging: free stops at the first 25 results; Pro and Team page through everything | |
| status | No | Loan condition, or a Schedule AL status as filed: foreclosure, reo (real estate owned), forbearance or extended (a modification dated in the last 24 months) | |
| tenant | No | A tenant named among the three largest, e.g. "Walgreens" | |
| vintage | No | Origination year, e.g. "2021" | |
| max_dscr | No | Maximum latest DSCR, e.g. 1.0 | |
| max_rate | No | Maximum current interest rate, as a fraction or percent | |
| min_dscr | No | Minimum latest DSCR, e.g. 1.25 | |
| min_rate | No | Minimum current interest rate, as a fraction or percent: 0.05 or 5 | |
| originator | No | Originator, or part of the name, e.g. "Wells Fargo" | |
| max_balance | No | Maximum balance in dollars | |
| min_balance | No | Minimum balance in dollars | |
| max_occupancy | No | Maximum latest occupancy, as a fraction or percent | |
| min_occupancy | No | Minimum latest occupancy, as a fraction or percent: 0.8 or 80 | |
| maturing_after | No | YYYY-MM or YYYY-MM-DD | |
| maturing_before | No | YYYY-MM or YYYY-MM-DD | |
| special_servicer | No | Trust's special servicer: finds loans in trusts whose general special servicer is this name, or part of it, e.g. "Rialto". A given loan may be serviced by someone else |