464 Piper St

North Dumfries, ON N0B 1E0
  • $2,699,000

    Price
  • 3

    Bed
  • 3

    Bath
  • 3,500

    SqFt

About the Listing 360900 -

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

Listing Highlights

Status Active
Days on Site 10
Property Type Residential
MLS ® X13147520
Year Built
Total Square Footage 3,500
Lot/Acreage 5.41

Interior Details

  • Bedrooms: 3
  • Bathrooms: 3 Full
  • Appliances:
  • Air Cond: Central Air
  • Heating: Gas
  • Fireplaces: Natural Gas
  • Floor:
  • Above Ground Sq Ft:
  • Below Ground Sq Ft: n/a
  • Basement: Partial Basement,Unfinished
  • Other: Accessory Apartment,In-Law Suite,Water Softener,Water Treatment
  • Water:

Exterior Details

  • Garage Capacity: 3 car
  • Roof: Asphalt Shingle,Metal
  • Others: Deck,Landscaped
  • Sewer: Septic
  • Parking Features: Circular Drive,Detached,Has Garage

Financial Details

  • Tax Amount: $9,020
  • Taxes w/Assessments: N/A
  • Tax/Property ID: 038530057
  • Tax Year: 2025

Payment Calculator

Monthly Payment

  • in Principal and Interest
  • in Taxes
Years
% Down Payment
% Mortgage Rate

Questions About..

464 Piper St North Dumfries, ON N0B 1E0

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

Never Miss A New Property

Get notified any time there's a new home on the market in this neighborhood!

Don't worry! We'll never spam you or sell your details. You can unsubscribe whenever you'd like.

|

home

Are you buying or selling a home?

Buying
Selling
Both
home

When are you planning on buying a new home?

1-3 Mo
3-6 Mo
6+ Mo
home

Are you pre-approved for a mortgage?

Yes
No
Using Cash
home

Would you like to schedule a consultation now?

Yes
No

When would you like us to call?

Thanks! We’ll give you a call as soon as possible.

home

When are you planning on selling your home?

1-3 Mo
3-6 Mo
6+ Mo

Would you like to schedule a consultation or see your home value?

Schedule Consultation
My Home Value

or another way