Castle Farms

Charlevoix, MI 49720 · O026e659ac6d1 · first seen 2026-11-03
3 sourceson premise · predictedalcohol: 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
Castle Farms 2 other
a source's own spelling of the licence name (record_title.py)
LINDASFARM, LLC mi-lcc (legal name) ×2
CASTLE FARMS KNIGHTS CAST ab-inbev
Street
5052 M 66 N 1 other
mi-lcc
5052 M-66 overture
City
Charlevoix
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49720
mi-lccno other value
Pin
45.28030, -85.22983 map 2 other
overture
169 m away mi-lcc ×2
151 m away ab-inbev
Phone
2312370884 1 other
overture
2370884249 mi-lcc ×2
Licences
mi-lcc L-000473319 · mi-lcc L-000486371
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocf1d0df018c1; Ofe61b6abdeba; O5f72215cc581

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-inbevCASTLE FARMS KNIGHTS CAST
2540290
5052 M 66 N, CHARLEVOIX, MI, 4972045.27935, -85.231202026-11-122026-11-16
mi-lccCASTLE FARMS
legal name: LINDASFARM, LLC
L-000473319
5052 M 66 N, Charlevoix, MI, 49720237088424945.27973, -85.231832026-11-032026-11-05
mi-lccCASTLE FARMS
legal name: LINDASFARM, LLC
L-000486371
5052 M 66 N, Charlevoix, MI, 49720237088424945.27973, -85.231832026-11-032026-11-05
overtureCastle Farms
a67b14aa-073b-4da0-9075-0e759828c36d
5052 M-66, Charlevoix, MI, 49720231237088445.28030, -85.229832026-11-182026-11-18

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 CASTLE FARMSmi-lcc CASTLE FARMS1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc CASTLE FARMSoverture Castle Farms1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 169 m apart · name similarity 1.00 · street similarity 0.80
mi-lcc CASTLE FARMSoverture Castle Farms1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 169 m apart · name similarity 1.00 · street similarity 0.80
ab-inbev CASTLE FARMS KNIGHTS CASTmi-lcc CASTLE FARMS0.57one name contains the other, same addressmergedjudge: None · pair_id: 7f5e8b457557103eb1d0 · person: None · rule: names contained at one address · stratum: near
ab-inbev CASTLE FARMS KNIGHTS CASTmi-lcc CASTLE FARMS0.57one name contains the other, same addressmergedjudge: None · pair_id: d4fdbf0f8dfe646c9bc0 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
LINDASFARM, 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 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
0 within 1 mi · 48 within 3 mi
Off / on premise
0 / 0 within 1 mi · 13 / 13 within 3 mi
Selling alcohol
0 within 1 mi · 38 within 3 mi
Nearest
same channel none within 3 mi · licensed 1.79 mi
Setting
rural (86 people per sq mi)
People within 3 mi
2,427 (1,963 adults 21+, 1,324 households) from 1 tract(s), tracts within 3 mi
Income
per capita $56,133 · median household ~$49,821 (weighted mean of tract medians)
Age and education
median age ~47.0 · bachelor's or higher 39%
Ethnicity
Hispanic 4% · White 93% · Black 1% · Asian 0%
Adults per alcohol outlet
50
Alcohol spend within 3 mi
$730,724 a year ($345,020 at home, $385,440 away) · $18,737 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-18 18:58insertmi-lcc L-000473319 ↔ overture a67b14aa-073b-4da0-9075-0e759828c36dstreet written two waysmerged15
2026-11-18 18:58insertmi-lcc L-000486371 ↔ overture a67b14aa-073b-4da0-9075-0e759828c36dstreet written two waysmerged15
2026-11-16 14:56insertab-inbev 2540290 ↔ mi-lcc L-000486371one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2540290 ↔ mi-lcc L-000473319one name contains the other, same addressmerged15
2026-11-03 13:33backfillmi-lcc L-000473319 ↔ mi-lcc L-000486371one store listed twicemerged