Ok for your entire second paragraph I would look into using something like a Windows Service that preforms each one of the tasks you are looking to do. I will try to break it down for you:
srelliott:download a zip folder from the MLS site via FTP
How to: Download Files with FTP:
http://msdn.microsoft.com/en-us/library/ms229711.aspx
srelliott:unzip it
WinZip has a command line utility that you can program against (shell out the commands) in .NET:
http://www.winzip.com/prodpagecl.htm
srelliott:move the photos to the photos folder
System.IO namespace should have everything you need here:
http://msdn.microsoft.com/en-us/library/system.io.file.move.aspx
srelliott:add data to the database
For this you could set up a job in SQL to import the text file, or you could import the text file via .NET and then BULK insert the data. There is a lot of ways to do this.
srelliott:then delete the zip folder that was just downloaded
Again use the System.IO namespace for this:
http://msdn.microsoft.com/en-us/library/system.io.file.delete.aspx
srelliott:And this will need to occur every 24hrs to make sure the content is updated.
If you use a Windows Service you can have this run on a System.Timers.Timer or System.Threading.Timer to occur at any interval you want. Take a look to the following:
http://csharpstruggles.blogspot.com/2005/02/using-timer-in-windows-service.html
http://www.codeguru.com/columns/dotnet/article.php/c6919
Lastly, I assume you have the rights to integrate MLS data into your site already. If not take a look at the notes from this thread too:
http://www.velocityreviews.com/forums/t121560-mls-integration.html
Hopefully this helps! 