Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
AFAIK there is no way to get the formatted/normalized address value used by the search function within the geocoder (bear in mind that it is a external party wrapped by a postgreSQL function of the SQL API). As I mentioned above, you can get the coordinates if you replace the * with something like st_x(cdb_geocode_street_point) as x, st_y(cdb_geocode_street_point) as y.