Header
logo

Friday, July 31st, 2026

header

$2,699,000
Available - For Sale
Listing ID: X13147520
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
Price $2,699,000
Taxes: $9,020
Assessment Year: 2025
Occupancy by: Owner
Address: 464 Piper Street , North Dumfries, N0B 1E0, Waterloo
Acreage: 5-9.99
Directions/Cross Streets: Gladstone
Rooms: 13
Bedrooms: 3
Bedrooms +: 0
Washrooms: 3
Family Room: T
Basement: Partial Base
Unfinished
  Level/Floor Room Length(ft) Width(ft) Descriptions
Room 1: Main Great Roo 33.06 24.83
Room 2: Main Kitchen 25.49 16.17
Room 3: Main Living Ro 16.17 10.92
Room 4: Main Dining Ro 13.58 15.48
Room 5: Main Mud Room 9.32 14.92
Room 6: Main Laundry 9.91 9.84
Room 7: Second Primary B 22.66 14.07
Room 8: Second Bathroom 5.25 9.41 4 Pc Ensuite
Room 9: Second Bedroom 2 14.07 14.56
Room 10: Second Bedroom 3 14.07 10.00
Room 11: Second Bathroom 8.00 6.76
Room 12: Main Bathroom 6.43 5.41 2 Pc Bath
No. of Pieces Level
Washroom 1:  4 Second
Washroom 2:  3 Second
Washroom 3:  2 Main
Washroom 4:  0
Washroom 5:  0
Washroom 6:  4 Second
Washroom 7:  3 Second
Washroom 8:  2 Main
Washroom 9:  0
Washroom 10:  0
Washroom 11:  4 Second
Washroom 12:  3 Second
Washroom 13:  2 Main
Washroom 14:  0
Washroom 15:  0
Washroom 16:  4 Second
Washroom 17:  3 Second
Washroom 18:  2 Main
Washroom 19:  0
Washroom 20:  0
Washroom 21:  4 Second
Washroom 22:  3 Second
Washroom 23:  2 Main
Washroom 24:  0
Washroom 25:  0
Washroom 26:  4 Second
Washroom 27:  3 Second
Washroom 28:  2 Main
Washroom 29:  0
Washroom 30:  0
Washroom 31:  4 Second
Washroom 32:  3 Second
Washroom 33:  2 Main
Washroom 34:  0
Washroom 35:  0
Washroom 36:  4 Second
Washroom 37:  3 Second
Washroom 38:  2 Main
Washroom 39:  0
Washroom 40:  0
Property Type: Detached
Style: 2-Storey
Exterior: Board & Batten
Stone
Garage Type: Detached
(Parking/)Drive: Circular D
Drive Parking Spaces: 15
Park #1
Parking Type: Circular D
Park #2
Parking Type: Circular D
Pool: Above Gr
Approximatly Age: 100+
Approximatly Square Footage: 3500-5000
CAC Included: N
Water Included: N
Cabel TV Included: N
Common Elements Included: N
Heat Included: N
Parking Included: N
Condo Tax Included: N
Building Insurance Included: N
Fireplace/Stove: Y
Heat Type: Forced Air
Central Air Conditioning: Central Air
Central Vac: N
Laundry Level: Syste
Ensuite Laundry: F
Sewers: Septic
First Name: *
Last Name: *
Phone: *
Email: *
Showing Date:
Showing Time:
I Am Thinking of Moving
 
First Name: *
Last Name: *
Phone: *
Email: *

Message:

From:

Name:
Email:

To:

Name:
Email:

Comment:

 

Down payment: $  
Interest Rate: %  
Amortization :  Years
Payment Frequency:
Your Payment:
This calculator is for demonstration purposes only. Always consult a professional financial advisor before making personal financial decisions.
Asking Price: $ Heating: $ /Year  
Interest Rate: % Condo Fee: $ /Year
Taxes:   $ /Year Other Debt: $ /Year  
Amortization:     Years GDS: %
    TDS: %
Percent Down:
Down Payment $ $ $ $
First Mortgage $ $ $ $
CMHC/GE $ $ $ $
Total Financing $ $ $ $
Monthly P&I $ $ $ $
Expenses $ $ $ $
Total Payment $ $ $ $
Income Required $ $ $ $

This chart is for demonstration purposes only. Always consult a professional financial advisor before making personal financial decisions.

Although the information displayed is believed to be accurate, no warranties or representations are made of any kind.
RE/MAX TWIN CITY REALTY INC.

464 Piper Street , North Dumfries, N0B 1E0, Waterloo

Evelina Branitsky
Sales Representative
Dir:
647.888.9606
Bus:
416.739.7200
Fax:
416.739.9367

 
 Virtual Tour   Book Showing   Email a Friend 
Jump To:
At a Glance:
Type: Freehold - Detached
Area: Waterloo
Municipality: North Dumfries
Neighbourhood: Dufferin Grove
Style: 2-Storey
Lot Size: x 611.00(Feet)
Approximate Age: 100+
Tax: $9,020
Maintenance Fee: $0
Beds: 3
Baths: 3
Garage: 0
Fireplace: Y
Air Conditioning:
Pool: Above Gr
Locatin Map:
View Larger Map
Payment Calculator:
Price:
Down Payment: %
Rate: %
Amortization:  Years
Frequency
Calculate
Down Payment:
Mortgage Payment:
This calculator is for demonstration purposes only. Always consult a professional financial advisor before making personal financial decisions.
Listing info
Description
General Details
Room & Interior
Exterior
Utilities
Get More Info:
Book Showing
Request More Info
Email Friend
Photos and movies:
View Slide Show
View All Photos
Virtual Tour
Calculator:
Affordability Chart
Mortgage Calculator
More To Do:
Print This Page

Listing added to compare list, click here  to view comparison chart.
Evelina Branitsky Sales Representative pic ebranitsky@rogers.com Sutton Group- Admiral Realty Inc., Brokerage Independently owned and operated. pic 1881 Steeles Avenue West, Toronto, Ontario M3H5Y4 pic Dir: 647.888.9606 | Office: 416.739.7200 | Fax: 416.739.9367 Personal Pic

ebranitsky@rogers.com