Forgot password Extend Verify Contact

24 John Martin Crescent
044 - Flamborough East Flamborough L8B 0Z9

$1,995,000
Residential beds: 4 baths: 4.0 4,510 sq. ft. built: 1985

Main Photo: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 1: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 2: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 3: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 4: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 5: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 6: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 7: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 8: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 9: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 10: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 11: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 12: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 13: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 14: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 15: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 16: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 17: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 18: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 19: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 20: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 21: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 22: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 23: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 24: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 25: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 26: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 27: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 28: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 29: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 30: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 31: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 32: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 33: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 34: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 35: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 36: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 37: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Photo 38: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
Open House - Nov 16, 2025
02:00 PM - 04:00 PM EST
NOTES: Open House on Sunday, November 16, 2025 2:00PM - 4:00PM
Status:
Active
Prop. Type:
Residential
MLS® Num:
40771606
Bedrooms:
4
Bathrooms:
4
Year Built:
1985
Situated on a quiet, beautifully manicured 0.99-acre lot in one of the most exclusive enclaves in the area, this impressive two-storey brick estate immediately captures attention with its elegant curb appeal, circular driveway, and landscaped centrepiece. This home has it all, offering four bedrooms, four bathrooms and over 4000 square feet of living space. No rear neighbours, an inground pool, hot tub, workshop & gazebo with a natural gas fireplace outside. The backyard is flat, unobstructed and surrounded by trees. Plenty of useable space for entertaining, family games/events and a huge ice rink. Breathtaking foyer illuminated by cascades of natural light and a stunning centre staircase. Exquisite Brazilian hardwood flooring flows seamlessly through the formal dining and entertainment spaces, where a natural gas fireplace adds a warm, ambiance ideal for both grand entertaining and intimate gatherings. The custom kitchen is a masterpiece of craftsmanship, featuring cherry maple oak soft-close cabinetry, under-cabinet lighting, heated floors, granite countertops, skylights, and a toe-kick central vacuum for effortless living. The step-down living room features large windows overlooking the private back yard, pot lights through-out and gleaming hardwood floors. The expansive primary suite impresses with two walk-in closets, custom built-in wall-to wall cabinetry, and an elegant ensuite featuring dual vanities and a walk-in shower. The fully finished basement features a spacious recreation room, a bathroom, a private office, an oversized storage room, and a separate walk-up staircase leading directly to the garage. Nestled in a prime location just five minutes from Waterdown, this location offers unrivaled access to excellent schools, parks, trails, golf courses, and fitness centers, a rare setting where every lifestyle amenity is within easy reach, yet the surroundings remain serene and exclusive.
Property Type:
Residential
Property SubType:
Single Family Residence
Year built:
1985 (Age: 40)
Listing General Location:
044 - Flamborough East, 43 - Flamborough
Bedrooms:
4
Bathrooms:
4.0 (Full:3/Half:1)
Lot Size:
0.99 acre(s)
Lot Details:
72.15 x
Lot Frontage:
72'2"
Frontage Type:
East
Kitchens:
1
Home Style:
Two Story
Elementary School:
Flamborough Centre Es, Guardian Angels Catholic Es
High School:
Waterdown Dhs, St Mary Catholic Ss
County Or Parish:
Hamilton
Taxes:
Property Attached:
Detached
Features:
Attached Garage: Yes, Crops Included: No, Garage: No, Common Elements Fee: No, New Construction: No
Construction:
Brick
Basement:
Separate Entrance, Full, Finished, Sump Pump
Foundation:
Concrete Block
Roof:
Asphalt Shing
Year Roof Replaced:
2020
Number of Buildings:
0
Other Structures:
Gazebo, Workshop
Total Floor Area:
4,510 sq. ft.
# Main Level Bathrooms:
1
Finished Area Above Grade:
3,045 sq. ft.
Finished Area Below Grade:
1,465 sq. ft.
Fireplace:
true
Fireplaces:
1
Fireplace Details:
Gas
Fireplace Stove Operational:
Yes
Laundry Features:
Laundry Room, Main Level
Water Supply:
Drilled Well
Water Treatment:
Iron/Mineral Filter, Sediment Filter, UV System, Water Purification, Water Softener
Pool:
In Ground, Salt Water
Spa:
Heated, Hot Tub
Winterized:
Fully Winterized
Sewer:
Septic Tank
Cooling:
Central Air
Heating:
Forced Air, Natural Gas, Heat Pump
Dishwasher,Dryer,Microwave,Pool Equipment,Range Hood,Refrigerator,Stove,Washer,Window Coverings,Mini Fridge, Custom Built-In Bed Frame & Mattress, Smart Thermostat, Exterior Cameras, Woodstove In Basement (As Is, Where Is)
Bar Fridge, Water Heater, Water Softener, Dishwasher, Dryer, Microwave, Range Hood, Refrigerator, Stove, Washer
Dolphin Pool Cleaner
High Speed Internet, Auto Garage Door Remote(s), Built-In Appliances, Ceiling Fan(s), Central Vacuum, In-law Capability, Upgraded Insulation, Water Treatment, Work Bench
Window Coverings, Skylight(s)
Canopy, Landscaped, Lawn Sprinkler System, Lighting, Privacy
Clear, Pool
Patio, Porch
false
No
Hwy 6 or Centre Rd to 6th Conc Rd East. East of Centre Rd to John Martin Cres
No
Carbon Monoxide Detector(s), Security System, Smoke Detector(s)
Floor
Type
Size
Other
Main Floor
Main Floor
Main Floor
Main Floor
Main Floor
Main Floor
Main Floor
2nd Floor
2nd Floor
2nd Floor
2nd Floor
Basement
Basement
Basement
Basement
Basement
Floor
Ensuite
Pieces
Other
Main Floor
2nd Floor
Basement
HST Applicable To Sale Price:
Included
Association Fee:
Association Fee Frequency:
Association Fee 2:
Association Fee 2 Frequency:
Administrative Fee:
Features:
Attached Garage: Yes, Crops Included: No, Garage: No, Common Elements Fee: No, New Construction: No
Road Access Fee:
Condo Corporation:
No
Lease to Own Equipment:
None
Zoning:
S1
Other Equipment:
Pool Equipment
Total Acres:
0.99
Utilities:
Cell Service, Electricity Available, Natural Gas Connected, Recycling Pickup, Street Lights
Exposure / Faces:
West
Lot Site Features:
Rural, Irregular Lot, Ample Parking, Dog Park, Near Golf Course, Highway Access, Landscaped, Library, Major Highway, Open Spaces, Park, Place of Worship, Playground Nearby, Public Parking, Quiet Area, Rec./Community Centre, School Bus Route, Schools, Shopping Nearby, Trails
Features:
Attached Garage: Yes, Crops Included: No, Garage: No, Common Elements Fee: No, New Construction: No
Garage Spaces:
2.0
Parking Places Covered:
2.0
Parking:
Attached Garage, Asphalt, Inside Entry
# Of Total Parking Spaces:
17.0
# Of Open Parking Spaces:
15.0
Driveway Parking:
Private Drive Double Wide
Road Frontage Type:
Municipal Road
Total Units:
Listed Date:
Sep 19, 2025
  • Photo 1: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 1 of 38
  • Photo 2: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 2 of 38
  • Photo 3: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 3 of 38
  • Photo 4: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 4 of 38
  • Photo 5: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 5 of 38
  • Photo 6: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 6 of 38
  • Photo 7: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 7 of 38
  • Photo 8: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 8 of 38
  • Photo 9: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 9 of 38
  • Photo 10: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 10 of 38
  • Photo 11: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 11 of 38
  • Photo 12: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 12 of 38
  • Photo 13: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 13 of 38
  • Photo 14: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 14 of 38
  • Photo 15: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 15 of 38
  • Photo 16: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 16 of 38
  • Photo 17: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 17 of 38
  • Photo 18: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 18 of 38
  • Photo 19: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 19 of 38
  • Photo 20: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 20 of 38
  • Photo 21: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 21 of 38
  • Photo 22: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 22 of 38
  • Photo 23: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 23 of 38
  • Photo 24: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 24 of 38
  • Photo 25: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 25 of 38
  • Photo 26: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 26 of 38
  • Photo 27: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 27 of 38
  • Photo 28: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 28 of 38
  • Photo 29: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 29 of 38
  • Photo 30: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 30 of 38
  • Photo 31: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 31 of 38
  • Photo 32: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 32 of 38
  • Photo 33: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 33 of 38
  • Photo 34: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 34 of 38
  • Photo 35: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 35 of 38
  • Photo 36: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 36 of 38
  • Photo 37: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 37 of 38
  • Photo 38: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40771606
    Photo 38 of 38

Virtual Tour

Virtual Tour 2

Listed by RE/MAX Escarpment Golfi Realty Inc.
Data was last updated November 8, 2025 at 01:50 PM (UTC)
Area Statistics
Listings on market:
33
Avg list price:
$1,888,000
Min list price:
$30,000
Max list price:
$5,999,900
Avg days on market:
50
Min days on market:
1
Max days on market:
571
Avg price per sq.ft.:
$604.17
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.