🌱 Seed-URLs (10) · 📞 19 Kontakte (📧 10 / 📱 13)
active
#702 WEALTH-US-5391811-RESIDENCY_ADVISORY — San Diego — Residency Advisors (Atlas)
Region: US / San Diego
✏️ Projekt bearbeiten
Fragestellung: Welche Residency Advisors haben aktiven Sitz in San Diego 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
10
alle Zeiträume
davon legit
10
100% der Auswahl
Seeds mit Kontakten
10
19 Kontakte auf diesen Seeds
Kontakte gesamt
19
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 = 702 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13793 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | Golden Opportunity Regional Center |
EB-5 Regional Center und Investment-Migration-Anbieter mit Fokus auf US-Aufenthalt über Kapitalanlage, Schwerpunkt San D…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 13792 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | Americana Pacific Law Group |
Americana Pacific Law Group ist eine auf Einwanderungsrecht spezialisierte Anwaltskanzlei mit Sitz in San Diego, Kalifor…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 13791 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | San Diego Immigration in California |
Immigration assistant / law-firm style site offering EB-5 investor program guidance and related immigration services for…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 13790 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | Jacobs & Schlesinger LLP |
Jacobs & Schlesinger LLP (jsslegal.com) ist eine auf Einwanderungsrecht spezialisierte Anwaltskanzlei mit Sitz in San Di…
Ganz ansehen
|
2 Contacts | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 13789 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | Henley & Partners |
Global residence and citizenship planning firm focused on residence by investment and citizenship-by-investment advisory…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 13788 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | Law Offices of Hasbini |
Einwanderungsrechtskanzlei mit Sitz in San Diego (425 W Beech St UNIT 538, San Diego, CA 92101). Spezialisiert auf US-Ei…
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 13787 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | San Diego Creative Investors Associa |
San Diego-based real estate investor association and club, founded in 1976. The organization serves real estate investor…
Ganz ansehen
|
1 Contact | 0 | — | Email 🌐 EN | gecrawlt+✓ | |||
| 13786 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | EB5AN (EB-5 Affiliate Network) |
EB5AN ist ein staatlich autorisierter EB-5 Regional Center Betreiber, EB-5 Beratungsfirma und globaler Investmentfonds-M…
Ganz ansehen
|
6 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 13785 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | Law Offices of Jacob J. Sapochnick |
San Diego immigration law firm focused on EB-5 green card and investment-based immigration matters. The site explains th…
Ganz ansehen
|
2 Contacts | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 13784 | 26.05.2026 04:16 |
legit | WEALTH-US-5391811-RESIDENCY_ADVISORY | Feldman Feldman & Associates, PC |
Einwanderungsrechtskanzlei mit Sitz in San Diego, Kalifornien, spezialisiert auf EB-5 Investor Green Cards (Investoren-G…
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ |