<!-- 
SELECT `ujingatlan`.`azonosito`, `ujingatlan`.`kieg`, `uj`, `jelleg`, `ugynok`, `ar`, `akciosar`, `kereskinal`, `szobakw`, `szobakh`, `terulet`, `terulet2`, `helyseg`, `ujingatlan`.`ovezet` as `ovezet`, `vovezet`, `fe_tel_u`, `egyeb`, `egyeb_eng`, `emelet`, `emeletszam`, `futes`, `komfort`, `ingatlan_ext`.`butorozott`, `lift`, `epult`, `epult_nyilvanos`, `kbepult`, `cimke`, `ltip`, `rentkind`, `ear`, `energetika`, `projekt_az`, `archive`, `eladar`, `ert_allapot`, `ytube`, `nomap`, `nyssz`, `elnev`, `eltel`, `map_link`, `pince`, `foldszint`, `teto`, `vovezet_nyilvanos`, `utca_nyilvanos`, `fe_tel_u`, `listak_utcak`.`utca`, `name`, `mymap_streets`.`type`, `cnev`, `URLszoveg`, `la_nev`, `adatlap_plusz`.`link` as `3dlink`, `adatlap_plusz`.`tipus` as `3dtipus`, `allapot_kivul_kod`, `allapot_belul_kod`, `sz_elhelyezkedes`, `room12`, `room12_count`, `room14`, `room14_count`, `room13`, `room13_count`, `room20`, `room20_count`, `nez_utcara`, `nez_kertre`, `nez_udvarra`, `nez_tuzfalra`, `nez_fuggofolyosora`, `nez_saroklakas`, `nez_parkra`, `csatorna`, `csatkap`, `gaz`, `gazkap`, `viz`, `vizkap`, `villany`, `villkap`, `haziallat`, `szlogen`, `gkt_vanhozza`, `gkt_tipus`, `extrak_text`, `pluszafa`, `elemail`, `ingatlan_ext`.`tipus`, `muvelesiag`, `ingatlan_ext`.`ovezet` as `besorolas`
FROM `ujingatlan`
LEFT JOIN `ingatlan_ext` ON `ingatlan_ext`.`azonosito`=`ujingatlan`.`azonosito` AND `ingatlan_ext`.`kieg`=`ujingatlan`.`kieg`
JOIN `partner` ON `partner`.`kieg` = `ujingatlan`.`user`
LEFT JOIN `listak_utcak` ON `ujingatlan`.`gkferohely`=`listak_utcak`.`id`
LEFT JOIN `ujingatlan_cim` ON `ujingatlan`.`azonosito`=`ujingatlan_cim`.`azonosito` and `ujingatlan`.`user`=`ujingatlan_cim`.`kieg`
LEFT JOIN `mymap_streets` ON `ujingatlan_cim`.`street`=`mymap_streets`.`id`
LEFT JOIN `frontend_beallitas` ON `ujingatlan`.`user`=`frontend_beallitas`.`kieg`
LEFT JOIN `listak_artipusok` ON `ujingatlan`.`rentkind`=`listak_artipusok`.`la_id` and `ujingatlan`.`kereskinal`=`listak_artipusok`.`la_elki`
LEFT JOIN `adatlap_plusz` ON `ujingatlan`.`azonosito`=`adatlap_plusz`.`azonosito` and `ujingatlan`.`user`=`adatlap_plusz`.`kieg`
WHERE `ujingatlan`.`kieg` = '_drh'
AND `ujingatlan`.`azonosito` = '226'
AND `archive` = ''
AND (1 = 1) AND `ert_allapot` in (0,2)  AND `masaltalfelvitt` in (0,1)  AND `partner`.`aktiv` = 1 
ORDER BY `fel_date` desc
 LIMIT 20
 --> 
<!-- 
SELECT `ujingatlan`.`azonosito`, `ujingatlan`.`kieg`, `uj`, `jelleg`, `ugynok`, `ar`, `akciosar`, `kereskinal`, `szobakw`, `szobakh`, `terulet`, `terulet2`, `helyseg`, `ujingatlan`.`ovezet` as `ovezet`, `vovezet`, `fe_tel_u`, `egyeb`, `egyeb_eng`, `emelet`, `emeletszam`, `futes`, `komfort`, `ingatlan_ext`.`butorozott`, `lift`, `epult`, `epult_nyilvanos`, `kbepult`, `cimke`, `ltip`, `rentkind`, `ear`, `energetika`, `projekt_az`, `archive`, `eladar`, `ert_allapot`, `ytube`, `nomap`, `nyssz`, `elnev`, `eltel`, `map_link`, `pince`, `foldszint`, `teto`, `vovezet_nyilvanos`, `utca_nyilvanos`, `fe_tel_u`, `listak_utcak`.`utca`, `name`, `mymap_streets`.`type`, `cnev`, `URLszoveg`, `la_nev`, `adatlap_plusz`.`link` as `3dlink`, `adatlap_plusz`.`tipus` as `3dtipus`, `allapot_kivul_kod`, `allapot_belul_kod`, `sz_elhelyezkedes`, `room12`, `room12_count`, `room14`, `room14_count`, `room13`, `room13_count`, `room20`, `room20_count`, `nez_utcara`, `nez_kertre`, `nez_udvarra`, `nez_tuzfalra`, `nez_fuggofolyosora`, `nez_saroklakas`, `nez_parkra`, `csatorna`, `csatkap`, `gaz`, `gazkap`, `viz`, `vizkap`, `villany`, `villkap`, `haziallat`, `szlogen`, `gkt_vanhozza`, `gkt_tipus`, `extrak_text`, `pluszafa`, `elemail`, `ingatlan_ext`.`tipus`, `muvelesiag`, `ingatlan_ext`.`ovezet` as `besorolas`
FROM `ujingatlan`
LEFT JOIN `ingatlan_ext` ON `ingatlan_ext`.`azonosito`=`ujingatlan`.`azonosito` AND `ingatlan_ext`.`kieg`=`ujingatlan`.`kieg`
JOIN `partner` ON `partner`.`kieg` = `ujingatlan`.`user`
LEFT JOIN `listak_utcak` ON `ujingatlan`.`gkferohely`=`listak_utcak`.`id`
LEFT JOIN `ujingatlan_cim` ON `ujingatlan`.`azonosito`=`ujingatlan_cim`.`azonosito` and `ujingatlan`.`user`=`ujingatlan_cim`.`kieg`
LEFT JOIN `mymap_streets` ON `ujingatlan_cim`.`street`=`mymap_streets`.`id`
LEFT JOIN `frontend_beallitas` ON `ujingatlan`.`user`=`frontend_beallitas`.`kieg`
LEFT JOIN `listak_artipusok` ON `ujingatlan`.`rentkind`=`listak_artipusok`.`la_id` and `ujingatlan`.`kereskinal`=`listak_artipusok`.`la_elki`
LEFT JOIN `adatlap_plusz` ON `ujingatlan`.`azonosito`=`adatlap_plusz`.`azonosito` and `ujingatlan`.`user`=`adatlap_plusz`.`kieg`
WHERE `ujingatlan`.`kieg` = '_drh'
AND `ujingatlan`.`azonosito` = '226'
AND `archive` = ''
AND (1 = 1) AND `ert_allapot` in (0,2)  AND `masaltalfelvitt` in (0,1)  AND `partner`.`aktiv` = 1 
ORDER BY `fel_date` desc
 LIMIT 20
 --> 
<!DOCTYPE html>
<html>
  <head>
    <title></title>
    <meta name="description" content="">
        <meta name="REVISIT-AFTER" content="1 days">
    <meta name="viewport" content="width=device-width; initial-scale=1; maximum-scale=1; user-scalable=0;">
    <link rel="alternate" type="application/rss+xml" title="Dr. House Ingatlaniroda ingatlanok RSS csatorna" href="rss.php">
            <link rel='stylesheet' type='text/css' href="/application/views/lc/css/responsiveslides.css">
    <link rel="stylesheet" type="text/css" href="/application/views/lc/css/bootstrap-select.css">
    <link rel="stylesheet" type="text/css" href="/application/views/lc/style.css">
    <link rel="stylesheet" type="text/css" href="/application/views/lc/print.css" media="print">
        <link rel="stylesheet" type="text/css" href="/application/views/lc/themes/36-project/custom.css">
        <script src="/application/views/lc/lc.js"></script>
    <script src="/application/views/lc/modernizr.custom.84206.js" async></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
    <script src="/application/views/lc/socialshare.js" async></script>
    <script async src="/application/views/lc/modalwindow/general.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.js"></script>
    <script src="/application/views/lc/carousel/jquery.carouFredSel-6.1.0-packed.js"></script>
    <script src="/application/views/lc/carousel/jquery.touchSwipe.min.js"></script>
    <script src="/application/views/lc/js/responsiveslides.js"></script>
    <script  src="/application/views/lc/js/bootstrap-select.js"></script>
    <script type="text/javascript" language="javascript">
      $(function (){
          //	Responsive layout, resizing the items
          $('#banner-slider').carouFredSel({
              responsive: true,
              width: '100%',
              pauseOnHover: true,
              prev: '#prev',
              next: '#next',
              scroll: {
                  pauseOnHover: true,
                  duration: 1000,
              },
              //scroll: 2,
              items: {
                  width: 400,
                  // height: '30%',
                  visible: {
                      min: 1,
                      max: 2
                  }
              }
          });
      });
    </script>
        <script>
      /* GA new TR hasznalatot meri, iroadtol fuggetlenul */
      (function (i, s, o, g, r, a, m) {
          i['GoogleAnalyticsObject'] = r;
          i[r] = i[r] || function () {
              (i[r].q = i[r].q || []).push(arguments)
          }, i[r].l = 1 * new Date();
          a = s.createElement(o),
                  m = s.getElementsByTagName(o)[0];
          a.async = 1;
          a.src = g;
          m.parentNode.insertBefore(a, m)
      })(window, document, 'script', '//www.google-analytics.com/analytics.js', 'ga');
      ga('create', 'UA-40872587-1', 'lc.hu');
      ga('send', 'pageview');
    </script>
    <script src="https://apis.google.com/js/platform.js" async defer>{ lang: 'hu' }</script>
    <script type="text/javascript">
      window.cookieconsent_options = {"message": "A webhely sütiket (cookie - kis méretű szöveges file-ok) használ a szolgáltatások biztosításához és a felhasználói élmény fokozásához, amelyet Ön az oldal használatával elfogad.", "dismiss": "Elfogadom", "learnMore": "", "link": "http://www.topsafe.hu/tajekoztato-a-cookie-k-hasznalatarol", "theme": "dark-bottom"}; //További infó
    </script>
    <script async type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/cookieconsent2/1.0.9/cookieconsent.min.js"></script>
    <style>
      body{ font-size:16px }
    </style>
  </head>
  <body class="desktop-device">


                <div id="modal-window-wrapper">
            <div id="modal-window">
                <a onclick="getElementById('modal-window-wrapper').style.display = 'none';" class="close-window"><i class="icon-remove" data-icon=""></i></a>
                <div id="modal-window-inner"></div>
            </div>
        </div>

        
        <div id="fb-root"></div>
       <!--   <script async type="text/javascript" src="/application/views/lc/fb.js"></script> -->
      <!--  <script async defer crossorigin="anonymous" src="https://connect.facebook.net/hu_HU/sdk.js#xfbml=1&version=v10.0" nonce="QLwGUc5M"></script> -->
      <script async defer crossorigin="anonymous" src="https://connect.facebook.net/hu_HU/sdk.js#xfbml=1&version=v11.0" nonce="yq8Aipo0"></script>

        <header id="header" role="banner">

            
            <div id="top-bar" class="has-contactinfo">
                <div class="margin clearfix">
                    <div class="top-bar-defaults">
                    <div class="current-date float-left"><time datetime="2021-12-08">2021. december 08. szerda - Mária                                                 </div>
                    <ul class="menu float-right">
                                               
                        
                        <li>
                        <div id="language-chooser">
                        <div id="language-indicator"></div>
                        <div id="google_translate_element" style=" margin:0px;"></div>
                        </div>    
                        <script>
                            

                        function googleTranslateElementInit() {
                            new google.translate.TranslateElement({
                                pageLanguage: 'hu',
                               //includedLanguages: 'cs,en,fr,de,hu,it,pl,ro,ru,sk,es,uk,zh-CN,ru'
                                includedLanguages: 'hu,en,de,sk,ro,zh-CN,ru'
                               // ,layout: google.translate.TranslateElement.InlineLayout.SIMPLE
                            }, 'google_translate_element');
                        }
                        $(document).ready(function()
                            {
                            $(".goog-te-gadget .goog-te-combo").each(function() {
                            $(this).addClass("form-control");
                            });
                              });
                        </script>
                        <script src="https://translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
                        </li>
                    </ul>
                </div>
                         <div class="topbar-contactbox">
                    <div>
                       
                        <span class="topbar-contact-phone">
                                                                     <i class="icon-phone" data-icon=""></i>
                                        <a href="" id="show-this-phone" data-toshow="+36-30-303-3019">+36-30-303-                                            <span class="button orange show-this-on-click">Mutasd</span>
                                        </a>
                                         <!--  class="show-this-on-click" class="topbar-contact-phone" -->
                                        

                        </span>
                                                <a href="" class="topbar-contact-email" id="show-this-email" data-toshow="drhouseingatlan@gmail.com">drhouseingatlan@                            <span class="button orange show-this-on-click">Mutasd</span>
                        </a>
                        <script>
                          var kieg = '_drh',
                              eurl = 'http://www.drhouseingatlan.hu/elado-ujepitesu-telek/demjen/dr-house-ingatlaniroda/226_drh';                          
                        </script>
                        <script src="/application/views/lc/mutasd.js"></script>
                    </div>
                </div> 
                </div>
            </div><!-- #top-bar -->


<!-- 
            <div id="header-main"
                                  >

                 <div class="margin clearfix">
                                                            <a href="http://www.drhouseingatlan.hu/"><img class="logo" src="http://wpix.lc.hu/_drh/images/ceglogo-20190121150835p7994.jpg" alt=""></a>
                                        <hgroup class="hgroup clearfix">
                        <div id="logo"><a href="http://www.drhouseingatlan.hu/" class="home h1">Dr. House Ingatlaniroda</a></div>
                        <div class=h2>Orvosoljuk ingatlanproblémáit!</div>
                    </hgroup>
                                    </div>

            </div><!-- #header-main --> 


                                                <div id="header-main">
                                     <div class="margin clearfix">
                                                                                 <a href="/"><img class="logo" src="https://wpix.lc.hu/_drh/images/ceglogo-20190121150835p7994.jpg" alt=""></a>
                                         
                                           <hgroup class="hgroup clearfix">

                                            <div id="logo"><a href="/" class="home h1 notranslate">Dr. House Ingatlaniroda</a></div>
                                            <div class=h2>Orvosoljuk ingatlanproblémáit!</div>
                                            </hgroup>
                                     </div>
                                </div>

                               
            <nav class="margin breadcrumbs">

                
                                <ol>

                                        <li><a href="/">Főoldal</a></li>
                                        <li>Részletes ingatlan adatlap</li>                </ol>
                                <div class="mobildiv"  data-show="0"></div>
                <script>
                  /*
                       $(document).ready(function ()
                {
                    $(".mobildiv").load("http://www.drhouseingatlan.hu/page/mobilmenu");

                    $(window).resize(function() {
                        $(".mobildiv").load("http://www.drhouseingatlan.hu/page/mobilmenu");
                        console.log('window was resized');
                    }); 
                });
                   */
                   $(document).ready(function ()
                           {
                               $(".mobildiv").load("http://www.drhouseingatlan.hu/mobilmenu");

                               $(window).resize(function() {
                                   $(".mobildiv").load("http://www.drhouseingatlan.hu/mobilmenu");
                                   console.log('window was resized');
                               }); 
                     });              
                </script>
             

            </nav>

        </header>
        <div id="main-content" class="margin clearfix" role="main">

  
<div class="page-header">
    <!--
	<h2>A hivatkozott ingatlan nem található a rendszerben! Hiba 404!</h2>
	-->
	<h2>A hivatkozott ingatlan nem található a rendszerben, mert elkelt, vagy más okból archiválásra került. </h2>
	
</div>

<div id="content" class="clearfix post">

<span class="path"><script type="text/javascript"> document.write(document.document.get_path()); </script></span>
<div>Próbálja a következő helyeken:
<ul>
<li><a href=http://www.drhouseingatlan.hu/page/keres>ingatlankereső</a>
<li><a href=http://www.drhouseingatlan.hu>főoldal</a>
<li><a href="" onclick="history.back()">visszanavigálás, ahonnan jöttem</a>
</ul>
</div>

</div>
</div>

</div>
<div style="clear:both"></div>
<footer id="footer">
  <style>
    #footer-links{ display: block }
  </style>
  <div id="footer-links" class="simple-list margin clearfix">
        <center>
            <div class="col-one-fifth">
              &nbsp            </div>
                        <div class="col-one-fifth">
                <h2>Eladó ingatlanok</h2>
                <ul>
                  <li><a href="/lista/223527/">Eladó tégla lakás</a></li>                  <li><a href="/lista/223529/">Eladó családi ház</a></li>                  <li><a href="/lista/223528/">Eladó panel lakás</a></li>                </ul>
            </div>
            
                        <div class="col-one-fifth">
                <h2>Kiadó ingatlanok</h2>
                <ul>
                  <li><a href="/lista/223533/">Kiadó tégla lakás</a></li>                  <li><a href="/lista/223534/">Kiadó családi ház</a></li>                  <li><a href="/lista/223536/">Kiadó panel lakás</a></li>                </ul>
            </div>
            
            
        </center>
    </div><!-- .margin -->
    

    <div id="footer-bar">
        <div class="margin clearfix">

            <center>
                <a href="/sitemap">Oldaltérkép</a>

                                                &nbsp; | &nbsp; <a href="/adatkezeles/dr-house-ingatlaniroda">Adatkezelés</a>
                                                &nbsp; | &nbsp; <a href="/partnerirodak/dr-house-ingatlaniroda">Partnerirodák</a>
                
                &nbsp; | &nbsp; <a href="/impresszum/">Impresszum</a>

                &nbsp; | &nbsp; <a href="/link-banner/">Link és bannercsere</a>
                                  
                        &nbsp; | &nbsp;<a href="/rss/_drh/dr-house-ingatlaniroda/">RSS</a>
                                             </center>

            <center>
                                            </center>

                    </div><!-- .margin -->
    </div><!-- #footer-bar -->

</footer>


<!-- Responsive video support -->
<script src="/application/views/lc/carousel/jquery.fitvids.js"></script>
<script>
    $(".video-container").fitVids();
</script>


<!-- <div class="sessdivx hidden"></div>
   <script>
                $(document).ready(function () {
                    setInterval(function () {
                        $(".sessdivx").load("refring.php");
                    }, 10000);
                });
            </script> -->


<div class="konv_face"></div>

        
</body>

   <script>

   //A webgalamb miatt.

       $(window).load(function () {
          if (typeof newIframe !== "undefined"){
             var ablak = document.getElementById(newIframe.id);
             var azon = newIframe.id.replace('f_','form_');
             var dok = ablak.contentDocument;             

             if (dok!=null){
                var urlap = dok.getElementById(azon); 
                if (https){
                   urlap.action = urlap.action.replace('http://','https://');
                   //alert(urlap.action);
                }
             }
             else{ 
            	 alert("Az űrlap elküldése nem működik ezen az oldalon.");
            	 //alert(ablak.src);
             }
           } 
      
       });
   
   </script> 

</html>