Tag Archives: appraisal

Davis, Woodland, and Arbuckle Market Update for April and a quick discussion of appraiser shortages

I hope you’ve had your Covid-19 vaccine shots. If not and you’re in California, sign up now here.

Inventory continues to be low in the region with rising prices and competition for most properties. Sales volume is rising as shown below for Davis and Woodland:

Activity is up in Davis from the previous 12 months
Woodland sales volume continues to increase

Inventory has risen in Davis but is still on the low side. Woodland continues to run significantly below normal.

Prices overall are increasing rapidly in Woodland and moderately in Davis. Keep in mind that specific market segments may be trending differently depending upon demand.

Includes only single family homes in Davis city limits sold through Metrolist
Woodland sales reported to Metrolist in city limits of single family homes only

Multiple Offers

Everyone is talking about competing against 15 offers and prices 30% over initial list. Davis and Woodland are competitive, but not that competitive, as shown below.

Mean number of offers received trending up in Davis. Source: Metrolist
Woodland showing a significant increase in offers received

Arbuckle Market Trends

Arbuckle is an unincorporated community of approximately 5,000 people located about 45 minutes northwest of Sacramento along Interstate Highway 5 in Colusa County. It features homes built in the 1940-50s plus newer subdivisions built over the past 20 years and is surrounded by farmland.

Inventory is very low, not that unusual given how small the Arbuckle market is. Sales volume in 2020 was down 10% from 2019, not unusual for the area. Prices have increased significantly over the past 12 months as shown below.

Rapid price increases in Arbuckle during the pandemic per Metrolist

A longer look shows the effect of the pandemic on pricing:

Prices were stable heading into the pandemic but increased as most markets I cover did over the past 12 months
Arbuckle, CA is surrounded by farmland and split by I-5

Of the 37 homes sold in Arbuckle since 1/1/20 in Metrolist, 17 had one offer and 20 had more than one with a peak of 17 offers for one property. Competition has picked up in Arbuckle, following trends throughout the area.

Every day I receive calls and offers from lenders, agents, and buyers hoping I can help them with a purchase appraisal. I’m very fortunate to be busy and can’t finish anything quickly now because of my workload. I strongly suggest everyone to be patient if an appraisal is part of your transaction. This graph below from Freddie Mac will help explain the situation.

Source: The Effect of COVID-19 on Appraisal Volume – Freddie Mac Single-Family

Appraisal volume ties directly to interest rates. When rates fall, mortgage financing rises and drives appraisal volume up. When rates rise, appraisal volume falls. However, as shown above, the number of appraisers in the US who work with lenders has been relatively stable over the past eight years. The interest rate cycle rises and falls much more rapidly than the time it takes to develop a productive appraiser, causing appraiser shortages in times like now.

Good luck.

Davis, Woodland, and Winters Market Update September 2020

Six months after the Covid-19 stay-at-home order hit Yolo County, what’s happened to residential real estate in local markets?

Sales activity in Davis was low at the start of 2020 before the pandemic hit and continued into the spring with a massive drop in May. As shown below, Davis is way behind in sales compared to last year but we may make up ground in the fall.

2020 vs. 2019 single family residential sales in Davis per Metrolist
12 Month change in Davis single family residential sales per Metrolist

In contrast, Woodland started 2020 with strong year-over-year sales activity, putting on the brakes in April and May. Some of the missing activity shifted into the summer but Woodland is still behind last year’s numbers.

Woodland closed sales 2020 vs. 2019 per Metrolist
12 Month change in Woodland single family residential sales per Metrolist

While demand (sales) fell over the past six months, supply fell even further in both Davis and Woodland. We have seen an increase this summer in homes listed in Davis, hopefully a sign of the traditional summer market spilling into the fall.

Davis single family residential new listings per Metrolist.

Woodland saw a sharp drop in new listings in April and May and is continuing to track lower.

Woodland new single family residential listings per Metrolist

Net effect on both Davis and Woodland is a supply imbalance leading to rising prices. Davis is showing year-over-year increases in five of the past six months.

Prices have increased on a year-over-year basis in five of the past six months in Davis per Metrolist

Woodland prices are rising too as shown on the scatter graph of all sales below.

The Woodland SFR market has increased over the past 12 months per Metrolist

Below is a quick summary of both markets:

The standout statistic above is the incredibly low inventory in Woodland.

Winters is a much smaller market than Davis or Woodland. As the graph below shows, sales are increasing at present. Also note the lack of sales in April and May in Winters, similar to other Yolo County markets.

Prices have increased in Winters over the past 12 months too

Takeaways for Davis and Woodland

  • Sales volume is down
  • Inventory has declined more leading to a supply imbalance
  • Prices are increasing

Pay Attention To

  • Interest rates. The historically low rates are jet fuel for the residential market. When rates go up, pay attention
  • The local economy. We’re still in a recession with massive job losses and a large percentage of mortgage forbearances. So far, impacts to local housing have been minimal but that may change in a hurry

Are you seeing the same things in your markets?

Easy Fix for Rappatoni Data Export Issue

Update: Well, this helps but doesn’t completely solve the problem. Tab characters still stay in the fields not converted to numbers or dates. If this doesn’t work, I’ve added a couple of steps that will work involving using a robust text editor, Notepad++.

Oh no! What broken my 1004MC calculator?

A recent Rappatoni MLS update broke data export. It appears that a hidden tab character is placed between fields as a delimiter, changing numeric fields into character fields. This causes issues when you try to use a workbook like Don Machholz’s 1004MC because the 1004MC workbook relies on the data types to be correct. The calculator chokes whenever it finds text in a numeric field like list price (or sale price, or DOM, etc.). This only affects Rappatoni system MLSes. Metrolist was not affected (yet) because they run their own code and do not appear to have run the update that broke stuff.

Here’s a quick way to know if your MLS has been affected. Take a look at the Selling Price column. If it lines up on the left, your MLS has the issue. If it lines up on the right, you’re good to go.

Here’s an example with the problem:

Here’s how it should look:

Here’s an easy workaround for the latest version of Excel.

  • Download your data out of MLS and save it to a csv file.
  • Open up an Excel workbook.
  • Click on the cell you want the downloaded data to appear in.
  • Click on the Data Tab and select From Text/CSV
  • Select your csv file containing the data you need and hit the Import button
  • Excel will open a data import wizard. This should show your data with the correct data formats and aligned correctly (numbers aligned to the right, text to the left, dates looking like dates). Click the Transform Data button and you should be good to go.
Excel 365 Data Importer screen

Older versions may require more work to find the data import wizard. This link shows the process using a slightly older version of Excel. Brings me back to my days as an EDI analyst….

I’m learning from others that this fix doesn’t work universally. If you see this in your Excel file, you still have problems.

Here are additional steps that you can do to fix it. The simple way is to place your cursor in the edit bar to the immediate left of the data you want to keep, hit <Backspace>, then enter. This deletes the hidden Tab character but needs to be repeated throughout the file. Another option is to simply not copy text fields into the 1004MC since they are not required to run the calculator.

If you’re interested in a better solution, download a robust text editor like Notepad++ (link). Use Notepad++ to open the csv file.

csv file opened with Notepad++

Go to View, Show Symbol, Show All Characters

Notepad++ will then show the Tab characters

Select one of the now visible tab characters and type ctl + c to copy the Tab character. In Notepad++, select Search then Replace

Click on the Find what: box and paste the Tab you selected previously. Leave the Replace with: box blank. Click on the Replace All button and then save changes.

Now you should be good to go.

(There are many ways to skin a cat. Another way would be to import your files into an Access database, delete the tabs, then output as an Excel file. If you know how to do this, you don’t need my instructions)

Good luck and contact me directly at joemlynch2112@gmail.com with questions. Hopefully Rappatoni fixes this soon.