Courtyard By Marriott

Farmington Hills, MI 48334 · O4468668d3a03 · 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
Courtyard By Marriott 2 other
a licence name in capitals, cleaned (derived; record_title.py)
STAR LODGES, LLC mi-lcc ×2
COURTYARD BY MARRIOTT BISTRO inspections
Street
33043 Hamilton Ct
mi-lccno other value
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.49687, -83.37598 map 2 other
inspections
117 m away ab-inbev
160 m away vtinfo
Phone
2485161400
vtinfono other value
Licences
mi-lcc L-000272519 · mi-lcc L-000272521
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe9c756eb6840; Oce0f838f45aa; O80f4faeae9c0; O8816e840d05d

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-inbevCOURTYARD BY MARRIOTT
4015599
33043 HAMILTON CT, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
42.49686, -83.374552026-11-112026-11-12
inspectionsCOURTYARD BY MARRIOTT BISTRO
inspections|mi|SFE-4063-236420
33043 HAMILTON CT, Farmington Hills, MI, 4833442.49687, -83.375982026-11-202026-11-20
mi-lccSTAR LODGES, LLC
L-000272519
33043 Hamilton Ct, Farmington Hills, MI, 4833442.49691, -83.375842026-11-032026-11-04
mi-lccSTAR LODGES, LLC
L-000272521
33043 Hamilton Ct, Farmington Hills, MI, 4833442.49691, -83.375842026-11-032026-11-04
vtinfoCOURTYARD BY MARRIOTT
f1c5e51a3ed8a16e
33043 HAMILTON CT, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
248516140042.49627, -83.374212026-11-122026-11-19

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 COURTYARD BY MARRIOTTvtinfo COURTYARD BY MARRIOTT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 71 m apart · name similarity 1.00
mi-lcc STAR LODGES, LLCmi-lcc STAR LODGES, LLC1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev COURTYARD BY MARRIOTTinspections COURTYARD BY MARRIOTT BISTRO0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.80 · same street + ZIP · pins 117 m apart · name similarity 0.80
inspections COURTYARD BY MARRIOTT BISTROvtinfo COURTYARD BY MARRIOTT0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.80 · same street + ZIP · pins 160 m apart · name similarity 0.80
ab-inbev COURTYARD BY MARRIOTTmi-lcc STAR LODGES, LLC0.12Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (80% confident; asked as a “same-address” pair)
The two records share an exact street address and ZIP (33043 Hamilton Ct, 48334), and 'STAR LODGES, LLC' reads as the hotel-operating legal entity behind the Courtyard by Marriott's liquor licence the
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 60% confident — Hotel at same address; Star Lodges likely licensee entity of Courtyard.
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records sit at the same street address (33043 Hamilton Ct, ZIP 48334) about 0.1 km apart, and the only two businesses there are this hotel's listings, so 'Star Lodges, LLC' is most plausibly the legal entity running the Courtyard by Marriott hotel and its licensed bar, though the names differ and no filed trade name links them.
pair 057ec4bb85aa7f977242

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
STAR LODGES, 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/B-Hotel
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
42 within 1 mi · 326 within 3 mi
Off / on premise
6 / 32 within 1 mi · 88 / 178 within 3 mi
Selling alcohol
13 within 1 mi · 158 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.12 mi
Setting
suburban (2,662 people per sq mi)
People within 3 mi
75,271 (59,258 adults 21+, 31,892 households) from 23 tract(s), tracts within 3 mi
Income
per capita $58,418 · median household ~$115,850 (weighted mean of tract medians)
Age and education
median age ~44.7 · bachelor's or higher 63%
Ethnicity
Hispanic 3% · White 58% · Black 17% · Asian 17%
Adults per alcohol outlet
373
Alcohol spend within 3 mi
$26,705,379 a year ($11,783,586 at home, $14,910,397 away) · $167,958 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-20 22:08insertinspections inspections|mi|SFE-4063-236420 ↔ vtinfo f1c5e51a3ed8a16esame address and namemerged17
2026-11-20 22:08insertab-inbev 4015599 ↔ inspections inspections|mi|SFE-4063-236420same address and namemerged17
2026-11-12 14:25insertab-inbev 4015599 ↔ mi-lcc L-000272519Claude judge: samemerged12
2026-11-12 14:25insertab-inbev 4015599 ↔ vtinfo f1c5e51a3ed8a16esame address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000272519 ↔ mi-lcc L-000272521one store listed twicemerged