🌱 Seed-URLs (13) · 📞 24 Kontakte (📧 18 / 📱 10)
active
#44 WEALTH-CH-2660646-RESIDENCY_ADVISORY — Genève — Residency Advisors (Atlas)
Region: CH / Genève
✏️ Projekt bearbeiten
Fragestellung: Welche Residency Advisors haben aktiven Sitz in Genève 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
13
alle Zeiträume
davon legit
13
100% der Auswahl
Seeds mit Kontakten
13
24 Kontakte auf diesen Seeds
Kontakte gesamt
24
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 = 44 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9028 | 22.05.2026 21:18 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | CSB Group |
The page belongs to CSB Group, a single real company offering residence by investment services.
|
3 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9027 | 22.05.2026 21:18 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Immigration-Lawyer.ch / Sara Brandon |
STECKBRIEF: Schweizer Kanzlei für Migrations- und Ausländerrecht mit Fokus auf Aufenthaltsbewilligungen, Visa, Einbürger…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 9026 | 22.05.2026 21:18 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Henley & Partners |
Henley & Partners is a single firm offering residence and citizenship planning services.
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9025 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Astons |
STECKBRIEF: Internationales Beratungsunternehmen für Residency- und Citizenship-by-Investment, mit Programmen wie EB-5 s…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9024 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | NTL Trust |
NTL Trust ist ein internationaler Beratungsdienstleister für Second Citizenship (Staatsbürgerschaft durch Investition), …
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9023 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Richmond Chambers Switzerland |
STECKBRIEF: Schweizer Niederlassung einer Immigration-Law-Firm mit Fokus auf Swiss residency und UK-Immigration matters.…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 9022 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Saad Ahsan Residency & Citizenship |
Residency- und Citizenship-by-Investment-Beratung mit Hauptsitz in Lahore, Pakistan. Gegründet von Ahsan Khaliq (laut Fo…
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9021 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Lincoln Global Partners |
Residency and citizenship advisory firm focused on investment migration. The page positions Switzerland as a residency-b…
Ganz ansehen
|
4 Contacts | 0 | — | Email 🌐 EN | gecrawlt+✓ | |||
| 9020 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | La Vida Golden Visas (goldenvisas.co |
La Vida ist ein auf Investment Migration spezialisiertes Beratungsunternehmen mit Hauptsitz in London (Uxbridge). Gegrün…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9019 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Harvey Law Group |
International immigration law firm covering residency-by-investment programs across many countries. The page explains pr…
Ganz ansehen
|
2 Contacts | 0 | — | Email 🌐 EN | gecrawlt+✓ | |||
| 9018 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | RIF Trust |
RIF Trust ist ein weltweit tätiger Berater für Residency-by-Investment und Citizenship-by-Investment, spezialisiert auf …
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9017 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Ingwe Global |
Immigration and residency advisory firm publishing educational content on golden visa investment structures. The page co…
Ganz ansehen
|
2 Contacts | 0 | — | Email 🌐 EN | gecrawlt+✓ | |||
| 9016 | 22.05.2026 21:17 |
legit | WEALTH-CH-2660646-RESIDENCY_ADVISORY | Henley & Partners |
The website belongs to Henley & Partners, a single firm offering residence and citizenship planning services.
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt |