464 Piper Street, North Dumfries, ON N0B 1E0
$2,699,000
$2,699,000

464 Piper Street

North Dumfries, Waterloo $2,699,000

Make an offer

3 Beds
3 Baths
3500-5000 sqft
Detached Garage
Parking for 15
West Facing
Pool!
Zoning: Z1
MLS®#:
X13147520
Property Type:
Detached
Property Style:
2-Storey
Area:
Waterloo
Community:
Taxes:
$9,020 / 2025
Added:
May 20 2026
Lot Frontage:
311.1
Lot Depth:
611
Status:
Active
Outside:
Board & Batten ,Stone
Year Built:
100+
Basement:
Partial Basement,Unfinished
Brokerage:
RE/MAX TWIN CITY REALTY INC.
Lot :

611

311

BIG LOT

Intersection:
Gladstone
Rooms:
Bedrooms:
3
Bathrooms:
3
Fireplace:
Utilities
Water:
Well
Cooling:
Central Air
Heating Type:
Forced Air
Heating Fuel:
Great Room 10.08 x 7.57m

Main Level
Kitchen 7.77 x 4.93m

Main Level
Living Room 4.93 x 3.33m

Main Level
Dining Room 4.14 x 4.72m

Main Level
Mud Room 2.84 x 4.55m

Main Level
Laundry 3.02 x 3m

Main Level
Primary Bedroom 6.91 x 4.29m

Second Level
Bathroom 1.6 x 2.87m
4 Pc Ensuite
Second Level
Bedroom 2 4.29 x 4.44m

Second Level
Bedroom 3 4.29 x 3.05m

Second Level
Bathroom 2.44 x 2.06m

Second Level
Bathroom 1.96 x 1.65m
2 Pc Bath
Main Level

Listing Details

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

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

Insights

  1. Historic Charm Meets Modern Luxury: This mid-1800s stone farmhouse has been beautifully transformed, offering over 3,000 sqft of living space that combines heritage character with contemporary design, making it a unique family retreat and entertainer's paradise.
  2. Ample Parking and Versatile Outbuildings: With a total of 18 parking spaces and a detached Coach House featuring a 3.5-bay garage and a modern 2-bedroom apartment, this property provides excellent utility and potential for rental income or guest accommodations.
  3. Expansive 5.5-Acre Estate: Nestled on manicured grounds, this estate offers unparalleled privacy while being just minutes away from Ayr's vibrant downtown amenities, making it an ideal location for both relaxation and convenience.

Sale/Lease History of 464 Piper Street

View all past sales, leases, and listings of the property at 464 Piper Street.

Neighborhood Overview

Complete neighborhood profile for 464 Piper Street

home prices

Average sold price for Detached, Semi-Detached, Condo, Townhomes in

Insights for 464 Piper Street

View the highest and lowest priced active homes, recent sales on the same street and postal code as 464 Piper Street, and upcoming open houses this weekend.

* Data is provided courtesy of TRREB (Toronto Regional Real-estate Board)
Aravinth R. Listo Expert