Söve
Rosa Yapı olarak Büyükçekmece ve İstanbul genelinde Joton yetkili uygulama bayii, Favori yetkili uygulama bayii, Dyo yetkili uygulama bayii olarak profesyonel ekiblerimiz ile çekme ve püskürtme söve kaplama panelleri ile projelerinizde fark yaratacak modern mimarisi ile kendini tasarımı, malzeme kalitesi, mükemmel işçiliği ile güsteren binalar yapıyoruz
Hizmetlerimiz
loadObjectList($hizmetler_page_q);
if($hizmetler_page)
{
foreach ($hizmetler_page as $key => $value) {
echo ''.$value->PAGE_LINK.'';
}
}
$hizmetler_page_q2 = "SELECT PAGE_DESC.PAGE_LINK, PAGE_DESC.PAGE_SHORT_DESC, PAGE.PAGE_UNIQ, PAGE_DESC.LANG_ID, PAGE_DESC.SEO_LINK AS P_SEO_LINK, PAGE_CAT_DESC.SEO_LINK AS C_SEO_LINK FROM PAGE_DESC
INNER JOIN PAGE ON PAGE.PAGE_UNIQ = PAGE_DESC.PAGE_UNIQ
INNER JOIN PAGE_CAT ON PAGE_CAT.PAGE_CAT_ID = PAGE.CAT_ID
INNER JOIN PAGE_CAT_DESC ON PAGE_CAT_DESC.PAGE_CAT_UNIQ = PAGE_CAT.PAGE_CAT_UNIQ
WHERE PAGE_DESC.LANG_ID = '{$GLOBALS["lid"]}' AND PAGE.MODUL_ID = '2' AND PAGE.STATUS = '1' AND PAGE.CAT_ID > '0' AND PAGE.CAT_PAGE = '0'";
$hizmetler_page2 = $db->loadObjectList($hizmetler_page_q2);
if($hizmetler_page2)
{
foreach ($hizmetler_page2 as $key2 => $value2) {
echo ''.$value2->PAGE_LINK.'';
}
}
$hizmetler_page_q1 = "SELECT PAGE_DESC.SEO_LINK,PAGE_DESC.PAGE_LINK,PAGE_DESC.PAGE_TITLE,PAGE_DESC.PAGE_SHORT_DESC,PAGE_DESC.PAGE_UNIQ,PAGE_DESC.LANG_ID FROM PAGE_DESC
INNER JOIN PAGE ON PAGE.PAGE_UNIQ = PAGE_DESC.PAGE_UNIQ
WHERE PAGE_DESC.LANG_ID = '{$GLOBALS["lid"]}' AND PAGE.MODUL_ID = '2' AND PAGE.STATUS = '1' AND PAGE.CAT_PAGE = '1' ORDER BY PAGE.SORTBY ASC";
$hizmetler_page1 = $db->loadObjectList($hizmetler_page_q1);
if($hizmetler_page1)
{
foreach ($hizmetler_page1 as $key1 => $value1) {
echo ''.$value1->PAGE_LINK.'';
}
}
?>
Bize Ulaşın
Muratçeşme Mh. Sultan Murat Cd. No:41/C Muratçeşme - Büyükçekece / İstanbul