Address
464 Piper Street, North Dumfries, ON
Price
$ 2,699,000
Property Attributes
- ID#X13147520
- TypeSingle Family
- Listing Status New
- CityNorth Dumfries
- NeighbourhoodNorth Dumfries
- Postal CodeN0B 1E0
- Style2-Storey
- Taxes$ 9020
- Price$ 2,699,000
- Bedrooms3
- Full Bathrooms3
- Half Bathrooms0
- Sqr Footage3500-5000
- Lot Size5.41 Acres
Data Source:
Toronto Real Estate Board (TRREB)
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.
| Price History | |
|---|---|
| 5/20/2026 | Listed $2,699,000 |
General Features
| Sewer | Septic |
|---|---|
| Cooling | Central Air |
| Roof | Asphalt Shingle,Metal |
| Architectural Style | 2-Storey |
| Pool Features | Above Ground |
| Construction Materials | Board & Batten,Stone |
| View | Forest,River |
| Heater Type | Forced Air |
| Parking Spaces | 15 |
| Property Subtype | Detached |
| Tax Year | 2025 |
| Lot Depth | 611.0 |
| County | Waterloo |
| New Construction | No |
| Property Type | Residential Freehold |
| Attached Garage | No |
| Facing Direction | West |
| Garage Y/N | Yes |
| Status | New |
| City | North Dumfries |
| Senior Community Y/N | No |
| Lot Size Units | Feet |
| Property Attached Y/N | No |
| Tax Annual Amount | 9020.0 |
| Virtual Tour | https://unbranded.youriguide.com/464_piper_st_north_dumfries_on/ |
| Standard Status | Active |
| Occupancy Type | Owner |
| Tax Assessed Value | 700000 |
| Legal Description | CON 8 PT LOT 38 |
Interior Features
| Interior Amenities | Accessory Apartment,In-Law Suite,Water Softener,Water Treatment |
|---|---|
| Basement | Partial Basement,Unfinished |
| Fireplace Features | Natural Gas |
| Heat Source | Gas |
| Basement (Y/N) | No |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Total Bedrooms | 3 |
| Elevator? | No |
| Total Baths | 3 |
| Bedrooms | 3 |
| Living Area Range | 3500-5000 |
Exterior Features
| Exterior Amenities | Deck,Landscaped |
|---|---|
| Waterfront | None |
| Parking Features | Circular Drive |
| Total Parking | 18.0 |
| Garage Type | Detached |
| Foundation Details | Stone |
| Spa | No |
| Lot Size Source | MPAC |
| Waterfront Y/N | No |
| Covered Spaces | 3.0 |
Amenities
- Views
- New Construction
- Adult 55+
- Lease To Own
- No Strata Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in N0B 1E0
Price
Taxes
Visits
Toronto Real Estate Board (TRREB); All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating