It has different effects on different time scales.
Short term, the supply for a specific area increases while other factors are basically constant, exerting downward pressure on prices.
Long term, the positive effects of density increase the desirability of the area, pushing prices up.