Hi,
your rule causes a loop because the From URL, as a regular expression, matches the original URL you wanted to redirect but also the final URL you wanted to go to. Change the rule as follow (literally):
From URL: ^/manor-by-the-lake$
To URL: {scheme}://{siteurl}/classifieds-search/venue/ceremony-reception-3/manor-by-the-lake-524
Request only: true (checked)
Kind regards,
Luigi