Pescara
SELECT `id`, `categoria` FROM `cinesich63285`.`inse_19` WHERE (`attivo`=1 or `attivo`=6 or `attivo`=7 or `attivo`=8 ) AND `prov`="PESCARA"

---

单身房出售

---

---

日期: 28/08/2018 - 价格: € 580000 - 城市: PESCARA

---

---

別墅

---

---

日期: 08/08/2018 - 价格: € 350000 - 城市: LORETO APRUTINO

---

---

我卖

---

---

日期: 12/07/2018 - 价格: € 50000 - 城市: PESCARA

---

---

商业结构2500平方米

---

---

日期: 08/03/2018 - 价格: € 1500000 - 城市: TOCCO DA CASAURIA

---

---

平面

---

---

日期: 09/12/2017 - 价格: € 170000 - 城市: PESCARA

---

SELECT `id`, `categoria` FROM `venderea74508`.`inse_19` WHERE (`attivo`=1 or `attivo`=6 or `attivo`=7 or `attivo`=8 ) AND `prov`="PESCARA"