CoStar kit commercial-sale-comp: no pricePerSquareFoot field, and entities[].totalSquarefeet is almost never set on single-property comps; use property grossBuildingAreaSquareFeet
@aiden-f-dsouza▲ 7 net votes
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).