464 Piper Street

North Dumfries, Ontario N0B 1E0

Overview

At a glance

Days on market158 days
ListedMay 20, 2026
UpdatedOct 1, 2026
Building age100+ years
Size3500-5000 sq ft
Lot311.1 x 611 Feet
Property taxes$9,020 (2025)
Parking18 spaces
BasementPartial Basement, Unfinished
MLS® numberX13147520
Data sourcePropTx MLS® System
Listing brokerageRE/MAX TWIN CITY REALTY INC.

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.

Details

Property

Style
2-Storey
Building age
100+
Fronting on
West
Cross street
Gladstone
Municipality
North Dumfries

Inside

Bedrooms above grade
3
Bathrooms
3
Kitchens
1
Basement
Partial Basement, Unfinished
Family room
Yes
Fireplace
Natural Gas
Interior features
Accessory Apartment, In-Law Suite, Water Softener, Water Treatment

Utilities

Heating
Forced Air
Heating fuel
Gas
Cooling
Central Air
Sewer
Septic

Building

Construction
Board & Batten , Stone
Foundation
Stone
Roof
Asphalt Shingle, Metal
Exterior features
Deck, Landscaped
Pool
Above Ground

Parking

Garage
Detached
Parking spaces
15
Total parking
18
Driveway
Circular Drive

Land

Frontage
311.1
Depth
611
Lot size units
Feet
Lot size (acres)
5-9.99
Waterfront
No
Rooms (12)
RoomLevelSizeFeatures
Great RoomMain10.08 x 7.57
KitchenMain7.77 x 4.93
Living RoomMain4.93 x 3.33
Dining RoomMain4.14 x 4.72
Mud RoomMain2.84 x 4.55
LaundryMain3.02 x 3
Primary BedroomSecond6.91 x 4.29
BathroomSecond1.6 x 2.874 Pc Ensuite
Bedroom 2Second4.29 x 4.44
Bedroom 3Second4.29 x 3.05
BathroomSecond2.44 x 2.06
BathroomMain1.96 x 1.652 Pc Bath
Value

What it’s worth

Automated estimate

Free Sold Nearby account

What this home is likely to sell for, based on its asking price and what similar homes nearby have actually sold for.

Create a free account

Market read

Free Sold Nearby account

Whether North Dumfries is a buyer’s or seller’s market right now, and how long homes like this usually take to sell.

Create a free account

History

Listing history

Past listings and sales

Free Sold Nearby account

When this home was listed before, every price change, and what it sold for last time.

Create a free account

Compare

How it compares

Sold comparables

Free Sold Nearby account

The recent sales nearby most like this home, and what each one sold for.

Create a free account

Neighbourhood

Around North Dumfries

What’s nearby

On a busier streetBackyard faces west

  • Elementary schoolSt. Brigid Catholic Elementary Schoolabout 16 min walk
  • ParkDouglas Parkabout 12 min walk
  • Playground about 13 min walk
  • Trail about 6 min walk
  • River or lakeNith Riverabout 3 min walk
  • Grocery storeFoodlandabout 26 min walk
  • DowntownAyrabout 22 min walk
  • LibraryRegion Of Waterloo Library - Ayr Branchabout 24 min walk
  • Rec centre or arenaAyr Curling Clubabout 17 min walk
  • Golf course about 2.6 km
  • HospitalWestgate Dental Careabout 13.7 km
  • Highway on-rampExit 268about 5.2 km
  • GO or train stationKitchenerabout 19.3 km

Approximate: straight-line distances, and the backyard and street worked out from the map pin and map data © OpenStreetMap contributors. Check school boundaries with the school board.

On the map

Sold nearby

Free Sold Nearby account

Homes within 3 km that sold in the last year, what they sold for and how fast.

Create a free account

Community

The North Dumfries market

North Dumfries sale prices

Free Sold Nearby account

The median sale price in North Dumfries month by month, how fast homes sell, and how close they come to asking.

Create a free account

Costs

What it would cost

%
%
An example rate. Use the one your lender quotes.
Every monthEstimate
Mortgage payment$0
Property tax$0
Monthly total$0
At closing
Ontario land transfer tax$0

Estimates only, not financial advice. Uses Canadian semi-annual compounding, the minimum down payment and mortgage insurance rules, and Ontario’s land transfer tax brackets. Your lender and lawyer confirm the real numbers. Legal fees, title insurance and moving costs aren’t included.

Listing courtesy of RE/MAX TWIN CITY REALTY INC.. Listing information from the PropTx MLS® System. Each listing shows the brokerage that represents it. 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. Information is deemed reliable but is not guaranteed accurate by PropTx. Last updated October 25, 2026 at 10:40 p.m.

See this home with Kris.

No obligation. Kris replies personally. Privacy policy

Your request goes to Kris Butler, Salesperson, M1 Real Estate Brokerage Ltd. He isn’t the listing agent for this home.

Selling nearby?

Get a valuation built from sales like this one, and see what you’d save with a 1% listing fee.

See what you’d save →
What’s my home worth?