$2,699,000
Available - For Sale
Listing ID: X13147520
464 Piper Street , North Dumfries, N0B 1E0, Waterloo
| 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 |
| Price | $2,699,000 |
| Taxes: | $9020.00 |
| Assessment Year: | 2025 |
| Occupancy: | Owner |
| Address: | 464 Piper Street , North Dumfries, N0B 1E0, Waterloo |
| Acreage: | 5-9.99 |
| Directions/Cross Streets: | Gladstone |
| Rooms: | 13 |
| Bedrooms: | 3 |
| Bedrooms +: | 0 |
| Family Room: | T |
| Basement: | Partial Base, Unfinished |
| Level/Floor | Room | Length(ft) | Width(ft) | Descriptions | |
| Room 1 | Main | Great Roo | 33.06 | 24.83 | |
| Room 2 | Main | Kitchen | 25.49 | 16.17 | |
| Room 3 | Main | Living Ro | 16.17 | 10.92 | |
| Room 4 | Main | Dining Ro | 13.58 | 15.48 | |
| Room 5 | Main | Mud Room | 9.32 | 14.92 | |
| Room 6 | Main | Laundry | 9.91 | 9.84 | |
| Room 7 | Second | Primary B | 22.66 | 14.07 | |
| Room 8 | Second | Bathroom | 5.25 | 9.41 | 4 Pc Ensuite |
| Room 9 | Second | Bedroom 2 | 14.07 | 14.56 | |
| Room 10 | Second | Bedroom 3 | 14.07 | 10 | |
| Room 11 | Second | Bathroom | 8 | 6.76 | |
| Room 12 | Main | Bathroom | 6.43 | 5.41 | 2 Pc Bath |
| Washroom Type | No. of Pieces | Level |
| Washroom Type 1 | 4 | Second |
| Washroom Type 2 | 3 | Second |
| Washroom Type 3 | 2 | Main |
| Washroom Type 4 | 0 | |
| Washroom Type 5 | 0 | |
| Washroom Type 6 | 4 | Second |
| Washroom Type 7 | 3 | Second |
| Washroom Type 8 | 2 | Main |
| Washroom Type 9 | 0 | |
| Washroom Type 10 | 0 | |
| Washroom Type 11 | 4 | Second |
| Washroom Type 12 | 3 | Second |
| Washroom Type 13 | 2 | Main |
| Washroom Type 14 | 0 | |
| Washroom Type 15 | 0 |
| Total Area: | 0.00 |
| Approximatly Age: | 100+ |
| Property Type: | Detached |
| Style: | 2-Storey |
| Exterior: | Board & Batten , Stone |
| Garage Type: | Detached |
| (Parking/)Drive: | Circular D |
| Drive Parking Spaces: | 15 |
| Park #1 | |
| Parking Type: | Circular D |
| Park #2 | |
| Parking Type: | Circular D |
| Pool: | Above Gr |
| Approximatly Age: | 100+ |
| Approximatly Square Footage: | 3500-5000 |
| CAC Included: | N |
| Water Included: | N |
| Cabel TV Included: | N |
| Common Elements Included: | N |
| Heat Included: | N |
| Parking Included: | N |
| Condo Tax Included: | N |
| Building Insurance Included: | N |
| Fireplace/Stove: | Y |
| Heat Type: | Forced Air |
| Central Air Conditioning: | Central Air |
| Central Vac: | N |
| Laundry Level: | Syste |
| Ensuite Laundry: | F |
| Sewers: | Septic |
$
%
Years
This calculator is for demonstration purposes only. Always consult a professional
financial advisor before making personal financial decisions.
| Although the information displayed is believed to be accurate, no warranties or representations are made of any kind. |
| RE/MAX TWIN CITY REALTY INC. |
|
|
.jpg?src=Custom)
Dir:
416-548-7854
Bus:
416-548-7854
Fax:
416-981-7184
| Virtual Tour | Book Showing | Email a Friend |
Jump To:
At a Glance:
| Type: | Freehold - Detached |
| Area: | Waterloo |
| Municipality: | North Dumfries |
| Neighbourhood: | Dufferin Grove |
| Style: | 2-Storey |
| Approximate Age: | 100+ |
| Tax: | $9,020 |
| Beds: | 3 |
| Baths: | 3 |
| Fireplace: | Y |
| Pool: | Above Gr |
Locatin Map:
Payment Calculator:
- Color Examples
- Red
- Magenta
- Gold
- Green
- Black and Gold
- Dark Navy Blue And Gold
- Cyan
- Black
- Purple
- Brown Cream
- Blue and Black
- Orange and Black
- Default
- Device Examples