Full and half bathrooms as the listing totals them.
Interior area
3,500 to 5,000 sqft
A band, not a measurement. Interior area as the listing states it. It does not say whether the figure was measured on site or taken from builder plans.
Property type
Detached
Style as listed: 2-Storey.
Second dwelling
The listing does not say whether there is a second dwelling unit here. Other records in this set state it either way, so this is a silence rather than a no.
Counts and measurements as the listing states them, not verified by us. MLSSource: MLS
$2.7MFor Sale
464 Piper Street, North Dumfries, ON · 3 bed · 3 bath · 4,250 sqft
Three parties produce a dollar figure for this house, for three different purposes, so they do not agree and were never meant to. The gaps are worked out here rather than left for you to hold in your head.
Asking price
$2,699,000
Set by the seller and their brokerage. It is a request, and nothing tests it until an offer arrives.
MLSSource: MLS
Our estimate
Not licensedOur estimate: Not shown: our current listing agreement does not licence this figure for display.
Modelled from comparable sales by the explorer further down this page. Change the comparables there and this number moves, which is the reason it is shown at all.
Est.Modelled from comparable sales, not an appraisal
Assessed value, 2025
Nothing of this kind on the record, and nothing here fills it in from an average of other houses.
The figure property tax is apportioned from, valued as of a date that is not today. It is not a market value and no lender treats it as one.
MLSMunicipal assessment and tax roll
Price per square foot
$635
asking price over 4,250 sqft, an area the listing does not source
Days on market
N/A
no area average shown: our current listing agreement does not licence market statistics
None of these is an appraisal. Your lender orders one of those once an offer is accepted, and it is the figure that decides how much they will actually lend.
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
Written by the listing brokerage to sell the house. Nothing in it is verified, so take its claims about condition to an inspection, not from it.
Nest 360 estimate
Our estimate for this listing is not shown here
Not shown: our current listing agreement does not licence this figure for display.
The estimate is built by weighing recent comparable sales, and sold comparables for a specific property are licensed to registered users only. It is withheld rather than approximated: an estimate with the sales taken out of it would be a number with nothing behind it.
Price and listing history
This listing's price and status history is not shown here
Not shown: our current listing agreement does not licence this figure for display.
Prior asking prices, terminations and relists are licensed to registered users only, and there are no accounts on Nest 360 yet. Nothing here should be read as evidence that the current price is the only price this house has been offered at.
Property details
MLSSource: MLS
Type
Detached
Style
2-Storey
Bedrooms
3
Bathrooms
3
Kitchens
1
Living area
3,500 to 5,000 sqft
Lot size
311 by 611 ft
Year built
100+
Status
For Sale
Occupancy
Owner occupied
Features
MLSSource: MLS
The pills are copied from the listing and sorted for reading, with nothing added to them, and a group the listing did not fill in is absent rather than empty. Where a group is written as sentences instead, those are ours: what the listing named, and what it means.
Outside
Deck
Landscaped
Above Ground pool
Also listed
On the record, and not one of the groups above.
Accessory Apartment
In-Law Suite
Water Softener
Water Treatment
Interior and systems
MLSSource: MLS
Heating
Forced Air · Gas
Cooling
Central Air
Basement
Partial Basement, Unfinished
Construction
Board & Batten , Stone
Roof
Asphalt Shingle
Foundation
Stone
Sewer
Septic
Parking and exterior
MLSSource: MLS
Garage spaces
3
Driveway spaces
15
Total parking
18
Pool
Above Ground
Exterior features
Deck, Landscaped
Taxes and assessment
MLSMunicipal assessment and tax roll
Assessment year
2025
Annual property tax
$9,020
Tax year
2025
Property tax by year
MLSSource: MLS
1 years · latest $9,020
1 years, from $9,020 in 2025 to $9,020 in 2025.
Location and neighbourhood
MLSSource: MLS
Market trend
Neighbourhood market statistics is not shown here
Not shown: our current listing agreement does not licence this figure for display.
Medians, sale-to-list ratios and absorption are computed from sold prices, and they are licensed to registered users only. There is no approximate version of a median that would be honest to show in their place.
