Save
Ask
Tour
Hide
Share
$2,699,000
83 Days On Site

464 Piper Street
North Dumfries, ON N0B 1E0

For Sale|Single Family Residence|Active
3
Beds
3
Total Baths
County:
Waterloo
464 Piper Street464 Piper Street464 Piper Street464 Piper Street
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$12,314
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

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

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,699,000
Days On Site 
83 Days
Bedrooms 
3
Inside Area (SqFt) 
N/A
Total Baths 
3
Full Baths 
N/A
Partial Baths 
N/A
Lot Size 
5.41 Acres
Year Built 
N/A
MLS® Number 
X13147520
Status 
Active
Property Tax 
$9,020
Maintenance Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
a month agoListing updated with changes from the MLS®
2 months agoStatus changed to Active
3 months agoListing first seen on site
General Features
Cross Street 
Gladstone
Direction Faces 
West
Foundation 
Stone
Garage 
Yes
Number Of Stories 
2
Parking 
Circular DrivewayDetached
Parking Spaces 
18
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
Style 
2-Storey
Water Source 
WellPrivate
Zoning 
Z1
Interior Features
Appliances 
Water SoftenerWater Purifier
Basement 
PartialUnfinished
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
Gas
Fireplaces 
1
Heating 
Natural GasForced Air
Interior 
In-Law Floorplan
Bathroom 
Dimensions - 2.44 x 2.06Level - Second
Bedroom 2 
Dimensions - 4.29 x 4.44Level - Second
Bedroom 3 
Dimensions - 4.29 x 3.05Level - Second
Dining Room 
Dimensions - 4.14 x 4.72Level - Main
Great Room 
Dimensions - 10.08 x 7.57Level - Main
Kitchen 
Dimensions - 7.77 x 4.93Level - Main
Laundry 
Dimensions - 3.02 x 3.0Level - Main
Living Room 
Dimensions - 4.93 x 3.33Level - Main
Master Bedroom 
Dimensions - 6.91 x 4.29Level - Second
Mud Room 
Dimensions - 2.84 x 4.55Level - Main
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Stone
Lot Features 
Landscaped
Patio And Porch 
Deck
Pool Features 
Above Ground
Roof 
AsphaltMetal
View 
Trees/WoodsForestRiver
Waterview 
Trees/WoodsForestRiver
Listing courtesy of RE/MAX TWIN CITY REALTY INC.

Listing information is provided by Participants of the Toronto Real Estate Board. VOW information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, Toronto Real Estate Board
Last checked 2026-08-11 01:33 PM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share