# cmbs_get_loans Fetch one registered CMBS deal's loans, collateral, and latest performance. | Field | Value | | --- | --- | | Category | CMBS (`cmbs`) | | Exposure | public | | MCP tool | `cmbs_get_loans` | | Documentation | https://www.agentdatasets.com/docs/tools/cmbs_get_loans | ## Description Fetch one registered CMBS deal's loans, collateral, and latest performance. `data.loans` is in prospectus loan-ID order: numeric asset IDs sort numerically, followed by occurrence sequence. Each loan includes origin terms/indicators, filed-order properties with location, valuation, occupancy, NOI/NCF, and DSCR, plus its latest available performance period with balances, payment status, and servicing fields. Exact decimals serialize as strings. Numeric objects carry `unit`, `currency` where monetary, `accession_number`, and that document's `as_of`; loan, property, and period records also carry their own accession/as-of lineage. A resolvable property includes `geography` with `geo_key`, `level`, `name`, `resolution`, `state_geo_key`, `county_geo_key`/`county_name`, and `cbsa_geo_key`/`cbsa_name`. Resolution `zip` means an exact ZCTA match; `state` means the ZIP was absent or unmatched and the filed state supplied the fallback. The key is omitted when location evidence is unresolved or ZIP and state conflict. The county is the ZCTA's dominant county by Census land-area overlap, and its CBSA follows OMB delineation. Use the pivot keys with other geography-aware tools—for example, take `cbsa_geo_key` and call `re_search_series(geo_key=...)`. This is deliberately per-deal, not cross-deal search, and returns only the latest period. Full history is future `cmbs_get_loan_history` work. The default limit is 25 and maximum is 100. Pass `next_cursor` back until `has_more` is false. Errors are `bad_parameter` for malformed filters/cursors, `unknown_entity` for an unregistered deal (with up to five suggestions), and `out_of_coverage` for a registered deal whose EX-102 loans are not ingested. Filters with no matches succeed with an empty list. Example: `cmbs_get_loans(deal="Benchmark 2020-B20 Mortgage Trust", property_type="OF", state="IL", limit=25)`. ## Parameters Input schema advertised to MCP clients and mirrored by the REST query string. | Parameter | In | Type | Required | Default | Constraints | Description | | --- | --- | --- | --- | --- | --- | --- | | deal | input | `string` | yes | — | min length 1 | Exact registered trust name (case-insensitive) or all-digits CIK. Use cmbs_search_deals first when the exact deal identity is unknown. | | property_type | input | `string \| null` | no | null | min length 1 | Optional case-insensitive exact SEC propertyTypeCode on any collateral property. SEC codes: CH=cooperative housing, HC=healthcare, IN=industrial, LO=lodging, MF=multifamily, MH=mobile home park, MU=mixed use, OF=office, RT=retail, SE=securities, SS=self storage, WH=warehouse, ZZ=missing information, 98=other. | | state | input | `string \| null` | no | null | min length 2, max length 2 | Optional 2-letter state or territory code, matched against any collateral property (case-insensitive). When property_type is also set, both filters must match the same property. | | payment_status | input | `string \| null` | no | null | min length 1 | Optional case-insensitive exact latest-period SEC paymentStatusLoanCode: 0=current, 1=30–59 days delinquent, 2=60–89 days delinquent, 3=90+ days delinquent, 4=performing matured balloon, 5=non-performing matured balloon, A=not received but within grace or not yet due, B=late but under 30 days. | | limit | input | `integer` | no | 25 | min 1, max 100 | Prospectus loan-ID-order rows per page (1–100). | | cursor | input | `string \| null` | no | null | — | Opaque pagination.next_cursor from the previous response; keep deal and filters constant while paging. | ## Provenance - `sec-edgar-abs-ex102` — U.S. Securities and Exchange Commission (EDGAR), CMBS EX-102 asset-data documents archived verbatim for lineage and normalized into loan, property, and reporting-period records (SEC public-record dissemination; 17 U.S.C. § 105 covers SEC-authored material, and filer-submitted factual disclosures are disseminated publicly through EDGAR). See https://www.agentdatasets.com/docs/attribution.md