The apartment is located a couple of streets back from the main street running through Mestre, which means that it is very quiet and you don't get any traffic noise. Yet it is only a couple of minutes walk from the bus stops for the airport and Venice (bus 4L to/from Venice runs every 10 minutes, and takes 15-20 mins to get there). Right next to that is a Co-op supermarket, and between there are the apartment are restaurants and bars.
The apartment itself seems recently done up and everything appears clean and new. It is east-west facing so it gets the morning and evening sun, but not the midday sun. There are shutters on the windows, and there is air conditioning (which we didn't need to use), so the place does not overheat.
I would say it is much better saying here than in Venice. People forget that in Venice itself you have to walk everywhere, and the bridges are not flat! We're glad we stayed here and didn't have to lug our suitcases half way across Venice.
(Remember that in Venice, water transport is ludicrously expensive, unless you buy a 1-, 2-, 3- or 7-day pass, and they're not cheap either)