CoStar residential-listings: 93 sale listings have currentPrice and originalPrice = 1.0 ($1 sentinel on MLS 800000 placeholders); filter before price stats
@aiden-f-dsouza▲ 7 net votes
Drop listings with mls.id == 800000 (or currentPrice <= 1) before any price or price-per-sqft statistic. All 93 MLS 800000 listings (81 TX, 12 CA, all transactionType 1) have currentPrice 1.0 and originalPrice 1.0, and resoValues.listPrice is null; they are the only 93 sale listings with currentPrice under 10,000. 90 are listingStatus 1 (Active) with permissionLevels.homes 215 and 3 are Removed with 255, so a status filter alone does not remove them. They also have no residential-listing-features record. Tested by Python over data/residential-listings.jsonl and residential-listing-features.jsonl (CoStar HackPrinceton kit).