Forgot password Extend Verify Contact

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

$2,150,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®# 40722090
Photo 1: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 2: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 3: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 4: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 5: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 6: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 7: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 8: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 9: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 10: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 11: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 12: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 13: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 14: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 15: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 16: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 17: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 18: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 19: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 20: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 21: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 22: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 23: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 24: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 25: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 26: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 27: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 28: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 29: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 30: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 31: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 32: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 33: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 34: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 35: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 36: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Photo 37: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
Status:
Active
Prop. Type:
Residential
MLS® Num:
40722090
Bedrooms:
4
Bathrooms:
4
Year Built:
1985
Situated on a 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, newly paved circular driveway, and charming landscaped centrepiece. This home has it all, offering 4 bedrooms, 4 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. As you enter inside, you’ll be greeted by a breathtaking foyer illuminated by cascades of natural light and crowned by a beautiful, elegant chandelier. 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, pot lights through-out and gleaming hardwood floors, offering an airy yet elegant atmosphere. Step upstairs, with three large bedrooms and two full bathrooms. The expansive primary suite impresses with two walk-in closets, custom in built shelving, 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:
2
Fireplace Details:
Gas, Wood Burning Stove
Fireplace Stove Operational:
No
Laundry Features:
Laundry Room, Main Level
Water Supply:
Drilled Well
Water Treatment:
Iron/Mineral Filter, Sediment Filter, Water Purification, Water Softener
Spa:
Heated, Hot Tub
Winterized:
Fully Winterized
Sewer:
Septic Tank
Cooling:
Central Air
Heating:
Forced Air, Natural Gas
Dishwasher,Dryer,Microwave,Pool Equipment,Range Hood,Refrigerator,Stove,Washer,Window Coverings,Mini Fridge, Custom Bedroom Frame & Mattress, All Light Fixtures, Exterior Cameras, Smart Thermostat
Bar Fridge, Water Heater, Water Softener, Dishwasher, Dryer, Microwave, Range Hood, Refrigerator, Stove, Washer
High Speed Internet, Auto Garage Door Remote(s), Built-In Appliances, Ceiling Fan(s), Central Vacuum, In-law Capability, Upgraded Insulation, Work Bench
Window Coverings, Skylight(s)
Canopy, Landscaped, Lawn Sprinkler System, Lighting, Privacy
Patio, Porch
false
No
Hwy 6 or Centre Rd to 6th Conc Rd East. East of Centre Rd to John Martin Cres
No
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
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, Near Golf Course, Highway Access, Landscaped, Library, Open Spaces, Park, Place of Worship, Public Parking, Quiet Area, Rec./Community Centre, School Bus Route, Schools, 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, Concrete, Inside Entry
# Of Total Parking Spaces:
17.0
# Of Open Parking Spaces:
15.0
Driveway Parking:
Private Drive Double Wide
Total Units:
Listed Date:
Apr 28, 2025
  • Photo 1: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 1 of 37
  • Photo 2: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 2 of 37
  • Photo 3: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 3 of 37
  • Photo 4: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 4 of 37
  • Photo 5: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 5 of 37
  • Photo 6: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 6 of 37
  • Photo 7: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 7 of 37
  • Photo 8: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 8 of 37
  • Photo 9: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 9 of 37
  • Photo 10: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 10 of 37
  • Photo 11: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 11 of 37
  • Photo 12: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 12 of 37
  • Photo 13: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 13 of 37
  • Photo 14: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 14 of 37
  • Photo 15: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 15 of 37
  • Photo 16: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 16 of 37
  • Photo 17: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 17 of 37
  • Photo 18: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 18 of 37
  • Photo 19: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 19 of 37
  • Photo 20: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 20 of 37
  • Photo 21: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 21 of 37
  • Photo 22: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 22 of 37
  • Photo 23: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 23 of 37
  • Photo 24: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 24 of 37
  • Photo 25: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 25 of 37
  • Photo 26: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 26 of 37
  • Photo 27: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 27 of 37
  • Photo 28: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 28 of 37
  • Photo 29: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 29 of 37
  • Photo 30: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 30 of 37
  • Photo 31: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 31 of 37
  • Photo 32: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 32 of 37
  • Photo 33: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 33 of 37
  • Photo 34: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 34 of 37
  • Photo 35: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 35 of 37
  • Photo 36: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 36 of 37
  • Photo 37: 24 John Martin Crescent in Flamborough: 044 - Flamborough East Single Family Residence for sale (43 - Flamborough)  : MLS®# 40722090
    Photo 37 of 37

Virtual Tour

Virtual Tour 2

Listed by RE/MAX Escarpment Golfi Realty Inc.
Data was last updated July 26, 2025 at 07:50 AM (UTC)
Area Statistics
Listings on market:
38
Avg list price:
$1,764,450
Min list price:
$69,900
Max list price:
$7,499,900
Avg days on market:
53
Min days on market:
2
Max days on market:
466
Avg price per sq.ft.:
$600.89
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.