3 days on Market

464 Piper St, North Dumfries, Ontario N0B 1E0

Detached
3
3
~3500-5000 sqft
$2,699,000
Get pre-qualifiedPowered by nesto
Detached
3
3
~3500-5000 sqft

Contact us about this property

Call

Highlights

Property Estimate

Days on market3 days

Estimated valueNot available

Price/Sqft$655/sqft

Monthly cost

Open Calculator

Description

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.


Property Details

Style2-Storey
ViewForest, River
Age of property100+
SqFt~3500-5000 SqFt
Lot Size190,082 SqFt(611 x 311.1)
Parking Spaces18
MLS ®NumberX13147520
Community NameNorth Dumfries
Data SourceTRREB
Listing byRE/MAX TWIN CITY REALTY INC.

Features

Heating: Forced Air
Cooling: Central Air
Fireplace
Basement: Part Bsmt, Unfinished

Main Floor

Great Rm

10.08 x 7.57

Kitchen

7.77 x 4.93

Living

4.93 x 3.33

Dining

4.14 x 4.72


Features

Lot size: 190,082 SqFt
Pool: Abv Grnd

Parking

Garage spaces 3

Garage type Detached

Other parking spaces 15

Total parking spaces 18


Property History

May 20, 2026
ListedActive
$2,699,000
3 days on market
history photo preview50
Listing by trreb®
Property listed by RE/MAX TWIN CITY REALTY INC., Brokerage
Agent Banner Image
Interested in this property?Get in touch to get the inside scoop.

Market Data - North Dumfries

Geo Zone Map ThumbnailNorth Dumfries

Balanced Market

View Market Data

Detached house - for the past 30 days

Buyer's market Seller's market

Avg. Days on Market

Past 30 days

29 days

Compared to

2025

12 days

2024

15 days

2023

28 days

New Listings

Past 30 days

17 listings

Compared to

2025

38 listings

2024

29 listings

2023

20 listings

Units sold

Past 30 days

7 units

Compared to

2025

8 units

2024

16 units

2023

13 units

Median Sold Price

Past 30 days

$1,075,000

Compared to

2025

$849,000

2024

$940,000

2023

$906,817


Population and Demographics

Overview

Total population 17095
Average household income $152,911

Age (%)

0 to 19
26%
20 to 34
16%
35 to 49
21%
50 to 64
21%
65 and plus
16%

Household composition (%)

Single family
81%
Single person
16%
Multi person
2%
Multi family
1%

Mother tongue (%)

English
87%
Others
7%
Portuguese
3%
Punjabi (Panjabi)
1%

House tenancy (%)

Owners
85%
Renters
15%

What’s nearby?Essentials within 5 km

Local Logic

Transportation Scores

Estimated Budget