Property Management System

Yomik Pandya, Aditya Thakur, Drumil Pistolwala, Kash Trivedi, Theres Bemila, Ankita AwsarmalInternational Journal for Research in Applied Science and Engineering Technology 2023 · DOI

Abstract

The price of a house increases annually based on location, reflecting the broader economic climate. Consequently, there is a critical need for systems capable of predicting future house sales to assist both buyers and sellers. This research utilizes a dataset from Pune, India, containing over 68,613 entries for training and testing. The analysis examines the impact of markdowns, size, price, and area on sales using various machine learning algorithms. By estimating home sales, developers can better determine selling prices, and buyers can identify optimal purchase times. The system evaluates property value based on three primary factors: physical conditions, concept, and location.

Introduction

Real estate represents one of the most significant financial and emotional investments for individuals. However, the traditional property market is often characterized by opacity and inefficiency. Buyers frequently struggle to determine fair market value, while sellers and developers find it challenging to time their market entries or price assets competitively.

This research addresses the gap for a centralized, data-driven system capable of accurately estimating property values based on specific characteristics. By leveraging machine learning (ML), the proposed system aims to provide a transparent "ground truth" for property valuations, creating a safer and more efficient environment for all stakeholders in the real estate ecosystem.

Methodology

The researchers developed a comprehensive full-stack solution integrating a user-facing web application with a predictive backend.

Web Framework

The application utilizes Python Django, a high-level framework chosen for its robustness in handling complex, database-driven environments. The system implements three distinct user roles:

  • Admin: Responsible for overall system oversight and data management.
  • Broker: Facilitates the listing and management of property entries.
  • End-User: Enables browsing, searching, and viewing price predictions for properties.

Machine Learning Pipeline

The predictive core was developed using Google Colab, focusing on supervised learning algorithms to model property values. Two primary models were evaluated:

  1. Linear Regression: Employed as a baseline to establish linear relationships between property features and market prices.
  2. Random Forest: An ensemble learning method that constructs multiple decision trees. This approach was selected for its ability to capture non-linear relationships and improve overall prediction accuracy.

Data preprocessing and manipulation were performed using the pandas and NumPy libraries, while model training and evaluation were conducted via scikit-learn (sklearn).

Database Management

A MySQL database serves as the backend storage, managed through tools like MySQL Workbench and DBeaver. This ensures data integrity and efficient retrieval for the thousands of property listings within the system.

Dataset Description

The study focuses on the housing market in Pune, India, utilizing a substantial dataset:

  • Volume: Over 68,613 entries, partitioned into training and testing sets.
  • Features: Key variables include property size, price, area, and physical condition.
  • Context: By focusing on a specific high-growth metropolitan area, the model captures local economic nuances that broader, national-level datasets might overlook.

Results and Analysis

The performance of the predictive models was measured using Mean Square Error (MSE) and Root Mean Square Error (RMSE), where lower values indicate higher precision. The experimental results demonstrate a significant performance gap between the two algorithms:

  • Linear Regression: Produced an RMSE of approximately 77.82.
  • Random Forest: Achieved a significantly improved RMSE of approximately 25.99.

The Random Forest model reduced the error margin by nearly two-thirds compared to the linear approach, proving its superior precision in handling the complexities of real estate data. Qualitatively, the project successfully integrated these models into a functional Django interface, allowing brokers to upload data and providing users with automated, dynamic price predictions.

Conclusion and Future Work

The research identifies physical conditions, concept, and location as the three pillars of property valuation. By embedding predictive models into a functional workflow, the study moves beyond theoretical analysis to provide a practical tool for the real estate industry.

Future work will focus on expanding the geographic scope to other major Indian hubs like Mumbai and Delhi, enriching the feature set with granular data such as proximity to public transport, and exploring blockchain integration for secure transaction history. Additionally, transitioning to real-time market feeds would allow the system to adapt dynamically to sudden economic shifts.

Summary updated

Abstract

The price of a house is increased every year according to the location. It indicates the current economic situation so there is a need for a system to predict house sales in the future for both buyer and the seller. Here we use a dataset of Pune with more than 68,613 entries of train data and test data of housing sales in India. This analysis includes the effect of markdowns on sales and the extent of effects on the sales by size, price, area etc. has been analysed using different machine learning algorithms. Estimating home sales can help the developer determine the selling price of the home and the best time for the buyer to purchase the home. The output values of the algorithms are estimated based on the input characteristics from the data presented in the system and the analysis is a process. Physical conditions, concept and location are the three factors that determine the selling price of a property.
BibTeX
@article{pandya2023property,
  author = {Yomik Pandya and Aditya Thakur and Drumil Pistolwala and Kash Trivedi and Theres Bemila and Ankita Awsarmal},
  title = {{Property Management System}},
  journal = {International Journal for Research in Applied Science and Engineering Technology},
  year = {2023},
  doi = {10.22214/ijraset.2023.51218},
}
Figure