Gurvinder Nokwal REALTOR®
For Sale Detached 151 days on market

$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

Room Level Dimensions
Primary Bedroom Second 22′ 8″ × 14′ 1″
Bathroom Second 5′ 3″ × 9′ 5″
Bathroom Main 6′ 5″ × 5′ 5″
Mud Room Main 9′ 4″ × 14′ 11″
Bedroom 3 Second 14′ 1″ × 10′ 0″
Great Room Main 33′ 1″ × 24′ 10″
Living Room Main 16′ 2″ × 10′ 11″
Laundry Main 9′ 11″ × 9′ 10″
Kitchen Main 25′ 6″ × 16′ 2″
Dining Room Main 13′ 7″ × 15′ 6″
Bathroom Second 8′ 0″ × 6′ 9″
Bedroom 2 Second 14′ 1″ × 14′ 7″

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

Minimum for this price: $539,800 (20%)

Amortization, years

Estimated mortgage payment

$11,951 per month

Principal and interest
$11,951
Property tax
$752
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
Total, before legal fees
$593,750
Talk to me about financing

Estimates 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

464 Piper Street, North Dumfries, ON N0B 1E0 North Dumfries, ON N0B 1E0
Open in Google Maps

Listing data is provided under license and deemed reliable but not guaranteed. MLS®, Multiple Listing Service® and associated logos are trademarks of The Canadian Real Estate Association (CREA).

$2,699,000 464 Piper Street, North Dumfries, ON N0B 1E0
Request a showing