One 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.