Geospatial query that search properties nearby to a point

geospatialMYSQL.sql

SELECT
    prom.id, p.id, p.direccion, p.latitud, p.longitud,
    (
        6371 *
        ACOS(
            COS( RADIANS( 6.250020 ) ) *
            COS( RADIANS( `latitud` ) ) *
            COS(
                RADIANS( `longitud` ) - RADIANS( -75.568510 )
            ) +
            SIN(RADIANS( 6.250020 )) *
            SIN(RADIANS(`latitud`))
        )
    ) `distance`
FROM
    Propiedad p
INNER JOIN Promocion prom ON p.id = prom.id_propiedad
HAVING
    `distance` < 1
ORDER BY
    `distance` ASC
LIMIT 10 OFFSET 10