How to Download Property Details Data

When I started real estate investing, I used to analyze deals one by one in a spreadsheet. This was time consuming, slow and hard to manage. But as of the last three years, I've been able to build tools to automatically evaluate deals with data and have shared these tools with others to do the same, all for free.

Ariel Herrera 0:00

It's wild to think that back in 2019, when I started real estate investing, I used to analyze deals one by one in a spreadsheet. This was time consuming, slow and hard to manage. But as of the last three years, I've been able to build tools to automatically evaluate deals with data and have shared these tools with others to do the same, all for free. My mission for this channel is to simplify success for you and ideally help you to avoid a lot of the mistakes that I made. And so I want to help you to build a data driven business that you can scale with automation. And if that's exciting for you, be sure to hit the like button so we can reach more people. And be sure to subscribe for new videos every single week. So taking it back to when I started analyzing deals in 2019. Automated options were few and far between. I didn't want to copy information like bedrooms and bathrooms down manually for each property that I saw. Since by the time I would complete each analysis, the deal could already be gone, I knew there had to be a better way to get property data and a pen metrics fast. This is where I stumbled on API's that already do web scraping for you and provide the data in a structured way. Let's jump into how you can get property details like beds, baths, square footage, purchase price, lot size, and Zestimate without a single line of code.

To get started, let's imagine that we're real estate investors, and we're looking to get information on a particular property. This includes what the current purchase price is possibly tax history comparables, Zestimate, the square footage, lot size, so much information, basically anything that we see when you pull up the property on Zillow. Now, this could be useful for wholesalers as well if you're looking to evaluate a deal. So we have this property here, which is 9407 and 21st. Street in Tampa, Florida, which is my Market. Now, if I wanted to evaluate this deal back in 2019, when I was first in real estate investing, I would have gone to this master spreadsheet, which is very useful. But I'll show you what implications there are. So I would come to say this property, then I would start plugging in numbers, I would take the list price, I would put it in the purchase price, tried to evaluate my improvements, estimate closing costs, down payment percentage interest rate, I would look at information on insurance, maintenance, HOA dues basically fill everything out, it's in yellow, then I would assess what my cash flow would be on a monthly basis. Now, although this was holistic to what I was looking for, there are some limitations in that I can enter in information incorrectly, because I'm doing it manually as well. If I'm trying to review multiple properties at the same time, I have to have multiple spreadsheets open, which just can become a headache as well. Unless someone who has a data science background, I knew there should be a way programmatically to extract this data. So before we jump into the actual API that we're going to use to help us get this information. Let me show you what the tool does. So you'd be able to enter enter property. So in this case, I'm going to grab this full address, and I'm going to my streamlet app. So this is an app I created in Python, there's no cost to use the app. This is just a layer on top of the API so that if you don't know how to code and don't seek to learn, you could still get the data. So let's imagine that I paste this into property detail. full address. Next step is for me to enter in my API key which will detail how to get that in one moment. And then lastly, is entering your email. So I'm going to enter my email here, run. And this will retrieve the data for us in real time. Do not leave the page because it's doing everything on the client side. Now, once this has been retrieved, we have the property ID, we can go to analytics. And we can again type in our email because I saved the data that way you can historically look at information up to 14 days. We will go to property detail. Select go. Now we can look at the latest properties we run data for and automatically we receive metrics. We could see the same information that came prior are from Zillow link. But now we see this data here. And we can look quickly at values like estimated rent, estimated value, price to rent ratio, price per square foot, we get a brief summary of the property itself, some information on historical taxes, as well as price, and we could see where the property is located. Lastly, we can download this data which has rich information about this property. You could even get data as to how often people have saved and like the property. You can also look at price changes, too. So once you download this information, you can do anything you like with this data. Say if you have your own flow already where you use Podio, or HubSpot, or maybe even Zoho, you can then upload this data for this particular property as well. So now let's jump into the API so you can see how to get started today. So this particular API is created by scrape peek, they have several real estate scrapers, including even getting information on deeds. Particularly, we're focusing on the Zillow scraper, which gets US and Canada real estate data, you could search for millions of for sale and rental listings by state, address, neighborhood, city or even zip code. To get started, click on the right hand side try for free. Here you will either log into your account if you already have one, or you will click Sign Up, enter your relevant information, and then click sign up. Once you sign up, you will see your dashboard, you will go over to plans and you will select the starter plan. This will allow you to query data for free, you will have 1000 credits per month, which equates to 100 Free searches. This is amazing for those who are looking to get information for their particular market, you will then come to Account Settings. Here will see your information that you entered your current plan, how many credits you use, and most importantly, your API key. your API key will allow you to access the information. Once you locate your API key, copy it down as we were going to use it and the property details and listings app, you still have to sign up for the tool itself. So here I will enter in my information. What's really neat about this tool is that I added a feature that will store the data for 14 days. That way, if you had a search from a couple days ago, and you want to reference it, you can do so. So click Agree. And then click sign up. Great. Now we could start searching. So let's look at another property. This is three 611 Potter Street in Tampa, Florida. It's almost a new build. And it's listed for 350k. It's located north of Ybor City, which is a popular destination in Tampa with lots of nightlife and restaurants. So if we wanted to not grab the address here, we could also grab the Z P ID from the URL. So I'm going to take the Z PID of top, go back to the app, go to property detail, answer the unique ID that I'm going to copy and paste the API key that I recently got from scrape peek. And once I copy the API key, the last step is to answer my email. So here, I'm going to enter coffee closers.com and click Run. Once this is running, do not leave the page, it only takes about three seconds for data to be retrieved. Once done, you'll see the snowflakes come down and you'll see your property ID below ending in five, nine. So if I go back to the analytics tab, I could now enter my email once more. And I'll go and select Property detail. Click go look at my files, and I see my property there. Now I can obtain the information for three 611 Potter street going all the way to the bottom. I can download this data. But you might be asking at this stage. Okay,

thank you area, I can now understand how to be able to obtain this information. I can see that there's 100 Plus columns of data. But I just want to know is this a good deal or not? How do we assess this this is where coffee closers comes into play. Coffee closers is a new tool that I'm a co founder of and it's made for buy and hold real estate investors seeking cash flowing deals. So in this case, I can take the above property three 611 Potter and I could plug it into the property calculator and select get results. There are five free searches a month. So you can test out the tool with ease. It gets information like property details, rent rates, images, neighborhood data, and cops. Right away, we could see price per square foot information. And we can get more data like cash on cash return, we can amend these fields to see how our cash on cash return would change. And we could review purchase costs as well. If we wanted to fix up the property, we can do so in this panel too. Now, in this case, cash on cash return is negative. So does that mean the deal doesn't work? Not necessarily. In this case, this property has been listed. Let's see. For 25 days, there's been a ton of use and saves, but still hasn't gone pending. And I see there's been a price cut recently. So they're probably motivated to sell this property. Now I've actually driven past the property and I know why it isn't selling, it isn't in the best neighborhood as of yet. So what I can do is come back to coffee closers app, and I could scroll down to the bottom and look at what makes the steel work. I can toggle to view what my cash on cash return would look like based on the asking price. So in this case, if I don't change anything above, and I want to seek at least 1% of cash on cash return, I would need to go 21% below asking price at 277k. This is very insightful because we can immediately know hey, we could still make this offer we're going to have to lowball but now we're in conversation with the seller. If you'd like to get started with coffee closers today, and please use the link below as well feel free to set up 15 minutes with me to go over the product as I'd love to get feedback at this stage. I hope this walkthrough has been useful and has shown you that in order to scale and automate your business, it's not worthwhile to copy down information manually. Instead, you should utilize API's previously scraped data to be as data driven as possible. If you haven't already, please like and subscribe. Thanks

Transcribed by https://otter.ai