select id, redirect from sf_404 where url like 'buy/house/dublin/rathfarnham/27-white-pines-heights-dublin-16'Would redirect