Smart Property Hub: Revolutionizing Real Estate Management Online

Abstract

The Smart Property Hub is a comprehensive full-stack web-based real estate management platform that digitizes
and streamlines property listing, discovery, and booking workflows. Built using Python Flask as the backend
framework, SQLite as the relational database, and Bootstrap 5 for the dark-themed responsive UI, the system
implements a three-role architecture (Admin, Seller, Buyer) enforced through Python decorator-based RBAC.
Sellers manage property listings across four types (Apartment, Villa, Plot, Commercial) with 12 comprehensive
attributes; buyers browse listings using a five-criteria dynamic SQL search engine and submit booking requests;
administrators exercise full platform oversight through real-time statistics and cascade-safe user management.
The platform comprises 17 distinct routes, 15 Jinja2 HTML templates, and a 3-table SQLite schema (users,
properties, bookings) with PBKDF2-SHA256 password hashing, parameterized SQL injection prevention, and
PRAGMA foreign key enforcement — all containerizable via Docker for zero-cost cloud deployment.