Tracking Homebuyer Activity

Last week an agent said to me, “I have had the same 6 or 7 buyers and sellers for the last 4 months.”  Reminded me of a waitress who couldn’t “turn a table” because the same people stayed all night long.

I decided to track homebuyer activity to see how many buyers who have been looking at homes for the last 30 days or so, have purchased one.  The little blue box on the doors of homes for sale tells us which agents have shown the property.  If you take that agent’s code number and plug it into the MLS, you can tell if that agent is involved in a pending or closed transaction in the same period of time. It’s not an exact science, but let’s see what we can find out.  As usual, I’m doing this in real time by tracking the agents as I write the post.

I pulled the records of 6 of my listings and the 56 showings by 48 agents they have had in the last 30 days or so.  34 of those 48 buyers have bought nothing. 2 bought my listings.  12 bought other properties (see below).  One of my listings in escrow during the same timeframe was purchased by the neighbor, so that pending transaction had no agent showing.  I’m not counting the times I showed the property myself or people who came through during an Open House.

Agent #1 showed the property 3 X in 2 days.  If you take the code # of the agent and plug it into the system, you will see that two days later that agent opened an escrow on a property that cost $250,000 more on a similar house nearby.

From that we can assume that the buyer of Agent #1 was weighing the choice of buying a fixer or spending $250,000 more for a similar home assessed for only $25,000 more.  It’s not unusual for someone to want a home that needs no work.  But spending $250,000 more to get one, is not all that common.  Especially one that doesn’t have more bedrooms or more bathrooms or much more square footage and is not in a better location.

Agent #3 showed the property twice and then the buyer purchased a newer townhome on the Eastside instead of a fixer single family home in Seattle.  This buyer spent $100,000 less.

Agent #5’s buyer bought my listing in Rivertrail in Redmond.

Agent #16’s buyer bought the house behind my listing in Seattle on a 2,800 sf lot vs. a 5,000 sf lot, listed for $6,000 less.  The price differential could have been $20,000 at the time.  I have to check the date of the showing vs. the date of the price change and the date the home behind it went into escrow.

Agent #19’s buyer bought a single family home in Downtown Kirkland vs. a townhome in Redmond for almost double the price.  (This one is more likely a different buyer with the same agent. Most of the agents listed as their buyer buying “Nothing” are agents who sold nothing at all, so it’s easier to be almost positive.  Though those 34 buyers could have bought something with a different agent, that’s not likely given the short timeframe tracked.

Agent #21s buyer went further south and bought a single family home instead of a condo for about $20,000 more.

Agent #22s buyer bought an “income qualified affordable ARCH” condo.  $20,000 more for twice the size and 1 additional bedroom.

Agent #24s. buyer bought a new townhome instead of an older craftsman that needed updating.

Agent #25s buyer spent $100,000 more and bought a house that needed less work.

Agent @26s buyer bought a condo in Capitol Hill vs. a fixer home in Green Lake.

Agent #28s buyer bought a newer home further away from Microsoft for $25,000 more (Newcastle)

Agent #36s buyer bought a new townhome (instead of an older SFH) further north in Seattle for $100,000 less.

Agent #37s buyer went to Shoreline vs. Green Lake and spent $100,000 less for a house that needed less or no work.

Agent #40s buyer bought my listing in Bellevue.

While I don’t intend to replace OBEO as “the expert in buyer behavior”, being able to track what buyers are actually doing, is a useful tool. This ability is only recent, as NWMLS just added the “selling agent” code ID to the data entered when registering a pending or closed sale.  It was the first (and only) thing I complained about back in 2004, and the change took place in June or July of 2008.  Many could not see the need to post the Buyer Agent info when recording a sale.

This feature offers an enormous advantage to our seller clients, who can now track via their listing agent, what the buyer did or didn’t do after seeing their home.

For listing agents, just write down the LAG# (agent code) of agents who show your listings.  Then you can track to see if they are putting anything at all into escrow…or not.  By seeing what the buyer chooses, you can determine if you need a price change, or if you need to make some condition improvements to your current listings.  There’s not much you can do if people don’t want a fixer and choose a new townhome instead. So before reducing the price based simply on time on market, assess the actual situation as carefully as possible.

Interesting side issues:

1)  Three of the agents are no longer agents at all, so I can no longer track them.  Showed my listing and then quit the business altogether 🙂

One of the agents’ buyers bought a Downtown Condo that had been on market for 4 1/2 months with no price reductions. Knowing WHY buyers are not choosing the property, by tracking their movements, can help owners decide whether you need to wait it out at the same price, or reduce the price.

Don’t buy into an automatic reverse auction of reducing the price every X days. Track what those buyers are doing, and plan and change your strategy accordingly.  A lower price isn’t going to turn a fixer craftsman into a new townhome.  Sometimes waiting longer for the right buyer IS the answer.  But if people are buying similar homes nearby for less…then a price reduction is in order.

Attack of the Killer Assessments

It was a warm & lovely summer evening… Our hapless hero goes through his nightly ritual of sorting the junk mail from the bills when stumbles upon his annual “Official property value notice” post card from the King County Assessor.

Before I actually looked at the card, I thought, this shouldn’t be too bad. The local real estate market has cooled down a lot in the past year. My appraised value should be flat (maybe even lower). Zillow thinks my house’s value has fallen by about 10% this past year. Cyberhomes thinks it’s fallen by about 9%. Eppraisal & Realtor.com doesn’t give me a historical chart, but their value ranges are realistic.

So I gaze upon my white post card of doom and see the following numbers…

APPRAISED VALUE

OLD VALUE

NEW VALUE

LAND

123,000

230,000

BLDGS, ETC

413,000

360,000

TOTAL

536,000

590,000

I then think, WTF? Why in the world has my land value gone up nearly 90%? Why is my total property value 10% higher than last year, despite the fact we are in a down market? Is the assessor catching up to the market? Did the assessor really blow it this badly in years past? Is this a work of comedy & horror to rival the cult classic of good garden vegetables gone bad?

So, I call the King County Assessor’s office, and they explain to me that the market sells it as one piece, but the assessor must value the land as if it were vacant. After the land value is determined, they determine the total value of the property. Then the land’s worth is subtracted from the total and the remainder becomes the value of the house. They tell me where to go to view the area report for the Issaquah Highlands if I want find out more about how they determined my property’s value.

I read the report and discover that the base land value of single family home in the Issaquah Highlands is $240,000 and that the appraised land value for Area 75 is about 56.7% higher than it was last year. OK, but it still doesn’t explain why my land value is nearly 90% higher than last year. Unless weeds are considered a land improvement or the definition of a square foot has changed in the past year, I still have no idea how they came up with that figure.

I usually read the Seattle Times, not the Seattle PI, so I didn’t see this coming! However, it’s nice to know, I’m that the only one confused about the crazy assessments this year. I haven’t decided if I’m going to get out my pitchfork and storm the assessor’s office yet, but I do feel the need to understand how they came up with their numbers. I’m sure it doesn’t help that Probably & Statistics for Engineers, wasn’t among the classes at school that improved my GPA when I was going to Cal Poly.

And if any program managers from Zillow are reading this blog post – there has to be a cool new feature idea in this experience somewhere. Your web site is very useful helping me buy or sell a home, but I really have no idea if land values really are what the county says they are. Besides, I pay property taxes on a twice a year basis, but I’ve only sold a home once in the past 10 years. Every time somebody’s assessment changes you could get more site traffic. Why can’t generating a Z-assessment petition be as easy as getting a Z-estimate? Just saying, there’s an opportunity here…

Predatory Upfront Loan Modification Fees

I’m troubled by a trend that I’m seeing.  Recently I’ve noticed that mortgage brokers/loan originators have become interested in learning about loss mitigation techniques. When I ask why, they say that they’re hearing there’s good money to be made doing loan modifications.  What? Wait a second. I thought loan modifications were done by the lender for free.

More and more spam is popping up in my spam bin advertising loan modification services, offered by loan originators so I decided to call one of these LOs today after sending an email late last night asking for more information and receiving no reply. 

This particular person goes by the title of “mortgage planner.”  On her website, she advertises a wide variety of mortgage products including the pay option ARM and the hybrid ARM (are those even available anymore?) but there’s nothing on her website about loan modifications. None of the staff bios show any experience in doing loan modifications. Here’s what I found out.  The upfront fee charged to the homeowner is $3500.  But the LO assures me that all the work is handled by attorneys, she says.  The borrower’s up front fee is placed into escrow.  If a request for loan modification is accepted by the lender for loss mitigation (statistics were offered that 93% of loans are being modified) the full fee is due.  If the loan does not get modified, $2,000 is refunded and the remaining $1500 is not.  I asked the LO why a homeowner wouldn’t just work directly with an attorney.  She said that she works with a network of attorneys with a high loan mod approval rate and homeowners are always free to hire their own attorney and not work with her.

I asked her how much of the $3500 goes to the attorney and how much of it she gets to keep.  Her response was, “why are you asking me that?” To which I replied, “because if the attorney is doing all the work, then I’m wondering how much of that fee is going to you.”  She said “Well I work with the clients. I put a package together and follow up with the lender.” I said, “but a few minutes ago you mentioned that everything is handled by attorneys.”  Of course at this point the conversation has turned a tad bit adversarial and she starts to probe deeper into my true intentions. My intentions are only to get closer to what’s really going on here. I need to know if this sort of gig is something that is a viable alternative for Realtors to know about when counseling homeowners in financial distress.  My intentions are to be able to help other loan originators evaluate whether receiving a referral fee on a loan modification is going to get them into trouble.  If I were to guess, I’d say that the LO earned $2,000 for a successful loan mod and the remaining $1500 went to the attorney. There are forums out there confirming my guess.

In some states, including Washington State, Mortgage Brokers and their LOs now owe fiduciary duties to consumers.  Fiduciary comes from the Latin word fiducia, meaning “trust.

Photo Synth will change real estate

Remember how we were once blown away by the amount of information on the web? The number of facts, rumors, discussions, and, well, the shear number of words that were generated daily?

The textual web is fascinating, but it’s yesterday’s news. The innovation now is the visual web. It’s already begun with Google Street View – you can look out the window of a virtual car on nearly every street in a metropolitan area now. Next up? PhotoSynth. We saw previews of it two years ago, but (holy smokes!) it will be real in 24 hours.

Photosynth takes overlapping photos and constructs a pseudo 3D scene out of them. More images: better scene. An agent could take 400 photos in a house and instead of virtual tours (or annoying video tours), users could walk themselves through the house.

I can only imagine it will get more powerful. Add some more horsepower and they could create scenes from video. Add some more horsepower and they could let you travel through time in a square – through all of the previous users “synths.” You’ll be able to wander off of Google’s Street View and into someone’s yard and, if they’ve uploaded photos, into their home. Creepy, but cool.

I will be very excited to use it. Once they’re “cool enough” to support my operating system. What is this, 1999?

nope.

no, you aren't

Watching trends in the daily market watch of the MLS

I’ve been keeping an eye on some of the daily trends in the MLS and have noticed for several weeks now that price reductions have now outnumbered new listings on an almost daily basis.  In past years, when almost all houses were selling fairly quickly, we noticed that a small percentage of houses required drops and there was usually a decent number increasing their prices.

Now, it seems that as days on market have increased for many sellers we are finally getting that reality check in place that was needed.  Granted, it does seem that the majority of these price drops are in the outlying areas of our MLS region, but the inner-city urban spots are not without their own new reality.

What I like right now is that we’re getting a nice balance of buyer and seller activity, which, for my own personal business/team, means that we’re likely going to be growing our business over the next year or more with some very nice results.

Sold, Sold and Sold again

One of the best ways to find accurate data as to home prices and appreciation levels is to find homes that have sold a few times recently, that have had no upgrades since the time they were built.

Sold New on 3/30/93 for $210,000

Sold again on 2/27/03 for $349,300

Sold again on 7/8/05 for $466,000

Sold again on 6/25/08 for $540,000

Appreciated by 66% in the first 10 years.

Appreciated an additional 33% from 2/03 to 7/05

Appreciated an additional 15.8% from 7/05 to 6/08

No granite countertops or stainless steel appliances.  No upgrades except maybe some updated paint colors.  A run of the mill 2,300 sf four bedroom 2 1/2 bath home in a good school district.

It was on the market for 75 days or so and had a $50,000 price reduction before it sold for $10,000 to $15,000 less than that.  Would it have been worth closer to the original $600,000 list price if the market hadn’t slowed down?  Probably.

Killer Views and Dog Poop – Short Sale

Given prices in the Seattle Area have not dropped to the extent of  most of the Country, people wonder why there are some deep discount short sales here.  Mostly those that have a deep discount are in worse shape than when the current owner purchased them.

Remodels gone bad…very, very bad.  If you know the house below, please don’t mention where it is or the address in the comments.  I can’t “advertise” another agent’s listing, but wanted to give you an idea of what a house looks like that will likely sell for $200,000 -$300,000 less than what is currently owed on it.

Often the work being done is substandard, in this case likely because of all of the beer being consumed while doing the work.

Often you will see a lot of new materials, like the travertine above, but partial and poor installation.  I think there were more broken pieces of travertine strewn about than there were full tiles laid.

Still, the view considerations suggest it may be a worthwhile project for someone, especially an owner occupant, if it sells close enough to lot value.

But rarely does anyone but an investor want the house with Killer Views and piles of dog poop.

Twitter is AMAZING

Over this past week, I’ve had the misfortune dealing with cable (Comcast) being down and just today, my email being out (an issue with Network Solutions).   Both times, I vented with 140 characters (or less) on Twitter.  Of course, I had to use my Treo to whine about Comcast.  But what happened in both cases really surprises me.   Apparently these big corporations have their own “David G’s” out there with their own Twitter profiles and alerts set up to address issues brought up on the internet.

Here’s my Tweet:

pulling out my hair…network solutions email seems to be down…argh! No emails for me.

And the response I received minutes later.

netsolcares @mortgageporter Hi this is Gerry from Network Solutions. I’m sorry your having issues. If you’d like to contact me I’ll see what we can do

I just got off the phone (after holding for over 11 minutes) with Gerry @ Network Solutions and they narrowed down what my issue was (too technical for me to explain) and the good news is, everything is back up and working.   And it’s the weekend.  I’m amazed.

The Comcast response and issue was very similar.   A “tweet” from me saying Comcast is out…no email or internet and this reply from “Comcast Scott” within moments

comcastscott @mortgageporter how often has this been happening? Can we help

Along with this one

comcastcares@mortgageporter Keep us updated

and

comcastscott @mortgageporter glad to help! Keep those tweets coming

By the way, if you have Twitter and you find your Comcast or Network Solutions services not working, you can always tweet these fella’s…they react quickly.  I am impressed and would have never pictured large corporations utilizing social networking this way.

So for all of you who are not utilizing Twitter because you think it’s a fad, I encourage you to check it out.  It is what ever you make it.  I’ve found it to be real useful for communicating what I doing during the day, like providing live rate quotes, in a consultation, writing a blog post, etc.  And I’ll post something “non-business” every once in a while like what I’m cooking up for dinner.

If you do sign up (it’s free and easy to do) please “follow me” or at very least, send me a tweet!

Seattle Real Estate Market – King County

To know if the market is getting better or worse, we have to expect something of the market.  That is the only way to know if the market is doing better or worse “than expected”.  Active markets anticipate.  If a company’s earnings are down to the same degree as anticipated and expected, there will be no change in prices.  So we have to expect something to happen, and this post is all about what I expect to happen in the King County – Seattle Area Real Estate Market.

To keep saying the market is down from peak for 3-5 years is both boring and of no value, and only fun ad nauseum for whiners.  I call that NSS (No Sh_t Sherlock) meaning no kidding the market is down from peak; that news is a year old now.  What’s next?

To those who hate it when an agent sticks their neck out and makes predictions, I say…go away then or get used to it or get over it.  Agents are paid good money to answer the question “Where is the real estate market going?”  If we only got paid to open doors and say “do you like this house”, we’d be paid $15 an hour.  That’s the going rate for a good real estate assistant. 

Sellers need to know if selling next year is better than selling this year.  Sellers need to know when they get an offer today, if that offer is or isn’t likely the best offer they are going to see in their timeframe.  Buyers need to know if they can sell in 1-3 years without taking a loss.  People need agents to have an opinion about the future, both the near term future and the foreseeable future,  They can’t simply rely on personal experience and say “well I’ve never seen that happen” because the future is not about the recent past.

The graphs below show what I expect the market to do as to volume, which will assist us in determining true Absorption Rate and knowing whether the market is getting better or worse (than expected). 

I’m calling Absorption Rate as of now, 10 months. Current inventory is 12,403 and I expect it to take 10 months from today for 12,403 Residential properties to sell in King County.  That also means it will be a Buyer’s Market until and unless we see inventory drop from 12,403 to 7,500.  That can happen by property selling, or sellers deciding to rent or withdraw from the marketplace, at a higher rate than properties are coming on market.  I expect that to start happening on September 1 and continue through year end.  Whether or not prices will continue to decrease into next year and beyond will depend on how close we can get to 7,500 properties on market by December 31st.

The two graphs below are a double check system.  On a month to month basis we would expect to see variance.  Sometimes August sales are higher than September, and sometimes September sales are higher than August.  So the double check is for the Quarterly sales stats to fall into the prescribed ranges within a reasonable variance.

I took the year notations off the monthly stats, as I don’t expect these numbers to change unless there are changes in the mortgage market that create additional buyers.  That could be lower interest rates and.or looser lending standards.  Until then, we have to learn to live with what we can most likely expect to happen.