Vernon Downs

 

Situated north of Scio Church Road and south of Avondale, on Ann Arbors West Side, Vernon Downs is a long popular development built in several phases between 1955 and 1965 by George Airey. The houses are well-built, and a mixture of ranch, split-level, capes and colonials. The majority of houses are ranch style, between 1,200 and 1,400 sqft in size. The oldest parts of the subdivision along Winsted, Sanford, Weldon and Waverly are primarily smaller ranches with varying degrees of off-street parking including carports, detached, attached, and no garages. The later part of the development along the west side, towards Maple Road (Waltham, Agincourt, Covington, and others) have more mixture and larger houses, with attached garages standard. The primary school is located on the northwestern side of the subdivision, and the area high school is less than one mile east across Seventh.

 

The Ann Arbor Area Board of Realtors no longer retains hardcopy MLS books, but does retain fairly robust data back to 2005, and in some instances earlier. Doing a search for the word “Vernon” in the legal description of all sales found online, and then restricting these to ranch style only, it is easy to track movement in price over time, including the Great Recession that hit Ann Arbor as well as the nation in general. The first graph shows price reductions for individual sales over time. This was included as price reductions are a leading indicator of a changing market. Using this information, it was clear that price reductions had started in 2005-06, and that they had increased in number between 2007 and 2010, then a second spike in 2012.

 

price reductions

 

The next data run was related to net sales price over time, showing increases at a significant level over the past few years, and the largest dip in prices here between 2009 and 2010.

 

net SP over time

 

Because there were varying size houses in the mix, and because the neighborhood is spread out in phases with the newer larger houses tending to sell at higher prices, price per square foot was also run. This data also shows a dip in prices in 2009 and 2010.

 

net sp per sqft

 

Because there were so many sales using this method (204 in total), it was also broken out year by year, and finally comparing current activity in the neighborhood using the same criteria of “Vernon” and ranch style houses. This is displayed in average price over time, as median and averages were largely similar.

 

price time

 

In observing this data, what is particularly noted is that right now, there is only one active and one property under contract, but both are lower priced than the past two years sales. Of course, the contracted property is smaller than the averages and likely in the older section, but it is worth noting.

 

Using the data above on a yearly run, It is easy to see how the list price to sales price ratio widened over time to a low point in 2005 (too few sales) and 2010, and rose over 100% in 2016 and 2017. So far, 2018 is lower, just over 97%. Part is likely due to the increasing prices however. Again, this could be a bellwether indicator of a market in transition.

 

avg lp sp ratio

 

Average sales price over time shows a decline from 2004 to 2005, but again there were too few sales in the MLS at that time to be meaningful, and an increase slightly in 2006 and 2007, followed by a decline to a low point in 2009. Because markets are very location specific, this is very interesting to observe, as the condominium study  that was completed last week showed a decline in prices starting in 2005. Those condominium properties are on the southwest side of Ann Arbor, only a couple miles from Vernon Downs. It actually makes a lot of sense to see rates of decline and increase at different times, because so much of what we see related to price fluctuation can be related to supply and demand. In areas with ample supply, the market may change at a greater rate, and at an earlier time. The average sales price per square foot ratio is much the same as the average price ratio, so is not posted in addition, but there is a leveling of price per square foot noted between 2017 and 2018.

 

avg sp over time

 

For the real estate professionals reading this blog, how does the current market “feel” to you? Does it feel like a normal winter slowdown, particularly with some early cold snaps we have had, or are the interest rates and price increases over the past couple of years perhaps taking a toll? Probably none of us can pin this down at the moment, but it is worth watching what is going on with the market, particularly the properties that are on the market and not going to contract, the price reductions, and the list prices of the contracted listings.

Hope everyone had a great Thanksgiving, and be safe out there!

September Washtenaw County Snapshot

Snapshot of the market for 9/1/18

pexels-photo-164359

How are we faring in Washtenaw County as far as market absorption?

A quick run of the Ann Arbor Area Board of Realtors MLS data for single family properties (includes duplicate listings due to multiple board insertions) shows mixed trends. To read the chart below, the data is arrayed by area, the number of prior closed sales in the last year, supply based on these sales (only includes available properties), total number of listings, those that are reporting as available, those under contract, and the contract to listing ratio.

9.1.18 snapshot

I have found the contract-to-listing ratio (CTLR) the most meaningful in measuring how a market is faring, and consider anything under 20% to be a buyers’ market, between 21-34% balanced, and over 35% as a sellers’ market. Based on this information three markets are showing as sellers’ markets, those being Lincoln, Milan and Ypsilanti. Ann Arbor and Chelsea are tilting towards a sellers’ market, and Manchester, Dexter and Saline are showing balance.

 

Based on the total number of sales in the past year, compared to what is currently available, Lincoln, Milan and Ypsilanti again are all showing less than two months of inventory, which helps support the thesis of a sellers’ market in these areas. Ann Arbor has less than three months inventory, while Chelsea, Manchester and Dexter are showing around 3.5 months in general. Saline shows close to five months’ worth of inventory, but my suspicion is that much of this relates to a larger number of “to be built” offerings in Saline as there are a number of new subdivisions under construction that are inputting offerings into the MLS. This may be the case as well in Ann Arbor and Chelsea, where new subdivisions are underway.

 

As we head into the fall, and new school year, the markets tend to slow down, and there is evidence based on this larger data, that this is the case with some areas. Of course, this information is “macro” data in that it includes each entire school district as opposed to the sub-markets within each one. I plan on running this type of information monthly for this blog, so we can compare how markets track over time. Please feel free to share the information gathered, and if you want to subscribe to my email distribution list, let me know, or sign up to follow my blog at https://annarborappraisal.blog//. I am always available to chat or assist with your appraisal needs.

Observe, Analyze and Report – in that order

The more things change, the more they remain the same. We still need to pay attention to our analysis of both sales histories and listing histories for our subject properties and comparable sales.

scales

Observe, Analyze and Report- In that Order
By Maureen Sweeney, SRA, AI-RRS and Rachel Massey, SRA, AI-RRS

Appraisers have always faced objections and challenges to their reports as soon as they leave the office. Some are preventable, such as typographical errors or taking a photograph of the wrong comparable property- after all, we are only human. Others are out of the appraiser’s control, such as a foreclosure or a loan repurchase of a property we appraised.

When a loan is repurchased, the Government Sponsored Entity (GSE) or lender may turn to the original appraisal to evaluate its accuracy and verify that the observations made during the time of inspection were correctly documented. They may look to see if the contract, market conditions, prior sales history and other observations were analyzed, and that those observations, analyses and conclusions were communicated in a manner that was not misleading. Many of us are great at documenting what we see at a property as well as communicating these observations in our appraisal reports. Unfortunately, many appraisers are not as strong at analyzing data and are uncertain of what needs to be addressed, particularly as it relates to prior sales of the subject and the comparable properties included in the report.

To analyze something is to examine and interpret it. For the appraiser, it is the analysis of the data that we collect, examine and interpret. Appraisers need to report their analysis clearly and accurately to prevent future problems; “an ounce of prevention is worth a pound of cure.” Remember, most of our clients are not mind readers and may need to be walked through why there was a price increase or decrease to the subject or one of the comparable properties.

Most residential appraisers whose work is exclusively mortgage related, work mainly with the Fannie Mae Uniform Residential Appraisal Report (URAR, Form 1004), Individual Condominium Appraisal Report (Form 1073), and/or the Small Residential Income Property Appraisal Report (Form 1025). While these three forms appear to be very different, they have many similarities. Each is tailored to a specific residential property type but each includes a Scope of Work, Statement of Assumptions, and Limiting Conditions. We are all so busy that it is easy to forget what is in the Certification that we sign with each report. As such, it is a good practice to read the pre-printed certification and limiting conditions pages occasionally. This is because each time we sign our report we are confirming that we have completed the items listed on those pages.

Analyze This
There are pressures that appraisers face daily, including time pressure, ever-growing engagement letters that require all kinds of additional details and information, and the constant battle for reasonable fees. Many of us have developed language and statements that help us save time in writing appraisal reports. One thing that boilerplate and drop-down menu statements cannot help us with is data analysis. This is one timesaving corner we cannot cut.

As much as we would like to think that presenting the facts about a sale is analyzing data, it is not.  Analysis is more than a statement that a property sold on such and such a date, for such and such a price. The analysis includes how that sale was positioned in the market at the time of transfer or sale. Was the sale at arm’s length? Was it a REO sale in need of a total overhaul? Was the sale under duress because of some need to sell? Was it one family member selling to another? We need to address why it sold for what it did in relation to what the current appraised or final sales price is. We must analyze the prior sale as well as the current contract, if applicable, and explain and report the results of the analysis or explain why it was not performed.

As markets are rarely static, we need to analyze the current market and any changes to the market since the prior sale. This analysis of the market, and how it has fluctuated, is a basis for part of the analysis of the prior sale in comparison to the current market value. Because of the requirement by the GSEs to use the Market Research and Analysis Form (1004MC), sometimes there are inadequate data within the report to support a trend which might otherwise help paint a picture of an increase (or decline). When there is inadequate data to adequately complete this form, there is nothing stating we cannot include additional information outside of the MC form.

Often, those who look to find fault with an appraisal turn to this section first, because sometimes appraisers do not analyze the data presented in the 1004MC. Boxes may be checked, boilerplate statements may be added, but the data analysis is not summarized. The appraiser knows the market and knows what is occurring, but did not add a summation of the analysis or trends that may be reflected in the data. Are foreclosures and short sales an issue in the market?  Appraisers may click the box “yes” yet not report the impact of those foreclosures and short sales in the subject’s market. When analyzing the market conditions, analysis is not a “should,” but a “must.” As appraisers, we are often so busy and it may seem so self-evident, but six months or a year down the line it may be very difficult to remember precisely what was happening in the market at the time. This extra bit of communication of what we observed in the market at the time can be very helpful, not only to our clients, but to ourselves in the event of a challenge to our work, months or even years down the line.

This analysis of the market conditions is used when analyzing the prior sales of the subject, as well as all comparable sales. Currently Fannie Mae and Freddie Mac require a minimum 36-month sale and transfer history of the subject to effective date, and 12-months for all comparable sales since their most recent closed date. After September 14, 2015, the FHA requires 36-months for the subject and 36-months for all comparable sales.  We are starting to see more ”flipping” again as the market has improved in many parts of the country. There are often examples of houses being purchased below market because they were in need of repair and then rehabbed or renovated, and resold. 

 

Were any of the comparable sales sold previously below market value due to their condition and lack of modernization?  Did these houses sell for a higher, similar or even lesser amount after improvement and is this consistent with the market conditions analysis?  Sometimes this cannot be determined by looking back 12 or 36-months. Perhaps the comparable prior sale sold 40-months ago, but sold at a similar time as the subject’s prior sale.  Would comparing that prior sale to its current sale further support the changing market conditions?  Would it support the information presented in the Sales Comparison Approach to value? If the prior sale was a “trashed-out” REO sale and there are photos in the MLS, consider including a few of these photos, in addition to the narrative, as they can add needed support for the change. As appraisers, we may have to go beyond the minimum time and reporting requirements to accurately analyze the prior sales in order to develop credible assignment results.

Analyzing a Sale
How does one analyze a sale?  The following is one simple example:
“Comparable sale 1 sold on 01/01/2015 after being exposed to the market for 7 days.  It was bank owned, and in need of significant work, including replacement of all cabinetry, flooring, light fixtures and paint.  It also needed a new roof and furnace. The water heater was in working order and the electric had previously been upgraded. The house was listed for sale for $99,000 and sold under a bidding war for $105,000.  The purchaser of this property gutted what was remaining, replaced cabinetry, flooring, light fixtures and windows, as well as installed new siding, roof, and furnace.  The entire interior was painted and the owner had the property staged for sale.  It was offered for sale on 06/01/2015 for $225,000 and received three offers according to the listing agent. The house sold in 5 days on the market for $230,000 without concessions. The increase in price of $110,000 was partially related to the increasing market but in larger part due to the remodeling that took place in the interim.”

In this example, the appraiser analyzed the prior sale, then reported this information in the body of their appraisal report. This sale, which would have generated many questions, did not. The appraiser communicated their analysis in writing instead of only keeping notes in the work file. There was no need for questions by the appraisal reviewer, especially since MLS photos showing the prior and current condition were included in the report.

The Working RE story Supporting Market Conditions has one example of how to complete a market analysis outside of the 1004MC form. In short, if there are insufficient data points to provide any type of robust market analysis, include additional information supporting the position of how the market is changing or has changed, before the effective date of the report. Let the client know what has happened in the market since the prior sale of the subject as well as what has happened to the subject itself. Part of our jobs as appraisers is to help clients understand the market.

Should Do/Must Do
The appraiser’s job has changed dramatically in the past 10 years. We are under increased scrutiny by all parties in the mortgage industry as well as state regulators, attorneys and borrowers. Those of us still in the industry are paying for the sins of individuals who were part of various financial crimes, some even appraisers. Many of those who were guilty of these sins were not appraisers, yet many in the industry, the media, and the public insist on pointing the finger at us.

Some of the bad apples left the industry, by their own choice or through the encouragement of their state appraisal licensing boards. Because of this, what once was a “should,” has turned into a “must.”  It is important to observe what is at the property and what is happening in the market, analyze that information, and provide at least a short summary of our analysis. Because of the massive amounts of information we are required to know and the constant changes that we see in the industry, sometimes we know much but don’t report enough. Sometimes we have to show our work. By showing our work and including our data analysis, objections and challenges of our reports will be a thing of the past. This is particularly the case related to prior sales of the subject property and the comparable sales included within the report.

 

Note, this originally appeared with WorkingRE 2.5 years ago, but the sentiment remains very much the same. This has been republished with their permission.  Please visit the original at Here if interested.

Latest comparison to online valuation models

Latest comparison to online valuation models

It is quite frustrating to see how many people rely on these online value estimators to either price their home, or use it for marital dissolution, or other reasons. As will be shown in a minute, these can be off by a significant amount, either low or high.

I just ran sales in Ann Arbor, in the 48103 area for the past couple of weeks. I then compared the sales prices to two online value estimators and State Equalized Value times two. The only consistency to the information is that these online value estimators overestimated on houses in need of work and underestimated on those houses that were remodeled. In only a small percentage of cases, were the value tools within five percent of the actual sales price.

 Image

Appraisals are “opinions” of value by educated professionals. They are opinions based on factual data, but in the end of the opinion of a professional. Not all appraisers have equal qualifications and experience, and therefore not all opinions are equal.

If you are shopping for an appraiser to help provide you an independent opinion of value, base your selection on the breadth and depth of that appraiser’s knowledge and experience, not the price of the appraisal assignment. After all, it is typically your client’s largest investment, and does it make sense to be penny-wise and pound-foolish?

Rachel Massey, www.annarborappraisal.com