$2,699,000
FOR SALE

Detached 2-Storey

Bedrooms: 3Bathrooms: 3Lot: 311.1 x 611 ft
2025 Taxes: $9,020

464 Piper St
North Dumfries, ON N0B 1E0 | Waterloo

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. Open House Sat 2-4
Extras
Accessory Apartment, In-Law Suite, Water Softener, Water Treatment
Share
Listed By RE/MAX TWIN CITY REALTY INC.
Data Provided By Toronto Regional Real Estate Board
MLS® Listing Number X13147520
Last Updated May 26, 2026
Property Summary
Property Type Detached

More like this:
PIN 038530057
Legal Description CON 8 PT LOT 38
Possession Date 120 days +
Taxes (2025) $9,020
Directions/Cross Streets Gladstone
Area Waterloo
Price History

Interested in obtaining the full price history for this property?
Contact us!Contact us! Our real estate professionals would be happy to provide a complete listing history with historical sold prices and dates.

Detailed Information
Fronting On West
Special Designations Unknown
Bedrooms 3
Bathrooms 3
Lot 311.1 x 611 ft
Exterior Board & Batten
Air Conditioning Central Air
Family Room Y
Fireplace/Stove Y
Pool Above Ground
Basement Partial Basement, Unfinished
Garage Type Detached
Garage/Park Spaces Y
Parking Spaces 15
Heat Source Gas
Heat Type Forced Air
Sewers Septic

The information contained on this site is based in whole or in part on information that is provided under copyright by the Toronto Regional Real Estate Board (TRREB) or by members of The Canadian Real Estate Association (CREA), who are responsible for its accuracy. TRREB and CREA reproduce and distribute this information as a service for their members and assume no responsibility for its accuracy. All information displayed is believed to be accurate but is not guaranteed and should be independently verified. No warranties or representations of any kind are made with respect to the accuracy of such information.
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.

FREE ESTIMATES ARE COMING

Reserve Your Spot To Be Notified
or

Coming soon to select cities
in North America

(We'll never share your details)