Zillow Distressed Property Finder by City or ZIP
Zillow Distressed Property Finder by City or ZIP produces property, agent and landlord lists: listings with the agents, brokers and managers behind them. Columns include zpid, link, distress type, home status, full address, city. Contact and quality columns: phone numbers, websites.
Useful for property teams who prospect agents, landlords or property managers.
The columns you get
| Column | What it holds |
|---|---|
| Zpid zpid | Zillow property ID |
| Link url | Zillow property detail page URL |
| Distress type distressType | Distress classification: foreclosure, bankOwned, preForeclosure, preMarketForeclosure, auction, comingSoon |
| Home status homeStatus | Raw Zillow homeStatus value |
| Full address address | Street address |
| City city | City |
| State or region state | State abbreviation |
| Zip code zipCode | ZIP code |
| Price price | Listing price ($) |
| Zestimate zestimate | Zillow estimate ($) |
| Rent zestimate rentZestimate | Zillow rent estimate ($/month) |
| Tax assessed value taxAssessedValue | Tax-assessed value ($) |
| Beds beds | Bedrooms |
| Baths baths | Bathrooms |
| Sqft sqft | Living area (sq ft) |
| Lot area value lotAreaValue | Lot area size |
| Lot area unit lotAreaUnit | Lot area unit: sqft or acres |
| Property type propertyType | Property type (e.g. SINGLE_FAMILY) |
| Year built yearBuilt | Year the property was built |
| Latitude latitude | Latitude |
| Longitude longitude | Longitude |
| Days on zillow daysOnZillow | Days on Zillow |
| Status text statusText | Zillow status label (e.g. Foreclosure, Pre-foreclosure, Auction) |
| Is foreclosure isForeclosure | Flagged as an active foreclosure-listed property |
| Is bank owned isBankOwned | Flagged as bank-owned (REO) |
| Is pre foreclosure isPreForeclosure | Flagged as pre-foreclosure |
| Is auction isAuction | Flagged as a foreclosure auction |
| Is coming soon isComingSoon | Flagged as coming soon |
| Listing agent name listingAgentName | Listing agent name |
| Listing agent phone listingAgentPhone | Listing agent phone number |
| Broker name brokerName | Listing brokerage |
| Mls name mlsName | MLS name |
| Mls id mlsId | MLS listing ID |
| Photos photos | Property photo URLs (Zillow photo CDN only) |
| Photo count photoCount | Number of photos available |
| Description description | Listing description |
| Listed date listedDate | Date the listing was posted (ISO 8601) |
| Monthly hoa fee monthlyHoaFee | Monthly HOA fee ($) |
| Price per square foot pricePerSquareFoot | Price per square foot ($) |
| Posting link postingUrl | External listing/auction page when Zillow provides one (e.g. auction.com) |
What it costs
- 100 rows in one run$0.50
- 1,000 rows in one run$1.39
- 10,000 rows in one run$10.30
Free-plan prices: $0.99 per 1,000 results plus a $0.40 start fee (4 GB run) per run, plus Apify platform usage at $0.20 per compute unit. The Free plan includes $5 a month (Apify pricing).
What you fill in
- Locations
US locations to search, one per line: a city ("Austin, TX"), ZIP code ("78701"), neighborhood ("Hyde Park, Austin, TX") or county ("Travis County, TX"). - Start urls
Zillow search pages to scrape instead of (or in addition to) locations. The distress filter is layered on top of whatever the URL already filters. - Distress types
Which distressed listing categories to return. Leave empty for all four. - Price min
Lower bound on the listing price. Leave blank for no minimum. - Price max
Upper bound on the listing price. Leave blank for no maximum. - Beds min
Only include properties with at least this many bedrooms. Leave blank for no minimum. - Baths min
Only include properties with at least this many bathrooms (decimals allowed, e.g. 1.5). Leave blank for no minimum. - Home types
Limit results to specific property types. Leave empty for all types. - Days on zillow
Only include listings that have been on Zillow within this window. - Sort by
Order in which Zillow returns the listings.
Other property, agent and landlord lists
- 99acres City & BHK Property Listing Scraper
- Apartments.com Rental Listing & Floor Plan Scraper
- Brazil Rental & Sale Listings by City (QuintoAndar)
- Century 21 Listings & Property Detail Finder
- Craigslist Classifieds Scraper with Category Attributes
- Crexi Commercial Property Listings & Pricing Extractor
- Fotocasa Spain Sale & Rental Listings Scraper
- Idealista Search Listings Price & Feature Scraper
- Immowelt Germany Rent & Buy Listings Scraper
- Indian Property Listings Finder by City & BHK
- Property Finder MENA Listings & Agent Contact Extractor
- Propwire Distressed & High-Equity Property Lead Finder
Questions
What does Zillow Distressed Property Finder by City or ZIP cost?
$0.99 per 1,000 results on the Apify Store (Free plan), plus a start fee per GB of run memory and Apify platform usage: one run of 1,000 rows costs about $1.39 before platform usage. The Free plan includes $5 a month.
Do I need to code to use it?
No. You fill in a form on the Apify Store page, start the run and download the results as CSV, Excel or JSON. You need a free Apify account.
Is it a good fit for a business list?
Useful for property teams who prospect agents, landlords or property managers.