In both cases, at least one of the rows of homes is actually large condo units on top of ground level retail space. The homes in both developments are selling quickly and in the first, the retail spaces are also condo (owner operated, or whatever you'd call it). It appears to be a mix of light food (coffee shop), retail, a fitness studio, and some small professional offices.
1 - http://www.crescentplaceleesburg.com/img/Waverly_Insert_Apr2...
2 - http://builtbytradition.com/development/developmentcurrent/j...
the other significant benefit of mixed zoning is that the city doesn't concentrate office space into pockets and breaks up peak hour travel across multiple directions and locations.
Oh wait, that's in my area, NYC. Maybe you should specify what area you're talking about too, this is a very regionally varying thing