What this is
Rachel sent overWinter_Park_Active_Homeowners_2026-04-23.xlsx — the canonical list of active SkyRun Grand County homeowners. Lives at /Users/josephbowens/Desktop/SkyRun/Winter_Park_Active_Homeowners_2026-04-23.xlsx.
This is the source of truth for "current customer" — NOT HubSpot lifecyclestage=customer. HS lifecycles have proven unreliable (Froelich + 7 other mismatches). Rachel's list is the authority.
Contents (as of 2026-04-23)
- 73 unique units managed by SkyRun Grand County
- 128 contact rows (primary + secondary per unit)
- 110 unique emails (primary + secondary per contact)
- 97 unique phones (10-digit) (home + mobile)
Columns
| Column | Use |
|---|---|
| Unit Name | Property address / name (73 unique) |
| Company | Owner entity (LLC, trust, or individual) |
| Contact | Person name |
| Email / Secondary Email | Both count as DNC |
| Home Phone / Mobile Phone | Both count as DNC (match on last-10-digit) |
| Company/Contact Street/City/Region/Postal | Owner mailing addresses |
| Is Active | 1.0 = active customer |
| Owner Liaison | Rachel's assigned liaison per unit |
Canonical derived files
/Users/josephbowens/Desktop/SkyRun/Current Owner Audit 2026-04-22/active_homeowners_canonical.json— parsed JSON, 128 rows + dedup email/phone sets/Users/josephbowens/Desktop/SkyRun/Current Owner Audit 2026-04-22/DNC_canonical_v2.json— unified DNC list (Rachel + HS expansion = 111 emails)
How to apply
Every outbound skill (SmartLead, live-ea, property-scout, hubspot-lead-push, daily-beenverified-enrichment, postcard-batch) MUST check against this list BEFORE drafting, sending, or enrolling: 1. Normalize target email → lowercase 2. Normalize target phone → last 10 digits 3. If email ∈active_homeowners_canonical.json:unique_emails OR phone-last10 ∈ unique_phones_last10 → HARD BLOCK from any cold outreach
4. Log the skip with reason CURRENT_HOMEOWNER to the daily report
Refresh cadence
- Rachel's list is manually delivered (no API into Track that gets this data). Ask Rachel for an updated export monthly or when she signs new owners.
- Until automation is built, treat the 2026-04-23 snapshot as authoritative.
- Nightly-consolidation should flag if the file hasn't been refreshed in >45 days.
Why this supersedes Track scrape
Rachel's list has emails. Track's UI list view only exposes phone + city — emails live on per-owner detail pages (~100+ clicks to scrape). Rachel's list is complete in one file.Known edge cases
- Some units have TWO entries (primary + secondary contact) — both emails/phones count
- Emails come in different variants across Track/HS/Rachel — always take the UNION across sources
- A few Track active accounts aren't in Rachel's list (e.g. Amanda Vrbas, Patrick Langhans) — may be owners outside Winter Park proper or recent additions. Cross-check with Track before excluding from Rachel-based DNC