SMART & FINAL 424

FREMONT, CA 94538 · O1a27bf258655 · first seen 2026-10-08
4 sourcesoff premisechain: Smart&finalalcohol: licensed2 licences

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
SMART & FINAL 424 3 other
the most common name a source states
SMART & FINAL EXTRA ab-inbevvtinfo ×2
SMART & FINAL STORES LLC ca-abc (legal name) ×2
Smart and Final overture
Street
3171 WALNUT AVE 1 other
ca-abc
3171 Walnut Avenue overture
City
FREMONT
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94538
ca-abcno other value
Pin
37.55133, -121.98054 map 3 other
overture
170 m away ca-abc ×2
173 m away ab-inbev
148 m away vtinfo
Phone
5107907188
vtinfono other value
Licences
ca-abc 00466824|21|APP|0 · ca-abc 00466824|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocd0ca8f684e9; Odedcd263dc0b; Od4b6cda54f05; Oc2e95f7cd610

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevSMART & FINAL EXTRA
2938195
3171 WALNUT AVE, FREMONT, CA, 9453837.55011, -121.979322026-11-112026-11-13
ca-abcSMART & FINAL 424
legal name: SMART & FINAL STORES LLC
00466824|21|APP|0
3171 WALNUT AVE, FREMONT, CA, 9453837.55112, -121.978622026-10-082026-11-16
ca-abcSMART & FINAL 424
legal name: SMART & FINAL STORES LLC
00466824|21|LIC|0
3171 WALNUT AVE, FREMONT, CA, 9453837.55112, -121.978622026-10-082026-11-16
overtureSmart and Final
ea2878f4-7b7f-4ded-9c61-c58af77af458
3171 Walnut Avenue, Fremont, CA, 94538510790718837.55133, -121.980542026-11-062026-11-16
vtinfoSMART & FINAL EXTRA
0f1cc2f988a0dec4
3171 WALNUT AVE, FREMONT, CA, 94538510790718837.55076, -121.979022026-11-132026-11-14

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev SMART & FINAL EXTRAvtinfo SMART & FINAL EXTRA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 77 m apart · name similarity 1.00
ca-abc SMART & FINAL 424ca-abc SMART & FINAL 4241.00one licence filemergedfile: 00466824 · same_address
ca-abc SMART & FINAL 424overture Smart and Final1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 170 m apart · matched through the licence's legal name: SMART & FINAL STORES LLC · name similarity 1.00
ca-abc SMART & FINAL 424overture Smart and Final1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 170 m apart · matched through the licence's legal name: SMART & FINAL STORES LLC · name similarity 1.00
ab-inbev SMART & FINAL EXTRAca-abc SMART & FINAL 4240.73one name contains the other, same addressmergedjudge: None · pair_id: 88d94ed15dd41707925a · person: None · rule: names contained at one address · stratum: near
ab-inbev SMART & FINAL EXTRAca-abc SMART & FINAL 4240.73one name contains the other, same addressmergedjudge: None · pair_id: f928913291d15fe43201 · person: None · rule: names contained at one address · stratum: near
ca-abc SMART & FINAL 424vtinfo SMART & FINAL EXTRA0.73one name contains the other, same addressmergedjudge: None · pair_id: 86816c975756641ed0a3 · person: None · rule: names contained at one address · stratum: near
ca-abc SMART & FINAL 424vtinfo SMART & FINAL EXTRA0.73one name contains the other, same addressmergedjudge: None · pair_id: 5965ab637a12f9accad2 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
off_premise — ca-licence
Chain
Smart&final — name-prefix
Alcohol
licensed — a licence or TTB permit on file
Operator
SMART & FINAL STORES LLC — 337 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
167 within 1 mi · 641 within 3 mi
Off / on premise
32 / 120 within 1 mi · 137 / 425 within 3 mi
Selling alcohol
58 within 1 mi · 298 within 3 mi
Nearest
same channel 0.11 mi · licensed 0.08 mi
Setting
urban (6,252 people per sq mi)
People within 3 mi
176,765 (134,885 adults 21+, 60,932 households) from 35 tract(s), tracts within 3 mi
Income
per capita $70,820 · median household ~$164,238 (weighted mean of tract medians)
Age and education
median age ~38.8 · bachelor's or higher 57%
Ethnicity
Hispanic 18% · White 20% · Black 3% · Asian 56%
Adults per alcohol outlet
451
Alcohol spend within 3 mi
$64,009,613 a year ($27,076,703 at home, $36,913,426 away) · $214,079 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-16 14:56insertca-abc 00466824|21|APP|0 ↔ vtinfo 0f1cc2f988a0dec4one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00466824|21|LIC|0 ↔ vtinfo 0f1cc2f988a0dec4one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2938195 ↔ ca-abc 00466824|21|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2938195 ↔ ca-abc 00466824|21|APP|0one name contains the other, same addressmerged15
2026-11-13 14:10insertab-inbev 2938195 ↔ vtinfo 0f1cc2f988a0dec4same address and namemerged15
2026-11-06 18:13insertca-abc 00466824|21|APP|0 ↔ overture ea2878f4-7b7f-4ded-9c61-c58af77af458same address and namemerged11
2026-11-06 18:13insertca-abc 00466824|21|LIC|0 ↔ overture ea2878f4-7b7f-4ded-9c61-c58af77af458same address and namemerged11
2026-10-09 13:59backfillca-abc 00466824|21|APP|0 ↔ ca-abc 00466824|21|LIC|0one licence filemerged