When
doing your MLS search from Connect MLS be sure to click “Add/Remove Fields”
button.
Add
“Listing Contract Date” and save changes.
Select
all status activity. Make sure that all
the status options are selected as shown except there is no need to select
rental activity.
Then
search for all activity for the last two years.
These options will make sure that all the data that is needed to create
the appropriate graphs, is collected.
You
should also make your normal selection choice by selecting other options that
you would normally select in doing a CMA.
As mentioned earlier, looking at activity in specific subdivisions or
neighborhoods is a good starting point or use the map search feature to find
all the activity near the subject property.
Once
you’ve selected the search criteria, you may view your results. Click the “View Results”
button. Once on the results page click Modify Columns> Edit Columns.
In
the table name enter “Focus 1st”. Then select from Available Fields
to Currently Selected Fields exactly as shown below. Remove those not on the
list below. Once you have added all the fields below, click the “Save” button.
This is a one-time action, and you will not need to Modify Columns moving
forward.
Required MLS Fields
·
Above Grade Finished Area
·
Address
·
Bathrooms Full
·
Bathrooms Half
·
Bedrooms
·
City
·
Sold Price
·
Closed Date
·
Days On Market
·
List Price
·
Listing Contract Date
·
Listing ID
·
Lot Size Acres
·
Original List Price
·
Off Market Date
·
Purchase Contract Date
·
Total Finished Area
·
Status
·
Subdivision
·
Unit Number
·
Year Built
After
you have clicked save as mentioned above, you can now export your MLS data. Be
sure you have selected the Focus 1st format and click the download
button.
Select
“all listings displayed in the results” then press the “Next” Button.
Be
sure “Focus 1st” is selected from dropdown options then press “Next”
Button.
Select
the “Tab-delimited text” format. This is
format you want to use, so select the “Next” button.
Once
you select the “Next” button, you will see a screen similar
to that shown below and your file is now in your downloads folder as a
TSV file. Depending on how your browser is set up it may prompt you to save the
file. Just remember where you saved it to as you will need to upload this file
to Focus 1st Pricing.
Once you
have saved your exported file, you are ready to run your application. When you run the application you will need to
find to the exported data file, so make sure that you’ve placed the file in an
easy to find place.
For
instructions on how to run your application, be sure to see the tutorial on the
Focus 1st YouTube
Channel.