Build a Better MLS IDX Part 2

Posted on May 25, 2010 by: Justin Scott 5 Comments

A couple of years ago I wrote about my horrific experiences working with MLS listing data from a variety of providers.  I thought it would be interesting to revisit the topic to see what's changed.  Unfortunately, not much.  The client we were working with through all of those experiences eventually got fed up with the constant battle with the images.  They complained to the Florida Association of Realtors, who suggested they try the FAR IDX feed.  Apparently, in Florida, all brokers and IDX providers are required to push their data up to the state level.  The Florida Association then aggregates all of this data into a single, well-formed IDX feed that is actually not all that difficult to use.  Their feed is well documented, normalized (no more having to deal with a dozen ways to misspell Sarasota), and they host the images on their server complete with a list of all of the image URLs right in the data file.  Oh, and it's free.  All the broker has to do is fill out a form and they will be issued access to the downloadable data.

If you're developing an online listing display for a realtor in Florida and you're NOT using the FAR IDX feed, STOP.  Just stop what you're doing and ask the broker to get in touch with the Florida Association and get access to their IDX data.  Compared to MLXchange (or any other vendor I've had the dubious pleasure of working with), their data is like a dream come true.  Not only that, but the support at FAR IDX is far superior to anything else I've experienced in the industry.  I found a couple of minor issues with the feed data and was able to speak directly with someone who had the ability to fix the problem at the source.

The way their feed works is that every quarter they assign a new FTP username and password.  Once you have FTP access, you download the file containing all of the listings for the local association.  In our case, the Sarasota association was joined up with the Mid-Florida Regional MLS, so we got the mid-Florida regional listings which included Sarasota, Manatee, Pinellas, and several other counties.  It was more data than we needed, but we could filter out the counties that were farther away upon import without any trouble.  All of the listing types are in the same file with the same data fields, so we could import everything into one database table.  As I mentioned, they hosted the images and even provided image URLs, so whatever was current is what we were fed through in the file.  No more downloading, sorting, or matching images.  If an agent deleted a photo, it got dropped from the feed the following day.  I can't impress enough how much easier working with their data is.

Unfortunately, that client of ours was bought out by another company, so their site is gone and the other company already had a solution in place, so we don't have any sites using MLS at the moment.  We have one project in production that will make use of MLS data, so we asked them to get access through FAR IDX and we just brought over the import code from the retired site and the data is being brought in daily without a hitch.

So, there is hope for MLS IDX data.  For anyone outside of Florida, ask your local or state association to get in touch with the Florida Association of Realtors and pick their brains.  They are doing it right.

5 responses to “Build a Better MLS IDX Part 2”

  1. Do you have an IDX scripts and app to share with us written in CF that pulls the data from the IDX vendor, normalizes the data and creates your own database for display and a front end tags to use which would be used to post the data on the realtor site?

    I'm actually looking to collect the data and pics from GSMLS, MLXCHANGE, TrenD MLS, Monouth/Ocean MLS, Ocean County MLS, NJ MLS, and Hudson MLS.

    I'm an amateur CF coder just getting into it and looking for a system to work off of and learn from. After all hacking someone elses code is the best way to learn with seeing results right away. Any help you can offer would be great.

    Victor

    Victor ~ Jun 9, 2010 at 6:58 PM

  2. Unfortunately I don't have code that is shareable at this point. It certainly sounds like you have your work cut out for you if you're integrating that many MLS systems into one website.

    Justin Scott

    Justin Scott ~ Jun 10, 2010 at 12:24 PM

  3. I was designing a database to hold some listings. At the moment I won't be importing MLS dat into it but I might in the future. Is there a standard data schema that I should use?

    eric

    eric ~ Aug 15, 2010 at 4:33 PM

  4. Unfortunately there is no standardized format that I am aware of. I generally map the fields in the local database to use the same structure as the data coming in (unless it's just awful) and go from there.

    Justin Scott

    Justin Scott ~ Aug 17, 2010 at 11:24 AM

  5. If only the Cincinnati MLS had a similar method for getting normalized data. I've been through the same loops you have, both in this post and your last.

    In my 10+ years of coding, I have yet to see a system more structurally flawed than the MLS IDX data feeds.

    Allen Gingrich

    Allen Gingrich ~ Mar 16, 2011 at 11:18 AM

Leave this field empty: