$2,699,000
28.97 BTC
Photos
Map
464 Piper Street, North Dumfries
$2,699,000
PRICE
3
BEDROOMS
3
BATHROOMS
X13147520
MLSID

464 Piper Street, North Dumfries

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
Read Full Description
View Property
Ask a Question

Summary

Address
464 Piper Street
MLSID
X13147520
Property Type
Detached
Property Category
Bedrooms
3
Bathrooms
3
Kitchens
1
Zoning
Z1
Taxes (Annual)
$9,020.00
Tax Year
2025
Published
May 20, 2026
Days on Market
11 Days
Possession Type
Other
Possession Details
120 Days +
View Property
Ask a Question

Inclusions

All appliances, window coverings, riding zero turn mower, great room table and stools

Details

Bathroom 1
4-Piece Second Level
Bathroom 2
3-Piece Second Level
Bathroom 3
2-Piece Main Level
Basement
Partial Basement, Unfinished
Exterior Features
Deck, Landscaped
Interior Features
Accessory Apartment, In-Law Suite, Water Softener, Water Treatment
Parking Spaces
15
Parking Total
18
Parking Features
Circular Drive
Architectural Style
2-Storey
Roof
Asphalt Shingle, Metal
Construction Materials
Board & Batten , Stone
Lot Size
5 Acres
Lot Width
311 Feet
Lot Depth
611 Feet
Water
Well
Heat Source
Gas
Heat Type
Forced Air
New Construction
No
Occupant Type
Owner
Private Entrance
No
Sauna
No
Seasonal Property
No
Hot Tub / Spa
No
View Property
Ask a Question

Similar Listings

Listing Contracted with RE/MAX TWIN CITY REALTY INC.
View Property
Ask a Question
View Property
Ask a Question
Appointment Date & Time
Date
Time
Send
Cancel
Thank you for your Inquiry!
Your message has been received, one of our represetatives will be in touch with you shortly.
Close