Cool Real Estate Search for Investors

I noticed that Robbie has been playing around with the back-end of the home search tool he has developed for Rain City Guide, and it reminded me that I’ve been wanting to highlight one of the cool feature. The search tool allows you to sort your listings based on the price per square foot…

And why should you care? Well, here is a search of the “cheapest homes in Seattle” in terms of cost per square foot. (note I had to put in values for the low end of a home and the low end of square footage in order to eliminate all the “zero” values.) If you’re the type of buyer who is looking for a good deal this would be a great place to start. I’m not aware of any home search site in Seattle that allows you to filter things in this way so easily!

Create your own search here: Seattle Home Search.

How cool is our home search? Ice Cold!

In case you haven’t dropped by our home search tool recently, we’ve made some improvementsicecube. Changes include…

Market Analysis Tool Improvements
We thought it would be helpful, if you could get a second opinion when you get an estimate. So, we’ve made arrangements with Zillow to use their Zestimate web services on our Market Analysis page. That way, when you type in a property address, we’ll give you our estimate, get your property’s Zestimate (and the link to it’s page on Zillow), and save you some typing.

Radius Search
Want to find the all houses, within 2 miles of your house or office? Now you can here! And yes, the search results pages are Bookmark-able, RSS-able, and Google Earth-able. (I wouldn’t have it any other way).

Improved Location Search
The list boxes on the location search page are multi-selectable. Big whoop, I hear you say? Well, ours doesn’t refresh the entire page when you change the city or download a big city / community list when you first navigate to the page. Yes, you are seeing AJAX in action. It’s not something most people are going notice, until they wonder “Gee how come your page is so much faster than all the other ones”?

As always, the results from the improved location search are Bookmark-able, RSS-able, and Google Earth-able.

What’s next
Well, it’s a given that at some point I’m going have to have Virtual Earth or Google Maps integration, instead of static Yahoo Maps. If I’m going to compete with the big boys of real estate search, I gotta do maps. I’m probably going to have to create profiles, so you can save your searches, favorite properties, favorite places and other stuff that requires server side persistence.

What features would consumers and realtors like to see next? I’m more interested in hearing what realtors would like to see next because they are the ones who’ll be writing the check, when I eventually decide to release this. I have a billion ideas for what I’m going to do, but I’d get to some more feedback to find out what features I should implement next. Otherwise, I’ll continue to make it up as I go along…

Robbie

Real Estate Search is an evil hard problem

google evilOne of my pet peeves about most real estate search sites is that I can’t search on what I want. All of them, ask the same 4 or 5 questions. Where is your house located? How much can you afford? How many bedrooms? Blah, blah, blah..

Well, I’m going to attempt to change that. I want to find houses with CAT-5 wiring built in! I want to find houses with home theaters & wine cellars. I want to find a home with air conditioning (believe it or not, summer is coming). And now, I can. I proudly present our new search remarks feature.

Using the power of SQL Server‘s Full-Text Indexing features, this is now possible. Granted, our search is a long long ways away from being Google good, but it’s a start. If somebody wants to throw a lot of money at me so I can turn around and buy a copy of Endeca In Front or a Google Search Appliance, I suspect we’d get a lot better.

For example, when I looked for “cat 5” and found a house that doesn’t have a black cat. I looked for “home theater” and found a lot of homes (but not lot of homes with home theaters). Do a search for “media rooms” and you’ll find a lot rooms (but not as many media rooms). Obviously, you need to pick your words carefully to get what you want. Also, I need to start adding words like “home” & “room” to SQL’s noise word list since those words appear on nearly every listing’s remarks section. But, let’s face it, writing a search engine is hard. Eventually, I’ll tweak things so I can get Google or Microsoft to do my dirty work.

In the mean time, I hope finding your dream home got a little easier.

Robbie
Caffeinated Software

The Future of MLS search is coming to Rain City Guide

Greetings fellow Rain City Readers! I’m a software engineer that has been working with Dustin to develop a better MLS search. Before I get started into what I’m doing, I thought I’d discuss the why I’m doing it…

My saga began when I had the opportunity to develop an NWMLS search web site for a local realtor. After spending several weeks, cutting red tape, determining what forms I needed to fill out, figuring out whom at my realtor’s broker I needed to bother, signing my life away and finally getting access to an NWMLS database, I was at the point where I could get real work done. Anyway, after I had spent over 40 hours developing standard search features (search summary with thumbnails, property detail page) and a few interesting ones (like customized HTML e-mail with property photos, customizable photo not available photos on search results), I sent her my bill.

Then things went south. Despite the fact that my client was warned ahead of time that my time isn’t free, she apparently expected that I would be price competitive with “canned” solutions such as those offered by iHouse & Superlative. On the one hand, I can’t blame her. A consultant can’t compete with a commercial product, because a commercial product has a lot more customers to help finance its development than a lone consultant does. Just because those companies sell solutions for $50/month doesn’t mean it only costs them $50 to design, develop & test the software! It still costs those organizations thousands of dollars (or more) to bring these products to market! However, if you plan on distributing software to 1,000 customers, you can charge a lot less per customer, than if you are only distributing it to one.

Anyway, after this failed business opportunity, I decided to contact Dustin and regroup. I wanted to develop a unique MLS service that would’ve given my client a competitive advantage (and she was more interested in price than value) and after reading Rain City Guide it became obvious that Dustin would see the value in what I could do. Besides, I’d rather continue to improve the code I was working on than send it to the hard drive in the sky.

Dustin & I, both share the belief that the real estate industry is in for some very interesting times as the reverberations of the internet revolution continue to change our society and business models. Dustin’s enthusiasm for the ideas I’m trying implement is contagious and we essentially worked out a deal in which I’ll continue to develop compelling MLS technology in my spare time, I’ll use him and his Rain City readers as a sounding board for ideas and beta testers (both marketing & development feedback), and in a few months time, ideally, I would have developed a really unique service that technology savvy realtors would be willing to pay for.

One of the cooler things I’ve done is turn MLS search results in to Google Earth files. Just download the Google Earth application, visit our BETA listings search page, click on the Google Earth icon, and see your search results on a 3D globe. Eventually, we’ll do similar stuff with AJAX style Mapping (although, right now I’m focusing more on things that haven’t been done yet) and other applications.

Google Earth Application

Most realtors have “me too” & “same old thing” web sites. One of the things I want to do, is give realtors the ability of exploiting the MLS data in way that is valuable and compelling to their clients and strengthens & reinforces their name/brand to their prospects. Having customized RSS feeds of MLS data, having proximity searches to points of interest (how far is this house away from a gas station?), and take advantage of all the cool location/mapping technology that the 3 giants of the internet are developing (Microsoft, Google & Yahoo), are just some of the things that could be done, but aren’t really done yet.

One of the reasons for this state of affairs is that currently only software engineers with access to MLS data can do these things. Unfortunately, we live in world in which most realtors don’t have the skills & knowledge that software engineers have and most software engineers don’t have free access to the raw MLS data that most realtors do, so things are moving slower than they otherwise might be. Obviously, waiting for the HouseValue’s of the world to develop this technology is an option. However, their business model seems to be marginalizing the value of a realtor instead of enhancing it. I’d rather take the opposite tack, since I suspect that my future customers would prefer to use technology to improve their competitive advantage against all comers rather than having it used against them and risk turning themselves into a bunch of “me-too” commodity realtors paying somebody else for random sales leads. (which is probably one of the reasons you blog!)

Right now, you can take a gander at the humble beginnings of our grand vision at http://listings.raincityguide.com/search.aspx. Granted we still have a few bugs that need to be fixed, and many, many more features need to get implemented. However, it’s my goal to turn this into something that would provide a compelling value for my future clients (realtors & their customers) and I welcome any comments that would help me, help you.

Robbie
Caffeinated Software