I must admit I love nothing better than creating a totally trashed house for my sims to clean up. So far there are 4 houses:

Stoneyville Haunted House

http://www.thesimsresource.com/downloads/sims2/lots/residential/bygone/849016/

The Stone House (TSR Renovation Challenge)

 http://www.thesimsresource.com/downloads/sims2/lots/residential/contemporary/550518/

Renovator's Delight

 http://www.thesimsresource.com/downloads/sims2/lots/residential/contemporary/541917/

The Warehouse (TSR Rock God Challenge)

 http://www.thesimsresource.com/downloads/sims2/lots/residential/industrial/578417/

Please head over to the challenge threads to view & share screenshots by TSR members of their renovations:

TSR Renovation Challenge

http://forums.thesimsresource.com/showthread.php?t=340487

TSR Rock God Challenge

http://forums.thesimsresource.com/showthread.php?t=365357

Love & Hugs

Shaz