3 upcoming open houses
Drop in during an open house, or tour online — no appointment needed.
- Open houseDate TBDTime TBD
- Open houseDate TBDTime TBD
- Open houseDate TBDTime TBD
What this listing tells us
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
Cleaned for readability — original MLS® text was lightly de-abbreviated and decapitalized.
Listing, price, and tax history
Every previous listing of this property, every list-price change, and 5 years of estimated annual property tax — switch tabs to drill in.
| Date | Event | Status | Price | Change | MLS® | View |
|---|---|---|---|---|---|---|
| May 20, 2026 | ListedCurrent | For sale | $2,699,000 | — | X13147520 | This page |
Inside this property
Systems, finishes, room dimensions, and building information — pulled from the full MLS® feed.
Features & systems
Heating, cooling, parking, exterior, lot, possession, and more.
Systems
5- Heating
- Forced Air
- Air conditioning
- Central Air
- Fireplaces
- 1
- Water source
Getting around, schools & the block
Walkability and transit, the nearest schools, an interactive map of the exact spot, and what's nearby.
The money — monthly cost, mortgage & return
Everything financial in one place: what you'd pay each month, a live mortgage calculator at the asking price, and what it could return as a rental.
Cost of ownership
A monthly snapshot at typical assumptions — personalize the mortgage just below.
How this home sits in the North Dumfries market
Live neighbourhood stats, the closed sales you'd negotiate against, and comparable active listings.
The North Dumfries market right now
Average sold price, days on market, and closed-transaction count for North Dumfries — sourced from MLS®.
- Avg sold price—Last 30 days
- Median sold price—Middle of the market
- Days on market—Avg from list to close
- Closed last 30d—MLS® transactions
We'll get you into 464 Piper Street — the seller pays our commission
On every MLS® listing in Canada, the seller's brokerage pays a cooperating commission to whoever brings the buyer. Buyer representation is free to you.
$0 to you. The seller pays our fee.
On every MLS® listing in Canada, the seller's brokerage advertises a cooperating commission for the buyer's agent. A Coldwell Banker Summit Realty agent represents you — you owe us nothing.
Property flags & disclosures
An automated scan of public records and news for anything a buyer should know about this specific address — liens, outstanding work orders, or stigma-related history. We never invent flags.
We scanned public records and news for liens, outstanding work orders, and stigma-related history (e.g. a former grow-op or fire) at 464 Piper Street and found nothing flagged. We re-check automatically as new records publish.
Common questions about this property
Tap a question to expand the answer. Short, direct answers tuned for AI search and voice assistants.
How much is 464 Piper Street listed for?
464 Piper Street is listed at $2,699,000 on the MLS® (listing X13147520). The price refreshes on Summitly within minutes of any MLS® change.
How many bedrooms, bathrooms, and square feet does 464 Piper Street have?
Coldwell Banker Summit Realty is a RECO-licensed Ontario real estate brokerage, independently owned and operated. Mortgage financing is arranged through Mortgage Squad Advisors. Summitly is the technology platform that powers this site. Listing data is sourced from MLS® and is provided for informational purposes only — not guaranteed accurate by the MLS® or its members. The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by the Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The Coldwell Banker® name and logo are trademarks of Coldwell Banker Real Estate LLC.
