- Yol Tarifi
- Fotoğraflar
- İncelemeler
- Çalışma Saatleri: 09:00 - 23:00Pts09:00 - 23:00Sal09:00 - 23:00Çar09:00 - 23:00Per09:00 - 23:00Cum09:00 - 23:59Cts09:00 - 23:59Paz09:00 - 23:59
- AdresFazilet Caddesi, 1 Hamidiye, Kağıthane, İstanbul
Hamidiye
34408
Yakın Çevrede Neler Var?
WordPress veritabanı hatası: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') - ABS( wp7m_geodir_gd_place_detail.latitude ) ) * PI() / 180 / 2 ), 2 ) + C...' at line 1]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.973751 - 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 (12439) AND wp7m_geodir_gd_place_detail.country = 'Turkey' AND wp7m_geodir_gd_place_detail.region = 'İstanbul' AND wp7m_geodir_gd_place_detail.city = 'Kağıthane'
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?.
