Ottawa, ON · Member since 2012 · 6 posts · 2 votes
First post!
I really hope I haven't missed a discussion on this, I've tried doing a search on it here, and it mostly leads to discussions about how inaccurate Zillow is. :) Be that as it may, I am interested in using Zillow Zestimates, "Last Sold" values, and the most recent property tax assessment values, in a property analysis spreadsheet I am trying to put together.
Input: Homepath bulk .csv file
Output: Same file with the above Zillow information added.
I have come across a site that does this automatically, but the rates seem steep for what you get out of it. zim.ca. "Zestimates In Minutes".
I see a number of similar projects have been posted on freelancer.com, so I may just contact someone there to whip something up for me.
Looking forward to taking part in the BP community.
Liberty, MO · Member since 2016 · 6 posts · 6 votes
10y
Hey everyone! I've developed using the Zillow API (I have even had a call with the CEO!). If this is a tool I could use for myself then I don't mind putting in the development time and sharing it with everyone. That's a win win for everyone: Everyone gets a free tool and I get to make some friends in the process. Please let me know if this is an option you all would consider
Barnesville, GA · Member since 2014 · 2 posts · 0 votes
9y
Is there still any interest in this? I think it would be very useful to programmatically sort through listings based on whether they hit financial targets like CoC or cap rate. If there aren't any tools already available, I was thinking about making one.
The URL above is the value of cell A1 in Excel. I enter into cell B1:
=webservice(A1)
which should invoke the URL which returns XML and put the return value into B1. Instead, I get a "#VALUE!" error and haven't found any clues as to what I am doing wrong in this very basic example. Any ideas?
Williamsburg, VA · Member since 2017 · 8 posts · 3 votes
8y
Interesting thread here, any traction on any of this yet?
I built a tool that I use personally for doing quick location analysis/property estimations which I'd be happy to share, though it's pretty catered to my own needs right now!
Rental Property Investor · Malvern, PA · Member since 2016 · 1k+ posts · 934 votes
8y
I was able to get the APIs working from home, but not at the office. They don't work if there is a proxy server involved if you are calling from Excel.
Ultimately, I gave up. Two of the critical pieces of data I wanted were current price and listing status. They seem to be unavailable due to legal restriction according to the message I was getting back. I was able to get the basic property data. I don't know if they have a fee on the API for current price and listing status - I didn't look.
I gave up for a 2nd reason: some of the data was coming back wrong. I would look at a Zillow page and it would show the house was built in 1920. The API data came back as 1950. I noticed a few other differences and guessed the API is very buggy or has a different data source than the Zillow pages. That shook my confidence - no point in using the service if I have to manually verify and edit the data.
Williamsburg, VA · Member since 2017 · 8 posts · 3 votes
8y
Thanks for the follow-up.
Wow, well at least you were able to catch it. And I would imagine you would need MLS to get at a reliable listing status/price? Surprised the housing details were off, though; that's unfortunate.
Barnesville, GA · Member since 2014 · 2 posts · 0 votes
8y
If anyone is still interested, there's a chrome extension called RE-Helper that pulls data from a listing and runs it through a calculator. Just works on zillow now.
Rental Property Investor · Malvern, PA · Member since 2016 · 1k+ posts · 934 votes
8y
@Scott Purser It looks like the link is not working.
The webpage at https://chrome.google.com/webstore/detail/re-helper/bbdlndhhhkfafaeofaecinfhcpafbnpe?hl=en might be temporarily down or it may have moved permanently to a new web address.
Made this after researching/purchasing rental properties in Nashville.
It’s basically a tool that works with the Zillow api for price/rent and analyzes a property based on (1) location-specific metrics (appreciation rate, tax rate, insurance) and (2) customary expenses (vacancy, prop mgmt, r&m, capex). Also, all the drivers are adjustable within a downloadable google sheet.
Can also download to excel if you want to tinker with it offline.
Let me know what you guys think; would love any feedback from this group!
Orlando, FL · Member since 2016 · 48 posts · 13 votes
8y
I am a big fan of excel, and use extensive macros and add-ons. You may just want to hire a coder to write a macro in VBA. I have never used Zillow, but it seems like a pretty solid tool.
My name is Edidson, I am new to BiggerPockets. I recently saw an old post by you (a copy of your post at the bottom).
That post catches my attention because I have been looking for a similar tool for my researches.
Question: have you find something like what you asked in your post?
Thanks
“First post!
I really hope I haven't missed a discussion on this, I've tried doing a search on it here, and it mostly leads to discussions about how inaccurate Zillow is. :) Be that as it may, I am interested in using Zillow Zestimates, "Last Sold" values, and the most recent property tax assessment values, in a property analysis spreadsheet I am trying to put together.
Input: Homepath bulk .csv file Output: Same file with the above Zillow information added.
I have come across a site that does this automatically, but the rates seem steep for what you get out of it. zim.ca. "Zestimates In Minutes".
I see a number of similar projects have been posted on freelancer.com, so I may just contact someone there to whip something up for me.
Looking forward to taking part in the BP community.”
New to Real Estate · Anderson, SC · Member since 2018 · 9 posts · 2 votes
7y
I hate to bust you guys bubble but I just finishing a python program that pulls data from the zillow api...I was getting on here to find out if there are better options because it's not really all that great of info. The differences in numbers between zillow and other sites are scary...