CRAFT BREWW CITY

Farmington Hills, MI 48334 · O3b097b653faf · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
CRAFT BREWW CITY 2 other
the most common name a source states
12 & ORCHARD HOLDINGS, LLC mi-lcc (legal name) ×2
craft breww city farmington hills doordash
Street
27843 Orchard Lake Rd 1 other
mi-lcc
27843 Orchard Lake Road doordash
City
Farmington Hills 1 other
mi-lcc
FARMINGTON ab-inbevvtinfo ×2
State
MI
mi-lccno other value
ZIP
48334
mi-lccno other value
Pin
42.50028, -83.35969 map 2 other
doordash
74 m away mi-lcc ×2
83 m away ab-inbev
Phone
2484885555
vtinfono other value
Licences
mi-lcc L-000454044 · mi-lcc L-000454045
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc1eabcc25ee3; O55f462327473; O77fc68b7a392; Ocaa1d1d0f438; O8677f47b7b21

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-inbevCRAFT BREWW CITY
3746701
27843 ORCHARD LAKE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
42.49993, -83.358802026-11-112026-11-11
doordashcraft breww city farmington hills
26027078
27843 Orchard Lake Road, Farmington Hills, MI, 4833442.50028, -83.359692026-10-082026-11-11
mi-lccCRAFT BREWW CITY
legal name: 12 & ORCHARD HOLDINGS, LLC
L-000454044
27843 Orchard Lake Rd, Farmington Hills, MI, 4833442.50038, -83.358802026-11-032026-11-05
mi-lccCRAFT BREWW CITY
legal name: 12 & ORCHARD HOLDINGS, LLC
L-000454045
27843 Orchard Lake Rd, Farmington Hills, MI, 4833442.50038, -83.358802026-11-032026-11-05
overtureCraft Breww City
819d8c4c-cd62-42aa-ba1b-fee96b5dad65
27843 Orchard Lake Rd, Farmington Hills, MI, 48334248488555542.50029, -83.359762026-11-062026-11-06
vtinfoCRAFT BREWW CITY
2231cc172e3e9d33
27843 ORCHARD LAKE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
248488555542.50028, -83.359682026-11-122026-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 CRAFT BREWW CITYmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev CRAFT BREWW CITYmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev CRAFT BREWW CITYoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 88 m apart · name similarity 1.00
ab-inbev CRAFT BREWW CITYvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 82 m apart · name similarity 1.00
doordash craft breww city farmington hillsmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 74 m apart · name similarity 1.00
doordash craft breww city farmington hillsmi-lcc CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 74 m apart · name similarity 1.00
doordash craft breww city farmington hillsoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYmi-lcc CRAFT BREWW CITY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc CRAFT BREWW CITYoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 80 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYoverture Craft Breww City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 80 m apart · name similarity 1.00
mi-lcc CRAFT BREWW CITYvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
overture Craft Breww Cityvtinfo CRAFT BREWW CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 · phone: equal
ab-inbev CRAFT BREWW CITYdoordash craft breww city farmington hills0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 83 m apart · name similarity 0.80
doordash craft breww city farmington hillsvtinfo CRAFT BREWW CITY0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 0 m apart · name similarity 0.80

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
12 & ORCHARD HOLDINGS, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
74 within 1 mi · 356 within 3 mi
Off / on premise
16 / 48 within 1 mi · 89 / 210 within 3 mi
Selling alcohol
26 within 1 mi · 158 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
suburban (2,375 people per sq mi)
People within 3 mi
67,159 (52,666 adults 21+, 27,695 households) from 20 tract(s), tracts within 3 mi
Income
per capita $56,737 · median household ~$114,330 (weighted mean of tract medians)
Age and education
median age ~45.6 · bachelor's or higher 60%
Ethnicity
Hispanic 2% · White 59% · Black 21% · Asian 13%
Adults per alcohol outlet
331
Alcohol spend within 3 mi
$23,036,077 a year ($10,191,739 at home, $12,834,399 away) · $144,881 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-14 20:23insertdoordash 26027078 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-14 20:23insertmi-lcc L-000454044 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-14 20:23insertmi-lcc L-000454045 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-14 20:23insertoverture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65 ↔ vtinfo 2231cc172e3e9d33same address and namemerged15
2026-11-12 14:25insertab-inbev 3746701 ↔ vtinfo 2231cc172e3e9d33same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ doordash 26027078same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ mi-lcc L-000454045same address and namemerged12
2026-11-11 12:56insertab-inbev 3746701 ↔ mi-lcc L-000454044same address and namemerged12
2026-11-10 17:05insertdoordash 26027078 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged12
2026-11-10 17:05insertdoordash 26027078 ↔ mi-lcc L-000454045same address and namemerged12
2026-11-10 17:05insertdoordash 26027078 ↔ mi-lcc L-000454044same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000454045 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000454044 ↔ overture 819d8c4c-cd62-42aa-ba1b-fee96b5dad65same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000454044 ↔ mi-lcc L-000454045one store listed twicemerged