SELECT DISTINCT `id` as `hid`, `haendler`.*, (6368 * SQRT(2*(1-cos(RADIANS(haendler.lat)) *
cos(0.84799439702022) * (sin(RADIANS(haendler.lng)) *
sin(0.20598375832037) + cos(RADIANS(haendler.lng)) *
cos(0.20598375832037)) - sin(RADIANS(haendler.lat)) * sin(0.84799439702022)))) AS `Distance`
FROM `haendler` WHERE `id` IN (0,746355, 411072, 259382, 749296, 584496, 584498, 1484824, 580313, 523421, 747229, 1382997, 393113, 750270, 748562, 811943, 789076, 1639794, 215515, 751459, 1273192, 215378, 1639810, 745440, 533875, 747212, 734449, 1614756, 1639805, 329204, 750929, 420286, 378448, 746587, 1640074) ORDER BY `Distance` ASC LIMIT 500
Insurances in Rudelzhausen - 4 Service provider
-
locabee.com
-
Rudelzhausen
-
Insurances
4 Stores for Insurances in Rudelzhausen
Allianz Versicherung Hermann Frantz Generalvertretung
Hochfeldstraße 10
84104 Rudelzhausen
more
Richard Märkl - Unabhängiger Versicherungsmakler
Pfarrer-Reindl-Straße 8A
84048 Mainburg
more
Allianz Versicherung Alois Michael Faltermeier Generalvertretung
Mainburger Straße 12
84072 Au in der Hallertau
more
Versicherungskammer Bayern - Versicherungsmanagement Fischer & Thoma GbR
Freisinger Str. 12
84048 Mainburg
more
Is something missing here?
Do you have a business in Rudelzhausen? 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 11:01:15
UP
Choose your country and language