03

DKM Real Estate Platform

Automated Blacklist Alert System & Admin Dashboard for Indonesian Students in Egypt

Python Django Telegram Bot API JavaScript PostgreSQL Leaflet.js
Project screenshot showing administrator CRUD

Project Info

Timeline

2026 - 2027

Role

Full Stack Developer & Bot Engineer

Client

DKKM PPMI Egypt

Status

βœ… Live & Active

Overview

DKM Real Estate Platform is a comprehensive automation solution designed to help Indonesian students in Egypt identify blacklisted properties quickly and efficiently. The system consists of a Telegram bot for instant property alerts and an admin dashboard for centralized data management.

Previously, blacklist information was scattered across WhatsApp channels and Instagram story highlights, making it difficult for students to access current data. Outdated listings remained visible, and properties that had been cleared were still marked as problematic. This platform centralizes all information with real-time updates, location-based search via Telegram bot, and comprehensive Django Admin dashboard with Leaflet map integration.

Transforming fragmented housing warnings into an automated, location-based alert system with centralized management.

The Challenge

πŸ“±

Fragmented Data

Property blacklist information was scattered across WhatsApp channels and Instagram story highlights, requiring students to manually check multiple sources regularly to stay updated.

⚠️

Outdated Records

Properties cleared from blacklist remained in old posts, while newly problematic units weren't quickly documented, causing confusion and misinformation among students.

The Solution

πŸ€–

Telegram Bot Alert

Students can share their location via Telegram to instantly receive information about nearby blacklisted properties, complete with building details, unit numbers, owner info, and blacklist reasons.

Location Sharing Instant Alerts Proximity Search
πŸ—ΊοΈ

Leaflet-Integrated Dashboard

Django Admin dashboard with Leaflet.js map integration allows DKKM staff to create, edit, and manage buildings and units with precise location mapping using OpenStreetMap for accurate proximity searches.

Leaflet Maps Django Admin Location Pins
πŸ”„

Real-Time Sync

Centralized PostgreSQL database ensures both bot and dashboard access the same up-to-date information, eliminating discrepancies and outdated blacklist data.

Live Database Auto Updates Data Consistency
πŸ“Š

Comprehensive Management

Admin interface allows complete control over buildings, units, and blacklist status with detailed forms, search filters, and batch operations for efficient data management.

Full CRUD Search & Filter Batch Updates

Key Features

01

Location-Based Bot Search

Students share their location in Telegram to instantly discover nearby buildings with blacklisted units, sorted by proximity with complete property details.

  • GPS coordinate detection
  • Radius-based property search
  • Building and unit details
  • Owner info and blacklist reasons
Project screenshot showing bot shareloc implementation
Project screenshot showing dashboard leaflet integration
02

Django Admin with Leaflet Maps

Comprehensive Django Admin interface with Leaflet.js integration for managing buildings, units, and blacklist status with precise location mapping and visual property management on OpenStreetMap.

  • Interactive Leaflet map interface
  • Create/edit buildings & units
  • Pin locations on OpenStreetMap
  • Manage blacklist status
03

Real-Time Data Management

Centralized database ensures instant synchronization between bot and dashboard, with automatic updates when properties are added, modified, or removed from blacklist.

  • Live database synchronization
  • Instant bot updates
  • Status change tracking
  • Audit log for changes
Project screenshot showing dashboard realtime data

Technology Stack

🐍

Backend

  • Python 3.11
  • Django 6.0
  • Django Admin
  • python-telegram-bot
  • PostgreSQL
πŸ’»

Frontend

  • JavaScript ES6+
  • HTML5 & CSS3
  • Django Templates
πŸ—ΊοΈ

Maps & APIs

  • Leaflet.js
  • OpenStreetMap
  • Telegram Bot API
  • Geolocation API
πŸš€

DevOps

  • Docker
  • Ubuntu Server
  • Git & GitHub

Interested in working together?

Let's keep in touch and discuss your next project