Tag Archives: appraisal

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.