Forgot password Extend Verify Contact

24 JOHN MARTIN Crescent
044 - Flamborough East Flamborough L8B 0Z9

$2,150,000
Single Family beds: 4 baths: 4.0 4,510 sq. ft. built: 1985

Main Photo: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 1: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 2: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 3: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 4: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 5: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 6: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 7: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 8: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 9: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 10: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 11: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 12: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 13: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 14: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 15: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 16: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 17: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 18: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 19: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 20: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 21: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 22: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 23: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 24: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 25: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 26: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 27: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 28: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 29: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 30: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 31: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 32: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 33: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 34: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 35: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 36: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 37: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Photo 38: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
Status:
Active
Prop. Type:
Single Family
MLS® Num:
40755557
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. (id:2493)
Property Type:
Single Family
Common Interest:
Freehold
Property Attached:
No
Total Living Area:
4,510 sq. ft.
Finished Area Above Grade:
3,045 sq. ft.
Zoning:
S1
Taxes:
$10,226 / -
Community:
044 - Flamborough East
Exterior Features:
Brick
Pool Features:
Inground pool
Community Features:
Quiet Area, School Bus, Community Centre
Security Features:
Smoke Detectors
Structure Type:
House
Utilities:
Natural Gas
Appliances Included:
Washer, Refrigerator, Water softener, Central Vacuum, Dishwasher, Stove, Dryer, Microwave, Hood Fan, Window Coverings
Home Style:
2 Level
Bedrooms:
4
Bedrooms Above Grade:
3
Bedrooms Below Grade:
1
Bathrooms:
4.0
Half Bathrooms:
1
Cooling:
Central air conditioning
Fireplace:
Yes
Fireplaces:
2
Fireplace Type:
Wood, Stove
Foundation:
Block
Heating:
Forced air, Natural gas
# Storeys:
2.0
Water:
Drilled Well
Sewer:
Septic System
Basement:
Finished, Full
Lot Frontage:
72'
Lot Size:
0.99 acre(s)
Lot Details:
0.99
Lot Features:
Skylight, Country residential, Gazebo, Sump Pump, Automatic Garage Door Opener
Parking:
Attached Garage
Total Parking Spaces:
17
Floor
Type
Size
Other
Main level
Laundry room
14'1" × 5'8"
-
Main level
Kitchen
15'3" × 12'6"
-
Main level
Breakfast
15'2" × 10'3"
-
Main level
Family room
16'8" × 15'2"
-
Main level
Dining room
15'10" × 13'
-
Main level
Living room
15'9" × 12'7"
-
Main level
Foyer
21'10" × 12'4"
-
Second level
Primary Bedroom
21'4" × 12'8"
-
Second level
Bedroom
14'2" × 10'
-
Second level
Bedroom
16'1" × 12'3"
-
Basement
Storage
17'11" × 11'4"
-
Basement
Office
14'2" × 11'7"
-
Basement
Bedroom
14'9" × 11'10"
-
Basement
Utility room
11'7" × 6'7"
-
Basement
Recreation room
37'5" × 20'6"
-
Floor
Ensuite
Pieces
Other
Main level
No
2
4'11" x 9'9"
Second level
No
4
10' x 12'5"
Second level
No
-
13'2" x 10'
Basement
No
3
9'3" x 15'1"
  • Photo 1: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 1 of 38
  • Photo 2: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 2 of 38
  • Photo 3: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 3 of 38
  • Photo 4: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 4 of 38
  • Photo 5: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 5 of 38
  • Photo 6: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 6 of 38
  • Photo 7: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 7 of 38
  • Photo 8: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 8 of 38
  • Photo 9: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 9 of 38
  • Photo 10: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 10 of 38
  • Photo 11: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 11 of 38
  • Photo 12: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 12 of 38
  • Photo 13: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 13 of 38
  • Photo 14: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 14 of 38
  • Photo 15: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 15 of 38
  • Photo 16: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 16 of 38
  • Photo 17: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 17 of 38
  • Photo 18: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 18 of 38
  • Photo 19: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 19 of 38
  • Photo 20: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 20 of 38
  • Photo 21: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 21 of 38
  • Photo 22: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 22 of 38
  • Photo 23: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 23 of 38
  • Photo 24: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 24 of 38
  • Photo 25: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 25 of 38
  • Photo 26: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 26 of 38
  • Photo 27: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 27 of 38
  • Photo 28: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 28 of 38
  • Photo 29: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 29 of 38
  • Photo 30: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 30 of 38
  • Photo 31: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 31 of 38
  • Photo 32: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 32 of 38
  • Photo 33: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 33 of 38
  • Photo 34: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 34 of 38
  • Photo 35: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 35 of 38
  • Photo 36: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 36 of 38
  • Photo 37: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 37 of 38
  • Photo 38: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40755557
    Photo 38 of 38

Video Tour Website

Listed by RE/MAX Escarpment Golfi Realty Inc.
Data was last updated August 19, 2025 at 12:45 PM (UTC)
Area Statistics
Listings on market:
29
Avg list price:
$1,972,900
Min list price:
$69,900
Max list price:
$7,499,900
Avg days on market:
70
Min days on market:
6
Max days on market:
336
Avg price per sq.ft.:
$851.49
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.
powered by myRealPage.com