search_deals
Filter real estate deals by pipeline stage, contact, property, or broker. Track deal progress, find lost deals, and analyze cancellation reasons.
Instructions
Search and filter deals (contact↔property relationships) in Propstack.
Use this tool to:
Show all deals in a specific pipeline stage
Find deals for a contact or property
Track deal pipeline progress for a project
Find lost deals and cancellation reasons
Filter by broker, team, feeling (cold/warm/hot)
A "deal" represents an interested contact linked to a property at a specific stage in a sales/rental pipeline (e.g. Anfrage → Besichtigung → Reserviert → Notartermin → Verkauft).
Use include="client,property" to get expanded contact and property details in one request.
Common queries:
All active deals: category="qualified"
Lost deals this month: category="lost" + created_at_from
Deals for a property: property_id=123
Pipeline view: deal_pipeline_id + sort_by=deal_stage_id
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (default: 1) | |
| order | No | Sort order (default: desc) | |
| include | No | Comma-separated related data to expand: 'client', 'property', or 'client,property' | |
| sort_by | No | Field to sort results by | |
| team_id | No | Filter by team ID | |
| category | No | Deal category: qualified (active), unqualified (not yet), lost (cancelled/rejected) | |
| per_page | No | Results per page (default: 25) | |
| broker_id | No | Filter by assigned broker ID | |
| client_id | No | Filter by contact ID | |
| feeling_to | No | Maximum feeling score | |
| project_id | No | Filter by project ID | |
| property_id | No | Filter by property ID | |
| feeling_from | No | Minimum feeling score (0=none, 1=cold, 2=warm, 3=hot) | |
| created_at_to | No | Filter deals created before this date (ISO 8601) | |
| start_date_to | No | Filter by deal start date to (ISO 8601) | |
| deal_stage_ids | No | Filter by deal stage IDs (pipeline steps) | |
| created_at_from | No | Filter deals created after this date (ISO 8601) | |
| start_date_from | No | Filter by deal start date from (ISO 8601) | |
| client_source_id | No | Filter by lead source ID | |
| deal_pipeline_id | No | Filter by deal pipeline ID | |
| client_broker_ids | No | Filter by contact's assigned broker IDs | |
| property_broker_ids | No | Filter by property's assigned broker IDs | |
| show_archived_clients | No | Include deals with archived contacts | |
| reservation_reason_ids | No | Filter by cancellation/reservation reason IDs | |
| hide_archived_properties | No | Exclude deals with archived properties |