For Sale: 464 Piper Street, North Dumfries, ON - REW
Boost your listing
Listing featured. Your listing will be featured on REW.
View featured placement
$2,699,000
3 bd • 3 ba • 3568 sf • House
464 Piper Street
Virtual TourStreet ViewDirections
$2,699,000
Get pre-approved

464 Piper StreetNorth Dumfries, ON, N0B 1E0

  • 3 Bed
  • 3 Bath
  • 3568 Sqft
  • House

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. OPEN HOUSE SAT 2-4
Listed by: Andy Naudi, RE/MAX TWIN CITY REALTY INC.

Home facts and features

Price details
List Price
$2,699,000
Get Pre-Approved
Gross Taxes for 2026
$9,020
Home facts
Bedrooms
3
Full Bathrooms
2
Partial Bathrooms
1
Parking Spaces
18
Parking Details
Garage Door Opener, Detached Garage, Asphalt, Ev Charging
Property Type
House
Lot Size
311 ft x 0 ft (0 ft²)
Depth
0.0
Frontage
311.1
Year Built
Built in 1850 (176 yrs old)
Style
Two Story
Heating Type
Forced Air,Natural Gas
Cooling
Central Air
Basement Details
Partial,Unfinished
Features
Auto Garage Door Remote(s), Awning(s), Balcony, Bed & Breakfast, High Speed Internet, In-law Floorplan, Landscape Lighting, Landscaped, Main Level, River/stream
Appliances
Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer, Window Coverings
Agent details
Primary Agent
Primary Broker
RE/MAX TWIN CITY REALTY INC.
Listing details
Days on REW
19 Days
MLS® Number
40831635
Source
Information Technology Systems Ontario
Board
Cornerstone Association of REALTORS®
Is this your listing? Help it to stand out.

Mortgage Calculator

Estimated Payments
Purchase Price
Mortgage Total
Down Payment
Amortization
25 Years
Interest Rate
3.99%

Connect with our mortgage partner

REW Money

REW Money

REW Money

Connect with a mortgage expert

Connect to a mortgage specialist

REW Money
REW Money

They will connect with you to understand where you are in your journey and how they can best guide you.

  • %
Name*
Email*
Phone*
Purchase City*
What best describes your current situation?
Loan Details
Amortization
Years
Mortgage Amount
Down Payment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

Property Insights

St Brigid Catholic Elementary School
  • Catholic
  • JK - 8
Ayr Public School
  • Public
  • JK - 6
Cedar Creek Public School
  • Public
  • JK - 8
School catchments and distances are intended to be used as reference only. To verify enrolment eligibility for a property, contact the school directly.Report Incorrect Info
Report Incorrect Info
Full Name*
Email*
Select School
Reason

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.
Thank You!
We really appreciate your help improving our home search experience. Our team will look into this issue as soon as possible.
Close

Cities near North Dumfries

Neighborhoods near North Dumfries

Listing data is subject to copyright, disclaimer, and additional requirements from the data provider. See our Terms of Use for terms applicable to this listing. Listing data was last updated on 2026-06-07.
Call Agent
Andy Naudi
Phone:
(226) 789-7193
Cell:
226-789-7193
Office:
519-579-4110
Share this Property
Text Message
Share this Property
Recipient Email Address*
Your Name
Your Email Address*

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.