Real Estate Data

Our latest National Housing Market Report is out. This one examines data through end of July 2008. You can download the PDF here.

Here's the press release:

Real Estate Report: National Housing Prices Down by 0.8% in July

Report measures current real estate data in major markets around the country. Data shows Las Vegas continuing to lead as the weakest US housing market with real estate prices down another 4% in July. Current real estate data shows some summertime price stability in Midwestern markets Detroit, Cleveland, Indianapolis, and Minneapolis

MOUNTAIN VIEW, CA August 5, 2008 - The Altos 10-City Composite Price Index showed a decline in asking prices of 0.8% in July and 1.3% for the past three months. Prices of properties listed for sale fell in 13 of 26 major markets according to the Real-Time Real Estate Report, published by Altos Research, the premier source for real-time real estate data, and market analysis consultancy Real IQ.

Asking prices fell at the fastest rate in Las Vegas - down 4.0% during July - and 7.5% over the most recent three-month period for an annualized rate of 30%. Listing prices rose at the fastest rate in Detroit - up 4.8% in July - followed by Cleveland where prices were up 2.7%. Prices were also up slightly in the Midwestern markets of Indianapolis and Minneapolis.

"While prices continue to fall in coastal and Western markets, prices appear to have stabilized in Midwestern markets that were previously declining," said Michael Simonsen, CEO and co-founder of Altos Research. "The real test will come in the fall when markets typically experience a seasonal slowdown which will be exacerbated by high job losses and foreclosures."

Asking prices fell at the fastest rate in Las Vegas - down 4.0% during July - and 7.5% over the most recent three-month period for an annualized rate of 30%. Listing prices rose at the fastest rate in Detroit - up 4.8% in July - followed by Cleveland where prices were up 2.7%. Prices were also up slightly in the Midwestern markets of Indianapolis and Minneapolis.

Listed property inventories declined with the 10-City Composite markets showing a decrease of 2.0% in July. Inventory rose in just 6 of 26 markets with the biggest decreases occurring in Detroit and Cleveland.

"Broadly declining inventory is a positive sign in the near-term, particularly for the Midwestern markets which all showed inventory declines," said Stephen Bedikian, partner and research director for Real IQ.

For the Altos 10-City Composite, the average days on market was 111, a slight increase from 109 in June. Thirteen of 26 markets had an average days-on-market of 100 or more. By far, the market with the slowest rate of inventory turnover was Miami at an average of 156 days-on-market, nearly a full month more than the next slowest market - Tampa. Austin led all markets with the fastest rate of inventory turnover at an average of 78 days-on-market.

Data in the Real-Time Housing Market Report is based on analysis of over one million properties currently listed for sale in 31 metropolitan markets across the country. The report is the most timely source of housing market data on current market activity.

The report examines housing pricing, inventory levels and market conditions in 31 major U.S. metropolitan statistical areas (MSAs): Atlanta, Austin, Boston, Charlotte, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Las Vegas, Los Angeles, Miami, Minneapolis, New York, Phoenix, Portland, San Diego, San Francisco, Seattle, Tampa, and Washington, DC. The Real-Time Real Estate Report is released every month.

Altos scores the big spread in BusinessWeek today! I was really happy to fulfill this request. The folks at BW wanted a national real estate slide show that wasn't just yet another chronicle of the market meltdown. They wanted to see where things were good too. Grown weary of all-bad-California-all-the-time, they also asked to take a look at 20 or so major metros around the country. So we suggested that we pick a nice sampling of metros, and then find the best and worst performing zip codes in each (in terms of median home price over the last year.)

And you know what? We found some very interesting trends. Aside from poor Las Vegas, we are able to find some healthy pricing trends in every metro we sampled.

What do the up markets have in common? Well, almost without exception, they're the nice parts of town. The biggest down zip codes? Again almost without exception, the hardest hit markets are the cheapest parts of town.

The phenomenon is working like this: There are a few folks who are well financed, and they for the first time in years, get to buy in the best neighborhoods without a ton of competition. Mortgages are still historically cheap, if in fact you can get one. While at the low end, no one can get financing, and of course those with the craziest mortgages are now selling or foreclosing. The mayhem starts at the bottom.

Check out the full article. Fascinating reading.

Over the past couple of years, we've built our client base with realtors and investors, buyers and sellers, with appraisers and traders, with planners and researchers.

During that time, our products for those folks have taken the form of either detailed analytical reports or simply raw data. Either we do all the analytical work, or you do it.

More and more though, we found that there is a big group of people who need an easy way to solve more unique problems than we can possibly address in our pre-designed local reports, but these folks have neither the time nor the experience to sift through the mountains of real estate data on their own.

We realized we needed a product that lets our clients easily query the vast Altos Research database to get the specific answers they need, and use the output in any number of different ways. Thus AltosXplorer was born.


AltosXplorer is for you if you've ever looked at our report products and said, "I don't need just one city, I need to be able to investigate any stat for any zip in the whole area (region, state, country)." Think about the investor who has opportunities that may come up anywhere in Florida, and wants to quickly compare two markets when a new deal arrives.

Or consider an appraiser who works all over Chicagoland. Any given day he needs to illustrate just a couple of key measures in a neighborhood to augment the rest of the data in his report.

For our Realtor clients, AltosXplorer is a lot of fun too. Previously, in order to use our AltosCharts you needed to formulate a long URL to get the right chart. With AltosXplorer, you build the chart you want with just a few clicks and then click, copy and paste! (See Kris Berg's first foray for the perfect example of how AltosXplorer was intended for our Pro clients.)

Can you tell we're giddy around here? I could go on and on but I'll wrap in a single (albeit multi-claused) sentence:

AltosXplorer is a rich internet application that enables you to do your own analysis, create your own trend AltosCharts, on our full database, and export the data to your own analysis in just a few clicks.

Learn more here. Try it out here.

Enjoy.

Oh my.

Three of four homes for sale in Stockton are in- or on the path to- foreclosure.

We released our National Real Estate Report today. Here's the press release.

Real Estate Report: Housing Prices Down By 0.5% in June

Report measures current real estate data in major markets around the country. Data shows Las Vegas the weakest US housing market with real estate prices down 3.6% in June. Current real estate data shows Denver the strongest US housing market in June with prices up fractionally over May 2008.
MOUNTAIN VIEW, CA July 8, 2008 - he Altos 10-City Composite Price Index showed a decline in asking prices of 0.5% in June and 0.8% for the past three months. Prices of properties listed for-sale increased in 15 of 26 major markets according to the Real-Time Real Estate Report, published by Altos Research, the premier source for real-time real estate data, and market analysis consultancy Real IQ.

Asking prices fell at the fastest rate in Las Vegas - down 3.6% during June - and 7.2% over the most recent three-month period. This is the third consecutive month that Las Vegas has held that dubious honor. Listing prices rose at the fastest rate in Denver - up 2.6% in June and 6.4% over the most recent three-month period.

"While the Composite Index continues to show price declines, the rate of decline has slowed recently and more than half of the markets we track are showing sequential asking price increases over the past three months," said Stephen Bedikian, partner and research director for Real IQ. "Housing markets are local, and this downturn remains largely confined to specific geographic areas of the country with four states in particularly bad shape: California, Florida, Nevada and Arizona."

Listed property inventories increased substantially with the 10-City Composite markets showing an increase of 5.7% during the past three months and 1.9% in June. Inventory rose in 17 of 26 markets with the largest jumps in Los Angeles and San Diego, up 8.7% and 6.1% respectively in June.

Data in the Real-Time Housing Market Report is based on analysis of over one million properties currently listed for-sale in 26 metropolitan markets across the country. The report is the most timely source of housing market data on current market activity.

For the Altos 10-City Composite, the average days-on-market was 109, a slight increase from 106 in May. Eleven of 26 markets had an average days-on-market of over 100. By far, the market with the slowest rate of inventory was Miami at an average of 154 days-on-market. Austin led all markets with the fastest rate of inventory turnover at an average of 72 days-on-market.

"Inventory continues to increase which is typical during the seasonally strong spring and summer seasons," said Michael Simonsen, CEO and co-founder of Altos Research. "The true test will come in the fall when the market experiences seasonal weakness. If inventory, especially foreclosure listings, piles up too quickly, prices may start declining broadly again."

The report examines housing pricing, inventory levels and market conditions in 31 major U.S. metropolitan statistical areas (MSAs): Atlanta, Austin, Boston, Charlotte, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Indianapolis, Las Vegas, Los Angeles, Miami, Minneapolis, New York, Phoenix, Portland, Salt Lake City, San Diego, San Francisco, San Jose, Seattle, Tampa, and Washington, DC. The first report was published December 7, 2007 and is released every month. Report downloads are available at: www.altosresearch.com.

Yesterday I wrote about Chicago's dubious distinction as the most socially regulated city in the US. I argue that trend does not bode well for the creative class, the city's future prosperity and ultimately its real estate values over the long haul. However today I came across a glowing article on Chicago in Fast Company, calling it "City of the Year". Indeed it's a city I love, so let's look at the positives.

Fast Company lauds some of the city's social restrictions as forward thinking "Greening" efforts. (Ironically they also posit that the city's position as anchor of 20th century architecture happened here because there was "no one to tell [the developers] to do it differently.")

Construction Booms
Most of what FC is happy about though derives from, Chicago's marvelous growth spurt. The city is the fastest-growing non-Sun Belt city in the US. The economy is growing faster than New York or LA. Immigration remains strong from all over the world.

While highrise condo development has slowed from it's frenzied pace a few years ago, I'm still excited about the Chicago's recent construction boom. The famed skyline is remains one of the most moving in the world. And its development continues. (I highly recommend the Chicago Architecture Foundation's boat tour if you have 90 minutes to spare while you're in town.) Between the 150-story Chicago Spire and the new Trump tower (who let him in there?) the city will remain on the forefront of skyscraper architecture.

With all this development, it's worth a look to see how the downtown Chicago condo market is holding up. Here's a handful of zip codes:


Let's look at demand rates also.


Like much of the country, the most desirable parts of town have (those with the higher prices already) show reasonably consistent demand and stable prices. This is not the case as you leave the hot neighborhoods.

So what's in store for the City? Construction, investment, and immigration warm my heart. Laws to dictate my diet chill me to the bone. The good news is that buildings last a long time. Bad laws can be as ephemeral as the foie gras they're restricting. Let's call this one a net positive.

Rock on Chicago.

Link: Chicago Real Estate Data

Checking out Andy Kaufman's blog this morning, I couldn't help but noticing the contrasting AltosCharts he's showing for Oakland and Berkeley California.

Oakland of course is the bigger city, but these next-door-neighbors share some parts that are virtually indistinguishable from each other. There are some spectacular parts of Oakland and sketchy parts of Berkeley and vise versa. But look at the home price trends over the last year.

Likewise look at the trends in inventory levels for the same to cities.

You couldn't have a clearer picture of the real estate pricing phenomenon we're seeing all over the country. It works like this:

• Demand is off everywhere and everyone knows it.
• So if you're a home buyer in the East Bay with good cash and good credit, you get your pick. In this case, Berkeley has generally better schools, more cachet, etc., so the buyers go there first.
• There's enough demand to keep the market afloat.
• If you don't have good cash and good credit, you get nothing. There is literally no spillover demand for Oakland.
• A few years ago, a home buyer might look to the nicer neighborhoods in Oakland for additional inventory or a lesser school-premium price. Not the case any more.

Actually, I'm sure we could dig through the zip code level data in Oakland and illustrate a similar phenomenon within the cities themselves. But this particular story jumped out at me this morning, so that's what gets covered.

Altos Links: Oakland real estate data, Berkeley Real Estate Data

The other day, I highlighted the announcement from Bob Shiller's MacroMarkets to list exchange traded funds on the housing market. I've now had a chance to investigate more deeply and I'm giddy like a schoolgirl. (Albeit an incredibly geeky schoolgirl, but giddy nonetheless.)

First, some foundation as to why this matters.

In all businesses you have risks you can control and costs you can't: food, energy, interest rates, etc. For those costs, it makes sense to hedge. Successful jet fuel hedges are a big reason Southwest Airlines is the strongest in the country. Consumer products (e.g. cheaper airline tickets, wacky mortgages) get created on the foundation of these tools. (i.e. derivatives are a good thing.) Speculators can also participate - they add potential return to their portfolio where a hedger removes risk. Speculators create liquidity for the hedgers. (i.e. speculators are a good thing.) Financial derivatives, futures, options, swaps, etc. exist in nearly every asset class to solve these problems for people.

Likewise, lots of people and companies have real estate "exposure". This is a $21 trillion asset class people. You should be able to hedge. Especially now, people realize housing prices don't always go up. But before 2006, there were no financial products that let you hedge your real estate risk. And the only way to speculate was to buy investment property.

In 2006, MacroMarkets introduced, on the Chicago Merc, housing derivatives. Unfortunately it turned out that there were practical limitations on the housing futures that prevented nearly all potential "end-users" from participating. (The big banks could trade amongst themselves, but how fun is that?) Namely, you need big capital requirements, special trading accounts, most of the time you need a broker-dealer on the other side of your trade, and the payoff is not significantly leveraged. Perhaps I was a bit harsh to characterize MacroMarkets as having "dropped the ball" but, as of today, mere mortals basically still can't hedge their real estate risk. So how do you eliminate these hurdles?

Enter Exchange Traded Funds

ETFs are securities that trade like stocks on stock exchanges. You can play the oil price trends or diversified stock market positions simply buy buying a single "stock".

Here's how MacroMarkets' new ETFs ("MacroShares" as they call them) work for the housing market:

• The shares will list on the NYSE Arca. You can buy them from any brokerage account, like you would any stock.
• They're designed to follow the Case Shiller Index - specifically the CSI 10-City Composite, the national index. more on the implications of this below.
• The shares are issued in pairs: ticker symbol NYSE:UMM goes up when housing prices go up, NYSE:DMM goes up when housing prices go down.
• Like any stock, there's a market specialist so you always have price liquidity. You don't need to line up Goldman or Merril to take the other side of your bet.
• The shares have a par value of $25/share so when the market is heavily bearish the DMMs will trade at a premium to the $25.
• They have a 10-year horizon so you can play the longer term cycles of the housing market.
• The underlying assets get parked in short term US Treasuries, so the securities actually return a quarterly dividend.
• So the very easy trade is if you're bearish, simply buy the DMMs. Think you're seeing the bottom? Buy the UMMs. Ahh... simplicity.

Exercise some caution however, because there are nuances of how these things will behave. Namely:

• They trade in pairs that offset each other. This means if home prices double, the DMMs will go to zero and the security closes out. This happened in MacroMarkets oil MacroShares this year. AMEX:UCR and AMEX:DCR. (Those securities have market values in the billions now, so people are obviously adopting them as useful instruments.)
• That means also that the upside is limited to a 100% move. You can improve your return with margin leverage like any stock.
• As these things approach close (because of A. time or B.100% market moves) the pricing will exhibit optionality. They'll behave less like the market and more like an option.
  

But is the Case Shiller Index Useful?

The remaining challenges for these products are oriented around the data. It's easy to bitch about the Case Shiller Index: doesn't include condos, or new construction, or flips, etc., etc., etc. Add in local market peculiarities and a lot of people wonder if the CSI actually measures the housing market.

My take on this argument is that Case-Shiller is not useful for making a home purchase decision. But that doesn't preclude its usefulness in financial instruments. The fact is that the CSI 10-City Composite peaked in June 2006, and that's widely regarded as the national turning point for this housing market cycle.

The classic example of the localness problem came when Brad Inman asked Bob Shiller on stage and his conference in Miami, "So let's say I bought a $2 million home in Sausalito in 2005. How would I hedge that?" Ill distill Shiller's 10-minute-Yale-finance-prof reply into two words for you: "You can't."

With Given that these new securities are based on the CSI 10-City Composite, which is down strong in the last 12 months, they're not going to be helpful to hedge in Sausalito, which is doing just fine, thank you.

But if you're a reasonably diversified investor, brokerage, lender, builder, supplier, or yes, even if you're a speculator, this is a great way to measure US housing broadly. Given success in the market, there's no reason why they can't list regional funds too at some point in the future, to get a little closer to home.

Finally, of course, the backward-looking nature of all typical housing market data presents opportunities for clients of the Altos real-time real estate data. Rock on.

This is big, folks. Huge.

I don't imagine that this innovation is going to save anyone from foreclosure. But we're looking at the only effective way to manage your real estate assets without physically selling off properties. Think about that. Won't that be amazingly useful?

Look for these to get listed sometime in Q3 or Q4 2008. You can be sure that we'll be watching, and of course publishing data to help you trade.

More coverage: Here, here, and here.

MacroMarkets today announced that they'll be issuing New York Stock Exchange-traded securities for investors to play the US Housing Market. From the press release:

MacroShares Housing Depositor, a subsidiary of MacroMarkets LLC, filed with the Securities and Exchange Commission for exchange-traded securities
that will allow investors to invest in the upward and the inverse movement of U.S. home prices. MacroShares Major Metro Housing Up and Down securities will be based on the S&P/Case-Shiller Composite-10 Home Price Index and will allow investors to access this important, but illiquid, asset class. When launched, these revolutionary paired securities will have a ten-year term and will feature a 2x (200%) leverage factor. MacroMarkets LLC plans to launch the new securities on the NYSE Arca under the ticker symbols:

• UMM- MacroShares Major Metro Housing Up
• DMM- MacroShares Major Metro Housing Down
  

Looks to me like an ETF, which would be ideal for lowering the transaction costs and the capital requirements that have been dogging the commodities-exchange traded securities. ETFs, remember are exchange traded funds so you can invest pretty directly in an underlying asset class. In oil, for example, you can trade with the ticker symbol USO traded on the Amex.

In the couple years since launching the Chicago Merc-traded housing futures based on the S&P/Case Shiller Index, MacroMarkets is widely acknowledged to have dropped the ball. The traded volume on these markets is tiny and was restricted by steep license fees that MacroMarkets tried to extract from the Street. This winter, MacroMarkets sold to S&P the master license of the Index and droped the license fees. That was Step One. Step Two is to get products into the hands of the people who can use them. It looks like MacroMarkets is focusing on Step Two. Let's hope they learned their lesson and this product gets the volume it deserves.

While we have yet to see these securities trade on the NYSE, they're based on the Case Shiller 10-City Composite, which is good news for Altos (and our customers). We publish the Altos 10-City Composite which, whattya know, follows the same 10 cities.

Our Real Estate Derivatives weekly report is now available to subscribers who want to know where these indexes are heading with a 90-day lead. Beyond just pricing, the reports dive into all the detail real estate data: supply and demand levels, turnover, etc. If you're interested, contact us.

Meanwhile, I'm keeping my fingers crossed to see some trading volume.

We released the latest National Real Estate Report today. You can download it here [PDF].

The data inspects 26 metro markets around the country and tracks home prices, inventory and days on market. We also track the Altos 10-City Composite for a National perspective on the trends.

Here's the press release:

HOUSING PRICES DOWN BY 0.3% IN MAY

Listing Prices Fell in Only 11 of 26 markets

MOUNTAIN VIEW, CA � June 10, 2008 � The Altos 10-City Composite Price Index showed a decline in asking prices of just 0.3% in May. Prices of properties listed for-sale increased in 15 of 26 major markets according to the Real-Time Real Estate Report, jointly published by Altos Research, the premier source for real-time real estate research, and market analysis consultancy Real IQ�.

Asking prices fell at the fastest rate in Las Vegas - down 3.7% during May and 6.5% over the most recent three-month period. Listing prices rose at the fastest rate in Denver up 3.7% and Dallas up 2.2% during May. Prices increased by more than one percent for the month in 11 of 26 markets.

"The weakest markets continue to be concentrated in Florida, California, Arizona and Nevada which all experienced the fastest price increases during the boom times," said Michael Simonsen, CEO and co-founder of Altos Research. "Now these same markets are outpacing others on the downside as foreclosures and price declines continue relentlessly. We�re seeing some stability in many markets outside of these hard-hit states."

Listed property inventories increased substantially with the 10-City Composite markets showing an increase of 7.9% during the first quarter and 3.7% in May. Inventory rose in 25 of 26 markets with the Miami market being the only exception. Inventory actually declined 1.3% in Miami during May and 2.4% during the past three months.

Data in the Real-Time Housing Market Report is based on analysis of over one million properties currently listed for-sale in 26 metropolitan markets across the country. The report is the most timely source of housing market data on current market activity.

For the Altos 10-City Composite, the average days-on-market was 106 � an improvement from 111 in April and 113 in March. Miami experienced the longest time-on-market span with an average days-on-market of 152. San Francisco led all markets with the fastest rate of inventory turnover at an average of 73 days-on-market.

"Continued growth in inventory across virtually all markets will restrain near-term price increases," said Stephen Bedikian, partner and research director for Real IQ. "Markets like Denver and Dallas are showing strength because they did not experience high price inflation during the boom and are showing only limited inventory growth now. Affordability and limited inventory are the keys to a healthy market."

The report examines housing pricing, inventory levels and market conditions in 31 major U.S. metropolitan statistical areas (MSAs): Atlanta, Austin, Boston, Charlotte, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Indianapolis, Las Vegas, Los Angeles, Miami, Minneapolis, New York, Phoenix, Portland, Salt Lake City, San Diego, San Francisco, San Jose, Seattle, Tampa, and Washington, DC. The first report was published December 7, 2007 and is released every month. Report downloads are available at: www.altosresearch.com.

We're have an internal game here at Altos - Guess the San Jose Market Bottom. It's quite clear that you can't predict the market bottom by looking at the price chart alone, but what else should you look at? Inventory provides a clue. Check this out:

The seasonal cycles are pretty clear, no? Usually there's a summer plateau in the number of homes for sale, then properties drop off through the winter.

The question is, Is that the first inkling of a summer plateau this year?

If inventory levels flatten out this sumer then maybe, just maybe, the worst of the carnage would be over. That inventory could work its way out over the next couple years. What do you think? Is the recession going to make this chart jump even higher this fall?

Here's where you can keep an eye on the live San Jose real estate data.

MacroMarkets released the monthly Case Shiller Index today. Case Shiller tracks repeat sales of single family homes. Like most real estate data (except ours of course) the Case Shiller lags the actual market by several months. This is data for March 2008.

CSI March 07 CSI Feb 08 CSI March 08 Feb 08 v Mar 08 Mar 07 v Mar 08 Boston 168.52 160.31 158.54 -1.10% -5.90% Chicago 167.04 153.33 150.35 -1.94% -10.00% Denver 134.20 127.50 127.43 -0.05% -5.00% Las Vegas 228.55 177.18 169.31 -4.44% -25.90% Los Angeles 264.58 214.83 207.11 -3.59% -21.70% Miami 276.89 218.74 208.88 -4.51% -24.60% New York 212.39 198.46 196.58 -0.95% -7.40% San Diego 233.28 190.34 185.44 -2.57% -20.50% San Francisco 211.09 174.54 168.38 -3.53% -20.20% Washington DC 237.14 207.05 202.34 -2.27% -14.70% 10-City Composite 219.67 190.58 186.06 -2.37% -15.30%

So what does the national real estate market look like right now? Here's the Altos 10-City Composite as of the end of May 2008. You'll be seeing this data in the Case Shiller Index in three months.

As a bonus, let's look at the Denver chart. The Denver metro actually defied the national carnage until October of last year. Case Shiller picked that up too and you can see that Denver is the smallest of the declines in the sample. We've actually seen a small uptick in Denver pricing this spring. (Don't be fooled by the scale on this chart. With the tight scale, it looks like a rocket, but it's only a few thousand dollars difference.)

See also:

• This post about trading real estate derivatives on the Case Shiller Index and our real time data.
• To inquire about our Weekly National Market Report: email us

Two very cool announcements today from Friends of Altos - both are great examples of real estate data helping people make better decisions in this crazy housing market. I just love this kind of innovation.

Krunching.com

First up is Krunching.com: These guys built an investor-focused site with tons of data about properties for sale, investor metrics, property analysis. You can tell it was built by real estate investors answering their own property analysis questions. The site is super-fast and really pretty (in a web 2.0 sense.)

If you're an investor, Krunching is going to be a powerful tool for you. They're taking a freemium business model - they give away a bunch of great data for free and their power users sign up for paid services. They've built Altos local real estate data and analysis into their premium services, so if you don't buy from us, you can get our data in your Krunching subscriptions. My only complaint is that they've used an OFHEO regional chart on their investment summary page. The feds are telling us what happened to home prices in September. Thanks guys. (Hey Brian - you need an AltosChart on that page! Get with the program!) Krunching is only available in California right now, but it's a great start for a national product. Great job guys.

Homethinking Mortgage

Also launched today is a really cool mortgage market analysis product from longtime Altos partner Homethinking.com. I get questions every day from people trying to understand the scope of the mortgage crisis. The Homethinking guys have taken a huge pile of mortgage data and presented it in a super-clean, very powerful visual interface. Want to know how much exposure your town has to sub-prime loans? Homethinking will tell you. Want to know what percent of mortgage applicants are rejected? Check it out. Huge amounts of information in here. Again, thanks to the feds, this data is a year old. Still, it's better information than the world had access to yesterday. So kudos to Niki and team at Homethinking. Looks fantastic. And it comes in cool embeddable widgets!

We did this fun infographic for the Boston Globe's spring real estate section last week.

City/Town	Average days on market	Median price
1. Watertown	63	$476,911
2. Needham Heights	72	$661,418
3. Arlington	73	$623,993
4. West Newton	80	$947,661
5. Reading	84	$449,514
6. Jamaica Plain	84	$658,687
7. Somerville	85	$338,882
8. Waltham	85	$389,807
9. Newton Centre	86	$924,786
10.West Roxbury	87	$432,925

What we found mirrors much of the rest of the country: the close in, nice neighborhoods are where the demand is. Go further out and time-to-sell a home climbs into the many months range.

Click on any city name for the real estate report for that town.