đ± Seed-URLs (8) · đ 10 Kontakte (đ§ 7 / đ± 7)
active
#672 WEALTH-US-5809844-RESIDENCY_ADVISORY â Seattle â Residency Advisors (Atlas)
Region: US / Seattle
âïž Projekt bearbeiten
Fragestellung: Welche Residency Advisors haben aktiven Sitz in Seattle und bedienen vermögende Privatkunden?
Ziel: Echte Firmen (keine LinkedIn-Profile, keine Verzeichnis-Listings, keine Job-Portale). Pro Firma: Name, Webseite, Adresse, Hauptkontakt-E-Mail/Telefon, GrĂŒndungsjahr wenn auffindbar, Regulator/Aufsicht, Mitgliedschaften wenn ersichtlich, Klientelfokus. Max. 15 valide Kandidaten.
Seeds in Auswahl
8
alle ZeitrÀume
davon legit
8
100% der Auswahl
Seeds mit Kontakten
8
10 Kontakte auf diesen Seeds
Kontakte gesamt
10
alle Kontakte im Projekt
SQL der Abfrage anzeigen
SELECT s.*, p.project_code, p.question,
(SELECT COUNT(*) FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id) AS contact_count,
EXISTS(SELECT 1 FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id AND COALESCE(c.email,'') <> '') AS has_email,
EXISTS(SELECT 1 FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id AND COALESCE(c.phone,'') <> '') AS has_phone,
(SELECT COUNT(*) FROM COMMUNICATION_EVENTS_events e
JOIN WEBRESEARCH_contacts c2 ON c2.id = e.contact_id
WHERE c2.seed_url_id = s.id AND e.channel = 'email' AND e.sent_at IS NOT NULL) AS attempt_count,
(SELECT COUNT(DISTINCT c3.id) FROM WEBRESEARCH_contacts c3
JOIN EMail_blocklist b3 ON LOWER(b3.email) = LOWER(c3.email)
WHERE c3.seed_url_id = s.id
AND (b3.expires_at IS NULL OR b3.expires_at > NOW())) AS blocked_count,
(SELECT c4.email FROM WEBRESEARCH_contacts c4
JOIN EMail_blocklist b4 ON LOWER(b4.email) = LOWER(c4.email)
WHERE c4.seed_url_id = s.id
AND (b4.expires_at IS NULL OR b4.expires_at > NOW())
ORDER BY c4.id ASC LIMIT 1) AS blocked_sample_email
FROM WEBRESEARCH_seed_urls s
LEFT JOIN WEBRESEARCH_projects p ON p.id = s.project_id
WHERE s.is_craweled >= 1 AND NOT EXISTS (SELECT 1 FROM EMail_blocklist b
JOIN WEBRESEARCH_contacts c5 ON LOWER(b.email) = LOWER(c5.email)
WHERE c5.seed_url_id = s.id
AND (b.expires_at IS NULL OR b.expires_at > NOW())) AND s.project_id = 672 AND (SELECT COUNT(*) FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id) > 0
ORDER BY s.id DESC
LIMIT 50 OFFSET 0
| ID | Erstellt | Status | URL | Projekt | Firma | Kurztext | Contacts | Versuche | đ« | Kontakt | Crawl | âïž Draft | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12605 | 24.05.2026 15:19 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | American Life, Inc. |
American Life, Inc. ist das am lĂ€ngsten bestehende USCIS-zugelassene EB-5 Regional Center in den USA (gegrĂŒndet 1996). DâŠ
Ganz ansehen
|
1 Contact | 0 | â | Email đ EN | gecrawlt+â | |||
| 12604 | 24.05.2026 15:19 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | American Life Inc |
EB-5 regional center and investment sponsor based in Seattle. Focuses on EB-5 visa investment projects, especially hospiâŠ
Ganz ansehen
|
1 Contact | 0 | â | Email Phone đ EN | gecrawlt+â | |||
| 12603 | 24.05.2026 15:19 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | Watson Immigration Law, LLC |
Watson Immigration Law ist eine auf US-Einwanderungsrecht spezialisierte Anwaltskanzlei mit Sitz in Seattle, Washington âŠ
Ganz ansehen
|
1 Contact | 0 | â | Email Phone đ EN | gecrawlt+â | |||
| 12601 | 24.05.2026 15:19 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | Stelmakh & Associates LLC |
Stelmakh & Associates LLC ist eine auf US-Einwanderungsrecht spezialisierte Anwaltskanzlei mit Sitz in Seattle, WashingtâŠ
Ganz ansehen
|
1 Contact | 0 | â | Email Phone đ EN | gecrawlt+â | |||
| 12600 | 24.05.2026 15:19 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | Crescent Law, PLLC |
Seattle immigration law firm advising on E-2 treaty investor visas, H-1B, work visas, and employment-based immigration. âŠ
Ganz ansehen
|
1 Contact | 0 | â | Phone đ EN | gecrawlt+â | kein Email-Kontakt | ||
| 12599 | 24.05.2026 15:19 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | Henley & Partners |
The website belongs to Henley & Partners, a single real firm offering residence and citizenship planning services.
|
1 Contact | 0 | â | Phone đ EN | gecrawlt+â | kein Email-Kontakt | ||
| 12598 | 24.05.2026 15:18 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | Bay Legal PC |
California-focused EB-5 immigration law site operated by Bay Legal PC. Content centers on EB-5 investor visas, source ofâŠ
Ganz ansehen
|
1 Contact | 0 | â | Phone đ EN | gecrawlt+â | kein Email-Kontakt | ||
| 12597 | 24.05.2026 15:17 |
legit | WEALTH-US-5809844-RESIDENCY_ADVISORY | Latitude Group (Latitude Consultancy |
Latitude Group ist ein globaler Spezialist fĂŒr Residence-by-Investment und Citizenship-by-Investment mit Hauptsitz in JeâŠ
Ganz ansehen
|
3 Contacts | 0 | â | Email Phone đ EN | gecrawlt+â |