Any question answered...

My wife wants a new bicycle.

Requirements are:

1. Good for commuting AND days out on the road/possibly off the road
   (gravel tracks nothing extreme)
   
2. Must be lightweight as we live on the third floor and she'll be
   carrying it up stairs.
   
3. Aesthetically pleasing!
   
4. Must have gears as Glasgow is a hilly fecker.
   
5. Not crazy expensive (from £500-£900 max)
   
   

Most important thing is the weight and the commuting/non-commuting days out on bike aspects.

Any thoughts would be greatly appreciated.

Thanks.
Andrew