464 Piper Street

North Dumfries, ONDetached
$2,699,000
MLS® X13147520
Detached3 beds3 baths18 total
Book a Showing Manage Saved Searches
464 Piper Street, North Dumfries, ON photo 1
464 Piper Street, North Dumfries, ON photo 2
464 Piper Street, North Dumfries, ON photo 3
464 Piper Street, North Dumfries, ON photo 4
464 Piper Street, North Dumfries, ON photo 5
464 Piper Street, North Dumfries, ON photo 6
464 Piper Street, North Dumfries, ON photo 7
464 Piper Street, North Dumfries, ON photo 8
464 Piper Street, North Dumfries, ON photo 9
464 Piper Street, North Dumfries, ON photo 10
464 Piper Street, North Dumfries, ON photo 11
464 Piper Street, North Dumfries, ON photo 12
464 Piper Street, North Dumfries, ON photo 13
464 Piper Street, North Dumfries, ON photo 14
464 Piper Street, North Dumfries, ON photo 15
464 Piper Street, North Dumfries, ON photo 16
464 Piper Street, North Dumfries, ON photo 17
464 Piper Street, North Dumfries, ON photo 18
464 Piper Street, North Dumfries, ON photo 19
464 Piper Street, North Dumfries, ON photo 20
464 Piper Street, North Dumfries, ON photo 21
464 Piper Street, North Dumfries, ON photo 22
464 Piper Street, North Dumfries, ON photo 23
464 Piper Street, North Dumfries, ON photo 24
464 Piper Street, North Dumfries, ON photo 25
464 Piper Street, North Dumfries, ON photo 26
464 Piper Street, North Dumfries, ON photo 27
464 Piper Street, North Dumfries, ON photo 28
464 Piper Street, North Dumfries, ON photo 29
464 Piper Street, North Dumfries, ON photo 30
464 Piper Street, North Dumfries, ON photo 31
464 Piper Street, North Dumfries, ON photo 32
464 Piper Street, North Dumfries, ON photo 33
464 Piper Street, North Dumfries, ON photo 34
464 Piper Street, North Dumfries, ON photo 35
464 Piper Street, North Dumfries, ON photo 36
464 Piper Street, North Dumfries, ON photo 37
464 Piper Street, North Dumfries, ON photo 38
464 Piper Street, North Dumfries, ON photo 39
464 Piper Street, North Dumfries, ON photo 40
464 Piper Street, North Dumfries, ON photo 41
464 Piper Street, North Dumfries, ON photo 42
464 Piper Street, North Dumfries, ON photo 43
464 Piper Street, North Dumfries, ON photo 44
464 Piper Street, North Dumfries, ON photo 45
464 Piper Street, North Dumfries, ON photo 46
464 Piper Street, North Dumfries, ON photo 47
464 Piper Street, North Dumfries, ON photo 48
464 Piper Street, North Dumfries, ON photo 49
464 Piper Street, North Dumfries, ON photo 50
1 / 50

BUYER ADVANTAGE

Buy with confidence

Get a full-service approach built on strategy, strong negotiation, and clear guidance from offer to close.

  • Local Market Expertise
  • Broker-level Negotiation
  • Transparent Process
  • No-pressure Guidance
View the guide

The right strategy depends on your goals, timing, budget, and the type of home you are buying. Get Your Buyer Snapshot.

About This Property

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. (id:63604)

Key Facts

Type
Detached
Beds
3
Baths
3
Size
3,500 sqft
Lot
311.1 x 611 FT
Parking
18 total

Highlights

  • All
  • Water softener
  • Water Treatment
  • Window Coverings
Property Details 19 details
Bedrooms
3 bedrooms
3 above grade
Bathrooms
3 bathrooms
1 partial
Parking
18 parking spaces
Detached Garage · Garage
Living area
3,500 - 5,000 sq. ft.
Property
Single Family · Freehold · Detached
Property subtype
Single Family
Structure type
House
Ownership
Freehold
Attached status
Detached
Storeys
2
Basement
Unfinished, Partial
Heating
Forced air, Natural gas
Cooling
Central air conditioning
Fireplace
1 fireplace
Pool
Above ground pool
Lot dimensions
311.1 x 611 FT
Frontage
311.10 feet
Taxes
$9,020.00 (2,025)
Zoning
Z1
Sewer
Septic System
Views
River view

Interior features

AllWater softenerWater TreatmentWindow CoveringsFireplace(s)

Exterior features

WoodStone

Lot and water

In-Law Suite
Rooms 12 rooms
Level
Room
Dimensions
Main level
Great room
10.08 m x 7.57 m
Second level
Bathroom
2.44 m x 2.06 m
Main level
Bathroom
1.96 m x 1.65 m
Main level
Kitchen
7.77 m x 4.93 m
Main level
Living room
4.93 m x 3.33 m
Main level
Dining room
4.14 m x 4.72 m
Main level
Mud room
2.84 m x 4.55 m
Main level
Laundry room
3.02 m x 3 m
Second level
Primary Bedroom
6.91 m x 4.29 m
Second level
Bathroom
1.6 m x 2.87 m
Second level
Bedroom 2
4.29 m x 4.44 m
Second level
Bedroom 3
4.29 m x 3.05 m

Virtual Tour & Media

Brochure
Mortgage & Affordability Estimate monthly costs
Mortgage Tools Buyer/Seller Snapshot
Purchase price$2,699,000
Down paymentNot available
Mortgage amountNot available
Principal & interestNot available
Property taxesNot available
Condo/HOA feeNot available
Insurance/OtherNot available
UtilitiesNot available
Est. monthly totalNot available
Income needed (GDS 32%)Not available
Estimates only. Not financial advice. Rates, taxes and fees vary by lender and municipality.

Saved Properties

Keep This One Handy

Save this listing, compare it later, or open your saved properties dashboard.

Manage Saved Searches
Map is approximate.

Neighbourhood

City
North Dumfries
Postal code
N0B 1E0
Nearby
Cross Streets: Gladstone. ** Directions: Hwy 97 to Northumberland St, right on Piper St about 1 mile to 464.
Request Showing

Other Available Options

Similar Listings

Listings from our database that match closely.

Browse more listings

Want to see more homes like this?

See all similar listings