Bella Vino Fine Wine & Spirits

FARMINGTON, MI 48334 · O6ede26ac67eb · first seen 2026-11-03
3 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
Bella Vino Fine Wine & Spirits 2 other
a licence name in capitals, cleaned (derived; record_title.py)
A-ONE WINE AND LIQUOR, LLC mi-lcc (legal name) ×2
BELLA VINO FINE WINES ab-inbevvtinfo ×2
Street
29970-29980 W 12 MILE RD 1 other
mi-lcc
29970 W 12 MILE RD ab-inbevvtinfo ×2
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.49961, -83.34609 map 1 other
mi-lcc
62 m away ab-inbev
Phone
2488512344
vtinfono other value
Licences
mi-lcc L-000455137 · mi-lcc L-000455138
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oeef03e5a394c; Od637337933e7; O870517135424

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-inbevBELLA VINO FINE WINES
2778380
29970 W 12 MILE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
42.50011, -83.345762026-11-112026-11-12
mi-lccBELLA VINO FINE WINE & SPIRITS
legal name: A-ONE WINE AND LIQUOR, LLC
L-000455137
29970-29980 W 12 MILE RD, FARMINGTON HILLS, MI, 48334248851234442.49961, -83.346092026-11-032026-11-05
mi-lccBELLA VINO FINE WINE & SPIRITS
legal name: A-ONE WINE AND LIQUOR, LLC
L-000455138
29970-29980 W 12 MILE RD, FARMINGTON HILLS, MI, 48334248851234442.49961, -83.346092026-11-032026-11-05
vtinfoBELLA VINO FINE WINES
545191f23d4fe2f7
29970 W 12 MILE RD, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
248851234442.49992, -83.346242026-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 BELLA VINO FINE WINESvtinfo BELLA VINO FINE WINES1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 45 m apart · name similarity 1.00
mi-lcc BELLA VINO FINE WINE & SPIRITSmi-lcc BELLA VINO FINE WINE & SPIRITS1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev BELLA VINO FINE WINESmi-lcc BELLA VINO FINE WINE & SPIRITS0.66Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (95% confident; asked as a “near” pair)
The names match: 'Bella Vino Fine Wines' and 'Bella Vino Fine Wine & Spirits' are one distinctive name. They share the same street number on W 12 Mile Rd, ZIP 48334, sit 62 m apart, and only one busin
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 93% confident — Bella Vino name matches at same address
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records name nearly the same store, BELLA VINO FINE WINE(S), at 29970 W 12 Mile Rd in ZIP 48334, with coordinates 62 m apart and only one business at that address; the Farmington versus Farmington Hills city difference is a common mailing-address variation.
pair 038060b7d21ad65c9b97
ab-inbev BELLA VINO FINE WINESmi-lcc BELLA VINO FINE WINE & SPIRITS0.66Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Bella Vino same address range
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records carry nearly the same trade name (BELLA VINO FINE WINES vs BELLA VINO FINE WINE & SPIRITS) at the same street address (29970 W 12 Mile Rd, with the MI-LCC record giving the 29970-29980 range), in the same ZIP 48334, about 62 m apart, with no other business at that address; the city difference (Farmington vs Farmington Hills) is a common postal-name variation in this ZIP.
pair 0cdc0fc96b76abd3fc10
mi-lcc BELLA VINO FINE WINE & SPIRITSvtinfo BELLA VINO FINE WINES0.66Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (97% confident; asked as a “near” pair)
Same name, address, phone
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records share the same name BELLA VINO (fine wine and spirits), an identical phone number, a matching ZIP, a 36-metre coordinate distance, and only one business at the address, so the MI licence and the VIP brand-finder listing describe one retail outlet; the 'A-ONE WINE AND LIQUOR' legal entity is consistent with a DBA.
pair 2e3b6977e284e96847d1
mi-lcc BELLA VINO FINE WINE & SPIRITSvtinfo BELLA VINO FINE WINES0.66Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Same name, address, phone
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name Bella Vino Fine Wine(s) at the same street address (29970 W 12 Mile Rd, ZIP 48334) with identical phone numbers and coordinates about 36 m apart, and the building holds only this one business, so they are one liquor retailer listed under its DBA in the state licence source and its brand-carrying listing in the VIP source.
pair 37d1569a1766c7eba931

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
A-ONE WINE AND LIQUOR, LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
51 within 1 mi · 331 within 3 mi
Off / on premise
9 / 34 within 1 mi · 79 / 196 within 3 mi
Selling alcohol
19 within 1 mi · 145 within 3 mi
Nearest
same channel 0.33 mi · licensed 0.11 mi
Setting
suburban (2,460 people per sq mi)
People within 3 mi
69,565 (54,958 adults 21+, 29,883 households) from 20 tract(s), tracts within 3 mi
Income
per capita $56,636 · median household ~$104,574 (weighted mean of tract medians)
Age and education
median age ~45.6 · bachelor's or higher 56%
Ethnicity
Hispanic 2% · White 57% · Black 27% · Asian 8%
Adults per alcohol outlet
376
Alcohol spend within 3 mi
$22,850,207 a year ($10,234,864 at home, $12,605,791 away) · $156,508 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-19 20:37insertmi-lcc L-000455138 ↔ vtinfo 545191f23d4fe2f7Claude judge: samemerged17
2026-11-19 20:37insertmi-lcc L-000455137 ↔ vtinfo 545191f23d4fe2f7Claude judge: samemerged17
2026-11-12 17:29insertab-inbev 2778380 ↔ mi-lcc L-000455138Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2778380 ↔ mi-lcc L-000455137Claude judge: samemerged12
2026-11-12 14:25insertab-inbev 2778380 ↔ vtinfo 545191f23d4fe2f7same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000455137 ↔ mi-lcc L-000455138one store listed twicemerged