<!-- Detekován kraj/lokalita z GET: Ostrava, Ostrava-město / ostrava, ostrava-mesto --><!-- 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: %ostrava, ostrava-mesto%, %ostrava, ostrava-mesto%, %ostrava, ostrava-mesto%, %ostrava, ostrava-mesto%, %ostrava, ostrava-město%, %ostrava, ostrava-město% --><!-- 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 '%ostrava, ostrava-mesto%'
        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 '%ostrava, ostrava-mesto%'
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(city,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE '%ostrava, ostrava-mesto%'
        OR LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(address,
        'ě','e'),'š','s'),'č','c'),'ř','r'),'ž','z'),'ý','y'),'á','a'),'í','i'),'é','e'),'ů','u')) LIKE '%ostrava, ostrava-mesto%'
        OR LOWER(title) LIKE '%ostrava, ostrava-město%'
        OR LOWER(description) LIKE '%ostrava, ostrava-město%'
    ) --><!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=Ostrava%2C+Ostrava-m%C4%9Bsto">

    <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>Ostrava, Ostrava-město</p>
        </div>

        <div class="results-count-pill">
            🏡 Nalezeno: 9        </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>Ostrava, Ostrava-město</strong></p>
                            </div>

            <div class="list-container">
                                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1307">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1307_1.webp"
                                         alt="Prodej bytu 3+1, REZERVOVÁNO"
                                         class="property-image">

                                                                            <span class="property-badge">Prodej</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">6 300 000 Kč</h3>

                                    <p class="property-title">
                                        Prodej bytu 3+1, REZERVOVÁNO                                    </p>

                                    <div class="property-meta">
                                        <span>3+1</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>79 m²</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Karla Pokorného, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1306">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1306_1.webp"
                                         alt="Prodej bytu 3+1, REZERVOVÁNO"
                                         class="property-image">

                                                                            <span class="property-badge">Prodej</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">Cena na dotaz</h3>

                                    <p class="property-title">
                                        Prodej bytu 3+1, REZERVOVÁNO                                    </p>

                                    <div class="property-meta">
                                        <span>3+1</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>81 m²</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Břustkova, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1305">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1305_1.webp"
                                         alt="Prodej bytu 4+1, REZERVOVÁNO"
                                         class="property-image">

                                                                            <span class="property-badge">Prodej</span>
                                                                    </div>

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

                                    <p class="property-title">
                                        Prodej bytu 4+1, REZERVOVÁNO                                    </p>

                                    <div class="property-meta">
                                        <span>4+1</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>75 m²</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Karla Pokorného, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1304">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1304_1.webp"
                                         alt="Prodej Garáže, Ostrava - Třebovice"
                                         class="property-image">

                                                                            <span class="property-badge">Prodej</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">620 000 Kč</h3>

                                    <p class="property-title">
                                        Prodej Garáže, Ostrava - Třebovice                                    </p>

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

                                    <div class="property-location">
                                        📍 Skryto, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1303">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1303_1.webp"
                                         alt="Prodej komerčního pozemku"
                                         class="property-image">

                                                                            <span class="property-badge">Prodej</span>
                                                                    </div>

                                <div class="property-info">
                                    <h3 class="property-price">32 000 000 Kč</h3>

                                    <p class="property-title">
                                        Prodej komerčního pozemku                                    </p>

                                    <div class="property-meta">
                                        <span>Dispozice neuvedena</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>27 363 m²</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1299">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1299_1.webp"
                                         alt="Pronájem bytu 2+1"
                                         class="property-image">

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

                                <div class="property-info">
                                    <h3 class="property-price">13 500 Kč</h3>

                                    <p class="property-title">
                                        Pronájem bytu 2+1                                    </p>

                                    <div class="property-meta">
                                        <span>2+1</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>55 m²</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Rabasova, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1298">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1298_1.webp"
                                         alt="Pronájem kancelářských prostor 84 m2"
                                         class="property-image">

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

                                <div class="property-info">
                                    <h3 class="property-price">19 500 Kč</h3>

                                    <p class="property-title">
                                        Pronájem kancelářských prostor 84 m2                                    </p>

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

                                    <div class="property-location">
                                        📍 Francouzská, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1297">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1297_1.webp"
                                         alt="Pronájem kancelářských prostor 113 m²"
                                         class="property-image">

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

                                <div class="property-info">
                                    <h3 class="property-price">24 000 Kč</h3>

                                    <p class="property-title">
                                        Pronájem kancelářských prostor 113 m²                                    </p>

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

                                    <div class="property-location">
                                        📍 Nádražní, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </div>
                                </div>
                            </a>
                        </article>
                                            
                        <article class="property-box">
                            <a href="properties/property_details.php?id=1295">
                                <div class="property-image-wrap">
                                    <img src="uploads/images/nemovitostiren/nemovitostiren_1295_1.webp"
                                         alt="Prodej bytu 2+1"
                                         class="property-image">

                                                                            <span class="property-badge">Prodej</span>
                                                                    </div>

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

                                    <p class="property-title">
                                        Prodej bytu 2+1                                    </p>

                                    <div class="property-meta">
                                        <span>2+1</span>
                                        <span>Ložnice neuvedeny</span>
                                        <span>58 m²</span>
                                    </div>

                                    <div class="property-location">
                                        📍 Kosmonautů, Ostrava                                    </div>

                                    <div class="property-agency">
                                        🏢 Nemovitosti REN                                    </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":1307,"title":"Prodej bytu 3+1, REZERVOV\u00c1NO","price":"6300000.00","location":"Karla Pokorn\u00e9ho, Ostrava, Ostrava-m\u011bsto","rooms":3,"bedrooms":null,"area":79,"address":"Karla Pokorn\u00e9ho, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"Karla Pokorn\u00e9ho","house_number":null,"latitude":"49.837576","longitude":"18.180248","property_type":"byt","type":"Byt","transaction_type":"sale","transaction":"prodej","disposition":"3+1","image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1307_1.webp"},{"id":1306,"title":"Prodej bytu 3+1, REZERVOV\u00c1NO","price":"0.00","location":"B\u0159ustkova, Ostrava, Ostrava-m\u011bsto","rooms":3,"bedrooms":null,"area":81,"address":"B\u0159ustkova, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"B\u0159ustkova","house_number":null,"latitude":"49.782987","longitude":"18.221164","property_type":"byt","type":"Byt","transaction_type":"sale","transaction":"prodej","disposition":"3+1","image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1306_1.webp"},{"id":1305,"title":"Prodej bytu 4+1, REZERVOV\u00c1NO","price":"4600000.00","location":"Karla Pokorn\u00e9ho, Ostrava, Ostrava-m\u011bsto","rooms":4,"bedrooms":null,"area":75,"address":"Karla Pokorn\u00e9ho, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"Karla Pokorn\u00e9ho","house_number":null,"latitude":"49.837576","longitude":"18.180248","property_type":"byt","type":"Byt","transaction_type":"sale","transaction":"prodej","disposition":"4+1","image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1305_1.webp"},{"id":1304,"title":"Prodej Gar\u00e1\u017ee, Ostrava - T\u0159ebovice","price":"620000.00","location":"Skryto, Ostrava, Ostrava-m\u011bsto","rooms":0,"bedrooms":null,"area":16,"address":"Skryto, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"Skryto","house_number":null,"latitude":"49.844790","longitude":"18.196790","property_type":"garaz","type":"Gar\u00e1\u017e","transaction_type":"sale","transaction":"prodej","disposition":null,"image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1304_1.webp"},{"id":1303,"title":"Prodej komer\u010dn\u00edho pozemku","price":"32000000.00","location":"Ostrava, Ostrava-m\u011bsto","rooms":0,"bedrooms":null,"area":27363,"address":"Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"","house_number":null,"latitude":"49.827513","longitude":"18.207241","property_type":"pozemek","type":"Pozemek","transaction_type":"sale","transaction":"prodej","disposition":null,"image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1303_1.webp"},{"id":1299,"title":"Pron\u00e1jem bytu 2+1","price":"13500.00","location":"Rabasova, Ostrava, Ostrava-m\u011bsto","rooms":2,"bedrooms":null,"area":55,"address":"Rabasova, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"Rabasova","house_number":null,"latitude":"49.832718","longitude":"18.178685","property_type":"byt","type":"Byt","transaction_type":"rent","transaction":"pron\u00e1jem","disposition":"2+1","image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1299_1.webp"},{"id":1298,"title":"Pron\u00e1jem kancel\u00e1\u0159sk\u00fdch prostor 84 m2","price":"19500.00","location":"Francouzsk\u00e1, Ostrava, Ostrava-m\u011bsto","rooms":0,"bedrooms":null,"area":null,"address":"Francouzsk\u00e1, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"Francouzsk\u00e1","house_number":null,"latitude":"49.826300","longitude":"18.184913","property_type":"komerce","type":"Komer\u010dn\u00ed","transaction_type":"rent","transaction":"pron\u00e1jem","disposition":null,"image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1298_1.webp"},{"id":1297,"title":"Pron\u00e1jem kancel\u00e1\u0159sk\u00fdch prostor 113 m\u00b2","price":"24000.00","location":"N\u00e1dra\u017en\u00ed, Ostrava, Ostrava-m\u011bsto","rooms":0,"bedrooms":null,"area":113,"address":"N\u00e1dra\u017en\u00ed, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"N\u00e1dra\u017en\u00ed","house_number":null,"latitude":"49.835864","longitude":"18.286373","property_type":"komerce","type":"Komer\u010dn\u00ed","transaction_type":"rent","transaction":"pron\u00e1jem","disposition":null,"image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1297_1.webp"},{"id":1295,"title":"Prodej bytu 2+1","price":"4390000.00","location":"Kosmonaut\u016f, Ostrava, Ostrava-m\u011bsto","rooms":2,"bedrooms":null,"area":58,"address":"Kosmonaut\u016f, Ostrava, Ostrava-m\u011bsto","city":"Ostrava","postal_code":null,"agency_name":"Nemovitosti REN","street":"Kosmonaut\u016f","house_number":null,"latitude":"49.787828","longitude":"18.229640","property_type":"byt","type":"Byt","transaction_type":"sale","transaction":"prodej","disposition":"2+1","image_url":"uploads\/images\/nemovitostiren\/nemovitostiren_1295_1.webp"}];
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>