Парсер html: вытащить весь текст, который в объявлениях

print template.format(*[j.text_content().strip().replace('"', '') for j in i])

print template.format(*[j.text_content().encode('utf-8').strip().replace('"', '') for j in i])

import sqlite3
 
import lxml.html
import requests
 
 
url = 'http://vashmagazin.ua/nerukhomist/kvartyry/sykhivskyy-rayon/'
 
page = requests.get(url).text
parser = lxml.html.fromstring(page)
 
street = parser.cssselect('table.ogolosh-avto-sp tbody tr strong')
number = parser.cssselect('table.ogolosh-avto-sp tbody tr td.rowspan-fix')
price = parser.cssselect('table.ogolosh-avto-sp tbody tr td div.price_ner div.'
                         'right nobr:nth-child(3)')
note = parser.cssselect('div.text_hidden_def')
 
connect = sqlite3.connect('./testdb.db')
cursor = connect.cursor()
 
for data in zip(street, number, price, note):
    cursor.execute(
        'INSERT INTO you_shop (street, num, price, note) '
        'VALUES (?, ?, ?, ?)', [j.text_content().strip() for j in data]
    )
 
connect.commit()
connect.close()

import lxml.html
import requests
import sqlite3
import pprint
 
page = requests.get('http://vashmagazin.ua/nerukhomist/kvartyry/sykhivskyy-rayon/').text
parser = lxml.html.fromstring(page)
 
street = parser.cssselect('table.ogolosh-avto-sp tbody tr strong')
number = parser.cssselect('td.rowspan-fix')
price = parser.cssselect('table.ogolosh-avto-sp tbody tr td div.price_ner div.right nobr:nth-child(3)')
note = parser.cssselect('table.ogolosh-avto-sp tbody tr td div.text_hidden_def ')
 
con = sqlite3.connect('parser.db')
cur = con.cursor()
cur.execute('CREATE TABLE parser (id INTEGER PRIMARY KEY, street CHAR(128), NUMBER CHAR(128), price CHAR(128), note CHAR(128))')
con.commit()
 
#template = u'INSERT INTO parser (street, number, price, note) VALUES ("{}","{}","{}","{}")'
 
for i in zip(street, number, price, note):
    #cur.execute(template.format(*[j.text_content().strip().replace('"', '') for j in i]))
    cur.execute('''INSERT INTO parser VALUES(?,?,?,?,?)''',
        (None, i[0].text_content().strip(), i[1].text_content().strip(), i[2].text_content().strip(), i[3].text_content().strip()))
 
 
con.commit()
cur.execute('SELECT * FROM parser')
for line in cur.fetchall():
    for item in line:
        print item,
    print ''
con.close()

#template = u'INSERT INTO parser (street, number, price, note) VALUES ("{}","{}","{}","{}")'
for i in zip(street, number, price, note):
    cur.execute(template.format(*[j.text_content().strip().replace('"', '') for j in i]))

cur.execute('''INSERT INTO parser VALUES(?,?,?,?,?)''',
        (None, i[0].text_content().strip(), i[1].text_content().strip(), i[2].text_content().strip(), i[3].text_content().strip()))