For Sale

464 Piper Street

$2,699,000
North Dumfries, Ontario N0B 1E0 · MLS® X13147520 · Updated 7d ago
464 Piper Street, North Dumfries, ON N0B 1E0
1 / 50 photos
3
Bedrooms
3
Bathrooms
Sq Ft
18
Parking

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.

Property Information

Type
Residential Freehold
Style
Detached
Architectural Style
2-Storey
Age
100+
Lot Size
311.1 × 611 ft
Direction Faces
West
Bedrooms
3
Kitchens
1
Parking
18 total · Detached
Cross Street
Gladstone
Postal Code
N0B 1E0
Occupancy
Owner
Possession
Other
MLS#
X13147520
Listing Office
RE/MAX TWIN CITY REALTY INC.

Building Details

Construction
Board & Batten , Stone
Roof
Asphalt Shingle, Metal
Heating
Forced Air · Gas
Cooling
Central Air
Basement
Partial Basement, Unfinished
Fireplace
1 · Natural Gas
Laundry
Main Level
Pool
Above Ground

Features & Amenities

Interior
Accessory ApartmentIn-Law SuiteWater SoftenerWater Treatment
Exterior
DeckLandscaped
View
ForestRiver

Financials & Fees

Annual Property Tax
$9,020 (2025)

Inclusions & Exclusions

Inclusions

All appliances, window coverings, riding zero turn mower, great room table and stools

Location

Listing courtesy of:RE/MAX TWIN CITY REALTY INC.

Source: Toronto Regional Real Estate Board (TRREB), via PropTx Innovations Inc.

The data relating to real estate on this website comes in part from the MLS® data feed of PropTx Innovations Inc. The information is deemed reliable but is not guaranteed accurate by PropTx.

The information provided herein must only be used by consumers that have a bona fide interest in the purchase, sale or lease of real estate and may not be used for any commercial purpose or any other purpose.

© 2026 PropTx Innovations Inc. All rights reserved. MLS®, REALTOR® and the associated logos are owned or controlled by The Canadian Real Estate Association (CREA).