Real Estate Geekiness…

Tonight, I’ve been playing engaging the inner real estate geekiness along the likes of Tom Dozier’s Seattle Property News blog… I’ve been following (from a distance) Tom’s “Home Tracking” posts and not exactly sure where he was going until today. When he said “since one of the signs of the strength of a market is whether high demand is causing people to bid prices above the original amount the seller seeks,” I decided to test out his theory with a larger sample size…

So here is my method. I took all the homes that sold in my neighborhood (Loyal Heights) over the past year and calculated the “Net (Sale minus List Price) as a Percent of List Price”, or this calculation:

  • (Average Sale Price – Average List Price)/Average List Price
  • Average((Sale Price – List Price)/List Price)

The result is summarized in this chart:
% of List Price
(Click on the chart to see a larger version!)

The first thing I found interesting is the extent to which the “Gross Net as a Percent of List Price” varied seasonally… For two years running the % of List Price bottomed out around Feb/Mar and then quickly picked up to peak around May (with homes selling for 4% and 8% over the list price!). Note that February (the bottom) is also when the number of sales bottomed out over both of the last two years.

For reference, there were 182 homes sold between October ’03 and August ’04 in Loyal Heights with the average home selling for 1.2% over asking price. (I threw out September 03 and September ’05 data since I only downloaded data for the partial months…)

My conclusion is that Tom is wasting his time if he expect to see the health of the market by looking at whether or not homes are selling above or below the market price. As my chart demonstrates, there is way too much seasonal variation for a one or two home snapshot to be valuable. Even in the last two years where the value of homes in my neighborhood have consistently risen (quite substantially), there have been long periods (up to six months) where the average home has sold for less than the asking price. However, with that said, I want to say thanks to Tom for raising this intersting issue because you’ve given me an opportunity to learn about (and demonstrate) the huge seasonal variation in the local market!

I welcome anyones comments on my method if you have ideas on improving things (including the obvious improvement of adding more neighborhoods).

Update: I realized this morning in the shower that I was calculating the net (sale price minus list price) as a percent of list price, so I’ve corrected the text in the post (but not the chart!).

Inbox: What’s the best neighborhood for same-sex couples with children?

roses
Continuing on the theme of opening up some of the questions I get via email to my readers, I’ve listed another question and my response below. I’m definitely interested in hearing from anyone in the community who feels they can add something to my response.

Question: My partner and I are thinking of moving to Seattle. We both have professional jobs and would like to be somewhere with good schools for our two children. What neighborhoods do you recommend for families where both parents are the same-sex?

Answer: I’m of the option that just about any neighborhood in Seattle would be very welcoming of you and your partner. I’m aware of only a few gay parents in my neighborhood, but I would not be surprised to learn that there were many more who just blend in with all the other families.

In terms of schools, I would recommend checking out the school guide that is put out by the Seattle Times. Seattle has some really great schools and some schools that probably won’t meet your expectations. While high test scores probably shouldn’t be the only way a school is judged, knowing this information can help weed out the schools that you would find unacceptable.

In addition to finding an appropriate school, a very relevant question is how much you are willing to spend on a house. A starter home in most neighborhoods in the City start at around 350k-400k. If this seems reasonable to you, then you should have no problem finding an appropriate home in a wonderful neighborhood.

Do you have a better answer for this question? Are there any neighborhoods that this family should definitely be considering? Are there some special resources that might make the transition easier for this family should they move to Seattle? Please share your knowledge in the comments section!

Inbox: Where to Live Within Biking Distance of UW?

Sasha With BikeI had someone email me the other day with an interesting question, and I thought I would share my response… and then see if anyone in the community could improve upon it.

Question: I’m moving to Seattle and interested in finding a neighborhood where I can bike to my work at the University of Washington (UW). Where should I be looking?

My Answer: There are a bunch of great places to live in North Seattle that are within biking distance to the UW. I would stay away from the south part of Seattle because there are not a lot of good north-south bike route through the downtown… (too many hills and not enough dedicated bike lanes).

Seeing as how I live in North Seattle and I bike a lot, I end up referencing the bike map put out by the City of Seattle quite often. Here is a direct link to the bike map of North Seattle (*.pdf), but note that this is a large file (1.5 MB). If you download the map, you’ll notice that the Burke-Gilman trail (a solid red line) goes through the UW campus. The Burke-Gilman is a wonderful commuting trail and has been recently expanded to the north-west all the way to the Golden Gardens Park. If you can find a place to live within a short ride to the Burke-Gilman, then you will have an easy ride to work!

By the way, if you follow this link, you can order a free hard-copy of the bike map: http://www.ci.seattle.wa.us/transportation/bikemapform.htm

Do you have a better answer for this question? Are there any neighborhoods that are particularly attractive for bicyclists? Please share your knowledge in the comments section!

Skyping for Real Estate

Skype The New York Times reports that EBay bought Skype for $2.6 billion yesterday.

Are you familiar with Skype?
It is a great service that I’ve been using extensively in the last few months to talk with people all over the world (and in particular my family in Russia!). The sound quality is at least as good as a land-line and definitely better than a cell phone!. And the best part is that it is free to talk to another Skype user! If you are interested in skyping me, just send me an email and I’ll happily pass along my Skype name!

One of the ways that I think Skype could be useful would be in connecting me to people thinking of moving to Seattle. If you are interested in learning more about Seattle real estate, then definitely consider connecting with me via Skype!

I know I’m not the only one thinking of using Skype for business purposes. According to NY Times their revenue is expected to grow from an estimate of $60M this year to about $ 200M in 2006. E-Bay sees this communication technology making on-line trading easier “particularly with transactions involving real estate, big-ticket purchases and services that require detailed conversations.”

“I’m a big believer in focusing brands and businesses that are in very large markets,” Ms. Whitman said by phone from London. EBay is “absolutely not” interested in developing a portal, she said. “You can be sure we’re going to focus on e-commerce.”
In addition to the basic service, about two million Skype customers have signed up for a pay service that allows them to use their computers to make calls to regular phone numbers as well as receive calls from landlines and cell phones. To complete these calls, Skype pays phone companies small per-minute fees.

They also give an interesting statistics as that only 13 percent of Skype’s users are in North America; nearly half are in Europe and another quarter are in Asia.

Some industry specialists said eBay’s purchase of Skype was a sign that voice calls would increasingly become one of many services that Internet companies would provide, rather than a stand-alone business.

“This turns the entire telecom industry picture on its head, and demonstrates that voice, presence, text messaging and other I.P.-based applications will be essential for the company of the future,” said Jeff Pulver, the chairman of pulvermedia, which promotes Internet-based phone services.

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!

Buyers and Sellers: Help is on the way…

I’m pretty sure that many real estate agents wouldn’t want to hear this, but the real estate industry has been very effective at protecting their own self-interest at the expense of home buyers and sellers. There are so many useful tools that could be built, but valuable real estate data is hidden behind thick walls! But rather than focus on the problems of the industry, I’d like to spend a few minutes talking about the future…

If you’ve been reading Rain City Guide long enough, you probably know that last May I put together the first home search (“gHomes

One good faith estimate isn’t good enough…

[photopress:Cats.JPG,thumb,alignright]In reading Elizabeth Rhodes response to an interest-only loan question, I realized that it has been a while since I talked about my uncomfort with interest only mortgages… I think way too many people are using them as a last resort to get into a house. When interest rates start rising, a lot of people could find out that they have bitten off more than they can chew.

The particular question Elizabeth was answering was in regards to whether or not someone should stick with a mortgage broker that made them feel uncomfortable… She gave an appropriate response (concluding that the client should walk away from this broker) but missed out on giving some truly useful advice that could really minimize this issue. What she could have said: “Get more than one quote!” or “You’re making a mistake by using only one broker anyway.”

In practical terms, “getting more than one quote” means getting at least two good faith estimates. At a minimum, you should get an estimate from at least one on-line banks and one local broker. If I ever create my own set of top 10 rules for a home buyer, getting two good faith estimates would be at the very top. No one has to tell you that you’re making a huge investment when you buy your home. By making loan brokers compete, it is entirely possible to get a much lower rate. Even saving just two-tenths of a percent on your loan can add up to thousands of dollars in the long run.

If you want some more detail, I wrote a bunch more on getting a home loan last March that stills seems relevant.

How Risky is the Seattle market?

Sasha getting ready to jumpA national mortgage company, PMI Group, recently came out with a real interesting study that lists the riskiest housing markets in the US. Interestingly the Seattle market ranked #45 out of 50 largest housing markets and it is the only west coast city that ranks in the bottom 10 riskiest areas. Here’s what they had to say about Seattle:

Seattle, WA has also seen its risk decline considerable. It is now the only West Coast MSA among the ranking’s bottom 10. Employment in the metropolitan division is still down by 80,000, or more than 5%, from its peak in the late 2000, but the labor market is gaining momentum with a growing service sector and information industry. The area’s homes have gained 11% in the market value in the last four quarters, while its Market Risk Index value dropped from 84 to 64.

Digging into the report, it says the risk index uses “information on past house price growth and variables measuring employment and unemployment, as well as local income measures and interest rates.” It’s always good to get some positive numbers on our local market!

Considering how much home prices have gone up recently in the Seattle market, I was surprised at the results of this study… None the less, it is pleasing to read that the area’s economics are so deathly as to dwarf the risk of the higher home prices (at least compared to other cities in the US!).

(via Dean Foust at Hot Property)

UPDATE:

CNN picked the story up today and mentions that Seattle home owners can breathe easy knowing that the Seattle market ranked the safest (least riskiest!) in the West.