I’ve seen a only a few foreclosures in CV in that range. And the only one I saw any discount on at all was in really bad condition.
The one I mentioned in an earlier post (Great Meadow Drive) sold for probably more than it was worth. I’m with everyone else here; I seriously doubt you’ll be able to pay anything less than full market value for that house.
As for whether it would drag down surrounding properties, well, obviously only if it sold at a discount. Which it most likely won’t. Foreclosures in this price range in CV are still quite rare. If there were a bunch of them, they could have an effect, I suppose. But the occasional one that sells at full market value won’t budge anything.