$2,699,000
Est. payment $11,951/moCalculate yours
464 Piper Street, North Dumfries, ON N0B 1E0
North Dumfries, ON N0B 1E0
- 3 Beds
- 3 Baths
- 3 Garage
- 3,500 Sq Ft
Listing courtesy of RE/MAX TWIN CITY REALTY INC. MLS® X13147520
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 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
Overview
- Property Type
- Detached
- Style
- 2-Storey
- For
- For Sale
- Status
- Extension
- Approximate Age
- 100+
- Size
- 3,500 sqft
Interior
- Bedrooms
- 3
- Bathrooms
- 3
- Kitchens
- 1
- Basement
- Partial Basement, Unfinished
Building & Systems
- Heating
- Forced Air (Gas)
- Cooling
- Central Air
- Exterior
- Board & Batten , Stone
- Foundation
- Stone
- Roof
- Asphalt Shingle, Metal
- Water
- Well
- Sewer
- Septic
Lot & Parking
- Lot Size
- 311.1 x 611 Feet
- Parking
- Detached garage · 18 total
- Zoning
- Z1
Financial
- Property Taxes
- $9,020 (2025)
Location
- Cross Street
- Gladstone
- Direction Faces
- West
Listing
- MLS® Number
- X13147520
- Days on Market
- 151
- Listed On
- 2026-05-20
- Possession
- 120 days +
- Listed By
- RE/MAX TWIN CITY REALTY INC.
Rooms
Features
Interior
- Accessory Apartment
- In-Law Suite
- Water Softener
- Water Treatment
Pool
- Above Ground
- Included
- All appliances, window coverings, riding zero turn mower, great room table and stools
- Rental items
- hot water heater
Mortgage calculator
Estimated mortgage payment
$11,951 per month
- Principal and interest
- $11,951
- Property tax
- $752
- Condo fees
- $0
- Estimated monthly cost
- $12,702
Your mortgage
- Mortgage amount
- $2,159,200
- Mortgage insurance
- Not needed
- Interest over 25 years
- $1,425,976
Cash to close
- Down payment
- $539,800
- Land transfer tax
- $53,950
- First-time buyer refund
- $0
- Sales tax on insurance (8%)
- $0
- Total, before legal fees
- $593,750
With less than 20% down, a 30-year amortization is available to first-time buyers and buyers of newly built homes.
Talk to me about financingEstimates only, not a mortgage offer or financial advice. Uses the Canadian fixed-rate convention (interest compounded twice a year), 2026 mortgage insurance premiums and Ontario land transfer tax. Your lender will confirm your actual rate and payment.
Location
This photo could not be loaded.