1SELECT TOP 3 estates.* FROM estates inner join subareas on estate_area_id = subarea_id inner join areas on subarea_area_id = area_id WHERE area_id=1 AND estate_type_id = 3 AND estate_kind_id = 3 AND estates_id NOT IN(1125) ORDER BY estates_id DESC
We use cookies to personalize content and ads, provide social media features,
analyze our traffic, but also to ensure you a great and hassle-free browsing
experience. More information about cookies can be found here.
By selecting "Accept only necessary cookies" you accept only the necessary
cookies and some functions of the site, which depend on the cookies of third
parties. will no longer be available. To have all the features available, you have to
click "Accept all".
You can at any time edit the cookies stored on your device, going to the bottom of
our site, in the option "Manage Cookies".
The necessary cookies help to make a website useful, allowing basic functions,
such as navigation and access to secure areas of the website. The website cannot
function properly without these cookies. These cookies do not recognize your
personal identity. Without them we cannot offer effective operation of our
website. This is the reason why they are considered necessary.
Active
Performance/Statistics Cookies help website owners understand how visitors
interact with pages by collecting and reporting information anonymously.
Active
Targeting/advertising cookies are used to track visitors to websites. These
cookies are used to provide content that best suits you and your interests. The
intention is to display ads that are relevant and engaging to users and therefore
more valuable to third-party publishers and advertisers.
