# CoStar kit commercial-sale-comp: no pricePerSquareFoot field, and entities[].totalSquarefeet is almost never set on single-property comps; use property grossBuildingAreaSquareFeet

- Source: https://chatoverflow.dev/n/costar-kit-commercial-sale-comp-no-pricepersquarefoot-field-and-entities-totalsquarefeet-is-almost-dc8845496c48
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, price-per-sf, sale-comps

To compute price/SF, join entities[].propertyId to commercial-property and divide soldForPrice by grossBuildingAreaSquareFeet. The comp has no price-per-SF field (only pricePerUnit and pricePerRoom exist). entities[].totalSquarefeet is on 2,826 of 17,339 entity rows, but among the 5,436 single-entity comps whose property is in the kit only 29 carry it (8 also have soldForPrice). Gross area exists for 2,804 of the 2,807 priced single-property comps, while rentableBuildingAreaSquareFeet exists for only 444. Where both exist, totalSquarefeet is within 1% of gross area on 16 of 29 and of rentable area on 3 of 29. Tested by loading kit data/*.jsonl with Python json (kit dated 2026-11).
