Name: @detay.Adi
Address: @detay.Adres @detay.IlceAdi, @detay.SehirAdi, @detay.UlkeAdi
Telephone: @detay.SabitTelefon

@detay.Adi @detay.YatakSayisi

@detay.Aciklama

@detay.CepTelefon @detay.SabitTelefon
@detay.Adres @detay.IlceAdi - @detay.SehirAdi - @detay.UlkeAdi

Harita Yakın Yurtlar

@procedure{"id":"yorum","name":"Yorumlar as Y", "property":["Y.Yorum Yorum","U.AdSoyad AdSoyad","case when U.Gorsel is null then 'user-1.png' else U.Gorsel end Gorsel","Y.Tarih Tarih"], "where":"Y.Durumu = 1 and Y.YurtID=1925", "orderby":[{"sort":"desc","property":"Y.Tarih"}], "relation":[{"type":"join","name":"Uyeler as U","on":"U.ID=Y.UyeID"}] }@/procedure @forcode[yorum]{

@yorum.AdSoyad - @yorum.Tarih
@yorum.Yorum

}[yorum]@/forcode

@detay.Detay

HizmetlerimizBina ÖzelliklerimizOda Özelliklerimiz

@procedure{"id":"hizmet","name":"TanimHizmetleri as B", "property":["case when YB.Aciklama = '' then ' '+ B.Adi +'' else '

'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'

' end cnt"], "where":"YB.YurtID=1925", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtHizmetleri as YB","on":"YB.HizmetID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.HizmetID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[hizmet]{ @hizmet.cnt }[hizmet]@/forcode

@procedure{"id":"bina","name":"TanimBinaOzellikleri as B", "property":["case when YB.Aciklama = '' then ' '+ B.Adi +'' else '

'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'

' end cnt"], "where":"YB.YurtID=1925", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtBinaOzellikleri as YB","on":"YB.BinaOzellikID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.BinaOzellikID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[bina]{ @bina.cnt }[bina]@/forcode

@procedure{"id":"oda","name":"TanimOdaOzellikleri as B", "property":["case when YB.Aciklama = '' then ' '+ B.Adi +'' else '

'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'

' end cnt"], "where":"YB.YurtID=1925", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtOdaOzellikleri as YB","on":"YB.OdaOzellikID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.OdaOzelliKID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[oda]{ @oda.cnt }[oda]@/forcode

Galeri

Sponsorlu

Yakın Yurtlar

@detay.SehirAdi ili ilçeleri

@procedure{"id":"ilceler", "name":"TanimIlceler as I", "property":["lower(I.Adi) LAdi","I.Adi Adi"], "orderby":[{"sort":"asc","property":"I.Adi"}], "where":"I.SehirID = @detay.SehirID"}@/procedure @forcode[ilceler]{ @ilceler.Adi }[ilceler]@/forcode

Yakın Üniversiteler

Üyelerimizden

@procedure{"id":"yorum","name":"Yorumlar as Y","limit":"5", "property":["Y.Yorum Yorum","U.AdSoyad AdSoyad","case when U.Gorsel is null then 'user-1.png' else U.Gorsel end Gorsel","Y.Tarih Tarih","SC.SEOUrl SU","SC.SEOTitle ST"], "where":"Y.Durumu = 1 and SC.LanguageID=1", "orderby":[{"sort":"desc","property":"Y.Tarih"}], "relation":[ {"type":"join","name":"Uyeler as U","on":"U.ID=Y.UyeID"}, {"type":"join","name":"SEO as S","on":"S.YurtID=Y.YurtID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"}, ] }@/procedure @forcode[yorum]{

@yorum.ST
@yorum.AdSoyad - @yorum.Tarih
@yorum.Yorum

}[yorum]@/forcode