Even more on-line real estate tools in the works…

trampolineJohn Cook’s Venture Blog had an update to the Zillow story… and this time it has to do with the relationship between Zillow’s founder (Rich Barton) and the man (Barry Diller) who bought his company, Expedia, who just happens to be developing a new real estate brokerage that will begin operations in the Pacific Northwest.

My guess is that Barry Diller wouldn’t be venturing into the real estate brokerage business unless he felt he could use his Internet empire to create something of unique value. (Otherwise, if he really wanted to own a traditional real estate company, he could just buy one of the many local firms!) My guess is that he (and the people at realestate.com that work for him) are developing a home search tool that they feel would really benefit consumers. From what I’ve read of Zillow, they are definitely building some type of system that will simplify (or at least improve) the home buying/selling experience. My guess is that Barry Diller up to something similar?

On a side note, I really like Tom Dozier’s insight that we are quite possibly seeing a bubble of local real estate sites! With each passing day, I feel more confident that the real estate search landscape will look completely different one year from now… With the only people guaranteed to win in this situation being the home buying/selling public!

Also of interest, I received an email today from someone of the big real estate firms here in the Northwest where the writer let me know that they have already developed a home search site based on one of the on-line mapping services, and that they will likely be rolling the site out in the near future. This confirms my suspicions that sites like MLSMapsOnline and ShackPrices will really have to develop some major innovations (and this doesn’t just mean more or less pull down menus!) or they can expect to be quickly forgotten. From what I’ve seen so far, any major player (Microsoft, Windermere, RealEstate.com, etc) could build a comparable site for less than $50,000, and while $50K might mean something to these start-ups, it is almost inconsequential to the larger firms.

More real estate mapping: MLS Maps Online

South Lake UnionThanks to a tip from a reader, I found out about a new home search site (MLS search) that is worth highlighting:
http://www.mlsmapsonline.com

The site uses Microsoft’s Virtual Earth technology to plot MLS listings. The idea is great, but the implementation is definitely lacking some key features. For starters, if you are a Firefox user (like me), you’ll be presented with this message when entering the site:

“We’re sorry. MLSMapsOnline.com is an IE only application. Please download the latest version of Internet Explorer to continue to this website.”

What a bummer! I’m surprised that people still write programs that only work with IE. Under most circumstances, I just ignore sites that don’t support Firefox, but in this case, my curiosity for new map-related MLS searching was greater than my dislike of IE. By the way, don’t even bother to try to view this site with a Mac, I had to use my work computer (as oppose to my home computer) just to test-drive the site!. Now that I’ve acknowledged this major drawback, I’ll move on with my review…

Some things I like:

  • The mixing of flash technology and Microsoft’s mapping technology makes for some really smooth visual searching. It is extremely intuitive to navigate the site. The future of home search is definitely visual, and this site is getting us one step closer.
  • The ability to search by “Listed Date“. The rest of the search controls will be pretty familiar to anyone who has used an MLS search.
  • The ability to log-in and save search results is nice, especially since they do not require it to use the site.

Some things I dislike:

  • It is worth repeating that an IE-only tool is really pathetic, especially when it doesn’t even work on the IE version for a mac!
  • The site design really encourages the user to define a city and/or county to search, when the best way to get to an interesting area would be to zoom in on that city. In other words, if I’m searching for homes in north Seattle, why limit me to the city limits. If I scroll north of Seattle, I want to see the homes that are for sale in Shoreline.
  • The search options are pretty minimal. A user should have access to more advanced search options.

At this point in time, it is one of the better home search options for people in the State of Washington (assuming you’re working on a PC and willing to use IE). However, I happen to know that there are a few more MLS search sites that will come on-line soon that will be using similar technology, but won’t have as many of the limitations. The layout they’ve created is not all that different from the standard MLS search and would be pretty easy to duplicate, which leaves me still waiting for a break-out search site.

It’s worth repeating that I’m definitely interested in hearing about more of these technologies. (I find this topic much more interesting than bubble talk 🙂 ) If you know of another interesting home search site available for Seattle residents, I’d love to hear about it!

UPDATE:
1) MLSMapsOnline went live with a version that works well with Firefox! (that was a really fast update!)
2) The VP of Technology for Windemere emailed me to let me know that Windemere also offers a map for viewing homes for sale via their PropertyPoint software. I’ve played around with their mapping software before and it definitely impressed me a year or two ago when it came out. However, I’m pretty sure they are using an ESRI ArcServer backend and that technology seems dated. I definitely think that the future is in running a backend using Google Maps, Yahoo Maps or Microsoft’s Virtual Earth. Besides being extremely expensive to run, ESRI server-side software is way too difficult to implement for there to be much innovation using this software. Leave it to the big companies (like Windemere) and governments (like MTC) to run ESRI software, while the rest of us take advantage of the mapping wars that the big internet companies are waging!

Shack Prices

Picture of Homes on RiverShack Prices (which I mentioned a few days ago in the comments section of this post) just went live. Their site gives the sale price of King County homes (including Seattle!). Their reason to be:

Shack Prices was created with the hope of giving people as much information about home values as possible. We realized that there were many websites that show you prices of homes on the market (i.e. homes that haven’t yet sold) and some websites that would sell you information about comparable houses nearby, but no sites that let you pick the comparables and the area. The difference between Shack Prices and realtor web sites is that Shack Prices shows the actual price that each house sold for versus the price that someone hopes their house is worth. You can use it to virtually appraise your home or a neighborhood. We hope it helps you as buyer or seller.

In playing around a little, the site seemed pretty darn intuitive. If you are interested in getting a rough idea of how much your home would be worth on the open market, just insert your bedrooms, bathrooms and square feet. If there is not a lot of data in your area, extend the time-frame out a year, instead of the default three months.

If I had to give a critique of the site, it is that they borrowed a little too heavily from the typical home search websites instead of re-thinking how an “appraisal” site might work. For example, if I’m going to appraise my home, I know precisely how many bedrooms and bathrooms are in the home. Why do they have the option for a range? Also, my experience in estimating a home’s value is that some other data fields within the County’s home sales database (like the home’s style code) is much better than the number of bedrooms at indicating the estimated value of a home. The number of bathrooms plays a minor role at best, so I wouldn’t have even bothered with that field. Granted, some of my suggestions might take some user training if they are used to the more traditional home search, but it would be a more valuable tool.

With that said, if you are living in King County and interested in an estimated value of your home, Shack Prices is a great place to start. However, if you want something a little more robust just ask any real estate agent. ANY agent looking for more business will prepare a “Comparative Market Analysis” for free and the agent will likely be more experienced at weeding through the appropriate data fields to develop a better estimate of your home’s value.

Congratulations to Galen for making this happen and check out Seattle Real Estate Talk’s post on Shack Prices…

more on real estate search technologies

[photopress:Ballard_RR_Bridge.JPG,thumb,alignright]In researching the options for different real estate search tools, I came across an interesting site called NeighborhoodScout. The idea behind the site is that it would help people moving to a new area find an appropriate neighborhood. I think that the idea is great, but my brief investigation came across some serious flaws in their implementation. For starters, I couldn’t get their algorithms to recommend a neighborhood in Seattle despite my effort to tweak my entries to things I thought would cause their algorithms to recommend Seattle. Instead the site kept recommending Bothell, which is a nice place to live, but not the neighborhoods I was looking for… Another major flaw is their pricing mechanism. The $20 fee to use the interesting parts of their tool seems like a major momentum killer for any website. As I alluded to yesterday, data wants to be free!

I have found a few other neighborhood sites, but they tend to be pretty focused on a local market. For example, Sustainable Seattle has an excellent site that maps demographic and environmental data for Seattle neighborhoods, but my current interest is in sites that have attempted to analyze real estate demographics on a neighborhood level based on national data.

Does anyone have any experience with NeighborhoodScout? Do you know of another neighborhood finders? I’d be very interested to hear about it!

How far is too far to commute?

[photopress:round_and_round.jpg,thumb,alignright] The most common question I get from people moving to Seattle regards their potential commute… The question typically follows this format:

“How far away from my work can I live and still have a reasonable commute?”

It doesn’t really matter whether the person is planning to work in Downtown Seattle, Downtown Bellevue, the Amazon Campus, or the Microsoft Campus, because a “reasonable commute” is different for each person.

Some people are willing to drive an hour to save money on a home (or be able to afford a home for that matter), while others want a commute that is less than 20 minutes. Across the country (and especially in the Seattle area), the farther you are willing to drive every day, the less you have to pay for a home.

Interestingly, my work as a transportation planning consultant has put me in contact with some very interesting resources. For example, I recently came across these five maps that were put together by the regional government (PSRC) that give a great indication of the average commute:

These maps are great if you know the area you are going to be working (say Downtown Bellevue) AND you know that you are willing to commute a specific distance (say 40 minutes) because then they can help you put a definitive boundary on your home search!

NOTE: These maps are created “topographical-style”. If you are new to this, imagine that the graphic is displaying a huge mountain centered on the point of interest (like Downtown Seattle). If you move anywhere within the first circle (the top of the mountain!), then your commute to Downtown Seattle would be less than 20 minutes. However, the farther out you live, the large the hill you have to climb to get to work. For example, if you were to move to Issaquah, then you could expect about a 40 minute commute to Downtown Seattle.

By the way, the maps are a little dated (they are based on 1997 data), but the commute patterns have not changed much in the last 8 years, so the trends are still pretty accurate.

The same regional model that was used to create this data also spits out data for future years! Wouldn’t it be great to have the same maps for future years (2010, 2020, etc.) so you could gauge how your commute might change? This can be done! And if there is sufficient interest, I’ll put something like this together!

Bus Monster! WOW!

bus monsterI just ran across the best google map hack yet:
Seattle Bus Monster

and the more I browse the site, the more impressed I am.

Some of the things to notice:

  • real time bus location information with estimated arrival times!
  • real time traffic cameras
  • bus stop information
  • the ability to search for a bus top and/or route
  • route markers drawn over google maps!

Everything about the site is professionally done. For example, try typing in “2nd and Spring” when searching for “bus stops”. The site will return all the 2nd and spring locations in King county!

Play around and I think you will find that Chris Smoak has made the life of Seattle transit commuters MUCH easier.

Farmers’ Markets in Seattle

Tulips As a test for a new little program I wrote to post things on Google Maps, I’ve put a map together displaying all the Farmers’ Markets in Seattle. In order to do this, I cribbed heavily from a few websites such as metroblogging and the Neighborhood Farmers’ Market Alliance .

The farmers’ markets current being displayed include:

  • Pike Place Market
  • Ballard Farmers’ Market
  • Broadway Farmers’ Market
  • Capital Hill Farmers’ Market
  • Columbia City Farmers’ Market
  • Fremont Market
  • Lake City Farmers’ Market
  • Magnolia Farmers’ Market
  • University District Farmers’ Market
  • West Seattle Farmers’ Market

If you know of some other farmers’ markets that should be included or some data that needs to be updated, just let me know.

By the way, I also made my first google maps “marker” for this site. If you look closely, you may notice that the marker is a tulip based on the flower in the center of the above photo.

Farmers’ Markets in Seattle

Mapping Seattle

house on waterAppropriate for a high-tech City, there are many digital mapping options. Listed below are some of my favorite ways that I view Seattle (while sitting at my desktop!)

1) Redfin gives you a birds-eye view of Seattle with great aerial photography. It is a very easy (and FUN) site to navigate. I should also note that Anna is a listing agent on the site.

2) Next up is Google Maps. There is no need to bother with Mapquest or Yahoo Maps anymore. Once again, Google has done it right. The site is a lot of fun and I especially like that you can zoom around with the arrow keys on your keyboard. While you’re at it, try doing a local search on something you like to visit (I did Bakery). I ended up with all the local bakeries around my house! UPDATE: On their march of progress, google added satellite imagery. Kottke gives a great description of how this is not necessarily a new technology (mapquest had this ability at least 4 years ago), it is just implemented much better!

3) If you really want to get down to details, check out the on-line GIS maps provided by the City of Seattle. This site is wickedly powerful in that you can see property information for EVERY residential property in the City all via a convenient (albeit slow) interface (no more trips down to the public library for “public” information). It includes previous sale information for each property… Not that I’ve done this :), but it can also be used to “remember” the name of a neighbor. As long as they are the owner of the house, then their name will show up on their parcel data.

4) The City of Seattle puts out a great bike map. I went ahead and ordered a free hard-copy version of these maps, and I use it regularly.

5) Seattle Neighborhoods. Did you know that the City has published exact boundaries for each of the Neighborhoods in Seattle? Very cool reference!

UPDATE: I’ve built a program called gHomes to my site. It is a great way to search for your next Seattle or Eastside home.

Transit in Seattle

streetcarI’ve been thinking about putting together a set of blog entries that describe Seattle. In particular, I’d like to provide some decent information and a decent set of links for people who are thinking of moving to this area. My first step was reviewing books. My next step was describing all the mapping technologies focusing on Seattle. This entry gives a real broad overview on the transit system. My next few entries will be more difficult as I’ll try to focus on different neighborhoods within Seattle.

No matter where you live and work in Seattle, you will rarely be far from good transit service. I’ve lived in a few different cities, and as much as residents love to complain about lousy transit service (a past-time of downtown commuters everywhere), Seattle’s transit is relatively comprehensive and reliable. Metro Transit, Sound Transit and Community Transit all offer bus service in the City. Metro Transit operates all the local routes (and most routes throughout King County, including Bellevue, Redmond and Kirkland). If you are living in Seattle, almost all of your transit riding will be on Metro.

In addition to regional bus service, Sound Transit also operates a train between Tacoma and Seattle and another train between Everett and Seattle. Sound Transit has already begun construction on a light-rail line that will connect the Sea-Tac Airport with Downtown Seattle.

And the white elephant in the room is the monorail. On Nov. 2004, Seattlites voted to keep the monorail development and construction moving forward. The plan is to have the first segment, the green line, completed in 2009.

Is there a major transit component that I’ve missed? Let me know by leaving a comment!