Redfin Real Estate API Capability

Market trends

Read public Redfin Data Center regional trend rows from JSON or CSV downloads.

Capability ID redfin.market.trends

Cost 1 credit per request

Maximum runtime 45 seconds

# Market trends

Read public Redfin Data Center regional trend rows from JSON or CSV downloads.

- Platform: [Redfin Real Estate](https://docs.upscrape.com/docs/platforms/redfin)
- Capability ID: `redfin.market.trends`
- Cost: 1 credit per request
- Maximum runtime: 45 seconds
- Execute endpoint: `POST https://data.upscrape.com/execute`

## Request

Use the exact public capability ID in the shared execute envelope.

```bash
curl --request POST \
  --url https://data.upscrape.com/execute \
  --header "Authorization: Bearer YOUR_API_KEY" \
  --header "Content-Type: application/json" \
  --header "Prefer: wait=30" \
  --data '{
  "input": {
    "limit": 12,
    "metric": "median_sale_price",
    "region": "Seattle, WA"
  },
  "capability": "redfin.market.trends"
}'
```

## Input

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `end_date` | `string` | No | Optional inclusive period end in YYYY-MM-DD format. |
| `limit` | `integer` | No | Maximum matching monthly rows to return. |
| `metric` | `string` | No | Normalized market metric returned in each row value. |
| `region` | `string` | Yes | Exact Redfin Data Center region name, for example Seattle, WA. |
| `start_date` | `string` | No | Optional inclusive period start in YYYY-MM-DD format. |

### Example input

```json
{
  "limit": 12,
  "metric": "median_sale_price",
  "region": "Seattle, WA"
}
```

## Response

Successful output is returned in `results[0].data`. Raw platform output is intentionally open-ended and may evolve with the upstream source.

### Illustrative sample output

This redacted fixture is an example, not a fixed response schema.

```json
{
  "metric": "median_sale_price",
  "region": "Seattle, WA",
  "rows": [
    {
      "change_pct": -0.16,
      "metrics": {
        "ACTIVE LISTINGS": 5395,
        "ACTIVE LISTINGS YOY (%)": 0.73,
        "AVERAGE SALE TO LIST RATIO (%)": 100.19,
        "AVERAGE SALE TO LIST RATIO YOY (PPTS)": -0.19,
        "HOMES SOLD": 2398,
        "HOMES SOLD YOY (%)": -6.08,
        "INVENTORY": 2387,
        "INVENTORY YOY (%)": 12.89,
        "MEDIAN DAYS ON MARKET (DAYS)": 12,
        "MEDIAN DAYS ON MARKET YOY (%)": 201.48,
        "MEDIAN NEW LISTING PRICE ($)": 841892,
        "MEDIAN NEW LISTING PRICE PER SQ.FT. ($)": 557.21,
        "MEDIAN NEW LISTING PRICE PER SQ.FT. YOY (%)": -2.2,
        "MEDIAN NEW LISTING PRICE YOY (%)": -2.67,
        "MEDIAN SALE PRICE NSA ($)": 898550,
        "MEDIAN SALE PRICE NSA YOY (%)": -0.16,
        "MEDIAN SALE PRICE PER SQ.FT. ($)": 560.93,
        "MEDIAN SALE PRICE PER SQ.FT. YOY (%)": -3.06,
        "MONTHS OF SUPPLY": 3.1,
        "MONTHS OF SUPPLY YOY (%)": 51.28,
        "NEW LISTINGS": 3362,
        "NEW LISTINGS YOY (%)": -7.79,
        "PENDING SALES": 2230,
        "PENDING SALES YOY (%)": -15.18,
        "PERCENT OFF MARKET IN TWO WEEKS (%)": 52.63,
        "PERCENT OFF MARKET IN TWO WEEKS YOY (PPTS)": -0.51,
        "REGION ID": 16163,
        "SHARE SOLD ABOVE ORIGINAL LIST (%)": 26.28,
        "SHARE SOLD ABOVE ORIGINAL LIST YOY (PPTS)": -0.24
      },
      "period_end": "2026-07-31",
      "period_start": "2026-05-01",
      "region": "Seattle, WA",
      "value": 898550
    },
    {
      "change_pct": -2.21,
      "metrics": {
        "ACTIVE LISTINGS": 5344,
        "ACTIVE LISTINGS YOY (%)": 0.17,
        "AVERAGE SALE TO LIST RATIO (%)": 100.57,
        "AVERAGE SALE TO LIST RATIO YOY (PPTS)": -0.63,
        "HOMES SOLD": 2485,
        "HOMES SOLD YOY (%)": -3.46,
        "INVENTORY": 2225,
        "INVENTORY YOY (%)": 2.3,
        "MEDIAN DAYS ON MARKET (DAYS)": 11,
        "MEDIAN DAYS ON MARKET YOY (%)": 400,
        "MEDIAN NEW LISTING PRICE ($)": 850000,
        "MEDIAN NEW LISTING PRICE PER SQ.FT. ($)": 565.16,
        "MEDIAN NEW LISTING PRICE PER SQ.FT. YOY (%)": -1.44,
        "MEDIAN NEW LISTING PRICE YOY (%)": 0,
        "MEDIAN SALE PRICE NSA ($)": 889925,
        "MEDIAN SALE PRICE NSA YOY (%)": -2.21,
        "MEDIAN SALE PRICE PER SQ.FT. ($)": 566.92,
        "MEDIAN SALE PRICE PER SQ.FT. YOY (%)": -3.92,
        "MONTHS OF SUPPLY": 2.7,
        "MONTHS OF SUPPLY YOY (%)": 15.28,
        "NEW LISTINGS": 3645,
        "NEW LISTINGS YOY (%)": -7.04,
        "PENDING SALES": 2493,
        "PENDING SALES YOY (%)": -7.08,
        "PERCENT OFF MARKET IN TWO WEEKS (%)": 55.35,
        "PERCENT OFF MARKET IN TWO WEEKS YOY (PPTS)": -4.21,
        "REGION ID": 16163,
        "SHARE SOLD ABOVE ORIGINAL LIST (%)": 28.49,
        "SHARE SOLD ABOVE ORIGINAL LIST YOY (PPTS)": -2.74
      },
      "period_end": "2026-06-30",
      "period_start": "2026-04-01",
      "region": "Seattle, WA",
      "value": 889925
    },
    {
      "change_pct": -2.22,
      "metrics": {
        "ACTIVE LISTINGS": 5228,
        "ACTIVE LISTINGS YOY (%)": 1.61,
        "AVERAGE SALE TO LIST RATIO (%)": 100.92,
        "AVERAGE SALE TO LIST RATIO YOY (PPTS)": -0.6,
        "HOMES SOLD": 2406,
        "HOMES SOLD YOY (%)": -1.96,
        "INVENTORY": 2226,
        "INVENTORY YOY (%)": 2.06,
        "MEDIAN DAYS ON MARKET (DAYS)": 10,
        "MEDIAN DAYS ON MARKET YOY (%)": 250,
        "MEDIAN NEW LISTING PRICE ($)": 849000,
        "MEDIAN NEW LISTING PRICE PER SQ.FT. ($)": 565.84,
        "MEDIAN NEW LISTING PRICE PER SQ.FT. YOY (%)": -1.81,
        "MEDIAN NEW LISTING PRICE YOY (%)": -0.12,
        "MEDIAN SALE PRICE NSA ($)": 880000,
        "MEDIAN SALE PRICE NSA YOY (%)": -2.22,
        "MEDIAN SALE PRICE PER SQ.FT. ($)": 566.19,
        "MEDIAN SALE PRICE PER SQ.FT. YOY (%)": -3.28,
        "MONTHS OF SUPPLY": 2.8,
        "MONTHS OF SUPPLY YOY (%)": 11.17,
        "NEW LISTINGS": 3698,
        "NEW LISTINGS YOY (%)": -5.78,
        "PENDING SALES": 2554,
        "PENDING SALES YOY (%)": -3.84,
        "PERCENT OFF MARKET IN TWO WEEKS (%)": 56.77,
        "PERCENT OFF MARKET IN TWO WEEKS YOY (PPTS)": -6.63,
        "REGION ID": 16163,
        "SHARE SOLD ABOVE ORIGINAL LIST (%)": 29.93,
        "SHARE SOLD ABOVE ORIGINAL LIST YOY (PPTS)": -1.98
      },
      "period_end": "2026-05-31",
      "period_start": "2026-03-01",
      "region": "Seattle, WA",
      "value": 880000
    }
  ],
  "source": "Redfin Data Center S3 housing_market/monthly/top_50_cities.csv"
}
```
### Illustrative output fields

Derived from the sample above for orientation only. These fields are not a fixed response schema.

| Path | Observed type | Example |
| --- | --- | --- |
| `metric` | `string` | median_sale_price |
| `region` | `string` | Seattle, WA |
| `rows` | `array` | 3 items |
| `rows` | `array` | 3 items |
| `source` | `string` | Redfin Data Center S3 housing_market/monthly/top_50_cities.csv |

## Execution behavior

A `200` response completed inline. A `202` response was queued; poll `GET /jobs/{id}` until the job reaches `completed` or `failed`. Use an `Idempotency-Key` when retrying must not create a duplicate logical job.

## Related documentation

- [Authentication](https://docs.upscrape.com/docs/api/authentication)
- [Jobs and results](https://docs.upscrape.com/docs/api/jobs)
- [Errors and retries](https://docs.upscrape.com/docs/api/errors)
- [Idempotency](https://docs.upscrape.com/docs/api/idempotency)

POST /execute Shared execution endpoint

Input parameters

end_date string optional

Optional inclusive period end in YYYY-MM-DD format.

limit integer optional

Maximum matching monthly rows to return.

Example 12

metric string optional

Normalized market metric returned in each row value.

Example median_sale_price

Available values median_sale_price

region string required

Exact Redfin Data Center region name, for example Seattle, WA.

Example Seattle, WA

start_date string optional

Optional inclusive period start in YYYY-MM-DD format.

Response

Successful output is returned in results[0].data. Raw platform output is intentionally open-ended and may evolve with the upstream source.

Illustrative sample The full redacted fixture is shown in the response panel.

Illustrative output fields

Derived from the sample above for orientation only. These observed fields are not a fixed response schema.

Path	Observed type	Example
`metric`	`string`	median_sale_price
`region`	`string`	Seattle, WA
`rows`	`array`	3 items
`rows`	`array`	3 items
`source`	`string`	Redfin Data Center S3 housing_market/monthly/top_50_cities.csv

Execution behavior

A 200 response completed inline. A 202 response was queued; poll GET /jobs/:id until the job reaches completed or failed.

curl --request POST \ --url https://data.upscrape.com/execute \ --header "Authorization: Bearer YOUR_API_KEY" \ --header "Content-Type: application/json" \ --header "Prefer: wait=30" \ --data '{ "input": { "limit": 12, "metric": "median_sale_price", "region": "Seattle, WA" }, "capability": "redfin.market.trends" }'

import json import requests payload = json.loads(r'''{ "input": { "limit": 12, "metric": "median_sale_price", "region": "Seattle, WA" }, "capability": "redfin.market.trends" }''') response = requests.post( "https://data.upscrape.com/execute", headers={ "Authorization": "Bearer YOUR_API_KEY", "Content-Type": "application/json", "Prefer": "wait=30", }, json=payload, ) response.raise_for_status() print(json.dumps(response.json(), indent=2))

{ "metric": "median_sale_price", "region": "Seattle, WA", "rows": [ { "change_pct": -0.16, "metrics": { "ACTIVE LISTINGS": 5395, "ACTIVE LISTINGS YOY (%)": 0.73, "AVERAGE SALE TO LIST RATIO (%)": 100.19, "AVERAGE SALE TO LIST RATIO YOY (PPTS)": -0.19, "HOMES SOLD": 2398, "HOMES SOLD YOY (%)": -6.08, "INVENTORY": 2387, "INVENTORY YOY (%)": 12.89, "MEDIAN DAYS ON MARKET (DAYS)": 12, "MEDIAN DAYS ON MARKET YOY (%)": 201.48, "MEDIAN NEW LISTING PRICE ($)": 841892, "MEDIAN NEW LISTING PRICE PER SQ.FT. ($)": 557.21, "MEDIAN NEW LISTING PRICE PER SQ.FT. YOY (%)": -2.2, "MEDIAN NEW LISTING PRICE YOY (%)": -2.67, "MEDIAN SALE PRICE NSA ($)": 898550, "MEDIAN SALE PRICE NSA YOY (%)": -0.16, "MEDIAN SALE PRICE PER SQ.FT. ($)": 560.93, "MEDIAN SALE PRICE PER SQ.FT. YOY (%)": -3.06, "MONTHS OF SUPPLY": 3.1, "MONTHS OF SUPPLY YOY (%)": 51.28, "NEW LISTINGS": 3362, "NEW LISTINGS YOY (%)": -7.79, "PENDING SALES": 2230, "PENDING SALES YOY (%)": -15.18, "PERCENT OFF MARKET IN TWO WEEKS (%)": 52.63, "PERCENT OFF MARKET IN TWO WEEKS YOY (PPTS)": -0.51, "REGION ID": 16163, "SHARE SOLD ABOVE ORIGINAL LIST (%)": 26.28, "SHARE SOLD ABOVE ORIGINAL LIST YOY (PPTS)": -0.24 }, "period_end": "2026-07-31", "period_start": "2026-05-01", "region": "Seattle, WA", "value": 898550 }, { "change_pct": -2.21, "metrics": { "ACTIVE LISTINGS": 5344, "ACTIVE LISTINGS YOY (%)": 0.17, "AVERAGE SALE TO LIST RATIO (%)": 100.57, "AVERAGE SALE TO LIST RATIO YOY (PPTS)": -0.63, "HOMES SOLD": 2485, "HOMES SOLD YOY (%)": -3.46, "INVENTORY": 2225, "INVENTORY YOY (%)": 2.3, "MEDIAN DAYS ON MARKET (DAYS)": 11, "MEDIAN DAYS ON MARKET YOY (%)": 400, "MEDIAN NEW LISTING PRICE ($)": 850000, "MEDIAN NEW LISTING PRICE PER SQ.FT. ($)": 565.16, "MEDIAN NEW LISTING PRICE PER SQ.FT. YOY (%)": -1.44, "MEDIAN NEW LISTING PRICE YOY (%)": 0, "MEDIAN SALE PRICE NSA ($)": 889925, "MEDIAN SALE PRICE NSA YOY (%)": -2.21, "MEDIAN SALE PRICE PER SQ.FT. ($)": 566.92, "MEDIAN SALE PRICE PER SQ.FT. YOY (%)": -3.92, "MONTHS OF SUPPLY": 2.7, "MONTHS OF SUPPLY YOY (%)": 15.28, "NEW LISTINGS": 3645, "NEW LISTINGS YOY (%)": -7.04, "PENDING SALES": 2493, "PENDING SALES YOY (%)": -7.08, "PERCENT OFF MARKET IN TWO WEEKS (%)": 55.35, "PERCENT OFF MARKET IN TWO WEEKS YOY (PPTS)": -4.21, "REGION ID": 16163, "SHARE SOLD ABOVE ORIGINAL LIST (%)": 28.49, "SHARE SOLD ABOVE ORIGINAL LIST YOY (PPTS)": -2.74 }, "period_end": "2026-06-30", "period_start": "2026-04-01", "region": "Seattle, WA", "value": 889925 }, { "change_pct": -2.22, "metrics": { "ACTIVE LISTINGS": 5228, "ACTIVE LISTINGS YOY (%)": 1.61, "AVERAGE SALE TO LIST RATIO (%)": 100.92, "AVERAGE SALE TO LIST RATIO YOY (PPTS)": -0.6, "HOMES SOLD": 2406, "HOMES SOLD YOY (%)": -1.96, "INVENTORY": 2226, "INVENTORY YOY (%)": 2.06, "MEDIAN DAYS ON MARKET (DAYS)": 10, "MEDIAN DAYS ON MARKET YOY (%)": 250, "MEDIAN NEW LISTING PRICE ($)": 849000, "MEDIAN NEW LISTING PRICE PER SQ.FT. ($)": 565.84, "MEDIAN NEW LISTING PRICE PER SQ.FT. YOY (%)": -1.81, "MEDIAN NEW LISTING PRICE YOY (%)": -0.12, "MEDIAN SALE PRICE NSA ($)": 880000, "MEDIAN SALE PRICE NSA YOY (%)": -2.22, "MEDIAN SALE PRICE PER SQ.FT. ($)": 566.19, "MEDIAN SALE PRICE PER SQ.FT. YOY (%)": -3.28, "MONTHS OF SUPPLY": 2.8, "MONTHS OF SUPPLY YOY (%)": 11.17, "NEW LISTINGS": 3698, "NEW LISTINGS YOY (%)": -5.78, "PENDING SALES": 2554, "PENDING SALES YOY (%)": -3.84, "PERCENT OFF MARKET IN TWO WEEKS (%)": 56.77, "PERCENT OFF MARKET IN TWO WEEKS YOY (PPTS)": -6.63, "REGION ID": 16163, "SHARE SOLD ABOVE ORIGINAL LIST (%)": 29.93, "SHARE SOLD ABOVE ORIGINAL LIST YOY (PPTS)": -1.98 }, "period_end": "2026-05-31", "period_start": "2026-03-01", "region": "Seattle, WA", "value": 880000 } ], "source": "Redfin Data Center S3 housing_market/monthly/top_50_cities.csv" }