We've all seen them: the gorgeous and pristine home with curb appeal that just seems to liven up the entire neighborhood, and the down-on-its-luck home with the weed-filled yard and shabby paint that makes the whole block look bleak. For people who live near both of these homes, they might understandably wonder if the first will have a positive impact on the local real estate market while the second will cause housing values to fall.