Northern California Full Landscape Redesign

Approximately 10,000 square feet sloped lot needs full landscape remodel design. Scope also include expansion of decks and replacement of siding and roof so need to consider color and materials to use on exterior of house. Please provide a lighting plan for yard and house exterior as well.

Video walkthrough available at https://photos.app.goo.gl/4N6lOWe0UrdeCYDO2

As the location gets quite windy, in order to have usable outdoor area, I would like a dining area under the backyard deck (NE side, perspective view provided) that will require a retaining wall to be created and extend some usable space into the sloped area. Similarly, would like to expand the front entrance deck to create a grander entrance for curb appeal.

The space will be used for two children currently so keep in mind child friendly design but also something flexible so they can grow into as they become older and eventually move out.

There is a ramp connected to the backyard deck from the previous owner - please remove as it heavily disrupts the flow of access from the back kitchen entrance to the back yard.

Other nice-to-haves (but optional) include:
- A hot tub preferably sunken in the back, possibly under the backyard deck as well
- Detached in-law unit/accessory dwelling unit
- Flatten or terrace part of the backyard into separate functional areas
- There is a view of the airport that can only be viewed by standing on the roof. It would be nice to have some viewing platform on the roof accessible from the outside to take advantage of it.
- Again, because the location is windy, keep in mind how to keep the upper deck and other parts of the uncovered deck usable (eg. wind blockers, high glass walls?)
- Feel free to push the fence line forward/backward to create more/less front/back yard space per your design.

The Christmas tree in the front yard and the oak tree in the backyard (see video) are the only plants that we want to keep for sure. Everything else is open for modification/removal in the design.

The southeast side of the lot slopes down again (where the shed currently is; see included perspective drawings and video) and is a difficult space to incorporate into rest of yard. Please consider options in this neglected area.

Prefer modern style with some Asian influence ie. a zen garden. Minimize use of plants to keep bugs away from house (we currently get hundreds of flying gnats seasonally around the house each year). A low maintenance, low water usage lawn is important.