The 15 clicks
From sec.gov to a clean CSV of real-estate sponsor leads
Each screenshot below was built from real EDGAR data pulled live from sec.gov. The chrome, column headers, and field names match the live site exactly. Real CIKs, real filings, real issuer names.
Go to sec.gov and click the EDGAR section. The landing page lists every search path the SEC offers, including Full-Text Search, company lookup, and the realtime feed of latest filings. For lead gen we will use a mix of Full-Text Search and the lower-level browse-edgar CGI.
What to copy. Bookmark the EDGAR home page. The three search paths cover 95% of any lead-gen workflow you will ever build on top of SEC data.
https://www.sec.gov/edgar.shtml
Click Full-Text Search. You land on a blank search form with three filters: keyword phrase, form type, and date range. With no filters applied, the form returns every filing in EDGAR, which is useless. The next two steps narrow that to real estate syndications only.
What to copy. Get familiar with the three filters. Combining all three is how you get from 10 million filings to a few hundred RE syndicators per week.
https://www.sec.gov/edgar/search/
Type D in the Forms field. The results collapse to roughly 10,000+ Form D filings sorted by most recent. That is the universe of every Accredited Investor-only private offering filed in the US. Real estate, venture capital, private equity, hedge funds, and oil-and-gas all live in this list. The next filter strips out everything except real estate.
What to copy. Save the URL with the Forms=D parameter as a permanent bookmark. Loading it always shows the most recent Form D filings, no clicks required.
https://efts.sec.gov/LATEST/search-index?q=&forms=D&hits=40
4
Add the "real estate" keyword
Type "real estate" in quotes in the search box. The quotes force exact phrase matching, which keeps the results clean. The Form D field stays at D. The result is every Form D filing whose actual filing text mentions real estate, which is almost always a real estate operator, fund, or syndication SPV.
What to copy. Always quote multi-word phrases. real estate without quotes also matches "real" and "estate" separately, which adds tens of thousands of unrelated filings (estate planning, real assets in fixed income, etc).
https://efts.sec.gov/LATEST/search-index?q=%22real+estate%22&forms=D
Each row is one filing. The columns matter: Issuer (the firm legal name), CIK, Form (D or D/A for amendments), Filing date, State, and Accession number. Click any issuer name to open that filing.
What to copy. The CIK is your join key. Save it for every lead. If the same operator files five Form Ds across multiple SPVs, the CIK lets you cluster them into one parent firm in your CRM.
6
Open a filing's document index
Click the issuer name. EDGAR loads the filing detail page, which lists every document submitted as part of the filing. For Form D, the only document that matters is primary_doc.xml. That file holds every structured field: issuer details, related persons, industry group, offering amounts, and signature block.
What to copy. Always open primary_doc.xml. The other documents in the filing are XBRL schema and metadata that the SEC needs but you do not.
The XML renders as a structured Form D. Item 1 carries the firm legal name, address, phone number, jurisdiction of incorporation, entity type, and year formed. This is your firm-level lead row. Real estate sponsors almost always file as a Delaware LLC with a California, Texas, Florida, or New York principal place of business, though the data set covers all 50 states.
What to copy. Pull the legal name, full street address, phone number, and CIK. These four fields anchor every downstream enrichment step in Apollo or Clay.
This is the section that turns EDGAR from a database of firms into a database of people. Every officer, director, general partner, managing member, and promoter named on the offering shows up here with their full name, address, and role. These are the humans you actually email. Executive Officers and Directors are your highest priority.
What to copy. Every name plus the role tag. Aim for two to four contacts per firm. In your CRM, tag each row with the firm CIK so you can deduplicate across multiple offerings by the same operator.
Item 6 is where the filer self-classifies. The two values that matter for real estate lead gen are Real Estate (direct operating companies that hold property) and Pooled Investment Fund (the syndication vehicles that hold and operate property through SPVs). If a Form D shows either value here and also mentions "real estate" in the filing text, it is a clean RE syndication lead.
What to copy. Drop everything that is not Real Estate or Pooled Investment Fund. This single filter removes 70% of the noise from any keyword-based pull.
10
Item 13. Offering and Sales
Item 13 carries the dollar amounts: total offering size, amount already sold, minimum check, and number of investors. Item 17 directly below it holds the signature block, which tells you which human at the firm signed off on the filing. The signatory is often the principal or CFO, which makes them a strong direct outreach target.
What to copy. Offering size is your qualifier. A firm raising $5M+ has budget for an agency retainer. Anything under $1M usually does not. Add total offering, minimum investment, and the signatory name and title to every lead row.
11
Open the browse-edgar form path
Full-Text Search is great for keyword work, but the older browse-edgar CGI endpoint lets you filter by exact SIC code, exact state, and exact form type at the URL level. That precision matters when you want to pull every RE-classified Form D in a 30-day window with no false positives. The URL pattern is simple and is the same every week.
What to copy. Memorize the URL pattern. Anywhere you can read a URL, you can read the live Form D feed.
https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&type=D&dateb=&owner=include&count=40
Add &SIC=6500 to the URL. SIC stands for SIC code, and 6500 is the root code for Real Estate. The subcodes inside the 6500 family cover operators of buildings (6512), subdividers and developers (6552), and real estate investment trusts (6798). Combining the SIC filter with the Form D filter gives you the cleanest possible cut of the data set.
What to copy. Try SIC 6500, 6510, 6512, 6552, 6798, and 6770. Run all six monthly and merge the results. That combo captures direct RE operators, REITs, and the blank-check SPVs that syndications often file under.
13
Drill into a specific sponsor's CIK page
Once you have an interesting issuer, load its CIK page. The URL pattern is /cgi-bin/browse-edgar?action=getcompany&CIK=XXXXXXXXXX. The page lists every filing the firm has ever made: Form Ds, amendments, and any other SEC submissions. Multiple filings often mean multiple SPVs, multiple offerings, and multiple sets of related persons to scrape.
What to copy. Pull every primary_doc.xml from every D and D/A for that CIK. Amendments often add new related persons (a new CFO, a new managing member) who are not on the original filing.
14
Pull the last 30 days only
Set the date range to the last 30 days. New filings mean new capital raised, which means active deal activity and fresh budget. The recency filter is the single highest-leverage move in this entire workflow, because cold outreach lands ten times better when the prospect just closed a raise than when their last filing was four years ago.
What to copy. Run this same query every Monday. The full pipeline below takes about 90 minutes a week and replaces every list-rental service most agencies pay for.
15
Export to CSV, then enrich and load
Parse the primary_doc.xml from every matching filing into a single CSV with one row per related person. The columns you want: firm, CIK, state, SIC, person name, person role, offering size, status (506(b) or 506(c)), filing date. Load the CSV into Apollo to enrich each row with a verified work email, then push the enriched rows into PlusVibe (or your sending tool of choice) as a fresh sequence segment.
What to copy. One row per person, not per firm. Two contacts at the same firm doubles your reply probability and is fully consistent with cold-email best practice on a firm that just publicly raised capital.