Coduri postale Bistrita, Maior Petru

ro-fr-BN-SELECT postal_code,city,street,county_id,county,street,city FROM ro WHERE (LCASE(county_id)=LCASE('BN')) AND (LCASE(city) LIKE LCASE('%Bistrita%')) AND ((LCASE(street) LIKE LCASE('%Maior_Petru%')) OR (street='')) AND 1 ORDER BY city LIMIT 0,16-10 Coduri postale Bistrita, Maior Petru - cod postal Romania

Cod postal	Localitatea	Strada	Judetul
420165	Bistrita	Maior Petru	Bistrita-Nasaud
427005	Bistrita Bargaului		Bistrita-Nasaud
427006	Bistrita Bargaului Fabrici		Bistrita-Nasaud