464 Piper Street photo 1
464 Piper Street photo 2
464 Piper Street photo 3
464 Piper Street photo 4
464 Piper Street photo 5
464 Piper Street photo 6
464 Piper Street photo 7
464 Piper Street photo 8
464 Piper Street photo 9
464 Piper Street photo 10
464 Piper Street photo 11
464 Piper Street photo 12
464 Piper Street photo 13
464 Piper Street photo 14
464 Piper Street photo 15
464 Piper Street photo 16
464 Piper Street photo 17
464 Piper Street photo 18
464 Piper Street photo 19
464 Piper Street photo 20
464 Piper Street photo 21
464 Piper Street photo 22
464 Piper Street photo 23
464 Piper Street photo 24
464 Piper Street photo 25
464 Piper Street photo 26
464 Piper Street photo 27
464 Piper Street photo 28
464 Piper Street photo 29
464 Piper Street photo 30
464 Piper Street photo 31
464 Piper Street photo 32
464 Piper Street photo 33
464 Piper Street photo 34
464 Piper Street photo 35
464 Piper Street photo 36
464 Piper Street photo 37
464 Piper Street photo 38
464 Piper Street photo 39
464 Piper Street photo 40
464 Piper Street photo 41
464 Piper Street photo 42
464 Piper Street photo 43
464 Piper Street photo 44
464 Piper Street photo 45
464 Piper Street photo 46
464 Piper Street photo 47
464 Piper Street photo 48
464 Piper Street photo 49
464 Piper Street photo 50

464 Piper Street

North Dumfries, ON N0B 1E0

ActiveFor Sale
3 Beds
3 Baths
3,500 Sq Ft
5 Lot Sq Ft
Single Family Home
Virtual Tour Available

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. Open House Sat 2-4

Property Details

StatusActive
Property TypeSingle Family Home
Listing TypeFor Sale
Interior Size3,500 sq ft
Lot Size5 sq ft
Bedrooms3
Bathrooms3
Postal CodeN0B 1E0
Last UpdatedAug 8, 2026 · 8:07 p.m.

Sign in for full listing history and the exact list date.

Features & Amenities

  • View
  • Fireplace
  • Air Conditioning
  • Basement

TRREB MLS® Attribution

MLS® X13147520

Listed by RE/MAX TWIN CITY REALTY INC.

The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by CREA and identify real estate professionals who are members of CREA. Listing data provided by the Toronto Regional Real Estate Board (TRREB). The information contained herein is from sources believed to be reliable but is not guaranteed. Information deemed reliable but not guaranteed accurate by TRREB or Team Filipe / RE/MAX.

$2,699,000

asking price

MLS®X13147520
TypeSingle Family Home
CityNorth Dumfries
← Back to Search

Team Filipe · RE/MAX · (647) 210-6070

Mortgage Estimate

Est. Monthly Payment

$13,180

/month · $2,159,200 mortgage

Down Payment20% — $539,800
Interest Rate5.5%

Amortization

Total Interest

$1,794,672

Total Cost

$3,953,872

Estimate only. Based on Canadian semi-annual compounding, 25-yr amortization at 5.5%.

Full Mortgage Calculator →

Listed By

RE/MAX TWIN CITY REALTY INC.