Profile picture for p100

Can I use Zillow to give me data exportable to a spreadsheet?

  • October 23 2011 - Naperville
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.

Be a Good Neighbor. Be respectful and on-topic. No spam or self-promotion! See our Good Neighbor Policy.

 
 

Answers (7)

Profile picture for blue screen exile
Bottom tier:


I don't know how that would be interpreted as "no movement".
  • October 25 2011
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.

Profile picture for blue screen exile
Zillow's terms of use do not allow copying 300 property records.  The list format on the search used to make that fairly simple, but they removed that.  So now the search results is up to 20 pages of 23 entries (up to 460 results), and it can be copied to Excel, but it takes quite a bit of manipulation to put the data back into columns.

The reason that Zillow does not allow bulk copying of the data is due to agreements they have with data provider companies as those companies also provide similar data for a fee to other clients, and if the clients could just get it for free here, the data provider companies are not being paid for their work.

If was an occasional 300 here or there with no commercial application of any kind, but just for a statistical study, probably no one would notice and likely no data provider company would sue.

The trend charts are not just averages... for the Zindexes, they are medians.  Even the upper and lower tier trends are medians, but of the upper and lower 1/3 valued homes; meaning essentially Hextile data.  (Quartile data is not available on this site even though readily available form the U.S. Census web site).

All local trend data including list price, sold price, # sold, %price reduced, etc. can be downloaded as Excel files.  Just use the "local info" tab at the top of the page.

For Zestimate trend data, and tax data... the website address is of the form:
http://www.zillow.com/ajax/homedetail/HomeValueChartData.htm?mt=1zpid=#&format=json

where the # is replace with the Zillow property identification number as found on the home details page as well as the URL address for that home details page.  It used to be in column format with text dates, but now it is in data-pair list format, with the dates as double integers representing the date & time in UNIX format (seconds since midnight 12/31/1969).  You also need to compensate several hours for the specific time zone.

For the other chart data for the home details pages; the MT parameter is replaced as follows:

mt=2  % change
mt=3  listing price
mt=4  tax assessed value
mt=5 property tax
mt=6 page views (per day, one month)
mt=9 rent-zestimate
  • October 25 2011
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.

Profile picture for AndyLinss

That would be fairly easy to do. 

  • October 25 2011
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.

Profile picture for p100
My needs are more micro.  i'd like to compile a spreadsheet of pertinent data on all the condos/townhomes in my area listed for sale, for rent, or recently rented and recently sold -  about 300 properties according to zillow. 
  • October 25 2011
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.

Profile picture for AndyLinss
I'm not sure why you might not be interested in market trends, provided the basis of the data is known and accounted for.  It would be of little value to try and look generically at the global market, even for a given area, but if you account for location, size, quality and price, you can definitely determine trends. I do agree that right now in my area, we don't see any definite movement, but that doesn't mean it isn't worth watching, especially when looking for a particular investment property that might stand out in the analysis.
  • October 25 2011
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.

I have looked for it here but can only find top line trends based on simple averages,not unlike what you get from most realtors.  As an agent, I have access to more public record data that can be exported and analyzed but I think it is harder for non agents.  Ignore analysis that refers to the "market trends",  price per square foot or other univariate findings. Completely spurious.
  • October 25 2011
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.

Profile picture for AndyLinss
A good Realtor :)  can export listings for you and even do spreadsheet analysis of trends and potential deals.  Feel free to contact me for information.
  • October 23 2011
  • 0Yes

  • Report a Problem

    Please enter a valid email address.

    Content flagged

    We will review this content. Thanks for helping make the site more useful to everyone. To learn more, read Zillow's Good Neighbor Policy.

    We're sorry. This service is temporarily unavailable. Please come back later and try again.