Immobilien Gewerbe

Bitte wählen Sie die gewünschte Kategorie

query($sqlr); while ($ntr = $resultr->fetch_assoc()) { if ("bp" == $ntr['Kurz']) { $sql1 = 'SELECT ID FROM objekte WHERE (O_TYP = "Büro" OR O_TYP = "Praxis") AND Aktiv = 1 ORDER BY ID ASC'; $result1 = $db->query($sql1); $anzahl1 = $result1->num_rows; $nt1 = $result1->fetch_assoc(); echo "\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; $file = "img/objekte/".$nt1['ID']."_1.jpg"; if (file_exists($file)) { echo "\n"; } echo "

Büros / Praxen

Zur Zeit haben wir $anzahl1 Objekte

\n"; echo "
\n"; echo "
\n"; } elseif ("ei" == $ntr['Kurz']) { $sql2 = 'SELECT ID FROM objekte WHERE (O_TYP = "Einzelhandel" OR O_TYP = "Industrie") AND Aktiv = 1 ORDER BY ID ASC'; $result2 = $db->query($sql2); $anzahl2 = $result2->num_rows; $nt2 = $result2->fetch_assoc(); echo "\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; $file = "img/objekte/".$nt2['ID']."_1.jpg"; if (file_exists($file)) { echo "\n"; } echo "

Einzelhandel / Industrie

Zur Zeit haben wir $anzahl2 Objekte

\n"; echo "
\n"; echo "
\n"; } elseif ("gh" == $ntr['Kurz']) { $sql3 = 'SELECT ID FROM objekte WHERE (O_TYP = "Gastronomie" OR O_TYP = "Hotel") AND Aktiv = 1 ORDER BY ID ASC'; $result3 = $db->query($sql3); $anzahl3 = $result3->num_rows; $nt3 = $result3->fetch_assoc(); echo "\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; $file = "img/objekte/".$nt3['ID']."_1.jpg"; if (file_exists($file)) { echo "\n"; } echo "

Gastronomie / Hotels

Zur Zeit haben wir $anzahl3 Objekte

\n"; echo "
\n"; echo "
\n"; } elseif ("mf" == $ntr['Kurz']) { $sql4 = 'SELECT ID FROM objekte WHERE O_TYP = "Multi" AND Aktiv = 1 ORDER BY ID ASC'; $result4 = $db->query($sql4); $anzahl4 = $result4->num_rows; $nt4 = $result4->fetch_assoc(); echo "\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; $file = "img/objekte/".$nt4['ID']."_1.jpg"; if (file_exists($file)) { echo "\n"; } echo "

Multifunktionsobjekte

Zur Zeit haben wir $anzahl4 Objekte

\n"; echo "
\n"; echo "
\n"; } } ?>