19 days on Market

402 Progreston Rd, Hamilton, Ontario L0R 1H1

Detached
2 + 1
4
~3500-5000 sqft
$2,899,000
Get pre-qualifiedPowered by nesto
Buy with Wahi to get
Up to
$14,495Cashback
Detached
2 + 1
4
~3500-5000 sqft

Contact us about this property

Call

Highlights

Property Estimate

Days on market19 days

Estimated valueNot available

Price/Sqft$704/sqft

Monthly cost

Open Calculator

CMA Subject Property

Curious about what homes are selling for in this area?

Get a report on comparable homes with helpful insights and trends.

+45

Properties sold*

$1.3M

Median sold price*

*Based on last 30 days

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 ®NumberX12223530
Community NameFlamborough
Data SourceTRREB
Listing byROYAL LEPAGE STATE REALTY

Features

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

3rd Floor

Bathroom

2.77 x 1.89

Sitting

8.35 x 7.5


Parking

Garage spaces 2

Garage type Detached

Other parking spaces 12

Total parking spaces 14


Property History

Jun 16, 2025
ListedActive
$2,899,000
19 days on market
history photo preview47
Listing by trreb®

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

33 days

Compared to

2024

46 days

2023

26 days

2022

14 days

New Listings

Past 30 days

98 listings

Compared to

2024

154 listings

2023

102 listings

2022

121 listings

Units sold

Past 30 days

45 units

Compared to

2024

45 units

2023

58 units

2022

38 units

Median Sold Price

Past 30 days

$1,200,000

Compared to

2024

$1,340,001

2023

$1,012,500

2022

$1,327,500


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