Screen Commertize offerings by criteria
search_offeringsScreen public investment offerings by text, asset class, geography, status and numeric ranges. Filter by cap rate, IRR, equity multiple, hold period and ticket size, with disclosed values only.
Instructions
Screen the public Commertize offering set: free-text search plus asset class, geography, status and exemption filters, plus inclusive min/max ranges on cap rate, year-1 cash-on-cash, target IRR, equity multiple, hold period, lockup, offering size, minimum ticket and SPV leverage, with sorting on any numeric field. Rates are DECIMAL FRACTIONS (0.06 = 6%). Undisclosed values never match a range filter and are returned in excluded_not_disclosed rather than silently dropped; field_coverage reports how many candidates disclose each figure at all, so an empty result is explainable. Public data only, filters narrow the public set and never widen it. Informational reference data — not an offer, solicitation, or recommendation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| city | No | City substring, case-insensitive — some listings name two towns. | |
| limit | No | Maximum offerings to return after filtering and sorting. | |
| order | No | Sort direction. Default desc. | |
| query | No | Case-insensitive substring over name, city, state, sponsor name and asset class. Applied locally to the fetched public set — not a search index. | |
| state | No | US state code, e.g. "WA". Exact, case-insensitive. | |
| status | No | The public set only ever contains these three statuses. | |
| sort_by | No | Numeric field to sort by. One of: cap_rate, year_1_cash_on_cash, target_irr, target_equity_multiple, preferred_rate, hold_period_years, lockup_months, token_price, tokens_for_investors, target_raise, min_investment_amount, implied_equity_valuation, effective_appraisal_value, spv_leverage_ratio. Offerings that do not disclose it sort LAST in both directions. | |
| sponsor | No | Sponsor id (exact) or a case-insensitive substring of the sponsor name. | |
| exemption | No | Exemption code, e.g. "RULE_506_B", "RULE_506_C", "REG_A". Exact, case-insensitive. | |
| asset_class | No | Asset class code, e.g. "MULTIFAMILY", "HOSPITALITY". Exact, case-insensitive. | |
| max_cap_rate | No | Maximum cap_rate, inclusive. Undisclosed values never match. | |
| min_cap_rate | No | Minimum cap_rate, inclusive. Undisclosed values never match. | |
| max_target_irr | No | Maximum target_irr, inclusive. Undisclosed values never match. | |
| min_target_irr | No | Minimum target_irr, inclusive. Undisclosed values never match. | |
| max_target_raise | No | Maximum target_raise, inclusive. Undisclosed values never match. | |
| min_target_raise | No | Minimum target_raise, inclusive. Undisclosed values never match. | |
| max_lockup_months | No | Maximum lockup_months, inclusive. Undisclosed values never match. | |
| min_lockup_months | No | Minimum lockup_months, inclusive. Undisclosed values never match. | |
| accepting_investment | No | True selects only offerings open to new subscriptions (status ACTIVE). | |
| max_hold_period_years | No | Maximum hold_period_years, inclusive. Undisclosed values never match. | |
| min_hold_period_years | No | Minimum hold_period_years, inclusive. Undisclosed values never match. | |
| max_spv_leverage_ratio | No | Maximum spv_leverage_ratio, inclusive. Undisclosed values never match. | |
| min_spv_leverage_ratio | No | Minimum spv_leverage_ratio, inclusive. Undisclosed values never match. | |
| max_year_1_cash_on_cash | No | Maximum year_1_cash_on_cash, inclusive. Undisclosed values never match. | |
| min_year_1_cash_on_cash | No | Minimum year_1_cash_on_cash, inclusive. Undisclosed values never match. | |
| max_min_investment_amount | No | Maximum min_investment_amount, inclusive. Undisclosed values never match. | |
| min_min_investment_amount | No | Minimum min_investment_amount, inclusive. Undisclosed values never match. | |
| max_target_equity_multiple | No | Maximum target_equity_multiple, inclusive. Undisclosed values never match. | |
| min_target_equity_multiple | No | Minimum target_equity_multiple, inclusive. Undisclosed values never match. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| as_of | Yes | ISO-8601 timestamp of when the underlying data was fetched from the API — not when this call was made. Older than a few seconds means it was served from cache. | |
| cache | Yes | Cache metadata for this response. | |
| count | Yes | Offerings returned after every filter. | |
| error | Yes | Null on success. Populated when the call failed. | |
| offerings | Yes | ||
| sorted_by | Yes | ||
| truncated | Yes | True when `limit` cut the result short. | |
| candidates | Yes | Survivors of the non-numeric filters, before range filters. | |
| disclaimer | Yes | Standing disclaimer. Carry it into anything you report to a user. | |
| sort_order | Yes | ||
| source_url | Yes | The upstream public API URL this response was derived from. | |
| field_coverage | Yes | How many candidates disclose each numeric field at all. | |
| unknown_fields | Yes | Field names in sort_by that this server does not know. Reported, then ignored — never silently treated as a no-match. | |
| field_catalogue | Yes | Every numeric field, where it lives in an offering record, its unit and whether it is a disclosure, a derivation or a projection. | |
| total_available | Yes | Size of the public set before any filter. | |
| excluded_by_criteria | Yes | Dropped because a DISCLOSED value failed a range test. | |
| excluded_not_disclosed | Yes | Dropped because a filtered field is undisclosed. Unknown, not non-matching — worth a look if the criteria matter. |