Coduri postale Bistrita, Haret Spiru

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('%Haret_Spiru%')) OR (street='')) AND 1 ORDER BY city LIMIT 0,16-10 Coduri postale Bistrita, Haret Spiru - cod postal Romania

Cod postal	Localitatea	Strada	Judetul
420048	Bistrita	Haret Spiru	Bistrita-Nasaud
427005	Bistrita Bargaului		Bistrita-Nasaud
427006	Bistrita Bargaului Fabrici		Bistrita-Nasaud