SEARCH LISTINGS

Forgot password Extend Verify Contact

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

$1,995,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®# 40804504
Photo 1: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 2: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 3: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 4: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 5: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 6: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 7: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 8: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 9: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 10: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 11: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 12: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 13: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 14: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 15: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 16: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 17: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 18: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 19: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 20: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 21: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 22: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 23: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 24: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 25: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 26: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 27: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 28: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 29: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 30: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 31: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 32: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 33: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 34: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 35: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 36: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 37: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Photo 38: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
Status:
Active
Prop. Type:
Single Family
MLS® Num:
40804504
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. (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,804 / -
Community:
044 - Flamborough East
Exterior Features:
Brick
Pool Features:
Inground pool
Community Features:
Quiet Area, School Bus, Community Centre
Security Features:
Security system, 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:
1
Foundation:
Block
Heating:
Heat Pump, Forced air, Natural gas
# Storeys:
2.0
Water:
Drilled Well
Sewer:
Septic System
Basement:
Finished, Full
Fence Type:
Fence
Lot Frontage:
72'
Lot Size:
0.99 acre(s)
Lot Details:
0.99
Lot Features:
Paved Driveway, Skylight, Country residential, Gazebo, Sump Pump, Automatic Garage Door Opener, Private Yard
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®# 40804504
    Photo 1 of 38
  • Photo 2: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 2 of 38
  • Photo 3: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 3 of 38
  • Photo 4: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 4 of 38
  • Photo 5: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 5 of 38
  • Photo 6: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 6 of 38
  • Photo 7: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 7 of 38
  • Photo 8: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 8 of 38
  • Photo 9: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 9 of 38
  • Photo 10: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 10 of 38
  • Photo 11: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 11 of 38
  • Photo 12: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 12 of 38
  • Photo 13: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 13 of 38
  • Photo 14: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 14 of 38
  • Photo 15: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 15 of 38
  • Photo 16: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 16 of 38
  • Photo 17: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 17 of 38
  • Photo 18: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 18 of 38
  • Photo 19: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 19 of 38
  • Photo 20: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 20 of 38
  • Photo 21: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 21 of 38
  • Photo 22: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 22 of 38
  • Photo 23: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 23 of 38
  • Photo 24: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 24 of 38
  • Photo 25: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 25 of 38
  • Photo 26: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 26 of 38
  • Photo 27: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 27 of 38
  • Photo 28: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 28 of 38
  • Photo 29: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 29 of 38
  • Photo 30: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 30 of 38
  • Photo 31: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 31 of 38
  • Photo 32: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 32 of 38
  • Photo 33: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 33 of 38
  • Photo 34: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 34 of 38
  • Photo 35: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 35 of 38
  • Photo 36: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 36 of 38
  • Photo 37: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 37 of 38
  • Photo 38: 24 JOHN MARTIN Crescent in Flamborough: Single Family for sale : MLS®# 40804504
    Photo 38 of 38

Video Tour Website

Listed by RE/MAX Escarpment Golfi Realty Inc.
Data was last updated February 11, 2026 at 09:45 PM (UTC)
Area Statistics
Listings on market:
21
Avg list price:
$1,249,900
Min list price:
$315,000
Max list price:
$5,499,000
Avg days on market:
100
Min days on market:
2
Max days on market:
512
Avg price per sq.ft.:
$595.19
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.
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are member’s of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.