This completely private property at 3340-3382 Old Northern Road features a magnificent three-storey mansion and large five-bedroom mansion, both with their own separate titles.

Expansive park-like grounds, rolling lawns, a sun-soaked swimming pool, grand ballroom, and a private helipad for quick access to the airport are just a few of the many epic features offered.

Kate Lumby, principal of Lumby Hampson Dural, says the rural property is an exceptional opportunity for multigenerational families and has already attracted a flood of inquiries from all corners of the world.

"The international marketing campaign has already prompted buyers from China, India, Portugal and Dubai to visit the property," she said.

Ms. Lumby also noted that Glenorie has a strong appeal to local buyers and that the suburb has experienced "tremendous growth" in recent years.

"The arable lifestyle is now an attractive option for many Sydney families as the inner-city suburbs become more crowded," she explained.

The stately mansion was designed and custom-built by the current owners in 2010, inspired by a love of the expansive land and abundant natural beauty.

It boasts a grand entrance hall, regal formal living and dining rooms, drawing and billiard rooms, a piano lounge and a full-size granite bar.

The grand ballroom - complete with catering kitchen, bar and dance floor - also serves as a showroom for the luxury car collection.

Ms. Lumby said the residence has served as a venue for weddings, fancy events and numerous film productions.

"With its many magnificent spaces, highly intimate setting and spectacular Blue Mountains backdrop, it provides the perfect setting for any film shoot," she added.

The accommodation consists of four bedrooms on the ground floor, each with its own walk-in closet and luxury marble ensuite.

On the second level, an exceptionally spacious master suite includes a luxurious spa suite, private sitting room and sun-soaked terrace, while the versatile upper level is perfect for staff accommodation.

The additional five-bedroom home base has recently been completely renovated.

Ms. Lumby also noted the property's strong appeal to business-oriented buyers, with its RU2 rural landscape zoning providing opportunities for a range of tourist features and accommodation options.

Although entirely private, the residence enjoys easy access to the Wisemans Ferry and Berowra Waters Marina for boat moorings, is only 19 minutes from Dural and has access to some of Sydney's best schools.

Expressions of interest are currently being accepted.