Fern Hill Golf and Country Club

Clinton Township, MI 48038 · O24bc866066b3 · first seen 2026-11-03
4 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
Fern Hill Golf and Country Club 2 other
a licence name in capitals, cleaned (derived; record_title.py)
FERN HILL GOLF CLUB ab-inbevoverturevtinfo ×3
FERN HILLS ENTERTAINMENT, LLC mi-lcc (legal name) ×2
Street
17600 Clinton River Rd
mi-lccno other value
City
Clinton Township 1 other
mi-lcc
Clinton Twp overture
State
MI
mi-lccno other value
ZIP
48038
mi-lccno other value
Pin
42.58216, -82.94238 map 2 other
overture
255 m away mi-lcc ×2
241 m away vtinfo
Phone
5862864700 1 other
vtinfo
5864058453 mi-lcc ×2
Licences
mi-lcc L-000217144 · mi-lcc L-000217146
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od1c147d81d43; O80d25b7a65d9; O87779abe0f36; O655849c711e6

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-inbevFERN HILL GOLF CLUB
2549255
17600 CLINTON RIVER RD, CLINTON TOWNSHIP, MI, 4803842.58236, -82.942762026-11-112026-11-12
mi-lccFERN HILL GOLF AND COUNTRY CLUB
legal name: FERN HILLS ENTERTAINMENT, LLC
L-000217144
17600 Clinton River Rd, Clinton Township, MI, 48038586405845342.58066, -82.944732026-11-032026-11-12
mi-lccFERN HILL GOLF AND COUNTRY CLUB
legal name: FERN HILLS ENTERTAINMENT, LLC
L-000217146
17600 Clinton River Rd, Clinton Township, MI, 48038586405845342.58066, -82.944732026-11-032026-11-12
overtureFern Hill Golf Club
2dd2a316-97d2-416d-aee8-baca66d0980c
17600 Clinton River Rd, Clinton Twp, MI, 48038
ZIP lookup: Clinton Township, MI
586286470042.58216, -82.942382026-11-062026-11-12
vtinfoFERN HILL GOLF CLUB
e19106e3ff25d9e9
17600 CLINTON RIVER RD, CLINTON TOWNSHIP, MI, 48038586286470042.58004, -82.943022026-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 FERN HILL GOLF CLUBoverture Fern Hill Golf Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
ab-inbev FERN HILL GOLF CLUBvtinfo FERN HILL GOLF CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 259 m apart · name similarity 1.00
mi-lcc FERN HILL GOLF AND COUNTRY CLUBmi-lcc FERN HILL GOLF AND COUNTRY CLUB1.00one store listed twicemergedsame street + ZIP · name: identical
overture Fern Hill Golf Clubvtinfo FERN HILL GOLF CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 241 m apart · name similarity 1.00 · phone: equal
ab-inbev FERN HILL GOLF CLUBmi-lcc FERN HILL GOLF AND COUNTRY CLUB0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.89 · same street + ZIP · pins 249 m apart · name similarity 0.81
ab-inbev FERN HILL GOLF CLUBmi-lcc FERN HILL GOLF AND COUNTRY CLUB0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.89 · same street + ZIP · pins 249 m apart · name similarity 0.81
mi-lcc FERN HILL GOLF AND COUNTRY CLUBoverture Fern Hill Golf Club0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.89 · same street + ZIP · pins 255 m apart · name similarity 0.81 · phone: differs
mi-lcc FERN HILL GOLF AND COUNTRY CLUBvtinfo FERN HILL GOLF CLUB0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.89 · same street + city + state · pins 156 m apart · name similarity 0.81 · phone: differs
mi-lcc FERN HILL GOLF AND COUNTRY CLUBoverture Fern Hill Golf Club0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.89 · same street + ZIP · pins 255 m apart · name similarity 0.81 · phone: differs
mi-lcc FERN HILL GOLF AND COUNTRY CLUBvtinfo FERN HILL GOLF CLUB0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.89 · same street + city + state · pins 156 m apart · name similarity 0.81 · phone: differs

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
FERN HILLS ENTERTAINMENT, 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:35.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
16 within 1 mi · 342 within 3 mi
Off / on premise
5 / 10 within 1 mi · 83 / 191 within 3 mi
Selling alcohol
8 within 1 mi · 171 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.45 mi
Setting
urban (3,700 people per sq mi)
People within 3 mi
104,609 (82,147 adults 21+, 45,029 households) from 30 tract(s), tracts within 3 mi
Income
per capita $43,347 · median household ~$83,461 (weighted mean of tract medians)
Age and education
median age ~42.8 · bachelor's or higher 28%
Ethnicity
Hispanic 3% · White 77% · Black 11% · Asian 4%
Adults per alcohol outlet
478
Alcohol spend within 3 mi
$29,543,918 a year ($13,637,108 at home, $15,894,534 away) · $171,767 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:23insertoverture 2dd2a316-97d2-416d-aee8-baca66d0980c ↔ vtinfo e19106e3ff25d9e9same address and namemerged15
2026-11-12 14:25insertmi-lcc L-000217146 ↔ vtinfo e19106e3ff25d9e9same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000217144 ↔ vtinfo e19106e3ff25d9e9same address and namemerged12
2026-11-12 14:25insertab-inbev 2549255 ↔ vtinfo e19106e3ff25d9e9same address and namemerged12
2026-11-11 12:56insertab-inbev 2549255 ↔ mi-lcc L-000217146same address and namemerged12
2026-11-11 12:56insertab-inbev 2549255 ↔ mi-lcc L-000217144same address and namemerged12
2026-11-11 12:56insertab-inbev 2549255 ↔ overture 2dd2a316-97d2-416d-aee8-baca66d0980csame address and namemerged12
2026-11-06 18:13insertmi-lcc L-000217146 ↔ overture 2dd2a316-97d2-416d-aee8-baca66d0980csame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000217144 ↔ overture 2dd2a316-97d2-416d-aee8-baca66d0980csame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000217144 ↔ mi-lcc L-000217146one store listed twicemerged