04.09.2010 23:49 Türkçe  |  English

main page profile Search Services Infobank(in Turkish) Contact Type: Land House Work Housing Workplace Resorts City: İstanbul(79) Bursa(1) Çanakkale(2) İzmir(1) Kırklareli(1) Muğla(1) Sakarya(1) Tekirdağ(2) County: SELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='811' GROUP BY semt2 ORDER BY semt2_adSELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='831' GROUP BY semt2 ORDER BY semt2_adSELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='840' GROUP BY semt2 ORDER BY semt2_adSELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='858' GROUP BY semt2 ORDER BY semt2_adSELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='945' GROUP BY semt2 ORDER BY semt2_adSELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='11000101' GROUP BY semt2 ORDER BY semt2_adSELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='21000401' GROUP BY semt2 ORDER BY semt2_adAllAllCihangirGümüşpalaAllB.ÇekmeceAlbatrosAtatürkBoğazköyDizdariyeEsenkentEsenyurtFatihKumburgazMerkezMimarsinanTepecikTurgut Özal BulvarıAllHadımköy BeldesiAllKemerburgazAllOrtaköyAllHadımköyAllAdnan KahveciBeykentCumhuriyetGürpınarHaramidereMerkezYeşilkent Status: Select For sale For rent Special Price Interval:  -  TL USD EUR GBP m2 Interval:  -  M2 Room Quantity: Select Studio 1 1+1 1+2 2+1 2+2 3+1 3+2 4+1 4+2 5 5+1 5+2 5+3 5+4 6+1 6+2 7+1 8+ Bathroom Quantity: Select None 1 2 3 4 5 6+ Building Age: Select 0 1 2 3 4 5-10 11-20 20+ Heating: Select No heating Central natural gas Combi boiler Natural gas Combi boiler Solid Combi boiler Rock Central coal Natural gas stove Central Fuel oil Combi boiler Fuel oil Air conditioner Stove Ground heating Geothermal Properties: Parent Bath Hilton Bath İtalian Bath Jacuzzi Bath Tub Sauna Hot-Water American Kitchen Built-in Kitchen Kitchen Cabinet İtalian Kitchen Larder Lacquered Kitchen Laminated Kitchen Oaken Kitchen Furnished Kitchen Kitchen Gas Line DSL Internet Alarm Wood Window Lift Balcony - Open Balcony - Closed Barbecue White Goods Steel Door Laundry Room Wallpaper Dress Room Built-in Cupboard Diaphone with screen Carpet Floor Covering Insulating Glass Cable TV - Satellite Papier Mache Air Conditioner Vinyl Floor Covering Marble Furnished Panel Door Parquet Parquet - Laminated Satin Paint Floor Ceramics Spot Light Fireplace Terrace - Open Terrace - Closed High Ceiling Shopping Center Aluminium Window Apt / Site Employee Ballpark Garden - Detached Garden - Common Teagarden Children's playground Recreation Facilities Wrought Iron / Iron Football Field Football Field Security Hydrophore Heat Insulation Internet Cafe Generator Cafeteria Detached Pool Car Park - Open Car Park - Closed Window Bracket PVC Window Sounding Insulation Siding In Site Gym Social Facilities Water Cistern Tennis Court Volleyball Field Fire Escape Swimming Pool - Open Swimming Pool - Closed Walkingcourse Back Side On the street Near street Double Side On seashore Near sea With sea-sight With lake-sight Near airport Near Hospital One flat on each floor In Centre Near express highway Near school Front side With city-sight Near public transportation Right/Left Side With greenspace-sight Basketball Billiards Equitation Bowling Fitness Centre Football Golf Gymnasium Ski Table Tennis Mini Golf Sport Lounge Squash Water Sports Tennis Volleyball With photo only Showroom Exchange Rates Date : 04.09.2010 Time : 23:49 USD : 1.4994 TL EUR : 1.9334 TL Contact Wec Çağdaş Cumhuriyet Mah. Beykent Çarşısı N:215 Beykent B.Çekmece/İstanbul Tel.1 : (212)8712070 Mobile1 : (212)8712071 Fax : (212)8713423 info@weccagdasemlak.com

main page  |   profile  |   Search  |   Infobank(in Turkish)  |   Services  |   Contact For rent  |   For sale ©2010 Wec Çağdaş