- Yol Tarifi
- Fotoğraflar
- İncelemeler
- Çalışma Saatleri: 09:00 - 23:59Pts09:00 - 23:00Sal09:00 - 23:00Çar09:00 - 23:00Per09:00 - 23:00Cum09:00 - 23:59Cts09:00 - 23:59Paz09:00 - 23:59
- Telefon Numarası
- AdresMollafenari Sokak, 39 Alemdar, Fatih, İstanbul
Alemdar
34110
Yakın Çevrede Neler Var?
WordPress veritabanı hatası: [Unknown column 'ıo0ğ' in 'field list']SELECT wp7m_posts.*, wp7m_geodir_gd_place_detail.*, ( 6371.009 * 2 * ASIN( SQRT( POWER( SIN( ( ABS( ıo0ğ ) - ABS( wp7m_geodir_gd_place_detail.latitude ) ) * PI() / 180 / 2 ), 2 ) + COS( ABS( ıo0ğ ) * PI() / 180 ) * COS( ABS( wp7m_geodir_gd_place_detail.latitude ) * PI() / 180 ) * POWER( SIN( ( 28.974877 - wp7m_geodir_gd_place_detail.longitude ) * PI() / 180 / 2 ), 2 ) ) ) ) AS distance FROM wp7m_posts
INNER JOIN wp7m_geodir_gd_place_detail ON (wp7m_geodir_gd_place_detail.post_id = wp7m_posts.ID)
WHERE 1=1 AND wp7m_posts.post_status = 'publish' AND wp7m_posts.post_type = 'gd_place' AND wp7m_posts.ID NOT IN (12440) AND wp7m_geodir_gd_place_detail.country = 'Turkey' AND wp7m_geodir_gd_place_detail.region = 'İstanbul' AND wp7m_geodir_gd_place_detail.city = 'Fatih'
GROUP BY wp7m_posts.ID
ORDER BY distance ASC
LIMIT 0, 5
No listings were found matching your selection. Something missing? Why not add a listing?.