Stony Lake Inn

Shelby, MI 49455 · O611c46d3cb66 · first seen 2026-11-03
4 sourceson premise · restaurantalcohol: 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
Stony Lake Inn 1 other
a source's own spelling of the licence name (record_title.py)
STONY LAKE INVESTMENTS, INC. mi-lcc (legal name) ×2
Street
4722 S Scenic Dr 2 other
mi-lcc
4722 S SCENIC DRIVE ab-inbev
4722 Scenic Dr overture
City
Shelby
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49455
mi-lccno other value
Pin
43.56089, -86.49935 map 3 other
overture
53 m away mi-lcc ×2
95 m away ab-inbev
122 m away inspections
Phone
2318614427
overtureno other value
Licences
mi-lcc L-000170685 · mi-lcc L-000170686
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of7d685177d9b; Oc64698a587c8; Oc467ab190853; Obc68359636ee

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-inbevSTONY LAKE INN
3057701
4722 S SCENIC DRIVE, SHELBY, MI, 4945543.56014, -86.498812026-11-152026-11-20
inspectionsSTONY LAKE INN
inspections|mi|SFE-2764-061631
4722 S SCENIC DR, Shelby, MI, 4945543.56005, -86.498392026-11-202026-11-20
mi-lccSTONY LAKE INN
legal name: STONY LAKE INVESTMENTS, INC.
L-000170685
4722 S Scenic Dr, Shelby, MI, 49455231861442743.56045, -86.499602026-11-032026-11-20
mi-lccSTONY LAKE INN
legal name: STONY LAKE INVESTMENTS, INC.
L-000170686
4722 S Scenic Dr, Shelby, MI, 49455231861442743.56045, -86.499602026-11-032026-11-20
overtureStony Lake Inn
89ecf683-0e5b-42e0-8133-8295df9fe899
4722 Scenic Dr, Shelby, MI, 49455231861442743.56089, -86.499352026-11-182026-11-20

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 STONY LAKE INNinspections STONY LAKE INN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00
ab-inbev STONY LAKE INNmi-lcc STONY LAKE INN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 72 m apart · name similarity 1.00
ab-inbev STONY LAKE INNmi-lcc STONY LAKE INN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 72 m apart · name similarity 1.00
ab-inbev STONY LAKE INNoverture Stony Lake Inn1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 95 m apart · name similarity 1.00 · street similarity 0.90
inspections STONY LAKE INNmi-lcc STONY LAKE INN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 107 m apart · name similarity 1.00
inspections STONY LAKE INNmi-lcc STONY LAKE INN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 107 m apart · name similarity 1.00
inspections STONY LAKE INNoverture Stony Lake Inn1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 122 m apart · name similarity 1.00 · street similarity 0.90
mi-lcc STONY LAKE INNmi-lcc STONY LAKE INN1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc STONY LAKE INNoverture Stony Lake Inn1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 53 m apart · name similarity 1.00 · street similarity 0.90
mi-lcc STONY LAKE INNoverture Stony Lake Inn1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 53 m apart · name similarity 1.00 · street similarity 0.90

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
STONY LAKE INVESTMENTS, INC. — 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 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-20 22:08insertinspections inspections|mi|SFE-2764-061631 ↔ overture 89ecf683-0e5b-42e0-8133-8295df9fe899street written two waysmerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-2764-061631 ↔ mi-lcc L-000170685same address and namemerged17
2026-11-20 22:08insertab-inbev 3057701 ↔ inspections inspections|mi|SFE-2764-061631same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-2764-061631 ↔ mi-lcc L-000170686same address and namemerged17
2026-11-18 18:58insertmi-lcc L-000170685 ↔ overture 89ecf683-0e5b-42e0-8133-8295df9fe899street written two waysmerged15
2026-11-18 18:58insertab-inbev 3057701 ↔ overture 89ecf683-0e5b-42e0-8133-8295df9fe899street written two waysmerged15
2026-11-18 18:58insertmi-lcc L-000170686 ↔ overture 89ecf683-0e5b-42e0-8133-8295df9fe899street written two waysmerged15
2026-11-15 16:24insertab-inbev 3057701 ↔ mi-lcc L-000170685same address and namemerged15
2026-11-15 16:24insertab-inbev 3057701 ↔ mi-lcc L-000170686same address and namemerged15
2026-11-03 13:33backfillmi-lcc L-000170685 ↔ mi-lcc L-000170686one store listed twicemerged