Недвижимость в Португалии

Кашкайш

Один из самых интересных и престижных городов Португалии. Красивые ухоженные дома, уютные жилые комплексы, богатая природа – все это создало Кашкайшу заслуженную славу. Отсюда рукой подать и до океанских пляжей, и до тенистых лесов природного парка Синтра-Кашкайш, и до шумного Лиссабона. Сам Кашкайш и его окрестности – это тихий и уютный уголок, который многие по праву называют идеальным местом для жизни. Недаром по средним ценам на недвижимость с ним может соперничать только Лиссабон и Золотой Треугольник Поругалии.
Развернуть карту
Тип сделки
Select *, (Select count(*) from catalog where exists(Select * from catalog_values where catalog.id=catalog_values.idt and catalog_values.def=catalog_paramdef.id limit 1) and catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=1 order by name_ru asc
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=1 ord' at line 1
Регион португалии
Цена от ... до ...
Тип недвижимости
Select *, (Select count(*) from catalog where exists(Select * from catalog_values where catalog.id=catalog_values.idt and catalog_values.def=catalog_paramdef.id limit 1) and catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=2 order by name_ru asc
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=2 ord' at line 1
Состояние
Select *, (Select count(*) from catalog where exists(Select * from catalog_values where catalog.id=catalog_values.idt and catalog_values.def=catalog_paramdef.id limit 1) and catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=27 order by name_ru asc
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=27 or' at line 1
Ванные
Select distinct(text) as name, (Select count(*) from catalog where exists(Select * from catalog_values as CV where catalog.id=CV.idt and CV.idp=6 and CV.text=catalog_values.text limit 1) and catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 limit 1) as count from catalog_values where idp=6 order by (text+0) asc, text asc
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 limit 1) as count from catalog_values where idp=6 order' at line 1
Спальни
Select distinct(text) as name, (Select count(*) from catalog where exists(Select * from catalog_values as CV where catalog.id=CV.idt and CV.idp=5 and CV.text=catalog_values.text limit 1) and catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 limit 1) as count from catalog_values where idp=5 order by (text+0) asc, text asc
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 limit 1) as count from catalog_values where idp=5 order' at line 1
Информация
Select *, (Select count(*) from catalog where exists(Select * from catalog_values where catalog.id=catalog_values.idt and catalog_values.def=catalog_paramdef.id limit 1) and catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=25 order by name_ru asc
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 limit 1) as count from catalog_paramdef where idp=25 or' at line 1
Select count(id) as n from catalog where catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 limit 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 limit 1' at line 1
Select *, (Select fname from catalog_photo where catalog_photo.type="gallery" and catalog_photo.idt=catalog.id order by tomain desc, id asc limit 1) as fname, (Select title_ru from catalog_location where catalog_location.id=catalog.region_id limit 1) as region, (Select title_ru from catalog_location where catalog_location.id=catalog.city_id limit 1) as city from catalog where catalog.lang="ru" and catalog.hide=0 and and catalog.city_id=17 order by timecreate desc limit 0,33
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and catalog.city_id=17 order by timecreate desc limit 0,33' at line 4