Į pradžią
Spausdinti puslapio vidurį
English
2014 m. lapkričio 27 d., ketvirtadienis
Juozapavičiaus g. 9 (303 kab.), 09311 Vilnius,
Tel. fax.: +370 5 2767590, info@forest.lt
Naujienos LMSA veikla Klauskite-atsakome Nemokami skelbimai Teisės aktai Nuorodos Struktūra ir kontaktai
Apie projektą
Partneriai
Reklama
Kontaktai
Iš viso apsilankė: 22769991
Šiandien apsilankė: 209
Dabar naršo: 30
Juozapavičiaus g. 9 (303 kab.), 09311 Vilnius, Tel.fax.: +370 5 2767590. K.Donelaičio g. 2, Kaunas, Tel.: +370 37 400363
© Lietuvos miško savininkų asociacija. Visos teisės saugomos. Sprendimas: Idamas. Naudojama Smart Web sistema.
 
SELECT C.obj_id, C.obj_id, C.high_number, C.high_number, C.city, C.section, C.address, B.ann_id, B.user_id, B.plot_purpose, B.area_min, B.area_max, B.area_dim, B.min_rent_price, B.max_rent_price, B.rent_dim, B.sell_price, B.sell_dim, B.enter_date, B.update_date FROM m_realty_announcment B INNER JOIN m_realty_obj C ON B.subobj_id = C.obj_id WHERE B.in_first = 1 AND B.obj_type = 'com' AND B.ann_type = 0
SELECT C.obj_id, C.obj_id, C.high_number, C.high_number, C.city, C.section, C.address, B.ann_id, B.user_id, B.plot_purpose, B.area_min, B.area_max, B.area_dim, B.min_rent_price, B.max_rent_price, B.rent_dim, B.sell_price, B.sell_dim, B.enter_date, B.update_date FROM m_realty_announcment B INNER JOIN m_realty_obj C ON B.subobj_id = C.obj_id WHERE B.in_first = 1 AND B.obj_type = 'man' AND B.ann_type = 0
SELECT A.obj_id, A.obj_id, A.high, C.high_number, C.city, C.section, C.address , B.ann_id, B.user_id, B.plot_purpose, B.area_min, B.area_max, B.area_dim, B.min_rent_price, B.max_rent_price, B.rent_dim, B.sell_price, B.sell_dim, B.enter_date, B.update_date FROM m_realty_announcment B INNER JOIN m_realty_obj C ON B.subobj_id = C.obj_id INNER JOIN m_realty_subobj A ON A.obj_id = B.subobj_id WHERE B.in_first = 1 AND B.obj_type = 'plot' AND B.ann_type = 0