Office Listings
402 PROGRESTON Road
044 - Flamborough East
Hamilton
L0R 1H1
$2,599,000
Single Family
beds: 2
baths: 4.0
4,465 sq. ft.
built: 1998
- Status:
- Active
- Prop. Type:
- Single Family
- MLS® Num:
- 40763253
- Bedrooms:
- 2
- Bathrooms:
- 4
- Year Built:
- 1998
- Photos (47)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
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. (id:2493)
- Property Type:
- Single Family
- Common Interest:
- Freehold
- Property Attached:
- No
- Total Living Area:
- 4,465 sq. ft.415 m2
- Finished Area Above Grade:
- 3,556 sq. ft.330 m2
- Zoning:
- S1
- Taxes:
- $8,288.65 / -
- Community:
- 044 - Flamborough East
- Exterior Features:
- Stone
- Community Features:
- Quiet Area
- Security Features:
- Alarm system, Security system
- Structure Type:
- House
- Appliances Included:
- Washer, Refrigerator, Water softener, Central Vacuum, Gas stove(s), Dishwasher, Stove, Dryer, Microwave, Window Coverings, Garage door opener, Microwave Built-in
- Home Style:
- 2 Level
- Bedrooms:
- 2
- Bedrooms Above Grade:
- 2
- Bedrooms Below Grade:
- 0
- Bathrooms:
- 4.0
- Half Bathrooms:
- 1
- Cooling:
- Central air conditioning
- Fireplace:
- Yes
- Fireplaces:
- 4
- Fireplace Type:
- Wood, Stove
- Foundation:
- Poured Concrete
- Heating:
- Heat Pump, Natural gas
- # Storeys:
- 2.0
- Water:
- Drilled Well, Dug Well, Well
- Sewer:
- Septic System
- Basement:
- Finished, Full
- Lot Frontage:
- 618'188 m
- Lot Size:
- 3.98 acre(s)1.61 hectare(s)
- Lot Details:
- 3.98
- Lot Features:
- Conservation/green belt, Country residential, Automatic Garage Door Opener
- Parking:
- Detached Garage
- Total Parking Spaces:
- 14
- Floor
- Type
- Size
- Other
- Main level
- Laundry room
- 7'5"2.26 m × 5'5"1.65 m
- -
- Main level
- Pantry
- 9'5"2.87 m × 5'10"1.78 m
- -
- Main level
- Foyer
- 17'7"5.36 m × 11'1"3.38 m
- -
- Main level
- Office
- 11'11"3.63 m × 11'10"3.61 m
- -
- Main level
- Dining room
- 13'6"4.11 m × 11'9"3.58 m
- -
- Main level
- Kitchen
- 13'8"4.17 m × 11'11"3.63 m
- -
- Main level
- Sunroom
- 16'2"4.93 m × 9'8"2.95 m
- -
- Main level
- Family room
- 19'10"6.05 m × 18'9"5.72 m
- -
- Main level
- Living room
- 26'4"8.03 m × 17'5"5.31 m
- -
- Second level
- Bedroom
- 17'5"5.31 m × 14'5"4.39 m
- -
- Second level
- Primary Bedroom
- 34'3"10.40 m × 16'3"4.95 m
- -
- Third level
- Sitting room
- 27'5"8.36 m × 24'7"7.49 m
- -
- Basement
- Storage
- 19'10"6.05 m × 8'7"2.62 m
- -
- Basement
- Storage
- 25'4"7.72 m × 24'7"7.49 m
- -
- Basement
- Sitting room
- 21'3"6.48 m × 18'10"5.74 m
- -
- Basement
- Recreation room
- 25'9"7.85 m × 25'5"7.75 m
- -
- Floor
- Ensuite
- Pieces
- Other
- Main level
- No
- 2
- 5'5" x 7'1"
- Second level
- No
- 3
- 5'6" x 8'10"
- Second level
- No
- 5
- 17'10" x 13'4"
- Third level
- No
- 3
- 6'2" x 9'1"
-
View of front of property featuring driveway and a garage
-
View from above of property
-
View of front facade with covered porch and a yard
-
Back of property featuring board and batten siding
-
Photo 5 of 47
-
View of subject property with a forest
-
View of front facade with a front yard, covered porch, and board and batten siding
-
View of front facade with board and batten siding, asphalt driveway, and an attached garage
-
Entrance foyer featuring wallpapered walls, crown molding, stairs, wood finished floors, and a chandelier
-
Kitchen with recessed lighting, glass insert cabinets, white cabinetry, an island with sink, and dark wood finished floors
-
Kitchen with stainless steel range with gas stovetop, dark wood-style floors, light stone counters, tasteful backsplash, and white cabinets
-
Kitchen with stainless steel microwave, a chandelier, recessed lighting, ornamental molding, and dark wood-style flooring
-
Kitchen with stainless steel gas stove, white cabinetry, healthy amount of natural light, glass insert cabinets, and recessed lighting
-
Dining room with healthy amount of natural light, dark wood-type flooring, a chandelier, and crown molding
-
Sunroom with a wood stove and vaulted ceiling
-
Living area featuring a wood stove
-
Sunroom with lofted ceiling and healthy amount of natural light
-
Sunroom / solarium with healthy amount of natural light
-
Half bathroom featuring vanity and wood finished floors
-
Carpeted living area featuring beamed ceiling, a fireplace, and coffered ceiling
-
Living area with carpet flooring, plenty of natural light, coffered ceiling, beamed ceiling, and recessed lighting
-
Home office featuring wallpapered walls and carpet
-
Foyer with wood finished floors and stairway
-
Photo 24 of 47
-
Bedroom with light colored carpet and vaulted ceiling
-
Office featuring lofted ceiling, carpet floors, and plenty of natural light
-
Carpeted bedroom featuring french doors and baseboards
-
Bathroom featuring wallpapered walls, a bath, a shower stall, double vanity, and tile patterned floors
-
Full bathroom with wallpapered walls, a bath, and tile patterned flooring
-
Bathroom with a stall shower, wallpapered walls, and tile patterned floors
-
Carpeted bedroom featuring lofted ceiling and baseboards
-
Bathroom with wallpapered walls, a stall shower, and vanity
-
Carpeted living area with a drop ceiling, a fireplace, a ceiling fan, and recessed lighting
-
Rec room with carpet, billiards table, a drop ceiling, and recessed lighting
-
Living room featuring stairway, light colored carpet, a drop ceiling, a fireplace, and recessed lighting
-
Carpeted home office/bedroom with a wall unit AC and baseboards
-
Bathroom featuring vanity and toilet
-
View of green lawn featuring view of scattered trees
-
View of yard
-
Back of house with a yard
-
View of patio / terrace
-
Rear view of house with board and batten siding, a yard, a chimney, a porch, and a wooden deck
-
Back of property featuring a porch, board and batten siding, and a yard
-
Back of property featuring a yard, a chimney, and board and batten siding
-
View of subject property
-
View from above of property with a forest
-
Aerial view
Video Tour Website
Larger map options:
Listed by Royal LePage State Realty Inc.
Data was last updated November 13, 2025 at 02:15 PM (UTC)
Area Statistics
- Listings on market:
- 30
- Avg list price:
- $3,075,000
- Min list price:
- $30,000
- Max list price:
- $5,999,900
- Avg days on market:
- 55
- Min days on market:
- 6
- Max days on market:
- 422
- Avg price per sq.ft.:
- $521.65
These statistics are generated based on the current listing's property type
and located in
044 - Flamborough East. Average values are
derived using median calculations. This data is not produced by the MLS® system.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR®
Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These
certification marks identify real estate professionals who are members of CREA and who
must abide by CREA’s By‐Laws, Rules, and the REALTOR® Code. The MLS® trademark and the
MLS® logo are owned by CREA and identify the quality of services provided by real estate
professionals who are members of CREA.
The information contained on this site is based in whole or in part on information that is provided by
members of The Canadian Real Estate Association, who are responsible for its accuracy.
CREA reproduces and distributes this information as a service for its members and assumes
no responsibility for its accuracy.
Website is operated by a brokerage or salesperson who is a member of The Canadian Real Estate Association.
The listing content on this website is protected by copyright and
other laws, and is intended solely for the private, non‐commercial use by individuals. Any
other reproduction, distribution or use of the content, in whole or in part, is specifically
forbidden. The prohibited uses include commercial use, “screen scraping”, “database
scraping”, and any other activity intended to collect, store, reorganize or manipulate data on
the pages produced by or displayed on this website.
My Featured Listings
188 STINSON Street
$549,900
Royal LePage State Realty Inc.
129 DUNDURN Street North
$549,900
Royal LePage State Realty Inc.




