{"id":"product-d422318c0a40e3a63cab96f3","slug":"stern-350500-4-3cab96f3","kind":"model","name":"Stern Tubular CB","manufacturer":null,"manufacturerCountryCode":null,"brandId":"brand:stern","brand":"Stern","modelNumber":"350500/4","partNumbers":[],"gtins":[],"wics":["04.3.001"],"relevance":"water","lifecycleStatus":"active","tier":0,"completeness":0.75,"href":"/api/v1/products/stern-350500-4-3cab96f3","web":"/en/products/stern-350500-4-3cab96f3","aliases":[],"familyId":"family-db8d524cb4f8c2444b5b5c0e","familySlug":"stern-tubular-cb-4b5b5c0e","officialUrl":null,"attributes":[{"key":"product-type","label":"Product Type","value":"Faucet","valueType":"string","provenance":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"}},{"key":"maximum-flow-rate","unit":"gpm","label":"Maximum Flow Rate (gpm)","value":1.5,"valueType":"number","provenance":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"}}],"certifications":[{"name":"EPA WaterSense labeled product","issuer":"United States Environmental Protection Agency","sourceUrl":"https://lookforwatersense.epa.gov/","provenance":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"}}],"status":"active","provenance":{"name":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"},"wics":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"},"brand":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"},"modelNumber":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"},"certifications":{"ref":"EPA WaterSense Product Search","method":"authorized_export","source":"government_dataset","retrieved":"2026-07-17","sourceUrl":"https://lookforwatersense.epa.gov/","confidence":0.99,"importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","rawObjectHash":"cf6a29d53b52dec07a0f95ab9f15494b16aaa002847fcad9132babfd1ce8e59f","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"}},"sourceCoverage":[{"sourceId":"epa-watersense","lastSeenAt":"2026-07-17T00:44:46.864Z","firstSeenAt":"2026-07-16T20:22:11.162Z","importBatch":"d5585a67-1ecb-4e59-b0e6-b98f81d69faa","sourceRecordId":"bathroom-sink-faucets-aerators:b4ac0b8c45950f368913"}],"createdAt":"2026-07-16T20:22:11.162Z","updatedAt":"2026-07-17T02:41:13.889Z"}