Combining Property Price Predictions from Repeat Sales and Spatially Enhanced Hedonic Regressions

  • Are OustEmail author
  • Simen N. Hansen
  • Tobias R. Pettrem


Hedonic regression and repeat sales are commonly used methods in real estate analysis. While the merits of combining these models when constructing house price indices are well documented, research on the utility of adopting the same approach for residential property valuation has not been conducted to date. Specifically, house value estimates were obtained by combining predictions from repeat sales and various hedonic regression specifications, which were enhanced to account for spatial effects. Three of these enhancements—regression kriging, mixed regressive-spatial autoregressive, and geographically weighted regression—are widely utilized spatial econometric models. However, a fourth augmentation, which addresses systematic residual patterns in regressions with district indicator variables and the presence of outliers in housing data, was also proposed. The resulting models were applied to a dataset containing 16,417 real estate transactions in Oslo, Norway, revealing that when the repeat sales approach is included, it reduces the median absolute percentage error of solely hedonic models by 6.8–9.5%, where greater improvements are associated with less accurate spatial enhancements. These improvements can be attributed to the inclusion of both spatial and non-spatial information inherent in previous sales prices. While the former has limited utility for well-specified spatial models, the non-spatial information that is implicit in previous sales prices likely captures otherwise difficult to observe phenomena, potentially making its contribution highly valuable in automated valuation models.


House prices Automatic valuation models Spatial models Repeated sales Hedonic regressions Big data 



  1. Amundsen, B. (2015). Rike og fattige flytter fra hverandre i Oslo [Rich and poor moving apart from each other in Oslo]., Available at: (accessed: 11 December 2017).
  2. Anon. (2013). OECD, Eurostat, International Labour Organization, International Monetary Fund, The World Bank, and United Nations Economic Commission for Europe. Repeat sales methods. Handbook on Residential Property Prices Indices (RPPIs), OECD publishing, Paris, 67–72.Google Scholar
  3. Anselin, L. (2010). Thirty years of spatial econometrics. Papers in Regional Science, 89(1), 3–25.CrossRefGoogle Scholar
  4. Bailey, M. J., Muth, R. F., & Nourse, H. O. (1963). A regression method for real estate price index construction. Journal of the American Statistical Association, 58(304), 933–942.CrossRefGoogle Scholar
  5. Basu, S., & Thibodeau, T. G. (1998). Analysis of spatial autocorrelation in house prices. The Journal of Real Estate Finance and Economics, 17(1), 61–85.CrossRefGoogle Scholar
  6. Bates, J. M., & Granger, C. W. (1969). The combination of forecasts. Journal of the Operational Research Society, 20(4), 451–468.CrossRefGoogle Scholar
  7. Bohling, G. (2005). Kriging. Data Analysis in Engineering and Natural Science, Kansas Geological Survey. Available at: (accessed: 8 June 2018).
  8. Bowen, W. M., Mikelbank, B. A., & Prestegaard, D. M. (2001). Theoretical and empirical considerations regarding space in hedonic housing price model applications. Growth and Change, 32(4), 466–490.CrossRefGoogle Scholar
  9. Can, A. (1992). Specification and estimation of hedonic housing price models. Regional Science and Urban Economics, 22(3), 453–474.CrossRefGoogle Scholar
  10. Can, A., & Megbolugbe, I. (1997). Spatial dependence and house price index construction. The Journal of Real Estate Finance and Economics, 14(1–2), 203–222.CrossRefGoogle Scholar
  11. Case, B., & Quigley, J. M. (1991). The dynamics of real estate prices. The Review of Economics and Statistics, 73(1), 50–58.CrossRefGoogle Scholar
  12. Case, K. E., & Shiller, R. J. (1987). Prices of single-family homes since 1970: New indexes for four cities. In NBER working paper series 2393. National Bureau of Economic: Research. Scholar
  13. Case, B., Pollakowski, H. O., & Wachter, S. M. (1991). On choosing among house price index methodologies. Real Estate Economics, 19(3), 286–307.CrossRefGoogle Scholar
  14. Case, B., Clapp, J., Dubin, R., & Rodriguez, M. (2004). Modeling spatial and temporal house price patterns: A comparison of four models. The Journal of Real Estate Finance and Economics, 29(2), 167–191.CrossRefGoogle Scholar
  15. Chan, Y. L., Stock, J. H., & Watson, M. W. (1999). A dynamic factor model framework for forecast combination. Spanish Economic Review, 1(2), 91–121.CrossRefGoogle Scholar
  16. Clapp, J. M., Giaccotto, C., & Tirtiroglu, D. (1991). Housing price indices based on all transactions compared to repeat subsamples. Real Estate Economics, 19(3), 270–285.CrossRefGoogle Scholar
  17. Clemen, R. T. (1989). Combining forecasts: A review and annotated bibliography. International Journal of Forecasting, 5(4), 559–583.CrossRefGoogle Scholar
  18. Cleveland, W. S. (1979). Robust locally weighted regression and smoothing scatterplots. Journal of the American Statistical Association, 74(368), 829–836.CrossRefGoogle Scholar
  19. Cliff, A. D., & Ord, K. (1970). Spatial autocorrelation: A review of existing and new measures with applications. Economic Geography, 46, 269–292.CrossRefGoogle Scholar
  20. Corcoran, C., & Liu, F. (2014). Accuracy of Zillow’s home value estimates. Real Estate Issues, 39(1), 45–49.Google Scholar
  21. Cressie, N. (1990). The origins of kriging. Mathematical Geology, 22(3), 239–252.CrossRefGoogle Scholar
  22. Dubin, R. A. (1988). Estimation of regression coefficients in the presence of spatially autocorrelated error terms. The Review of Economics and Statistics, 70(3), 466–474.CrossRefGoogle Scholar
  23. Dubin, R. A. (1998). Spatial autocorrelation: a primer. Journal of Housing Economics, 7(4), 304–327.CrossRefGoogle Scholar
  24. Eurostat. (2016). Distribution of population by tenure status, type of household and income group − EU-SILC survey. Available at:Æilc_lvho02&langÆen (accessed: 20 May 2018).
  25. Farber, S., & Yeates, M. (2006). A comparison of localized regression models in a hedonic house price context. Canadian Journal of Regional Science, 29(3), 405–420.Google Scholar
  26. Fik, T. J., Ling, D. C., & Mulligan, G. F. (2003). Modeling spatial variation in housing prices: A variable interaction approach. Real Estate Economics, 31(4), 623–646.CrossRefGoogle Scholar
  27. Fotheringham, A. S. (2009). Geographically weighted regression. In S. Fotheringham & P. Rogerson (Eds.), The SAGE handbook of spatial analysis, 243–254. London: SAGE Publications Ltd.CrossRefGoogle Scholar
  28. Fotheringham, A. S., Brunsdon, C., & Charlton, M. (2002). Geographically weighted regression: The analysis of spatially varying relationships. New York: Wiley.Google Scholar
  29. FreddieMac. (2017). Home Value Explorer. Available at: (accessed: 5 December 2017).
  30. Geary, R. C. (1954). The contiguity ratio and statistical mapping. The Incorporated Statistician, 5(3), 115–146.CrossRefGoogle Scholar
  31. Gelfand, A. E., Ghosh, S. K., Knight, J. R., & Sirmans, C. F. (1998). Spatio-temporal modeling of residential sales data. Journal of Business & Economic Statistics, 16(3), 312–321.Google Scholar
  32. Goovaerts, P. (1999). Using elevation to aid the geostatistical mapping of rainfall erosivity. Catena, 34(3–4), 227–242.CrossRefGoogle Scholar
  33. de Haan, J. & E. Diewert (2013), "Hedonic Regression Methods”. Handbook on Residential Property Price Indices, OECD Publishing, Paris,
  34. Harris, P., Fotheringham, A., Crespo, R., & Charlton, M. (2010). The use of geographically weighted regression for spatial prediction: An evaluation of models using simulated data sets. Mathematical Geosciences, 42(6), 657–680.CrossRefGoogle Scholar
  35. Harris, P., Brunsdon, C., & Fotheringham, A. S. (2011). Links, comparisons and extensions of the geographically weighted regression model when used as a spatial predictor. Stochastic Environmental Research and Risk Assessment, 25(2), 123–138.CrossRefGoogle Scholar
  36. Helbich, M., Brunauer, W., Hagenauer, J., & Leitner, M. (2013). Data-driven regionalization of housing markets. Annals of the Association of American Geographers, 103(4), 871–889.CrossRefGoogle Scholar
  37. Hengl, T., Heuvelink, G. B. M., & Stein, A. (2003). Comparison of kriging with external drift and regression kriging. Technical note, ITC. Available at: (accessed: 11 May 2018).
  38. Hengl, T., Heuvelink, G. B. M., & Rossiter, D. G. (2007). About regression-kriging: From equations to case studies. Computers & Geosciences, 33(10), 1301–1315.CrossRefGoogle Scholar
  39. Humberset, K. (2018). Her må du punge ut 85.000 kroner for én kvadratmeter [Here you have to pay 85,000 NOK for one square meter]. Available at: (accessed: 4 June 2018).
  40. Kitanidis, P. K. (1993). Generalized covariance functions in estimation. Mathematical Geology, 25(5), 525–540.CrossRefGoogle Scholar
  41. Koenker, R., & Bassett, G., Jr. (1978). Regression quantiles. Econometrica: Journal of the Econometric Society, 46(1), 33–50.CrossRefGoogle Scholar
  42. Krause, A. L., & Bitter, C. (2012). Spatial econometrics, land values and sustainability: Trends in real estate valuation research. Cities, 29, S19–S25.CrossRefGoogle Scholar
  43. LeSage, J. P., & Pace, R. K. (2014). The biggest myth in spatial econometrics. Econometrics, 2(4), 217–249.CrossRefGoogle Scholar
  44. Levin, J. (2001). Information and the market for lemons. RAND Journal of Economics, 32(4), 657–666.CrossRefGoogle Scholar
  45. Monsrud, I. J. & Takle, M. (2018). Price index for existing dwellings. Statistics Norway. Available at: (accessed: 7 June 2018).
  46. Moran, P. A. (1950). A test for the serial independence of residuals. Biometrika, 37(1/2), 178–181.CrossRefGoogle Scholar
  47. Eiendom Norge, Eiendomsverdi & (2017). Eiendom Norges boligprisstatistikk [Real Estate Norway housing price statistics]. Available at: (accessed: 4 December 2017).
  48. Odeh, I. O. A., McBratney, A. B., & Chittleborough, D. J. (1995). Further results on prediction of soil properties from terrain attributes: Heterotopic kriging and regression kriging. Geoderma, 67(3–4), 215–226.CrossRefGoogle Scholar
  49. Olaussen, J. O., Oust, A., & Solstad, J. T. (2017). Energy performance certificates–informing the informed or the indifferent? Energy Policy, 111, 246–254.CrossRefGoogle Scholar
  50. Oslo Kommune. (2018). Finn bydelen din her [Find your city district here]. Available at: (accessed: 13 May 2018).
  51. Pace, R. K., Barry, R., Gilley, O. W., & Sirmans, C. F. (2000). A method for spatial–temporal forecasting with an application to real estate prices. International Journal of Forecasting, 16(2), 229–246.CrossRefGoogle Scholar
  52. Páez, A., Long, F., & Farber, S. (2008). Moving window approaches for hedonic price estimation: An empirical comparison of modelling techniques. Urban Studies, 45(8), 1565–1581.CrossRefGoogle Scholar
  53. Park, B., & Bae, J. K. (2015). Using machine learning algorithms for housing price prediction: The case of Fairfax County, Virginia housing data. Expert Systems with Applications, 42(6), 2928–2934.CrossRefGoogle Scholar
  54. Reichert, A. K. (1990). The impact of interest rates, income, and employment upon regional housing prices. The Journal of Real Estate Finance and Economics, 3(4), 373–391.CrossRefGoogle Scholar
  55. Rosen, S. (1974). Hedonic prices and implicit markets: Product differentiation in pure competition. Journal of Political Economy, 82(1), 34–55.CrossRefGoogle Scholar
  56. Sinnott, R. W. (1984). Virtues of the haversine. Sky and Telescope, 68(2), 159.Google Scholar
  57. Trawiński, B., Lasota, T., Kempa, O., Telec, Z., & Kutrzyński, M. (2017). Comparison of ensemble learning models with expert algorithms designed for a property valuation system. In N. Nguyen, G. Papadopoulos, P. Jędrzejowicz, B. Trawiński, & G. Vossen (Eds.), Computational collective intelligence , ICCCI 2017, lecture notes in computer science, vol 10448. Cham: Springer.Google Scholar
  58. Wheeler, D. C., & Calder, C. A. (2007). An assessment of coefficient accuracy in linear regression models with spatially varying coefficients. Journal of Geographical Systems, 9(2), 145–166.CrossRefGoogle Scholar
  59. Yao, J., & Fotheringham, A. S. (2016). Local spatiotemporal modeling of house prices: A mixed model approach. The Professional Geographer, 68(2), 189–201.CrossRefGoogle Scholar
  60. Yoo, S.-H. (2001). A robust estimation of hedonic price models: Least absolute deviations estimation. Applied Economics Letters, 8(1), 55–58.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2019

Authors and Affiliations

  1. 1.NTNU Business SchoolNorwegian University of Science and TechnologyTrondheimNorway
  2. 2.Department of Industrial Economics and Technology ManagementNorwegian University of Science and TechnologyTrondheimNorway

Personalised recommendations