{"uid":"cap_OjdYs0oSBaCStL115e2bG","slug":"locus-cmbs-maturity-wall-a223b80c","name":"Locus CMBS Maturity Wall","description":"SEC ABS-EE filings for county public CMBS debt maturing in 6, 12, 18, and 24 months, grouped by property type, plus special-servicer debt. For agents checking a maturity window. Months start at the filing reporting period, not today; no match does not prove there is no loan. npx @velinussage/locus-agent-skill add.","url":"https://api.locus.report/api/locus-cmbs-maturity-wall?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"address":{"type":"string","maxLength":200,"minLength":5},"countyFips":{"type":"string","pattern":"^\\d{5}$"}}},"responseSchema":{"type":"json","example":{"kind":"cmbs_maturity_wall","loans":1,"buckets":{"m0_6":{"loans":0,"balance":0},"m6_12":{"loans":1,"balance":45100000},"m12_18":{"loans":0,"balance":0},"m18_24":{"loans":0,"balance":0},"m24plus":{"loans":0,"balance":0},"pastMaturity":{"loans":0,"balance":0}},"caveats":["Example artifact; not live data. County figures are as filed and partial, not a complete debt inventory."],"charged":true,"sourceUrl":"https://www.sec.gov/Archives/edgar/data/1707817/000188852426013923/exh_102.xml","countyFips":"36061","sourceName":"SEC EDGAR ABS-EE Exhibit 102","byPropertyType":{"MU":{"loans":1,"balance":45100000}},"currentBalance":45100000,"reportingPeriodEnd":"2026-07-13","specialServicedLoans":0,"leaseBeforeMaturityLoans":0}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.25","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.25/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.25","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.25","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_OY2YSb5Qx96tSTG-IigIl","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.25","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Returns SEC ABS-EE CMBS debt maturing in 6, 12, 18, and 24 months for a county, grouped by property type and including special-servicer debt","exampleAgentPrompt":"Can you pull the CMBS maturity wall for the county covering 123 Main Street, Chicago, IL — I want to see what commercial mortgage-backed loans are coming due in the next 6, 12, 18, and 24 months, broken out by property type?","exampleUseCases":[{"title":"Office market refinancing pressure check","prompt":"What CMBS loans are maturing over the next two years in the county around 350 Park Avenue, New York, NY? I'm trying to understand office loan refinancing pressure and want to see it broken out by property type including any special-servicer debt."},{"title":"Retail distress signal for acquisition underwriting","prompt":"Before we put in an offer on a retail strip center in Maricopa County (FIPS 04013), can you pull the CMBS maturity wall so I can see how much retail debt is coming due in 6 and 12 months in that market?"},{"title":"Market-wide CMBS exposure for county lender report","prompt":"I need the full CMBS debt maturity picture for Harris County, Texas (FIPS 48201) — all property types, all time windows through 24 months, and any loans that have moved to special servicers."}],"resultDescription":"A structured dataset of SEC ABS-EE CMBS loan maturities grouped by property type for the requested county, segmented into 6-, 12-, 18-, and 24-month maturity buckets from the filing's reporting period, plus special-servicer debt. Note that months are measured from the filing reporting period, not the current date, and a null result does not confirm the absence of a loan.","failureModes":["Neither address nor countyFips provided — request rejected","Address cannot be resolved to a county FIPS — no results returned","County has no matching SEC ABS-EE CMBS filings — empty result (does not mean no loans exist)","FIPS code format invalid — must be exactly 5 digits","Stale filing data — maturity windows based on last SEC reporting period, not real-time"],"whenToPreferThis":"Use this endpoint when you need structured CMBS maturity exposure data for a specific county, segmented by property type and maturity window, sourced from official SEC ABS-EE filings. Prefer this over generic real estate APIs when the use case involves debt market analysis, refinancing risk assessment, distress signal monitoring, or commercial underwriting research at the county level. It is especially useful for understanding the 'maturity wall' — concentrated debt coming due — which can signal market stress or opportunity.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T06:43:01.257Z","isFirstParty":false,"canonicalSlug":"locus-cmbs-maturity-wall-a223b80c"}