Serving The Community For 19 Years!
Sign In / Register
Contact
Serving The Community For 19 Years!
Sign In / Register
Contact
Ontario > North Dumfries > 464 Piper Street

464 Piper Street, North Dumfries, ON

North Dumfries, Hood
Gladstone
3 Br | 3 Bath | 3500-5000 Sqft
$2,699,000 For Sale

Property Overview

  • Detached — 2-Storey
  • SqFt: | 3500-5000 Sqft
  • Lot Size: 311.10 x 611.00 Feet
  • Age: 100+ Years
  • Basement: Partial Basement, Unfinished
  • Exterior: Board & Batten , Stone
  • Taxes: 9,020 / 2025
  • Zoning: n/a
  • MLS #: X13147520
  • Sewer: Septic
  • Heat Source: Gas , Forced Air

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 completely 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.

All appliances, window coverings, riding zero turn mower, great room table and stools

Property Details

  • For: For Sale
  • Type: Detached
  • Style: 2-Storey
  • Lot: 311.10 x 611.00 Feet
  • Region: Waterloo
  • Hood: North Dumfries
  • Zoning: n/a
  • Lot Irreg: Fronting on: West
  • Fronting On: West

Building Details

  • Age: 100+ Years
  • Exterior: Board & Batten , Stone
  • Heat: Gas , Forced Air
  • A/C: Central Air
  • Interior Features: Accessory Apartment, In-Law Suite, Water Softener, Water Treatment
  • Pool: Above Ground
  • Sewer: Septic
  • Garage: Detached
  • Total Parking: 18.00
  • Driveway: Circular Drive

Property Interior

  • Sqft: 3500-5000 Sqft
  • Bed: 3
  • Bath: 3
  • Kitchen: 1
  • Family Room: No
  • Basement: Partial Basement, Unfinished
Rooms Details

Great Room

Main Level

10.08 x 7.57

Kitchen

Main Level

7.77 x 4.93

Living Room

Main Level

4.93 x 3.33

Dining Room

Main Level

4.14 x 4.72

Mud Room

Main Level

2.84 x 4.55

Laundry

Main Level

3.02 x 3

Primary Bedroom

Second Level

6.91 x 4.29

Bathroom

Second Level

1.6 x 2.87

4 Pc Ensuite

Bedroom 2

Second Level

4.29 x 4.44

Bedroom 3

Second Level

4.29 x 3.05

Bathroom

Second Level

2.44 x 2.06

Bathroom

Main Level

1.96 x 1.65

2 Pc Bath
Property Listed by: RE/MAX TWIN CITY REALTY INC.
Virtual Tour: https://unbranded.youriguide.com/464_piper_st_north_dumfries_on/

Home Valuation Estimate

What is 464 Piper Street, North Dumfries, ON worth in today’s North Dumfries market?

This HomeZira valuation preview helps buyers and sellers think through the asking price for this 3-bedroom Detached with 3500-5000 sq. ft. in North Dumfries. The full estimate reviews the property’s location, home type, bedroom count, size range, age, and nearby comparable market activity after sign-in.

Property-specific estimate See a valuation range built around this listing’s local profile.
Comparable market context Review how similar nearby homes help frame value.
Buyer and seller guidance Use the estimate as a starting point before an offer or pricing decision.
Sign in to view the full valuation estimate.
Log in to view valuation Create free account

Similar Recently Sold Properties

Compare 464 Piper Street, North Dumfries, ON with nearby homes that recently sold in the same market area.

Similar sold property preview
Sold recently

Sold price locked

List price available after sign-in

Similar sold home nearby

Hood, city and sold details available after sign-in
  • Beds
  • Baths
  • SqFt.
Type: Similar property type
DOM: Available after sign-in
Similar sold property preview
Sold recently

Sold price locked

List price available after sign-in

Similar sold home nearby

Hood, city and sold details available after sign-in
  • Beds
  • Baths
  • SqFt.
Type: Similar property type
DOM: Available after sign-in
Similar sold property preview
Sold recently

Sold price locked

List price available after sign-in

Similar sold home nearby

Hood, city and sold details available after sign-in
  • Beds
  • Baths
  • SqFt.
Type: Similar property type
DOM: Available after sign-in

Sign in to view recent similar sold properties

View recently sold comparable homes, including sold prices, list prices, sale dates, and property details.

Log in Register

Location

  • Address: 464 Piper Street
  • Neighborhood: n/a
  • Zip/Postal Code: N0B 1E0
  • Nearby Amenities:
Map preview placeholder for 464 Piper Street, North Dumfries, ON, Canada
Loads interactive map with Street View + zoom.

Mortgage Calculator

Mortgage Amount:$0
Monthly Mortgage (est.):$0
Payment (per period): $0
Estimated Monthly Total*$0
*Monthly total = monthlyized mortgage payment + taxes/12 + condo fee.
Kazi Hossain

Kazi Hossain

Kazi — Serving the Community for 19 Years!
REALTOR®

Similar Properties In North Dumfries, North Dumfries

Similar property near North Dumfries
$1,895,000
Detached - bungalow
For Sale
1279 Maple Manor Road, North Dumfries, ON
Cheese Factory Road
  • 3 Beds
  • 3 Baths
  • 2000-2500 SqFt.
Similar property near North Dumfries
$1,099,900
Detached - 2-storey
For Sale
1462 Beke Road, North Dumfries, ON
West River Rd
  • 5 Beds
  • 2 Baths
  • 2500-3000 SqFt.
Similar property near North Dumfries
$849,900
Detached - bungaloft
For Sale
1 Hughson Street, North Dumfries, ON
Victoria St
  • 3 Beds
  • 1 Baths
  • 1500-2000 SqFt.
Similar property near North Dumfries
$799,900
Detached - 2-storey
For Sale
109 ROBERT SIMONE Way, North Dumfries, ON
Robert Simone way
  • 3 Beds
  • 4 Baths
  • 1500-2000 SqFt.

About 464 Piper Street, North Dumfries, ON N0B 1E0, North Dumfries

Located at 464 Piper Street, North Dumfries, ON in North Dumfries, near Gladstone. This freehold home offers Detached, ["2-Storey"], 3 bedrooms, 3 bathrooms and 3500-5000 sq.ft. (approx.) in a layout suited to everyday family living. Basement: Partial Basement, Unfinished • 18 parking spots • Garage: Detached • Heating: Gas Forced Air • Cooling: Central Air. Property taxes are approximately $9,020 for 2025. 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 completely 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 o.

FAQs for 464 Piper Street, North Dumfries, ON , North Dumfries

What are the listing details for 464 Piper Street, North Dumfries, ON?
464 Piper Street, North Dumfries, ON is a Detached for sale in North Dumfries, Waterloo. The current list price is $2,699,000. MLS number: X13147520.
How many bedrooms and bathrooms does this home have?
464 Piper Street, North Dumfries, ON is listed as a Detached with a ["2-Storey"] style, featuring 3 bedroom(s) and 3 bathroom(s). The listed interior size range is 3500-5000 sq. ft..
What lot, basement, garage, or parking details are listed?
The lot size is listed as approximately 311.10 x 611.00 Feet. The basement is listed as: Partial Basement, Unfinished. Garage type: Detached. Total parking: 18 space(s).
What heating, cooling, and exterior details are shown?
Heating is listed as: Gas, Forced Air. Cooling is listed as: Central Air. Exterior/construction materials are listed as: Board & Batten , Stone.
Where is this property located?
464 Piper Street, North Dumfries, ON is located in North Dumfries. The listed cross street is Gladstone.
What information is available on this public listing page?
The public listing page shows current active listing information, property photos, room details when available, map location, listed price, property features, and contact options. Annual taxes are listed as $9,020 / 2025. Valuation tools and similar sold-property previews are available after sign-in where applicable, without displaying sold data in this public FAQ.

FAQ content is based on current active listing fields shown on this page. Sold prices, sold comparables, and VOW-only details are not included in this public FAQ.