Commercial lease expiry and tenancy data in Connecticut

12 dated Connecticut records, read from filed public sources rather than modelled, and callable by an AI agent with no key.

Short answer

Which commercial leases are approaching expiry, and who occupies a building? In Connecticut, 8 records are dated ahead of today. Every one of them is listed below in full, and they are free. 12 have been published in Connecticut in total, counting those already past.

All 8 in Connecticut

That is the whole Connecticut population for this family, not a sample. The call underneath returns the same rows, up to its own fifty-row ceiling.

Date	Property	City	Units	Amount	Source
2027-03-31	1650 WATERTOWN AVENUEDollar General: the lease at 1650 WATERTOWN AVENUE, Waterbury, CT expires 2027-03-31 (9,607 sq ft, 22% of the building).	Waterbury	—	9,607 square_feet	sec_abs_ee
2027-09-30	475 Talcottville RoadWB - Vernon Rockville (Talcottville), CT: the lease at 475 Talcottville Road, Vernon, CT expires 2027-09-30 (6,768 sq ft, the whole building).	Vernon	—	6,768 square_feet	sec_abs_ee
2027-12-31	123 CHURCH STREETSquare 9 Softworks: the lease at 123 CHURCH STREET, New Haven, CT expires 2027-12-31 (10,825 sq ft, 28% of the building).	New Haven	—	10,825 square_feet	sec_abs_ee
2028-01-31	157 CHURCH STREETYALE UNIVERSITY: the lease at 157 CHURCH STREET, New Haven, CT expires 2028-01-31 (71,803 sq ft, 15% of the building).	New Haven	—	71,803 square_feet	sec_abs_ee
2028-01-31	157 CHURCH STREETYALE UNIVERSITY: the lease at 157 CHURCH STREET, New Haven, CT expires 2028-01-31 (71,803 sq ft, 15% of the building).	New Haven	—	71,803 square_feet	sec_abs_ee
2028-04-30	100 WASHINGTON BOULEVARDSpringWorks Therapeutics: the lease at 100 WASHINGTON BOULEVARD, Stamford, CT expires 2028-04-30 (23,919 sq ft, 17% of the building).	Stamford	—	23,919 square_feet	sec_abs_ee
2028-08-31	1055-1065 KENNEDY ROADHomeGoods Inc.: the lease at 1055-1065 KENNEDY ROAD, Windsor, CT expires 2028-08-31 (20,000 sq ft, 31% of the building).	Windsor	—	20,000 square_feet	sec_abs_ee
2028-11-30	1 FOREST PARKWAYLaboratory Corporation of: the lease at 1 FOREST PARKWAY, Shelton, CT expires 2028-11-30 (78,600 sq ft, the whole building).	Shelton	—	78,600 square_feet	sec_abs_ee

Read from the published event tape on 2026-09-12.

The call that returns this

One anonymous POST. No key, no signup, no rate card. Raise limit to 50, or change state to any of the 55 covered.

curl -s https://exchange-production-9123.up.railway.app/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"search_property_events","arguments":{"event_type":"LEASE_EXPIRING","state":"CT","within_days":1825,"limit":500}}}'

Putting this in your own agent

The same endpoint is a Model Context Protocol server, so an assistant can ask it the question instead of you reading a table. It answers for every covered state, not just Connecticut, and it is the same free tier.

Add to Cursor Add to VS Code

Claude Code

one command, then it is available in every session

claude mcp add --transport http dfx-real-estate https://exchange-production-9123.up.railway.app/mcp

Claude Desktop

claude_desktop_config.json, then restart the app. It cannot reach a remote server directly, so this bridges through mcp-remote.

{
  "mcpServers": {
    "dfx-real-estate": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "https://exchange-production-9123.up.railway.app/mcp"
      ]
    }
  }
}

Cursor, Windsurf, Cline and Zed

the mcp.json their settings panel writes

{
  "mcpServers": {
    "dfx-real-estate": {
      "url": "https://exchange-production-9123.up.railway.app/mcp"
    }
  }
}

VS Code

the servers key, which is spelled differently to everything above

{
  "servers": {
    "dfx-real-estate": {
      "type": "http",
      "url": "https://exchange-production-9123.up.railway.app/mcp"
    }
  }
}

Then ask it this

Nothing names DFX. If the install worked, the assistant picks the tool itself.

Which commercial leases in Connecticut expire in the next two years?

There is no signup, no API key and no OAuth for anything free, and eleven of the twelve tools are free. A plain GET on the endpoint returns every tool schema, so a client can be pointed at it and evaluated before it is trusted.

Where this does not help

This is the DISCLOSED slice of tenancy, not all of it. Absence of a lease is not evidence a building is empty.

The same question in other states

Facts on this page were last checked against the running product on August 19, 2026. Prices are read from the live billing configuration, so this page and your invoice cannot disagree. The machine-readable version of this record is at /ai/entity.json.