Skip to main content
Sell Your Home
Shortlisted Properties
  • New Homes
  • For Sale
  • For Rent
Danger! Indicates a dangerous or potentially negative action.
Error

Maximum 4 project can be compared at one go.

Last Updated : 30 Days ago
464 Piper Street, North Dumfries, ON,
Photo Gallery
+ 50 Photos

464 Piper Street, North Dumfries MLS Number: X13147520

North Dumfries, Waterloo, ON, N0B 1E0

$2,699,000

Status: For Sale

  • 3+ Beds
  • 3 Baths
  • Area : 3500-5000 sqft
  • Property Type: Residential Freehold (Detached)
  • Property Taxes : $9020.0 (Tax Year:2025)
  • Listing Courtesy : Re/max Twin City Realty Inc.

464 Piper Street Property 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

Read More

464 Piper Street Property Facts

Property Type :Residential Freehold
MLS Number :X13147520
Listing Type :Sale
Property Age :100+ Years
Possession Date :
know more link icon
Last Updated :07 Jul, 2026 (30 Days ago)
Source :Toronto Regional Real Estate Board
Area :Waterloo
Postal Code : N0B 1E0

464 Piper Street Property Price & Tax Insights

Price : $2,699,000
Property Taxes :$9020.0
Tax Year :2025

464 Piper Street, North Dumfries Property Details

Bedrooms :3 +
No. of Rooms :13
Air Conditioning :Central Air
Heating :Forced Air
Cross Street :Gladstone
Bathrooms :3
Fuel :Gas
Approx Square Footage :3500-5000 sqft
Fireplace/Stove :No
Virtual Tour
Dimensions 12
Primary Bedroom :6.91 m x 4.29 m
Bathroom :1.96 m x 1.65 m
Bedroom 3 :4.29 m x 3.05 m
Living Room :4.93 m x 3.33 m
Kitchen :7.77 m x 4.93 m
Bathroom :2.44 m x 2.06 m
Bathroom :1.6 m x 2.87 m
Mud Room :2.84 m x 4.55 m
Great Room :10.08 m x 7.57 m
Laundry :3.02 m x 3.0 m
Dining Room :4.14 m x 4.72 m
Bedroom 2 :4.29 m x 4.44 m

Exterior Information

Exterior Finish :Board & Batten , Stone
Parking Space :18
Basement :Partial Basement
Garage :Detached
Laundry Level :Main Level

464 Piper Street, North Dumfries - Price History

2026-05

20 May, 2026

TREB #X13147520

Listed

$2699000.0

  • 0
  • 400k
  • 800k
  • 1.2M
  • 1.6M
  • 2M+
  • 0
  • 6
  • 12
  • 18
  • 24
  • 30+
  • 0
  • 6
  • 12
  • 18
  • 24
  • 30+

464 Piper Street - Location Map and Landmarks

Last Updated : 13 Days ago
177 Piper Street, Waterloo, ON
$1099900.0
  • 3 Bd
  • 3 Ba
  • 1500-2000 sq-ft
Distance : 350 metre
Last Updated : 34 Days ago
25 Bute Street, Waterloo, ON
$699000.0
  • 3 +1 Bd
  • 3 Ba
  • 1500-2000 sq-ft
Distance : 1259 metre
Recently Viewed

Buildings in North Dumfries

338 Albert St

338 Albert St

Waterloo
  • 0 For Sale
  • 1 For Rent
View Building Details
50 Grand Ave S

50 Grand Ave S

Waterloo
  • 0 For Sale
  • 2 For Rent
View Building Details
318 Spruce St

318 Spruce St

Waterloo
  • 4 For Sale
  • 0 For Rent
View Building Details
60 Frederick St

60 Frederick St

Waterloo
  • 5 For Sale
  • 1 For Rent
View Building Details
308 Lester St

308 Lester St

Waterloo
  • 4 For Sale
  • 0 For Rent
View Building Details
62 Balsam St

62 Balsam St

Waterloo
  • 4 For Sale
  • 0 For Rent
View Building Details
128 King St N

128 King St N

Waterloo
  • 0 For Sale
  • 2 For Rent
View Building Details
8 Hickory St W

8 Hickory St W

Waterloo
  • 0 For Sale
  • 1 For Rent
View Building Details
258A Sunview St

258A Sunview St

Waterloo
  • 1 For Sale
  • 0 For Rent
View Building Details
255 Keats Way

255 Keats Way

Waterloo
  • 1 For Sale
  • 0 For Rent
View Building Details
330 Phillip St

330 Phillip St

Waterloo
  • 2 For Sale
  • 0 For Rent
View Building Details
280 Lester St

280 Lester St

Waterloo
  • 3 For Sale
  • 1 For Rent
View Building Details
525 New Dundee Rd

525 New Dundee Rd

Waterloo
  • 2 For Sale
  • 0 For Rent
View Building Details
5 Wellington St S

5 Wellington St S

Waterloo
  • 0 For Sale
  • 5 For Rent
View Building Details
417 Keats Way

417 Keats Way

Waterloo
  • 1 For Sale
  • 0 For Rent
View Building Details

FAQs: 464 Piper Street, North Dumfries

  • Q:What is the Area Size of the 464 Piper Street In Sq.Ft and it's MLS No.?

    A: The project covers an area of approximately 3500-5000 sq. ft and is strategically located in Waterloo. The MLS No of this project is X13147520 and the Project is located in ON, Canada
  • Q: Does this Project 464 Piper Street available for Sale ?

    A: The project 464 Piper Street is readily available for Sale and can be purchased at competitive prices today. You can schedule a tour or request a call back for knowing further.
  • Q: How far is this property from my workplace?

    A:You can calculate your travel time and see how this property is far from your Office, your spouse's workplace or your kid's school. You just need to tell us which places you commute to frequently and Square Yards will tell you how far they are from this property.
  • Q:What are the Key Features 464 Piper Street is Offering?

    A:Square Yards is giving a Cashback of $13,495 if you buy this property from us, however there are several key features offered by the 464 Piper Street. You get 3+ Beds with 3 Bath, central air conditioning, parking space and garage along with a heating system, basement, gas fuel system and balcony.
  • Q:How many Parking Space available in this 464 Piper Street?

    A: 464 Piper Street in Waterloo offers a total of 18 parking spaces for residents.
  • Q:How many Beds & Baths available in 464 Piper Street, Waterloo?

    A: 464 Piper Street, Waterloo comes with 3+ Beds for maximum convenience and space. There are 3 baths available as well for when you have guests over or if you have a large family!
  • Q:How many Apartments and Condos are available for Sale in Waterloo, On?

    A:Waterloo, ON is one of the biggest real estate markets in Canada. There are several options available here pertaining to condos and apartments alike. There are approximately apartments and condos available currently for your perusal.
Related to your search

Tell us a Little about yourself!