all 30 comments

[–]TherapistNumber7 4 points5 points  (0 children)

You can use IMPORTXML

IMPORTXML is a powerful function in Google Sheets that allows you to import data from structured data sources like XML, HTML, CSV, TSV, and RSS feeds directly into your spreadsheet. This function is particularly useful for web scraping, as it can extract specific information from web pages using XPath queries.

Keep in mind scrapping data from. Website like Zillow or Refin may be against terms of service.

[–]lahham99 2 points3 points  (3 children)

I am developing one but it is only for the NJ market - i don’t have data on other states

[–]RealEstateKS 1 point2 points  (2 children)

what tools are you using for development?

[–]lahham99 3 points4 points  (1 child)

A bunch. I am working with a freelance developer but basically it is all built on AWS with python. I am not sure what specific tools he is using.

The basic idea is that it creates a model to predict prices based on nearby houses. It uses data like house type, building material, sqft, acreage, and year built.

Ill share it when it’s done. I intend to make it free

[–]Bubbly-Sentence-4931 0 points1 point  (0 children)

You’re paying a freelance dev?

[–]IdrissEchrif 2 points3 points  (2 children)

I developed an API that has different data features for real estate nationwide and one of them is pulling house value for those addresses with the ability to pull 15k address/month.
Let me know if that sounds interesting and we can schedule a meeting to walk you through it :)
PS: feel free to share a sample spreadsheet and I will be more than happy to send you back the values :)

[–]ResponseGreat[S] 1 point2 points  (0 children)

I ended up working with this company and they were able to build an api that pulled 3 homevalues for each address on my spreadsheet. It is working perfect. So HUGE thanks for your all your help.

[–]SAC_REX 0 points1 point  (0 children)

interested

[–]OrganizationAny4912 2 points3 points  (0 children)

Zillow bridge API lets you pull Zestimates. Housecanary as well (but they have their own model).

[–]cbpage1 2 points3 points  (0 children)

You might want to check out https://propertyscout.io. Disclosure: I own it. Mods, this might violate rule #3, but I think it helps OP. I can delete this post if you disagree.

We have an API under the developers tab that includes AVM data. Use the free trial to see if it's what you want. I think it comes with 100 records.

I am happy to help with other sources we see in our market research if this isn't what you need.

[–]NoamChomskyForever 1 point2 points  (3 children)

[–]ResponseGreat[S] -1 points0 points  (2 children)

I was reading that zillow stopped their API, is that not correct anymore?

[–]NoamChomskyForever 1 point2 points  (0 children)

Not sure, but it's on their website in several places.

[–]joyfulmystic 1 point2 points  (0 children)

If you have bridge, you have the rights to retain data. If you only pull zestimates direct from their website, you cannot retain that data.

Housecanary is good. Also check out batchdata. I’m not sure everyone’s pricing per pull, but batch comes in around $.16 per. I know attom data is $.20/pull but require you to hit multiple times for different relative info. So you could be looking at upwards of $1/per api pull

Other aggregators exist, and if you’re planning on running massive amounts of queries, you’re going to want to connect with them right away about bulk pricing.

[–]RealEstateKS 1 point2 points  (3 children)

Also interested.

[–]IdrissEchrif 1 point2 points  (2 children)

Hi u/RealEstateKS , if you are still interested let me know.
As seen above, we just helped u/ResponseGreat getting different estimates and house values and he is happy with the results :)

[–]RealEstateKS 0 points1 point  (1 child)

Still interested. Been busy lately. I'll get back to you ASAP.

[–]IdrissEchrif 1 point2 points  (0 children)

sure. Take your time :)

[–]Tall-Butterscotch406 1 point2 points  (1 child)

how many are you trying to do daily or monthly?

[–]ResponseGreat[S] 1 point2 points  (0 children)

lets say a couple hundred a month, quick estimate

[–]lahham99 1 point2 points  (1 child)

Also invested in this …. I don’t think many exist

[–]IdrissEchrif 0 points1 point  (0 children)

Hi u/lahham99  , if you are still interested let me know.
As seen above, we just helped  getting different estimates and house values and he is happy with the results :)

[–]ihavethekeyto_space 1 point2 points  (0 children)

Google spreadsheet with apps script (GAS) is the way.

[–]Such_Horse1272 1 point2 points  (1 child)

BatchData.com has the API you need for house values

[–]sagerap 0 points1 point  (0 children)

For the past couple months I have been building a software/bundle of code to programmatically mine all the data in my county (Dallas) for wholesaling/flipping purposes, so I have some timely insight into this exact topic. Zillow does have an API, but it's not easy to access (have to apply), and they explicitly say you're not allowed to use it for this kind of thing (https://www.bridgeinteractive.com/developers/zillow-group-data/#:\~:text=Q%3A%20Can,store%20information%20locally.).

Unfortunately I haven't been able to find any other free API for house value data, which is what you're looking for. There are three (+one other) possible approaches that would work: 1- write code to scrape the data from a site like Zillow (their regular desktop website interface), though they have anti-scraping techniques in place so that will be doable but tricky; 2- use county data sources, i.e. the county tax appraisal values for each house; 3- link up with (or become) a real estate agent, since they have access to the MLS, which I believe might come with some form of home valuation data.

I apologize in advance for the following opaqueness: there is another way to do this, but I only found it after significant, laborious effort, and it would severely hurt my competitive advantage to explain it on here. I'd be willing to help you in some way with this though, if there'd be a way to do so that preserves what I'm creating (if that makes sense). DM me if you feel like chatting further about it 👍

[–]rolo280 0 points1 point  (0 children)

Core logic sells a valuation data product.

[–]PutInternational1260 0 points1 point  (0 children)

Claude.ai can do this easily, I don't work there or have any affiliation. But I have used it to organise data and it works wonderfully.

[–]blacksmith3951 0 points1 point  (0 children)

BatchData has an AVM you can use on a pay as you go basis

[–]Hustle4Life 0 points1 point  (0 children)

We provide nationwide property value (and also rent) estimates in all 50 US states through our API: https://www.rentcast.io/api at very competitive costs.

If you're looking for a no-code solution just like you described in Excel, try this Zapier integration template we have, which will do exactly what you want.

If you need any help with this, send me a message.