So, Monica, here are the single family, detached homes. I just noticed that all that prettyin' up I did got wiped out when the chart got posted. Hope you can make heads and tails of it!

Month # Sold Avg Sq Ft Avg $ Avg $/Sq Ft
Jan-07 3 1860.33 $767,500.00 $412.56
Feb-07 7 1528.43 $649,178.57 $424.74
Mar-07 6 1653.17 $645,250.00 $390.31
Apr-07 12 1573.58 $658,041.67 $418.18
May-07 4 1709.75 $671,500.00 $392.75
Jun-07 4 1492.75 $667,250.00 $446.99
Jul-07 5 1807.40 $705,000.00 $390.06
Aug-07 6 1678.17 $642,083.33 $382.61
Sep-07 4 1708.00 $655,750.00 $383.93
Oct-07 4 1539.75 $603,250.00 $391.78
Nov-07 1 1956.00 $525,000.00 $268.40
Dec-07 3 1613.33 $468,333.33 $290.29
Jan-08 2 1154.00 $442,500.00 $383.45
Feb-08 4 1845.00 $636,250.00 $344.85
Mar-08 2 1726.00 $558,500.00 $323.58
Apr-08 5 1409.40 $455,000.00 $322.83
May-08 5 1498.00 $517,800.00 $345.66
Jun-08 11 1449.27 $485,377.27 $334.91
Jul-08 14 1672.71 $534,357.14 $319.46
Aug-08 13 1590.08 $496,000.00 $311.93
Sep-08 6 1694.00 $503,000.00 $296.93
Oct-08 2 1579.00 $455,000.00 $288.16
Nov-08 4 1580.25 $482,544.50 $305.36
Dec-08 5 1443.20 $436,800.00 $302.66
Jan-09 3 1710.33 $516,666.67 $302.09
Feb-09 3 1790.33 $505,800.00 $282.52
Mar-09 9 1502.78 $449,222.22 $298.93
Apr-09 6 1758.67 $542,833.33 $308.66
May-09 13 1550.69 $483,576.92 $311.85
Jun-09 4 1744.75 $505,000.00 $289.44
Jul-09 4 1574.00 $471,725.00 $299.70
Aug-09 6 1557.17 $531,666.67 $341.43
Sep-09 3 1391.00 $462,166.67 $332.25
Oct-09 2 1465.00 $480,000.00 $327.65

Pending 19 1547.95 $483,952.63 $312.64
Active 17 1591.00 $548,970.00 $345.05

SFRs droped in value from $412.56 to $327.65, a decline of $174.91 or 42%. That's a pretty substantial drop and, even looking back to September or even August's numbers, it doesn't make a huge difference to pick a previous month with more home sales in it.

The great thing about using price per square foot as your guage is that you can ROUGHLY (I want to emphasize that!) calculate the value of a similar property by multiplying the average price per square foot by the square footage of the subject house. For instance, based on the final average price per square foot of $327.65, if you were looking at a 1500 square foot home (close to the average sold in October so far), you could calculate a value of $491.475. Of course, it's always best to ask a real estate professional (or two or three) to provide you with a Comparative Market Analysis (CMA) of any property in which you are interested.

Hope this encyclopedic diatribe helped!

Monica,

I agree with Harrison and Aaron. However, I think that the average price per square foot gives you a much better guage by which you can compare any similar property. Below, I've inserted the results of my statistics search on condominiums and single family, detached homes since you don't specify. One thing to keep in mind when trying to determine the value of a property is that you should compare it to like properties. Your results are skewed if you use condos to compare to detached houses or vice versa.

First, for condos in 92886:

Month/Year # Homes Avg. Sq. Ft. Avg $ Avg $/Sq. Ft
Jan-07 11 1235.27 $434,372.73 $351.64
Feb-07 11 1257.73 $458,000.00 $364.15
Mar-07 13 1222.23 $429,596.15 $351.49
Apr-07 15 1597.87 $527,999.47 $330.44
May-07 12 1199.83 $421,483.33 $351.28
Jun-07 20 1306.85 $437,911.55 $335.09
Jul-07 8 1366.75 $425,687.50 $311.46
Aug-07 7 1691.43 $504,071.43 $298.02
Sep-07 3 1088.00 $367,666.67 $337.93
Oct-07 7 1325.00 $411,485.71 $310.56
Nov-07 10 1423.10 $440,400.00 $309.47
Dec-07 7 1323.57 $422,662.86 $319.34
Jan-08 5 1097.80 $349,800.00 $318.64
Feb-08 2 855.00 $247,500.00 $289.47
Mar-08 3 1331.00 $412,488.67 $309.91
Apr-08 3 1966.67 $502,885.67 $255.70
May-08 4 1294.00 $351,250.00 $271.45
Jun-08 3 1078.00 $304,666.67 $282.62
Jul-08 4 1386.50 $375,000.00 $270.47
Aug-08 1 2217.00 $600,000.00 $270.64
Sep-08 0
Oct-08 1 943.00 $260,000.00 $275.72
Nov-08 0
Dec-08 1 1128.00 $270,000.00 $239.36
Jan-09 12 1219.17 $279,016.67 $228.86
Feb-09 9 1572.67 $347,944.44 $221.24
Mar-09 20 1562.05 $350,839.95 $224.60
Apr-09 13 1407.15 $333,676.92 $237.13
May-09 7 1686.71 $377,842.86 $224.01
Jun-09 11 1164.27 $258,663.55 $222.17
Jul-09 7 1437.71 $319,516.00 $222.24
Aug-09 18 1716.06 $383,871.89 $223.69
Sep-09 19 1199.63 $263,765.79 $219.87
Oct-09 3 1656.67 $432,328.33 $260.96

Pending 52 1311.10 $290,932.98 $221.90
Active 41 1493.46 $347,990.12 $233.01

So, condominiums went from $351.64 in January of 2007 to $260.96 to date this month, a drop of $$90.68 per square foot or 26%.

I'll have to give you the statistics for SFRs on another post! I ran out of characters trying to pretty the charts up.

I agree with comment made by Aaron here to some extent.

Using the median home price can be deceptive, and it just looks at the middle point where 50% of the homes sold over that amount and 50% sold under.

We agree with Aaron that it would be better and more valuable to look at average sold home prices.

The Case Schiller index uses another model and comparison of exactly the same home previously sold to that same house selling at this time. This index is a valued tool and usually shows continuing and anticipated negative price pressure, which is true as of this time, June 2009.

Harrison K. Long, Realtor and broker, Coldwell Banker Previews, Irvine, CA http://www.ExploreOChomes.com

Monica,

Using the median home price can be deceptive because it just looks at the middle point where 50% sold over that amount and 50% sold under. I think it is best to look at average sales prices and compare them with each other because it tells you what the same house is selling for at two different times in the market.

According to my MLS records, in October 2007, there were 21 home sales in that zip code with an Average sales price of $984,076 or approx. $318 per square foot. In the last 30 days ending May 26 there have been 31 home sales with an Average sales price of $728,287 or approx. $310 per square foot.

Sales Volunme: + 47.6%
Average Sales Price: - 26%
Average Price per square foot: - 2.5% (In 2007 the average square foot was 2,869, in 2009 it is 2339.

There are larger price drops when you go back into 2006 and compare those numbers to 2009. One home sold for $787,000 on 5/30/2006 and sold again on 5/2/2009 for $497,000. That's a huge fall.

If you think that home prices are going to continue to drop, I'd love to hear why you are thinking that. Hopefully, this info has been helpful to you.

I live and sell real estate in YL.

Best of luck.

Monica, http://www.dqnews.com/Charts/Monthly-Charts/OC-Register-Char…

http://www.dqnews.com/Charts/Annual-Charts/OC-Register-Chart…

http://www.dqnews.com/Articles/2009/News/California/Southern…

All together it covers a good bit of the time and the annual/monthly reports are broken into zip codes.

The source, for the numbers on my "chart" are from DataQuick, and represent closed escrows.

The decline shown is approximately 40%. ( Which is nowhere near the previous gain, by the way.)

Hi Monica. I'm not aware of a source to go to that breaks down the median per zip code, and allows you to pick and choose a starting and ending period of time, but here is a table showing the median for the entire County of Orange, in California:

$734,000 = Jun 2007 ~ Peak of O.C. median price
$718,000 = Jul
$710,000 = Aug
$655,000 = Sep
$650,000 = Oct
$655,000 = Nov
$600,000 = Dec
.
~2008
.
$583,250 = Jan
$575.000 = Feb
$570,000 = Mar
$555,000 = Apr
$537,000 = May
$550,000 = Jun
$515,000 = Jul
$500,000 = Aug
$480,000 = Sep
$480,000 = Oct
$430,000 = Nov
$425,000 = Dec
.
~2009
.
$418,250 = Jan
$434,500 = Feb
$440,000 = March 12

I hope that is helpful.

Hi Monica,
You can choose Stats&Trends above to get some information. I beleive Trulia collects this from public records.

http://www.trulia.com/real_estate/92886-Yorba_Linda/
http://www.trulia.com/real_estate/92886-Yorba_Linda/market-trends/

Hi Monica,
If you will supply me a little more information, I would be happy to help. Please email me directly with the size and property types (single , attached, detached, condos) to be included.
Thanks Walter