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 |
34 comments:
Yeah, I wish I had done this before. I will create a page that compares weekly changes in price/inventory.
This is great data. Thanks for putting in the time to do this.
I found another website:
http://spreadsheets.google.com/pub?key=pOSu8I1YrtgD6YqtUVBaINg
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?
So the question is...
When did they break $1 billion?
Keep up the good work,
Got popcorn?
Neil
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.
Thanks Neil, fantastic idea!
dimitris, good job keep it going man.
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.
You are right. I'll do that now.
You rock. This is a great bit of code.
Would love to see the data graphed!
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.
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
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
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...
Sweet stuff. I will be coming here regularly for updates.
Great work how about them graphs ?
Dimitris, excellent work. Thanks for the graphs and state-by-state links to the actual REO listings.
PDXrenter
Love it. Simple, powerful.
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.
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.
Nice. Can you break it down within each state by town?
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.
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
Awesome service. Thank you.
Great information. Where do you get the data from and how often is it published?
Thanks
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!!!
can you graph the dollar amount ? especially for Ca. it is VERY intresting.
Tnx.
Wow this is really good. Maybe you could add an "Average Price" that would divide total cost by number of houses.
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.
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.
Well the trend is clear.
It will be of great help if you set up another graph for the Ca. trend.
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.
very good info even though its kind of outdated. :)
Post a Comment