Viewing File: D:\INETPUB\VHOSTS\officespacebangalore.com\httpdocs\index.php


<?php

require_once __DIR__ . '/config.php';

$pageTitle = 'Find a space worth moving for';

$pdo = db();

/* =========================================================
   PROPERTY DATA
   ========================================================= */

$featured = $pdo
    ->query("
        SELECT *
        FROM property
        WHERE status = 'available'
        ORDER BY isFeatured DESC, pid DESC
        LIMIT 6
    ")
    ->fetchAll();

$cities = cities_from_properties();

$allCount = (int) $pdo
    ->query("
        SELECT COUNT(*)
        FROM property
        WHERE status = 'available'
    ")
    ->fetchColumn();

$rentCount = (int) $pdo
    ->query("
        SELECT COUNT(*)
        FROM property
        WHERE status = 'available'
        AND LOWER(stype) = 'rent'
    ")
    ->fetchColumn();

$saleCount = (int) $pdo
    ->query("
        SELECT COUNT(*)
        FROM property
        WHERE status = 'available'
        AND LOWER(stype) = 'sale'
    ")
    ->fetchColumn();


/* =========================================================
   CLIENT FEEDBACK
   ========================================================= */

$feedback = [];

try {
    $feedback = $pdo
        ->query("
            SELECT
                f.fdescription,
                u.uname
            FROM feedback f
            LEFT JOIN user u
                ON u.uid = f.uid
            WHERE f.fdescription <> ''
              AND f.status = 1
            ORDER BY f.fid DESC
            LIMIT 3
        ")
        ->fetchAll();
} catch (Throwable $e) {
    $feedback = [];
}


include __DIR__ . '/includes/site-header.php';

?>

<!-- =========================================================
     HERO
     ========================================================= -->

<section class="hero-home hero-home-premium">

    <div class="hero-overlay"></div>

    <div class="container hero-layout">

        <!-- Hero Content -->
        <div class="hero-content">

            <div class="hero-kicker">
                <span></span>
                PREMIUM PROPERTY MARKETPLACE
            </div>

            <h1>
                Find a space that<br>
                <em>feels right.</em>
            </h1>

            <p>
                Discover offices, homes and commercial opportunities
                presented with clarity. Search your live property
                inventory and move from browsing to enquiry without
                the noise.
            </p>

            <div class="hero-actions">

                <a class="btn btn-light" href="<?= url('properties.php') ?>">
                    Explore properties <span>↗</span>
                </a>

                <a class="hero-link" href="<?= url('contact.php') ?>">
                    Talk to an expert <span>→</span>
                </a>

            </div>

            <div class="hero-proof">
                <span class="proof-dot"></span>
                <strong>Live inventory</strong>
                <span>Connected to your property database</span>
            </div>

        </div>


        <!-- Property Search Card -->
        <div class="hero-search-card">

            <div class="search-card-glow"></div>

            <div class="search-card-top">

                <div>

                    <div class="search-card-kicker">
                        PROPERTY SEARCH
                    </div>

                    <h2>
                        What are you<br>
                        looking for?
                    </h2>

                </div>

                <div class="search-card-icon">
                    ⌕
                </div>

            </div>


            <form
                action="<?= url('properties.php') ?>"
                method="get"
                class="premium-search-form"
            >

                <!-- Purpose -->
                <div class="purpose-tabs">

                    <label>
                        <input
                            type="radio"
                            name="stype"
                            value=""
                            checked
                        >
                        <span>All</span>
                    </label>

                    <label>
                        <input
                            type="radio"
                            name="stype"
                            value="rent"
                        >
                        <span>Rent</span>
                    </label>

                    <label>
                        <input
                            type="radio"
                            name="stype"
                            value="sale"
                        >
                        <span>Sale</span>
                    </label>

                </div>


                <!-- Location / Keyword -->
                <label class="field-label">

                    LOCATION / KEYWORD

                    <span class="field-wrap">
                        <i>⌖</i>

                        <input
                            name="q"
                            type="text"
                            placeholder="City, location or property"
                        >
                    </span>

                </label>


                <!-- City -->
                <label class="field-label">

                    CITY

                    <span class="field-wrap">
                        <i>⌖</i>

                        <select name="city">

                            <option value="">
                                All cities
                            </option>

                            <?php foreach ($cities as $c): ?>

                                <option value="<?= e($c['city']) ?>">
                                    <?= e($c['city']) ?>
                                </option>

                            <?php endforeach; ?>

                        </select>

                    </span>

                </label>


                <!-- Search Button -->
                <button
                    class="premium-search-button"
                    type="submit"
                >
                    <span>
                        Search available spaces
                    </span>

                    <b>↗</b>
                </button>


                <!-- Search Note -->
                <div class="search-card-note">
                    <span>✓</span>
                    Search results are pulled from your live
                    property inventory.
                </div>

            </form>

        </div>

    </div>

</section>



<!-- =========================================================
     FEATURED PROPERTIES
     ========================================================= -->

<section class="section section-light">

    <div class="container">

        <div class="section-head">

            <div>

                <div class="eyebrow">
                    SELECTED FOR YOU
                </div>

                <h2>
                    Featured spaces
                </h2>

                <p>
                    Strong listings from your live property inventory.
                </p>

            </div>

            <a
                class="outline-btn"
                href="<?= url('properties.php') ?>"
            >
                View all ↗
            </a>

        </div>


        <div class="properties-grid">

            <?php foreach ($featured as $p): ?>

                <?php
                include __DIR__ . '/includes/card.php';
                ?>

            <?php endforeach; ?>

        </div>

    </div>

</section>














<!-- =========================================================
     STATS
     ========================================================= -->

<section class="stats-band">

    <div class="container stats-grid">

        <div>
            <strong><?= $allCount ?>+</strong>
            <span>Available properties</span>
        </div>

        <div>
            <strong><?= $rentCount ?></strong>
            <span>Spaces for rent</span>
        </div>

        <div>
            <strong><?= $saleCount ?></strong>
            <span>Properties for sale</span>
        </div>

        <div>
            <strong><?= count($cities) ?></strong>
            <span>Active locations</span>
        </div>

    </div>

</section>





<!-- =========================================================
     BROWSE BY DESTINATION
     ========================================================= -->

<section class="section destination-section">

    <div class="container">

        <div class="eyebrow">
            BROWSE BY DESTINATION
        </div>

        <h2>
            Where are you looking?
        </h2>


        <div class="destination-grid">

            <?php foreach ($cities as $i => $c): ?>

                <a
                    class="destination-card"
                    href="<?= url(
                        'properties.php?city=' . rawurlencode($c['city'])
                    ) ?>"
                >

                    <span class="destination-num">
                        <?= str_pad(
                            (string) ($i + 1),
                            2,
                            '0',
                            STR_PAD_LEFT
                        ) ?>
                    </span>

                    <div>

                        <h3>
                            <?= e($c['city']) ?>
                        </h3>

                        <p>
                            <?= number_format((int) $c['total']) ?>
                            available spaces
                        </p>

                    </div>

                    <span class="destination-arrow">
                        ↗
                    </span>

                </a>

            <?php endforeach; ?>


            <?php if (!$cities): ?>

                <div class="destination-card">

                    <div>

                        <h3>
                            Your cities will appear here
                        </h3>

                        <p>
                            Add available properties to the database.
                        </p>

                    </div>

                </div>

            <?php endif; ?>

        </div>

    </div>

</section>


<!-- =========================================================
     WHAT WE DO
     ========================================================= -->

<section class="section what-section">

    <div class="container">

        <div class="center-head">

            <div class="eyebrow">
                WHAT WE DO
            </div>

            <h2>
                Everything you need to move with confidence.
            </h2>

            <p>
                From discovery to decision, we make property search
                simpler, clearer and more useful.
            </p>

        </div>


        <div class="what-grid">

            <!-- Buying & Selling -->
            <div class="what-item">

                <div class="line-icon">
                    ⌂
                    <span>₹</span>
                </div>

                <h3>
                    Buying &amp; Selling
                </h3>

                <p>
                    Whether you are buying or selling, our property
                    inventory and market knowledge help you move
                    toward the right transaction.
                </p>

            </div>


            <!-- Rental Service -->
            <div class="what-item">

                <div class="line-icon">
                    ▣
                </div>

                <h3>
                    Rental Service
                </h3>

                <p>
                    Find furnished offices, commercial spaces and
                    other rental opportunities matched to your
                    business or personal requirement.
                </p>

            </div>


            <!-- Property Listing -->
            <div class="what-item">

                <div class="line-icon">
                    ☑
                </div>

                <h3>
                    Property Listing
                </h3>

                <p>
                    Present your property clearly with strong
                    visuals, essential details and a direct route
                    for enquiries.
                </p>

            </div>


            <!-- Investment Guidance -->
            <div class="what-item">

                <div class="line-icon">
                    ↗
                </div>

                <h3>
                    Investment Guidance
                </h3>

                <p>
                    Explore opportunities with practical information
                    and a straightforward path from first interest
                    to serious enquiry.
                </p>

            </div>

        </div>

    </div>

</section>


<!-- =========================================================
     HOW IT WORKS
     ========================================================= -->

<section class="section how-section">

    <div class="container">

        <div class="center-head">

            <div class="eyebrow">
                STEPS TO FIND YOUR SPACE
            </div>

            <h2>
                A simpler way to find the right property.
            </h2>

        </div>


        <div class="steps-grid">

            <!-- Step 01 -->
            <div class="step">

                <div class="step-circle">
                    <span>01</span>
                    <i>⌕</i>
                </div>

                <div class="step-line"></div>

                <h3>
                    View Property
                </h3>

                <p>
                    Browse verified listings with pricing, location,
                    area, features and images.
                </p>

            </div>


            <!-- Step 02 -->
            <div class="step">

                <div class="step-circle">
                    <span>02</span>
                    <i>↗</i>
                </div>

                <div class="step-line"></div>

                <h3>
                    Contact Agency
                </h3>

                <p>
                    Send an enquiry or call the team for more details
                    and a site visit.
                </p>

            </div>


            <!-- Step 03 -->
            <div class="step">

                <div class="step-circle">
                    <span>03</span>
                    <i>♢</i>
                </div>

                <div class="step-line"></div>

                <h3>
                    Visit &amp; Decide
                </h3>

                <p>
                    Compare the space, understand the terms and
                    choose the opportunity that fits.
                </p>

            </div>


            <!-- Step 04 -->
            <div class="step">

                <div class="step-circle">
                    <span>04</span>
                    <i>✓</i>
                </div>

                <h3>
                    Move Forward
                </h3>

                <p>
                    Complete the required checks and proceed with
                    the transaction confidently.
                </p>

            </div>

        </div>

    </div>

</section>


<!-- =========================================================
     MEMBERS / ASSOCIATIONS
     ========================================================= -->

<section class="section members-section">

    <div class="container">

        <div class="center-head">

            <div class="eyebrow">
                MEMBERS OF
            </div>

            <h2>
                Trusted industry associations
            </h2>

            <p>
                Membership marks can be managed from the website
                assets as your organisation's affiliations change.
            </p>

        </div>


        <div class="members-grid">

            <div class="member-logo">
              <img src="assets/img/asso1.jpg" alt="" />

                <b>NAR</b>
                <span>
                    National Association<br>
                    of Realtors
                </span>
            </div>

            <div class="member-logo">
                <img src="assets/img/asso2.jpg" alt="" />
                <b>BRAI</b>
                <span>
                    Bangalore Realtors<br>
                    Association of India
                </span>
            </div>

            <div class="member-logo">
                <img src="assets/img/asso3.jpg" alt="" />
                <b>ICREA</b>
                <span>
                    International Council<br>
                    of Real Estate Associations
                </span>
            </div>

            <div class="member-logo">
                <img src="assets/img/asso4.jpg" alt="" />
                <b>CRISIL</b>
                <span>
                    Ratings &amp; Research
                </span>
            </div>

            <div class="member-logo">
                <img src="assets/img/asso5.jpg" alt="" />
                <b>FIABCI</b>
                <span>
                    International Real Estate<br>
                    Federation
                </span>
            </div>

            <div class="member-logo">
                <img src="assets/img/asso6.jpg" alt="" />
                <b>FNAIM</b>
                <span>
                    Real Estate Professionals
                </span>
            </div>

        </div>

    </div>

</section>


<!-- =========================================================
     WHY Office Space Bangalore
     ========================================================= -->

<section class="section why-section">

    <div class="container feature-split">

        <!-- Feature Panel -->
        <div class="feature-panel">

            <div class="eyebrow">
                WHY Office Space Bangalore
            </div>

            <h2>
                A calmer way to find the right property.
            </h2>


            <div class="feature-list">

                <div>

                    <span class="check">
                        ✓
                    </span>

                    <div>

                        <strong>
                            Real inventory
                        </strong>

                        <span>
                            Your existing database powers every listing.
                        </span>

                    </div>

                </div>


                <div>

                    <span class="check">
                        ✓
                    </span>

                    <div>

                        <strong>
                            Clear information
                        </strong>

                        <span>
                            Pricing, location, area and features are
                            surfaced immediately.
                        </span>

                    </div>

                </div>


                <div>

                    <span class="check">
                        ✓
                    </span>

                    <div>

                        <strong>
                            Direct enquiries
                        </strong>

                        <span>
                            Turn property interest into an actionable
                            customer lead.
                        </span>

                    </div>

                </div>

            </div>

        </div>


        <!-- Editorial Panel -->
        <div class="editorial">

            <div class="eyebrow">
                BUILT FOR BUSINESS
            </div>

            <h3>
                From first impression to serious enquiry.
            </h3>

            <p>
                Your website should do more than display property.
                It should make the decision easier. The experience
                puts the most important information first and gives
                your team a clear route to every enquiry.
            </p>

            <a
                class="btn btn-dark"
                href="<?= url('about.php') ?>"
            >
                Discover our story →
            </a>

        </div>

    </div>

</section>


<!-- =========================================================
     CLIENT TESTIMONIALS
     ========================================================= -->

<?php if ($feedback): ?>

    <section class="section testimonials">

        <div class="container">

            <div class="center-head">

                <div class="eyebrow">
                    CLIENT VOICES
                </div>

                <h2>
                    Trusted conversations.
                </h2>

            </div>


            <div class="testimonial-grid">

                <?php foreach ($feedback as $f): ?>

                    <div class="quote">

                        <div class="stars">
                            ★★★★★
                        </div>

                        <p>
                            “<?= e(
                                truncate_text(
                                    $f['fdescription'],
                                    260
                                )
                            ) ?>”
                        </p>

                        <small>
                            <?= e(
                                $f['uname']
                                    ?: 'Office Space Bangalore customer'
                            ) ?>
                        </small>

                    </div>

                <?php endforeach; ?>

            </div>

        </div>

    </section>

<?php endif; ?>


<!-- =========================================================
     FINAL CTA
     ========================================================= -->

<section class="cta">

    <div class="container cta-box">

        <div>

            <div class="eyebrow">
                HAVE A REQUIREMENT?
            </div>

            <h2>
                Tell us what you need. We'll help you find the space.
            </h2>

            <p>
                Office, commercial property, home or investment —
                start with a requirement and let the team take it
                forward.
            </p>

        </div>


        <a
            class="btn btn-light"
            href="<?= url('contact.php') ?>"
        >
            Start an enquiry ↗
        </a>

    </div>

</section>


<?php

include __DIR__ . '/includes/site-footer.php';

?>
Back to Directory File Manager