Real Estate Aggregator - Zillow + Redfin + Realtor

Search all major real estate platforms at once by John Rippy | johnrippy.link

---

The Ultimate Real Estate Data Solution

Tired of checking Zillow, Redfin, AND Realtor.com separately? This actor searches all three platforms simultaneously and automatically deduplicates listings that appear on multiple sites.

What You Get:

• Unified Search: Query Zillow, Redfin, and Realtor.com in a single run
• Automatic Deduplication: Same property on 3 sites? You get 1 record with all data merged
• Cross-Platform Enrichment: Zestimate from Zillow + agent info from Redfin + photos from Realtor
• Price Variance Detection: Instantly see when the same property is priced differently across platforms
• Source Tracking: Know which platforms have each listing
• Best-of-Breed Data: Automatically pulls the best data from each source

---

Why Aggregation Matters

The Problem with Single-Platform Scraping

Platform	Unique Listings	Overlap with Others
Zillow	~35%	65% also on Redfin/Realtor
Redfin	~25%	75% also on Zillow/Realtor
Realtor.com	~20%	80% also on Zillow/Redfin

If you scrape all three separately, you'll have 2-3x duplicates!

The Aggregator Solution

1. Scrapes all platforms in parallel
2. Normalizes addresses to USPS standard format
3. Matches duplicates by normalized address
4. Merges data from all sources into one record
5. Flags price discrepancies between platforms

---

Perfect For

Real Estate Investors

• Get the most complete view of any market
• Catch underpriced listings missed by single-platform searches
• Track price discrepancies for arbitrage opportunities

Market Researchers

• Build comprehensive property databases
• Analyze listing coverage across platforms
• Track which properties are cross-listed

Real Estate Agents

• Complete competitive market analysis
• Never miss a listing on any platform
• Verify listing data across sources

Wholesalers

• Maximum lead coverage
• Find motivated sellers faster
• Identify stale listings across all platforms

---

Output Format

Each aggregated listing includes:

{
  "platform": "aggregated",
  "listingId": "AGG-ZL-12345678",
  "addressNormalized": "123 MAIN ST, SAN FRANCISCO, CA 94102",
  "price": 1350000,
  "zestimate": 1380000,
  "rentZestimate": 5200,
  "beds": 3,
  "baths": 2,
  "sqft": 1850,
  "sources": ["zillow.com", "redfin.com", "realtor.com"],
  "pricesByPlatform": {
    "zillow.com": 1350000,
    "redfin.com": 1349000,
    "realtor.com": 1355000
  },
  "priceVariance": "$6,000 (0.45%)",
  "allUrls": [
    "https://www.zillow.com/homedetails/...",
    "https://www.redfin.com/CA/...",
    "https://www.realtor.com/..."
  ],
  "bestPhotos": ["https://..."],
  "agent": {...},
  "features": [...],
  "priceHistory": [...],
  "taxHistory": [...],
  "scrapedAt": "2025-12-24T12:00:00Z"
}

Key Aggregation Fields

Field	Description
sources	Array of platforms that have this listing
pricesByPlatform	Price on each platform
priceVariance	Difference between highest and lowest price
allUrls	URLs on all platforms
bestPhotos	Deduplicated photos from all sources

---

Quick Start Examples

Example 1: Basic City Search (All Platforms)

{
  "city": "San Francisco, CA",
  "priceMax": 1500000,
  "bedsMin": 3
}

Example 2: Specific Platforms Only

{
  "city": "Miami, FL",
  "platforms": ["zillow", "redfin"],
  "priceMin": 500000,
  "priceMax": 1000000
}

Example 3: Keep Lowest Price (Arbitrage Strategy)

{
  "zipCode": "90210",
  "deduplicationStrategy": "keep_lowest_price",
  "maxResultsPerPlatform": 100
}

Example 4: Demo Mode (Free Testing)

{
  "demoMode": true
}

---

Input Parameters

Parameter	Type	Required	Default	Description
demoMode	boolean	No	false	Run with sample data (free testing)
platforms	array	No	all	Which platforms to search: zillow, redfin, realtor
city	string	No*	-	City to search (e.g., "San Francisco, CA")
zipCode	string	No*	-	ZIP code to search
address	string	No*	-	Address to search around
searchRadius	integer	No	5	Radius in miles
priceMin	integer	No	-	Minimum listing price
priceMax	integer	No	-	Maximum listing price
bedsMin	integer	No	-	Minimum bedrooms
bathsMin	integer	No	-	Minimum bathrooms
propertyTypes	array	No	all	Filter: house, condo, townhouse, multi_family, land
listingStatus	string	No	for_sale	Status: for_sale, pending, recently_sold, for_rent
maxResultsPerPlatform	integer	No	50	Max listings from each platform
deduplicationStrategy	string	No	keep_all_merged	How to handle duplicates

*At least one location parameter required

Deduplication Strategies

Strategy	Description
keep_all_merged	Merge data from all sources (default)
keep_lowest_price	Keep the listing with the lowest price
keep_highest_price	Keep the listing with the highest price
keep_zillow	Prefer Zillow data when available

---

How Deduplication Works

1. Address Normalization

All addresses are converted to USPS standard format:

• 123 Main Street, Apt 4 → 123 MAIN ST APT 4
• 456 Oak Avenue #2B → 456 OAK AVE #2B
• 789 N. First Blvd → 789 N FIRST BLVD

2. Matching

Properties with identical normalized addresses are grouped together.

3. Merging

Based on your strategy, data is merged:

• Price: From primary source or lowest/highest
• Zestimate: Always from Zillow (only they have it)
• Photos: Combined from all sources
• Features: Union of all features
• Agent: From most complete source

4. Variance Detection

Price differences across platforms are calculated and flagged.

---

Pricing

Event	Cost
Per aggregated listing	$0.10
Demo mode	Free

Why More Than Single-Platform Scrapers?

The aggregator runs 3 separate scrapers (Zillow, Redfin, Realtor) and then performs deduplication and enrichment. The $0.10 per unique property includes:

• Running 3 platform scrapers ($0.05 × 3 = $0.15 potential)
• Deduplication (often 40-60% overlap = savings)
• Cross-platform enrichment
• Price variance analysis

Typical savings: 30-50% vs running platforms separately!

---

Use Cases

Investment Property Pipeline

{
  "city": "Atlanta, GA",
  "propertyTypes": ["multi_family"],
  "priceMax": 500000,
  "maxResultsPerPlatform": 100,
  "deduplicationStrategy": "keep_lowest_price"
}

Find multi-family properties across all platforms, keeping the lowest listed price for each.

Luxury Home Search

{
  "city": "Beverly Hills, CA",
  "priceMin": 5000000,
  "bedsMin": 5,
  "platforms": ["zillow", "redfin"]
}

High-end properties with maximum data coverage.

Rental Market Analysis

{
  "zipCode": "78701",
  "listingStatus": "for_rent",
  "maxResultsPerPlatform": 200
}

Comprehensive rental inventory in downtown Austin.

---

Part of the Real Estate Scraper Suite

Actor	Description	Status
zillow-scraper	Scrape Zillow (Zestimate, tax history)	✅ Available
redfin-scraper	Scrape Redfin (agent data, accurate sqft)	✅ Available
realtor-scraper	Scrape Realtor.com (comprehensive photos)	✅ Available
real-estate-aggregator	Combine all 3 + deduplicate	✅ You're here!
mls-scraper	Direct MLS data (BYOK)	🔜 Coming Soon

---

FAQ

How long does it take?

Typically 3-5 minutes depending on result count. Each platform is scraped in parallel.

What if one platform fails?

The aggregator will continue with successful platforms. You'll see which platforms returned data in the output.

Can I run just 2 platforms?

Yes! Use the platforms array to specify which ones.

How accurate is the deduplication?

Very accurate. Address normalization handles 99%+ of cases. Edge cases (typos, new construction) may occasionally slip through.

Do I need API keys for each platform?

No! All platform scrapers use web scraping. No API keys required.

---

Integrations

Zapier/Make/n8n

Use the Apify integration to trigger this actor and route aggregated listings to:

• Google Sheets
• Airtable
• Your CRM
• Email notifications

Webhooks

{
  "webhooks": [{
    "eventTypes": ["ACTOR.RUN.SUCCEEDED"],
    "requestUrl": "https://your-app.com/webhook/listings"
  }]
}

---

Support

• LinkedIn: John Rippy
• Website: johnrippy.link

---

Built by John Rippy | johnrippy.link

---

Keywords

real estate aggregator, property search, zillow redfin realtor combined, multi-platform real estate search, property listing aggregation, real estate data deduplication, combined property search, cross-platform real estate, unified property search, real estate api, property data aggregation, home search all platforms, deduplicated listings, real estate data enrichment, investment property finder, multi-source real estate data