Zillow vs The Coyle Group Part III

The Coyle Group vs Zillow Part III

It’s that time again for the annual match up between Zillow and The Coyle Group.  This year we randomly selected 25 appraisals completed by our office with in the past 3 months.  The appraisals were of properties across Philadelphia, Montgomery County, Bucks County, Delaware County and Chester County.  Housing styles ranged from simple South Philly row homes to Center City condos (you’re welcome Mark) to Main Line mansions.

Below is a chart of the results.  The first column shows where the property is located, the second The Coyle Group’s appraised value and the third Zillow’s Zestimate.  The last column shows how high or low Zillow was relative to our appraised values.

Property

 Appraisal

 

 Zillow Zestimate

Difference

Rittenhouse Square Townhse  $    990,000.00    $     954,000.00

3.63%

Chestnut Hill Twin  $    285,000.00    $     329,000.00

15.43%

Ambler Colonial  $    570,000.00    $     396,000.00

54.47%

Burholme Twin  $    125,000.00    $     138,000.00

10.40%

Media Split Level  $    325,000.00    $     251,000.00

29.48%

Mount Airy Twin  $    310,000.00    $     259,000.00

9.69%

Northeast Philly Row  $    171,000.00    $     172,000.00

0.58%

Hatboro Split Level  $    225,000.00    $     244,000.00

8.44%

Gladwyne Colonial  $    600,000.00    $     758,000.00

26.33%

Society Hill Townhouse 1  $    875,000.00    $     848,000.00

3.18%

Conshohocken Single  $    190,000.00    $     252,000.00

32.63%

Flourtown Colonial  $    735,000.00    $     698,000.00

5.30%

West Chester Colonial  $  1,300,000.00    $  1,000,000.00

30.00%

Society Hill Townhouse 2  $  2,100,000.00    $     922,000.00

127.76%

Chestnut Hill Colonial  $    975,000.00    $     857,000.00

13.77%

Bryn Mawr Colonial  $    770,000.00    $     750,000.00

2.67%

Havertown Cape Cod  $    295,000.00    $     286,000.00

3.14%

South Philly Row  $    186,000.00    $     151,000.00

23.17%

Doylestown Colonial  $    395,000.00    $     337,000.00

17.21%

Villanova Tudor  $  1,550,000.00    $  1,430,000.00

8.39%

Roxborough Row  $    240,000.00    $     210,000.00

14.20%

Warrington Colonial  $    435,000.00    $     378,000.00

13.10%

Condo – The Philadelphian  $    675,000.00    $     634,000.00

6.07%

Condo – Queen Village  $    180,000.00    $     183,000.00

1.63%

Lafayette Hill Colonial  $    325,000.00    $     275,000.00

15.38%

 

The results are pretty amazing.  In a few comparisons, Zillow was right on target.  For instance, I would say that they were spot-on with the Northeast Philly Row and the Queen Village Condo.  They were fairly close with number of others including the Rittenhouse Square Townhouse, Society Hill Townhouse 1, the Bryn Mawr Colonial and Havertown Cape.

However, Zillow completely whiffed on a number of others, most notably the Society Hill Townhouse 2.  Zillow wasn’t even close.  The Zestimate missed the mark by more than 127%.  That’s crazy considering there was a recorded sale of this property in 2013 for $1.85M.  This is where having a human being analyze the market data is so crucial.  All the fancy algorithms and computer models overlooked the simple fact that this property sold only months ago for twice the Zestimate amount.  We appraised the property a couple months after the sale and following a renovation of the kitchen and baths.

On average, including the Society Hill 2 property, the Zillow Zestimate was 23.42% lower than the appraised value.  Excluding the Society Hill 2 property, Zillow was still off by 16.47%.  When Zillow over-Zestimated they did so by 11.25%, on average.  These are some significant numbers.  If you were selling and used a Zestimate to potentially under-price your house, you could be leaving huge sums of money on the table.  If you overpriced, the market would likely pass you by in favor of more competitively priced homes.  Eventually, you would have to reduce your price and by that time many of the interested buyers will have moved on.

Philadelphia and the surrounding counties are such a patchwork of real estate markets that computers and algorithms can’t possibly take into account the individual nuances.  Zillow doesn’t take into consideration if there’s a vacant house next to your property or a golf course.  Zillow looks at them as being the same. That’s why having a knowledgeable appraiser to physically inspect the property is so important to realizing a correct value.  Nothing (so far) beats having a live human being appraising your property.

Bottom line, Zillow is not all bad.  It is not an appraisal but it is a good place to start.  The neighborhood data, general sales information, graphs and comparative tools are great and very user-friendly.  However, if you are looking to properly price your home, I would pass Zillow by and get some advice from a good local agent or a certified appraiser.

The Coyle Group’s team of Philadelphia appraisers are a leading provider of appraisals for Estate/Probate, Divorce, Bankruptcy, Tax Appeal and Pre-Listing appraisals.  If you need a guest speaker at your next sales meeting, please give us a call.  We would welcome to opportunity to speak to your group and field any appraisal related questions you may have.  For more information please visit our website at www.TheCoyleGroupLLC.com  You can also contact The Coyle Group at 215-836-5500 or appraisals@coyleappraisals.com

Share

Estate Appraisals 101

IMG_9577A Realtor friend of mine called the other day with a referral to do an estate appraisal for home that they would be listing in Philadelphia, for an estate attorney.  After taking down all the necessary property information, I asked him “How many values will the estate need?” 
 
To which he replied “Why? How many values do I need?”
 
After I though about it, I realized that his question was a reasonable one.  How many values do you need for an estate appraisal?
 
The answer…well, that depends. 
 
Estate appraisals are needed when a property owner passes away and the finances of that person’s estate have to be settled.  They are typically ordered by the estate’s attorney, accountant or the executor, usually a family member or trusted friend of the deceased.  The primary reason for the appraisal is to aid in determining how the inheritance tax will affect the estate.  Depending on how the estate is being administered, an appraiser could be required to provide more than one value.  
 
The most common request that we receive is what we call a Date of Death Valuation.   This is simply a retrospective appraisal as of the date of passing.  It establishes the value of the property at the time of death.  Sometimes the appraisal is orders shortly after the DOD.  Other times, the estate may wait several years to initiate the appraisal process.  This involves looking at older sales data, if it’s available.  I believe our local TReND MLS service goes as far back as 1992.
 
Another request is for a current fair market value.  This is just as it sounds, a current value of the property regardless of the Date of Death. 
 
Some estates will require both values mentioned above.  This is typically the case when an estate has been drawn out over a prolonged period of time.
 
A few years back, we had a situation where we were contacted by an attorney to do an estate appraisal in Chestnut Hill.  The kicker here was that the husband passed away in 2004 and his estate was not settled at that time.  Remember, this was during the upswing of the boom market.  His wife passed away at the peak of the market in the Summer of 2006.  We were engaged to perform the appraisals in 2008, when the market was in free-fall.  So, given the market volatility during that time period, we were asked to provide three different values.  It required three sets of comparables and analysis.  You can imagine how different those three values were!
 
So if you are an attorney or an agent involved with an estate and need an appraisal, be sure to have an understanding of which appraisal  effective date you will need.  It may likely have a significant impact on the estate’s inheritance tax liability.
 
If you are an attorney in need of an appraisal for an estate you are representing, please feel free to give us a call.  If you know someone who needs an estate appraisal, please do not hesitate to contact The Coyle Group.  We will handle the situation with the professionalism and sensitivity it deserves.  Contact The Coyle Group at 215.836.5500 or appraisals@coyleappraisals.com   For more information please visit our website at www.TheCoyleGroupLLC.com   
Share

Zillow vs Appraiser 2013

 Zillow vs TCG

“Zillow told me that my home is worth…”

Appraisers across the USA hear those words at least once a week from well-meaning homeowners.  What many homeowners don’t realize is that Zillow, while a very useful tool, is not always the best indicator of the actual value of their home.  A Zillow Zestimate is not an appraisal.  In fact, if homeowners use Zillow to help them price their home for sale, they could be leaving thousands of dollars on the table, as we will show you.

Below is a chart of 18 randomly selected appraisals that The Coyle Group completed in the past 3 months.  The houses are located throughout Philadelphia, Montgomery, Bucks, Delaware and Chester County.  The chart is a comparison of our appraised value and the Zestimates produced by Zillow.  Keep in mind that our appraisals have the benefit of a full property inspection by a human being and nuanced market knowledge.   Zillow’s Zestimates rely on public records, complex algorithms and no physical inspection of the property.  Here are the results: 

Maple Glen Colonial Appraisal: $430,000 Zillow: $351,050

22.48%

Conshohocken Single Appraisal: $370,000 Zillow: $329,924

12.14%

Collegeville Cape Cod Appraisal: $364,000 Zillow: $355,012

8.65%

Bryn Mawr Mansion Appraisal: $2,000,000 Zillow: $1,662,317

20.32%

Lafayette Hill Colonial Appraisal: $550,000 Zillow: $470,806

16.82%

Chestnut Hill Colonial Appraisal: $635,000 Zillow: $686,018

7.44%

Gladwyne Cape Cod Appraisal: $745,000 Zillow: $697,428

6.82%

Condo – The Murano Appraisal: $575,000 Zillow: $458,870

25.30%

Art Museum Condo Appraisal: $280,000 Zillow: $257,852

8.59%

Condo – The Dorchester Appraisal: $345,000 Zillow: $339,499

1.62%

South Philly Row Appraisal: $110,000 Zillow: $157,378

30.10%

Berwyn Colonial 1 Appraisal: $750,000 Zillow: $886,168

15.37%

Berwyn Colonial 2 Appraisal: $1,200,000 Zillow: $1,153,633

4.02%

Doylestown Townhouse Appraisal: $325,000 Zillow: $294,410

10.39%

Fishtown Row Appraisal: $225,000 Zillow: $211,700

6.28%

Villanova Mansion Appraisal: $2,450,000 Zillow: $2,544,935

3.73%

Mount Airy Twin Appraisal: $285,000 Zillow: $324,137

12.07%

Roxborough Row Appraisal: $245,000 Zillow: $235,076

4.22%

As you can see there are some pretty dramatic deviations between Zestimates and the appraisals.  Based on our appraised values Zillow under valued 13 of the properties.  In some instances Zillow was almost right on, take for instance the condo in The Dorchester.  They were only off by 1.62%…that’s pretty good if you ask me.  For the condo at The Murano, they were off by more than 25%…waaaay off!  On average, Zillow under-valued the properties by 12.39%.

In the case of the South Philly row, the Zestimate was over by more than 30%.  However, I can’t fault Zillow on this one.  The property was really dated and needed a great deal of work.  But this does illustrate how having a full interior inspection of a property can lead to more accurate values.  Also, the Mount Airy twin was over-valued by 12%…but this doesn’t surprise me, everyone in Mount Airy thinks their home is worth more than it is.  Just kidding.

Now imagine that you’re a homeowner getting ready to sell.  You hop on your computer, plug-in your address and Zillow says your home is worth $300,000.  Based on our findings, if Zillow under-values properties 12.39% on average, you (the homeowner) could potentially be leaving $37,170 on the table.  That’s serious money!

This illustration underscores the importance of consulting with a knowledgeable real estate agent or Certified Real Estate Appraiser.  Getting a Pre-Listing Appraisal prior to putting your home up for sale and knowing the true market value of your home can save you time, money and effort when it comes to selling. 

As for Zillow, keep in mind that it is a tool…a starting point.  It’s great for neighborhood data, graphs, general sales information or for seeing what your new neighbors paid for their house.  It’s probably not the best place if you’re looking for assistance with making definitive decision or properly pricing your home for sale.

If you want to know more about our Pre-Listing Appraisal services or have any real estate appraisal related questions please visit www.TheCoyleGroupLLC.com.  You may contact us directly at…215.836.5500 or appraisals@coyleappraisals.com

Share

Zillow vs Appraiser

It seems that Zillow is every nervous homeowner’s best friend (and in some cases their worst enemy). Hardly a week goes by that I don’t hear “Zillow told me my home is worth (fill in the blank).” 

The Zestimates that homeowners often present to appraisers can produce some interesting (and misleading) results.  So much so, that I thought we could do a comparison of 12 randomly selected appraisals that were completed by our office and match them up against their Zillow Zestimates.  Keep in mind that the appraisals have the benefit of a full property inspection by a human being.   Zillow uses public records and complex algorithms.  Here are the results. 

Lafayette Hill house Appraisal: $600,000 Zillow: $529,000

(-11.83%)

Oreland house Appraisal: $230,000 Zillow: $209,500

(-9.78%)

Gladwyne house Appraisal: $585,000 Zillow: $633,500

7.66%

Roxboro twin Appraisal: $206,000 Zillow: $186,300

(-10.57%)

Conshohocken house Appraisal: $350,000 Zillow: $279,600

(-25.17%)

Blue Bell house Appraisal: $335,000 Zillow: $314,900

(-6.38%)

Chestnut Hill twin Appraisal: $300,000 Zillow: $334,200

10.23%

East Falls twin Appraisal: $411,000 Zillow: $427,100

3.77%

Center City condo Appraisal: $755,000 Zillow: $634,200

(-19.05%)

Penn Valley house Appraisal: $585,000 Zillow: $561,000

(-4.28%)

Rittenhouse Square townhouse Appraisal: $1,900,000 Zillow: $898,700

(-111.4%)

Chester Springs home Appraisal: $1,000,000 Zillow: $871,700

(-14.72%)

As you can see there are some pretty significant deviations between the appraised value and the Zillow Zestimate.  In one case, Zillow was off by more than 111% (this seems like a fluke) but, in other examples as close as 3.77% (not bad!).

Bottom line, Zillow is a tool…a starting point.  It’s wonderful for neighborhood data, graphs and general sales information.  It’s probably not the best place if you’re looking for assistance with making definitive decision.

If you have any real estate appraisal related questions, please feel free to contact us…215.836.5500 or appraisals@coyleappraisals.com

Share

Mount Airy Trends

Being located in Erdenheim, just outside the city limits, we are frequently asked to appraise properties in northwestern Philadelphia, especially Chestnut Hill, Mount Airy, Roxborough and Manayunk. 

The other day we received our first question for the Ask PAB! section of the site.  It was submitted by a local agent who works primarily in the northwest section of Philly.  She typically deals with entry level and first time buyers.  For that segment of the market, Mount Airy offers a great selection of housing options for her clientele, in a wide range of price points and design styles.   It has very appealing housing stock, access to transportation, shopping, proximity to Center City and the suburbs and very unique community atmosphere.  Her question was simply:

 “How have Mt. Airy twins and rows been performing over the past couple of years?”

Below is a chart of the sales of 3-4 bedroom twins and rowhomes in Mt. Airy from January 2008 through December 2010.  Click on the chart to enlarge.

The blue dots indicate the sales of 3 bedroom homes; the red dots represent the 4 bedroom sales.  Our sample produced 341 sales of 3 bedrooms and 105 sales of 4 Bedroom homes, in Mt. Airy, during that time period.  The green and yellow lines depict the linear sale price trends for 3 and 4 bedroom houses, respectively.

The trend lines indicate that both 3 and 4 bedroom homes are moving downward.  However, it appears as though the 4 bedroom properties are experiencing a deeper shift that the 3 bedrooms, which are riding a flatter trend.  This is likely due to the fact that there are fewer 4 bedrooms homes and, as a result, fewer 4 bedroom sales.  With a smaller sample, it is easier for a few sales to influence the trend.  Conversely, with a greater number of samples it is less likely that a handful of sales to move the trend so dramatically.

If you have a question about real estate markets and trends in the Philadelphia region, please visit our Ask PAB! page to submit your inquiry.

Share

The Roxborough Row

 

Philadelphia is known as a city of neighborhoods. When Philadelphians meet one another for the first time it’s not long before someone asks “what neighborhood are you from?”

Neighborhoods can be as small as a few square blocks or cover large sections of the city. One such neighborhood is the Roxborough section of Philadelphia. It occupies much of the northwestern portion of the City abutting Montgomery County, along with Manayunk and Chestnut Hill. It has always been a solid, working class area with strong family values and sensibilities.

The staple of the Roxborough housing stock is the three bedroom, single family attached rowhome or townhouse. Many were built to satisfy the housing needs of the local factory workers and to keep up with urban sprawl. Depending on which part of the Boro you are talking about the homes were generally built between 1865 and 1970. These are still very popular housing choices for first time homeowners and investors.

Below is a chart of the sales activity of the typical 3 bedroom Roxborough Row over the the past four quarters (2009 Q4 – 2010 Q3). As you can see, the number of sales spiked to 36 in 2010 Q2. This is a direct result of the tax credit that was being offered to first time homebuyers. The three bedroom Roxborough Row was essentially made for this program due to its attractiveness to first time buyers and those targeted buy the tax credit program. You will notice that in 2010 Q3, after the sunset of the credit, sales of the Rows dropped off by more than 60%, which was just where sales were prior to the credit program.

The next chart compares the Average and Median Sale Price for three bedroom Roxborough Rows over the same time period. In 2010 Q1, the Average Price spikes up to $271,042 despite only 12 sales during that quarter. The reason for the skewed average is two or three higher sales of newer townhouses that pulled the average up. Note that the Median Sale price tracks right along with the other quarters. The Median Sale Price for Roxborough Row has hovered between $204,900 in 2009 Q4 to a high of $214,500 in 2010 Q1. In 2010 Q2, the median began to settle into a more traditional trend eventually getting back down to $205,250 in 2010Q3…almost even with where it was in 2009Q4, prior to the tax credit.

It goes to show, that despite government interference with credits and incentives, the markets will correct themselves. It also goes to show that the Roxborough Row is the backbone of this market and can withstand outside market influences. Perhaps that’s why it’s been around for so long and continues to show consistent and measurable value.

Share

Chestnut Hill Luxury Market

Recently, The Coyle Group, LLC Real Estate Appraisers & Consultants completed an analysis of the Chestnut Hill Luxury Home Market from January 2000 to the present.

In our analysis, the Luxury Market was defined as the top 20% of single family homes sold in Chestnut Hill. Only sales listed in the MLS were part of the analysis. Private sales and sales occurring outside of the MLS listings were not included.

There were a total of 1,186 single family homes sold in Chestnut Hill since January 2000. This figure takes into account all price points. The top 20% (totaling 237 sales) were included in this analysis as the Luxury Market. Below is a graph of the sales activity that was tracked along with a trend line that illustrates the overall trend for the Chestnut Hill Luxury Market over the span of more than 9 years.

The bottom of this segment began at $675,000 and topped out at $3,300,000. The average sale price over the entire time period was $1,060,840, with a median sale price of $912,000.

One of the metrics that were tracked was the List Price to Sale Price Ratio. The cumulative average LP/SP ratio was 96.14%. This means that, on average, since January 2000, homes in the Chestnut Hill Luxury Market have been discounted approximately 4% from their most current asking price. The time period with the most full or over full price sales was between 2004 and 2007, totaling 53. The time period with the fewest full price sales was from January 2008 to the present. In that period, there were only 9 sales that went for full price.

Observing the trend line, the Chestnut Hill Luxury Market appears to be leveling out from the highs of 2006-2008 and more recent declines through the end of 2008 thru 2010. The trend even shows signs of incremental upward movement. This is positive news for this market. However, looking at the historical data the current market is roughly in line with the market from Spring 2005.

The Coyle Group, LLC is a group of professional Real Estate Appraisers and Consultants serving the Greater Philadelphia markets, including Chestnut Hill. For more information on our services such as Pre-Listing Appraisals, please contact our office at 215-836-5500 or visit our website www.thecoylegroupllc.com .

Share