6 days on Market

402 Progreston Rd, Hamilton, Ontario L0R 1H1

Detached
3
4
~3500-5000 sqft
$2,349,000
Get pre-qualifiedPowered by nesto
Detached
3
4
~3500-5000 sqft

Contact us about this property

Call

Highlights

Property Estimate

Days on market6 days

Estimated valueNot available

Price/Sqft$570/sqft

Monthly cost

Open Calculator

Description

Welcome to your private country retreat on nearly 4 acres in the heart of Carlisle. From the moment you arrive, this property leaves a lasting impression with its winding driveway, lush natural surroundings, and timeless centre-hall design. Nestled on a quiet hill and surrounded by mature trees, this custom-built home offers an exceptional blend of craftsmanship, quality, and classic charm. The inviting front and covered side porches provide peaceful spaces to relax and take in the views. Inside, the home showcases maple hardwood flooring and a bright, open-concept layout designed for modern living. The kitchen is equipped with high-end stainless steel appliances, quartz countertops, and a large central island that flows seamlessly into the dining and living areas, perfect for both entertaining and everyday comfort. Just off the kitchen, a sunroom offers a serene spot to enjoy morning coffee while overlooking the greenery. The family room exudes warmth with its inviting fireplace and direct walkout to the backyard. Upstairs, the primary suite is a true retreat. Designed with spa-like comfort in mind, this space features a spacious layout, walk-in closets, and a luxurious en-suite bathroom complete with a glass shower, soaker tub, double vanity, and heated floors. The fully finished basement offers generous additional living space and ample storage, making it perfectly suited for a variety of needs. A standout feature of this property is the workshop, ideal for storage, projects, or equipment. Another highlight is the spacious, fully finished apartment above the double garage with a separate entrance, offering incredible potential for guests, in-laws, or rental income. This is a rare opportunity to own a truly versatile property in one of Carlisle's most picturesque locations. With premium finishes, thoughtful design, and expansive indoor and outdoor living spaces, this home delivers a lifestyle that's increasingly hard to come by.


Property Details

Style2-Storey
ViewForest, Trees/Woods
Age of property31-50
SqFt~3500-5000 SqFt
Lot Size-
Parking Spaces14
MLS ®NumberX12840868
Community NameFlamborough
Data SourceTRREB
Listing byROYAL LEPAGE STATE REALTY

Features

Heating: Forced Air
Central Vacuum
Cooling: Central Air
Fireplace
Basement: Full, Finished

Main Floor

Living

5.31 x 8.03

Family

6.05 x 5.72

Sunroom

4.93 x 2.94

Kitchen

3.63 x 4.15


Parking

Garage spaces 2

Garage type Detached

Other parking spaces 12

Total parking spaces 14


Property listed by ROYAL LEPAGE STATE REALTY, Brokerage
Agent Banner Image
Interested in this property?Get in touch to get the inside scoop.

Market Data - Flamborough

Geo Zone Map ThumbnailFlamborough

Strong Buyer's Market

View Market Data

Detached house - for the past 30 days

Buyer's market Seller's market

Avg. Days on Market

Past 30 days

38 days

Compared to

2025

48 days

2024

43 days

2023

32 days

New Listings

Past 30 days

59 listings

Compared to

2025

70 listings

2024

87 listings

2023

58 listings

Units sold

Past 30 days

19 units

Compared to

2025

25 units

2024

31 units

2023

33 units

Median Sold Price

Past 30 days

$965,000

Compared to

2025

$1,210,000

2024

$1,200,000

2023

$1,212,000


Population and Demographics

Overview

Total population 46428
Average household income $164,302

Age (%)

0 to 19
24%
20 to 34
17%
35 to 49
20%
50 to 64
23%
65 and plus
17%

Household composition (%)

Single family
80%
Single person
17%
Multi person
2%
Multi family
1%

Mother tongue (%)

English
89%
Others
9%

House tenancy (%)

Owners
88%
Renters
12%

What’s nearby?Essentials within 5 km

Local Logic

Transportation Scores

Estimated Budget