Case Study

Zillow Agent Data Extraction

The Challenge: A national real estate investment firm needed direct mobile numbers for thousands of active real estate agents to send bulk SMS offers for off-market properties. Manual data entry was too slow, and off-the-shelf lists were full of disconnected landlines.

The Solution

I deployed a custom Python automation script to extract publicly available agent data directly from state licensing boards and major real estate directories like Zillow and Realtor.com. Instead of scraping blindly, the script cross-referenced the names against specialized mobile carrier databases to ensure we were capturing direct cell phone numbers, not office switchboards.

The Execution

  • Targeted Extraction: Scraped profiles of agents who had completed at least 5 transactions in the last 12 months within the target zip codes.
  • Data Enrichment: Processed the raw names through a premium mobile-number enrichment API to append direct SMS-capable numbers.
  • DNC Scrubbing: Scrubbed the entire dataset against the National Do Not Call (DNC) registry and litigation lists to ensure absolute compliance for the SMS campaign.

The Results

  • Delivered 8,500 highly active, SMS-ready agent profiles within 72 hours.
  • The client achieved a 22% response rate on their first bulk SMS blast.
  • Closed 4 off-market wholesale deals directly attributed to the data list.