🌱 Seed-URLs (12) · 📞 17 Kontakte (📧 11 / 📱 13)
active
#333 WEALTH-US-5128581-RESIDENCY_ADVISORY — New York City — Residency Advisors (Atlas)
Region: US / New York City
✏️ Projekt bearbeiten
Fragestellung: Welche Residency Advisors haben aktiven Sitz in New York City 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, Regulator/Aufsicht, Mitgliedschaften. Max. 15 valide Kandidaten.
Seeds in Auswahl
12
alle Zeiträume
davon legit
12
100% der Auswahl
Seeds mit Kontakten
12
17 Kontakte auf diesen Seeds
Kontakte gesamt
17
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 = 333 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9761 | 23.05.2026 04:17 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Eiges & Eiges, PC |
Eiges & Eiges, PC ist eine auf Einwanderungsrecht spezialisierte Anwaltskanzlei mit Sitz in New York City. Die Kanzlei w…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 9760 | 23.05.2026 04:17 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Katona & Associates, PLLC |
New Yorker Immigration law firm in Manhattan, focused on investor visas and broader immigration matters. The firm serves…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 9759 | 23.05.2026 04:17 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | La Vida Golden Visas (goldenvisas.co |
La Vida Golden Visas ist ein auf Investment Migration spezialisierter Beratungsdienstleister mit Hauptsitz in London (Ux…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9758 | 23.05.2026 04:17 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Wildes & Weinberg, P.C. |
Established New York immigration law firm handling investor visas and broader immigration matters. The site highlights l…
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9757 | 23.05.2026 04:17 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | The Law Offices of Cheryl R. David |
Spezialisierte Einwanderungsrechtskanzlei mit Sitz in New York City (299 Broadway, Suite 706, New York, NY 10007 – mitte…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 9756 | 23.05.2026 04:17 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | EB5AN / EB5 Visa Investments |
EB-5 investment platform and regional-center operator focused on New York and other U.S. markets. The site promotes USCI…
Ganz ansehen
|
3 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9755 | 23.05.2026 04:17 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Pozo Goldstein, LLP |
Pozo Goldstein, LLP ist eine auf Einwanderungsrecht spezialisierte Anwaltskanzlei mit Sitz in New York City (Manhattan).…
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9754 | 23.05.2026 04:16 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Holborn Pass |
Residency-by-investment specialist focused on EB-5 for the United States. The site positions the firm as part of Holborn…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9753 | 23.05.2026 04:16 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Law Office of Alena Shautsova, P.C. |
Einwanderungsrechtskanzlei mit Sitz in New York City (Brooklyn) und Amityville (Long Island), gegründet 2008 von Alena S…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 9752 | 23.05.2026 04:16 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Henley & Partners |
Global residence and citizenship by investment advisory firm with a strong U.S. EB-5 offering. The site emphasizes compr…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt | ||
| 9751 | 23.05.2026 04:16 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | Harvey Law Group (HLG) |
Harvey Law Group (HLG) ist eine internationale Anwaltskanzlei mit Spezialisierung auf Investment Immigration und Busines…
Ganz ansehen
|
2 Contacts | 0 | — | Email 🌐 EN | gecrawlt+✓ | |||
| 9750 | 23.05.2026 04:16 |
legit | WEALTH-US-5128581-RESIDENCY_ADVISORY | New York Immigration Fund |
New York City-based EB-5 immigration investor fund focused on helping foreign investors and their families obtain perman…
Ganz ansehen
|
1 Contact | 0 | — | Phone 🌐 EN | gecrawlt+✓ | kein Email-Kontakt |