464 PIPER STREET, North Dumfries
$2,699,000
For sale: Detached
- Property type
- Detached
- Bedrooms / bathrooms
- 3 bedrooms, 3 bathrooms
- Living area
- 5,000 sqft
- MLS®
- MLS® X13147520
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.
Sold data
Detached homes in North Dumfries — recent sold market
Detached homes in North Dumfries took a median of 30 days to sell over the last 365 days, with the quickest quarter selling within 14 days and the slowest quarter taking more than 56, across 67 recorded sales.
That clock counts only the listing each home finally sold on. Measured from the first time these properties came to market, including any earlier listings that were withdrawn and re-entered, the median is 63 days.
The median sale price was $899,900.
Homes sold for about 2.3% below asking on average, so there was room to negotiate.
About 18% of sales closed above the list price.
Around 25% of sellers reduced their price before finding a buyer.
- Median days to sell
- 30
- Median sale price
- $899,900
- Sale-to-list ratio
- 97.7%
- Sold above asking
- 18%
Based on 67 recorded sales in the last 1 year — a small sample, so treat these figures as indicative. Aggregate statistics only; individual sale prices are not shown.
Currently for sale
Homes for sale near 464 PIPER STREET
$2,995,000
Detached433,500–5,000 sqft1285 KIRKWALL ROAD, Rural Flamborough, Hamilton
$2,500,000
Detached332,000–2,500 sqft15 RIVER BLUFF PATH, Rural Guelph/Eramosa East, Guelph/Eramosa
$2,499,000
Detached332,500–3,000 sqft9245 WELLINGTON 124 ROAD, Rural Erin, Erin
$2,699,999
Detached443,000–3,500 sqft13 TIMBERRUN COURT, Rural Flamborough, Hamilton
$2,890,000
Detached433,500–5,000 sqft5008 NINTH LINE, Rural Erin, Erin
$1,880,000
Detached342,500–3,000 sqft12 WENEIL DRIVE, Freelton, Hamilton
$2,299,000
Detached433,000–3,500 sqft4314 CONCESSION 11 ROAD, Rural Puslinch East, Puslinch
$2,289,000
Detached331,500–2,000 sqft5167 FIFTH LINE, Rural Erin, Erin