Quick and dirty guide to running comps on Zillow

By | September 24, 2016

Map of the United States with a magnifying glassComps are properties close to a potential flip that are similar to the flip using a specific set of criteria. Due to distance, it can be difficult for the remote investor to evaluate comparables. A savvy technical toolbox can help to level the playing field when evaluating “the lay of the land.” Additionally, solid data will guide in making good decisions about whether to pass on a flip or go for it.

Today we’re going to walk you through running comps, using an investor’s special as an example, in the Zillow.com website. First, however, let’s talk about whether Zillow should be in your toolbox.

Is Zillow Good for Running Comps?

This is a hot topic among many investors and sellers who would like to know the potential value of their property. The general consensus among experienced investors is that Zillow is good for, as our title states, quick and dirty comp runs, but it’s usefulness usually ends there. We also do not believe that Zillow’s proprietary Zestimate that many new investors rely on is ever a good indicator of ARV (after repair value). That said, we do find that Zillow does supply a lot of value in the quantity of information that it provides. It provides much helpful information, like these among many others:

  • direct links to the appropriate county assessor’s office with the APN (assessors property number)
  • neighborhood market temp bar
  • official property description

To summarize, Zillow gives a very good birds-eye view of the property statistics that you can build on with other, more reliable sources. That said, let’s go through finding comps on Zillow from beginning to end.

Zillow Basics

This property that we want to find at least three comps for is located at 7019 Dwight Way, San Bernardino CA 92404. The first thing you notice is that Zillow brings up the subject property information. Note that it’s a 2 bed, 1 bath, with 1563 square feet. We’re just going to close that popup for right now.

 

Picture of Zillow property information

 

Zooming

Keeping an eye on the green dot that indicates the property, we’re going to zoom into that area a few times to get a closer look. Do this by clicking on the plus sign icon.

 

Pictur of Zillow website zoom icon

 

Lasso Tool

To make viewing easier, we’re going to draw a box around the subject area using the lasso tool. With the lasso tool you want to draw a rough shape around the area going a little outside of the street margins to capture all the properties and then click ‘Apply’.

 

Picture of Zillow area outline after using lasso tool

 

Active and Potential Listings

The listings that Zillow first shows when you search for a property are ones that are active For Sale, indicated by red dots, and Potential, foreclosures or auctions, indicated by blue dots.

 

Picture of active listings in Zillow website

 

Recently Sold Listings

While you can keep in mind what active listings are priced, they are by no means indicative of what the subject will sell for after rehab. For ARV we always rely on properties that have already sold, and the more recently they sold, the better. We start our search with exact criteria and then widen it if we don’t find many sold properties that are similar to the subject.

So now we’re going to set the criteria to sale data by going to the light blue bar at the top where it says ‘Listing Type’:

  1. clicking on Listing Type to expose the drop-down menu
  2. unchecking ‘For Sale’ and ‘Potential Listings’
  3. clicking on the box for ‘Recently Sold.’

 

Zillow website Listing Type dropdown in bar

 

The 100 sold properties that appear now are your comps, but we still haven’t set a time frame of the sold-within dates. Three months is ideal when you start your search. If you don’t find any or few, then you broaden that search to six or even twelve months. All of this depends on how cold the market is.

To set this for three months we are going to:

  1. go to the ‘More’ tab in the top bar
  2. set the ‘Sold in last’ criteria to ’90 days’
  3. click ‘Apply’.

 

Zillow website property comps after selecting sold from downdown menu.

 

This brings up three results with only one having dimensions similar to our subject property, a 2 bed and 1 bath with 1032 square feet. You can view these stats when you hover over the property dot with your mouse.

 

Hovering over a property icon in zillow website to view information

 

We’ll repeat the process to broaden the search to six months by selecting ‘6 Months’ from the ‘More’ drop-down menu.

Now we get 10 more properties in addition to the three we just found.

 

Zillow website after selecting sold within six months as criteria from the dropdown

 

What is a Good Comp?

A quick hover over each of these property icons shows us that some don’t fit the top five criteria that qualifies a good comp. We write a detailed post about that criteria here but a quick overview is that a good comp will be:

  1. within the same neighborhood as the subject
  2. have sold within 3 to 6 months
  3. have similar features such as the number of beds, baths or inclusion of pools and garages
  4. have approximately the same square footage
  5. be of similar construction on the exterior.

In this case, we have studios with no beds and baths indicated, apartments in complexes, or one side of a duplex, as well as a half acre lot, and those we ignore. We also ignore properties that clearly were sold as tear-downs, as-is, rehabs, or in need of TLC as in the case of the 55k property on Tippecanoe.

Gather the Data

Once we’ve looked briefly at all the sold properties and weighed them for inclusion, what we like to do is just quickly type basic data on the ones that made the cut into a spreadsheet. For these three properties it looks something like this:

 

Subject property and Comps data in a spreadsheet

 

What becomes clear right away is that our comps have considerably less square footage than our subject property. The comp with the largest square footage at 1073 sold for 199k, however it does have an extra bedroom.

For this comps selection overview we haven’t looked at the features beyond the beds, baths and square footage.

Focus on Factors Within Your Control

Finding good comps is part experience, part research, and part knowing your market. Since knowing the market is a challenge when flipping remotely, try to focus on what is within your control. Continue to build on your experiences, and expand your toolkit by learning different techniques to find the information you need that will help you make a good decision on whether to flip or pass.

Interested in the next step? In this post we run comps on an actual potential deal with details, and work out the ARV to see if the numbers work.

If you liked this post and would like to receive posts on how to improve your fix and flip business as soon as they roll out, please subscribe to the Remote Fix and Flip blog.

I want fresh fix and flip news!

 

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Leave a Reply

Your email address will not be published. Required fields are marked *