← Back to results
For sale

464 Piper Street, North Dumfries

Price
$2,699,000
Beds
3
Baths
3
Home type
House
Lot
311.1 x 611 ft

Bedroom count from the listing feed; may include a den.

Home details

MLS® number
X13147520
Home type
House
Listed
May 20, 2026
Days on market
185
Property tax
$9,020 (2025)
Parking
18 spaces · Detached garage
Basement
Unfinished, partial

About this home

5.5-Acre Ayr Estate - step into a rare blend of pre-Confederation legacy and modern luxury at Stonehaven Estate. Nestled on manicured grounds within walking distance of Ayr, this mid-1800s stone farmhouse has been transformed into the ultimate family retreat and entertainer's paradise. Boasting over 3,000 sqft of living space, the main residence flawlessly marries heritage character with contemporary design. The heart of the home is a breathtaking 800 sq. ft. Great Room featuring soaring vaulted ceilings, wrap around windows/doors to pool deck, original exposed stone walls, a gas fireplace, and wide-plank flooring. A modernized showstopper kitchen, main floor is perfectly complemented by formal living/dining rooms and main floor laundry. Upstairs offers three bedrooms, a main 3-piece bath, and a vast Primary Suite with a stunning private ensuite. Beyond the main home, the property offers incredible outbuildings designed for utility and lifestyle. Capped by a striking red steel roof, the detached Coach House features a 3.5-bay garage. Above, a fully modernized 2-bedroom apartment reveals a gourmet kitchen, sprawling living space, and vaulted ceilings, with layout potential to add an extra bedroom on the main level. Adding to the estate's appeal is a custom-finished, heated shop ideal for hobbyists and entrepreneurs. This space features epoxy floors, a WETT-certified wood stove, electric heating, available water, and a large commercial roll-up door. Centered around a custom live-edge wood bar, it is the ultimate private pub, showroom, or home-business headquarters. Offering unparalleled privacy just minutes from Ayr's vibrant downtown amenities, Stonehaven Estate is truly a legacy property. The apartment's legal status and permits are currently being updated with the township to ensure full buyer confidence, and the property will also benefit from a brand-new septic system. Watch the YouTube video to truly see what this estate has to offer.

Monthly payment

A rough number from the price and your own rate. It leaves out property tax, heating and mortgage insurance.

Type your lender's rate to see the payment.
Listed by RE/MAX Twin City Realty Inc.Powered by REALTOR.ca (Third-party site, opens in a new tab)

Similar homes

See more homes in North Dumfries

Before you go

Fifteen minutes with the team, whenever you are ready.

A call, a question, a second opinion on a listing. We will tell you the next step and leave the rest to you.

Search homes

Kai Min, Peng Hock Tan, Ola Akinyemi · Royal LePage Meadowtowne · 647-657-8589