Friday, March 23, 2007

Foreclosure Listings: 6,294

Total Asking Price: $1,147,017,933




Click on State for Detailed Foreclosure Listings.

State
Count
Total Ask Price($)
Median Ask Price($)
AL
75
7,329,600
77,900
AK
6
1,248,400
218,400
AZ
107
32,923,200
234,900
AR
30
2,101,897
54,400
CA
888
353,672,500
375,400
CO
223
35,902,000
137,900
CT
44
10,345,700
197,400
DE
2
414,800
207,400
FL
209
51,948,400
201,900
GA
442
62,901,000
108,900
HI
1
432,900
432,900
ID
5
1,826,500
194,900
IL
237
40,796,800
136,900
IN
265
18,909,980
43,900
IA
29
2,313,100
61,900
KS
49
5,701,000
89,900
KY
36
3,254,700
67,400
LA
20
2,047,000
72,400
ME
7
902,300
122,900
MD
35
10,485,100
283,900
MA
167
42,621,800
234,900
MI
934
80,205,896
59,900
MN
189
30,221,800
149,900
MS
52
4,076,255
59,400
MO
250
27,539,305
75,900
MT
1
219,900
219,900
NE
24
2,443,600
88,900
NV
188
66,520,700
307,900
NH
41
9,304,900
203,900
NJ
39
11,212,200
251,900
NM
19
4,638,100
134,900
NY
72
13,578,300
142,950
NC
114
12,113,400
71,400
ND
5
559,500
139,900
OH
379
23,751,400
49,900
OK
59
4,634,300
69,900
OR
7
1,371,500
227,900
PA
100
8,630,300
65,400
RI
27
6,237,300
210,900
SC
42
5,266,800
79,400
SD
4
455,600
108,900
TN
153
13,978,000
72,900
TX
470
67,247,700
110,200
UT
7
1,487,300
113,900
VT
1
102,900
102,900
VA
136
45,537,500
319,400
WA
29
7,056,100
168,900
WV
16
2,158,400
104,400
WI
59
8,390,300
122,900
WY
0


Total
6,294
1,147,017,933
123,900

35 comments:

rent2home said...

Good info. Hope we can plot a graph based on past data and make it more indicative..

dimitris said...

Yeah, I wish I had done this before. I will create a page that compares weekly changes in price/inventory.

Anonymous said...

This is great data. Thanks for putting in the time to do this.

Anonymous said...

I found another website:
http://spreadsheets.google.com/pub?key=pOSu8I1YrtgD6YqtUVBaINg

Q3CTF4 said...

I found another website:
http://spreadsheets.google.com/pub?key=pOSu8I1YrtgD


Thanks for that link! The trend is definitely up on foreclosures. I will take that data and include it here. Do you know if that site is going to be kept up to date?

wannabuy said...

So the question is...

When did they break $1 billion?

Keep up the good work,

Got popcorn?
Neil

Q3CTF4 said...

Thank you Neil. I estimate that the one billion mark was passed about a month ago. At this rate, CFC assets will should go to 1.5 billion by summertime, if not more.

synthetik said...

Thanks Neil, fantastic idea!

wawawa said...

dimitris, good job keep it going man.

Jonathan said...

I suggest putting "wishing" in parenthesis rather than after a "/". When I first read this I thought it was a ratio of some kind and only after reading your post over at Ben's blog did I figure out what you were trying to convey.

Q3CTF4 said...

You are right. I'll do that now.

Anonymous said...

You rock. This is a great bit of code.

Would love to see the data graphed!

Rob Dawg said...

Ahhh, yes. "Wishing Price." I feel all warm and loved. I'm thinking they are looking for 95¢ on the dollar and will ultimately end up getting 60¢ on the dollar on average.

Anonymous said...

I am not sure how to do it automatically:


There was one property that caught my eye in CFC list from last week. The asking price (wish price) was over $400K (I think it was $460K but not sure could be $440K).

Anyhow as I looked it up I found that it was sold and indeed in a day it was removed from CFC list.

The Price: $297K. Yes this is correct a drop of about 30% from CFC asking price.

http://www.zillow.com/search/Search.htm?addrstrthood=598%20South%20Lincoln&citystatezip=95437

Can you do script that automate the following:

Compare the list of REO o a list from a week ago, a month ago. Finds out what was removed go to Zillow and find out the price.

Sum up all the differences decline in price between asking price and actual sale price.

This should give us an idea on CFC losses as well as where Real-estate prices area heading.

If you need my help e-mail me

Anonymous said...

You really need graphs.

Not many graphs. Not many lines on each graph but few for total trend (# of REO, # of new ones added vs last month, # of REO sold)

I would do 1 graph for the nation and one for California. (epicenter)

maybe 2 more graphs tracking the trend combined prices of the REO (national, california)

this is me from the last message can not log in for somereason

Anonymous said...

great work and good suggestions here.
I am an old fart financial programmer and one thing I always try to do with numbers and especially $ is to align them vertically -that generally requires a fixed width font, and for big numbers like this I would drop the pennies, and maybe even present them as k's (thousands). I see all kinds of programs today that should format numbers and they don't, arrrrrrgh. And yeah, I know its petty, but I can't read a table decently without formatting...

Bubble Sitter said...

Sweet stuff. I will be coming here regularly for updates.

Anonymous said...

Great work how about them graphs ?

Anonymous said...

Dimitris, excellent work. Thanks for the graphs and state-by-state links to the actual REO listings.

PDXrenter

JA said...

Love it. Simple, powerful.

Anonymous said...

I ran the two Petaluma houses through Zillow and discovered that either Countrywide has raised their prices significantly beyond the prices paid just a few months earlier, or Zillow is spitting out woefully wrong numbers. Or both. I wonder what is up with this.

Dimitris said...

That's a good catch. I'm thinking countrywide is just pricing them at 'retail' until they give them to a realtor. The listings you mentioned haven't shown up on MLS yet.

Anonymous said...

Nice. Can you break it down within each state by town?

Anonymous said...

Great source.

You should access public records or zillow to find out what is the difference between "wishing price" and actual sale price.

At that point you can tally-up CFC loses.

ON CNBC the CEO already build his defense of why his CFC is going under:

It is all those aggressive sub-prime lenders who cut prices. Now they are falling apart and sub-prime borrower can not get a loan to pay the high price of homes.

Because the sub-prime FTHB is gone no one moves up and the whole market freeze up.

There is a different explanation:

Both CFC and NEW have been giving "no docs" stated income loans. These Hugh loans allowed people to overbid on homes way beyond what they can afford.

The problems in every economic situation is prices. When real-estate prices go too high the market collapses.

The ONLY ONLY difference between home prices to any other inflation was that banks such as CFC allowed people to get a HELOC mortgaging their future and their homes . The HELOC allowed people to consume based on using their homes as ATMs instead of asking for better wages.

The Fed supported all that with low interest rates because the Fed's job is to keep wages low.

But time comes when reality sets in: People can not afford such home prices. Even CFC and the Fed can not give people 1%-2% interest loans to keep the home prices in the sky. As ARM adjustments continue the whole house of cards will come down CFC included.

PDXrenter said...

Dimitris,

Wasn't the CA dollar amount $250 million a couple days ago? And today it is $332 million.

Could you track the dollar amount jumps in your database? As more Alt-A loans go bad, the jump in wishing price total dollar volume will likely be disproportionately larger than the jump in # of CFC's REOs because the Alt-A loans are much larger in size than subprime.

PDXrenter

jt said...

Awesome service. Thank you.

Anonymous said...

Great information. Where do you get the data from and how often is it published?
Thanks

Anonymous said...

This is the kind of information a prospective borrower should know before getting a loan from CFC.

CFC is hurting because they aren't honest with there borrowers about the loan terms.

Great site!!!

Anonymous said...

can you graph the dollar amount ? especially for Ca. it is VERY intresting.

Tnx.

Kevin said...

Wow this is really good. Maybe you could add an "Average Price" that would divide total cost by number of houses.

Dimitris said...

Thanks everyone for the nice comments . I didn't expect there would be such an interest in this as I had originally done it for myself. I plan on adding additional stuff soon. Some great ideas presented here and I'll try and see if I can program them to work.

Anonymous said...

Don't add too much. Don't cloud the web site.

maybe just break it to:

Total
Ca.
Fl.
Rest of the country

use graphs to replace long lists.

You are doing a great job. This web site will get more traffic soon. CFC will be the next Enron.

Anonymous said...

Well the trend is clear.

It will be of great help if you set up another graph for the Ca. trend.

Dimitris said...

I should have some more maps up (CA, FL, etc.)within the next day or so. I'm very new to blogger and just realized you can't have sub folders (real links to pages) which makes it a bit tricky to automate something.

REO Properties for Sale said...

very good info even though its kind of outdated. :)