SELECT property.paon, property.saon, property.street, property.postcode, property.lastSalePrice, property.lastTransferDate,
 epc.ADDRESS1, epc.POSTCODE, epc.TOTAL_FLOOR_AREA,
        (
            3959 * acos (
                cos (radians(54.6921))
                * cos(radians(property.latitude))
                * cos(radians(property.longitude) - radians(-1.2175))
                + sin(radians(54.6921))
                * sin(radians(property.latitude))
            )
        ) AS distance
        FROM property
        RIGHT JOIN epc ON property.postcode = epc.POSTCODE AND CONCAT(property.paon, ', ', property.street) = epc.ADDRESS1
        WHERE property.paon IS NOT NULL AND epc.TOTAL_FLOOR_AREA > 0
        GROUP BY CONCAT(property.paon, ', ', property.street)

        HAVING distance < 1.4
        ORDER BY property.lastTransferDate DESC
        LIMIT 10