Tuesday, June 16, 2009

Tons of Sorting Options

Many people miss the power of the sorting options in all search mode, so I thought I would go over them now in detail. Note that once you sort, when you come back to the site or do another search, that sort option will be the default for you. No need to resort it each time.

To sort, look for the "Sort by" followed by a scroll bar. This should be above the results.

Price/High- This one should be obvious. This is the default. Homes with the highest (current) "for sale" price are listed first.

Price/Low- The lowest (current) "for sale" price.

DOMm/Low- This is Days on the Market "M" M stands for MLS. SO it shows you how many days this home WITH THIS MLS# has been on the market.

DOMp/High- This is Days on the Market "P" P stands for Property. This DOMp shows you total days on the market for this property regardless of multiple agents and several MLSs (it resets after 90 days off the market). This number is more accurate if you want to know "How many days have they been trying to sell this home?" Many sites won't show you this. They think the consumer needs less info and they dumb down their site.

(more on DOMM vs DOMP)

City- Alphabetically by City.
Zip- Sorted by Zipcode
BDR/Low- Sorting by the # of total bedrooms. Lowest first.
BDR/High- Highest number of bedrooms first.

Lot/Low- Lot size (if entered in by the Realtor). Lowest first.
Lot/High- Highest listed first.

ADVANCED- These are more complex!
List$/Tax Low- This is List Price divided by Tax Assessment. The lowest ratios are shown first. This is an amazing feature that is frequently missed. While sure, I constantly say NOT to use the tax assessment to value a home accurately, you CAN use it to quickly show you the "bargains" in a zip code. Homes that are 20-50% below tax assessment mgiht be great fixer uppers or bank deals. You can even sign up for alerts to "show me homes that are 50% below the tax assessment". This is a must have for investors. Here is Jeff's video how to:

List$/LastSold- This will in one click show you homes that have dropped the most since their previous purchase price. It is the current List Price divided by the Last Sold price.

Built/Low- Year built.

SQFT/Low Total interior square feet. Sometimes this includes the basement, sometimes it does not. Also note that MANY agents leave this off, so this is not a great way to sort.
SQFT/High- Larger units shown first.

Subdivision/Asc- Alphabetical order for the subdivision. A-Z
Subdivision/Desc- Same as above but Z-A

# Views/High- This is cool. This tracks the number of people that have looked at the property. So you can sort to see the most popular listings first.

Last$Change- This sorts by the last DATE of change in the price. So the homes at the top have most frequently dropped their price. This can be better than sorting by DOMm to see newly listed homes. The recently dropped homes shouldn't be missed!

OpenHouse- Pulls up all the Official Open Houses first and then the Unofficial "maybe" Open Houses based ont eh remark's keywords. For example if it says "Open Sunday" in the remarks and the home has been on for 60 days, there is a good chance the agent was too laxy to update their listing. We use the wavy symbiol to show maybe: ~.

Walk Score High- A new feature! Allows you to quickly see which homes have a higher walkability score from WalkScore.com

CloseDate High- This works great in the SOLD mode. It lets you sort by the date the home last sold. Good for recent sales, but also for homes that sold in the 1990s (when hairdoos were cool!).

ListDate High- Shows the most recent listed homes first. This works well for people watching Short Sales that are under contract since the DOMm get frozen.

Am I missing anything? Any benefit of one of these?

And don't forget you can export to Excel and sort using that as well.

Written by the Owner of FranklyMLS.com: Frank LL0SA


  1. Can the the price ranges in the save searches be more flexible? Thanks. Keep up the good work.

  2. What are you looking for? $50k increments? More numbers on the higher side or the lower side?

  3. The ListDate High is a great addition as well... thanks for adding it!

  4. One additional search that would be helpful is LastChange - meaning any change to the listing: price, updated pics, status, corrections, etc.

    This site has been invaluable in my home search, thanks!

  5. Can it show the actual listing date when you sort by the ListDateHigh? I am trying to see when it was listed compared to when it sold. The days on the market freezes as you said once it goes under contract so it throws you off. I am watching short sales under agents.

  6. Could you kindly advise how to "export to excel"? Thank you!

  7. Click the checkboxes on the far right and then click EXPORT below.