SQL_ERROR_TITLE
SQL_ERROR_CODE 0
SQL_QUERY select t1.*, t1.id as advert_id, t2.Name as estate_status, t3.Name as estate_type, t4.Name as estate_warming_system, t5.Name as estate_ground, t6.Name as estate_room_type, t7.Name as estate_flat_item, t8.Name as estate_current_flat, t9.Name as estate_city, t10.Name as estate_township, t15.Name as estate_area, t11.Name as estate_land_registry_status, t12.Name as estate_development_status, t13.Name as estate_precedents, t14.Name as estate_floor_permission, t16.Name as estate_wet_ground, t17.Name as estate_front, (select t_advert_images.Images from t_advert, t_advert_images where t_advert.ID=t_advert_images.ParentID and t_advert.ID='101197' order by Seq asc LIMIT 0,1) as estate_images from t_advert t1 left join t_properties t2 on t1.EstateStatus = t2.ItemID and t2.PageType='EstateStatus' and t2.PageLang='Русский' left join t_properties t3 on t1.EstateType = t3.ItemID and t3.PageType='EstateType' and t3.PageLang='Русский' left join t_properties t4 on t1.WarmingSystem = t4.ItemID and t4.PageType='WarmingSystem' and t4.PageLang='Русский' left join t_properties t5 on t1.Ground = t5.ItemID and t5.PageType='Ground' and t5.PageLang='Русский' left join t_properties t6 on t1.RoomType = t6.ItemID and t6.PageType='RoomType' and t6.PageLang='Русский' left join t_properties t7 on t1.FlatItem = t7.ItemID and t7.PageType='FlatItem' and t7.PageLang='Русский' left join t_properties t8 on t1.CurrentFlat = t8.ItemID and t8.PageType='CurrentFlat' and t8.PageLang='Русский' left join t_city t9 on t1.City = t9.ID left join t_township t10 on t1.TownShip = t10.ID left join t_area t15 on t1.Area = t15.ID left join t_properties t11 on t1.LandRegistryStatus = t11.ItemID and t11.PageType='LandRegistryStatus' and t11.PageLang='Русский' left join t_properties t12 on t1.DevelopmentStatus = t12.ItemID and t12.PageType='DevelopmentStatus' and t12.PageLang='Русский' left join t_properties t13 on t1.Precedents = t13.ItemID and t13.PageType='Precedents' and t13.PageLang='Русский' left join t_properties t14 on t1.FloorPermission = t14.ItemID and t14.PageType='FloorPermission' and t14.PageLang='Русский' left join t_properties t16 on t1.WetGround = t16.ItemID and t16.PageType='WetGround' and t16.PageLang='Русский' left join t_properties t17 on t1.Front = t17.ItemID and t17.PageType='Front' and t17.PageLang='Русский' where t1.ID='101197'
SQL_ERROR Table './evim_hb2k2/t_advert' is marked as crashed and should be repaired Untitled Document
 
Особенности
 
Дальнейшая Информация
Агенство по недвижимости «Premium Emlak» Новостройка! Cдается 1 комнатная квартира в Бинагадинском районе, в 9 МКР-е, рядом с домом торжеств «Лейла». Этаж 6ቬ. Общая площадь 955 кв.м. Санузел-совмещенный в отличном состоянии. Хороший ремонт. Раздельные комнаты. Пол (паркет). КАТВ, стиральная машина, отопительная система «комби» , телевизор, сплит кондицонер. Качественная кухня со всей бытовой техникой в наличии. Коммуникации 24ቴ. Охраняемый двор, кодовый блок, 2 скоростных лифта "Сигма", место для парковки, подземный гараж, детская площадка. Оплата 400 АЗН. (Фарид)

«Premium Emlak» daşınmaz əmlak agentliyi, Yeni binada, şəhərin mərkəzində, Binəqədi rayonunda, 9 MKR-da, “Leyla” şadliğ sarayin yaninda hər bir şəraiti olan 1 otağli mənzil kirayə verilir. 6ቬ. Ümumi sahəsi 55 kv.m. Əla təmirli. Televizor, KATV, soyuducu, h/t-bir yerdə, paltaryuyan maşın, istilik sistemi “kombi”, qaz, su, işıq daimi, 24 saat mühafizə, sakit həyət. 2 yüksək sürətli "Sigma " lifti , parking, yeraltı qaraj, uşaq meydançası. Qiymət 400 azn (Fərid)
 
Расстояния