• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Sacramento Appraisal Blog | Real Estate Appraiser

Real estate appraisals for divorce, estate settlement, loans, property tax appeal, pre-listing and more. We cover Sacramento, Placer and Yolo County. We're professional, courteous and timely.

  • About
  • Appraisals
  • Order
  • Ask Ryan
  • Areas
  • Classes
  • Press
  • Trends
  • Share
  • Contact

Sacramento MLS

5 Reasons why graphing is a vital skill for real estate professionals

May 1, 2014 By Ryan Lundquist 5 Comments

Can you teach an old dog new tricks? That’s questionable. It’s certainly not easy for us humans to learn new things either. But let’s talk about one skill in real estate that is HIGHLY attainable, yet something that most will ignore (which can be good for you). Knowing how to graph neighborhood sales sounds really dull, but it’s truly something that can be an amazing tool to help you stand out from the crowd and look like a rock star to your clients.

Real estate geeks - Image purchased and used with permission by Sacramento Appraisal Blog

5 Reasons why graphing is a vital skill for real estate professionals

  1. We live in a visual world, so graphs help clients see the market.
  2. Neighborhood data can be far more powerful than zip code data.
  3. Why let Zillow or Trulia make all the graphs? Show your skills.
  4. Graphing helps you understand trends first before talking with clients.
  5. Graphs are perfect for sharing on your blog or social media.

A tutorial on how to make trend graphs: I made a tutorial below for you to check out. I recommend watching it and then pulling up your MLS so you can create a graph by following the steps I took. This is good for Sacramento MLS, but it’s also good for any MLS so long as you can export data (which is probably only a matter of clicking one button). Ask your MLS how you can export data to a spreadsheet if you cannot figure it out. I use Gnumeric in the video (a free version of Excel), and you can download that here for free. Or just use Excel, which is similar and what I use all the time for my fancier graphs.

You can watch the video above or directly here on YouTube. If it’s too small here, watch on YouTube for a larger version. Does this image help illustrate the market? What story does it tell? Should this seller in Rancho Cordova list at $230,000?

Rancho Cordova Example - trend graph of sales - by Sacramento Appraisal Blog

Some Quick Advice: The only way to add skills in business is to take a stab at learning something new, but one big reason why that doesn’t happen is because it can feel intimidating to take that first step. When it comes to graphing it’s easy to think it is only for techies, but trust me, you can do it. The more you practice, the better you’ll get. Remember, you are going to impress your clients by showing them the market visually. Don’t just tell them. Show them. I recommend trying out a graph every time you need to comp a neighborhood or maybe whenever you get a new listing. There are so many different types of graphs too. You can look at my market trends category for some examples. Whatever you do, get into a rhythm so you are practicing regularly. If you have some questions too, don’t hesitate to ask.

Questions: Was the tutorial helpful? Anything you need clarity on?

If you liked this post, subscribe by email (or RSS). Thanks for being here.

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Random Stuff, Resources Tagged With: education, growth in business, how to, how to make a graph, Metrolist, real estate professional, Sacramento MLS, Scatter Graph, tips from appraiser, trend graphs, tutorial, using MLS data

How to make a graph using new and old MLS data

October 3, 2012 By Ryan Lundquist Leave a Comment

I wanted to show you how to make graphs by exporting current and historic MLS data. Sounds exciting, right? I used a screencast below to give a brief tutorial. I show some examples of graphs in the beginning of the video, but you can also click market trends to scroll through more.

Why does this matter? Knowing how to work with numbers is very powerful. Making graphs can help you understand the market more deeply and assist clients to see what you are seeing. Both agents and appraisers can visually show things like a decade of sales in a particular neighborhood, all sales of a certain size or bedroom count, or even compare multiple tiers of data in a neighborhood (as I show you in the second tutorial below). This can be very convincing to quickly illustrate value trends and even help establish a list price (plus it makes you look smart in the eyes of your clients). You may want to check out a beginner’s tutorial I did for making scatter graphs in MLS and download Gnumeric for free here.

Tea or Lunch: If you’re an agent and want to sit down in person, just buy me a tea or lunch and I’m glad to teach you how to do this.

Coventry Neighborhood Elk Grove

Tutorial on how to use new and old data in MLS (watch below or here):

Tutorial on how to use multiple segments of data: (view below or here – examples include REO vs Traditional Sales, 2-bed vs. 3-bed, model match sales vs. entire neighborhood, etc…)

How might making graphs be relevant for your business?

If you have any questions or Sacramento home appraisal or property tax appeal needs, let’s connect by phone 916-595-3735, email, Twitter, subscribe to posts by email (or RSS) or “like” my page on Facebook

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Appraisal Stuff, Market Trends, Resources Tagged With: appraiser in Sacramento, Gnumeric, historical data in MLS, Home Appraiser, House Appraiser, how to export data to Gnumeric, how to export MLS data, how to make a scatter graph, Sacramento Metrolist, Sacramento MLS, screencast for how to make graph in MLS, tips for appraisers, tips for real estate agents, visually showing the market

Is it a condominium or townhouse? What does the plat map say?

June 12, 2012 By Ryan Lundquist 2 Comments

How do you know if a property is a condominium or townhouse? There is quite a bit of confusion about this question actually, and this uncertainty translates into properties in MLS being frequently labeled as “condos” when they’re really townhouses. The distinction is of course really important because comparable sales really should be the same type of property, right?

What does the plat map say? If you don’t have a preliminary title report at your fingertips, knowing how to view plat maps can actually make a huge and quick difference. Take a few minutes to watch the screencast below (or here) where I show three examples of how looking at a plat map can help identify the type of property. I know, this ranks low on the exciting scale, but trust me, if you’re in real estate, this is really good stuff to know. The video is a bit larger if you watch directly on YouTube. If anything is unclear or you have questions, speak on.

Does the plat map show specific lot dimensions for the individual unit on a parcel? If so, it’s most likely a townhouse PUD and not a condominium. This is an important indicator that’s often missed in listings on MLS. The owner of the condominium does not have ownership of the entire site on which the unit is built, so there is no reason to give specific dimensions on the plat map for the lot shape (the only dimenstions for a condo in the plat map are for the entire parcel where all units are located – NOT each individual unit). Click the thumbnails to view example images.

     

NOTE: This information is good for the Sacramento area and may not be relevant for other areas.

If you have any questions or Sacramento area real estate appraisal or property tax appeal needs, contact me by phone 916-595-3735, email, Twitter, subscribe to posts by email or “like” my page on Facebook

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Appraisal Stuff, Internet, Resources Tagged With: condo vs. townhouse, difference between condo and townhouse, Home Appraiser, House Appraiser, PUD, real estate education, Sacramento MLS, tutorial, type of ownership, using plat maps

How to make a multi-level graph in MLS

November 7, 2011 By Ryan Lundquist Leave a Comment

Are you a visual learner? I am. Today I want to show you how to export data from MLS to make a great visual presentation. This can come in very handy for real estate agents and appraisers when comparing different segments of data in a specific neighborhood, city or county. You might consider doing something like this to display a difference in bedroom count, price vs. square foot range, distressed vs. typical sales or even something like pool vs. no pool. In the video example below I show you how to plot Arms-length vs. REO vs. Short Sales in a neighborhood (like this graph in Elk Grove). I hope it’s easy to understand. Enjoy and let me know if you need any clarification. Happy graphing!!

If you have any questions, or real estate appraisal or property tax appeal needs in the Greater Sacramento Region, contact Lundquist Appraisal by phone 916-595-3735, email, Facebook, Twitter or subscribe to posts by email.

Share:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Filed Under: Appraisal Stuff, Resources, Videos Tagged With: appraisal service in Sacramento, appraisers in Sacramento, how to make a scatter graph, Lundquist Appraisal Company, making a scatter graph with multiple tiers of data, multi-level graph in Sacramento MLS, Real Estate Appraiser in Sacramento, Sacramento Metrolist, Sacramento MLS, Sacramento Real Estate Appraiser, scatter graph in MLS

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

Connect with Ryan

 Facebook Twitter LinkedIn YouTube Pinterest

Subscribe to Weekly Post

* indicates required

Search this site

Blog Categories

  • Appraisal Stuff (401)
  • Bankruptcy (3)
  • Divorce (4)
  • Estate Settlement (6)
  • FHA Appraisal Articles (56)
  • Internet (53)
  • Market Trends (440)
  • Photos from the Field (126)
  • Property Taxes (70)
  • Random Stuff (225)
  • Resources (560)
  • Videos (161)

Blog Archives: 2009 – 2019

Lundquist Appraisal Links

  • Appraisal Order Form
  • Appraisal Website
  • Rancho Cordova Appraiser Website
  • Sacramento Appraisal Blog Sitemap
  • Sacramento Real Estate Appraiser Facebook Page
  • Twitter: Sacramento Appraiser (@SacAppraiser)
  • YouTube: Sacramento Appraiser Channel

Most Recent Posts

  • ‘Tis the season for real estate predictions
  • My real estate mind never shuts off
  • How might rent control affect the housing market?
  • Street names & hot stats with an asterisk
  • Thoughts on PG&E and the housing market
  • That place where shiplap & murder meet
  • Does the market really change every seven years?
  • When sellers care too much about the Zestimate
  • Zillow has officially entered the market
  • Not everything is getting multiple offers

Disclaimer

First off, thank you for being here. Now let's get into the fine print. The material and information contained on this website is the copyrighted property of Ryan Lundquist and Lundquist Appraisal Company. Content on this website may not be reproduced or republished without prior written permission from Ryan Lundquist.

Please see my Sharing Policy on the navigation bar if you are interested in sharing portions of any content on this blog.

The information on this website is meant entirely for educational purposes and is not intended in any way to support an opinion of value for your appraisal needs or any sort of value conclusion for a loan, litigation, tax appeal or any other potential real estate or non-real estate purpose. The material found on this website is meant for casual reading only and is not intended for use in a court of law or any other legal use. Ryan will not appear in court in any capacity based on any information posted here. For more detailed market analysis to be used for an appraisal report or any appraisal-related purpose or valuation consulting, please contact Ryan at 916-595-3735 for more information.

There are no affiliate links on this blog, but there are three advertisements. Please do your homework before doing business with any advertisers as advertisements are not affiliated with this blog in any way. Two ads are located on the sidebar and one is at the bottom of each post. The ads earn a minor amount of revenue and are a simple reward for providing consistent original content to readers. If you think the ads interfere with your blog experience or the integrity of the blog somehow, let me know. I'm always open to feedback. Thank you again for being here.

Copyright © 2019 Sacramento Appraisal Blog