SELECT street_number, street_name, city, state, zip_code, media_url, street_dir_prefix, street_dir_suffix, street_suffix, price, beds, baths, BuildingAreaTotal, ST_X(location) AS lng, ST_Y(location) AS lat FROM properties WHERE street_number REGEXP '[0-9]' AND street_number != '' AND street_name != '' AND lng IS NOT NULL AND lng NOT LIKE 'NaN' AND lng != 0 AND lat IS NOT NULL AND lat NOT LIKE 'NaN' AND lat != 0 ORDER BY price DESC LIMIT :perPage OFFSET :offset

Second row, second column content goes here.