464 Piper Street
Ayr
N0B 1E0
$2,699,000
Residential
beds: 3
baths: 3.0
3,568 sq. ft.
built: 1850
- Status:
- Active
- Prop. Type:
- Residential
- MLS® Num:
- 40831635
- Bedrooms:
- 3
- Bathrooms:
- 3
- Year Built:
- 1850
- Photos (50)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
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
- Property Type:
- Residential
- Property SubType:
- Single Family Residence
- Year built:
- 1850 (Age: 176)
- Listing General Location:
- 60 - Ayr, 16 - N. Dumfries Twp. (W. of 24 - Rural W.)
- Bedrooms:
- 3
- Bathrooms:
- 3.0 (Full:2/Half:1)
- Lot Size:
- 5.41 acre(s)
- Lot Details:
- 311.1 x
- Lot Frontage:
- 311'1¼"
- Frontage Type:
- West
- Kitchens:
- 1
- Home Style:
- Two Story
- County Or Parish:
- Waterloo
- Property Attached:
- Detached
- Features:
- Attached Garage: No, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
- Construction:
- Board & Batten Siding, Stone
- Basement:
- Partial, Unfinished
- Linked Foundation:
- No
- Foundation:
- Stone
- Roof:
- Asphalt Shing, Metal
- Year Roof Replaced:
- 2015
- Number of Buildings:
- 1
- Other Structures:
- Gazebo, Shed(s), Storage, Workshop
- Total Floor Area:
- 3,568 sq. ft.
- # Main Level Bathrooms:
- 1
- Finished Area Above Grade:
- 3,568 sq. ft.
- Fireplace:
- true
- Fireplaces:
- 1
- Laundry Features:
- Main Level
- Water Supply:
- Drilled Well
- Water Treatment:
- Iron/Mineral Filter, Water Softener, Water System
- Sewer:
- Septic Tank
- Cooling:
- Central Air
- Heating:
- Forced Air, Natural Gas
- Dishwasher,Dryer,Garage Door Opener,Range Hood,Refrigerator,Stove,Washer,Window Coverings
- Bar Fridge, Water Softener, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer
- High Speed Internet, Auto Garage Door Remote(s), Bed & Breakfast, In-Law Floorplan
- Window Coverings
- Awning(s), Balcony, Landscape Lighting, Landscaped
- Deck, Porch
- false
- River/Stream
- No
- Hwy 97 to Northumberland St, right on Piper St about 1 mile to 464
- No
- HST Applicable To Sale Price:
- No
- Features:
- Attached Garage: No, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
- Condo Corporation:
- No
- Zoning:
- Z1
- Total Acres:
- 5.41
- Topography:
- Flat
- Utilities:
- Fibre Optics, Natural Gas Connected
- Lot Site Features:
- Rural, Corner Lot, Highway Access
- Features:
- Attached Garage: No, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
- Garage Spaces:
- 3.0
- Parking Places Covered:
- 3.0
- Parking:
- Detached Garage, Garage Door Opener, Asphalt, EV Charging
- # Of Total Parking Spaces:
- 18.0
- # Of Open Parking Spaces:
- 15.0
- Driveway Parking:
- Outside/Surface/Open
- Listed Date:
- May 20, 2026
-
Stone facade home featuring multiple gabled roofs, natural stone pathways, mature trees, and a covered patio area -
Stone facade residence featuring a multi-pitched shingle roof
-
Stone exterior residence featuring a steeply pitched roof with asphalt shingles
-
Stone and dark-paneled exterior with a prominent covered patio area
-
Expansive aerial showcasing a significant land parcel with two distinct structures, mature trees, and a paved road frontage
-
Vaulted ceiling living space featuring light wood-finish flooring, a stone fireplace with a dark surround, and multiple French doors
-
Vaulted white ceilings with exposed beams, two skylights, and light wood-finish flooring
-
Spacious living area featuring a vaulted ceiling with exposed beams, skylights, and light wood-finish flooring
-
Exposed stone wall with vaulted ceilings, featuring skylights and light wood-finish flooring
-
Kitchen featuring a rustic wood island with dark hardware, wood-finish flooring, white upper cabinetry, and sage green lower cabinetry
-
Kitchen featuring a rustic wood island with storage, stainless steel appliances, light wood-finish flooring, two-tone cabinetry, and pendant lighting
-
Open-concept kitchen featuring a rustic wood-finish island, light wood-finish flooring, white cabinetry, and built-in appliances
-
Kitchen featuring wood-finish flooring, two-tone cabinetry, a wood-paneled range hood, and a dark wood-finish island with shelving and drawers
-
White cabinetry with dark hardware and wood-finish countertops
-
Light wood-finish flooring complements the neutral wall tones
-
Dining area featuring light wood-finish flooring and a rectangular black chandelier
-
Attic bedroom featuring an angled ceiling, a horizontal wood plank accent wall, and a large window with white sheer curtains
-
Sloped ceiling bedroom featuring shiplap wall accents, a black metal bed frame, and wood-finish side tables
-
Contemporary bathroom featuring a walk-in shower with a black-framed glass enclosure, white marble-look wall tiling, and a matte black rainfall showerhead with a handheld attachment
-
Bedroom featuring a large window with white blinds and striped curtains, a light-toned wood bifold closet, and a white wardrobe
-
Spacious room featuring vaulted ceilings, a prominent arched window, and light-colored flooring
-
Bathroom featuring a dark wood-finish vanity with an integrated white sink, a modern circular black-framed mirror, horizontal white plank wall paneling, a clawfoot bathtub, and patterned floor tiling
-
Photo 23 of 50
-
Detached outbuilding featuring a red metal roof, board and batten siding, three wood-finish garage doors, and an arched window dormer
-
Living area featuring wood-finish flooring, a stone-clad fireplace, recessed lighting, and a ceiling fan
-
Built-in white shelving unit with open display storage and lower cabinetry
-
Kitchen featuring a breakfast bar with stone-finish countertops, stainless steel sink with gooseneck faucet, light-toned upper cabinetry, built-in microwave, and wood-finish flooring
-
Open-concept kitchen featuring light green cabinetry with black hardware, stainless steel appliances, and a tiled backsplash
-
Sliding glass doors opening to an outdoor patio with wood-finish flooring throughout
-
Bathroom featuring a tiled shower with pebble flooring, a window, and a rain showerhead
-
Vaulted ceilings featuring a wooden chandelier and track lighting
-
Expansive attic space featuring a large arch-top window, wood-finish flooring, a ceiling fan, and sloped ceilings
-
Attic room featuring vaulted ceilings, wood-finish flooring, a ceiling fan with integrated lighting, and white sliding glass doors
-
Room featuring an angled ceiling, dark wood-finish flooring, and a white shiplap-style accent wall
-
Gray exterior structure with a red roof, featuring multiple windows with window boxes
-
Spacious utility building featuring a wood-burning stove, high ceilings, multiple windows, a roll-up door, and durable speckled flooring
-
Spacious interior featuring wood paneling, a wood-finish ceiling, and a speckled epoxy floor
-
Expansive multi-level wood-finish deck with a built-in circular pool
-
Expansive rear yard featuring a large wood deck, built-in swimming pool, and stone-ringed fire pit
-
Outdoor living area featuring a wood pergola with a dark gray metal roof, stamped concrete patio, mature landscaping, and dark gray horizontal siding
-
Expansive outdoor area featuring a shingled gazebo, a wooden arbor, stone and concrete pathways, and mature trees
-
Stone water feature with a waterfall and surrounding river rock landscaping
-
Expansive property featuring multiple structures with red roofs, a winding paved driveway, and mature trees
-
Wooded path featuring mature trees and lush undergrowth
-
Gated property entrance with dual driveways leading to a dark-clad residence featuring a red roof and a prominent front-facing gable window
-
Expansive aerial perspective showcasing a verdant landscape with a winding river and a paved road
-
Aerial perspective showcasing a verdant landscape with extensive tree cover
-
Expansive gravel and stone pathway with mature trees and a wooden deck structure
-
Image quality insufficient for description
-
Photo 50 of 50
Listed by RE/MAX Twin City Realty Inc.
Data was last updated June 24, 2026 at 03:50 AM (UTC)
Area Statistics
- Listings on market:
- 22
- Avg list price:
- $704,943
- Min list price:
- $70,000
- Max list price:
- $2,699,000
- Avg days on market:
- 41
- Min days on market:
- 1
- Max days on market:
- 222
- Avg price per sq.ft.:
- $377.96
These statistics are generated based on the current listing's property type
and located in
60 - Ayr. Average values are
derived using median calculations. This data is not produced by
the MLS® system.
- SONIA SHARIF
- RE/MAX TWIN CITY REALTY INC
- 226-972-9444
- sonia@sharifsisters.ca
