Debolender
  • Home
  • About
    • Relocating
    • Testimonials
  • Real Estate Listings
    • Guelph
    • Kitchener
    • Waterloo
    • Cambridge
  • News and Advice
    • Deb’s Blog
    • Home Buying Advice
    • Home Selling Advice
    • Get Listings Sent To You
    • Get Your Free Home Evaluation
  • Contact
Debolender
  • Home
  • About
    • Relocating
    • Testimonials
  • Real Estate Listings
    • Guelph
    • Kitchener
    • Waterloo
    • Cambridge
  • News and Advice
    • Deb’s Blog
    • Home Buying Advice
    • Home Selling Advice
    • Get Listings Sent To You
    • Get Your Free Home Evaluation
  • Contact

464 Piper Street, Ayr ON N0B 1E0

  • Home
  • Ayr

464 Piper Street, Ayr ON N0B 1E0

464 Piper Street, Ayr ON N0B 1E0

$2,699,000

  • aadbc08010828e091af0edddfbafda69-m1.jpeg
  • aadbc08010828e091af0edddfbafda69-m2.jpeg
  • aadbc08010828e091af0edddfbafda69-m3.jpeg
  • aadbc08010828e091af0edddfbafda69-m4.jpeg
  • aadbc08010828e091af0edddfbafda69-m5.jpeg
  • aadbc08010828e091af0edddfbafda69-m6.jpeg
  • aadbc08010828e091af0edddfbafda69-m7.jpeg
  • aadbc08010828e091af0edddfbafda69-m8.jpeg
  • aadbc08010828e091af0edddfbafda69-m9.jpeg
  • aadbc08010828e091af0edddfbafda69-m10.jpeg
  • aadbc08010828e091af0edddfbafda69-m11.jpeg
  • aadbc08010828e091af0edddfbafda69-m12.jpeg
  • aadbc08010828e091af0edddfbafda69-m13.jpeg
  • aadbc08010828e091af0edddfbafda69-m14.jpeg
  • aadbc08010828e091af0edddfbafda69-m15.jpeg
  • aadbc08010828e091af0edddfbafda69-m16.jpeg
  • aadbc08010828e091af0edddfbafda69-m17.jpeg
  • aadbc08010828e091af0edddfbafda69-m18.jpeg
  • aadbc08010828e091af0edddfbafda69-m19.jpeg
  • aadbc08010828e091af0edddfbafda69-m20.jpeg
  • aadbc08010828e091af0edddfbafda69-m21.jpeg
  • aadbc08010828e091af0edddfbafda69-m22.jpeg
  • aadbc08010828e091af0edddfbafda69-m23.jpeg
  • aadbc08010828e091af0edddfbafda69-m24.jpeg
  • aadbc08010828e091af0edddfbafda69-m25.jpeg
  • aadbc08010828e091af0edddfbafda69-m26.jpeg
  • aadbc08010828e091af0edddfbafda69-m27.jpeg
  • aadbc08010828e091af0edddfbafda69-m28.jpeg
  • aadbc08010828e091af0edddfbafda69-m29.jpeg
  • aadbc08010828e091af0edddfbafda69-m30.jpeg
  • aadbc08010828e091af0edddfbafda69-m31.jpeg
  • aadbc08010828e091af0edddfbafda69-m32.jpeg
  • aadbc08010828e091af0edddfbafda69-m33.jpeg
  • aadbc08010828e091af0edddfbafda69-m34.jpeg
  • aadbc08010828e091af0edddfbafda69-m35.jpeg
  • aadbc08010828e091af0edddfbafda69-m36.jpeg
  • aadbc08010828e091af0edddfbafda69-m37.jpeg
  • aadbc08010828e091af0edddfbafda69-m38.jpeg
  • aadbc08010828e091af0edddfbafda69-m39.jpeg
  • aadbc08010828e091af0edddfbafda69-m40.jpeg
  • aadbc08010828e091af0edddfbafda69-m41.jpeg
  • aadbc08010828e091af0edddfbafda69-m42.jpeg
  • aadbc08010828e091af0edddfbafda69-m43.jpeg
  • aadbc08010828e091af0edddfbafda69-m44.jpeg
  • aadbc08010828e091af0edddfbafda69-m45.jpeg
  • aadbc08010828e091af0edddfbafda69-m46.jpeg
  • aadbc08010828e091af0edddfbafda69-m47.jpeg
  • aadbc08010828e091af0edddfbafda69-m48.jpeg
  • aadbc08010828e091af0edddfbafda69-m49.jpeg
  • aadbc08010828e091af0edddfbafda69-m50.jpeg

Property ID:

 RH-1305665-property

Bedrooms
3
Bathrooms
2.5
Garage
Yes
Year Built
1850
Area
3568 Square Feet

Description

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

Additional Details

  • Property Age: 1850
  • Property Sub Type: Single Family Residence
  • Zoning: Z1
  • Transaction Type: Sale
  • Basement: Partial, Unfinished
  • Heating: Forced Air, Natural Gas
  • Cooling: Outside/Surface/Open
  • Parking Space: 18
  • Fire Places: 1
  • Virtual Tour: https://youriguide.com/464_piper_st_north_dumfries_on/

Similar Properties

View Property

1083 Trudeau Drive, Milton ON L9T 0A3

Welcome to 1083 Trudeau Drive, Milton – a beautifully maintained…

Bedrooms
3
Bathrooms
2.5
Area
1849 Square Feet

$1,079,000

View Property

9630 Wellington Rd 42, Erin ON L7G 4S8

Now on Standard Broadband fibre optics! Note 6 separate walkouts.…

Bedrooms
8
Bathrooms
3.5
Area
6518 Square Feet

$2,888,000

Debolender

Menu

  • Home
  • About
  • Buying Tips
  • Selling Tips
  • Testimonials
  • Contact

Contact Info

238 Speedvale Ave W, Guelph, ON N1L 1C9

+1 519 993 5656

deb@deboraholender.com

Find your new Home

  • All Listings
  • Guelph Listing
  • Kitchener Listing
  • Waterloo Listing
  • Cambridge Listing

Copyright © 2026, Deb Olender RE/MAX Guelph Real Estate Centre

|
93 Tremaine Drive, Kitchener ON N2A 4M3 3918 Maddaugh Road, Puslinch ON N0B 2J0

Owning a home is a keystone of wealth… both financial affluence and emotional security.

Suze Orman
May 31, 2026 Sunday!
Debolender
  • Login
Forget Password?