The acceleration due to gravity is never exactly zero at any point on the Earth's surface. Gravity is a fundamental force that exists everywhere, pulling objects towards the Earth's center. However, there are certain locations where the gravitational force can be effectively cancelled out by the gravitational pull of other celestial bodies or by the centrifugal force due to the Earth's rotation. These points are known as Lagrange points, specifically Lagrange point L1, L2, and L3.
However, it's important to note that Lagrange points are not on the Earth's surface but rather points in space where the gravitational forces of multiple bodies balance out. Therefore, while the acceleration due to gravity can be very small at these points, it is technically never zero, especially at any location on the Earth's surface.