Pull zestimate from zillow with address and zip code

I am looking for a macro or vba code running in MS Excel or Access. The code needs to pull zestimate from zillow.com with address and zipcode. Basically I have two columns, address and zipcode. The code needs to pull zestimate and put it into a third column. I will pay you for this program. Thank you very much.

I tried your program and it got hung up at Set Progress = Wks.Shapes("Group 1").GroupItems(2)
Should there be a worksheet named "Shapes"? I just saw Main and Sheet2.

Originally Posted by Leith Ross

Hello kspeese,

You most likely ran the macro directly without using the button "Get Estimates". You can change the following line in the "GetEstimates" Sub...

Please Login or Register  to view this content.

I saved the file to my desktop and clicked the "Get Estimates" button. The debugger stopped here (see pic - even after doing that fix you had recommended). Sorry for the hassle, but that looked pretty cool and I have been trying to learn Excel... Just for the fun of it.

Capture.GIF

I tried it and it works great. That progress bar is really cool! I would think this should work for the original poster if she or he ever reports back.

Leith, thank you so much. It works like a charm.

I tried to run the code in you Zillow Estimates ver 4a and get a "Run-time error '-2147024809 (80070057)'; The item with the specified name wasn't found"

Also, would it be easier/faster to use the Zillow API? http://www.zillow.com/howto/api/GetSearchResults.htm. Just asking.

Leith,

Thank you for sharing this awesome program! This is so helpful!

I have an issue each time I click "Get Estimates" which says:

Compile error

Can't find project or library

Any idea why this may be happening?
(I'm running this on a mac, not sure if that matters..)

yosseld: I went ahead and created a new macro that uses the Zillow API that you can check out. I know I can run through a list of about 200 in a pretty short period of time.
http://www.excelforum.com/excel-prog...ml#post3556934

Leave some feedback on that thread with your thoughts on how it can be improved.

sdgenxr,

Thanks for sharing. I'm really still new to macros, and so I don't really know how to integrate them into a spreadsheet.

If it's not too much to ask, could you upload a usable spreadsheet for us dummies?
Thanks,

Copy the macro that you want to use, then open Excel and pres Alt+F11 to open the VBA Script Editor. Paste the code into the editor and edit the lines that define your data location and where you intend to return the Zillow information and close the script editor. Hopefully they are easy enough for you to figure out. Back in Excel, make a button to call the macro you just created and press it to run.

Please post any other questions about that particular macro in that thread as not to hijack this one. Hope it works well for your needs.

Thank you so much for this! I was trying to figure out how to do exactly this myself using the Zillow API, even though I have never used an API before and have limited experience with VBA and macros.

This will save me a lot of time!

Originally Posted by sdgenxr

I tried to run the code in you Zillow Estimates ver 4a and get a "Run-time error '-2147024809 (80070057)'; The item with the specified name wasn't found"

Also, would it be easier/faster to use the Zillow API? http://www.zillow.com/howto/api/GetSearchResults.htm. Just asking.

This is exactly what I have been looking for. This is great. I am getting the error mentioned above as well. Any assistance would be much appreciated.

This is wonderful. Thank you for the hard work that was put into this excel document. Is there anyway to add the rent zestimate? I attempted to duplicate the Zestimate code and replace it with what I thought would work, but I failed miserably.

I'm not 100% on this, but I think I found the <div class> that provides the zestimate on the zillow site, but I'm not sure how to add it to your code.


<div class="zest-value" id="yui_3_15_0_1_1405302051991_3673">$1,202/mo</div>


Thanks in advance.

Hey everyone. I'm really busy this week and I hope to carve out some time during the weekend to look into the error.

Leith, I just got a new computer with Windows 8.1 and installed Excel 2010. However, the program does not work on the new computer and just shows "not found" for any address. The same file still works perfect on my old computer. I can pay you to get this resolved. Thanks a lot.

Hi Leith-
Thanks so much for making the Zillow Estimates macro version 4a. I've used it successfully for awhile now, but lately have been getting back "Not found" in the Zestimate column for all the addresses I enter. Even running the addresses you had included in the spreadsheet all come back as Not Found. Is it possible that something changed on Zillow's end? Do you have any suggestions as to what I can do to fix it? I'd like to give it a try, since that will help me learn.

Thanks very much for any advice.

Leith,

This is great! I ran it with the addresses you already had and I got a ton of blank line (dash)returns. I only received information for 190 Addresses and those only returned the "Zestimate". Some of those 190 also returned the Rent Zestimate and Property Status.

I am using Excel 2013. Is it me?

What I am looking for is just a return of the Zestimate and Sq.Ft.

Any help would be outstanding.

Leith,

Thanks! for the super quick reply. I loaded it up and I changed the first address selected it and clicked get estimate and this is what I gotZillow Estimates ver 7.xlsm PIC.PNG

I then went ahead and Typed CTRL+R and got a "Not listed with Zillow" for all Addresses.

Any idea what I could be doing wrong?

You are Awesome! I look forward to the update!

Leigh,

Thanks so much for your hard work on this. I am using this within your Terms and Zillow's terms.

I tried to use it again and got a few "errors" (I still can't get it to pull data, It shows me a plus sign when I hover over the buttons and it will not let me click. When I use the ALT command it does not return Data, and there appears to be a part of a button under the Purple Zillow drop down cell. Zillow Ver 8.PNG

I hate to be such a bother with this. This is just so perfect for what I need.

If there is another way to take an existing address database and obtain the Zestmate and the Square footage of the home, that would work for me too.

Sorry auto correct spelled you name Leigh instead of Leith.

Leith,

Well since I am Sam Smith I rarely have anyone mis-spell my name. I have had people ask me to spell my last name, to which I reply J-O-N-E-S.

I don't think I have any other Workbooks that have ActiveX Control. I did download a Workbook that had ActiveX control adn after "lowering" my security settings in Excel it opened adn worked. I then reopened the Zillow Estimates ver 8 and got this

Debug Error.PNG

I had not, but did, and now I get "not listed with Zillow" or "No Data." Have My trust center settings for Macro Settings "Enable all Macros..." and for ActiveX "Enable all Controls..."

Ver 8.PNG

Leith,

Thanks, I switched to my laptop and it works now if I use ALT+. This is going to be great to have this info!

Leith,

This is an awesome workbook you created, but I cannot get it to work (my fault I'm sure of it). I can run everything but it always returns "no data". I did the ActiveX fix you mentioned and I changed my Macro security settings to "Enable all macros" and Selected "Trust access to the VBA project object model".

I do not work with macros very often so I'm sorry for my ignorance.


Thanks,
Matt

Hello Leith,

I would first say that you have an excellent program. I was wondering if you have updated the software for the Zillow website. Im looking forward to using the program.

Thanks,

I too would love an updated copy of this!! I can't wait to use it!

Leith,

You should take a look at the API Zillow offers. Once you get the hang of how it works, it's pretty easy. Plus, the xml format doesn't change that much!

There's a working example on this thread:
http://www.excelforum.com/excel-prog...xtraction.html

I've been making small tweaks to the code recently and post them on my website (shameless plug).

Today, I'm going to tackle this API call:
http://www.zillow.com/howto/api/GetD...rchResults.htm

Originally Posted by Leith Ross

Hello SCSMITH6547,


I have created a new version of the program At first glance, it appeared the changes were minor. So much for wishful thinking. A new column had to be added for asking price information. which now included with homes, apartments, condos, and lots for sale. There were several other changes to the data that required a major change to the existing program's code.

It has been tested and checked for accuracy. I believe the data to be both accurate and correct. If you find any discrepancies, let me know what they are. Another change is a legal notice I have included. This is for everyone's protection. So please read it.

Is there an updated version of this excel spreadsheet? I tried to use it and the results come back "No Data" for every property. I would really love to use this tool as it would be enormously helpful.

Originally Posted by Leith Ross

Hello tiderider03,

Happy New Year!

I wrote this program a short while ago. It may be more than you need but will pull addresses from column "D" and return several columns of information including the Zestimate, number of beds, baths, and square footage. Have a look and let me know what you think.

How do I input my data for where I live?

Hello Leith,

As hard as I've tried to make the necessary adjustments to the Zillow code, I seem to keep coming up short. If you're able to either edit and correct the code, or even just point me in the right direction in terms of troubleshooting it myself, would be greatly appreciated. Our company has benefited greatly from the results whenever it was functioning properly, and would like to continue utilizing it in our process.

Best Regards,
Mike

Hi Mike,

Take a look at post #46 above and try that code out and report back.

Hello Leith,

This is fantastic. I downloaded it and tried to use it however when I hit "Get Estimates" I get a "Not Found" for every single property and no information populates. I really need this to work. I have several properties I need to get this exact information for (from Truilia too) and I need to get it as soon as humanely possible. Can you help me get this working? Not sure what is wrong. Thank you!

Pam

Yeah, I'd be interested in updated code, too. This is a great concept. Too bad the last posted sheet no longer works.

Hi Leith Ross,
I came across this thread:
https://www.excelforum.com/excel-pro...-zip-code.html

I wonder if you have the latest version?
I tried version 4a and version 5, both has trouble reading data from the site, all returns "ERROR: 0 - "

I tried version 7 and version 8, I ran into the following error:

Run-time error '57121':

Application-defined or object-defined error

when I ignored that msg and carry on, I ran into another error:

Can't exit design mode because Control 'Frame1' can not be created

Please help!

I’m getting an error on the ‘.Send’ part of the code saying ‘Access denied’. I think it is because of a corporate blockage on my work system. Any suggestions how to get around that?

Thanks

Same issue getting the following error version 8 running windows10 excel 365. ERROR: # 80070005 - Access is denied.

Moderator please update thread subject. This is definitely not [SOLVED}.

Originally Posted by Leith Ross

Hello Matt,

No it isn't your fault. Zillow for the past month has been expanding their listings and the information provided on the web has changed. This has drastically altered the HTML code for the web pages. The program can no longer pull the information due to the code changes. I will need to revamp the workbook once Zillow has solidified the new format. Keep checking back or send me a private message for the current status.

Hi Leith
Any updates on this? looks like it was an awesome tool before 2015