This grand residence at Galston in Sydney’s Hills district is expected to attract offers above $5 million.

Inside the luxurious residence, situated in two prime hectares at Galston, is a stunning atrium with a waterfall and running creek encased in a towering three-metre window.

Set against the formal dining and living areas of the home, it offers a new twist on the theme of bringing the ‘outdoors inside’.

This stunning Galston mansion in Sydney’s Hills district features undulating grounds.Source:Supplied

This house features a waterfall and running creek in the living room.Source:Supplied

“I have never seen a creek through a house — I have never seen anything like this at all, not in the Hills District, not anywhere,” said agent Sandy Ward from Ray White Dural, who has just listed the property for sale.

The formal lounge room connects to the internal garden.Source:Supplied

A special lighting system helps the plants grow at night.Source:Supplied

The sprawling six bedroom home was built 15 years ago and was the brainchild of its former owner the late architect John Van Berkel.

The new owners paid $2.75 million for the property in 2002 and it has now been listed with a price guide of ‘offers over $5 million’.

The swimming pool has been added by the current owners.Source:Supplied

The grand residence was built on an old dairy farm.Source:Supplied

The full brick double storey residence lies behind electric security gates on Crosslands Rd.

It was constructed on 220 piers to ensure the home was solid as possible.

The long driveway cuts through two cascading man-made dams on the estate, built with a special drainage system to prevent flooding.

The road winds up to the front of the manor, which is framed by beautiful hedging, sculptured trees and surrounded by rolling green paddocks.

The front driveway was specially designed to pass through the man-made dam on the property.Source:Supplied

Two marble steps in the vast entry lead to the formal room with its amazing greenery as a backdrop.

“It is just like a wooded area and is beautiful,” Ms Ward said.

“The current owner’s wife and then six-year-old daughter decided they wanted to buy the house as soon as they walked in and saw it from the front steps.”

Other features include a purpose built home theatre.Source:Supplied

The atrium windows are sun protected so a special UV system kicks in at night giving the plants enough light to thrive.

It is also temperature controlled by computer so if anything goes wrong or malfunctions, such as the waterfall stopping, it sends an alert.

The large kitchen flows on to the informal dining room.Source:Supplied

The high-end property also boasts other features including a billiard room, wet bar and home theatre room with a transducer system which adds vibrations to the movie watching experience. A wrap around terrace overlooks the in-ground pool with pontoon and waterfall.

The billiards room overlooks the lush green gardens.Source:Supplied

The outdoor eating area also has an ice-maker and fridge.Source:Supplied

The home also has guest quarters with kitchenette, external entry and ensuite.

Several contracts have been issued since the property was listed on the market.

“There are a lot homes in The Hills with amazing features but I have not have had anything like this,” Ms Ward said.

The home is behind an electric front gate.Source:Supplied