• 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

tutorial

Convincing sellers to NOT overprice their homes by making graphs

October 2, 2014 By Ryan Lundquist 12 Comments

The market is overpriced. So if you are a real estate agent trying to communicate with sellers, how do you get someone who wants to test the market at $500K to realize a more reasonable price is $375K? There are surely many strategies, but today I want to mention the power of graphing neighborhood sales. I don’t mean to beat the dead horse by bringing this up again, but knowing how to graph will help you communicate effectively, stand out from other industry professionals, and seize your role as a market trend expert instead of letting Zillow have all the glory. Sure, you can show your client a graph of city or zip code trends by using Trendvision, but it’s hard to argue with neighborhood-specific data.

making graphs - image purchased by sacramento appraisal blog

A letterhead to give your sellers: Before we dig in, here is a letter I wrote for sellers about things to consider when pricing in this market. This letterhead is based on a post I wrote recently, but I tweaked a few things. See the image below and DOWNLOAD here (PDF). Feel free to email or use as you see fit. Obviously the letter does not address a specific property. If you need a letterhead for your specific property, let’s talk about some consulting.

letterhead

Excel Tutorial: I know, you don’t use Excel because it’s only for nerds. But let me break it down for you below so you can join the club. Previously I shared a tutorial on how to graph with Gnumeric, but I had a few requests for using Excel instead since that’s what most people already have on their computers.

land park two-bedroom graph example by sacramento appraisal blog

This graph shows the range of similar-sized neighborhood sales is between $300-375K for the most part (instead of $500K). This can be a very powerful visual, especially when you begin to show the sales at $375K have been remodeled.

A tutorial on how to show the market: I recommend watching the tutorial below and then pulling up some MLS data for a neighborhood you are working in so you can create a graph by following the steps I took. This is perfect for Sacramento MLS, but as long as you can export data from your MLS system, you should be okay too. You may need to pause my video several times or rewind at moments. Whenever we do something new, it takes a while to catch on. If you don’t have Microsoft Paint to paste the graph like I did, you can use a different photo editing program, or maybe use a snipping tool on your computer. Additionally, you can open up Paint and simply start a new file, and then paste your graph (as opposed to opening an existing photo like I did). Watch below (or here if it’s too small below).

Please let me know if you have any questions. I hope this was helpful. Perhaps this will spur on a new skill set for you that can make a difference in your business.

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: Resources Tagged With: appraisers, convince sellers of price, Excel, Gnumeric, how to, how to make a scatter graph, how to make real estate graphs, Land Park, overpriced market, Real Estate Appraiser, sacramento market, tutorial

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

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

The value of “street view” on Google Maps

July 26, 2011 By Ryan Lundquist 5 Comments

Do you use the Google Maps app on your smart phone? Have you seen the “street view” feature yet? This feature is of course available online, but it’s neat to see on a smart phone too. I think “street view” is a great tool to begin to see a neighborhood in more detail before physically going there. Have a look at the video below (or here) and let me know how you think street view might come in handy for you.

If you have an iPhone and need to use “street view”, check out this well-written article from REbliss. The iPhone and Android app are similar, but they do have differences.

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 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: Internet, Random Stuff, Resources, Videos Tagged With: Capital Village Neighborhood, Google Maps, Google Maps and real estate, Google Maps app, Granite Bay Treelake, iPhone Street View on Google Maps, Lundquist Appraisal Company, myTouch4G, NY Times Square, overview of street view, Real Estate Appraiser in Sacramento, REbliss, review of street view on Google Maps, tutorial

Primary Sidebar

Connect with Ryan

 Facebook Twitter LinkedIn YouTube Instagram

Subscribe to Weekly Post

* indicates required

Search this site

Blog Categories

  • Appraisal Stuff (408)
  • Bankruptcy (3)
  • Divorce (4)
  • Estate Settlement (6)
  • FHA Appraisal Articles (56)
  • Internet (53)
  • Market Trends (485)
  • 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

  • An explosion of appraisal waivers. Is that good or bad?
  • Skyrocketing prices aren’t happening everywhere
  • The housing market feels like a crazy auction
  • Are appraisers keeping up with rapid price growth?
  • How much have prices risen since the bottom of the market?
  • How long can this market keep going?
  • What is your housing persona?
  • Rapid price growth & the Gilmore Girls next door
  • Are first-time buyers targeting 2-4 unit properties?
  • Stale real estate headlines & buyers flocking to El Dorado County

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