select id, redirect from sf_404 where url like 'buy/house/tipperary/mullinahone/kings-river-lodge-on-123-acres'Would redirect