SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) *
cos(0.88399181284261) * (sin(RADIANS(haendler.lng)) *
sin(0.15092280921015) + cos(RADIANS(haendler.lng)) *
cos(0.15092280921015)) - sin(RADIANS(haendler.lat)) * sin(0.88399181284261)))) AS `Distance`
FROM `haendler` WHERE `id` IN (1527282, 783237, 745601, 751493, 751644, 750683, 749163, 748320, 746622, 751028, 780844, 1416867, 748627, 746038, 750263, 750917, 746034, 745868, 746786, 746366, 750322, 748071, 750147, 748629, 811670, 748729, 1238868, 749901, 751219, 750819, 749348, 1527166, 750551, 811933, 1239426) ORDER BY `Distance` ASC LIMIT 500
Products from Allianz Trade® in Wettenberg - 5 stores
-
locabee.uk
-
Wettenberg
-
Allianz Trade
5 Stores for Allianz Trade in Wettenberg
Allianz Versicherung Timo Weber Generalvertretung
Felsweg 16
35435 Wettenberg
more
Allianz Versicherung Vanessa Schumann Hauptvertretung
Felsweg 16
35435 Wettenberg
more
Allianz Versicherung Adigüzel OHG Hauptvertretung
Marburger Straße 18
35457 Lollar
more
Allianz Versicherung Frithjof Köhler Hauptvertretung
Am alten Bahnhof 8
35457 Lollar
more
Allianz Versicherung Metz,Mandler und Brand GbR Generalvertretung
Gießener Straße 72
35444 Biebertal
more
Is something missing here?
Do you have a business in Wettenberg? Enter it for free in a few steps.
Register now!
© 2024, Wogibtswas / Locabee. All brand names and trademarks are the property of their respective owners. All information without guarantee. Status 04.10.2024 10:57:05
UP
Choose your country and language