Good afternoon, everybody. My name is Josh Hernandez. And today, we are going to take a very short quick webinar to look at quick statistics from any search results screen. Now this is going to be a short class, so I’m just going to start directly with the quick search. I’ll give you an example of maybe what our goal is for the day. We’ll take a look at the stats tab. I’ll show you how it works, and then we’ll go through a quick frequently asked questions about the stats tab itself. So let’s go into the search and I’ll exit these slides in just one moment and actually show Flexmls on the screen. But let’s say for this example today. I want to select a location and just get a snapshot of what’s currently on the market. What’s pending maybe under contract or recently closed listing. So I know in this particular location, we’ve got X number of actives pending and closed and I can even drill down into that. See what the average list price is, what the average sold price is for those closed listings. So that’s going to be our goal today as we use the quick search and we’ll do that by using the quick search itself.
Now, I will leave my full screen presentation mode just so I have access to Flexmls in my other tab, and I’m going to begin a quick search. I’m going to search by location. I’m going to select certain statuses to include and then relevant search criteria, maybe property subtype. Like I just want to look at single family listings or your built. So we can do this from any search results screen. You could do it when you’re looking at a hot sheet. But for today’s example, I’m just going to build a search. So I’m going to go to Flexmls and I’ve already logged in, so I’ll click on my quick search. When you go to the quick search, we’ll just take a quick overview of this, a ten second overview. Let me zoom in on my screen just a little bit. And when I’m using the search, if you’re new to using Flexmls, I always say you start by entering your search criteria, then you find your results, and then you take an action with those results. So we will enter our search criteria here. I’ll use the map in today’s example. You don’t have to. We’ll look at the results and this is the results row. You’ll see edit search. This is where we’re currently at, but we can view the results in a list details, photos, map, and stats. That’s what we taking a look at today. And then our actions are at the top. We’ll talk about a few of those as well. So let’s put in our search. Now, you’ll see in my current MLS that I’m looking in. It’s a very large regional MLS, so I have a lot of listings available. So I’m going to search. You could use any location fields that your MLS has for the search template. Maybe you’re typing in and looking for a specific subdivision or something like that or neighborhood. I don’t currently have those as searchable fields in my demonstration MLS that I’m using. So I’m going to use the map and you can draw on the map in several ways, but I’m going to start off and in this example, I’m just going to locate an address on the map. So you’ll see I clicked that pop up that was there away and my map tools are on the right hand side.
To find any MLS or not MLS number to find any address, it doesn’t matter if it’s been on the MLS previously or not. You can use the map tool. This red push pin is your locate address feature. So it’s looking for just an address going by Google Maps essentially to find an address. It’s not looking for any current or previous listings in the MLS. When I click that, it’s just going to help me locate the address.
So I’m going to type in the address of twenty four zero nine Harbor Lane, and our zip code five eight zero seven eight. When you type in your address, city, state, zip, all of your address information, just click on locate, and that gives me my push pin. Now, I can use my zoom functions to zoom in make sure that’s located where I want that to be. I’m just clicking that plus to zoom in right now. I know already this is where I want to be. So you’ll notice the push pin. I could move it around if necessary. You can drag and drop. But what I’ll do for today’s example is I’m just going to do a radius search. And when I click on that radius search it defaults at one mile. If you want to keep it at one mile, great. If you want to change that maybe for today’s example, I’m going to do point five miles. And then I’ll just click this create radius. Now you can draw on the map and do a freehand shape or anything like that. I’m just using a radius for today. So you’ll see there’s my push pin located on the map. And right now, I haven’t put in any search criteria. So by default in this MLS I’m demonstrating in, it’s just showing me active listings. So all of those green dots on the screen are active listings. And over on my search template, you’ll see status of active. Now if I want to include multiple statuses, just use your control key, hold that in or command key if you’re a Mac user.
And while you hold that control key in, I’m making my additional selections in this status section. So you’ll see now it’s looking at active listings, pending listings, and the off market date on those pending listings. It’s going back three hundred and sixty seven days. I could change that if I want. And closed listings also going back, one year. So as I’m looking at that, that’s how I would select multiple statuses. Just click, hold your control key, command key for Mac users, and while holding, select the multiple statuses. Now, if there’s anything else that I want to include, maybe I know this area has a lot of condos or things like that that I want to ensure are not included.
So if you have a property subtype or style or stories that you’re looking for, I can always use those fields that are on my template and put those in. Or maybe, for example, your built. I want to make sure if your MLS has a year built field, maybe I’m just looking at listings that have been built within the past fifteen years or so. So now we’re down to seventy one results and you’ll see it say seventy one right here. Now as I mentioned, I can put in any search criteria that I want maybe number of stories or anything else.
But just for this example, I’m going to take these seventy one listings and I can see them on the map, but I’m curious now how many of these listings are active? How many are pending? How many are closed? What’s the average sold price on those closed listings? What’s the average number of bedrooms bathrooms? And I can move from my edit search to any of these results options and I’ll click on stats. That’s what we’re talking about today. And my stats tab, you’ll notice it’ll take just a moment for it to load depending on how many listings you have in your search results and, of course, your speed of your Internet connection. And I can see currently in this set of search results, my seventy one listings over on the left, I see a breakdown by status right here. And I’ll just give you an idea here. We’ll see account by current status. We’ll look at average, median, low, and high, and days on market to and sale to list price or sold to list price ratios. So those are the three things that will display here on the stats tab. Eight active, one currently pending, and within that past three hundred and sixty seven days, sixty two of those listings have closed. Now, status is outside of active, pending, or closed, or sold depending on how your MLS labels that, those would be included in the other statuses. Those would kind of get grouped in. So if you have active listings that are, possibly active under contract or something like that, they may get grouped under other if you have those in your search results. Now, right beneath that, I see average, median, low, and high statistics. So looking at all seventy one of these listings, I can see the average number of bedrooms, three point seven. Bathrooms, two point eight. Square footage, twenty four hundred sixty two. Original list price, list price, sold price, list price per square foot. Sold price per square foot, sale to list price, and sale to original list price ratio. They’re hovering right at ninety nine and ninety eight percent here. Days on market. And if your MLS uses things like cumulative days on market, you’ll see that as well. And then what’s that average price change, for those listings? And I see the average for that. Now, if you’re into statistics and you say, well, the average sometimes in this data set, I’ve got some outliers. There was one million dollar property that was sold, but that was the only one. In that case, median listings, median, one of the benefits as long as you have a nice sample size is that your median listings kind of kick out the outliers. So this is not a stats class per se where I’ll go down and break down how stats are calculated, but that’s the exact middle number here. If I were to look at all my listings, three bedrooms, three baths, square footage, original list price. So I see my median statistics here as well. And then I can see the lowest. What’s the lowest amount of square footage included here? Sixteen hundred or the lowest original list price, twenty six, two thousand six hundred, two hundred and sixty four thousand, excuse me, nine hundred high. And then you’ll also see at the very bottom of this, the number of listings that were used in that calculation because I’ve got seventy one total listings, but for my sold listings, it’s only using the sold listing. So it’s not using all seventy one to calculate a sold price or sale to list price ratio. It’s using, those sixty two listing.
So I have that here as well or the listings that with the price changes. How many had that price change? Twenty three. So you also get that information here.
Moving down is our third section here with days on market and sale to list price, ratios. So this is only using those sold listings.
So I can see how many of those listings that were sold sold within thirty days, twenty nine and that represents forty six percent. Those that sold that quickly, ninety nine percent sale to list price, sale to list price and and sale to original list price ratios. Those that sold in the time frame of thirty one to sixty days. I can see fifteen out of all of those sold listings, what percentage that is and their sale to list price and original list price ratios here as well. And of course, as that goes beyond sixty, I see some of those sale to list price ratio starting to fall. So I know if we’re selling within sixty days looking at our current market and what’s been going on in the past year for those sold listings. The sooner it sells right now, the suit the higher that sale to list price ratio is going to be. And then it’s broken down graphically here as well where I can see how what percentage sold within zero to thirty, thirty one to sixty, and so forth.
And then lastly, if your MLS uses cumulative days on market. So when a listing goes off market and then is relisted within a certain amount of time, that information is also included here. So that can give you slightly different information. If any of those sold listings were on for an extended period of time, they went off market, they were relisted by somebody else. So I would see that cumulative days on market sale to list price ratio information here as well. So this is great to give me a snapshot just saying, okay, looking at these listings, average number of bedrooms, average list price, average sold price. Looking at this information, let’s go into some of our frequently asked questions and we’ll just do our last five minutes responding to these.
Number one. This is very good useful information. Sometimes you want to share this with the contact. Maybe you’re discussing somebody who’s considering putting their home on market and you want to show them what’s been happening around them. Can I share this? Can I share these stats with the contact? And you have several options. So I’m going to go back here to share that. Right at the top of the stats page, I’m just gonna move all the way back to the top, you see a print option. So if I just want to print this off and put it in a presentation, I have that option. I’m going to click on that.
And here, I could send that to my printer and print this off. I don’t have a color printer, so it went black and white. Maybe I want to just email that separately to to one of my contacts as an attachment. I don’t want to wait until I meet with them in person. I just want to send that to them right now. You could always click and save this as a PDF and that’s just your browser as you’re going to that print option. We’ll have that option. What are you doing with this? Sending it to my printer or saving it as a PDF. You do have an additional way to share this with your contacts as well. So rather than just printing a report, if I wanted to email this whole search, all of these search results to my contact and let them see kind of the interactive search page right here. I could go up and I could just email all of these listings to my contact as an interactive listing format. So let me show you that. I’ll click on email. We’ll click on the interactive version. And on the left, what am I sending? Not my currently highlighted listing, but all search results. I’m sending the public version, so it’s only publicly available listing information. And then on the right, who am I sending this to? You can type in an email address. I already have Megan. I’ve created her previously in different demos, so we’ll just show you what Megan will see right here. And then I’m just going to say search stats in West Fargo. Put in my message. Hi, Megan. Here are the statistics we talked about. Take a look. Let me know what you want to do.
And when I email that, I’m going to go ahead and show you what Megan sees.
So I’m gonna pull up Megan’s inbox on my other screen and bring it over. You can’t see your client’s inbox. Megan’s got a search where she’s getting automatic updates. I use her for automatic update demos. But here’s the email that I just sent from my Triune account, search stats for West Fargo. Here’s the message we sent to Megan. But when Megan opens that, it included all seventy one listings.
So what Megan sees is an interactive version of these listings where she’s going to be able to view all of these listings, pull up details as well. But you’ll notice Megan can view these as a single line view, the summary view in the map, or she has this stats tab as well.
So when Megan clicks on that stats tab, she’s going to be able to see the same information that I had sent her. And again, it will take just a moment, but she can see currently eight active that are nearby that address, one pending, sixty two closed. All of that statistical information is there as well. And the nice thing about this interactive listing format that I sent, if Megan opens that up on a mobile device, which I think most people often do, they’re not looking at on a laptop computer. This is automatically formatted here and resizes for mobile device. So I can see or and rather Megan would see that information. Now in these charts and graphs that come out, if they don’t fit on the screen, they can scroll to view the rest of those. So that’s an additional way that I could share that information with Megan.
Now back in Flexmls, I’m gonna go back to my search results. Do I need to select multiple statuses? So maybe, for example, I just want to know what’s the average list price of all of those current eight active listings. I’m not interested in the sold depending. You don’t need to select multiple statuses. I did that for this example, but I can always just go back, edit my search. I’m just going to look at active listings, will pull up eight. And then when I see my stats, I’m going to see again all of the possible statuses, but now only eight listings are being used. I’ve got eight active. My sold price information, the column stays available, but of course, there’s no sold listings here. So I won’t see sold price information or again for those sold listings and days on market. That information is going to be null as well because I’m not currently looking at sold listings in my search results. Now, I’m going to go back. We’ll just add in closed again. Next question. Can I customize the fields that display in the average, median, low and high statistics? So by that, when I go to that statistics screen, I’m referring to that second section that we looked at, the actual average, median, low, and high. And we’ll just wait for that to load.
As I look at this, the question really is, maybe I’m looking at a search for vacant land and it doesn’t have bedrooms or bathrooms. Can I customize the fields that display in this section? So it maybe I don’t want to include bedrooms or bathrooms and the answer is going to be no. This is hard coded into the system. So it’s most useful for any kind of residential listing or rental listings that are using bedrooms and bathrooms. If you want to get full use out of all of those fields. If I did the search for land, these would just show zero or a no value for bedrooms and bathrooms. But I’d still be able to see original list price, sold price, sale to list price rate ratio. All of that would still be included, but I can’t customize the columns that I have display here. These are just hard coded into the system with that.
Fourth one, can I run statistics or only specifically selected listings? So maybe I ran a search and as I’m looking at these listings, I’m going to go to my list tab, and I’m going to look at the one line view. And as I’m looking at this, let’s sort.
It’s going to sort these by price, And I’m going to grab maybe I’m looking for comps and I’m I know what my subject has as far as square footage, number of bedrooms, number of baths, and I’m going through looking at these in the list, the detail, the photos, and I want to specifically select just some of these search results. Now I’m just going to grab five right here. So you’ll see right here seventy selected. I’ve got five.
When I go to my stats tab, that’s going to be showing me the statistics for all of my seventy results right now. However, if I just want to view the stats for the selected five, I have this results row, so I can see which ones I have selected. Just click on selected. Now, I’ll only view those five selected listings. I can always toggle back to all seventy, but now I’m just viewing five.
And now it’s giving me the stats for just those selected listings. So I see I’ve got five selected, five closed listings. My average list price sold price, it’s just using those five selected listings. So you can see my number of listings that I’m used in that bottom to achieve those calculations. It’s letting me know there are just those five sold listings that are being included. So now I can see what’s the average list price on those five selected listings. What’s the average sale to list price ratio? The average sold price. And I can also see, how quickly did they close for those selected five. And I see one sold within thirty, one sold within thirty one to sixty days, and the other two that sixty one to ninety day time frame. So you can just view the statistics for selected listings only. Now I can always toggle back to view all results from selected.
And when I do so, I am going to go back to all of those included seventy listings in our search results here. Finally, our last question is this is great information. This was a very short direct purposeful webinar, But is there a way to for me to see market trends over time? So can I see what months are prices trending up? What months are they trending down? So we won’t get into that today. You can definitely do that inside Flexmls. And if you’re interested in that, you can always read ahead and go into the market trends graphs in the menu. I’m not going to go there today. However, I will plug our upcoming webinars. If you go to help in the upper right corner and go to the Flexmls Academy. You can see upcoming webinars here as an option. And here you see today’s webinar was here previously, but right at the end of the month, we have a buyer intelligence webinar for market trends and statistics. So it’ll be a quick review of what we’ve done here on the stats tab, but really moving on from that and using other Flexmls features to be able to see and graph market trends over time. How many new listings were in each month over the past year? What was the average sold price for those listings in the past year each month? We’ll take a look at that sort of market statistics in the webinar on February twenty sixth. With that, I want to thank everybody for attending today.
This session has been recorded and will be available in your inbox tomorrow afternoon, as well as the FlexMLS Academy. It’ll be here under the recording trainings within usually a week or so. And I’m going to take a pause now and just check to see if there were any outstanding questions. And I don’t see any. So thank you again for attending, and have a great rest of your day.
