464 Piper Street, North Dumfries, Ontario N0B 1E0

Listed for:
$2,699,000
3 beds
3 baths
Listed 5 days ago
House for rent: 464 Piper Street, North Dumfries, Ontario N0B 1E0

View all 50 photos

About

Cross Streets: Gladstone. ** Directions: Hwy 97 to Northumberland St, right on Piper St about 1 mile to 464. 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 (id:27476)

Property Highlights

MLS® Number
X13147520
Type
Single Family
Ownership Type
Freehold
Land Size
311.1 x 611 FT|5 - 9.99 acres
Parking Space Total
18

Building

Building Type
House
Storeys
2.00
Square Footage
3500 - 5000 sqft
Bathrooms Total
3
Bedrooms Above Ground
3
Bedrooms Total
3
Amenities
Fireplace(s)
Exterior Finish
Wood, Stone
Fireplace Present
Yes
Basement Type
Partial (Unfinished)
Basement Features
Building Heating Type
Forced air
Heating Fuel
Natural gas
Building Cooling Type
Central air conditioning

Utilities

Utility Sewer
Septic System

Room Layout

Bathroom
Second level
2.44 m x 2.06 m
Primary Bedroom
Second level
6.91 m x 4.29 m
Bathroom
Second level
1.6 m x 2.87 m
Bedroom 2
Second level
4.29 m x 4.44 m
Bedroom 3
Second level
4.29 m x 3.05 m
Great room
Main level
10.08 m x 7.57 m
Bathroom
Main level
1.96 m x 1.65 m
Kitchen
Main level
7.77 m x 4.93 m
Living room
Main level
4.93 m x 3.33 m
Dining room
Main level
4.14 m x 4.72 m
Mud room
Main level
2.84 m x 4.55 m
Laundry room
Main level
3.02 m x 3 m

Location

Learn more about this property
Listing provided by:
RE/MAX TWIN CITY REALTY INC.
MLS® number:
X13147520
Agent:
Andy Naudi
*Indicates required field
Name is required
Email is required
Please enter a valid phone number (e.g., 416-111-1111).