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

price = parser.cssselect('table.ogolosh-avto-sp tbody tr td div.price_ner div.right nobr:nth-child(3)')

#!/usr/bin/env python
 
import lxml.html
import requests
import sqlite3
 
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('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')
 
template = 'street: {}, number: {}, price: {}, note: {}'
 
conn = sqlite3.connect('/Users/jabbson/Documents/testdb.db')
c = conn.cursor()
 
for i in zip(street, number, price, note):
    c.execute('''INSERT INTO vashmagazin VALUES(?,?,?,?)''',
              (i[0].text_content().strip(), i[1].text_content().strip(), i[2].text_content().strip(), i[3].text_content().strip()))
 
conn.commit()
conn.close()

#!/usr/bin/env python
# -*- coding: utf-8 -*-
 
import lxml.html
import requests
import sqlite3
 
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('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')
 
conn = sqlite3.connect('/Users/jabbson/Documents/testdb.db')
c = conn.cursor()
 
template = 'INSERT INTO vashmagazin (street, number, price, note) VALUES ("{}","{}","{}","{}")'
 
for i in zip(street, number, price, note):
    c.execute(template.format(*[j.text_content().strip().replace('"', '') for j in i]))
 
conn.commit()
conn.close()