← Blog

Zillow Listing Data Fields, Explained

A reference to the data a Zillow listing contains, what each field actually means, and the common mistakes people make when they put these values into a spreadsheet.

A Zillow listing contains far more data than the price and the number of bedrooms. Some of it is clearly labeled on the page. Some of it is hidden in collapsed sections. And some fields have names that suggest one thing but mean another. This article is a reference: it groups the fields, explains what each group means, and points out where people commonly misread the values.

The field names below are the ones Listing2Sheets uses. Other tools may name them slightly differently, but the underlying data is the same.

Core fields

These identify the listing and its current state.

  • Link. The listing's Zillow URL. It is worth always exporting this, because it lets you return to the source later.
  • Price. The current asking price for a listing for sale, or the rent for a rental.
  • Home Status. The listing's status in Zillow's own terms, such as FOR_SALE, PENDING or SOLD. These values come in capital letters with underscores, because they are system codes rather than display text.
  • Home Type. The property type, such as SINGLE_FAMILY, CONDO or TOWNHOUSE. Same format as Home Status.
  • Days on Zillow and Time on Zillow. How long the listing has been on Zillow. Days on Zillow is a number; Time on Zillow is the same information as display text, such as "322 days".
  • Date Listed, Price Change, Price Change Date. When the listing appeared, the amount of the most recent price change (a negative number means a reduction), and when that change happened.

A common mistake: Days on Zillow is not the same as days on market. If a property was listed, removed, and listed again, Zillow's count may restart. Treat it as an indication, not an exact history. The price history, described below, gives the fuller picture.

Address fields

Street Address, City, State, Zipcode, County, Subdivision, Latitude, Longitude.

Two practical notes:

  • Export the address as separate fields, not only as one combined line. Separate fields let you sort and filter by city or ZIP code.
  • Latitude and longitude let you place properties on a map later, for example with Google My Maps, which can import a sheet.

Property details

Bedrooms, Bathrooms (with a breakdown into full, three-quarter, half and quarter baths), Living Area, Lot Size, Lot Area (acres), Year Built, Stories, Property Sub Type.

A note on bathrooms: in US listings, a full bathroom has a toilet, sink, and a bathtub or shower. A half bathroom has only a toilet and sink. A total like "2.5" means two full and one half. If you compare properties, the breakdown is more precise than the total.

A note on area: Living Area is the finished interior space, in square feet. Lot Size is the land. The two are easy to swap by accident in a spreadsheet, so label the columns clearly.

Valuation and cost

This group needs the most care, because several values look similar but come from entirely different sources.

  • Zestimate. Zillow's own estimate of the property's market value, produced by a statistical model. It is not an appraisal and not an offer. It is useful for comparison, but it can differ substantially from the eventual sale price.
  • Rent Zestimate. Zillow's estimate of monthly rent for the property. Same caveat.
  • Tax Assessed Value. The value the local government assigns to the property for property tax purposes. It is set by a different process, on a different schedule, and often differs from market value, sometimes by a large margin. It is not a second opinion on price.
  • Property Tax Rate. The tax rate for the area, as a percentage.
  • HOA Fee. The recurring fee paid to a homeowners' association, where one exists. Check the period; it is usually monthly.
  • Price Per Sqft. Price divided by living area.
  • Est. Monthly Cost. Zillow's estimate of the monthly cost of owning the home, which depends on Zillow's own assumptions about the loan and other costs.

The central point: Price, Zestimate and Tax Assessed Value are three different things from three different sources. Keep them in separate, clearly named columns.

Listing information

MLS ID, MLS Name, Listing Agent, Agent Phone, Broker Name, Broker Phone, Listing Type, Listing Status, Photo Count, Page Views, Saves, Zillow ID.

  • MLS ID identifies the listing in the multiple listing service it came from. It is useful when you speak to an agent, because it refers to the listing unambiguously.
  • Zillow ID is Zillow's own identifier for the property. It is the most reliable value for spotting the same property twice in your sheet, because addresses can be written in different ways.
  • Page Views and Saves show how much attention the listing has received on Zillow. They are a rough signal of interest, nothing more.

Sale history, price history and tax history

  • Date Sold and Last Sold Price describe the most recent sale.
  • Price history lists recent events, such as "Listed for sale", "Price change" and "Sold", each with a date, price and source. Listing2Sheets captures the five most recent entries as separate fields (Price History 1 Date, Price History 1 Event, and so on).
  • Tax history lists recent years with the tax paid and the assessed value. Listing2Sheets captures the five most recent years.

Price history is where you see a listing's real trajectory: how many times the price was reduced, and whether the property was taken off the market and relisted.

Schools

For each nearby school that Zillow shows, the fields include the school's name, rating, grade levels, distance, type (public or private) and level (elementary, middle, high). These are numbered: School 1 Name, School 1 Rating, and so on.

Keep in mind that a nearby school is not necessarily the assigned school for that address. Zillow's own page notes this, and it is worth verifying with the school district.

Property features

This group describes the building and the land in words rather than numbers: heating, cooling, appliances, flooring, roof, foundation, construction materials, basement, fireplace, laundry, windows, security, sewer, water source, electric, community features, lot features, view, fencing, pool, spa, patio and porch, plus a group for parking and garage.

These values are text, often lists such as "Dishwasher, Refrigerator, Microwave". They are useful for filtering ("which of these have a garage?") but not for calculation.

Description

Description is the listing's written text. Home Insights are short highlights Zillow extracts, such as "Open kitchen" or "Large primary suite". The description can be long; if you export it, give it a wide column and turn on text wrapping.

Search results pages contain less data

Everything above describes a listing page, the page for a single property. A search results page contains a smaller summary of each property: price, address, beds, baths, living area, lot area, Zestimate, Rent Zestimate, tax assessed value, days on Zillow, broker name, and a few flags such as whether an open house is scheduled.

It does not include the deeper fields, such as the listing agent's phone number, year built, HOA fee, price history, tax history or schools. If you need those, export from the individual listing page. A common workflow is to export a search page first to build a shortlist, then export the full listing for the properties that interest you.

Summary

A Zillow listing holds several dozen fields, grouped into identity, address, physical details, valuation, listing information, history, schools and features. The fields most often misread are the three value figures: the asking price, the Zestimate and the tax assessed value come from different sources and answer different questions. Zillow ID is the most reliable way to recognize duplicates. And search results pages carry only a summary, so detailed fields require the listing page.

Listing2Sheets lets you choose which of these fields to send to Google Sheets and which column each one goes into.