<!-- Detekován kraj/lokalita z GET: Praha 9 - Sokolovská / praha 9 - sokolovska --><!-- DEBUG SQL: SELECT 
            id, 
            title, 
            price, 
            location, 
            rooms, 
            bedrooms, 
            area, 
            address, 
            city, 
            postal_code, 
            agency_name, 
            street, 
            house_number, 
            latitude, 
            longitude,
            property_type,
            type,
            transaction_type,
            transaction,
            disposition,
            COALESCE(
                NULLIF(real_estate_ads.main_image_url, ''),
                NULLIF(real_estate_ads.image_url, ''),
                NULLIF(real_estate_ads.image_file_path, ''),
                NULLIF(real_estate_ads.image, ''),
                (
                    SELECT pi.image_url 
                    FROM property_images pi 
                    WHERE pi.property_id = real_estate_ads.id 
                    AND pi.is_primary = 1 
                    LIMIT 1
                ),
                (
                    SELECT pi2.image_url 
                    FROM property_images pi2 
                    WHERE pi2.property_id = real_estate_ads.id 
                    LIMIT 1
                ),
                'uploads/images/default_property/default_property.jpg'
            ) AS image_url
        FROM real_estate_ads 
        WHERE is_visible = 1 AND (
        LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(location,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE ?
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(region_clean,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE ?
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(city,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE ?
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(address,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE ?
        OR LOWER(title) LIKE ?
        OR LOWER(description) LIKE ?
    ) --><!-- DEBUG PARAMS: %praha 9 - sokolovska%, %praha 9 - sokolovska%, %praha 9 - sokolovska%, %praha 9 - sokolovska%, %praha 9 - sokolovská%, %praha 9 - sokolovská% --><!-- DEBUG SQL COMPLETE: SELECT 
            id, 
            title, 
            price, 
            location, 
            rooms, 
            bedrooms, 
            area, 
            address, 
            city, 
            postal_code, 
            agency_name, 
            street, 
            house_number, 
            latitude, 
            longitude,
            property_type,
            type,
            transaction_type,
            transaction,
            disposition,
            COALESCE(
                NULLIF(real_estate_ads.main_image_url, ''),
                NULLIF(real_estate_ads.image_url, ''),
                NULLIF(real_estate_ads.image_file_path, ''),
                NULLIF(real_estate_ads.image, ''),
                (
                    SELECT pi.image_url 
                    FROM property_images pi 
                    WHERE pi.property_id = real_estate_ads.id 
                    AND pi.is_primary = 1 
                    LIMIT 1
                ),
                (
                    SELECT pi2.image_url 
                    FROM property_images pi2 
                    WHERE pi2.property_id = real_estate_ads.id 
                    LIMIT 1
                ),
                'uploads/images/default_property/default_property.jpg'
            ) AS image_url
        FROM real_estate_ads 
        WHERE is_visible = 1 AND (
        LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(location,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE '%praha 9 - sokolovska%'
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(region_clean,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE '%praha 9 - sokolovska%'
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(city,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE '%praha 9 - sokolovska%'
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(address,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE '%praha 9 - sokolovska%'
        OR LOWER(title) LIKE '%praha 9 - sokolovská%'
        OR LOWER(description) LIKE '%praha 9 - sokolovská%'
    ) --><!DOCTYPE html>
<html lang="cs">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- společná hlavička -->
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<!-- 🔵 Favicon sada -->
<link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png?v=11">
<link rel="icon" type="image/png" sizes="192x192" href="/favicon-192x192.png?v=11">
<link rel="icon" type="image/png" sizes="512x512" href="/favicon-512x512.png?v=11">
<link rel="apple-touch-icon" sizes="180x180" href="/favicon-180x180.png?v=11">

<!-- 🔵 PWA manifest -->
<link rel="manifest" href="/manifest.json">

<!-- 🔵 PWA ikony -->
<link rel="icon" type="image/png" sizes="192x192" href="/icon-192.png">
<link rel="icon" type="image/png" sizes="512x512" href="/icon-512.png">
<link rel="icon" type="image/png" sizes="512x512" href="/maskable_icon.png" purpose="maskable">

<!-- 🔵 iOS PWA -->
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-title" content="GlovatoReal">
<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">

<!-- 🔵 Barva horní lišty pro Android Chrome -->
<meta name="theme-color" content="#0078e7">

<!-- 🔵 Glovato styly -->
<link rel="stylesheet" href="/assets/zillow-agent-profile.css">

<!-- 🔵 PWA Script: registrace service workeru -->
<script>
if ("serviceWorker" in navigator) {
    window.addEventListener("load", () => {
        navigator.serviceWorker.register("/service-worker.js")
            .then(reg => console.log("Service Worker registrován:", reg))
            .catch(err => console.warn("SW registrace selhala:", err));
    });
}
</script>

    <title>Výpis nemovitostí | GlovatoReal</title>

<link rel="canonical" href="https://glovatoreal.cz/vypis.php?region=Praha+9+-+Sokolovsk%C3%A1">

    <link rel="stylesheet" href="styles.css">
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://unpkg.com/leaflet/dist/leaflet.js"></script>
    <link rel="stylesheet" href="https://unpkg.com/leaflet/dist/leaflet.css">

<style>
    * {
        box-sizing: border-box;
    }

    html,
    body {
        margin: 0;
        width: 100%;
        min-height: 100%;
        font-family: Arial, sans-serif;
        background: #f5f7fb;
        color: #102a43;
        overflow-x: hidden;
    }

    body {
        padding: 0;
    }

    .results-page {
        padding-top: 72px;
        min-height: 100vh;
        background: #f5f7fb;
    }

    .results-topbar {
        display: flex;
        align-items: center;
        justify-content: space-between;
        gap: 18px;
        min-height: 74px;
        padding: 14px 26px;
        background: #ffffff;
        border-bottom: 1px solid #e4edf7;
        box-shadow: 0 6px 20px rgba(15, 60, 110, 0.06);
        position: sticky;
        top: 72px;
        z-index: 80;
    }

    .results-title-wrap h1 {
        margin: 0;
        font-size: 24px;
        line-height: 1.2;
        color: #102a43;
    }

    .results-title-wrap p {
        margin: 6px 0 0;
        color: #62748a;
        font-size: 15px;
    }

    .results-count-pill {
        display: inline-flex;
        align-items: center;
        gap: 8px;
        padding: 10px 14px;
        border-radius: 999px;
        background: #eaf4ff;
        color: #0b3d75;
        font-weight: 700;
        white-space: nowrap;
        border: 1px solid #cfe4ff;
    }

    /* ✅ Desktop layout: mapa je fixně vlevo, karty mají odsazení */
    .results-layout {
        display: block;
        min-height: calc(100vh - 146px);
        overflow: visible;
    }

    /* ✅ Skutečně plovoucí mapa vlevo */
    .map-panel {
        position: fixed;
        left: 0;
        top: 146px;
        width: 56vw;
        height: calc(100vh - 146px);
        min-height: 520px;
        overflow: hidden;
        background: #dce8f4;
        border-right: 1px solid #dbe7f3;
        z-index: 20;
    }

    #map {
        width: 100%;
        height: 100%;
        min-height: 100%;
        background: #dce8f4;
        z-index: 1;
    }

    .leaflet-container {
        cursor: grab;
    }

    .leaflet-container:active {
        cursor: grabbing;
    }

    /* ✅ Pravý panel posunutý vedle fixní mapy */
    .results-panel {
        background: #f8fafc;
        min-width: 0;
        border-left: 1px solid #e4edf7;
        min-height: calc(100vh - 146px);
        margin-left: 56vw;
        position: relative;
        z-index: 10;
    }

    .results-panel-header {
        background: rgba(248, 250, 252, 0.96);
        backdrop-filter: blur(8px);
        padding: 16px 18px 12px;
        border-bottom: 1px solid #e4edf7;
        position: sticky;
        top: 146px;
        z-index: 40;
    }

    .results-panel-header h2 {
        margin: 0;
        font-size: 20px;
        color: #102a43;
    }

    .results-panel-header p {
        margin: 6px 0 0;
        color: #62748a;
        font-size: 14px;
    }

    .list-container {
        display: grid;
        grid-template-columns: repeat(2, minmax(0, 1fr));
        align-content: start;
        gap: 18px;
        padding: 18px;
        min-height: 0;
    }

    .property-box {
        background: #ffffff;
        border: 1px solid #e3ebf5;
        border-radius: 18px;
        overflow: hidden;
        box-shadow: 0 8px 24px rgba(15, 60, 110, 0.08);
        transition: transform 0.18s ease, box-shadow 0.18s ease;
        min-width: 0;
    }

    .property-box:hover {
        transform: translateY(-3px);
        box-shadow: 0 14px 32px rgba(15, 60, 110, 0.14);
    }

    .property-box a {
        color: inherit;
        text-decoration: none;
        display: block;
        height: 100%;
    }

    .property-image-wrap {
        position: relative;
        width: 100%;
        height: 190px;
        background: #e8eef6;
        overflow: hidden;
    }

    .property-image-wrap .property-image {
        width: 100%;
        height: 100%;
        object-fit: cover;
        display: block;
        transition: transform 0.25s ease;
    }

    .property-box:hover .property-image {
        transform: scale(1.035);
    }

    .property-badge {
        position: absolute;
        left: 12px;
        top: 12px;
        padding: 6px 10px;
        border-radius: 999px;
        font-size: 12px;
        font-weight: 800;
        background: rgba(255, 255, 255, 0.92);
        color: #0b3d75;
        border: 1px solid rgba(207, 228, 255, 0.9);
        box-shadow: 0 4px 12px rgba(0, 0, 0, 0.08);
    }

    .property-info {
        padding: 14px 14px 16px;
    }

    .property-price {
        margin: 0 0 8px;
        font-size: 23px;
        font-weight: 800;
        color: #0078e7;
    }

    .property-title {
        margin: 0 0 10px;
        font-size: 15px;
        line-height: 1.35;
        font-weight: 700;
        color: #102a43;
        display: -webkit-box;
        -webkit-line-clamp: 2;
        -webkit-box-orient: vertical;
        overflow: hidden;
    }

    .property-meta {
        display: flex;
        gap: 7px;
        flex-wrap: wrap;
        margin-bottom: 10px;
    }

    .property-meta span {
        flex: 1;
        min-width: 74px;
        text-align: center;
        font-size: 13px;
        font-weight: 700;
        color: #243b53;
        background: #f0f5fb;
        border-radius: 10px;
        padding: 7px 6px;
    }

    .property-location {
        font-size: 14px;
        font-weight: 700;
        color: #243b53;
        line-height: 1.4;
        margin-top: 8px;
    }

    .property-agency {
        font-size: 13px;
        color: #73849a;
        margin-top: 7px;
        line-height: 1.4;
    }

    .no-results-box {
        grid-column: 1 / -1;
        align-self: start;
        margin: 18px auto;
        width: min(680px, 100%);
        padding: 34px 28px;
        background: #ffffff;
        border: 1px solid #e4edf7;
        border-radius: 22px;
        text-align: center;
        box-shadow: 0 12px 34px rgba(15, 60, 110, 0.10);
    }

    .no-results-icon {
        font-size: 44px;
        margin-bottom: 12px;
    }

    .no-results-box h2 {
        margin: 0 0 10px;
        font-size: 25px;
        color: #102a43;
    }

    .no-results-box p {
        margin: 0 auto 20px;
        max-width: 520px;
        font-size: 15px;
        line-height: 1.6;
        color: #62748a;
    }

    .no-results-actions {
        display: flex;
        justify-content: center;
        flex-wrap: wrap;
        gap: 10px;
    }

    .no-results-btn {
        display: inline-flex;
        align-items: center;
        justify-content: center;
        padding: 11px 17px;
        border-radius: 12px;
        text-decoration: none;
        font-weight: 800;
    }

    .no-results-btn.primary {
        background: #0078e7;
        color: #ffffff;
    }

    .no-results-btn.secondary {
        background: #eaf4ff;
        color: #0b3d75;
        border: 1px solid #cfe4ff;
    }

    .no-results-btn:hover {
        transform: translateY(-1px);
    }

    /* Tablet */
    @media screen and (max-width: 1100px) {
        .results-topbar {
            position: relative;
            top: auto;
        }

        .results-layout {
            display: block;
            min-height: 0;
            overflow: visible;
        }

        .map-panel {
            position: relative;
            left: auto;
            top: auto;
            width: 100%;
            height: 380px;
            min-height: 380px;
            border-right: none;
            border-bottom: 1px solid #dbe7f3;
            z-index: 1;
        }

        .results-panel {
            margin-left: 0;
            min-height: 500px;
        }

        .results-panel-header {
            position: relative;
            top: auto;
        }

        .list-container {
            grid-template-columns: repeat(2, minmax(0, 1fr));
        }
    }

    /* Mobil */
    @media screen and (max-width: 720px) {
        .results-page {
            padding-top: 70px;
        }

        .results-topbar {
            flex-direction: column;
            align-items: flex-start;
            padding: 16px;
        }

        .results-title-wrap h1 {
            font-size: 21px;
        }

        .results-count-pill {
            width: 100%;
            justify-content: center;
        }

        .list-container {
            grid-template-columns: 1fr;
            padding: 14px;
        }

        .property-image-wrap {
            height: 220px;
        }

        .map-panel {
            height: 320px;
            min-height: 320px;
        }
    }
</style>

</head>
<body>
<!DOCTYPE html>
<html lang="cs">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<script type="application/ld+json">
{
    "@context": "https://schema.org",
    "@graph": [
        {
            "@type": "Organization",
            "@id": "https://glovatoreal.cz/#organization",
            "name": "GlovatoReal",
            "url": "https://glovatoreal.cz/",
            "logo": "https://glovatoreal.cz/uploads/logos/GlovatoReal.png",
            "description": "GlovatoReal je moderní realitní platforma pro inzerci nemovitostí, vyhledávání nabídek, AI nástroje a realitní služby.",
            "sameAs": [
                "https://www.facebook.com/glovatoreal"
            ]
        },
        {
            "@type": "WebSite",
            "@id": "https://glovatoreal.cz/#website",
            "url": "https://glovatoreal.cz/",
            "name": "GlovatoReal",
            "publisher": {
                "@id": "https://glovatoreal.cz/#organization"
            },
            "inLanguage": "cs-CZ"
        }
    ]
}</script>


<link rel="stylesheet" href="/assets/header-styly.css">
<style>

</style>
<header class="global-header">
  <div class="header-container">
<div class="burger" id="burger-toggle">
  <div></div>
  <div></div>
  <div></div>
</div>

    <nav class="nav-menu">
      <div class="menu-item">
        <a href="#">Poptávky</a>
        <div class="dropdown-content">
              <a href="/poptavky/index.php">Poptávky</a> <!-- ✅ TOTO JEDINÉ -->
    <a href="/auth/login.php">Vložit poptávku</a>
         
        </div>
      </div>
      
    <div class="menu-item add-listing-btn">
    <a href="/properties/vlozit-inzerat.php">Vložit inzerát</a>
</div>

<div class="menu-item book-btn">
    <a href="/kniha-prodej-bytu.php">📘 Kniha zdarma</a>
</div>

<a href="/reviews/agents_directory.php">Najít agenta</a>
<a href="/realitni_kancelare/index.php">Kanceláře</a>
<a href="/properties/discounted_properties.php">🔥 Zlevněné</a>
<div class="menu-item">
  <a href="#">Prodat nemovitost</a>

  <div class="dropdown-content">
    <a href="/properties/vlozit-inzerat.php">Přidat nemovitost</a>

    
  <a href="/auth/login.php">Moje nemovitosti</a>
  <a href="/monitoring/landing.php">Realitní monitoring</a>


</div>
</div>
  
   
</a>
  </div>
</div>
 

    </nav>

    <div class="center-logo">
  <a href="/" class="logo-link">
    <img src="/uploads/logos/GlovatoReal.png" alt="Logo GlovatoReal" class="logo">
    <span class="logo-text">GlovatoReal</span>
    <span class="beta-badge">BETA</span>
  </a>
</div>

<div class="menu-item">
  <a href="#">Služby</a>
  <div class="dropdown-content">
    <a href="/sluzby/index.php">🔍 Vyhledat služby v okolí</a>
  </div>
</div>

<div class="menu-item">
  <a href="/cenik">Ceník</a>
</div>
<div class="menu-item">
<a href="/stahovani/documents.php">Ke stažení</a>
</div>

<nav class="header-right">
  <!-- ✅ NOVÁ SEKCE: O GlovatoReal + dropdown -->
  <div class="menu-item">
    <a href="/about/o-glovatoreal.html">O GlovatoReal</a>
    <div class="dropdown-content">
      <a href="/about/proc-byt-na-glovatoreal.html">Proč být na GlovatoReal</a>
    </div>
  </div>

  <div class="menu-item">
    <a href="/blog/index.php">Blog</a>
    <div class="dropdown-content">
        <a href="/poradna/questions.php">Poradna</a>
    </div>
</div>


  <div class="menu-item">
    <a href="#">Pomoc</a>
    <div class="dropdown-content">
      <a href="/help/help.php">Nápověda</a>

      <!-- 🔥 NOVÉ: Kalkulačky -->
      <a href="/kalkulacky/index.php">🧮 Stavební kalkulačky</a>

      
              <!-- Přesměrování na login s návratem -->
                <a href="/auth/login.php?return=https%3A%2F%2Fenergy.glovato.cz%2F%23calculator"
           onclick="alert('Pro přístup ke kalkulačce se nejprve přihlaste.');">
           Energetická kalkulačka
        </a>
        <a href="/auth/login.php?return=https%3A%2F%2Fanalyza.glovato.cz%2F"
           onclick="alert('Tato sekce je dostupná po přihlášení.');">
           Analýza
        </a>
        <a href="/auth/login.php?return=https%3A%2F%2Finvestor.glovato.cz%2Findex.html"
           onclick="alert('Tato sekce je dostupná po přihlášení.');">
           Investorská kalkulačka
        </a>
        <a href="/auth/login.php?return=https%3A%2F%2Fglovatoreal.cz%2Fcenova_mapa%2Fcenova_mapa.php"
           onclick="alert('Tato sekce je dostupná po přihlášení.');">
           Cenová mapa
        </a>
        <a href="/auth/login.php?return=https%3A%2F%2Fglovatoreal.cz%2Fagent-zone%2Findex.php"
           onclick="alert('Tato sekce je dostupná po přihlášení.');">
           Pro makléře
        </a>
      
      <a href="/support/index.php">Podpora</a>
    </div>
  </div>
</nav>


<!-- (volitelně) Doporučuju mít i „Reklama“ uvnitř <nav> kvůli zarovnání -->
<div class="menu-item">
  <a href="#">Reklama</a>
  <div class="dropdown-content">
    <a href="/advertise/advertise.php">Reklama na GlovatoReal</a>
      </div>
</div>

            <a href="/auth/login.php" class="auth-btn">Přihlášení</a>
      <a href="/auth/register.php" class="auth-btn register-btn">Registrace</a>
          </nav>
  </div>
  

</header>
<script>
document.addEventListener('DOMContentLoaded', function () {
  const burger = document.getElementById('burger-toggle');
  const navMenu = document.querySelector('.nav-menu');
  const headerRight = document.querySelector('.header-right');

  burger.addEventListener('click', function () {
    navMenu.classList.toggle('active');
    headerRight.classList.toggle('active');
  });
});
</script>
<a href="https://www.toplist.cz" id="toplistcz1841590" title="TOPlist"><noscript><img src="https://toplist.cz/dot.asp?id=1841590&njs=1" border="0"
alt="TOPlist" width="1" height="1"/></noscript><script language="JavaScript">
(function(d,e,s) {d.getElementById('toplistcz1841590').innerHTML='<img src="https://toplist.cz/dot.asp?id=1841590&http='+
e(d.referrer)+'&t='+e(d.title)+'&l='+e(d.URL)+'&wi='+e(s.width)+'&he='+e(s.height)+'&cd='+
e(s.colorDepth)+'" width="1" height="1" border="0" alt="TOPlist" />';
}(document,encodeURIComponent,window.screen))
</script></a>

<main class="results-page">

    <section class="results-topbar">
        <div class="results-title-wrap">
            <h1>Inzeráty v kraji / lokalitě</h1>
            <p>Praha 9 - Sokolovská</p>
        </div>

        <div class="results-count-pill">
            🏡 Nalezeno: 6        </div>
    </section>

    <section class="results-layout">

        <aside class="map-panel">
            <div id="map"></div>
        </aside>

        <section class="results-panel">
            <div class="results-panel-header">
                <h2>Nemovitosti podle vašeho výběru</h2>

                                    <p>Lokalita / kraj: <strong>Praha 9 - Sokolovská</strong></p>
                            </div>

            <div class="list-container">
                                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=899">
                                <div class="property-image-wrap">
                                    <img src="https://www.soccer-reality.cz/softreal/img/uploads/resized/666734_1772045362.jpg/384/216"
                                         alt="Pronájem komerčního prostoru"
                                         class="property-image">

                                                                            <span class="property-badge">Pronájem</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">4 217 Kč</h3>

                                    <p class="property-title">
                                        Pronájem komerčního prostoru                                    </p>

                                    <div class="property-meta">
                                        <span>Dispozice neuvedena</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>Plocha neuvedena</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Praha 9 - Sokolovská                                    </div>

                                    <div class="property-agency">
                                        🏢 Inzerent neuveden                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=898">
                                <div class="property-image-wrap">
                                    <img src="https://www.soccer-reality.cz/softreal/img/uploads/resized/66672_0491937749.jpg/384/216"
                                         alt="Pronájem komerčního prostoru"
                                         class="property-image">

                                                                            <span class="property-badge">Pronájem</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">12 378 Kč</h3>

                                    <p class="property-title">
                                        Pronájem komerčního prostoru                                    </p>

                                    <div class="property-meta">
                                        <span>Dispozice neuvedena</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>Plocha neuvedena</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Praha 9 - Sokolovská                                    </div>

                                    <div class="property-agency">
                                        🏢 Inzerent neuveden                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=897">
                                <div class="property-image-wrap">
                                    <img src="https://www.soccer-reality.cz/softreal/img/uploads/resized/66667_0509357690.jpg/384/216"
                                         alt="Pronájem komerčního prostoru"
                                         class="property-image">

                                                                            <span class="property-badge">Pronájem</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">3 532 Kč</h3>

                                    <p class="property-title">
                                        Pronájem komerčního prostoru                                    </p>

                                    <div class="property-meta">
                                        <span>Dispozice neuvedena</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>Plocha neuvedena</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Praha 9 - Sokolovská                                    </div>

                                    <div class="property-agency">
                                        🏢 Inzerent neuveden                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=896">
                                <div class="property-image-wrap">
                                    <img src="https://www.soccer-reality.cz/softreal/img/uploads/resized/66665_8682679418.jpg/384/216"
                                         alt="Pronájem komerčního prostoru"
                                         class="property-image">

                                                                            <span class="property-badge">Pronájem</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">2 912 Kč</h3>

                                    <p class="property-title">
                                        Pronájem komerčního prostoru                                    </p>

                                    <div class="property-meta">
                                        <span>Dispozice neuvedena</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>Plocha neuvedena</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Praha 9 - Sokolovská                                    </div>

                                    <div class="property-agency">
                                        🏢 Inzerent neuveden                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=551">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/scraped/551_1.jpg"
                                         alt="Pronájem komerčního prostoru"
                                         class="property-image">

                                                                            <span class="property-badge">Pronájem</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">5 666 Kč</h3>

                                    <p class="property-title">
                                        Pronájem komerčního prostoru                                    </p>

                                    <div class="property-meta">
                                        <span>Dispozice neuvedena</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>Plocha neuvedena</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Praha 9 - Sokolovská                                    </div>

                                    <div class="property-agency">
                                        🏢 Inzerent neuveden                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=550">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/scraped/550_1.jpg"
                                         alt="Pronájem komerčního prostoru"
                                         class="property-image">

                                                                            <span class="property-badge">Pronájem</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">10 445 Kč</h3>

                                    <p class="property-title">
                                        Pronájem komerčního prostoru                                    </p>

                                    <div class="property-meta">
                                        <span>Dispozice neuvedena</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>Plocha neuvedena</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Praha 9 - Sokolovská                                    </div>

                                    <div class="property-agency">
                                        🏢 Inzerent neuveden                                    </div>
                                </div>
                            </a>
                        </article>
                    
                            </div>
        </section>

    </section>
</main>

   
<script>
    var map = L.map('map', {
    scrollWheelZoom: false,
    wheelDebounceTime: 200,
    wheelPxPerZoomLevel: 120
}).setView([49.8175, 15.4730], 7);

map.scrollWheelZoom.disable();

    // 🌍 OpenStreetMap vrstva
    var osmLayer = L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', {
        attribution: '&copy; OpenStreetMap contributors'
    });

    // 🛰️ Google satelitní vrstva
    var satelliteLayer = L.tileLayer('https://mt1.google.com/vt/lyrs=s&x={x}&y={y}&z={z}', {
        attribution: '&copy; Google Satellite'
    });

    var baseMaps = {
        "OpenStreetMap": osmLayer,
        "Satelitní mapa": satelliteLayer
    };

    osmLayer.addTo(map);
    L.control.layers(baseMaps).addTo(map);

    // 📌 Přidání značek nemovitostí z databáze
  var properties = [{"id":899,"title":"Pron\u00e1jem komer\u010dn\u00edho prostoru","price":"4217.00","location":"Praha 9 - Sokolovsk\u00e1","rooms":0,"bedrooms":null,"area":0,"address":"","city":null,"postal_code":null,"agency_name":"0","street":null,"house_number":null,"latitude":null,"longitude":null,"property_type":"neuvedeno","type":"","transaction_type":"rent","transaction":"0","disposition":null,"image_url":"https:\/\/www.soccer-reality.cz\/softreal\/img\/uploads\/resized\/666734_1772045362.jpg\/384\/216"},{"id":898,"title":"Pron\u00e1jem komer\u010dn\u00edho prostoru","price":"12378.00","location":"Praha 9 - Sokolovsk\u00e1","rooms":0,"bedrooms":null,"area":0,"address":"","city":null,"postal_code":null,"agency_name":"0","street":null,"house_number":null,"latitude":null,"longitude":null,"property_type":"neuvedeno","type":"","transaction_type":"rent","transaction":"0","disposition":null,"image_url":"https:\/\/www.soccer-reality.cz\/softreal\/img\/uploads\/resized\/66672_0491937749.jpg\/384\/216"},{"id":897,"title":"Pron\u00e1jem komer\u010dn\u00edho prostoru","price":"3532.00","location":"Praha 9 - Sokolovsk\u00e1","rooms":0,"bedrooms":null,"area":0,"address":"","city":null,"postal_code":null,"agency_name":"0","street":null,"house_number":null,"latitude":null,"longitude":null,"property_type":"neuvedeno","type":"","transaction_type":"rent","transaction":"0","disposition":null,"image_url":"https:\/\/www.soccer-reality.cz\/softreal\/img\/uploads\/resized\/66667_0509357690.jpg\/384\/216"},{"id":896,"title":"Pron\u00e1jem komer\u010dn\u00edho prostoru","price":"2912.00","location":"Praha 9 - Sokolovsk\u00e1","rooms":0,"bedrooms":null,"area":0,"address":"","city":null,"postal_code":null,"agency_name":"0","street":null,"house_number":null,"latitude":null,"longitude":null,"property_type":"neuvedeno","type":"","transaction_type":"rent","transaction":"0","disposition":null,"image_url":"https:\/\/www.soccer-reality.cz\/softreal\/img\/uploads\/resized\/66665_8682679418.jpg\/384\/216"},{"id":551,"title":"Pron\u00e1jem komer\u010dn\u00edho prostoru","price":"5666.00","location":"Praha 9 - Sokolovsk\u00e1","rooms":0,"bedrooms":null,"area":0,"address":"Praha 9 - Sokolovsk\u00e1","city":"Praha 9 - Sokolovsk\u00e1","postal_code":null,"agency_name":"0","street":"","house_number":null,"latitude":"50.106789","longitude":"14.488437","property_type":"Patrov\u00fd","type":"","transaction_type":"rent","transaction":"0","disposition":null,"image_url":"uploads\/images\/scraped\/551_1.jpg"},{"id":550,"title":"Pron\u00e1jem komer\u010dn\u00edho prostoru","price":"10445.00","location":"Praha 9 - Sokolovsk\u00e1","rooms":0,"bedrooms":null,"area":0,"address":"","city":null,"postal_code":null,"agency_name":"0","street":null,"house_number":null,"latitude":null,"longitude":null,"property_type":"Patrov\u00fd","type":"","transaction_type":"rent","transaction":"0","disposition":null,"image_url":"uploads\/images\/scraped\/550_1.jpg"}];
var bounds = L.latLngBounds();

properties.forEach(function(property) {
    var lat = parseFloat(property.latitude);
    var lon = parseFloat(property.longitude);

    if (!isNaN(lat) && !isNaN(lon)) {
        var fullAddress = "";
        if (property.street) fullAddress += property.street + " ";
        if (property.house_number) fullAddress += property.house_number + ", ";
        if (property.postal_code) fullAddress += property.postal_code + " ";
        if (property.city) fullAddress += property.city;

        var marker = L.marker([lat, lon]).addTo(map)
            .bindPopup(
                `<b>${property.title}</b><br>
                ${property.price} Kč<br>
                ${property.rooms} Pokojů, ${property.bedrooms} Ložnic, ${property.area} m²<br>
                📍 ${fullAddress}<br>
                <a href="properties/property_details.php?id=${property.id}" target="_blank">Zobrazit</a>`
            );

        bounds.extend([lat, lon]);
    }
});

// 📍 Automatické přiblížení mapy podle bounds
if (bounds.isValid()) {
    map.fitBounds(bounds.pad(0.1));
} else {
    map.setView([50.0755, 14.4378], 7); // fallback – Praha
}


</script>


</body>
</html>