Archive for the ‘Inventory’ Category

June 3, 2008

Trouble in the Southland

Update as of June 6:  Sandicor has fixed its data feed, and as of a few minutes ago all San Diego MLS listings are up-to-date on Redfin.com. Should listing data issues in any market come up in the future, we’ll hold to the commitment outlined below. Thanks for your patience!

Some of you may have noticed that San Diego listings on Redfin.com haven’t been updated over the weekend. Sandicor, the San Diego area MLS, has been having some issues that mean it can’t export listing data to MLS-powered websites like ours.

We’ve talked to the folks over at Sandicor and they’re working hard to resolve the issues. They run a tight ship, so we’re confident the data will be moving again soon.

road-closed.png

San Diego listing data highway: temporarily closed.

It bothers us whenever the data on our site isn’t as fresh as possible. We’re a member-broker of the MLSs in each of our markets so that we can get the most accurate and up-to-date listings on Redfin.com. We update our site with new data from most of the MLS databases every 15 minutes.

But sometimes problems come up. You should know what you’re getting on Redfin.com, so here’s what you can expect:

We’ll update listings on Redfin.com every 24 hours, or sooner.
This applies to our MLS listings, as well as foreclosure and for-sale-by-owner (FSBO) listings. An update means the latest data from our listing data providers is on Redfin.com. For sources of data that change less often, like tax records and school information, you can expect the data to be updated less frequently.

When we can’t, we’ll tell you why.
Whenever our listing data is more than 24 hours old, we’ll post a note in the forums for each market that’s affected, explaining the issue and giving you some idea of when it will be resolved.

And then we’ll fix the problem ASAP.
If the problem is on our side, you can rest assured that we’ll attack it like rabid dogs until it’s fixed. On weekends, we may be slower to discover problems with our data, since our developers personally monitor the data feeds and they occasionally, but only occasionally, take part in non-development related activities - i.e. “personal life.” If it’s our partners who are having trouble, we’ll give them whatever help they need.

We simply want to build the best real estate website in the world, and as part of that we’re making this public commitment on our listing data. Comments are, as always, welcome.

Photocredit: sillygwailo on Flickr.


May 27, 2008

No One’s Going to Take Away Our Data, But What Can We Do With It?

In September 2005, just as Redfin was raising its first round of funding, the Department of Justice sued the National Association of Realtors for developing a policy that allowed its members to share listing information with some brokers but not others.

The policy was suspended while the lawsuit lumbered through federal court. And in the interim, Redfin was able to cite the lawsuit in convincing investors that we could compete straight up, broker to broker, without losing access to all the listing data controlled by other brokers.

And it’s still why Redfin, alone among the major new websites, has had all the broker-listed homes for sale: we’ve been able to become members of the Multiple Listing Services (MLSs) that Realtors use to share data, and have made our peace with its other rules.

But plenty of folks wondered what would happen to Redfin when the NAR suit settled. We wondered too. Well, today the suit settled. When I first read the NAR press release, I suddenly remembered what Billy told his platoon of mercenaries at the beginning of “Predator”: “We’re all gonna die.”

The National Association of Realtors proclaimed a stunning victory, first because it didn’t have to admit to any wrongdoing, though this is a standard feature of many settlement agreements; and second because the NAR also said that it didn’t hbilly5.jpgave to pay any money, though this is hardly what the Department of Justice was after.

Greg Swann at Bloodhound, quoting Hamlet Macbeth, rightly said so what.

But the proposed settlement agreement did result in a major change, the permanent repeal of the Internet Listings Display policy that would have allowed brokers to selectively withhold listing data.

So for the consumer (and for Redfin too), the settlement is good news: an MLS can’t discriminate against Redfin or any other broker because of our business model or our technology. Any information that can be whispered by a real estate agent to his client — such as how long a home has been on the market, or how its price has changed over time — can be distributed by Redfin through its site. Hooray!

But the NAR wasn’t about to set the data free willy-nilly, especially when its member Realtors are accountable to home-sellers who want to see their homes marketed, not discussed or criticized. For one thing, the DoJ protections only apply if we ask site visitors to register, which turns off about 90% of the people who visit a real estate site (how would Google have grown if it required registration to search?).

Beyond that the NAR claims that “the new policy protects sellers from having false or other unwanted information about their listings appear” on sites like ours. We wondered what that meant. According to the exhibits in the settlement agreement, a seller can opt out of:

“1. allow[ing] third-parties to write comments or reviews about particular listings or displays a hyperlink to such comments or reviews in immediate conjunction with particular istings, or
2. display[ing] an automated estimate of the market value of the listing (or hyperlink to such estimate) in immediate conjunction with the listing.”

The automated estimate mentioned in the exhibits is exactly what we’ve integrated from Zillow, eppraisal and Cyberhomes. And the online discussions are something we’ve tried to host before, too. We suspect that some brokers will include such prohibitions in their standard listing agreements, so that many sellers will opt out.

Ultimately, we think that ducking a conversation like this is just sticking our heads in the sand. We can understand why the NAR took the position it did, but in the final analysis it marginalizes Realtors, and limits our ability to connect buyers and sellers.

People will talk about homes online, and they’d rather do it on brokers’ sites, where all the listings are available. But if they can’t talk here, they’ll go somewhere else.

So all in all, we were glad to see that the settlement protected all brokers’ access to data. We just want to make sure we can still do something meaningful with the data, too.

Bonus link: The NYT gets snarky about Paris Hilton, AGAIN…


April 30, 2008

All the Homes for Sale (Well, Nearly All)

One Sunday morning last fall, my great friend Conan, a debonair former nose-tackle who often advises me to get in touch with my feminine side, called to ask about using our site. It took half an hour to convince someone who knows I would never lie to him in a million years to run a search on Redfin. And almost all that time was spent on one simple question: “do you have all the homes for sale?”Conan and the Great Peter Seidenberg (Far Left)

“Great question,” I said as real estate inventory has somehow become one of my favorite subjects, second only to “how popular I was in high school,” gossip, my many grudges, and what different drugs are like. “We have all the broker-listed homes for sale.”
“And that’s ALL the homes for sale?”
“Well, technically there’s always a few sold by the owner, without a broker. It’s called FSBO.”
“Yeah?” Conan said. “You don’t have those?”
“No.”
“Is that it?”
“And there’s also stuff in foreclosure, that’s been repo’d by the bank, before the bank has hired a broker to put it in the MLS.”
“Yeah?” Conan said. “Is THAT it?”
“And there’s always the possibility that you could sell your place to your cousin, without ever putting it on the market. We wouldn’t have that either.”
“So basically you’re saying you kind of suck,” Conan said. We had now come to very familiar ground in our 20-year friendship.
“Yeah,” I said. “But everyone else sucks too. Many suck worse.”
In the background, I could hear Conan typing in his first search.

A few minutes after our call ended, the U.S. real estate market collapsed, putting more inventory in a gray market of foreclosures. And we soon began working with I-don’t-have-an-office-number-just-a-cell-phone middle-men, data-scrapers and offshore aggregators to get our hands on every home for sale we could find, minus outdated garbage, copyrighted information, stuff that wasn’t really for sale, and teasers where consumers would have have to pay someone else for the address.

This culmination of this effort is the latest version of our site, live since 6 a.m. this morning, which has bank-owned foreclosures and for-sale-by-owner listings alongside all the listings from the Multiple Listing Service (MLS). It’s a little controversial, and lots of fun to play around with and of course we think it’s beautiful too.Redfin Supports FSBO and Foreclosure

Not that even now the new version of Redfin has all the homes for sale – we only had enough money to get data on foreclosures once the bank owns them, but not before, when they’re up for auction. For the markets we serve, we should have more real estate listings than anyone else. And the foreclosure data we do have is unique, because we give the foreclosures’ actual addresses and bank contact information, which other sites require you to pay for. Redfin is the only site we know of that aggregates bank-owned properties for free.

We’ve hit up more than 50 for-sale-by-owner sites for their inventory, with only two major gaps: Zillow and craigslist. Zillow is, we hope, coming soon. Someone offered us a craigslist feed, no questions asked. But when we emailed craigslist about it, Internet god Craig Newmark confirmed this was a violation of the terms of service. What was incredible about his reply was that it took exactly three minutes and it came from The Man Himself (Craig Newmark rocks).

On other fronts, we’ve fixed up our URLs for Google, and juiced up our MLS integration again, in both Boston and Southern California, so that we can get comprehensive inventory updates every 15 minutes (our only laggard MLS integration is now in Ventura County). While we were at it, we grabbed more open-house data, let people search for open houses, and upgraded our email notifications to tell people when their favorite listings change prices or sell. Next up, the data team is hoping to get photos of very-recent past sales.

But for now we’ve also made it more obvious how to search for data on past sales, a sweet feature that Redfin has always had but which no one ever knew about because it used to be hard to find. No longer! For the markets we serve, you can easily see what any home sold for between last week and 20 years ago (the lag is often more than a week, depending on how long it takes the transaction to record).

What does this all add up to? As our press release explains, the new version takes us deeper and deeper into Freakish Depth, which is our strategy to build the best real estate site by getting the best data. Because we’re a broker in the thick of doing deals, we have access to data as it’s being recorded. And unlike lead-generation sites, we want people to use Redfin to go all the way, getting everything they need to buy the home without having to talk to anyone or pay anything.

The strategy started in January with super-low-latency-MLS integration, bird’s-eye views, two new estimates, Excel integration, neighborhood boundaries and comparable listings. Then we got deeper with listing statistics, which analyzes where the traffic for a listing is coming from, and how inventory levels in the neighborhood have changed.

A gratifying subplot of all this is that the MLSs with whom we have sometimes jousted worked with us on this release. One MLS guided us on how we could show different types of inventory without violating the rules. And another provided the square footage data we’d been asking for. It’s still a delicate balance, sharing data among competitors, and working within a common set of rules to protect the different brokers’ clients.

Which makes us all the more careful not to screw things up. For years, we’ve wanted to add inventory to Redfin’s site, but have hesitated out of respect for the brokers who share their listing data with Redfin, many of whom have legitimate concerns about properties for sale directly from banks or owners. In the end what swayed us was:
a. the consumers who want above all else to see all the homes for sale,
b. the market, where in places like San Diego 40% of the sales have been foreclosure-related,
c. guidance from some of the MLSs we work with.

Hopefully, we’ve found a way to show consumers more information without causing any harm to other MLS members. We’re going to roll out flat-fee services in the next few weeks to work with buyers on for-sale-by-owner and foreclosure properties, but we won’t help anyone go around a listing broker if one has been hired.

Many thanks to all the engineers, product managers and customers – a San Francisco focus group talked us into buying the addresses for foreclosures — who came together to create this site. We worked awfully hard on it, some of us through occasionally daunting circumstances, and are anxious to see how you like it. We hope there aren’t too many bugs. And please, spread the word!

*PS: we may add auction properties in the future but in that case we would have to require users to pay an extra fee to see the address.