Teacandy: Here is what I created based on your request.
Download Link:
http://www.thesims3.com/assetDetail.html?assetId=3273603I did use one Store item, the Cellar Arch, which i believe is a free item. It's mainly on the exterior and should be replaced by another arch if you didn't want to download it. Everything else should be from the base game or World Adventures.
Outside, there is a patio at the back of the house for entertaining, and a good sized pool. There are 3 garden plots waiting for plants, and three parking spaces at the front of the house.
First floor contains kitchen and dining rooms, a reading room and a TV room. There is a half bath and a room set aside for Laundry (I do not have Ambitions).
Second floor contains 4 bedrooms (2 singles, 1 double and 1 currently a nursery), 2 full baths, a Master Bedroom with en suite bath and a painting/chess room.
Third floor contains a workout room, a full bath with shower, and two extra rooms that could be used for an Office, extra bedroom, etc. (I left these empty so that they could be filled with some of the Ambitions skilling stuff, as desired.)
There is a Cellar with a full bath and some decorative items. It would be easy to move things about and add a sculpture work area, and a nectar making area.
The exterior of the house is based on the Patsy Clark mansion (easily googled.) I had a lot of fun recreating the house in a way that was functional in game. Feed back would be lovely, feel free to PM me. (anyone).
I may go back and recreate this on a 40x40 lot so it can be used closer in to town.