Special offer

How to do your own 'Comp Search'

By
Real Estate Appraiser with Estimation Nation Corporation

How to do your own ‘Comp Search':

1) Talk to your borrower about their house.  Ask them if they have any amenities or upgrades (inground pool, new roof, updated kitchen, etc.).  Ask them what year their house was built and what style it is (Ranch, Split-Level, Traditional, etc.).  Ask if there have been any additions or conversions to the house and if so, ask them what they believe their current square footage to be.

2)  If the property is:

  •  a) built earlier than 1970
  •  b) is in a neighborhood with hills and valleys which may provide views
  •  c) is near a river where there might be riverfront properties
  •  d) is custom built
  •  e) has a basement (or properties around it have basements)
  •  f) is on a acreage
  •  g) is rural
  •  h) is a manufactured home
  •  i) is near manufactured homes, attached homes, condos, etc.
  •   or
  •  j) is in an area where other houses were not built in similar styles, ages and square footage

Then skip steps 2 through 7 and call an Appraiser and order an appraisal.

3)  Enter the borrower's address into Zillow or any other AVMs (such as Cyberhomes, Trulia or Real Estate ABC). Be sure that the property information matches what the owner has told you.  Keep in mind that AVMs take information from tax databases and so the information provided to them is only as good as the county's record keeping.  In addition, please note that Zillow allows a home owner, Realtor or anyone who can type in a password to manipulate information in it's database which may render this information useless.

 

North Portland Oregon

 

4) SET THE PARAMETERS... This is a huge step and if you choose to disregard it, contact an Appraiser and order an appraisal now.   Set the square footage within 15% of the subject property's square footage.  Look for sales no older than 6 months back.  Make sure that all sales are within 1 mile of the subject property.  If the borrower's home has anything unusual like 5 bedrooms in a community where there are usually only 3 in a home look for 4-6 bedroom homes. 

5) Take note of the valuation ("Zestimate") of the borrower's home.  (For Zillow):  Deselect the ‘For Sale', ‘Make Me Move' and ‘All other homes' check boxes.  If the sales in the area are more than 10% difference in size or ‘Zestimated value', disregard this as a valid opinion of value and contact an Appraiser and order an appraisal.

6) Print out this information.  Your borrower may have looked up the same information on Zillow and it may be where they came up with the estimated value of their home.  It is wise to speak with them about their discovery and talk with them in an educated manner about why the value may or may not be correct.   Check the value against at least two more AVMs (Cyberhomes, Trulia, Real Estate ABC, etc.) to determine any discrepancies.  If there are differences that vary more than 10% in value, contact a local Appraiser and order an appraisal.

7) If you have access to a local mls system, look up the subject and each sale that the AVM has listed as comparable to see if there are condition differences, square footage differences, etc to tax and AVM information.

 

Impressively, Zillow, Cyberhomes and Trulia estimate my home to be within a $10,000 variance of each other.  Unfortunately, the square footage of my home is 200 square feet off because the county considers 200 square feet of my home's basement as ‘finished' (I put this in quotes as I'm not sure how they came to this conclusion) and all three AVMs have thusly added it into the above ground square footage which makes me wonder how many of the ‘comparable properties' were askew as well.

Unimpressively, the example home I used in the screenshots gave the following estimates:

  •    Zillow: $276,685
  •    Trulia:  $345,667
  •    Cyberhomes: $276,012
  •    Real Estate ABC:  no coverage available
  •    Actual sold price (within past 30 days):  $308,000

I find AVMs to be helpful, interesting and educational... until people start to take them seriously and then I find them dangerous.  There is no reason not to use these resources to educate yourself on the area and subject property, but free is a very good price .... and you do get what you pay for... In short; Contact a local Appraiser and order an appraisal.

Comments (7)

Jennifer Monroe
Indigo Home Team powered by Compass - Charlotte, NC
Real Estate REALTOR®/Broker/Designer
Sara this is fantastic! I can't tell you how 'off' those sites have been when I check them just for 'fun' - and to be prepared to discuss these numbers with my clients since i know they will bring it up. In the end, too many people get hung up on numbers and forget that it's worth what someone will pay for it TODAY!
Oct 08, 2007 06:52 AM
Stephen Joos & Chris Brubaker- HouseFront
HouseFront - Denver, CO

Sara, great post.  You did hit the nail on the head for online valuations, they are estimates.  But you forgot to mention the company I work for, HouseFront, give our system a try and let us know what you think (we are always looking for professional feedback).  You are right in your closing comments and at HouseFront we are merely trying to be a tool for professionals and a link to get consumers to the pros. Keep up the great blogs.

 

Oct 08, 2007 10:56 AM
Sara Goodwin
Estimation Nation Corporation - Portland, OR
Portland, Oregon Appraiser

Thanks, Jennifer - I'm glad you get it, too :-)

Hey Stephen - Thanks for the extra AVM - I stopped by housefront.com ... it gave me a range of $262k-$290k for the same house listed above.  I do appreciate the fact that it does present a range rather than an absolute value, though! It's interesting though that the housefront.com info states that it was built in 1953 rather than 1918... I wonder if it's gleening effective age data rather than actual age data.

Oct 08, 2007 02:16 PM
Drew Meyers
Geek Estate - Seattle, WA
Drew Meyers

Sara-

Hey, it's Drew from Zillow. Great post you've written here. We definitely agree with you -- an AVM is not a replacement for an appraisal or CMA by a local professional who knows the market.

One quick clarification -- your statement that "Zillow allows a home owner, Realtor or anyone who can type in a password to manipulate information in it's database which may render this information useless" -- only the listing agent or homeowner can edit the home facts of a particular home in our database, not just anyone.

I just looked at your home on Zillow and it appears that you've claimed your home and edited the home facts. It now shows that the home has 2 bedrooms and 2,200 square feet. Please note that we'll be using owner facts as an input into the Zestimate calculation soon, but we aren't doing so currently (the formula is using the 1,028 number right now). 

I looked at Trulia and didn't see a valuation and I actually wasn't aware that they had valuations on their site. Can you please point me to the page where you see that value on their site? 

Oct 09, 2007 02:15 PM
Sara Goodwin
Estimation Nation Corporation - Portland, OR
Portland, Oregon Appraiser

Hello Drew -

Thank you for the clarification... but how does Zillow know it is the owner or Realtor that is signing up on the Zillow web site? 

The home listed here is not my own.  The owner is including the basement in with above ground square footage.  Which should bring the total square footage to no more than 1,932.  I'm not sure where the other 200+ square feet came from unless they are counting a finished attic.  This will completely skew not only the zestimate on this property but other properties that use this property as a 'zomp' (a Zillow comp).

Trulia's information is located toward the mid to bottom right (ads pending) of the page (once address is entered) and says: "Avg. list price for similar homes: $271,796" for the above house now.  This was originally written several months ago.

Oct 10, 2007 02:50 AM
Drew Meyers
Geek Estate - Seattle, WA
Drew Meyers

Sara-

Regarding owners, we make them pick the name of the homeowner from a drop-down list or verify their identity via a credit card to claim a home. There have been roughly 1 million people who have claimed homes on Zillow -- and we've seen very few  (<20) malicious claims over the past year.

There are very strict rules for licensed agents regarding advertising other people's homes, so there is not much incentive to falsely advertise homes on Zillow.

Please read this thread regarding comps on Zillow -- http://www.zillow.com/forum/site/ViewThread.htm?tid=3442 . They are not used the same as a realtor would use them in a CMA. 

Oct 10, 2007 04:58 AM
Sara Goodwin
Estimation Nation Corporation - Portland, OR
Portland, Oregon Appraiser

Thanks for the information, Drew....

In this situation (property posted) the owner was moving and it would behoove him/her to make the house look at 'phat' as possible.  Wouldn't the updated information still skew this areas records for other zestimates?  ... Doesn't matter, since most of the houses in the area listed have basements (see rule 2e above).

Oct 11, 2007 03:32 AM