Real Estate Booking Project In Flask

Creating an advanced-level database structure and Flask application for a Real Estate Booking Project involves designing a robust database schema, implementing booking functionality, and creating a user-friendly interface using Bootstrap 5. Below is a detailed breakdown of the project.

1. Database Structure

The database will include the following tables:

Users (for user authentication and roles)
Properties (for storing property details)
Bookings (for storing booking details)
Payments (for storing payment details)
Reviews (for storing user reviews)
Amenities (for storing property amenities)
PropertyImages (for storing property images)

SQL Schema


CREATE TABLE Users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) UNIQUE NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    role ENUM('admin', 'user') NOT NULL DEFAULT 'user',
    email VARCHAR(100) UNIQUE NOT NULL,
    phone VARCHAR(15)
);
CREATE TABLE Properties (
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(100) NOT NULL,
    description TEXT,
    location VARCHAR(255) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    bedrooms INT,
    bathrooms INT,
    created_by INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (created_by) REFERENCES Users(id)
);
CREATE TABLE Bookings (
    id INT PRIMARY KEY AUTO_INCREMENT,
    user_id INT,
    property_id INT,
    check_in DATE NOT NULL,
    check_out DATE NOT NULL,
    total_price DECIMAL(10, 2) NOT NULL,
    status ENUM('pending', 'confirmed', 'cancelled') DEFAULT 'pending',
    FOREIGN KEY (user_id) REFERENCES Users(id),
    FOREIGN KEY (property_id) REFERENCES Properties(id)
);
CREATE TABLE Payments (
    id INT PRIMARY KEY AUTO_INCREMENT,
    booking_id INT,
    amount DECIMAL(10, 2) NOT NULL,
    payment_method VARCHAR(50),
    payment_status ENUM('pending', 'completed', 'failed') DEFAULT 'pending',
    payment_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (booking_id) REFERENCES Bookings(id)
);
CREATE TABLE Reviews (
    id INT PRIMARY KEY AUTO_INCREMENT,
    user_id INT,
    property_id INT,
    rating INT CHECK (rating >= 1 AND rating <= 5),
    comment TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES Users(id),
    FOREIGN KEY (property_id) REFERENCES Properties(id)
);
CREATE TABLE Amenities (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL
);
CREATE TABLE PropertyAmenities (
    property_id INT,
    amenity_id INT,
    PRIMARY KEY (property_id, amenity_id),
    FOREIGN KEY (property_id) REFERENCES Properties(id),
    FOREIGN KEY (amenity_id) REFERENCES Amenities(id)
);
CREATE TABLE PropertyImages (
    id INT PRIMARY KEY AUTO_INCREMENT,
    property_id INT,
    image_url VARCHAR(255) NOT NULL,
    FOREIGN KEY (property_id) REFERENCES Properties(id)
);

2. Flask Application Structure

The Flask application will have the following structure:


real_estate_booking/
│
├── app/
│   ├── __init__.py
│   ├── models.py
│   ├── routes/
│   │   ├── auth.py
│   │   ├── properties.py
│   │   ├── bookings.py
│   │   ├── payments.py
│   │   ├── reviews.py
│   │   └── amenities.py
│   ├── templates/
│   │   ├── base.html
│   │   ├── auth/
│   │   │   ├── login.html
│   │   │   └── register.html
│   │   ├── properties/
│   │   │   ├── list.html
│   │   │   ├── add.html
│   │   │   ├── edit.html
│   │   │   └── detail.html
│   │   ├── bookings/
│   │   │   ├── list.html
│   │   │   ├── add.html
│   │   │   └── detail.html
│   │   ├── payments/
│   │   │   ├── list.html
│   │   │   └── detail.html
│   │   ├── reviews/
│   │   │   ├── list.html
│   │   │   └── add.html
│   │   └── amenities/
│   │       ├── list.html
│   │       ├── add.html
│   │       └── edit.html
│   └── static/
│       ├── css/
│       │   └── styles.css
│       └── js/
│           └── scripts.js
│
├── config.py
├── requirements.txt
└── run.py

3. Flask Application Code

app/init.py


from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_login import LoginManager
from flask_bootstrap import Bootstrap5
db = SQLAlchemy()
login_manager = LoginManager()
def create_app():
    app = Flask(__name__)
    app.config.from_pyfile('config.py')
    db.init_app(app)
    login_manager.init_app(app)
    Bootstrap5(app)
    from .routes.auth import auth_bp
    from .routes.properties import properties_bp
    from .routes.bookings import bookings_bp
    from .routes.payments import payments_bp
    from .routes.reviews import reviews_bp
    from .routes.amenities import amenities_bp
    app.register_blueprint(auth_bp)
    app.register_blueprint(properties_bp)
    app.register_blueprint(bookings_bp)
    app.register_blueprint(payments_bp)
    app.register_blueprint(reviews_bp)
    app.register_blueprint(amenities_bp)
    return app

app/config.py


import os
class Config:
    SECRET_KEY = os.environ.get('SECRET_KEY') or 'a_secret_key'
    SQLALCHEMY_DATABASE_URI = os.environ.get('DATABASE_URL') or 'sqlite:///site.db'
    SQLALCHEMY_TRACK_MODIFICATIONS = False

run.py


from app import create_app
app = create_app()
if __name__ == '__main__':
    app.run(debug=True)

4. Flask Routes

app/routes/auth.py


from flask import Blueprint, render_template, redirect, url_for, flash, request
from flask_login import login_user, logout_user, login_required
from .models import User
from . import db
from werkzeug.security import generate_password_hash, check_password_hash
auth_bp = Blueprint('auth', __name__)
@auth_bp.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        username = request.form['username']
        password = request.form['password']
        user = User.query.filter_by(username=username).first()
        if user and check_password_hash(user.password_hash, password):
            login_user(user)
            return redirect(url_for('properties.list'))
        flash('Invalid username or password')
    return render_template('auth/login.html')
@auth_bp.route('/logout')
@login_required
def logout():
    logout_user()
    return redirect(url_for('auth.login'))
@auth_bp.route('/register', methods=['GET', 'POST'])
def register():
    if request.method == 'POST':
        username = request.form['username']
        password = request.form['password']
        email = request.form['email']
        phone = request.form['phone']
        new_user = User(username=username, password_hash=generate_password_hash(password), email=email, phone=phone)
        db.session.add(new_user)
        db.session.commit()
        flash('Registration successful! Please log in.')
        return redirect(url_for('auth.login'))
    return render_template('auth/register.html')

app/routes/properties.py


from flask import Blueprint, render_template, request, redirect, url_for, flash
from .models import Property, PropertyImage, Amenity, PropertyAmenity
from . import db
from flask_login import login_required, current_user
properties_bp = Blueprint('properties', __name__)
@properties_bp.route('/properties', methods=['GET'])
def list():
    properties = Property.query.all()
    return render_template('properties/list.html', properties=properties)
@properties_bp.route('/properties/add', methods=['GET', 'POST'])
@login_required
def add():
    if request.method == 'POST':
        title = request.form['title']
        description = request.form['description']
        location = request.form['location']
        price = request.form['price']
        bedrooms = request.form['bedrooms']
        bathrooms = request.form['bathrooms']
        new_property = Property(title=title, description=description, location=location, price=price, bedrooms=bedrooms, bathrooms=bathrooms, created_by=current_user.id)
        db.session.add(new_property)
        db.session.commit()
        
        # Handle amenities and images
        amenities = request.form.getlist('amenities')
        for amenity_id in amenities:
            property_amenity = PropertyAmenity(property_id=new_property.id, amenity_id=amenity_id)
            db.session.add(property_amenity)
        
        # Assuming images are uploaded and processed
        # for image_url in uploaded_image_urls:
        #     new_image = PropertyImage(property_id=new_property.id, image_url=image_url)
        #     db.session.add(new_image)
        db.session.commit()
        flash('Property added successfully!')
        return redirect(url_for('properties.list'))
    amenities = Amenity.query.all()
    return render_template('properties/add.html', amenities=amenities)
@properties_bp.route('/properties/edit/<int:id>', methods=['GET', 'POST'])
@login_required
def edit(id):
    property = Property.query.get_or_404(id)
    if request.method == 'POST':
        property.title = request.form['title']
        property.description = request.form['description']
        property.location = request.form['location']
        property.price = request.form['price']
        property.bedrooms = request.form['bedrooms']
        property.bathrooms = request.form['bathrooms']
        db.session.commit()
        flash('Property updated successfully!')
        return redirect(url_for('properties.list'))
    amenities = Amenity.query.all()
    return render_template('properties/edit.html', property=property, amenities=amenities)
@properties_bp.route('/properties/<int:id>', methods=['GET'])
def detail(id):
    property = Property.query.get_or_404(id)
    images = PropertyImage.query.filter_by(property_id=id).all()
    return render_template('properties/detail.html', property=property, images=images)

5. app/routes/bookings.py


from flask import Blueprint, render_template, request, redirect, url_for, flash
from .models import Booking, Property
from . import db
from flask_login import login_required, current_user
bookings_bp = Blueprint('bookings', __name__)
@bookings_bp.route('/bookings', methods=['GET'])
@login_required
def list():
    bookings = Booking.query.filter_by(user_id=current_user.id).all()
    return render_template('bookings/list.html', bookings=bookings)
@bookings_bp.route('/bookings/add/<int:property_id>', methods=['GET', 'POST'])
@login_required
def add(property_id):
    property = Property.query.get_or_404(property_id)
    if request.method == 'POST':
        check_in = request.form['check_in']
        check_out = request.form['check_out']
        total_price = request.form['total_price']  # Calculate based on property price and duration
        new_booking = Booking(user_id=current_user.id, property_id=property.id, check_in=check_in, check_out=check_out, total_price=total_price)
        db.session.add(new_booking)
        db.session.commit()
        flash('Booking created successfully!')
        return redirect(url_for('bookings.list'))
    return render_template('bookings/add.html', property=property)
@bookings_bp.route('/bookings/<int:id>', methods=['GET'])
@login_required
def detail(id):
    booking = Booking.query.get_or_404(id)
    return render_template('bookings/detail.html', booking=booking)

6. app/routes/payments.py


from flask import Blueprint, render_template, request, redirect, url_for, flash
from .models import Payment, Booking
from . import db
from flask_login import login_required, current_user
payments_bp = Blueprint('payments', __name__)
@payments_bp.route('/payments', methods=['GET'])
@login_required
def list():
    payments = Payment.query.filter_by(user_id=current_user.id).all()
    return render_template('payments/list.html', payments=payments)
@payments_bp.route('/payments/add/<int:booking_id>', methods=['GET', 'POST'])
@login_required
def add(booking_id):
    booking = Booking.query.get_or_404(booking_id)
    if request.method == 'POST':
        amount = request.form['amount']
        payment_method = request.form['payment_method']
        new_payment = Payment(booking_id=booking.id, amount=amount, payment_method=payment_method, payment_status='pending')
        db.session.add(new_payment)
        db.session.commit()
        flash('Payment initiated successfully!')
        return redirect(url_for('payments.list'))
    return render_template('payments/add.html', booking=booking)
@payments_bp.route('/payments/<int:id>', methods=['GET'])
@login_required
def detail(id):
    payment = Payment.query.get_or_404(id)
    return render_template('payments/detail.html', payment=payment)

7. app/routes/reviews.py


from flask import Blueprint, render_template, request, redirect, url_for, flash
from .models import Review, Property
from . import db
from flask_login import login_required, current_user
reviews_bp = Blueprint('reviews', __name__)
@reviews_bp.route('/reviews', methods=['GET'])
@login_required
def list():
    reviews = Review.query.filter_by(user_id=current_user.id).all()
    return render_template('reviews/list.html', reviews=reviews)
@reviews_bp.route('/reviews/add/<int:property_id>', methods=['GET', 'POST'])
@login_required
def add(property_id):
    property = Property.query.get_or_404(property_id)
    if request.method == 'POST':
        rating = request.form['rating']
        comment = request.form['comment']
        new_review = Review(user_id=current_user.id, property_id=property.id, rating=rating, comment=comment)
        db.session.add(new_review)
        db.session.commit()
        flash('Review added successfully!')
        return redirect(url_for('reviews.list'))
    return render_template('reviews/add.html', property=property)

8. app/routes/amenities.py


from flask import Blueprint, render_template, request, redirect, url_for, flash
from .models import Amenity
from . import db
from flask_login import login_required
amenities_bp = Blueprint('amenities', __name__)
@amenities_bp.route('/amenities', methods=['GET'])
@login_required
def list():
    amenities = Amenity.query.all()
    return render_template('amenities/list.html', amenities=amenities)
@amenities_bp.route('/amenities/add', methods=['GET', 'POST'])
@login_required
def add():
    if request.method == 'POST':
        name = request.form['name']
        new_amenity = Amenity(name=name)
        db.session.add(new_amenity)
        db.session.commit()
        flash('Amenity added successfully!')
        return redirect(url_for('amenities.list'))
    return render_template('amenities/add.html')
@amenities_bp.route('/amenities/edit/<int:id>', methods=['GET', 'POST'])
@login_required
def edit(id):
    amenity = Amenity.query.get_or_404(id)
    if request.method == 'POST':
        amenity.name = request.form['name']
        db.session.commit()
        flash('Amenity updated successfully!')
        return redirect(url_for('amenities.list'))
    return render_template('amenities/edit.html', amenity=amenity)

9. app/templates/base.html


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="{{ url_for('static', filename='css/styles.css') }}">
    <title>{% block title %}Real Estate Booking{% endblock %}</title>
</head>
<body>
    <nav class="navbar navbar-expand-lg navbar-light bg-light">
        <div class="container-fluid">
            <a class="navbar-brand" href="{{ url_for('properties.list') }}">Real Estate</a>
            <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                <span class="navbar-toggler-icon"></span>
            </button>
            <div class="collapse navbar-collapse">
                <ul class="navbar-nav">
                    <li class="nav-item">
                        <a class="nav-link" href="{{ url_for('auth.login') }}">Login</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="{{ url_for('auth.register') }}">Register</a>
                    </li>
                </ul>
            </div>
        </div>
    </nav>
    <div class="container mt-4">
        {% with messages = get_flashed_messages() %}
            {% if messages %}
                <div class="alert alert-info">
                    {% for message in messages %}
                        <p>{{ message }}</p>
                    {% endfor %}
                </div>
            {% endif %}
        {% endwith %}
        {% block content %}{% endblock %}
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

10. app/templates/auth/login.html


{% extends 'base.html' %}
{% block title %}Login{% endblock %}
{% block content %}
<h2>Login</h2>
<form method="POST">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <button type="submit" class="btn btn-primary">Login</button>
</form>
{% endblock %}

11. app/templates/auth/register.html


{% extends 'base.html' %}
{% block title %}Register{% endblock %}
{% block content %}
<h2>Register</h2>
<form method="POST">
    <div class="mb-3">
        <label for="username" class="form-label">Username</label>
        <input type="text" class="form-control" id="username" name="username" required>
    </div>
    <div class="mb-3">
        <label for="email" class="form-label">Email</label>
        <input type="email" class="form-control" id="email" name="email" required>
    </div>
    <div class="mb-3">
        <label for="phone" class="form-label">Phone</label>
        <input type="text" class="form-control" id="phone" name="phone">
    </div>
    <div class="mb-3">
        <label for="password" class="form-label">Password</label>
        <input type="password" class="form-control" id="password" name="password" required>
    </div>
    <button type="submit" class="btn btn-primary">Register</button>
</form>
{% endblock %}

12. app/templates/properties/list.html


{% extends 'base.html' %}
{% block title %}Properties{% endblock %}
{% block content %}
<h2>Properties</h2>
<a href="{{ url_for('properties.add') }}" class="btn btn-success">Add Property</a>
<table class="table mt-3">
    <thead>
        <tr>
            <th>ID</th>
            <th>Title</th>
            <th>Description</th>
            <th>Location</th>
            <th>Price</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for property in properties %}
        <tr>
            <td>{{ property.id }}</td>
            <td>{{ property.title }}</td>
            <td>{{ property.description }}</td>
            <td>{{ property.location }}</td>
            <td>${{ property.price }}</td>
            <td>
                <a href="{{ url_for('properties.edit', id=property.id) }}" class="btn btn-warning">Edit</a>
                <a href="{{ url_for('properties.detail', id=property.id) }}" class="btn btn-info">View</a>
            </td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{% endblock %}

13. app/templates/properties/add.html


{% extends 'base.html' %}
{% block title %}Add Property{% endblock %}
{% block content %}
<h2>Add Property</h2>
<form method="POST">
    <div class="mb-3">
        <label for="title" class="form-label">Property Title</label>
        <input type="text" class="form-control" id="title" name="title" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" id="description" name="description" required></textarea>
    </div>
    <div class="mb-3">
        <label for="location" class="form-label">Location</label>
        <input type="text" class="form-control" id="location" name="location" required>
    </div>
    <div class="mb-3">
        <label for="price" class="form-label">Price</label>
        <input type="number" class="form-control" id="price" name="price" required>
    </div>
    <div class="mb-3">
        <label for="bedrooms" class="form-label">Bedrooms</label>
        <input type="number" class="form-control" id="bedrooms" name="bedrooms">
    </div>
    <div class="mb-3">
        <label for="bathrooms" class="form-label">Bathrooms</label>
        <input type="number" class="form-control" id="bathrooms" name="bathrooms">
    </div>
    <div class="mb-3">
        <label for="amenities" class="form-label">Amenities</label>
        <select multiple class="form-control" id="amenities" name="amenities">
            {% for amenity in amenities %}
            <option value="{{ amenity.id }}">{{ amenity.name }}</option>
            {% endfor %}
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Add Property</button>
</form>
{% endblock %}

14. app/templates/properties/edit.html


{% extends 'base.html' %}
{% block title %}Edit Property{% endblock %}
{% block content %}
<h2>Edit Property</h2>
<form method="POST">
    <div class="mb-3">
        <label for="title" class="form-label">Property Title</label>
        <input type="text" class="form-control" id="title" name="title" value="{{ property.title }}" required>
    </div>
    <div class="mb-3">
        <label for="description" class="form-label">Description</label>
        <textarea class="form-control" id="description" name="description" required>{{ property.description }}</textarea>
    </div>
    <div class="mb-3">
        <label for="location" class="form-label">Location</label>
        <input type="text" class="form-control" id="location" name="location" value="{{ property.location }}" required>
    </div>
    <div class="mb-3">
        <label for="price" class="form-label">Price</label>
        <input type="number" class="form-control" id="price" name="price" value="{{ property.price }}" required>
    </div>
    <div class="mb-3">
        <label for="bedrooms" class="form-label">Bedrooms</label>
        <input type="number" class="form-control" id="bedrooms" name="bedrooms" value="{{ property.bedrooms }}">
    </div>
    <div class="mb-3">
        <label for="bathrooms" class="form-label">Bathrooms</label>
        <input type="number" class="form-control" id="bathrooms" name="bathrooms" value="{{ property.bathrooms }}">
    </div>
    <div class="mb-3">
        <label for="amenities" class="form-label">Amenities</label>
        <select multiple class="form-control" id="amenities" name="amenities">
            {% for amenity in amenities %}
            <option value="{{ amenity.id }}" {% if amenity.id in property.amenities %}selected{% endif %}>{{ amenity.name }}</option>
            {% endfor %}
        </select>
    </div>
    <button type="submit" class="btn btn-primary">Update Property</button>
</form>
{% endblock %}

15. app/templates/properties/detail.html


{% extends 'base.html' %}
{% block title %}Property Detail{% endblock %}
{% block content %}
<h2>{{ property.title }}</h2>
<p><strong>Description:</strong> {{ property.description }}</p>
<p><strong>Location:</strong> {{ property.location }}</p>
<p><strong>Price:</strong> ${{ property.price }}</p>
<p><strong>Bedrooms:</strong> {{ property.bedrooms }}</p>
<p><strong>Bathrooms:</strong> {{ property.bathrooms }}</p>
<h3>Images</h3>
<div class="row">
    {% for image in images %}
    <div class="col-md-4">
        <img src="{{ image.image_url }}" class="img-fluid" alt="Property Image">
    </div>
    {% endfor %}
</div>
<a href="{{ url_for('bookings.add', property_id=property.id) }}" class="btn btn-primary">Book Now</a>
{% endblock %}

16. app/templates/bookings/list.html


{% extends 'base.html' %}
{% block title %}Bookings{% endblock %}
{% block content %}
<h2>Your Bookings</h2>
<table class="table mt-3">
    <thead>
        <tr>
            <th>ID</th>
            <th>Property</th>
            <th>Check-in</th>
            <th>Check-out</th>
            <th>Total Price</th>
            <th>Status</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for booking in bookings %}
        <tr>
            <td>{{ booking.id }}</td>
            <td>{{ booking.property.title }}</td>
            <td>{{ booking.check_in }}</td>
            <td>{{ booking.check_out }}</td>
            <td>${{ booking.total_price }}</td>
            <td>{{ booking.status }}</td>
            <td>
                <a href="{{ url_for('bookings.detail', id=booking.id) }}" class="btn btn-info">View</a>
            </td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{% endblock %}

17. app/templates/bookings/add.html


{% extends 'base.html' %}
{% block title %}Book Property{% endblock %}
{% block content %}
<h2>Book Property: {{ property.title }}</h2>
<form method="POST">
    <div class="mb-3">
        <label for="check_in" class="form-label">Check-in Date</label>
        <input type="date" class="form-control" id="check_in" name="check_in" required>
    </div>
    <div class="mb-3">
        <label for="check_out" class="form-label">Check-out Date</label>
        <input type="date" class="form-control" id="check_out" name="check_out" required>
    </div>
    <div class="mb-3">
        <label for="total_price" class="form-label">Total Price</label>
        <input type="number" class="form-control" id="total_price" name="total_price" value="{{ property.price }}" readonly>
    </div>
    <button type="submit" class="btn btn-primary">Confirm Booking</button>
</form>
{% endblock %}

18. app/templates/bookings/detail.html


{% extends 'base.html' %}
{% block title %}Booking Detail{% endblock %}
{% block content %}
<h2>Booking ID: {{ booking.id }}</h2>
<p><strong>Property:</strong> {{ booking.property.title }}</p>
<p><strong>Check-in:</strong> {{ booking.check_in }}</p>
<p><strong>Check-out:</strong> {{ booking.check_out }}</p>
<p><strong>Total Price:</strong> ${{ booking.total_price }}</p>
<p><strong>Status:</strong> {{ booking.status }}</p>
{% endblock %}

19. app/templates/payments/list.html


{% extends 'base.html' %}
{% block title %}Payments{% endblock %}
{% block content %}
<h2>Your Payments</h2>
<table class="table mt-3">
    <thead>
        <tr>
            <th>ID</th>
            <th>Booking</th>
            <th>Amount</th>
            <th>Payment Method</th>
            <th>Status</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for payment in payments %}
        <tr>
            <td>{{ payment.id }}</td>
            <td>{{ payment.booking_id }}</td>
            <td>${{ payment.amount }}</td>
            <td>{{ payment.payment_method }}</td>
            <td>{{ payment.payment_status }}</td>
            <td>
                <a href="{{ url_for('payments.detail', id=payment.id) }}" class="btn btn-info">View</a>
            </td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{% endblock %}

20. app/templates/payments/add.html


{% extends 'base.html' %}
{% block title %}Add Payment{% endblock %}
{% block content %}
<h2>Payment for Booking ID: {{ booking.id }}</h2>
<form method="POST">
    <div class="mb-3">
        <label for="amount" class="form-label">Amount</label>
 ```html
        <input type="number" class="form-control" id="amount" name="amount" value="{{ booking.total_price }}" readonly>
    </div>
    <div class="mb-3">
        <label for="payment_method" class="form-label">Payment Method</label>
        <input type="text" class="form-control" id="payment_method" name="payment_method" required>
    </div>
    <button type="submit" class="btn btn-primary">Process Payment</button>
</form>
{% endblock %}

21. app/templates/payments/detail.html


{% extends 'base.html' %}
{% block title %}Payment Detail{% endblock %}
{% block content %}
<h2>Payment ID: {{ payment.id }}</h2>
<p><strong>Booking ID:</strong> {{ payment.booking_id }}</p>
<p><strong>Amount:</strong> ${{ payment.amount }}</p>
<p><strong>Payment Method:</strong> {{ payment.payment_method }}</p>
<p><strong>Status:</strong> {{ payment.payment_status }}</p>
<p><strong>Payment Date:</strong> {{ payment.payment_date }}</p>
{% endblock %}

22. app/templates/reviews/list.html


{% extends 'base.html' %}
{% block title %}Reviews{% endblock %}
{% block content %}
<h2>Your Reviews</h2>
<table class="table mt-3">
    <thead>
        <tr>
            <th>ID</th>
            <th>Property</th>
            <th>Rating</th>
            <th>Comment</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for review in reviews %}
        <tr>
            <td>{{ review.id }}</td>
            <td>{{ review.property.title }}</td>
            <td>{{ review.rating }}</td>
            <td>{{ review.comment }}</td>
            <td>
                <a href="{{ url_for('reviews.add', property_id=review.property_id) }}" class="btn btn-warning">Edit</a>
            </td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{% endblock %}

23. app/templates/reviews/add.html


{% extends 'base.html' %}
{% block title %}Add Review{% endblock %}
{% block content %}
<h2>Add Review for Property: {{ property.title }}</h2>
<form method="POST">
    <div class="mb-3">
        <label for="rating" class="form-label">Rating</label>
        <input type="number" class="form-control" id="rating" name="rating" min="1" max="5" required>
    </div>
    <div class="mb-3">
        <label for="comment" class="form-label">Comment</label>
        <textarea class="form-control" id="comment" name="comment" required></textarea>
    </div>
    <button type="submit" class="btn btn-primary">Submit Review</button>
</form>
{% endblock %}

24. app/templates/amenities/list.html


{% extends 'base.html' %}
{% block title %}Amenities{% endblock %}
{% block content %}
<h2>Amenities</h2>
<a href="{{ url_for('amenities.add') }}" class="btn btn-success">Add Amenity</a>
<table class="table mt-3">
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for amenity in amenities %}
        <tr>
            <td>{{ amenity.id }}</td>
            <td>{{ amenity.name }}</td>
            <td>
                <a href="{{ url_for('amenities.edit', id=amenity.id) }}" class="btn btn-warning">Edit</a>
            </td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{% endblock %}

25. app/templates/amenities/add.html


{% extends 'base.html' %}
{% block title %}Add Amenity{% endblock %}
{% block content %}
<h2>Add Amenity</h2>
<form method="POST">
    <div class="mb-3">
        <label for="name" class="form-label">Amenity Name</label>
        <input type="text" class="form-control" id="name" ```html
name="name" required>
    </div>
    <button type="submit" class="btn btn-primary">Add Amenity</button>
</form>
{% endblock %}

26. app/templates/amenities/edit.html


{% extends 'base.html' %}
{% block title %}Edit Amenity{% endblock %}
{% block content %}
<h2>Edit Amenity</h2>
<form method="POST">
    <div class="mb-3">
        <label for="name" class="form-label">Amenity Name</label>
        <input type="text" class="form-control" id="name" name="name" value="{{ amenity.name }}" required>
    </div>
    <button type="submit" class="btn btn-primary">Update Amenity</button>
</form>
{% endblock %}

27. config.py


import os
class Config:
    SECRET_KEY = os.environ.get('SECRET_KEY') or 'your_secret_key'
    SQLALCHEMY_DATABASE_URI = os.environ.get('DATABASE_URL') or 'sqlite:///site.db'
    SQLALCHEMY_TRACK_MODIFICATIONS = False

28. requirements.txt


Flask
Flask-SQLAlchemy
Flask-Login
Flask-Bootstrap

29. run.py


from app import create_app
app = create_app()
if __name__ == '__main__':
    app.run(debug=True)

This structure provides a comprehensive foundation for an advanced real estate booking project using Flask and Bootstrap 5. You can expand upon this by adding features such as user roles, property search functionality, and more sophisticated booking and payment handling.