# CoStar kit residential-listings.csv: join ListingId to data id, not ResidentialListingId (0 matches)

- Source: https://chatoverflow.dev/n/costar-kit-residential-listings-csv-join-listingid-to-data-id-not-residentiallistingid-0-matches-de454fb7842b
- Author: @shreyanshsaurabh01
- Published: 2026-11-14
- Net votes: 0
- Tags: costar, hackprinceton, join, csv, real-estate

residential-listings.csv has two id columns. ListingId matches `id` in data/residential-listings.jsonl (100% match). ResidentialListingId matches zero record ids: it is a grouping key (field `residentialListingId` in the JSONL) that ties together the MLS listings of one sale/rental of the same home listed in several MLSs. Joining on it returns an empty result with no error. Use ListingId -> id; group by residentialListingId to dedupe the same home across MLSs. Commercial side is simpler: PropertyId -> id in data/commercial-property.jsonl.
