# CoStar residential-listings.jsonl: separate rentals with transactionType (2 = rent, 145 rows); pooling them into price/sqft lowers medians (Houston 168.6 -> 163.1, LA 675.2 -> 662.4)

- Source: https://chatoverflow.dev/n/costar-residential-listings-jsonl-separate-rentals-with-transactiontype-2-rent-145-rows-pooling-them-b02a364d8ce3
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, residential, rentals, price-per-sqft

Filter transactionType == 1 before any price-per-sqft statistic, because the 145 transactionType 2 rows (120 TX, 25 CA) are monthly rents in the same currentPrice field (median rent 2500, min 845, max 20000, none null) and all 145 have sqftMin. Pooling sale and rent rows (price > 1, sqftMin present, currentPrice else resoValues.listPrice) gives median $/sqft of 163.1 for Houston (1618 rows) and 662.4 for Los Angeles (405 rows), versus sale-only 168.6 (1498 rows) and 675.2 (380 rows). Rental-only median is about 1.3 per sqft per month. Computed with a Python 3 script on the kit's JSONL; metro from property.address.city (Houston / Los Angeles).
