Mining a Set of Rules for Determining the Waiting Time for Selling Residential Units

Document Type : Research Paper


Department of Industrial Engineering, South Tehran Branch, Islamic Azad University, Tehran, Iran


Being aware of the waiting time for selling residential units is one of the important issues in the housing sector for the majority of people, especially investors. There are several factors affecting the waiting time for selling residential units. Determining the influential factors on the time period of selling real estates can lead to an informed decision making by real estate consultants, sellers as well as those seeking to buy real estates. Using a real estate database in Iran, the present paper proposes a two-module procedure. The first module deals with implementation of association rule mining. Using the well-known association rule mining techniques namely FP-Growth, several association rules have been extracted which indicate the effective factors on the waiting time for selling residential units. Generated association rules have been evaluated based on metrics such as support, confidence and lift and finally the best rules are selected. The main objective of the second module is to develop a fuzzy inference system which can determine the factors influencing the waiting time for selling residential units from historical data, so that the model can be used to estimate the time it to sell the property for a real estate agency. Several IF-THEN rules are extracted from this module. Extracted rules can be used by real estate agencies as well as buyers and sellers of residential units to make better decisions in their investments. In conclusion section, a number of suggestions for future studies are presented. For example, machine learning algorithms such as neural networks, decision trees, etc. can also be used to predict the duration of residential units’ sale.

The main objective of the second module is to develop a fuzzy inference system which can learn about the factors that influence the waiting time for selling residential units from historical data, so that the model can be used to estimate the time it takes to sell the property for a real estate agency. Several IF-THEN rules are extracted from this module.
Extracted rules can be used by real estate agencies as well as buyers and sellers of residential units to make better decisions in their investments.


Alahyari, M., & Pilevari, N. (2020). CO-Active Neuro- Fuzzy Inference System Application in Supply Chain Sustainability Assessment Based on Economic, Social, Environmental, and Governance Pillars, Journal of System Management, 6 (3) 265-287
Agrawal R. & Srikant R. (1994). Fast Algorithms for Mining Association Rules, in: Proceedings of the 20th International Conference on Very Large Data Bases, pp. 487-499
Agrawal, R., Imielinski, T., & Swami, A. N. (1993). Mining association rules between sets of items in large databases. In Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, 207-216.
Aribowo, A.S., & Cahyana N.H. (2015). Feasibility study for banking loan using association rule mining classifier, International Journal of Advances in Intelligent Informatics, 1 (1) 41-47.
Arincy, N., Sitanggang, I.S.: Association rules mining on forest fires data using FP-Growth and ECLAT algorithm. In: 2015 3rd International Conference on Adaptive and Intelligent Agroindustry (ICAIA), pp. 274–277 (2015)
Azadeh, A., Ziaei, B., & Moghaddam, M. (2012). A hybrid fuzzy regression-fuzzy cognitive mapalgorithm for forecasting and optimization of housing market fluctuations. Expert Systems with Applications, 39(1), 298–315.
Bahia, I.S.H, (2013). A Data Mining Model by Using ANN for Predicting Real Estate Market: Comparative Study, International Journal of Intelligence Science, 3, 162-169
Banerji G., & Saxena K. (2012). An Efficient Classification Algorithm for Real Estate domain, International Journal of Modern Engineering Research (IJMER), 2 (4) 2424-2430
BogdanTrawiński B., Smętek M., Lasota T., & Trawińsk G. (2014) Evaluation of Fuzzy System Ensemble Approach to Predict from a Data Stream. In: Nguyen N.T., Attachoo B., Trawiński B., Somboonviwat K. (eds) Intelligent Information and Database Systems. ACIIDS 2014. Lecture Notes in Computer Science, vol 8398. Springer, Cham.
Carrillo P-E. (2013). To Sell or Not to Sell: Measuring the Heat of the Housing Market, Real estate economics, 41, 310–346.
Castelli, M., Dobreva, M., Henriques, R., & Vanneschi, L. (2020). Predicting days on market to optimize real estate sales strategy. Complexity, 2020.
Chang, H.Y., Lin, J.C., Cheng, M.L., Huang, S.C. (2016) A novel incremental data mining algorithm based on FP-growth for Big Data. In: 2016 International Conference on Networking and Network Applications (NaNA), pp. 375–378.
Cheng C-W, Lin C-C, & Leu S-S. (2010). Use of association rules to explore cause–effect relationships in occupational accidents in the Taiwan construction industry, Safety Science 48, 436–444.
Cheng P, Lin Z., & Liu Y. (2008). A Model of Time-on-Market and Real Estate Price Under Sequential Search with Recall, Real estate economics, 36, 813–843
Chiang W-Y (2011). To mine association rules of customer values via a data mining procedure with improved model: An empirical case study, Expert Systems with Applications 38, 1716–1722.
Chiarazzo V, Caggiania L, & Marinelli M. (2014). A Neural Network based model for real estate price estimation considering environmental quality of property location, Transportation Research Procedia. 3, 810 – 817.
Chica-Olmo, J. (2007). Prediction of housing location price by a multivariate spatial method: Cokriging. Journal of Real Estate Research, 29, 92–114.
Czibula G., Maria Z., & Czibula I.G. (2014). Software defect prediction using relational association rule mining, Information Sciences 264, 260–278.
Dambon, J.A., Sigrist, F., & Furrer, R. (2021). Maximum likelihood estimation of spatially varying coefficient models for large data with an application to real estate price prediction, Spatial Statistics, 41, 100470
Doostan M, & Chowdhury B.H. (2017). Power distribution system fault cause analysis by using association rule mining, Electric Power Systems Research 152, 140–147.
Du D., Li A., & Zhang L. (2014). Survey on the Applications of Big Data in Chinese Real Estate Enterprise, Procedia Computer Science, 30, 24 – 33.
Fabozzi, F.J., Kynigakis, I., Panopoulou, E., Tunaru, R.S. (2019). Detecting Bubbles in the US and UK Real Estate Markets. The Journal of Real Estate Finance and Economics, 60, 469–513.
Febrita, R. E., Alfiyatin, A. N.  Taufiq, H. & Mahmudy, W. F. (2017). Data-driven fuzzy rule extraction for housing price prediction in Malang, East Java, International Conference on Advanced Computer Science and Information Systems (ICACSIS), Bali, 2017, pp. 351-358, doi: 10.1109/ICACSIS.2017.8355058.
Feng, W., Zhu, Q., Zhuang, J., Shimin, Y.. An expert recommendation algorithm based on Pearson correlation coefficient and FP-growth. Cluster Comput 22, 7401–7412 (2019).
García-Magariño, I., Medrano, C. & Delgado, J. (2020) Estimation of missing prices in real-estate market agent-based simulations with machine learning and dimensionality reduction methods. Neural Computing and Applications, 32, 2665–2682.
Gerek I.H. (2014). House selling price assessment using two different adaptive neuro-fuzzy techniques, Automation in Construction, 41, 33–39.
Ghosalkar, N.N., & Dhage, S. N. (2018). Real Estate Value Prediction Using Linear Regression, Fourth International Conference on Computing Communication Control and Automation (ICCUBEA), 2018, pp. 1-5, doi: 10.1109/ICCUBEA.2018.8697639.
Ghousi R. (2015). Applying a decision support system for accident analysis by using data mining approach: A case study on one of the Iranian manufactures, Journal of Industrial and Systems Engineering, 8 (3) 59-76.
Goel M., Goel K. (2017) FP-Growth Implementation Using Tries for Association Rule Mining. In: Deep K. et al. (eds) Proceedings of Sixth International Conference on Soft Computing for Problem Solving. Advances in Intelligent Systems and Computing, vol 547. Springer, Singapore.
Guan J, Zurada J, & Levitan A.S. (2008). An adaptive neuro-fuzzy ınference system based approach to real estate property assessment, Journal of Real Estate Research. 30 (4) 395–421.
Guan, J., Shi, D., Zurada, J. M., & Levitan, A. S. (2014). Analyzing Massive Data Sets: An Adaptive Fuzzy Neural Approach for Prediction, with a Real Estate Illustration. In: Journal of Organizational Computing and Electronic Commerce. 24 (1) 94-112.
Jaen, R. D. (2002) Data Mining: An Empirical Application in Real Estate Valuation. In FLAIRS Conference, pp. 314-317.
Juan, Y. K., Shin, S. G., & Perng, Y. H. (2006). Decision support for housing customization: A hybrid approach using case-based reasoning and genetic algorithm. Expert Systems with Applications, 31, 83–93.
Kamara, A.F., Chen, E., Liu, Q, & Pan, Z. (2020). A hybrid neural network for predicting Days on Market a measure of liquidity in real estate industry, Knowledge-Based Systems, 208, 106417
Khalili-Damghani K., Sadi-Nezhad, S., Hosseinzadeh Lotfi, F., & Tavana, M. (2013) A hybrid fuzzy rule-based multi-criteria framework for sustainable project portfolio selection, Information Sciences, 220, 442-462
Korczak J., Skrzypczak P. (2012) FP-Growth in Discovery of Customer Patterns. In: Aberer K., Damiani E., Dillon T. (eds) Data-Driven Process Discovery and Analysis. SIMPDA 2011. Lecture Notes in Business Information Processing, vol 116. Springer, Berlin, Heidelberg.
Król, D., Lasota T., Trawiński B., & Trawiński K. (2007) Comparison of Mamdani and TSK Fuzzy Models for Real Estate Appraisal. In: Apolloni B., Howlett R.J., Jain L. (eds) Knowledge-Based Intelligent Information and Engineering Systems. KES 2007. Lecture Notes in Computer Science, vol 4694. Springer, Berlin, Heidelberg.
Kusan, H, Aytekin, O, & Ozdemir I. (2010). The use of fuzzy logic in predicting house selling price, Expert Systems with Applications. 37, 1808–1813.
Kuo R.J., Lin S.Y., & Shih C.W. (2007). Mining association rules through integration of clustering analysis and ant colony system for health insurance database in Taiwan, Expert Systems with Applications, 33, 794–808.
Lasota T., Telec Z., Trawiński B., & Trawińsk K. (2011) Investigation of the eTS Evolving Fuzzy Systems Applied to Real Estate Appraisal, Multiple-Valued Logic and Soft Computing, 17, 229-253.
Lin K-C, Liao I-E, & Chen Z-S. (2011). An improved frequent pattern growth method for mining association rules, Expert Systems with Applications 38, 5154–5161.
Li, L., & Chu, K. (2017). Prediction of real estate price variation based on economic parameters, International Conference on Applied System Innovation (ICASI), 2017, pp. 87-90, doi: 10.1109/ICASI.2017.7988353.
Liu, J., Zhang, G. X. L., & Wu, W. P. (2006). Application of fuzzy neural network for real estate prediction. Lecture Notes in Computer Science, 3973, 1187–1191.
Mao Y., & Wu W. (2011) Fuzzy Real Option Evaluation of Real Estate Project Based on Risk Analysis, Systems Engineering Procedia, 1, 228–235
Narvekar, M., Syed, S.F., An optimized algorithm for association rule mining using FP tree, Procedia Computer Science, 2015, 45(C), pp. 101–110.
Neloy AA, Haque HMS, & Ul Islam MM (2019) Ensemble learning based rental apartment price prediction model by categorical features factoring. North South Univ. Res. study, pp. 350–356, 2019.
Nguyen, N., & Cripps, A. (2001). Predicting housing value: a comparison of multiple regression analysis and artificial neural networks, J. Real Estate Res. 22 (3) 313–336.
Ngai, E.W.T., Xiu, L. & Chau, D.C.K. (2009). Application of data mining techniques in customer relationship management: a literature review and classification, Expert Systems with Applications, 36, 2592–2602
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 (2015) 2928–2934.
Rachburee N., Arunrerk J., Punlumjeak W. (2018) Failure Part Mining Using an Association Rules Mining by FP-Growth and Apriori Algorithms: Case of ATM Maintenance in Thailand. In: Kim K., Kim H., Baek N. (eds) IT Convergence and Security 2017. Lecture Notes in Electrical Engineering, vol 449. Springer, Singapore.
Sarip, A.G., Hafez, M.B., & MD. Nasir Daud (2016) Application of Fuzzy Regression Model For Real Estate Price Prediction, Malaysian Journal of Computer Science 29(1) 15-27.
Sharma, Nitin & Arora, Yojna & Sharma, Vikas & Gupta, Hardik. (2020). Real Estate Price’s Forecasting Through Predictive Modelling. In book: Machine Learning for Predictive Analysis, Proceedings of ICTIS 2020, pp.589-597, 10.1007/978-981-15-7106-0_58.
Singh, A.K., Kumar, A., Maurya, A.K. (2014) An empirical analysis and comparison of apriori and FP-growth algorithm for frequent pattern mining. In: 2014 International Conference on Advanced Communication Control and Computing Technologies (ICACCCT), pp. 1599– 1602.
Singh, A., Sharma, A. & Dubey, G. (2020). Big data analytics predicting real estate prices. International Journal of Systems Assurance Engineering and Management, 11, 208–219.
Tsai P. S.M., & Chen C-M. (2004). Mining interesting association rules from customer databases and transaction databases, Information Systems 29, 685–696
Yu Y., Lu, J., Shen, D., & Chen B. (2020). Research on real estate pricing methods based on data mining and machine learning, Neural Computing and Applications.  
Zadeh, L.A., Fuzzy sets, Information and Control. 8 (3) (1965). 338–353.
Zhang ML, &Yang Wp. (2012). Fuzzy Comprehensive Evaluation Method Applied in the Real Estate Investment Risks Research, Physics Procedia, 24, 1815 – 1821.
Zheng X., & HuiE.C.M. (2016). Does liquidity affect housing market performance? An empirical study with spatial panel approach, Land Use Policy, 56, 189–196
Zhu H., Xiong H., Tang F., Liu Q, Ge Y., Chen E., & Fu Y. (2016). Days on Market: Measuring Liquidity in Real Estate Markets, In: Proceeding KDD '16 Proceedings of the 22nd ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, pp. 393-402.
  • Receive Date: 11 May 2021
  • Revise Date: 24 July 2021
  • Accept Date: 26 August 2021
  • First Publish Date: 26 August 2021