Skip to main content
24 JOHN MARTIN Crescent

24 JOHN MARTIN Crescent

Flamborough, Ontario

4 bed • 4 bath • Single Family

$1,895,000

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.

Price History

Property

Lot Size
0.99 acres

Schools

Elementary

  • Flamborough Centre School0.4 km

    Public · Hamilton-Wentworth DSB · 370 students

    Grade 6 math: 44% met the provincial standard

  • Guardian Angels Catholic Elementary School2.1 km

    Catholic · Hamilton-Wentworth CDSB · 455 students

    Grade 3 reading: 94% met the provincial standard · Grade 6 math: 65% met the provincial standard

  • Allan A Greenleaf3.2 km

    Public · Hamilton-Wentworth DSB · 700 students

    Grade 3 reading: 85% met the provincial standard · Grade 6 math: 69% met the provincial standard

Secondary

  • Waterdown District High School3.2 km

    Public · Hamilton-Wentworth DSB · 1140 students

    Grade 10 literacy: 90% met the provincial standard

Straight-line distance. Nearby schools are not necessarily the assigned schools — confirm catchment with the school board. Scores are EQAO provincial test results for 2024-2025.

Community

Postal area L8B

Population
25,778
Private dwellings
9,053
Median age
38.4
Average household size
2.9
Median household income
$131,000

Source: Statistics Canada, 2021 Census of Population, catalogue 98-401-X2021013. Adapted from Statistics Canada. This does not constitute an endorsement by Statistics Canada of this product.

Local market

Single Family in Flamborough · last 12 months

Median sold price
$0
Homes sold
0
Median days on market
0
Sale-to-list price
0.0%

Based on 0 recorded sales of single family properties in Flamborough over the last 12 months.

Location

Mortgage Calculator

$379,000

Estimated Monthly Payment

$9,310

Investment Analysis

No recent nearby lease data. Enter a rent to see the numbers.

Mortgage: $9,310/mo (20% down, 5.5%)

Taxes: $0/mo · Insurance: $474/mo

Estimates only. Consult a financial advisor.

R

Reita | Assistant

Online

Reita said:

Reita is an automated assistant, not a licensed real estate agent. I can help you explore neighbourhoods, understand the market, and find our free tools. What are you looking for?

Interested in this property?

By submitting this form you consent to REintel, operated by Direct Realty Ltd. (6992 Hwy 62, Belleville, ON K8N 0L7) contacting you to respond to your inquiry and send you relevant property listings, market updates, and real-estate information. You can withdraw your consent at any time using the unsubscribe link in every email, or by contacting us at the mailing address above.

Cookie Preferences