Skip to content
1 / 68
For saleMLS® X13147520

464 Piper Street, North Dumfries, ON N0B 1E0

$2,699,000

$771 / sq ft

5 months on market

Bedrooms
3
Bathrooms
3
Interior
3,500 sf
Parking
18
Lot
311.1 × 611 ft
Age
100+ years

What's special

  • Detached garage
  • Pool
  • Central air
  • Finished basement
  • Fireplace
  • Accessory apartment
  • In-law suite
  • Water softener

Book a private showing

Pick a time that suits you. No obligation.

Loading open times…

About this property

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.

Rooms

12 rooms. Dimensions as published by the listing brokerage.

Room dimensions and features
RoomLevelDimensionsFeatures
Great RoomMain10.08 × 7.57 m33.1 × 24.8 ft—
KitchenMain7.77 × 4.93 m25.5 × 16.2 ft—
Living RoomMain4.93 × 3.33 m16.2 × 10.9 ft—
Dining RoomMain4.14 × 4.72 m13.6 × 15.5 ft—
Mud RoomMain2.84 × 4.55 m9.3 × 14.9 ft—
LaundryMain3.02 × 3.00 m9.9 × 9.8 ft—
BathroomMain1.96 × 1.65 m6.4 × 5.4 ft2 Pc Bath
Primary BedroomSecond6.91 × 4.29 m22.7 × 14.1 ft—
BathroomSecond1.60 × 2.87 m5.2 × 9.4 ft4 Pc Ensuite
Bedroom 2Second4.29 × 4.44 m14.1 × 14.6 ft—
Bedroom 3Second4.29 × 3.05 m14.1 × 10.0 ft—
BathroomSecond2.44 × 2.06 m8.0 × 6.8 ft—

Features

  • Accessory Apartment
  • In-Law Suite
  • Water Softener
  • Water Treatment

Property details

Property

Property type
detached
Bedrooms
3
Bathrooms
3
Interior size
3,500 sq ft
Year built
100+
Lot size
311.1 × 611 ft
Zoning
Z1
Possession
120 days +

Interior

Basement
Partial Basement, Unfinished
Heating
Forced Air · Gas
Cooling
Central Air
Fireplaces
1
Exposure
West

Exterior & services

Construction
Board & Batten , Stone
Garage
Detached
Parking spaces
18
Pool
Above Ground
Sewer
Septic

Costs

List price
$2,699,000
Property taxes
$9,020 / year (2025)
Price per sq ft
$771
Rental items
hot water heater

Listing

MLS® number
X13147520
Status
For sale
Listed
May 20, 2026
Days on market
169
Last updated
October 1, 2026
Listing brokerage
RE/MAX TWIN CITY REALTY INC.

Price & sale history

This property's sale history is hidden

TRREB rules require a free account before sold and leased prices can be shown. One registration unlocks full sale history across the site.

Unlock sale history & sold price

Free. Takes about twenty seconds.

Before you make an offer

What this home costs beyond the asking price, and how that price compares to what else is on the market.

How this price compares

This home is priced above most comparable listings — about 84% of comparable detached listings in North Dumfries are asking less.

$822KMedian $1000K$2.75M
This home
$771 / sq ft
Comparable median
$597 / sq ft

Based on 19 comparable active detached listings in North Dumfries. These are asking prices, not sale prices.

Mortgage estimate

Down payment20.0% · minimum $539,800
$539,800
Interest rate5-year fixed, illustrative only
4.49%
Amortization
Principal & interest
$11,938.59
Property tax (est.)
$751.67
Estimated monthly
$12,690

Estimate only. Excludes CMHC insurance premiums, which apply below 20% down, and does not constitute a mortgage approval or an offer of credit.

Land transfer tax

Payable on closing, on top of the purchase price.

Ontario
$53,950
Total due on closing
$53,950

An estimate on the asking price of $2,699,000. Rates current as of September 2026; confirm the final figure with your real estate lawyer.

Listing courtesy of RE/MAX TWIN CITY REALTY INC.. Listing data is provided in part by the Toronto Regional Real Estate Board (TRREB) and is deemed reliable but is not guaranteed accurate. Information is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties. Data is updated every 15 minutes.

$2,699,000

Contact Book a viewing

Comparable sales nearby

What similar homes in this area actually sold for.

Nearby sold prices are hidden

Recent closed sales for comparable homes in this area — the numbers that tell you whether the asking price is realistic.

Unlock nearby sold prices

Free. Takes about twenty seconds.

Similar properties nearby