Skip to content
Basara.

North Dumfries · Ayr · Detached · MLS# 40831635

464 PIPER Street

$2,699,000

3

bed

3

bath

3,568

sqft

1850

built

Detached · $756/sqft

Listed May 20, 2026

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 completely 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. (id:59491)

The full record.

Property typeDetached
Year built1850
Square footage3,568 sqft
Lot size5.41 acres
Bedrooms3
Bathrooms3
HeatingForced air,, ,Natural gas
CoolingCentral air conditioning
ListedMay 20, 2026

How this listing prices against Ayr.

8

Sales

$690,000

Median price

27

Days on market

96.1%

% of list

24

Active listings

N/A

Months supply

Ayr accounted for 6 of North Dumfries' 7 sales over the past 30 days, making it the centre of local market activity, with 21 active listings still on the market. The average price was $820,748 and the median was $691,000, which sits closely in line with the city median but well below the city average that was lifted by an outlier sale elsewhere. Homes took 25.67 days to sell on average and closed at 96.96 percent of list price, suggesting steadier demand here than the broader municipality. Activity was split between 4 freehold sales and 2 condo sales, with freeholds moving faster and condos taking longer to clear.

Read the full North Dumfriesreport →

Estimate the monthly carry.

Down payment
%($539,800)
Mortgage rate
%
Amortization
years

Estimated monthly payment

$12,360

Principal$2,159,200
Total interest$1,548,711
Total paid$3,707,911

Estimate only. Excludes property tax, condo fees, and insurance.

Questions on this property?

Neso Basara

RE/MAX Icon Realty

Waterloo Region

Use the chat button to message me directly.

Or email me at neso@basara.ca

464 PIPER Street, North Dumfries — $2,699,000 | Basara