Property Data Entry Guidelines

September 24, 2013 at 9:16 pm  •  Posted in busad265 by  •  7 Comments

You can also use Zillow or Trulia (or others) to identify and enter a set of addresses. These sites will not have all the variables in the template but it might be easier to identify your set of address locations on one of these sites and then find the additional details from the County website later.  Here are some links:

NEW: I recorded a screen capture video that might help you use Zillow as a short-cut to the county property database. Click here to see the video. 

Is this helpful? Let me know in the comments section.

Excel template for data entry

When entering the data variables for your 30 selected properties, please note the following:

1. Only include Single Family residential homes. Do NOT include mobile homes, duplexes, multi-family residential (4-plex, apartment building, etc), commercial properties (retail, office, medical, industrial, etc.), non-profit buildings (e.g., schools, churches) or publicly owned property (e.g., government buildings, parks).  If in doubt, use Google Maps Street View (or similar) to try to determine whether the property appears to be a single family home.

2. If you can not determine one of the variables then enter 0 (if the variable is numeric, like square footage or number of rooms) or enter NA (if the variable is text, like Style or Construction).

3. Try to spread out your selection of properties so that they’re not too clustered in one location within the neighborhood. For some neighborhoods this may not be possible. Just do the best you can.

4. Try to select properties with different values. In most neighborhoods there will be expensive properties and inexpensive properties. Get some of each.  This will help you later when you want your model to have the flexibility to determine approximate home values for various home types.

5. Be sure to save a copy of your 30 property data records! Even if you have uploaded the data to the Google Drive spreadsheet please save your 30 properties locally or in your own cloud folder location as a back up. We don’t want to repeat work if Google Drive doesn’t work well for so many shared users. Click here for an Excel template.


  1. Kendrick Gardner / September 24, 2013 at 11:43 pm / Reply

    when Im typing in street addresses into that property site.. it takes forever to load anything!! I think the properties in the university are hard to show cause some of them are still recently new built properties

    • justinholman / September 25, 2013 at 12:12 am / Reply

      Hi Kendrick, I think we may be overwhelming the servers. As a backup, you can use If you zoom all the way in you should be able to see individual properties and click to show details. Unfortunately, Zillow won’t include all the info that the County website displays. But, that will allow you to get the set of addresses entered along with bedrooms, bathrooms, sq ft, lot size and year built.

  2. justinholman / September 25, 2013 at 12:44 am / Reply

    Hey, found a shortcut. Go to Zoom in and click on a specific address. Click to show property details. Scroll down and look for a link called “County website”. It should take you directly to the relevant page. Let me know if this is helpful.

  3. Anders / September 25, 2013 at 9:30 pm / Reply

    Where is the download for the Excel Spreadsheet that had all the titles of the info that we had to collect?

  4. Pingback: Exercise #10 | Inferential Statistics and Problem Solving

Leave a Reply