Working With Sellers

Video Thumbnail

Your trainer

Anne

Anne joined FBS early 2020 as a member of the CPR team after being an MLS Director for several years in Southern California. She enjoys training agents so they can be both more efficient and comfortable working within Flexmls. Outside of work, she is a Movie Lover and Science Geek who loves to travel, read Murder Mysteries, and play games of all kinds.

Welcome everyone. My name is Anne O’Shea and I am your Flexmls trainer today. And today’s webinar is called Working with Sellers.

Before we begin, we are using GoToWebinar and should you have any trouble, first be aware that we are recording this and you will get a copy of this recording in an email around this time tomorrow. So if you have to step away because of a client call or your dog or whatever, you can do that easily. Not a problem, you’ll get the recording tomorrow.

If you’re having any trouble with GoToWebinar, you can try going to the help menu at the top. You can also sometimes with audio issues, if you’re having any audio issues, you can use the phone call, which gives you a phone number and personal pin. So you can call in on the phone for the audio and watch on the computer for the visual.

If you can hear me but you can’t see my screen, then I would try restarting GoToWebinar.

And again, if you’re having a bad connection, need to leave early, anything, approximately twenty four hours, so not to worry.

If you’re not having any issues, which most of you hopefully are not and most likely are not, We have the questions pane available where you can type in your questions. And both Josh and Amy, my fellow trainers are gonna be answering questions throughout. So you can always type in a question there and they’ll be able to answer you.

So today’s topics. Seems like a short list, but we’re going go into it quite a bit. But these are really the things that in the FlexMLOS system that you’re going to most likely use with your seller. So we’re going to get into the full CMA. I’ll also point out some other CMA options you have. But typically, the full CMA is what you’re going to want to use for your sellers. I’m also going to show you how to print or email an incomplete listing.

And then there are these great listing reports a lot of people seem to miss that are available that you can share with your seller and even set up a regular email to them. So very handy. I’ll show you how to do all of that. So let’s begin.

So here I am in the Fargo Moorhead MLS. And this is our typical demo MLS for these general webinars that go out to the entire Flexmls family. So if it looks a little different than your MLS, sometimes property types or something is different, not to worry. All these features I’m going over, you still have the ability to do in your MLS.

It’ll just look a little different. So at the top of course we have Flexmls and right next to it is this quick launch bar.

In the case of Let’s see. How best to start? We’re going to jump into a full CMA, but there are two scenarios that you may have. You may have one scenario where you have an old MLS number that is for that particular property that these potential clients are currently living in that want to sell. And that will save you some steps. So I’m going show you that little shortcut.

But I’ll also show you how to do just a radius search around a property that’s never been in the MLS before So you can do the CMA that way. So there’s two ways to attack that full CMA.

And again, this all may look a little different because I’m in the Fargo Moorhead MLS, but you can still do this where you live. So we’re going to jump into QuickSearch. Come on, QuickSearch. Wake up. There we go.

There we go. Good.

My Internet has slowed down, I apologize. It’ll catch up, I’m sure.

So like I said, maybe this listing was once in the MLS. This address was once in the MLS. So before getting all the way into quick search, I’m gonna come up here to the quick launch bar and put in my potential client’s address just to see has it been in the MLS before. So I’m just gonna put in four thousand thirty two Copperfield.

And I just start typing in their address and I can see their two previous listings with Copperfield Court. And I love this little thing here, new tab, click on new tab.

And I’m gonna get right into that listing. And the key thing when you pull up an old listing for a property is you wanna make sure that you’re looking at the most recent version. I apologize, my internet was working perfectly a half an hour ago. It’s just slowed down, something turned on somewhere. But I’ll still talk plenty over these little gaps in the visual, so don’t worry.

Here’s my old MLS number for this address. And I can see the little mini map and that looks like the proper place that I met them or I’m going to meet them, etcetera. When I look up an MLS number, jumps right in here and it puts me in the detail tab, which you can see here on the right. And I wanna point out the history.

So I’m gonna click on history because it’s gonna show me past listings for this address. And I’m gonna always want the most recent, which I happen to be in. The seventy four thousand five hundred seventy seven. And again, your MLS may have a different numbering system but you always want the most recent because maybe there was a bathroom added between the first listing and the second or something like that. So you want the most recent.

So I’m just gonna copy this MLS number. Actually, I’m just going to jot it down. Seven-four thousand five hundred and seventy seven.

And actually, I’ll leave this tab up and open so it’s handy. Click on here. And now I’m going to if you don’t know anything about the house, of course, can come over here and look at the listing on the report here, which we were just in. And I’ll see that it’s Again, my apologies. I know that it is four bedroom, three bath.

So I can see that in the old listing. And of course, if they tell me differently, I can adjust.

But I’m gonna do my typical CMA quick search, which would be active pending and closed listings. So obviously, don’t want to do a CMA on seven thirty three listings. So let’s come down here to status and I’m going to click. In this MLS it defaults to active. I’m also gonna click on pending and close.

I’m a PC user, so I’m gonna hold down my control button to select more than one thing. For you Mac users, that would be a command button. And now I have twelve hundred oh, it jumped again. It’s constantly updating six thousand listings. And this MLS defaults one year back. You can see all these little arrows here to the left of that and I’ll zoom in a bit.

That gives me a change of date type. So you can pick a specific date, maybe you wanna do it since April first of last year. Whatever your scenario is, but I’m just going to pick thirty days back. So I’m going to change this from a whole year to thirty days back. And if I wanted to, I can even click on days.

You’ll see that it’s underlined and I can click and make it a month because my little cursor turns into my hand when I’m over there. So thirty months back, click it again, it’s thirty years. And again, thirty days.

And again, we’re trying to look for comps for this particular property. So I want to get I’m just going to look at single families And bedrooms, I’ll pick, say I don’t know if I wanna pick exactly theirs. I’ll pick maybe four to five. They have a four bedrooms. Oops. Four to five and they have a three bath.

So maybe I’ll pick three to four and see what I come up with. I’m down to three twenty six results. So I want to still narrow the field. I’ll use total square feet. There’s is a little over three thousand. So I’ll pick a range, maybe two thousand eight hundred to three thousand two hundred. And you can adjust all these numbers.

If you’re not in city limits, you may need to do a longer timeframe or you may wanna do a bigger range of square feet. Whatever it is to give you an appropriate number of response results. So I can see that these are all over on the map, all over town.

And I want to just narrow the field into that general neighborhood. I know that they’re in this area. So I’m going to come down here to one of my map tools and I’m just going to use the simple rectangle this time.

You can get very detailed and just go over specific outlines with the other tools, maybe just a specific builders tracked. You want to outline every single thing. I could certainly do that using the polygon tool, but right now I’m just going to use the rectangle. And let’s see what we’ve got. I’ve got nine results. So I’m going to come up here to the list and take a peek.

There they are. And now I like to sort them by price myself. You might want to sort them by maybe something else, maybe by bedrooms or bathrooms or square feet, whatever it is. I find it a little easier to sort it here, but it’s total preference. You can certainly sort them in the CMA and I’ll show you how to do that. But today, I’m just going to sort by price here.

I’m going to do descending and I’m going to just do it here in the search rather than in the CMA. And I like to see that nothing’s completely off the deep end. I can actually come in here and select them all and say, you know what, I happen to know that this pending, this house has very little to do with this. It’s not an appropriate Or maybe it’s this one, not an appropriate comp.

So I would just take that out of the list. So now I have nine results and eight selected. And I’m gonna come up here to these action buttons up here that you use all the time, email, save and print. Right there next to it is CMA. I’m gonna click on CMA. And here you can see I can use all results, so I can still change my mind and use all nine. I can use selected, which is those eight.

And here’s even your one line CMA for those of you that would like to do just a quick and dirty one line, just the facts, just the stats. But I’m going to come in here, get into that full CMA. I’m going to use the selected.

And here I am. So as you can see, I’m in the create the CMA window and right here, I want to point out something new. This is a guided help, which you have up here. Guided help, which will walk you through the process of CMAs. And it’s fabulous because it’s like having a support staff looking over your shoulder and pointing at things to click on.

But I just want to point it out there for you.

And the first step we have is to choose what type of CMA. You have quick CMA, which you don’t even need subject property for, just maybe for This is more for buyers that are looking at a particular neighborhood, say. Statistical, that’s where again those number crunchers, maybe your client is an accountant and that’s all they want. There you go. You get lots of information right there.

And there’s even a particular type of statistical CMA in there for you appraisers out there. But we’re going to do the default, which is that full CMA today. And you can even say it’s useful for sellers and includes options for cover page and many other things. So let’s jump in. Now select statistical type. This one, the statistical average field is based on square feet.

So the price per square feet is what’s used here in this MLS for overall statistical analysis. If some MLSs, some scenarios, there’ll be other options, but this one’s just square feet and we’re just gonna leave it as is and take the next step.

I’m gonna close this just to help my bandwidth a little bit. Okay, here we are, cover page information. Now you don’t even have to do a cover page, but I’m going to go ahead and do one. So I’m going to say this is for my client, Mark Watney. I already typed his name in so he was there, but you can just type in whomever.

I can do today’s date or this is a cool feature, always use current date. So maybe I’m going to start this, but I end up not emailing it or printing it until tomorrow or the next day. This will make sure that it’s always got the current date. So whatever day that I actually finish and send it off, it will have whatever that date is. And I’ll just use my name here.

If you have custom business cards in the system, you could choose a different one. But most of us just have a default, which is fabulous. It has all our current information. Comments optional, but I’ll type in comments. Maybe you want to tell them your experience selling in their neighborhood or how thrilled you are to potentially work with them, whatever it may be.

Put that here. And you have three thousand characters max. Put whatever you like.

Next step down here, subject property. Well, as I said before, you may not have a subject property from the MLS. But in this case, I have that old MLS number. So I’m going to use this shortcut of auto populate fields from an existing listing.

And I’m going type in that listing number seven-four thousand five hundred and seventy seven. And it’s from the Fargo Moorhead Association Realtors and I’m going to click Submit.

And that’s going to auto populate all the information from that listing in here. So I don’t have to do it manually. You can do it manually, but this saves you a couple of steps. So it’s worth taking a peek to see if you can find it. Now, it also includes the photo from that old listing and that’s fourteen years ago now. So you may want to upload a new photo.

You could remove the photo because maybe they painted and you don’t have a current photo to replace it with. You can just remove it altogether or upload an updated something. It’s up to you. In this case, I’ll just keep the one that came with it from the old listing. Now it auto filled this in and I can adjust. Maybe I can even create templates. If you run CMAs all the time, you may want to have a favorite template where you include certain things.

Like maybe you don’t want to include lot acres or you do want to include but not lot size dimensions. Whatever it is, you could customize. Another wonderful thing about Flexmls, you can customize so many things so that once you get it set up, it just makes your life easier. But in this case, I’m just going to leave it as is. This is the default that comes from the MLS.

If I hadn’t made it custom, I would just choose it here out of the dropdown. Very easy to use. If you notice, I have no lot acres information. So I’m just gonna come over here and delete that with the big red x.

And maybe I prefer that the garage type, is attached, be up here by the style. So I’m going to click on the gray arrows.

And now I have the blue arrows and I can bump this up one level. So now it’s below style. I like that where it is. And I’m gonna click next step.

So here we have our comparables. Now, I wanna point out that what if you’re like, uh-oh, maybe I need to go back and find some more comps. You could certainly do that. It’s here. Return to search results is right there. But I have them all here and they’re all in the order that they came by status. They are supported by price, which is what I did when I was in my search results.

But what’s nice is that here, I can still remove things, map things, report a location, and I can move things around. Maybe I want this one up next for whatever reason, or I can remove something at this point if I like. But also there’s this little thing here that says edit sold price for this listing. Perhaps there was a bonus involved and perhaps your MLS doesn’t include that in the sale price.

Whatever the application may be, you have that at your fingertips. You also have here, you could add other comparables.

Maybe you want to use the comparable that was not in those search results, but it’s a house that’s very similar, maybe it’s a few blocks over. You want to throw that in. You can put in that MLS number right here. If I had a listing collection that I put together of things that I wanted to throw into my CMA for this client, I can throw them in here very easily.

I can find another quick search results and throw them in, find more comps. But I’m not gonna do that today. I do wanna point out also you have Those are all MLS comparables. And here is the non MLS comparables.

So I’m gonna click on that and I can over here create a new comparable. So maybe there’s a FSBO in the area that I wanna include. You can do that for sale by owner. You can put that information in here manually. Again, I’m not going to do that today, but you have this all at your fingertips.

So what else? Let me just take a peek. Make sure there’s nothing. Okay. Good. I thought I got a message from one of my co trainers, but we’re good. Okay. So here we are on the Comps tab and say we like where everything is. We want to keep them all.

I can still come in here and deselect something and only use the selected. Again, we give you lots of choices, a lot of time to change your mind, change things up, add things. But I’m gonna take the next step. Now, you notice, next step is here as I’ve been clicking on. But you also have this tab. The other tabs we’re not quite ready for, so they’re still grayed out. But can always click the next tab here.

So you have two places to click. So I’ll click on adjustments.

Now, adjustments. This is a tab that a lot of people just skip. You do not have to do this tab at all. This is for those that really know the neighborhood or really want to make sure to adjust prices based on some feature.

And your fields that your address that we had in that first step are all here. And these are all the different addresses here. And I can adjust them by address. Maybe a certain street, maybe Autumn Drive is worth always ten thousand more. Any house there is always ten thousand, you you can say even overpriced because of that street.

Maybe it’s a really pretty street or something. I can make adjustments. So let’s do the typical, which is like bedrooms and bathrooms. Of course, in this case, all my comps all have the same bathroom. So we’re not adjusting there. But I am going to do some adjustments on the bedrooms. And again, this can be confusing. Some people don’t like to do this.

There is some great help. And I do want to point this out. Wherever you are in the system, you have help with this page. And this really goes into some details about how you can create manual adjustments, which is what I’m going to show you today. You can also set up auto adjustments and there’s even predefined adjustments that you can do and open this page in a new tab and learn all about it at your convenience.

I’m close that for now. And I’ll just show you this basic adjustment where my subject property here at the top has four bedrooms. And this is four bedrooms because I came over here and selected out of here. Four bedroom. I picked total bedrooms and over here I can see my subject property has four. And this one has five.

So that means it’s got a little bump in price because it has an extra bedroom. So let’s pretend that I know something about this neighborhood. I do not. So I’m going to guess. But if you do know about the neighborhood or if you don’t know and you want to adjust for things like bedrooms and bathrooms in a particular neighborhood, you have resources. You can look at market stats for the neighborhood.

You contact your broker. You can contact a local appraiser. These are people that are good resources for this kind of information. So again, I am not the resource for this. So I’m picking a random number and that’s going to be ten thousand. I’m going to pretend that an extra bedroom in this neighborhood is worth ten thousand.

So to make this house price seem as if it was for a four bedroom, I’m knocking that ten thousand dollars off.

So now the price is based on as if it was like a four bedroom. And I’m going to do that for all my five bedrooms.

I’m going to take ten thousand off the sale price or the for sale price. And I’m going to just adjust for the fact that they have an extra bedroom. So that’s just the two. And now they’re priced as if they had a four bedroom like everything else. I could also do it for say, total square feet, maybe one house. Mine has three seventeen square feet. And most of these are pretty close, but maybe this one is two hundred less.

Maybe I think it needs to have an adjustment for being smaller. If it was the same size, it would be worth say two thousand dollars more. I am making these numbers up off the top of my head. I am not a realtor, so please don’t quote me on these numbers. It’s just for demonstration purposes. Okay? But here’s an adjustment. So I’ve done two different adjustments.

One for the number of bedrooms and now one for square feet. This is where your auto adjusts if you were to set that up in advance would work. And I can change my mind and go, you know what? I don’t know enough about this area. I’m going to remove all of this, but let’s keep going and pretend I know what I’m talking about. So here is where the adjustments for comparables.

This is the whole summary section and I can look at Autumn Drive and see that I took off ten thousand for that house. And you can have more than one adjustment for a house. Maybe this one had also three extra bathrooms and I would have subtracted for that. So whatever the total numbers are, you can see it for each of the comps. This one has no adjustments.

This one has no adjustments and you can go through the list just to kinda get a big picture of everything. Okay? So I’m gonna go to next step down here. Now I only picked There it goes. I can always choose the tab up here too. This one’s already finished crunching the numbers. That’s why I picked a small number.

If you have picked a lot of listings for the statistics on, it may take a moment for the next step to show up. So just be patient. Sometimes if you’re running a CMA for sixty listings, it’ll take a moment, but you’ll get it. And once you see that the next tab is available or this next step button is available, you know it’s done and you can move on.

So there’s that price analysis summary by status. Closed, pending and active. Here are the low average, median and high comparisons And the overall market analysis unadjusted. So it’s not using any of your adjustments. It’s just looking at the overall market analysis. You’ve got the average agent days on market, average cumulative days on market, price per total square feet in all the different statuses.

Next step.

Now there’s a recommendation. This one looks at the low and the high and gives you a recommended average in between. And this is for the sale prices.

So you can use this, calculate low high price using the high low price from comparables or you can click this calculate high low price using percentage above and below the recommended price. And you can choose to do that too. It’s whatever you like. If I wanted to do that, the recommended price currently is three hundred and twelve thousand five hundred.

I click recalculate and now these are gonna be two point five percent above and below that number. But I’m gonna go back here, click recalculate again, So it’s back where it was. And maybe I don’t like this price. Maybe I really think that this is a three hundred and nineteen thousand nine hundred and ninety nine dollars house. That’s the one I would recommend they start with.

You can change that. You can absolutely edit that. Now I’m gonna go to next step. You can also choose not to, you don’t have to edit that. Whatever you prefer. It is available. Now here is that finish tab. And basically, this is putting the report together. Do you want the cover page? All of these are optional.

One thing I do want to point out, some people like the street map, some people prefer the satellite map. It’s Google Maps. We use Google Maps in Flexmls. So you have your choice. Subject property description. Maybe you think that’s redundant, you don’t want to include it. It’s entirely up to you. I like this one, sort side by side comparison by status.

So all the actives are together, all the pendings are together and all the close are together. So I’m going to check that. Search parameters, some people want to include that, some don’t. And again, you have all these many, many options. Color scheme, there is default white.

Maybe I’m going to pick plum because I like purple or maybe it’s even a color that I use consistently through my marketing or maybe it’s my brokerages color, whatever you like.

Listing detail options, different information here. I think this is a key one. I’m gonna go ahead and do the full report. But I do wanna point out that you can, and of course, again, your MLS may have different options, but you could choose a flyer if you think you’d rather do that. Or perhaps a different report. Instead of the full report, you want the standard report.

Instead of the standard report, you want the detailed report. Whatever it may be. I’m going to go ahead with the default for this MLS, which is the full report. But you can see there’s even another Fargo full report. So whatever report you like, I’ll go with the default. And of course, you want it public.

You don’t want that listing agent information or those gate codes or anything like that included. So we can email this straight away. Save it. If you save the CMA, then you can adjust it and edit it later. And that would be in under the menu under CMA. It would be saved in the Flexmls system.

I can view it just here on my computer and I can download the PDF. So in this case, I wanna download it so that I can see what it looks like and then I will email it to my client.

And while that thinks about it, I already have it saved on my computer. So this is what it looks like. And again, there’s my color scheme and the address of the subject property prepared for MARC. And there’s the photo from the old MLS number. There’s my information and I wrote comments in comments. And this is the default disclaimer that’s in for this MLS. Next page.

If you notice, it’s twenty pages long and that’s only eight comps. Or actually in this one, nine. I ran this one earlier. But in any case, the map, I want to point out that everybody’s here with a number and a color based on the status and who they are. And they’re listed right here. You can see and then you can see again the status here and the distance from subject property right here.

Subject property is going to be this black push pin. So that’s a nice thing. Also, there is CMA prepared for Mark Watney by Anne O’Shea and here’s this address for the subject property. And at the bottom of each page is my contact information and what page number we’re on. Let’s go to the next. There’s that subject property description. Some people like to include this, some don’t.

It’s entirely up to you. Comparable properties. Now I sorted by status. So all the actives are going to show up first because it does it by alphabetical. So it’ll be active and then closed and then pending because it’s alphabetical. But always the subject properties in the first column so they can easily compare the information. And if you notice, this one had an adjustment that I made.

Now, if you didn’t make any adjustments, there wouldn’t be this column here in the second half. Okay.

Next page, more comps. These are closed and appending. And again, subject properties in that first column.

Here we are again. And again, you can see those adjustments.

Then you get into the price analysis. This line across, that is the you can see here low, high and recommended list price. So the low and the high, you can see my recommended, which is the dotted line here, is a little toward the high side. And they can see this is on closed listings, so they’ll just see those couple of closed listings here. That gives us that range.

And this also on closed listings, low average median and high sold price. Here’s all those numbers that we saw earlier, all the stats and the adjustments are here in a separate column. If you didn’t have adjustments, there would not be this column. And again, overall market analysis does not use the adjustments for those numbers.

Okay. Here’s the listing price recommendation. And my edited price is right here, three hundred and twenty thousand. Well, that’s what I did yesterday. I did in this one, three hundred and nineteen thousand nine hundred ninety nine dollars So whatever you can adjust it to, you can change it to.

And then this is that full report in the Fargo Moorhead MLS. This is what it looks like. And you may choose to do this or you may choose something that looks more like a flyer with a lot of information. It’s whatever is your preference.

But this gives me a report on each one of those comps so that the client can see. And on the ones I have an adjustment, it’s added to the bottom, which puts it over the edge so it’s on a separate page. But the comps are here and they can see what it is exactly for.

Okay. That’s it. That’s your full CMA. Pretty cool.

No, I’m not downloading that. That was taking too long. Thank you. So now, I promised to show you another way of doing it because what if you don’t have a subject property? So let’s go here to quick search again. Yes, I’m leaving the page. I did not save it. And I’m going back, just a quick search, which is here in my favorites. There it goes.

Now, this is for those that you don’t have an old MLS number and you just want to get things that are within a certain distance. So these info bubbles are always great. They give you lots of information. So I’m going to, just in case, this is how I check, put it in Quick Launch Bar.

I’m gonna get that address for my potential client, two one one four Sterling. And start typing in the address. Oops, helps if I could spell, no results found. And even when your Internet’s a little slow and it starts doing this, you can see that this is not what I was looking for. And there’s nothing in the MLS for this particular address. Not a problem.

So I just come over here what I’m going to do actually, before I go over there is I’m going to go ahead and pick my parameters as before, and I’m going to pick active, pending, and closed. And maybe this time, I’ll pick. I’m just going to start this so you don’t have to watch it again. Once we get past a certain point, it’s the same.

But I’m going to maybe pick sixty days and I’m down to seventeen hundred listings.

And again, you can always switch to a specific date. Maybe you want since January one for solds. Whatever works best for you. Come down here to subtype. This potential client has a single family residence.

And I know that they have four bedroom, so I’m going to do four to five. I could do three to five Bathrooms, I’ll do three to four. Whatever makes sense. Sometimes you can’t be so narrow. Sometimes you have to be more broad with your choices because you just don’t have enough comps to run your CMA. So whatever works.

Say their house is again around three thousand and we’ll do a bigger range on square feet. And that’s going to give me three thirty eight. Well, I don’t want oh, no. It just updated. Two thirty two. I don’t want to run a CMA for two thirty two listings. I know there’s some people that may, but in this case, I just want to get the ones that are near this property that is not in the MLS.

So I’m to come down here to the bottom right of your map and there’s this great push pin and I’m going to click on that. It’s great. This is where you do your radius search. And I’m going to put in the address two thousand one hundred fourteen Sterling Rose Lane. Now, we use Google Maps.

So the only criteria for this property to show up here is that it’s in you can find it on Google. So which pretty much covers everything. Not always, but sometimes. So most of the time. So I’m gonna click locate.

And we’re gonna wait for Google to find it. There it is. And I’m gonna say, yeah, I drove by and that does look like the right location. So I’m gonna go ahead and click use this location.

And it shows me the address and looks like it’s Lane South. Good to know. And I’m going to click on Radius Search. Now, the default is always one mile and I’m going to change this to one point nine. You change it to whatever you like. You could do zero point nine. You could do zero point three, whatever you like. But I’m going to pick one point nine and click create radius.

And everything turned blue, so I’m gonna close this because what happened is that it made a circle and the circle is blue and so everything is in it in the blue circle. Now this gives me thirty five results. I can adjust that. I can click on the circle and adjust the size if I like.

But in this case, let’s just jump up to the CMA. Again, I can look in the list.

Let’s just jump to the CMA up here in those action buttons. And I’m going to use all results.

And it’s going to take me here and what I’m going to have to do because there’s no old MLS number to use as a shortcut. And again, I’m doing the full CMA clicking next step. I’m going to have to manually input the information.

So I’m going to do this for my client as it loads. John Wayne. There it goes.

And again, I like using this always use the current date. It’s up to you. Of course, if you’re putting it out right away, you don’t need to do that. I’m going to skip the comments, click next step.

And this is where I’m going be on the subject tab and I’m going to have to input the information. So I’ll put in the two thousand one hundred fourteen Sterling Rose Lane South, and that’s Fargo, North Dakota, fifty eight thousand one hundred four. Because I couldn’t use the shortcut right here. So I’m putting it in here, but I also need to upload a photo if I want.

You don’t have to, I’m going to skip it. But I do need to put in things like they have four bedroom, three bath. I’ll put three thousand square feet. Lot dimensions, I’m going to skip. But maybe they have two point zero acres. Style, I’ll put two story. Year built.

Maybe I looked up the tax information or I found out from my potential client. Garage type attached. And again, I can take out a line. Maybe I don’t have the information. Just put the basics. Next step.

When you click the next step, it’s gonna geocode it just as if you were adding a listing.

And yes, I wanna use that location. I click yes.

So that way, it uses that for that map.

And you can see we have a lot of comps, And I’m going to come here to adjustments. And you can just continue on.

Yeah, we won’t wait. I could do adjustments or not.

Go to the summary and then go in and just The bottom line is that when you come out here to your CMA, I’ll put that on. I think that was page two.

That manually entered property would be right here. Okay. So you can do either way, either scenario with an old MLS number or without. Not a problem. Now, one other thing you may want to do with your seller, which can help you out quite a bit.

And it’s good for those sellers that really want to make sure that you have everything in perfectly, those kind of sellers. So let’s take a peek in the system. And I’m gonna go in and I can start adding a listing, just put the basic info in or I can go into my incompletes because maybe I already started this. And they said, you know what, can you show us what you’re putting in before you put it in?

Absolutely. So I can go to my incomplete or if you haven’t started it yet, you can start adding a listing and save it as incomplete. See how that looks. Put the basic information in, the address, and then you would just come up here and save incomplete. Well, let’s go back to my incomplete because that’s where they end up before you put them in the MLS, as you know.

And I’m going to come here to my incomplete listings, and I’m going to scroll down. And from right here, I can print your email. Or I can go in and edit. So you could do it from here or I’m going show you where it is in here if you’re in there editing and you realize you want more information from your client. So here I am in my incomplete, change and complete listing. And here is that button as well.

Print or email this listing. I need help. I need more information. So or it’s a client that wants to make sure I’ve got everything perfect. Let’s click on that. Print your email. This will help your many sellers. They’ll feel like they’ve got a little more control over the process perhaps.

So you have reports, generate a report of what you’ve already done. I would think for some printing the input form might be best.

And you can even include or not all those many field options. You know, in that detail tab when you’re adding a listing and you have fifty choices, you may not If you’re printing this out on actual paper, you may not want to print out all those choices or you can include them if you’re saving this as a PDF or you can email the input form.

Public version, private version, you can include a signature box and you can give it a title and font size. Maybe you want it to be a little easier to read for your client. Shows you that here how big it’ll be. It’ll need more pages if you were to print out, but that’s good. But let’s take a peek at the input form.

So I’m going to click on print input form.

And thanks to my fabulously fast Internet, I’m going to show you the one I already did. So this is that listing, my incomplete listing. Oh, it did pop up. That’s good. Incomplete listing, I’ve done the basics, the address, I saved incomplete. And now it’s basically a form that your client can fill in anything that they want to add or change to the information.

And particularly on page three and four, when you get into the details, maybe they want to point out, yes, I have a sunroom too, whatever it may be. Okay? Now, I did print out or save as a PDF the version that has all the options and you can see here you go. This is page five of ten. So instead of four pages, it’s ten pages.

And I can see these are all the high school’s square foot sources, master bedroom main floor, yes or no. Everything’s here. So it’s all printed out and then your client can just circle things or just let you know in some other way and you can then input the appropriate response into your listing.

Okay? So that’s very much a very long version. But again, it gives them all that information so that it can help you input accurate data into the MLS. So that’s a great thing. So all these are here and all I did to get here was to go into my incomplete or when you’re editing an incomplete listing.

So if you’re in here, you can do it from here or it could be in my incomplete at the bottom of that page as well. Now I’m going to switch over into the root account because I don’t have any actual listings. And I want to show you what a listing report looks like. Those are awesome. But that only works on real listings. So I’m going to switch over now to the root account in Fargo.

And I’m going to put in a listing that I know is currently active and has some activity so I can show you that listing report. And for some reason, this is not always very visible to agents. Here it is. Click on that.

There we go. And it’s funny because it is kinda hidden. So I just wanna make sure you’re aware of it because this is very popular with sellers. Absolutely. And what’s nice is that you can set up an automatic email, which is even better. So here is we’re pretending this is my listing. This is not my listing. This is a real active listing though, and I’m not going to touch or change anything in here.

But I want to point out, when you’re in your listing, you can come here to that little triangle. Let me zoom in. That little triangle next to your MLS number in your listing. Okay? Come right here. And if this is your listing, you may not have all these choices because I’m in the root account. So this is I’m super using as the MLS. But below Everybody does have this.

Below edit listing, because if you can edit this, you will have this listing activity choice. So I’m gonna click listing activity and it’s really cool. So it gives you the activity for the address. You can pick a date range. I will point out that there are certain things in here where it’ll tell you maximum ninety days, but you can pick a date range.

Maybe I wanna pick just since January, Just the information since then. So that’s not ninety days, but I just want to look at that information. And one thing I want to point out, you can print, you can email to your seller and you can set up auto emails, which is again very popular with agents. So here’s your listing basic information, very basic. This is showing where people are viewing this listing.

One hundred and forty nine people have looked at this listing in FlexMOS since January one. FlexMOS IDX, that would be an agent’s website somewhere, forty six people.

Twenty two people have been emailed this listing and usually due to a subscription or possibly could be just a one off from an agent saying, hey, out this listing. Could be either one of those kinds of emails and then the portal. And that’s typically, of course, those saved searches that your client accesses through their app, which accesses their portal. And here’s more information. How do people rate this listing?

No agents have recommended this to their clients since January one, but two people have saved this listing. Three people have hidden it, so it’s not their cup of tea and no agent has hidden it thinking that their agent wouldn’t care for it. Down here, this is just the same. This is the pie graph version of this above it. So again, you can see sometimes that’s easier for people to look at.

Just depends how your brain works. We’ve got it all though, so you can see it both ways. And again, the rating up here, you can see it down here in pie form. That may help your seller just visualize. Actions people took. Now the max is ninety days, but in this case, we only went back to January one and this listing was shared by someone twice.

So some client was in their portal and they shared this listing. So that’s pretty cool. If there was somebody clicking on it to contact the agent or gave feedback or something else, if there’s something else going on, this is what you would see. And I find this very interesting. People who save this listing also saved these. So this is cool because basically you can see the competition.

That might help you convince a seller that maybe their price is a little high and should be brought down because look at the competition. Or same also with people that are viewing their property also viewed these. And you may want to pull some of these listings and send a public report to your seller saying, hey, this is your competition. We may want to bump the price down or we may want to bump the price up.

Whatever you as the professional recommend. But this just gives you great information. So print, fabulous. Email, also fabulous. Auto email, Extra great, right? So in here, I can send activity reports automatically by email for this MLS number. And I can send it to whomever. So I can send it to say Dave Rocks.

And I’m going to send it to Dave weekly on Mondays or maybe weekly on Wednesdays. You don’t have a huge choice in time frames, but usually weekly on a certain day is sufficient or monthly. Do monthly and then pick what day of the month it’s going out. So that’s nice. I would think most sellers are going want it weekly, but you guys know your clients better than I.

And then I can get cc’d as the agent. I can get cc’d and get those emails as well, which might be really helpful. And it says down here, auto emails will not be sent if this listing is sold, canceled or expired. So they’ll keep getting them while this listing is in some form of active. And just click save and you’ll set that up. Fabulous.

So again, you have two ways to do that full CMA. One using the shortcut of finding an old MLS number or one where you input all the information. You can use a radius search or you can use another map tool. You can send those listing reports, listing activity reports to your seller once it’s in the MLS.

And to get it into the MLS perfectly so that your seller’s happy and all the information’s in there to get the most exposure and the most information out to the other agents and their clients, you have that report that you can have them look at and help you input all the information about their listing.

So printing out an incomplete listing or emailing it to your client and having them add, oh, yeah, we forgot we have also a sunroom or probably not something like that, but they can that will help nudge them to add everything that is available. So that is everything I was going to cover today.

Right at time, let me take a peek and see if there’s anything from my team saying that I need to cover.

Looks good. Sounds like all questions have been addressed. Thank you so much for joining me. I hope you all have a great rest of your day.

Anne

Anne joined FBS early 2020 as a member of the CPR team after being an MLS Director for several years in Southern California. She enjoys training agents so they can be both more efficient and comfortable working within Flexmls. Outside of work, she is a Movie Lover and Science Geek who loves to travel, read Murder Mysteries, and play games of all kinds.

Welcome everyone. My name is Anne O’Shea and I am your Flexmls trainer today. And today’s webinar is called Working with Sellers.

Before we begin, we are using GoToWebinar and should you have any trouble, first be aware that we are recording this and you will get a copy of this recording in an email around this time tomorrow. So if you have to step away because of a client call or your dog or whatever, you can do that easily. Not a problem, you’ll get the recording tomorrow.

If you’re having any trouble with GoToWebinar, you can try going to the help menu at the top. You can also sometimes with audio issues, if you’re having any audio issues, you can use the phone call, which gives you a phone number and personal pin. So you can call in on the phone for the audio and watch on the computer for the visual.

If you can hear me but you can’t see my screen, then I would try restarting GoToWebinar.

And again, if you’re having a bad connection, need to leave early, anything, approximately twenty four hours, so not to worry.

If you’re not having any issues, which most of you hopefully are not and most likely are not, We have the questions pane available where you can type in your questions. And both Josh and Amy, my fellow trainers are gonna be answering questions throughout. So you can always type in a question there and they’ll be able to answer you.

So today’s topics. Seems like a short list, but we’re going go into it quite a bit. But these are really the things that in the FlexMLOS system that you’re going to most likely use with your seller. So we’re going to get into the full CMA. I’ll also point out some other CMA options you have. But typically, the full CMA is what you’re going to want to use for your sellers. I’m also going to show you how to print or email an incomplete listing.

And then there are these great listing reports a lot of people seem to miss that are available that you can share with your seller and even set up a regular email to them. So very handy. I’ll show you how to do all of that. So let’s begin.

So here I am in the Fargo Moorhead MLS. And this is our typical demo MLS for these general webinars that go out to the entire Flexmls family. So if it looks a little different than your MLS, sometimes property types or something is different, not to worry. All these features I’m going over, you still have the ability to do in your MLS.

It’ll just look a little different. So at the top of course we have Flexmls and right next to it is this quick launch bar.

In the case of Let’s see. How best to start? We’re going to jump into a full CMA, but there are two scenarios that you may have. You may have one scenario where you have an old MLS number that is for that particular property that these potential clients are currently living in that want to sell. And that will save you some steps. So I’m going show you that little shortcut.

But I’ll also show you how to do just a radius search around a property that’s never been in the MLS before So you can do the CMA that way. So there’s two ways to attack that full CMA.

And again, this all may look a little different because I’m in the Fargo Moorhead MLS, but you can still do this where you live. So we’re going to jump into QuickSearch. Come on, QuickSearch. Wake up. There we go.

There we go. Good.

My Internet has slowed down, I apologize. It’ll catch up, I’m sure.

So like I said, maybe this listing was once in the MLS. This address was once in the MLS. So before getting all the way into quick search, I’m gonna come up here to the quick launch bar and put in my potential client’s address just to see has it been in the MLS before. So I’m just gonna put in four thousand thirty two Copperfield.

And I just start typing in their address and I can see their two previous listings with Copperfield Court. And I love this little thing here, new tab, click on new tab.

And I’m gonna get right into that listing. And the key thing when you pull up an old listing for a property is you wanna make sure that you’re looking at the most recent version. I apologize, my internet was working perfectly a half an hour ago. It’s just slowed down, something turned on somewhere. But I’ll still talk plenty over these little gaps in the visual, so don’t worry.

Here’s my old MLS number for this address. And I can see the little mini map and that looks like the proper place that I met them or I’m going to meet them, etcetera. When I look up an MLS number, jumps right in here and it puts me in the detail tab, which you can see here on the right. And I wanna point out the history.

So I’m gonna click on history because it’s gonna show me past listings for this address. And I’m gonna always want the most recent, which I happen to be in. The seventy four thousand five hundred seventy seven. And again, your MLS may have a different numbering system but you always want the most recent because maybe there was a bathroom added between the first listing and the second or something like that. So you want the most recent.

So I’m just gonna copy this MLS number. Actually, I’m just going to jot it down. Seven-four thousand five hundred and seventy seven.

And actually, I’ll leave this tab up and open so it’s handy. Click on here. And now I’m going to if you don’t know anything about the house, of course, can come over here and look at the listing on the report here, which we were just in. And I’ll see that it’s Again, my apologies. I know that it is four bedroom, three bath.

So I can see that in the old listing. And of course, if they tell me differently, I can adjust.

But I’m gonna do my typical CMA quick search, which would be active pending and closed listings. So obviously, don’t want to do a CMA on seven thirty three listings. So let’s come down here to status and I’m going to click. In this MLS it defaults to active. I’m also gonna click on pending and close.

I’m a PC user, so I’m gonna hold down my control button to select more than one thing. For you Mac users, that would be a command button. And now I have twelve hundred oh, it jumped again. It’s constantly updating six thousand listings. And this MLS defaults one year back. You can see all these little arrows here to the left of that and I’ll zoom in a bit.

That gives me a change of date type. So you can pick a specific date, maybe you wanna do it since April first of last year. Whatever your scenario is, but I’m just going to pick thirty days back. So I’m going to change this from a whole year to thirty days back. And if I wanted to, I can even click on days.

You’ll see that it’s underlined and I can click and make it a month because my little cursor turns into my hand when I’m over there. So thirty months back, click it again, it’s thirty years. And again, thirty days.

And again, we’re trying to look for comps for this particular property. So I want to get I’m just going to look at single families And bedrooms, I’ll pick, say I don’t know if I wanna pick exactly theirs. I’ll pick maybe four to five. They have a four bedrooms. Oops. Four to five and they have a three bath.

So maybe I’ll pick three to four and see what I come up with. I’m down to three twenty six results. So I want to still narrow the field. I’ll use total square feet. There’s is a little over three thousand. So I’ll pick a range, maybe two thousand eight hundred to three thousand two hundred. And you can adjust all these numbers.

If you’re not in city limits, you may need to do a longer timeframe or you may wanna do a bigger range of square feet. Whatever it is to give you an appropriate number of response results. So I can see that these are all over on the map, all over town.

And I want to just narrow the field into that general neighborhood. I know that they’re in this area. So I’m going to come down here to one of my map tools and I’m just going to use the simple rectangle this time.

You can get very detailed and just go over specific outlines with the other tools, maybe just a specific builders tracked. You want to outline every single thing. I could certainly do that using the polygon tool, but right now I’m just going to use the rectangle. And let’s see what we’ve got. I’ve got nine results. So I’m going to come up here to the list and take a peek.

There they are. And now I like to sort them by price myself. You might want to sort them by maybe something else, maybe by bedrooms or bathrooms or square feet, whatever it is. I find it a little easier to sort it here, but it’s total preference. You can certainly sort them in the CMA and I’ll show you how to do that. But today, I’m just going to sort by price here.

I’m going to do descending and I’m going to just do it here in the search rather than in the CMA. And I like to see that nothing’s completely off the deep end. I can actually come in here and select them all and say, you know what, I happen to know that this pending, this house has very little to do with this. It’s not an appropriate Or maybe it’s this one, not an appropriate comp.

So I would just take that out of the list. So now I have nine results and eight selected. And I’m gonna come up here to these action buttons up here that you use all the time, email, save and print. Right there next to it is CMA. I’m gonna click on CMA. And here you can see I can use all results, so I can still change my mind and use all nine. I can use selected, which is those eight.

And here’s even your one line CMA for those of you that would like to do just a quick and dirty one line, just the facts, just the stats. But I’m going to come in here, get into that full CMA. I’m going to use the selected.

And here I am. So as you can see, I’m in the create the CMA window and right here, I want to point out something new. This is a guided help, which you have up here. Guided help, which will walk you through the process of CMAs. And it’s fabulous because it’s like having a support staff looking over your shoulder and pointing at things to click on.

But I just want to point it out there for you.

And the first step we have is to choose what type of CMA. You have quick CMA, which you don’t even need subject property for, just maybe for This is more for buyers that are looking at a particular neighborhood, say. Statistical, that’s where again those number crunchers, maybe your client is an accountant and that’s all they want. There you go. You get lots of information right there.

And there’s even a particular type of statistical CMA in there for you appraisers out there. But we’re going to do the default, which is that full CMA today. And you can even say it’s useful for sellers and includes options for cover page and many other things. So let’s jump in. Now select statistical type. This one, the statistical average field is based on square feet.

So the price per square feet is what’s used here in this MLS for overall statistical analysis. If some MLSs, some scenarios, there’ll be other options, but this one’s just square feet and we’re just gonna leave it as is and take the next step.

I’m gonna close this just to help my bandwidth a little bit. Okay, here we are, cover page information. Now you don’t even have to do a cover page, but I’m going to go ahead and do one. So I’m going to say this is for my client, Mark Watney. I already typed his name in so he was there, but you can just type in whomever.

I can do today’s date or this is a cool feature, always use current date. So maybe I’m going to start this, but I end up not emailing it or printing it until tomorrow or the next day. This will make sure that it’s always got the current date. So whatever day that I actually finish and send it off, it will have whatever that date is. And I’ll just use my name here.

If you have custom business cards in the system, you could choose a different one. But most of us just have a default, which is fabulous. It has all our current information. Comments optional, but I’ll type in comments. Maybe you want to tell them your experience selling in their neighborhood or how thrilled you are to potentially work with them, whatever it may be.

Put that here. And you have three thousand characters max. Put whatever you like.

Next step down here, subject property. Well, as I said before, you may not have a subject property from the MLS. But in this case, I have that old MLS number. So I’m going to use this shortcut of auto populate fields from an existing listing.

And I’m going type in that listing number seven-four thousand five hundred and seventy seven. And it’s from the Fargo Moorhead Association Realtors and I’m going to click Submit.

And that’s going to auto populate all the information from that listing in here. So I don’t have to do it manually. You can do it manually, but this saves you a couple of steps. So it’s worth taking a peek to see if you can find it. Now, it also includes the photo from that old listing and that’s fourteen years ago now. So you may want to upload a new photo.

You could remove the photo because maybe they painted and you don’t have a current photo to replace it with. You can just remove it altogether or upload an updated something. It’s up to you. In this case, I’ll just keep the one that came with it from the old listing. Now it auto filled this in and I can adjust. Maybe I can even create templates. If you run CMAs all the time, you may want to have a favorite template where you include certain things.

Like maybe you don’t want to include lot acres or you do want to include but not lot size dimensions. Whatever it is, you could customize. Another wonderful thing about Flexmls, you can customize so many things so that once you get it set up, it just makes your life easier. But in this case, I’m just going to leave it as is. This is the default that comes from the MLS.

If I hadn’t made it custom, I would just choose it here out of the dropdown. Very easy to use. If you notice, I have no lot acres information. So I’m just gonna come over here and delete that with the big red x.

And maybe I prefer that the garage type, is attached, be up here by the style. So I’m going to click on the gray arrows.

And now I have the blue arrows and I can bump this up one level. So now it’s below style. I like that where it is. And I’m gonna click next step.

So here we have our comparables. Now, I wanna point out that what if you’re like, uh-oh, maybe I need to go back and find some more comps. You could certainly do that. It’s here. Return to search results is right there. But I have them all here and they’re all in the order that they came by status. They are supported by price, which is what I did when I was in my search results.

But what’s nice is that here, I can still remove things, map things, report a location, and I can move things around. Maybe I want this one up next for whatever reason, or I can remove something at this point if I like. But also there’s this little thing here that says edit sold price for this listing. Perhaps there was a bonus involved and perhaps your MLS doesn’t include that in the sale price.

Whatever the application may be, you have that at your fingertips. You also have here, you could add other comparables.

Maybe you want to use the comparable that was not in those search results, but it’s a house that’s very similar, maybe it’s a few blocks over. You want to throw that in. You can put in that MLS number right here. If I had a listing collection that I put together of things that I wanted to throw into my CMA for this client, I can throw them in here very easily.

I can find another quick search results and throw them in, find more comps. But I’m not gonna do that today. I do wanna point out also you have Those are all MLS comparables. And here is the non MLS comparables.

So I’m gonna click on that and I can over here create a new comparable. So maybe there’s a FSBO in the area that I wanna include. You can do that for sale by owner. You can put that information in here manually. Again, I’m not going to do that today, but you have this all at your fingertips.

So what else? Let me just take a peek. Make sure there’s nothing. Okay. Good. I thought I got a message from one of my co trainers, but we’re good. Okay. So here we are on the Comps tab and say we like where everything is. We want to keep them all.

I can still come in here and deselect something and only use the selected. Again, we give you lots of choices, a lot of time to change your mind, change things up, add things. But I’m gonna take the next step. Now, you notice, next step is here as I’ve been clicking on. But you also have this tab. The other tabs we’re not quite ready for, so they’re still grayed out. But can always click the next tab here.

So you have two places to click. So I’ll click on adjustments.

Now, adjustments. This is a tab that a lot of people just skip. You do not have to do this tab at all. This is for those that really know the neighborhood or really want to make sure to adjust prices based on some feature.

And your fields that your address that we had in that first step are all here. And these are all the different addresses here. And I can adjust them by address. Maybe a certain street, maybe Autumn Drive is worth always ten thousand more. Any house there is always ten thousand, you you can say even overpriced because of that street.

Maybe it’s a really pretty street or something. I can make adjustments. So let’s do the typical, which is like bedrooms and bathrooms. Of course, in this case, all my comps all have the same bathroom. So we’re not adjusting there. But I am going to do some adjustments on the bedrooms. And again, this can be confusing. Some people don’t like to do this.

There is some great help. And I do want to point this out. Wherever you are in the system, you have help with this page. And this really goes into some details about how you can create manual adjustments, which is what I’m going to show you today. You can also set up auto adjustments and there’s even predefined adjustments that you can do and open this page in a new tab and learn all about it at your convenience.

I’m close that for now. And I’ll just show you this basic adjustment where my subject property here at the top has four bedrooms. And this is four bedrooms because I came over here and selected out of here. Four bedroom. I picked total bedrooms and over here I can see my subject property has four. And this one has five.

So that means it’s got a little bump in price because it has an extra bedroom. So let’s pretend that I know something about this neighborhood. I do not. So I’m going to guess. But if you do know about the neighborhood or if you don’t know and you want to adjust for things like bedrooms and bathrooms in a particular neighborhood, you have resources. You can look at market stats for the neighborhood.

You contact your broker. You can contact a local appraiser. These are people that are good resources for this kind of information. So again, I am not the resource for this. So I’m picking a random number and that’s going to be ten thousand. I’m going to pretend that an extra bedroom in this neighborhood is worth ten thousand.

So to make this house price seem as if it was for a four bedroom, I’m knocking that ten thousand dollars off.

So now the price is based on as if it was like a four bedroom. And I’m going to do that for all my five bedrooms.

I’m going to take ten thousand off the sale price or the for sale price. And I’m going to just adjust for the fact that they have an extra bedroom. So that’s just the two. And now they’re priced as if they had a four bedroom like everything else. I could also do it for say, total square feet, maybe one house. Mine has three seventeen square feet. And most of these are pretty close, but maybe this one is two hundred less.

Maybe I think it needs to have an adjustment for being smaller. If it was the same size, it would be worth say two thousand dollars more. I am making these numbers up off the top of my head. I am not a realtor, so please don’t quote me on these numbers. It’s just for demonstration purposes. Okay? But here’s an adjustment. So I’ve done two different adjustments.

One for the number of bedrooms and now one for square feet. This is where your auto adjusts if you were to set that up in advance would work. And I can change my mind and go, you know what? I don’t know enough about this area. I’m going to remove all of this, but let’s keep going and pretend I know what I’m talking about. So here is where the adjustments for comparables.

This is the whole summary section and I can look at Autumn Drive and see that I took off ten thousand for that house. And you can have more than one adjustment for a house. Maybe this one had also three extra bathrooms and I would have subtracted for that. So whatever the total numbers are, you can see it for each of the comps. This one has no adjustments.

This one has no adjustments and you can go through the list just to kinda get a big picture of everything. Okay? So I’m gonna go to next step down here. Now I only picked There it goes. I can always choose the tab up here too. This one’s already finished crunching the numbers. That’s why I picked a small number.

If you have picked a lot of listings for the statistics on, it may take a moment for the next step to show up. So just be patient. Sometimes if you’re running a CMA for sixty listings, it’ll take a moment, but you’ll get it. And once you see that the next tab is available or this next step button is available, you know it’s done and you can move on.

So there’s that price analysis summary by status. Closed, pending and active. Here are the low average, median and high comparisons And the overall market analysis unadjusted. So it’s not using any of your adjustments. It’s just looking at the overall market analysis. You’ve got the average agent days on market, average cumulative days on market, price per total square feet in all the different statuses.

Next step.

Now there’s a recommendation. This one looks at the low and the high and gives you a recommended average in between. And this is for the sale prices.

So you can use this, calculate low high price using the high low price from comparables or you can click this calculate high low price using percentage above and below the recommended price. And you can choose to do that too. It’s whatever you like. If I wanted to do that, the recommended price currently is three hundred and twelve thousand five hundred.

I click recalculate and now these are gonna be two point five percent above and below that number. But I’m gonna go back here, click recalculate again, So it’s back where it was. And maybe I don’t like this price. Maybe I really think that this is a three hundred and nineteen thousand nine hundred and ninety nine dollars house. That’s the one I would recommend they start with.

You can change that. You can absolutely edit that. Now I’m gonna go to next step. You can also choose not to, you don’t have to edit that. Whatever you prefer. It is available. Now here is that finish tab. And basically, this is putting the report together. Do you want the cover page? All of these are optional.

One thing I do want to point out, some people like the street map, some people prefer the satellite map. It’s Google Maps. We use Google Maps in Flexmls. So you have your choice. Subject property description. Maybe you think that’s redundant, you don’t want to include it. It’s entirely up to you. I like this one, sort side by side comparison by status.

So all the actives are together, all the pendings are together and all the close are together. So I’m going to check that. Search parameters, some people want to include that, some don’t. And again, you have all these many, many options. Color scheme, there is default white.

Maybe I’m going to pick plum because I like purple or maybe it’s even a color that I use consistently through my marketing or maybe it’s my brokerages color, whatever you like.

Listing detail options, different information here. I think this is a key one. I’m gonna go ahead and do the full report. But I do wanna point out that you can, and of course, again, your MLS may have different options, but you could choose a flyer if you think you’d rather do that. Or perhaps a different report. Instead of the full report, you want the standard report.

Instead of the standard report, you want the detailed report. Whatever it may be. I’m going to go ahead with the default for this MLS, which is the full report. But you can see there’s even another Fargo full report. So whatever report you like, I’ll go with the default. And of course, you want it public.

You don’t want that listing agent information or those gate codes or anything like that included. So we can email this straight away. Save it. If you save the CMA, then you can adjust it and edit it later. And that would be in under the menu under CMA. It would be saved in the Flexmls system.

I can view it just here on my computer and I can download the PDF. So in this case, I wanna download it so that I can see what it looks like and then I will email it to my client.

And while that thinks about it, I already have it saved on my computer. So this is what it looks like. And again, there’s my color scheme and the address of the subject property prepared for MARC. And there’s the photo from the old MLS number. There’s my information and I wrote comments in comments. And this is the default disclaimer that’s in for this MLS. Next page.

If you notice, it’s twenty pages long and that’s only eight comps. Or actually in this one, nine. I ran this one earlier. But in any case, the map, I want to point out that everybody’s here with a number and a color based on the status and who they are. And they’re listed right here. You can see and then you can see again the status here and the distance from subject property right here.

Subject property is going to be this black push pin. So that’s a nice thing. Also, there is CMA prepared for Mark Watney by Anne O’Shea and here’s this address for the subject property. And at the bottom of each page is my contact information and what page number we’re on. Let’s go to the next. There’s that subject property description. Some people like to include this, some don’t.

It’s entirely up to you. Comparable properties. Now I sorted by status. So all the actives are going to show up first because it does it by alphabetical. So it’ll be active and then closed and then pending because it’s alphabetical. But always the subject properties in the first column so they can easily compare the information. And if you notice, this one had an adjustment that I made.

Now, if you didn’t make any adjustments, there wouldn’t be this column here in the second half. Okay.

Next page, more comps. These are closed and appending. And again, subject properties in that first column.

Here we are again. And again, you can see those adjustments.

Then you get into the price analysis. This line across, that is the you can see here low, high and recommended list price. So the low and the high, you can see my recommended, which is the dotted line here, is a little toward the high side. And they can see this is on closed listings, so they’ll just see those couple of closed listings here. That gives us that range.

And this also on closed listings, low average median and high sold price. Here’s all those numbers that we saw earlier, all the stats and the adjustments are here in a separate column. If you didn’t have adjustments, there would not be this column. And again, overall market analysis does not use the adjustments for those numbers.

Okay. Here’s the listing price recommendation. And my edited price is right here, three hundred and twenty thousand. Well, that’s what I did yesterday. I did in this one, three hundred and nineteen thousand nine hundred ninety nine dollars So whatever you can adjust it to, you can change it to.

And then this is that full report in the Fargo Moorhead MLS. This is what it looks like. And you may choose to do this or you may choose something that looks more like a flyer with a lot of information. It’s whatever is your preference.

But this gives me a report on each one of those comps so that the client can see. And on the ones I have an adjustment, it’s added to the bottom, which puts it over the edge so it’s on a separate page. But the comps are here and they can see what it is exactly for.

Okay. That’s it. That’s your full CMA. Pretty cool.

No, I’m not downloading that. That was taking too long. Thank you. So now, I promised to show you another way of doing it because what if you don’t have a subject property? So let’s go here to quick search again. Yes, I’m leaving the page. I did not save it. And I’m going back, just a quick search, which is here in my favorites. There it goes.

Now, this is for those that you don’t have an old MLS number and you just want to get things that are within a certain distance. So these info bubbles are always great. They give you lots of information. So I’m going to, just in case, this is how I check, put it in Quick Launch Bar.

I’m gonna get that address for my potential client, two one one four Sterling. And start typing in the address. Oops, helps if I could spell, no results found. And even when your Internet’s a little slow and it starts doing this, you can see that this is not what I was looking for. And there’s nothing in the MLS for this particular address. Not a problem.

So I just come over here what I’m going to do actually, before I go over there is I’m going to go ahead and pick my parameters as before, and I’m going to pick active, pending, and closed. And maybe this time, I’ll pick. I’m just going to start this so you don’t have to watch it again. Once we get past a certain point, it’s the same.

But I’m going to maybe pick sixty days and I’m down to seventeen hundred listings.

And again, you can always switch to a specific date. Maybe you want since January one for solds. Whatever works best for you. Come down here to subtype. This potential client has a single family residence.

And I know that they have four bedroom, so I’m going to do four to five. I could do three to five Bathrooms, I’ll do three to four. Whatever makes sense. Sometimes you can’t be so narrow. Sometimes you have to be more broad with your choices because you just don’t have enough comps to run your CMA. So whatever works.

Say their house is again around three thousand and we’ll do a bigger range on square feet. And that’s going to give me three thirty eight. Well, I don’t want oh, no. It just updated. Two thirty two. I don’t want to run a CMA for two thirty two listings. I know there’s some people that may, but in this case, I just want to get the ones that are near this property that is not in the MLS.

So I’m to come down here to the bottom right of your map and there’s this great push pin and I’m going to click on that. It’s great. This is where you do your radius search. And I’m going to put in the address two thousand one hundred fourteen Sterling Rose Lane. Now, we use Google Maps.

So the only criteria for this property to show up here is that it’s in you can find it on Google. So which pretty much covers everything. Not always, but sometimes. So most of the time. So I’m gonna click locate.

And we’re gonna wait for Google to find it. There it is. And I’m gonna say, yeah, I drove by and that does look like the right location. So I’m gonna go ahead and click use this location.

And it shows me the address and looks like it’s Lane South. Good to know. And I’m going to click on Radius Search. Now, the default is always one mile and I’m going to change this to one point nine. You change it to whatever you like. You could do zero point nine. You could do zero point three, whatever you like. But I’m going to pick one point nine and click create radius.

And everything turned blue, so I’m gonna close this because what happened is that it made a circle and the circle is blue and so everything is in it in the blue circle. Now this gives me thirty five results. I can adjust that. I can click on the circle and adjust the size if I like.

But in this case, let’s just jump up to the CMA. Again, I can look in the list.

Let’s just jump to the CMA up here in those action buttons. And I’m going to use all results.

And it’s going to take me here and what I’m going to have to do because there’s no old MLS number to use as a shortcut. And again, I’m doing the full CMA clicking next step. I’m going to have to manually input the information.

So I’m going to do this for my client as it loads. John Wayne. There it goes.

And again, I like using this always use the current date. It’s up to you. Of course, if you’re putting it out right away, you don’t need to do that. I’m going to skip the comments, click next step.

And this is where I’m going be on the subject tab and I’m going to have to input the information. So I’ll put in the two thousand one hundred fourteen Sterling Rose Lane South, and that’s Fargo, North Dakota, fifty eight thousand one hundred four. Because I couldn’t use the shortcut right here. So I’m putting it in here, but I also need to upload a photo if I want.

You don’t have to, I’m going to skip it. But I do need to put in things like they have four bedroom, three bath. I’ll put three thousand square feet. Lot dimensions, I’m going to skip. But maybe they have two point zero acres. Style, I’ll put two story. Year built.

Maybe I looked up the tax information or I found out from my potential client. Garage type attached. And again, I can take out a line. Maybe I don’t have the information. Just put the basics. Next step.

When you click the next step, it’s gonna geocode it just as if you were adding a listing.

And yes, I wanna use that location. I click yes.

So that way, it uses that for that map.

And you can see we have a lot of comps, And I’m going to come here to adjustments. And you can just continue on.

Yeah, we won’t wait. I could do adjustments or not.

Go to the summary and then go in and just The bottom line is that when you come out here to your CMA, I’ll put that on. I think that was page two.

That manually entered property would be right here. Okay. So you can do either way, either scenario with an old MLS number or without. Not a problem. Now, one other thing you may want to do with your seller, which can help you out quite a bit.

And it’s good for those sellers that really want to make sure that you have everything in perfectly, those kind of sellers. So let’s take a peek in the system. And I’m gonna go in and I can start adding a listing, just put the basic info in or I can go into my incompletes because maybe I already started this. And they said, you know what, can you show us what you’re putting in before you put it in?

Absolutely. So I can go to my incomplete or if you haven’t started it yet, you can start adding a listing and save it as incomplete. See how that looks. Put the basic information in, the address, and then you would just come up here and save incomplete. Well, let’s go back to my incomplete because that’s where they end up before you put them in the MLS, as you know.

And I’m going to come here to my incomplete listings, and I’m going to scroll down. And from right here, I can print your email. Or I can go in and edit. So you could do it from here or I’m going show you where it is in here if you’re in there editing and you realize you want more information from your client. So here I am in my incomplete, change and complete listing. And here is that button as well.

Print or email this listing. I need help. I need more information. So or it’s a client that wants to make sure I’ve got everything perfect. Let’s click on that. Print your email. This will help your many sellers. They’ll feel like they’ve got a little more control over the process perhaps.

So you have reports, generate a report of what you’ve already done. I would think for some printing the input form might be best.

And you can even include or not all those many field options. You know, in that detail tab when you’re adding a listing and you have fifty choices, you may not If you’re printing this out on actual paper, you may not want to print out all those choices or you can include them if you’re saving this as a PDF or you can email the input form.

Public version, private version, you can include a signature box and you can give it a title and font size. Maybe you want it to be a little easier to read for your client. Shows you that here how big it’ll be. It’ll need more pages if you were to print out, but that’s good. But let’s take a peek at the input form.

So I’m going to click on print input form.

And thanks to my fabulously fast Internet, I’m going to show you the one I already did. So this is that listing, my incomplete listing. Oh, it did pop up. That’s good. Incomplete listing, I’ve done the basics, the address, I saved incomplete. And now it’s basically a form that your client can fill in anything that they want to add or change to the information.

And particularly on page three and four, when you get into the details, maybe they want to point out, yes, I have a sunroom too, whatever it may be. Okay? Now, I did print out or save as a PDF the version that has all the options and you can see here you go. This is page five of ten. So instead of four pages, it’s ten pages.

And I can see these are all the high school’s square foot sources, master bedroom main floor, yes or no. Everything’s here. So it’s all printed out and then your client can just circle things or just let you know in some other way and you can then input the appropriate response into your listing.

Okay? So that’s very much a very long version. But again, it gives them all that information so that it can help you input accurate data into the MLS. So that’s a great thing. So all these are here and all I did to get here was to go into my incomplete or when you’re editing an incomplete listing.

So if you’re in here, you can do it from here or it could be in my incomplete at the bottom of that page as well. Now I’m going to switch over into the root account because I don’t have any actual listings. And I want to show you what a listing report looks like. Those are awesome. But that only works on real listings. So I’m going to switch over now to the root account in Fargo.

And I’m going to put in a listing that I know is currently active and has some activity so I can show you that listing report. And for some reason, this is not always very visible to agents. Here it is. Click on that.

There we go. And it’s funny because it is kinda hidden. So I just wanna make sure you’re aware of it because this is very popular with sellers. Absolutely. And what’s nice is that you can set up an automatic email, which is even better. So here is we’re pretending this is my listing. This is not my listing. This is a real active listing though, and I’m not going to touch or change anything in here.

But I want to point out, when you’re in your listing, you can come here to that little triangle. Let me zoom in. That little triangle next to your MLS number in your listing. Okay? Come right here. And if this is your listing, you may not have all these choices because I’m in the root account. So this is I’m super using as the MLS. But below Everybody does have this.

Below edit listing, because if you can edit this, you will have this listing activity choice. So I’m gonna click listing activity and it’s really cool. So it gives you the activity for the address. You can pick a date range. I will point out that there are certain things in here where it’ll tell you maximum ninety days, but you can pick a date range.

Maybe I wanna pick just since January, Just the information since then. So that’s not ninety days, but I just want to look at that information. And one thing I want to point out, you can print, you can email to your seller and you can set up auto emails, which is again very popular with agents. So here’s your listing basic information, very basic. This is showing where people are viewing this listing.

One hundred and forty nine people have looked at this listing in FlexMOS since January one. FlexMOS IDX, that would be an agent’s website somewhere, forty six people.

Twenty two people have been emailed this listing and usually due to a subscription or possibly could be just a one off from an agent saying, hey, out this listing. Could be either one of those kinds of emails and then the portal. And that’s typically, of course, those saved searches that your client accesses through their app, which accesses their portal. And here’s more information. How do people rate this listing?

No agents have recommended this to their clients since January one, but two people have saved this listing. Three people have hidden it, so it’s not their cup of tea and no agent has hidden it thinking that their agent wouldn’t care for it. Down here, this is just the same. This is the pie graph version of this above it. So again, you can see sometimes that’s easier for people to look at.

Just depends how your brain works. We’ve got it all though, so you can see it both ways. And again, the rating up here, you can see it down here in pie form. That may help your seller just visualize. Actions people took. Now the max is ninety days, but in this case, we only went back to January one and this listing was shared by someone twice.

So some client was in their portal and they shared this listing. So that’s pretty cool. If there was somebody clicking on it to contact the agent or gave feedback or something else, if there’s something else going on, this is what you would see. And I find this very interesting. People who save this listing also saved these. So this is cool because basically you can see the competition.

That might help you convince a seller that maybe their price is a little high and should be brought down because look at the competition. Or same also with people that are viewing their property also viewed these. And you may want to pull some of these listings and send a public report to your seller saying, hey, this is your competition. We may want to bump the price down or we may want to bump the price up.

Whatever you as the professional recommend. But this just gives you great information. So print, fabulous. Email, also fabulous. Auto email, Extra great, right? So in here, I can send activity reports automatically by email for this MLS number. And I can send it to whomever. So I can send it to say Dave Rocks.

And I’m going to send it to Dave weekly on Mondays or maybe weekly on Wednesdays. You don’t have a huge choice in time frames, but usually weekly on a certain day is sufficient or monthly. Do monthly and then pick what day of the month it’s going out. So that’s nice. I would think most sellers are going want it weekly, but you guys know your clients better than I.

And then I can get cc’d as the agent. I can get cc’d and get those emails as well, which might be really helpful. And it says down here, auto emails will not be sent if this listing is sold, canceled or expired. So they’ll keep getting them while this listing is in some form of active. And just click save and you’ll set that up. Fabulous.

So again, you have two ways to do that full CMA. One using the shortcut of finding an old MLS number or one where you input all the information. You can use a radius search or you can use another map tool. You can send those listing reports, listing activity reports to your seller once it’s in the MLS.

And to get it into the MLS perfectly so that your seller’s happy and all the information’s in there to get the most exposure and the most information out to the other agents and their clients, you have that report that you can have them look at and help you input all the information about their listing.

So printing out an incomplete listing or emailing it to your client and having them add, oh, yeah, we forgot we have also a sunroom or probably not something like that, but they can that will help nudge them to add everything that is available. So that is everything I was going to cover today.

Right at time, let me take a peek and see if there’s anything from my team saying that I need to cover.

Looks good. Sounds like all questions have been addressed. Thank you so much for joining me. I hope you all have a great rest of your day.

Explore Related Academy Content