[query "
select firms.id as id,
firms.name as name,
firms.zip as zip,
firms.citytxt as citytxt,
firms.cred as cred,
firms.zipc as zipc,
firms.adress as adress,
firms.description_min as description_min,
firms.site as site,
firms.country_id as country_id,
firms.region_id as region_id,
countries.code as country_code,
countries.name_ru as country_name,
regions.name as region_name
from firms, regions, countries
where firms.country_id='39'
and
firms.country_id=countries.id
and
firms.region_id=regions.id
and
firms.parent_id='0'
and
firms.active='1'
and firms.region_id='305'
group by firms.id
order by regions.name, firms.name
limit 0,600" [sql query error: Disk full (/tmp/#sql_296b_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]]
Поиск объекта по запросу
В случае, если Вас не заинтересовал ни один из предложенных на сайте объектов, мы сможем найти для Вас объект недвижимости по Вашему индивидуальному запросу.