Skip to content
416-688-4663
← Back to resultsNorth Dumfries / Home details
For sale · MLS® X13147520

464 Piper Street, North Dumfries, ON N0B 1E0

North Dumfries, ON N0B 1E0

$2,699,000Property tax (2025): $9,020 / year
170 Days on MLS3 Bedrooms3 BathroomsDetached3500-5000 Size311.10 ft × 611 ft Lot dimensions5.41 acres Lot sizeVirtual tour ↗
Quick cost estimateKnown monthly subtotal$13,309.68 / monthLand transfer tax $53,950One-time estimate
PLANNING ESTIMATE

Quick cost estimate

$13,309.68 / month

Known monthly subtotal

Mortgage principal & interest
$12,558.01
Property tax / month
$751.67
Maintenance / month
Period / amount not reported

Assumes 20% down, 5% annual interest and 25-year amortization. Illustrative rate, not a current quote.

Unknown expenses excluded. Mortgage insurance and closing costs are excluded; add insurance and utilities in the assumptions.

Land transfer tax · one time

Transfer tax total
$53,950

Before rebates, surcharges and fees. Not part of the monthly subtotal.

Tax assumptions & breakdown

Toronto municipal land transfer tax does not apply to this listing outside the City of Toronto.

Ontario tax
$53,950
Toronto municipal tax
$0

Current purchase scenario, before rebates, foreign-buyer taxes and fees. Confirm residence classification. Not historical tax paid; excluded from the monthly subtotal.

Ontario rates · Toronto rates (April 2026)

Eligible first-time purchasers may qualify for an Ontario land transfer tax refund of up to $4,000. Toronto buyers may also qualify for a separate municipal rebate of up to $4,475. Eligibility varies and these maximums are not guaranteed savings. See official eligibility links and details.

Adjust cost assumptions ↓ · Closing-cost tools

Want to see it in person?Request a showing →

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.

Home details

Days on market
Not reported
Property type
Detached
MLS® number
X13147520
Source status
Extension
Bedrooms
3
Bathrooms
3
Postal code
N0B 1E0
Kitchens
1
Kitchens above grade
1
Family room / den
Yes
Interior size (reported range)
3500-5000
Lot size
5.41 acres
Lot depth
611 ft
Garage parking spaces
Not reported
Total parking spaces
18
Occupancy
Owner
Possession type
Other
Garage
Detached
Annual property tax
9020
Basement
Partial Basement, Unfinished
Interior features
Accessory Apartment, In-Law Suite, Water Softener, Water Treatment
Exterior features
Deck, Landscaped
Architectural style
2-Storey
Parking features
Circular Drive
Pool features
Above Ground
Fireplace
Yes
Waterfront
No
Garage available
Yes
Heating system
Forced Air
Heating fuel
Gas
Cooling
Central Air
Sewer
Septic
View
Forest, River
Direction facing
West
Construction materials
Board & Batten , Stone
Roof
Asphalt Shingle, Metal
Foundation
Stone
MLS entry age (not confirmed DOM)
170 days

These details come from the listing source. Please confirm measurements and fees before making a decision.

Utilities and services

Sewer
Septic
Heating system
Forced Air
Heating fuel
Gas
Cooling
Central Air

A reported service is not necessarily included in rent or maintenance. Missing information does not mean a service is absent.

Rooms & virtual tours

Room measurements

Room measurement units

Loading source-reported room dimensions…

Converted measurements are approximate. Levels and dimensions are shown only when supplied.

Bedrooms above grade
3
Rooms above grade
13
Den / family room reported
Yes

Reported counts are shown independently. Room dimensions have not been inferred from these counts.

Ask the listing brokerage for floor plans and measured room layouts.

PARTIAL SOURCE RECORD

Listing dates & price record

Asking amount
$2,699,000
  1. Original MLS entry

    Entry into the source MLS system; distinct from days on market.

Coverage varies by listing. Dates are source-reported calendar dates; only the latest reported asking-price change is shown. This is a partial record.

Explore sold records with approved VOW access →

Nearby homes sold near 464 Piper Street, North Dumfries, ON N0B 1E0, North Dumfries

Nearby sale prices are private. Sign in or request access to see homes that sold.

Sign in · Request access

Estimate monthly costs

Adjust the assumptions for your own scenario. Blank expenses are unknown; enter them for a fuller estimate.

Enter assumptions

Planning estimate with Canadian semiannual compounding. Excludes mortgage insurance, closing costs and special assessments. This is not a lender quote or mortgage approval.

Explore affordability & closing-cost tools →

Map and neighbourhood

Region / county
WATERLOO
Municipality
NORTH DUMFRIES
See homes for sale in North Dumfries →
PLAN YOUR ROUTE

Plan a trip from this home

Check a route from this property to work, school or another destination. Google Maps provides the current estimate when opened; traffic and departure time affect results.

Google Maps opens in a new tab and calculates the route. Your destination and this property location are sent to Google only when you submit. EnterHome does not store the destination or calculate a travel time.

Around this property

Schools, transit & everyday places

Published local sources. Distances are approximate straight-line distances, not walking routes.

Nearby publicly funded schools

Within 5 km · approximate straight-line distances, not walking routes or attendance eligibility.

School year 2024-2025 · Preliminary · publisher extract 2026-09-14.

1.1 km

St Brigid Catholic Elementary School ↗

Elementary · JK-8 · English · Catholic

School board: Waterloo CDSB ↗

50 Broom St, Ayr

Reported assessment results · source workbook 2024-2025

Source workbook percentages, not an overall school rating. Confirm assessment periods with the Ministry. Values may be privacy-rounded or suppressed; 0% and 100% do not always mean none or all.

Grade 3 Reading (at provincial standard)
84%
Grade 3 Writing (at provincial standard)
74%
Grade 3 Mathematics (at provincial standard)
65%
Grade 6 Reading (at provincial standard)
100%
Grade 6 Writing (at provincial standard)
100%
Grade 6 Mathematics (at provincial standard)
67%
1.7 km

Ayr Public School ↗

Elementary · JK-6 · English · Public

Waterloo Region DSB

105 Hall St, Ayr

Reported assessment results · source workbook 2024-2025

Source workbook percentages, not an overall school rating. Confirm assessment periods with the Ministry. Values may be privacy-rounded or suppressed; 0% and 100% do not always mean none or all.

Grade 3 Reading (at provincial standard)
62%
Grade 3 Writing (at provincial standard)
58%
Grade 3 Mathematics (at provincial standard)
71%
Grade 6 Reading (at provincial standard)
80%
Grade 6 Writing (at provincial standard)
77%
Grade 6 Mathematics (at provincial standard)
20%
2.3 km

Cedar Creek Public School ↗

Elementary · JK-8 · English · Public

Waterloo Region DSB

55 Hilltop Dr, Ayr

Reported assessment results · source workbook 2024-2025

Source workbook percentages, not an overall school rating. Confirm assessment periods with the Ministry. Values may be privacy-rounded or suppressed; 0% and 100% do not always mean none or all.

Grade 3 Reading (at provincial standard)
71%
Grade 3 Writing (at provincial standard)
61%
Grade 3 Mathematics (at provincial standard)
59%
Grade 6 Reading (at provincial standard)
78%
Grade 6 Writing (at provincial standard)
75%
Grade 6 Mathematics (at provincial standard)
46%

Confirm programs and attendance with the school board. Private schools and verified catchment boundaries are not included. Contains information licensed under the Open Government Licence – Ontario. Ministry source.

Transit near this property

No current nearby stops were returned by the installed TTC, GO Transit and UP Express datasets. Coverage and service dates vary; distances and travel times are not inferred.

Nearby shops & amenities

No nearby places were returned by the current OpenStreetMap snapshot. Coverage is regional and may be incomplete; verify business details before visiting.

Want to see this home?Request a showing →

Similar homes for sale in North Dumfries

Current public IDX listings in the same city and transaction type. These are alternatives to explore, not sold comparables or an appraisal.

Property questions

How do I request a showing?

Choose a date and time preference in the request form. A request is not a confirmed appointment; EnterHome will confirm availability separately.

Are the measurements and features independently verified?

Measurements, lot details and features are displayed as reported by the listing source or a named public dataset. Missing facts are not inferred. Confirm material details with the listing brokerage.

What do nearby school, transit and shop results mean?

They are nearby records from the displayed source datasets. Distances are approximate straight-line distances; school catchment eligibility, ratings, walking routes, hours and live transit service are not inferred.

Can I see sold prices for nearby properties?

Sold and leased comparable records are shown only to approved VOW users where the source permits display. Sign in or request VOW access if prompted.

How should I use the monthly cost estimate?

It is a planning estimate based on the visible assumptions and reported property figures. It is not a lender quote, tax assessment, legal opinion or mortgage approval.

Home and neighbourhood overview

464 Piper Street, North Dumfries, ON N0B 1E0, North Dumfries is listed for sale as a Detached. The listing reports 3 bedrooms, 3 bathrooms, reported interior area of 3500-5000 (units not reported), kitchens reported as 1, parking spaces reported as 18, lot size reported as 5.41 acres. Asking price: $2,699,000. Occupancy is reported as Owner. Review the Home details, room measurements and utility sections below to compare reported specifications; confirm important details with the listing brokerage. MLS® X13147520.

The Ministry’s school dataset lists St Brigid Catholic Elementary School approximately 1.1 km from the property’s mapped location.

Local context

The Ministry’s school dataset lists St Brigid Catholic Elementary School approximately 1.1 km from the property’s mapped location.

Sources & distance notes

Distances are approximate straight-line estimates to mapped points or area centres. School proximity does not establish attendance eligibility.

Explore the area: Waterloo · North Dumfries.

This overview uses facts reported by the listing and named local sources. Please confirm details with the listing brokerage.

Listing brokerage: RE/MAX TWIN CITY REALTY INC.. Displayed by EnterHome Realty. Source: authorized IDX record, MLS® X13147520. Information deemed reliable but not guaranteed.

Request a showing
Property at 464 Piper Street, North Dumfries, ON N0B 1E0