• 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 Metrolist

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

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

How do you make a scatter graph with Sacramento MLS data?

October 5, 2010 By Ryan Lundquist 8 Comments

One of the tools in my real estate utility belt is making trend graphs. Why is this important? I find that being able to visually display all sales or listings on a graph is a very convincing resource. For example, when a home owner hires me to do an appraisal for bankruptcy or any other reason, and I include graphs of historic sales over the past three years, sales over the last twelve months, and then other graphs showing sales for 3-bedroom units, and properties similar in size to the owner’s house, it’s easy to begin to get a picture of what is happening in the real estate market. The great thing too is that you can graph so many different facets, whether square footage, age, date, bed-count, days on market, short sales vs. REOs vs typical sales, etc…

You can see some examples of trend graphs here if you wish. For now, I made a brief video tutorial to help local Realtors and real estate professionals in the Sacramento area export and work with data from our local MLS. It’s a huge benfit to be able to share things like this with clients, and once you have a little practice, you can crank out graphs very quickly. And don’t worry, if you don’t have Excel on your computer, simply download Gnumeric for free.

If you have any questions, let me know, particularly if you are a local Realtor. Call me at 916.595.3735 or connect with me 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, Videos Tagged With: Excel, Gnumeric, how to make a trend graph, Lundquist Appraisal Company, Sacramento Appraisal, Sacramento Appraiser, Sacramento Metrolist, Sacramento Real Estate, trend graphs, Trendgraphix, video tutorial for Realtors

Buying a House for Less than $20,000 in the Sacramento Area?

April 23, 2010 By Ryan Lundquist 4 Comments

What is the lowest-priced sale in MLS over the past 90 days? Can I get a drum roll please? The winner is $5,000. No, that’s not a typo.

1628 8th Street in Livingston is a 2-bedroom 1-bath single family detached property and it sold for $5,000 on 2/05/2010 as a bank-owned fixer. The Listing Agent stated that this “property is unfinished”, which probably means it is completely gutted or has some very serious damage. The photo certainly shows that the shell of the house has some major work needed. Sometimes properties near this price level have “unknown blackish substances” in them too, though not always.

Just in case you are wondering, this price level is not typical for the Sacramento Region or Central Valley. This is indeed the bottom of the market. Over the past 90 days there were only a total of 10 single family detached properties that sold under $20,000. For reference, here is a graph of all sales under $20,000 over the past year based on information in Sacramento MLS (this covers many counties surrounding Sacramento).

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: Market Trends, Random Stuff Tagged With: 000, Bank-Owned Property, Fixer, Graph of All Sales under $20, House for less than $20, Lowest-priced house in MLS, Lundquist Appraisal Company, Metrolist, Real Estate Appraiser, Sacramento Metrolist

Primary Sidebar

Connect with Ryan

 Facebook Twitter LinkedIn YouTube Instagram

Subscribe to Weekly Post

* indicates required

Search this site

Blog Categories

  • Appraisal Stuff (407)
  • Bankruptcy (3)
  • Divorce (4)
  • Estate Settlement (6)
  • FHA Appraisal Articles (56)
  • Internet (53)
  • Market Trends (476)
  • Photos from the Field (126)
  • Property Taxes (70)
  • Random Stuff (231)
  • Resources (566)
  • Videos (161)

Blog Archives: 2009 – 2021

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

  • My new sewer line adds huge value, right?
  • The housing market nobody predicted
  • Real estate trends to watch in 2021
  • You carried me & a spreadsheet for Christmas
  • Real estate drama (and a market update)
  • Goodbye California. Is everyone leaving?
  • How much are buyers paying above the list price?
  • What would happen to the housing market if we went on lockdown again?
  • Overpricing, multiple offers, & hot ranges
  • Why your home isn’t worth 16% more today

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 © 2021 Sacramento Appraisal Blog