Home • PRRES Inc. Journal • Read the Journal

Comparative Evaluation of the Comparable Sales Method with Geostatistical Valuation Models

Author/s: Richard Borst, William McCluskey

Date Published: 1/01/2007

Published in: Volume 13 - 2007 Issue 1 (pages 106 - 129)

Abstract

There is an identifiable theoretical relationship between the comparable sales method (CSM) of valuation as practiced by mass appraisers and the recent developments in geostatistical valuation models. This paper provides an evaluation of techniques in respect of their treatment of location and their predictive capability. The CSM is shown to be a special case of a spatially lagged weight matrix model. There is a less formal but clear relationship with Geographically Weighted Regression as well. The predictive accuracy of CSM is compared to several Ordinary Least Squares Model configurations, and results obtained from Geographically Weighted Regression via empirical studies on diverse datasets. An example of a comparable sales weighting scheme as practiced by mass appraisers is provided. In addition, particular interest is focused on how well each method is able to model the spatial variations in property values.

Download Full Article

Download the Full Article PDF

14445921.2007.11104225.pdf 14445921.2007.11104225.pdf (417kB)

Keywords

Comparable Sales - Geostatistical - Location - Market Basket Value - Spatial Autocorrelation - Weight Matrix

References

  • Barry, R.P. and Pace, R.K. (1999), Monte Carlo Estimates of the Log Determinant of Large Sparse Matrices, Linear Algebra and its Applications, 289, 41-54.
  • Can, A. (1992), Specification and Estimation of Hedonic Housing Price Models, Regional Science and Urban Economics, 22, 453-474.
  • Cannaday, R.E., (1989), How Should You Estimate and Provide Market Support for Adjustments in Single Family Appraisals, Real Estate Appraiser and Analyst, 55:4, 43-54.
  • Case, B., Clapp, J., Dubin, R. and Rodriguez, M. (2004), Modeling Spatial and Temporal House Price Patterns: A Comparison of Four Models, Journal of Real Estate Finance and Economics, 29:2, 167-191.
  • Colwell, P.F., Cannaday, R.E. and Wu, C. (1983), The Analytical Foundations of Adjustment Grid Methods, Journal of the American Real Estate and Urban Economics Association, 11:1, 11-29.
  • Eichenbaum, J. (1988), Incorporating Location into Computer Assisted Valuation: Progress in New York City, paper presented at the World Congress III Computer-Assisted Valuation and Land Information Systems Assisted Valuation, Cambridge, MA.
  • Gau, G.W., Lai, T-Y and Wang, K. (1992), Optimal Comparable Selection and Weighting in Real Property Valuation: An Extension, AREUEA Journal, 20:1, 107-123.
  • Gipe, G.W. (1974), Analysis of Residuals to Improve Multiple Regression Equations, Assessors Journal, 9:1, 9-16.
  • Harrison, D. and Rubinfeld, D.L. (1978), Hedonic Housing Prices and the Demand for Clean Air, Journal of Environmental Economics and Management, 5, 81-102.
  • Kang, H-B. and Reichert, A.K. (1991), An Empirical Analysis of Hedonic Regression and Grid-Adjustment Techniques in Real Estate Appraisal, AREUEA Journal, 19: 70-91.
  • Kelejian, H.H. and Prucha, I.R., (1998), A Generalized Spatial Two-Stage Least Squares Procedure for Estimating a Spatial Autoregressive Model with Autoregressive Disturbances, Journal of Real Estate Finance and Economics, 17:1, 99-121.
  • Korbo, B.G., Rizvi, S., Ghebre, K. and Merritt, G. (2003), Location Adjustments for Agricultural Land Using the Geostatistical Capabilities of a GIS, Assessment Journal, Fall, 34-43.
  • Lai, T-Y. and Wang, K. (1996), Comparing the Accuracy of the Minimum-Variance Grid Method to Multiple Regression in Appraised Value Estimates, Real Estate Economics, 24:4, 531-549.
  • McCluskey, W.J. and Borst, R.A. (1998), Application of Hybrid Intelligent Appraisal Techniques Within The Field of Comparable Sales Analysis, IAAO Conference Proceedings: Today’s Vision Tomorrow’s Reality.
  • McCluskey, W.J., Deddis, W.G., Lamont, I. and Borst, R.A. (2000), The Application of Surface Generated Interpolation Models for the Prediction of Residential Property Values, Journal of Property Investment and Finance, 18:2, 162-176.
  • O’Connor, P.M. (1982), Making one MRA Model Behave Appropriately Across the Whole of Large County, Paper presented at the First World Congress on Computer Assisted Valuation, Cambridge, MA.
  • O’Connor, P.M. and Eichenbaum, J. (1988), Location Value Response Surfaces: The Geometry of Advanced Mass Appraisal, Property Tax Journal, September 1988, 277-298.
  • Pace, R.K. and Gilley, O.W. (1997), Using the Spatial Configuration of the Data to Improve Estimation, Journal of Real Estate Finance and Economics, 14:3, 333-340.
  • Pace, R.K. and Gilley, O.W. (1998), Generalizing the OLS and Grid Estimators, Real Estate Economics, 26:2, 331-347.
  • Smith, R.A. (1986), Comparing Traditional Methods for Selecting Class Intervals on Choropleth maps, Professional Geographer, 38:1, 62-67.
  • Thibodeau, Thomas G. (2003), Marking Single-Family Property Values to Market, Real Estate Economics, 31:1, 1-22.
  • Thompson, J.F. (2006), Comparable Sales Weighting Formulae, Cole Layer Trumble, private communication.
  • Thompson, J.F. and Gordon, J.F. (1987), Constrained Regression Modeling and the Multiple Regression Analysis-Comparable Sales Approach, Property Tax Journal, 6:4, 35-46.
  • Todora, J. and Whiterell, D. (2002), Automating the Sales Comparison Approach, Assessment Journal, Jan/Feb, 25-33.
  • Underwood, W.E. and Moesch, J.R. (1982), The Second Generation of CAMA in New York State, paper presented at the First World Congress on Computer Assisted Valuation, Cambridge, MA.
  • Vandell, K.D. (1991), Optimal Comparables Selection and Weighting in Real Property Valuation, Real Estate Economics, 19:2, 213-239.
  • Ward, R.D., Guilford, J., Jones, B., Pratt, D. and German, J.C. (2002), Piecing Together Location: Three Studies by the Lucas County Research and Development Staff, Assessment Journal, Sept/Oct., 15-48.
  • Ward, R.D., Weaver, J.R., and German, J.C., (1999), Improving CAMA Models Using Geographic Information Systems Response Surface Analysis Location Factors, Assessment Journal, Jan/Feb, 30-38.