SELECT *, CONCAT(st_num, `st`, `st_sfx`, apt_num) AS street_condition
FROM `reso_freehold_idx`
WHERE REPLACE(REPLACE(REPLACE(REPLACE(municipality, ' ', ''), '-', ''), '''', ''), '.', '') = 'hamilton'
AND REPLACE(REPLACE(REPLACE(REPLACE(community, ' ', ''), '-', ''), '''', ''), '.', '') = 'southam'
HAVING REPLACE(REPLACE(REPLACE(REPLACE(street_condition, ' ', ''), '-', ''), '''', ''), '.', '') = '51cloverhillrd'
ORDER BY `ml_num` DESC
 LIMIT 1SELECT *, CONCAT(st_num, `st`, `st_sfx`, apt_num) AS street_condition
FROM `reso_condo_idx`
WHERE REPLACE(REPLACE(REPLACE(REPLACE(municipality, ' ', ''), '-', ''), '''', ''), '.', '') = 'hamilton'
AND REPLACE(REPLACE(REPLACE(REPLACE(community, ' ', ''), '-', ''), '''', ''), '.', '') = 'southam'
HAVING REPLACE(REPLACE(REPLACE(REPLACE(street_condition, ' ', ''), '-', ''), '''', ''), '.', '') = '51cloverhillrd'
ORDER BY `ml_num` DESC
 LIMIT 1bool(false)