UNION LIQUOR LAND

Commerce Township, MI 48382 · O17bbbac77c1e · first seen 2026-10-08
5 sourcesoff premise · liquor_storealcohol: 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
UNION LIQUOR LAND 2 other
the most common name a source states
AVIRAJ & HARMAN, INC. mi-lcc (legal name) ×2
union liquor land commerce township doordash
Street
3171 Union Lake Rd
mi-lccno other value
City
Commerce Township 1 other
mi-lcc
Commerce Twp overture
State
MI
mi-lccno other value
ZIP
48382
mi-lccno other value
Pin
42.58971, -83.44538 map 1 other
doordash
57 m away ab-inbev
Phone
2487797602 2 other
vtinfo
5177631620 mi-lcc ×2
2487797812 overture
Licences
mi-lcc L-000474111 · mi-lcc L-000474112
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obbcdcea4b0d6; Oa9355ae38413; O3d14b6e89e4c; Oc1388fb6f417; O1e6716940b4b

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-inbevUNION LIQUOR LAND
4514778
3171 UNION LAKE RD, COMMERCE TOWNSHIP, MI, 4838242.59013, -83.445772026-11-112026-11-11
doordashunion liquor land commerce township
31042302
3171 Union Lake Rd, Commerce Township, MI, 4838242.58971, -83.445382026-10-082026-11-03
mi-lccUNION LIQUOR LAND
legal name: AVIRAJ & HARMAN, INC.
L-000474111
3171 Union Lake Rd, Commerce Township, MI, 48382517763162042.58971, -83.445732026-11-032026-11-05
mi-lccUNION LIQUOR LAND
legal name: AVIRAJ & HARMAN, INC.
L-000474112
3171 Union Lake Rd, Commerce Township, MI, 48382517763162042.58971, -83.445732026-11-032026-11-05
overtureUnion Liquor Land
04117813-b260-4c7e-929a-913744c45c98
3171 Union Lake Rd, Commerce Twp, MI, 48382248779781242.58974, -83.445382026-11-062026-11-06
vtinfoUNION LIQUOR LAND
8173be34b2bd73aa
3171 UNION LAKE RD, COMMERCE TOWNSHIP, MI, 48382248779760242.58957, -83.445642026-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 UNION LIQUOR LANDdoordash union liquor land commerce township1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00
ab-inbev UNION LIQUOR LANDmi-lcc UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 46 m apart · name similarity 1.00
ab-inbev UNION LIQUOR LANDmi-lcc UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 46 m apart · name similarity 1.00
ab-inbev UNION LIQUOR LANDoverture Union Liquor Land1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 54 m apart · name similarity 1.00
ab-inbev UNION LIQUOR LANDvtinfo UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 64 m apart · name similarity 1.00
doordash union liquor land commerce townshipmi-lcc UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash union liquor land commerce townshipmi-lcc UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash union liquor land commerce townshipvtinfo UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00
mi-lcc UNION LIQUOR LANDmi-lcc UNION LIQUOR LAND1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc UNION LIQUOR LANDoverture Union Liquor Land1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00 · phone: differs
mi-lcc UNION LIQUOR LANDvtinfo UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 · phone: differs
mi-lcc UNION LIQUOR LANDoverture Union Liquor Land1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00 · phone: differs
mi-lcc UNION LIQUOR LANDvtinfo UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 · phone: differs
overture Union Liquor Landvtinfo UNION LIQUOR LAND1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00 · phone: differs

Attributes

Channel
off_premise · liquor_store — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
AVIRAJ & HARMAN, INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor Resort; MI Retail - Off Premises/Specially Designated Merchant
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 111 within 3 mi
Off / on premise
11 / 12 within 1 mi · 40 / 33 within 3 mi
Selling alcohol
21 within 1 mi · 71 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.08 mi
Setting
suburban (1,660 people per sq mi)
People within 3 mi
46,934 (35,387 adults 21+, 17,954 households) from 10 tract(s), tracts within 3 mi
Income
per capita $56,171 · median household ~$109,993 (weighted mean of tract medians)
Age and education
median age ~44.0 · bachelor's or higher 48%
Ethnicity
Hispanic 4% · White 82% · Black 6% · Asian 4%
Adults per alcohol outlet
491
Alcohol spend within 3 mi
$15,040,065 a year ($6,619,256 at home, $8,414,999 away) · $208,890 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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:23insertoverture 04117813-b260-4c7e-929a-913744c45c98 ↔ vtinfo 8173be34b2bd73aasame address and namemerged15
2026-11-12 14:25insertab-inbev 4514778 ↔ vtinfo 8173be34b2bd73aasame address and namemerged12
2026-11-12 14:25insertdoordash 31042302 ↔ vtinfo 8173be34b2bd73aasame address and namemerged12
2026-11-12 14:25insertmi-lcc L-000474112 ↔ vtinfo 8173be34b2bd73aasame address and namemerged12
2026-11-12 14:25insertmi-lcc L-000474111 ↔ vtinfo 8173be34b2bd73aasame address and namemerged12
2026-11-11 12:56insertab-inbev 4514778 ↔ overture 04117813-b260-4c7e-929a-913744c45c98same address and namemerged12
2026-11-11 12:56insertab-inbev 4514778 ↔ doordash 31042302same address and namemerged12
2026-11-11 12:56insertab-inbev 4514778 ↔ mi-lcc L-000474112same address and namemerged12
2026-11-11 12:56insertab-inbev 4514778 ↔ mi-lcc L-000474111same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000474112 ↔ overture 04117813-b260-4c7e-929a-913744c45c98same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000474111 ↔ overture 04117813-b260-4c7e-929a-913744c45c98same address and namemerged11
2026-11-03 13:33backfilldoordash 31042302 ↔ mi-lcc L-000474112same address and namemerged
2026-11-03 13:33backfilldoordash 31042302 ↔ mi-lcc L-000474111same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000474111 ↔ mi-lcc L-000474112one store listed twicemerged