Gabriel Farms LLC

Petoskey, MI 49770 · O0009bee33cb7 · first seen 2026-11-03
3 sourcesoff premise · liquor_storealcohol: licensed5 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
Gabriel Farms LLC 1 other
a source's own spelling of the licence name (record_title.py)
Gabriel Farms & Winery overture
Street
2800 E Mitchell Rd
mi-lccno other value
City
Petoskey
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49770
mi-lccno other value
Pin
45.37261, -84.91289 map 2 other
overture
145 m away mi-lcc ×4
145 m away ttb
Phone
2316228880 1 other
overture
2318383664 mi-lcc ×4
Licences
mi-lcc L-000427377 · mi-lcc L-000427378 · mi-lcc L-000427379 · mi-lcc L-000440378 · ttb MI-W-21380
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O62a10c4332af; Oe5ed705ad404; Oa6169f5750b2; O142c9bff55b1; O7b5aafbcb9c0

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
mi-lccGABRIEL FARMS LLC
L-000427377
2800 E Mitchell Rd, Petoskey, MI, 49770231838366445.37378, -84.912072026-11-032026-11-04
mi-lccGABRIEL FARMS LLC
L-000427378
2800 E Mitchell Rd, Petoskey, MI, 49770231838366445.37378, -84.912072026-11-032026-11-04
mi-lccGABRIEL FARMS LLC
L-000427379
2800 E Mitchell Rd, Petoskey, MI, 49770231838366445.37378, -84.912072026-11-032026-11-04
mi-lccGABRIEL FARMS LLC
L-000440378
2800 E Mitchell Rd, Petoskey, MI, 49770231838366445.37378, -84.912072026-11-032026-11-04
overtureGabriel Farms & Winery
3bf3659b-8342-4fd2-a1cb-55a2471f26a5
2800 E Mitchell Rd, Petoskey, MI, 49770231622888045.37261, -84.912892026-11-062026-11-06
ttbGabriel Farms LLC
MI-W-21380
2800 E MITCHELL RD, PETOSKEY, MI, 4977045.37378, -84.912072026-11-032026-11-04

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
mi-lcc GABRIEL FARMS LLCmi-lcc GABRIEL FARMS LLC1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc GABRIEL FARMS LLCmi-lcc GABRIEL FARMS LLC1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc GABRIEL FARMS LLCmi-lcc GABRIEL FARMS LLC1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc GABRIEL FARMS LLCttb Gabriel Farms LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc GABRIEL FARMS LLCttb Gabriel Farms LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc GABRIEL FARMS LLCttb Gabriel Farms LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc GABRIEL FARMS LLCttb Gabriel Farms LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc GABRIEL FARMS LLCoverture Gabriel Farms & Winery0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 145 m apart · name similarity 0.73 · phone: differs
mi-lcc GABRIEL FARMS LLCoverture Gabriel Farms & Winery0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 145 m apart · name similarity 0.73 · phone: differs
mi-lcc GABRIEL FARMS LLCoverture Gabriel Farms & Winery0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 145 m apart · name similarity 0.73 · phone: differs
mi-lcc GABRIEL FARMS LLCoverture Gabriel Farms & Winery0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 145 m apart · name similarity 0.73 · phone: differs
overture Gabriel Farms & Wineryttb Gabriel Farms LLC0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 145 m apart · name similarity 0.73

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GABRIEL FARMS LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — MI Manufacturer/Direct Shipper; MI Manufacturer/Micro Brewer; MI Manufacturer/On-Premises Tasting Room Permit; MI Manufacturer/Small Wine Maker
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
3 within 1 mi · 102 within 3 mi
Off / on premise
2 / 0 within 1 mi · 29 / 42 within 3 mi
Selling alcohol
2 within 1 mi · 68 within 3 mi
Nearest
same channel 0.40 mi · licensed 0.40 mi
Setting
rural (130 people per sq mi)
People within 3 mi
3,686 (2,859 adults 21+, 1,594 households) from 1 tract(s), tracts within 3 mi
Income
per capita $55,290 · median household ~$86,806 (weighted mean of tract medians)
Age and education
median age ~40.2 · bachelor's or higher 60%
Ethnicity
Hispanic 2% · White 88% · Black 1% · Asian 1%
Adults per alcohol outlet
41
Alcohol spend within 3 mi
$1,203,094 a year ($538,322 at home, $664,402 away) · $17,436 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-06 18:13insertoverture 3bf3659b-8342-4fd2-a1cb-55a2471f26a5 ↔ ttb MI-W-21380same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000440378 ↔ overture 3bf3659b-8342-4fd2-a1cb-55a2471f26a5same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000427379 ↔ overture 3bf3659b-8342-4fd2-a1cb-55a2471f26a5same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000427378 ↔ overture 3bf3659b-8342-4fd2-a1cb-55a2471f26a5same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000427377 ↔ overture 3bf3659b-8342-4fd2-a1cb-55a2471f26a5same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000440378 ↔ ttb MI-W-21380same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000427379 ↔ ttb MI-W-21380same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000427378 ↔ ttb MI-W-21380same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000427377 ↔ ttb MI-W-21380same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000427377 ↔ mi-lcc L-000440378one store listed twicemerged
2026-11-03 13:33backfillmi-lcc L-000427377 ↔ mi-lcc L-000427379one store listed twicemerged
2026-11-03 13:33backfillmi-lcc L-000427377 ↔ mi-lcc L-000427378one store listed twicemerged