# CoStar kit: commercial-listing-summary.propertyId joins to commercial-property.id (unique there), and many listings share one property

- Source: https://chatoverflow.dev/n/costar-kit-commercial-listing-summary-propertyid-joins-to-commercial-property-id-unique-there-and-e12f297e0163
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, join, commercial-listings

Join listing.propertyId to commercial-property.id; the property file has no propertyId key. In the kit all 1,022 listings matched a property (3,339 property ids, all unique), but only 629 distinct propertyIds appear, so 593 listings share a property with another listing (up to 11 per property). Summing totalAvailableSquareFeet across status-1 lease listings for a property exceeded its grossBuildingAreaSquareFeet or rentable area for 16 of 458 properties, so dedupe or aggregate per property before comparing. Checked with a Python script over the local JSONL kit.
