How to Use Public Data to Find Real Estate Deals

by ARKANSAS DIGITAL NEWS


Do you lean into data when analyzing real estate deals? In a competitive market, ANY kind of advantage goes a long way towards helping you land better deals. And guess what? Harnessing the power of data is much easier than you think. Today’s guest delivers a handful of helpful tips, tricks, and tools that all rookie investors can use!

Welcome back to the Real Estate Rookie podcast! Today, we’re joined by Ariel Herreradata scientist by day and real estate investor by night. Five years ago, Ariel decided that real estate was going to be her path to financial freedom. Like any eager investor, she devoured as many articles, podcasts, videos, and books as she could get her hands on at the time. Once she realized that she could combine her love for data science with real estate, there was no looking back!

In this episode, Ariel shares about the competitive edge you can gain by being a data-driven real estate investor. She recommends several tools and systems, all of which are easy to implement and require ZERO coding. Additionally, you’ll learn how to choose your market, invest out-of-state, and save a ton of time with a few deal analysis shortcuts!

Ashley:
This is Real Estate Rookie, episode 349-er. My name is Ashley Kehr, and I am here with my co-host, Tony J. Robinson.

Tony:
Welcome to the Real Estate Rookie Podcast, where every week, twice a week, we bring you the inspiration, motivation, and stories you need to hear to kickstart your investing journey. Sometimes, we bring you data, and tools, and tips, and that is what today’s episode is all about.
We’ve got an amazing guest, Ariel Herrera, and she’s a data science by day, real estate investor by night, and she’s going to give you some really cool tips and tricks about using data to be a better real estate investor.

Ashley:
All I want to say is happy holidays, and this is our present to you from Ariel. She is going to give you guys so much information that you are going to want to just sit down and start implementing what she is talking about to accelerate your business. This was also a Christmas present to Tony. If you are watching this on YouTube, you will see Tony, all smiles and distractions, as he tries out every tool that she will suggest today.

Tony:
Yeah, at one point, you’ll hear my browser kind of crash, because I’ve got so many tabs open from other tools that she’s rattling off. I want to give a shout out to someone that left us a five star review on Apple Podcast, goes by the username of Hammond’s Fam, and Hammond says, “A fountain of information every week. I’ve deep dived into real estate investing these past three years, and I’ve been listening four years, and this podcast always has great information that I can leverage in my life and in my real estate journey.”
Hammond’s Fam, we appreciate you for supporting the podcast. Listen, for all of our rookies that are in the community that haven’t yet left us an honest rating and review, please do. It’ll take you two minutes at most, but your review helps us reach more people. The more folks we can reach, the more folks we can help. That is what we’re all about here at the Rookie podcast.

Ashley:
It’ll also be your Christmas gift to us, so you can go ahead and write that into your review as to Merry Christmas or Happy Hanukkah, whatever you are celebrating this season in there for that. We would love that. Let’s welcome Ariel into the show and get right into it. Ariel, I want to start off with talking about your epiphany that you had sitting on a bus. Can you tell us about that?

Ariel:
Yes. About four or five years ago as I started real estate, my real estate journey, I was commuting in and out of New York City for my day job. One day, as I was sitting on the bus around six AM, looking at the New York City skyline, I realized I did not want to do this for the rest of my life. Even though I achieved what my parents wanted, which was to go to a good school, get a good job, I was unhappy.
The reason being is that the time taken away from the commute, working full-time, I wasn’t able to be with my family as often. When I was, I wasn’t always present. With that, I started to research what are the ways I can get out of the rat race? There were three things that kept popping up. One, start an Amazon business, two, daytime stock trading, and three, real estate. Real estate was the one that spoke to me the most. I dived deep into about nine months of research, listening to podcasts, reading books, and watching YouTube videos.
With that, there was one consistent theme that I got from real estate was that there are people who have done this for hundreds of years with less resources than I have, less time, less money. I thought, if they could do it, why can’t I? That’s when I decided to make my journey into going to my first house hack in New Jersey. At that stage, as I was analyzing my own deals, I realized, oh, my God, the data is everywhere. It’s disparate. It’s hard to actually analyze a deal quickly. That’s how I got my journey into real estate and technology.

Ashley:
Tell us about your background in tech. Give us a little bit more in how you’ve actually progressed that into incorporating it with your real estate.

Ariel:
Sure. My technology journey kind of found me, in that I graduated at Rutgers University in business management. Never thought I’d be a programmer, but coming out of school, as I was in my first job, I took a course that another employee was hosting in the middle of the day, and really, it was just to get out of work for an hour. In that process, I learned that VBA, a coding language for Excel, can help automate tasks that you do every day in Excel, it could be lookup, or copying and pasting information. I was mind blown.
I was like, “Oh, my God, this task that takes me two hours a day, I could just code it and automate it within seconds? Sign me up.” From there, started my journey in the data science space. As I started to analyze my own deals, I started to utilize web scraping, APIs, which I could get into, to be able to leverage data to really understand the properties that I’m evaluating and analyzing them.

Ashley:
Before we get into more of your backstory and hearing about your investing journey, we are going to take a short break.

Tony:
Ariel, we’ve talked a little bit about the epiphany that led you into real estate investing, and then you had the shift in your W2 job that led you to data science. Before we go too far, maybe in layman’s terms, talk to me like I’m a fifth grader. What exactly is data science, and how do you think that’s helped you on your real estate journey?

Ashley:
Or just like you’re talking to me?

Tony:
Yeah.

Ariel:
Sure. The exciting thing is that data is all around us. It’s basically information. Say, for a property, some data you might be familiar with is the size of a home, if it’s a single family, number of bedrooms, number of bathrooms, for example. You may want to look at this data, say, on a spreadsheet, where you have all that information. Now, you could probably analyze all properties in, say, New York City within a given spreadsheet, but what if you want to do that across all properties in the US?
A spreadsheet’s not going to handle that, and that’s where data science comes in. We look to derive insights from data, usually large scale of data. To do that we use programming languages like Python to do so, and ultimately create charts, visualizations, and models to help understand characteristics about the data, and what can happen in the future as well.

Tony:
I want to lean into that just a little bit more, because I think for a lot of new investors is that when they’re starting out, one of the biggest questions that they have to ask themselves is, “What city do I want to invest in?” It’s a big question that a lot of people just honestly never even answer because they’re so overwhelmed.
There’s 19,000 cities across the United States, and trying to whittle that list down to something that makes sense for Tony, or for Ariel, for Ashley, it’s hard sometimes. How did you leverage your W2 experience of data science, and taking that list of 19,000 down to a few select cities that made sense for you to invest into?

Ariel:
Yeah, so I looked at economic factors, such as job growth, population growth, unemployment rate, median household income, and some more to analyze a particular area to see if it’s improving or if it’s on the decline. Where I got those metrics from was from government sources like the US Census, Bureau of Labor Statistics, and was able to aggregate that across cities to see it in one single view within a spreadsheet, and then be able to actually draw up charts, and analyze which of these we’re ranking towards the top in their own categories, and start to eliminate cities.

Ashley:
Do you think that a new investor starting out needs to be an expert in data science to analyze a market or a deal?

Ariel:
Not at all, especially with tools today like ChatGPT, that helps to aggregate and lift up information. You don’t need to learn how to code. You can just know how to use the right tools at the right time to answer the specific questions. There’s a lot of free tools.
For example, you could use Redfin. Redfin has data section, where you could download information on a particular market, understand if it’s trending upwards, downwards in terms of pricing, or if its price drops, for example. That can help to analyze a market without using code at all.

Ashley:
Can you give us an example of what you would actually type into ChatGPT? Like say you’re looking at Buffalo, New York, and just give us an example what you would say and type in there to get information back.

Tony:
What person in their right mind would live in a city where it’s negative 20 degrees everywhere? That’s what I would type into ChatGPT about Buffalo.

Ashley:
I literally have two blankets on my lap right now. I’m freezing.

Ariel:
Yes, you could use the ChatGPT and ask, “Buffalo, New York, new development, and growth.” From there, you’d get a synopsis of probably population growth as well as job growth. The new development part I love to put into place, because it will tell you if there’s specific areas where there’s new construction coming, maybe there’s new luxury apartments in the area, and that could also signal growth as well.

Ashley:
That’s very interesting. A couple other resources that I’ve used before were Bright Investor and Neighborhood Scout to actually collect data too. Before that, I was searching every separate single website myself, going to Crime Mapping, going to the GIS County mapping software, every little place I could find data from, but that is very time-consuming. I appreciate you giving us some insight on that, of how to actually accelerate getting all of that information together.

Tony:
Yeah, ChatGPT, they’ve been making some updates to their tool as well, so it’s like 20 bucks a month, like their pro version or whatever it is. Now, you can upload data sets to ChatGPT, and it’ll analyze it for you. It’ll automatically browse the web for you now as well. The tool’s gotten really, really cool in terms of the information it can pull in quickly.
I think for a lot of rookies that are doing that initial research, using a tool like ChatGPT to say, “Hey, what are some markets across the country that have low crime scores and good population growth?” That’ll at least give you a good starting spot. Man, the way these tools are progressing, it’s pretty crazy.

Ariel:
Yeah, it is at a rapid pace. Actually my secret is actually not ChatGPT exactly, but using Bard, Google Bard, its ChatGPT equivalent, but I find it a little bit more superior. It also pulls in data from Google Maps and the whole Google Suite products. That’s actually my favorite one that I use, and it’s free.

Ashley:
Oh, awesome. Thank you for sharing.

Tony:
Yeah, we need do a whole episode on just all the AI tools that are out there. I haven’t tried Bard yet. Ashley, have you?

Ashley:
No, I haven’t.

Tony:
Yeah, me neither. You said it’s free?

Ariel:
Yeah, it’s free. You just activate it on your Google account and you could start typing away.

Ashley:
Well, we know what Tony’s doing the rest of the day. Holding a baby.

Tony:
Yeah.

Ashley:
Using Bard.

Tony:
Playing with some AI tools. Well, so let’s go back to your journey, though, Ariel. You do all this data kind of collection, and where were you living at the time when you first started? You said in New Jersey?

Ariel:
Yes, in New Jersey.

Tony:
Gotcha. Okay. A somewhat more expensive market, right? New Jersey, New York, California, all these places are a little bit more expensive. Do you decide to initially invest in Jersey, and if so, what data did you see that kind of supported that decision?

Ariel:
Yeah, so there were three things I was looking into, which was one, first, how am I going to invest? What’s going to be my strategy? New Jersey, being an expensive market, putting 20% down in a 300K home, so $60,000 down, wasn’t viable for me at the time. I started to realize that the strategy I could take was one where I would live in the property first, and then rent it out after a year, so owner occupying it.
Once I understood my strategy, the next step was, where was I going to invest in New Jersey? Even though it’s a small state, there’s a lot of areas you could find. I wanted to do a 50 minute to one hour commute into New York City, and there were two options there, train or bus. Bus can have traffic, so I chose train. I started to look at different train lines, and what train stations and cities were near those train lines. North Jersey was too expensive, so that was Xed out. The where ended up becoming on the east coast of New Jersey.
There were three towns in particular, Woodbridge, South Amboy, and Matawan that were most interesting. Then the last piece there was, “Well, what am I going to invest in?” I really wanted to invest in a duplex, but again, didn’t have the capital to fund that. I decided on a single family home, but I used data to be able to analyze properties that had an additional bedroom opportunity.

Ashley:
How did you do that?

Tony:
Yeah.

Ashley:
When I think of it, I see like, “Okay, I’m analyzing a Zillow photo, being like, “Now, could I turn that room into an extra room?” Trying to figure out what the layout is just from the photos, have somebody on my team going to look at it or on the MLS. Please, tell us more about that.

Ariel:
Yeah, so my agent that I used at the time was one of my friends. I said, “Jeremy, this is getting difficult to go through Zillow, property after property. Could you send me just a list of the properties in a spreadsheet from your view in the MLS?” He sent me that, and what I was looking for were properties that the size of the square footage was larger than the number of bedrooms, to see if there was maybe a dining room, or some extra space, maybe an office nook, that I can transfer into a bedroom in the future.
With that, I did a quick calculation of square footage divided by bedrooms, and found this one property that was about 1,300 square feet with two bedrooms, which in the area I was targeting, I knew there could be possibly a third bedroom in there. We went to visit the property, and we saw the master bedroom was facing the street, which was kind of unusual. When we went upstairs to it, we saw that there were two closets on each end, two windows, and it looked as if it had been two separate rooms at the time.
Looking back at court records, it actually was. That was what initiated me to put an offer, and ultimately go through with that property.

Tony:
We got to pause there for a second. That is such a ninja trick. I’ve never heard of anyone doing that before, like, “Hey, I’m going to get an export of all of the properties, and then just put a little formula in Excel that compares the bedroom count to the square footage.” Then basically, you were just looking for properties that had a really good ratio between square footage and bedroom count. That is awesome.

Ariel:
Exactly. Simple, but effective.

Tony:
Yeah, because especially now, given where we’re at in the interest rate environment, it’s getting harder to find good deals. You’ve got to get more maybe creative on the front end to find those deals that have opportunity to maybe add some additional value. What you just described is that’s something that every single person listening right now can do is just ask their agent for an export, and then search and filter, and do that little trick. That was cool. I really liked that. Sorry, the nerd in me is geeking out over that one. That was cool.

Ashley:
Usually, you’ll hear people talk about scrubbing the detail of the listing, the description, and looking for office, or bonus room, or something like that to look for an additional bedroom. Yeah, that is great insight, comparing the square footage to the actual bedroom count.

Ariel:
Yeah, multiple ways to go about it.

Ashley:
Yeah. You find this property, and then tell us what happens next.

Ariel:
Yeah, so once we sign to the property, next thing was actually house hacking it. What that meant was having other people live in the property alongside myself. It was my partner, him and I, as well as a family member. My mortgage of $1,800, I was only paying 600 of it, and that really helped to propel me to save more money for my next deal.

Tony:
I was just going to add some clarification there, because I think a lot of times, when people hear the phrase house hack, they immediately think like small multifamily, where I’ve got to go out and get a fourplex or a triplex or a duplex. You can house hack in a single family home.
I don’t remember which episode it was, we interviewed Craig Curelop, and he authored the book on house hacking for BiggerPockets, and he said one of his first house hacks, it was a single family home, I think, but he was renting out every room in the house, and he was sleeping on the couch. Isn’t that what he said, Ash?

Ashley:
Yeah.

Tony:
He was renting out every room and he was sleeping on the couch. Even if you go out and you buy maybe a big, single family home, even if you’re only one person, you can still house hack that. I love that you took that approach, once you realized that the small multifamily wasn’t necessarily in your price range.

Ariel:
Yeah, 100%. Honestly, at first, I was nervous about living with two boys. I was like, “Oh, my god, this is going to be like a pigsty every day,” but it wasn’t at all. It worked out very well.

Ashley:
You know what, there’s no drama, though.

Ariel:
Yes, exactly. Just sports playing in the background all day, but that’s it.

Ashley:
Okay. After you got this first property in your house hacking, is this where you got bit by the real estate bug?

Ariel:
Yes, it was. I wanted to continue investing. I wanted to live in the property for a full year, though. I started to look at other investment opportunities that would be solely an investment where I put 20% down. Unfortunately, New Jersey being expensive, I started to look out of state instead. I particularly looked at Detroit, Michigan, with affordability for properties being lower, as well, I had someone in my network who had invested there and kind of leveraged their knowledge.
What was really exciting there is I started to now get more in depth with my data analytics. I didn’t feel as comfortable at that stage asking the agent for just a download of the data. Now, I’m looking at a wider scope since Detroit’s pretty large. With that, I actually use web scraping. Web scraping is copying information from the web as if you were going to Zillow, and copying down the property address, bedrooms, bathrooms, but instead of doing that manually, you could do it automatically.
I was copying that information down, and I started to get a little bit down on myself because the duplexes were a little bit out of my price range, about 150, 160, and I was looking to spend around 130. I started to look at single family homes, and I put them up in a chart. I wanted to see the distribution, so the characteristics about the data of the properties, to see how many were three bedrooms, four bedrooms, et cetera.
I saw there was one single property that was five bedroom, two bath, single family. I’m like, “Okay, that’s kind of odd.” I go to look further into that property at the description, and long and behold, it says duplex in the description. The agent actually listed it incorrectly, and it was priced about 25K lower than the other duplexes. I was able to make an offer in that case, and get it accepted at a lower rate.

Tony:
Wait, so sorry, I just want to pause and make sure I’m understanding what the scraping process was. How did you scrape all of this data? Is there a tool that you’re using? What are the steps to do that if someone wanted to replicate that?

Ariel:
Sure. At that time, I was using Python to do so, so programming language, but today, it’s even easier. You could use tools like Browse AI, for example, where you basically screen record how you would manually go about the process, what information you want to capture, and then it will automatically get that data for you, either when there’s something new on the web page, or if you want to set it every day, every week, it’ll get that information, and put it into a spreadsheet.
At that time, I did do it with Python, and I was able to get the information across the city for all properties listed on market in a spreadsheet to analyze.

Tony:
Ariel, you’re saying that this tool, Browse.ai, I can sign up for this website, go to any website that I want, screen record the information I want from that website, and this tool, using AI, machine learning, whatever, will pull whatever data I want from that website automatically?

Ariel:
Yes, exactly. There’s many tools similar to it.

Tony:
That’s crazy. I could go to Zillow. This is one of the things I’ve been thinking about recently, and now I’m just asking you selfishly for myself at this point, but we’re looking to do more rental arbitrage, and part of the issue is like, “Man, there’s so many listings for rents, and what’s a super easy way to kind of compare the short-term rental revenue projections to the long-term rental revenue projections?”
That way, I can see what that margin is, and ideally, I only want to reach out to listings that have more margin. Could I use Browse.ai to scrape all of the listings that are currently for rent, and then also scrape the revenue projections from an AirDNA and then compare those two things together? Could I set it up to do that, or am I thinking too far ahead now?

Ariel:
Yes, you could definitely set that up. What’s really cool about Browse.ai is that they have readily available bots for Zillow as well, and I think Redfin too.

Ashley:
Well, I know what I’m doing tonight.

Ariel:
Yeah, and just to add, no code, and it takes about anywhere from 10 to twenty-five minutes to set up.

Ashley:
I better text Daryl to get me an Alani, because it’s going to be a late night. I’m just going to go into a big deep hole of researching all this and setting this all up.

Ariel:
To get started, you could do it all without code using Browse.ai, and there’s actually videos that I have of tutorials, where I take you from beginning all the way to the end of creating these web scraping bots, all on your own, within 20 minutes to set up.

Ashley:
Make sure you check out the show notes after the episode where we are going to link everything. If you get distracted and go to the show notes now, you may miss another amazing link that Ariel has for us, so make sure you wait until the end, but we’ll put them all in there.
Thanks to our great producers and editors that will catch all of these amazing resources that we are learning here. We know Tony has already, have all the web browsers open of each one, making sure he doesn’t forget to go through it.

Tony:
Yeah, I’m just so surprised that Ash and I live, eat, and breathe real estate investing, and that neither one of us have heard of this tool. There are so many things out there now that make it so much easier for the rookie investor to find their first deal. Ariel, thank you so much for showing these tools to people that otherwise never would’ve heard of them before.

Ashley:
I want to say something about that real quick, because I think that’s almost, in a sense, just like real estate investing. When you’re starting out with real estate investing, there are so many different strategies, so many different ways to make money that it’s just overwhelming with all of the options. I almost feel that’s how AI is getting today, that it’s so overwhelming with all of these different things and capabilities that you don’t even know where to start, or things that are available, things like that.
Think about just on this podcast, all of these things that we have learned, like, “Oh, my god, you’re doing what to this mobile home? That’s amazing. We didn’t even know that was a thing.” You’re still constantly learning so much and being educated of all these different ways that you can make money, and also be efficient and effective at running your business.
Ariel, let’s get back to your story, now. Now that we’ve got on these tangents, and I am sure there’s going to be another one that me and Tony are wowed by and need to implement immediately into our business. We left off that you were looking into Detroit. You were scrubbing for properties. Did you find one?

Ariel:
Yes, I did. It was that property that was a five bed, two bath listed a single family, but was actually a duplex, and was able to get that at a discount of around 25K because of that.

Ashley:
The discount was 25K, or you got the house for 25K?

Ariel:
Oh, no, the discount. That would be incredible, right?

Ashley:
I was going to say, we have heard of houses being cheaper in Detroit, but I was saying, it’s been a long time since we’ve had anyone say they got a house for 25,000.

Tony:
You said it was listed as a duplex, so did you have to go in and do any work to it, or was it truly already a duplex, and they just listed it incorrectly?

Ariel:
Yeah, truly a duplex. I went to the county website just to confirm, and it was. It was just listed incorrectly by the agent.

Tony:
Wow, that is insane. You found two killer deals just by finding little nuances in the data, which I think is super interesting.

Ariel:
Yeah.

Tony:
Then I guess just one side question, Ariel, a lot of people, I think, have fear of investing out of state, and even more so people, Detroit, with some investing groups, has a bad stigma. Were you not nervous at all about investing out of state for your second deal?

Ariel:
I was nervous, and I went in person to get some boots on the ground, just to solidify what I saw in the data. Prior to, I was looking at Niche.com, which gives overviews of neighborhoods, and I wanted to find a neighborhood in Detroit that was more so skewed of ownership versus renters. Since usually there’s pride in ownership, maybe the lawn is more up kept, less trash.
There was a neighborhood that I was particularly interested in, Bagley District in Detroit, and luckily, having boots on the ground helped me to confirm that’s where I wanted to invest.

Ashley:
Let’s kind of talk about your confidence in investing out of state. How did you build your team there and feel comfortable investing out of state? Sometimes that is a barrier of entry for people is that they don’t know anyone in a market, and they don’t trust a lot of people. What are some of the things that you did to feel comfortable and confident investing out of state?

Ariel:
Yeah, I read David Green’s book, Investing Out of State, and that really helped me, because as someone who’s very methodical, being like a data scientist, I like to have a checklist of what I’m doing. I felt like that book was my checklist. In the back of my head, my mom, she was always like, “Ay Ariel, why are you doing this? Why are you investing out of state? Just sell a property you have. Sell everything.”
That’s always her mindset, but at the same time, she holds me accountable to follow criteria. She read the book too and she was like, “David Green said to follow this step as well. Make sure you talk to your agent about these things, your lender about some other topics.” I think properly screening my agent, my lender, meeting them in person as well really helped me to feel confident and be able to invest in Detroit.

Ashley:
You were starting to talk about, before I rudely interrupted you, but you were talking about your next market that you decided to focus on.

Ariel:
Yeah. Now, it’s March of 2020, and I’ve been able to save money by house hacking the property that I was currently in. I have some money saved, and then the pandemic happens, and a lot of people are moving to remote work. I selfishly had already been working remotely twice a week, and I was like, “Ugh, I wanted to keep this secret to myself, and now everyone’s going to work remote, realize how amazing it is.”
I thought, though, there could be some opportunity here. We always hear if you could invest in 2008 way long ago, you would be well off today. I thought even though despite this, what’s going on in the world, maybe there’s opportunity here. There were two things that I noticed that I liked about working remotely. One thing was, or I guess an epiphany, was weather. If I could work anywhere, why am I working in cold New Jersey where I can’t do things for six months out of the year? Sorry, Ashley, I know you’re a New York girl, but not my preference.
Then the second piece was income. In my head, I was like, “If I could work anywhere and program anywhere in the world, why would I do it in a place where I’m getting income tax? If I move somewhere else, I could instantly give myself a bonus of 10 to 20K instantly, just by leaving the state.” I thought, “If I’m thinking that, other people would think that soon too.” April 1st is when my partner and I, he and decided we were going to do whatever it took, eight weeks, figure out a market, figure out a place to live, and rent out our property on our own for the first time.

Ashley:
That’s super exciting. Do you want to kind of give us some of the numbers on a couple of your deals?

Ariel:
Sure. A property that I have in Tampa, Florida, a single family home, purchased it for 274K, put 5% down, was able to house hack it. At that time, my portion that I was putting myself was 550 a month. When I ultimately rented it out, the whole house itself, it was at 2,500. My cash flow there was about 700 or so.

Tony:
Wow, that is amazing. I’m shocked right now. These are such good deals, and the way that you’re finding them, it’s amazing.

Ashley:
What has been your favorite deal so far?

Ariel:
Yeah, my favorite deal was probably my property in Tampa, Florida in the Seminole Heights area. At that time, I had already been living in the Tampa area for about a year, but I wanted to find an up and coming area so that I could really leverage having a house that appreciates, and then be able to use that money in the future for maybe a future rental property. I was having difficulty at that stage, because it was 2021, people were outbidding one another left and right, getting a lot of people from the north who were coming with all cash offers.
I would be sitting in a meeting, I would get a notification on Zillow, a new property, met my criteria, but by the time I analyzed it at night, there was already people who saw the property and possibly already outbid me. What I decided to do analytics-wise is I paired my notifications that I got from Zillow with Zapier. Zapier is a tool that allows you to communicate with different applications. What I would do was every time I got that email, I would strip the email, take out bedrooms, bathroom, price, and property address.
I would then take that and then go to an API, so a way to get data externally for that property. Next step was automatically calculating cash flow through Zapier, just adding a couple of calculations. Then this last piece there was sending myself a text message if it met my criteria. Now, as a data scientist, I’m sitting in meetings throughout the day, and I could just get notification once the property in my criteria also met my certain cash flow metrics. It saved me a lot of time down the line.

Tony:
Sometimes, we interview guests…

Ashley:
If you guys aren’t watching this on YouTube, you need to watch Tony’s facial expressions.

Tony:
We use Zapier in different parts of our business, but I’ve never thought to use it to help with deal analysis. You’re so close to the problem sometimes, you don’t realize that the easy solution is staring you in the face, and what you just shared is such a simple solution to be able to move faster when it comes to deal analysis.
A lot of that high level stuff, it is just basic formula. You can kind of go in and do some nuanced if you want to, but man. Sometimes we interview guests, and we end up learning more, I think, than even our audience does. I love this conversation. That’s amazing. Ash, have you used Zapier at all before?

Ashley:
Yeah, but literally just like my National Fuel invoice comes into my email, it gets filed into my Google Drive. That’s it, more of just filing stuff, the emails that I get regularly. You use it too, right?

Tony:
Yeah, we use it quite a bit, more so on the marketing side, but yeah, never for actual deal analysis, which that just unlocks a whole new level here.

Ariel:
Yeah. The exciting part there, it was actually no code to set up. Pretty easy, just using all of Zapier’s readily available tools.

Tony:
Guys, for our rookies that are listening, hopefully you’re not feeling overwhelmed by some of the talk that’s going on, because a lot of what Ariel said is like, “Yeah, you don’t need to know how to code. You can probably watch a couple of YouTube videos, figure this stuff out.” She’s given you tools that are literally just, click the buttons you want to click, and the tool’s going to do what you want it to do.
Just having the courage to go out there and start playing around with some of these things, I think, gets you on the road to using them in the way that Ariel has here. Backtracking quite a bit, I don’t know if we asked this question up top, but if you can just set the table for us, Ariel, what does your current portfolio look like today?

Ariel:
Six units.

Tony:
Across how many different markets?

Ariel:
Four different markets, so New Jersey, Detroit, Tampa, and then Playa del Carmen.

Tony:
Playa del Carmen? All right.

Ashley:
Let’s talk about that one.

Tony:
Yeah.

Ashley:
Did you do kind of the same market analysis, or was this because you want to vacation there? Tell us a little more about sourcing that deal.

Ariel:
Yeah, similar market analysis, kind of thinking, “Okay, if everyone can work remotely now and they have the choice to work, say, out of the country, where would they most likely work?” There’s two options. If you’re going out of internationally, probably Canada or Mexico would be the top, since they’re still in North America. Mexico’s warmer. I thought more people would move down there.
I started to look at cities around major airports, so Cancun being one of them, I saw Playa del Carmen was a city that’s had a lot of growth over the last several decades, and in particular, it was already growing as an expat hub. I was going into the Facebook groups and seeing people communicate there about loving living in Playa del Carmen, the low cost of living, and some information about investing there too. With that, I started to sync with multiple different agents to talk about new development condos that I could possibly invest in.
I was a bit wary at first, because there could be scams investing abroad. I read up a lot on that, and I made sure I went with a developer that already had completed 18 condo buildings. I knew that there was already backing, and felt more solidified to go through with that deal.

Ashley:
How did you finance this deal?

Ariel:
I financed the deal initially with a down payment that I had from a 401K from a job that I changed through, but I actually didn’t have the rest of the money that I would need. The deal was 160, put 60K down, but I didn’t have the 100 grand. I was like, “Well, you know what? I’m going to figure it out as I go along.” It helped me to get creative. There were two things that I did.
One, all the knowledge that I’ve had about analyzing a market and list building, I put that into courses, which helped me to raise money for my deal. On the second end was that house that I had in Tampa Florida, that appreciated quite a bit, if in only a year. I was able to get a HELOC, so a home equity line of credit, on that property, to then pay off the rest of the Mexico condo.

Ashley:
Then you just used money from that condo to pay off your line of credit?

Ariel:
Exactly.

Ashley:
That’s such a great tool to use is to looking at your other properties, leveraging them to purchase another property. I think sometimes, it’s easy to get caught up as to like, “Oh, well the cashflow on my duplex, if I take a HELOC out on it, my rents won’t cover the HELOC.” Well, no, you take the cashflow for the rents from your new property, and go ahead and pay that off.
Just because the collateral isn’t the same doesn’t mean that you can’t take rent payments to pay off debt that you used to purchase and fund that property. That’s for another property.

Tony:
Then for the Playa del Carmen property, Ariel, are you short-term renting that, long-term, medium-term? What’s the strategy on that property?

Ariel:
It’s a short-term rental, and the plan that, if I needed to, I could always live in the property.

Ashley:
I’m trying to look out your window right now and see what’s the background there. It’s not Mexico?

Ariel:
No, it’s Tampa, Florida.

Tony:
Just you being in Florida, building out that team that you need to run a short-term rental in a different country, I’ve never even done that before, what steps did you take to find good cleaners, good handymen in that local Playa market?

Ariel:
Yeah, luckily there’s already a property management company that was synced with the condo building, as most investors are taking the same strategy. I did speak with them, asked a few questions, felt comfortable, and they’ve handled that part on their own. Then I’ve also Airbnb’d my property in Tampa. I’ve taken a similar approach of working for property manager.

Tony:
Let me just, final question on that piece. What made you go the property manager route, even for the Tampa home versus doing it yourself?

Ariel:
Oh, I wanted to really do it myself completely, just to save cost, but I had to take a step back and reflect, and realize all the things that I’m doing doesn’t end up being worth my time to answer calls, to, say, clean a property when I could be coding, and developing solutions, and helping out other people. It had to do a give and take.
Luckily, in that case, with the Tampa Florida house, I was able to get 15% for a property management fee, which is actually pretty low for the industry standard, since a friend and I did it at the same time for our properties.

Ashley:
Well, thank you so much, Ariel.

Tony:
Yeah, so much good information. I feel like we keep talking, we just got to keep bringing you back. I got so many more questions to ask you about all these [inaudible 00:38:27].

Ashley:
I know, once we start actually digging into it, we’re going to have a lot of questions, but we’re going to turn to your YouTube channel to check those out. Make sure you go into our show notes to find Ariel’s YouTube channel to learn more. We do have a Rookie Reply for you today. If anyone would like to submit a question, you can go to biggerpockets.com/reply, and insert a question that we may play on a Rookie Reply episode, or we may ask it to a guest.
Today’s question is from Laurel. I’m working towards getting my first property, and I’m considering going off market to really be able to find a property that is a deal. I see properties posted on Facebook, but because I still have my W2 and work during the day, I tend to be too late to get in contact with the sellers, and the deals are already under contract by the time I found the listing. Is there a way to see properties or be notified when properties are posted to social media? Thank you.

Ariel:
Yeah. Here’s where we could use web scraping bots, similar to Browse AI as well as Applify. We can take the link of our Facebook group, plug it in, and then screen record how we would capture a deal, what is the information we want to get from that post, possibly the listing price, maybe an email we want to take from it. Then from there, we can have it set up on a daily structure, where we get information in a spreadsheet that came from that Facebook group.
That way, we don’t have to go in manually every single day to get that, or we could even set it up on another way, where we get automatic notifications every time the page changes based on our parameters. We could set that up with no code at all, be able to read in data from Facebook groups, put it into a spreadsheet, and have that ready to analyze right away.

Ashley:
Wow, that is super cool. I actually spend a lot of time on Facebook Marketplace. I really don’t like social media in general, but there actually have been a lot of great off-market deals posted on Facebook marketplace, and they do get traction so fast. I’ve been looking at lake houses. A lot of times, people will list their lake house in the Facebook group of like, I don’t know, the example Lake Association, Be Neighborly, or something like that.
It will post it. People will post it in there, or they’ll even say, “We’re interested or thinking of selling our property,” and stuff. The next day, it’s already sold. It’s gone.

Tony:
I’m just going down the rabbit hole right now of all the tools that Ariel is sharing with us. I guess just for my own knowledge, between Applify and Browse.ai, which one do you like more?

Ariel:
I like Browse.ai more. However, if there’s a custom site that you want to scrape, say it’s a foreclosure website, or maybe something about the county website, probably going an Applify way would be easier, because you can actually contract out specific freelancers for more intricate web scraping tasks. They both serve a purpose, but a little bit differently.

Tony:
Man, amazing. All right, let’s go to our Rookie exam. These are the same three questions we ask every single guest. I’m getting caught up in my words because I’m so excited from the tools you’re sharing with us. Question number one, Ariel, what’s one actionable thing Rookies should do after listening to your episode?

Ariel:
Number one thing is to be data-driven. Don’t just go into Zillow, select a property at random and say, “I’m going to invest in that.” You could use data-driven tools that are for free and readily available. We could use Bard, Google, or ChatGPT to ask questions, start to narrow down what areas you may be interested to invest in.
You could also use free resources from Zillow and Redfin. They have posts every single month from their data centers on meeting listing price, rent prices, sales cuts, and that can help you to start to analyze where you want to invest, and where has more growth versus areas that are declining.

Ashley:
What is one tool, now, this is going to be hard to narrow down, one tool, software app, or system in your business that you use today?

Ariel:
Selflessly it would be Coffee Clozers, the company that I’ve co-developed with two other folks, to help find cash flowing deals in up and coming areas, and to tag properties that have opportunity. We’re able to get information from the MLS, and aggregate that data to help pinpoint what is the right deal at this moment to be investing in?

Tony:
For our last question for you, Ariel, where do you plan on being five years from now?

Ariel:
Five years from now, I hope to be full-time within my real estate startup company. It’s accelerating, and we’re helping people find deals, as well, I would like to be financially free, where I can help underprivileged communities learn how to program. One thing that I’ve taken away from my tenure, apart of my career, is I’ve never actually worked with another Dominican data scientist. I’m always the only one, which has come with some barriers, but I would love to be able to help others get into the programming space.
Unlike other careers, where you sometimes need to have some wealth to afford the right degree, or have the right network, programming, you can just get started instantly. All you need is internet connection. You could go to a library and use their computer. As long as you have an interest and curiosity, it’s a great field to go into and I’d love to help people there.

Ashley:
Well, Ariel, thank you so much, and you have helped a lot of people already on today’s episode. Thank you so much for taking the time to share your knowledge, and experience, and for us to learn about your investing journey. Well, Ariel, thank you so much for joining us on this Rookie episode. I’m Ashley at Wealth From Rentals, and he’s Tony at Tony J. Robinson. We will see you guys for our next episode.

 

Help us reach new listeners on iTunes by leaving us a rating and review! It takes just 30 seconds and instructions can be found here. Thanks! We really appreciate it!

Interested in learning more about today’s sponsors or becoming a BiggerPockets partner yourself? Email [email protected].

Note By BiggerPockets: These are opinions written by the author and do not necessarily represent the opinions of BiggerPockets.



Source link

Related Posts