Address
24 John Martin Crescent, Flamborough, ON
Price
$ 2,150,000

Your Agent

Leo Puskar

Salesperson

289-700-4471


Listing provided by Leo Puskar, Salesperson, REMAX Escarpment Realty, Inc.

Property Attributes
  • MLS#40755557
  • TypeSingle Family
  • Listing Status Active
  • CityFlamborough
  • AreaFlamborough
  • Neighbourhood044 - Flamborough East
  • Postal CodeL8B 0Z9
  • StyleTwo Story
  • Year Built1985
  • Taxes$ 10226
  • Price$ 2,150,000
  • Bedrooms4
  • Full Bathrooms3
  • Half Bathrooms1
  • Sqr Footage3045
  • Lot Size0.99 Acres
Data Source:
REALTORS® Association of Hamilton-Burlington (RAOHB)
Property Description

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.

Elementary School High School
Guardian Angels Catholic Es St Mary Catholic Ss High School
Price History
7/29/2025 Listed $2,150,000

General Features

Sewer Septic Tank
Heating Forced Air,Natural Gas
Cooling Central Air
Utilities Cell Service,Electricity Available,Natural Gas Connected,Recycling Pickup,Street Lights
Roof Asphalt Shing
Appliances Bar Fridge,Water Heater,Water Softener,Dishwasher,Dryer,Microwave,Range Hood,Refrigerator,Stove,Washer
Zoning S1
Garage Spaces 2
Patio/Porch Features Patio,Porch
Architectural Style Two Story
Pool Features In Ground
Security Features Smoke Detector(s)
Construction Materials Brick
Year Built 1985
Property Subtype Single Family Residence
County Hamilton
New Construction No
Property Type Residential
HOA No
Attached Garage Yes
Facing Direction West
Garage Y/N No
Other Structures Gazebo,Workshop
Total Rooms 19
Full Baths 3
Status Active
Directions Hwy 6 or Centre Rd to 6th Conc Rd East. East of Centre Rd to John Martin Cres
ModificationTimestamp 2025-08-03T20:00:06.350Z
High School Waterdown Dhs,St Mary Catholic Ss
City Flamborough
Senior Community Y/N No
Open Parking Spaces 15
MLS Area 43 - Flamborough
Lot Size Units Acres
Lot Size Square Feet 43124.4
Carport Y/N No
Spa Features Heated,Hot Tub
HOA Fee 2 Frequency Monthly
Elementary School Flamborough Centre Es,Guardian Angels Catholic Es
Land Lease Y/N No
Tax Annual Amount 10226
Property Condition 31-50 Years
Lease Renewal Y/N No
MLS Area Minor 044 - Flamborough East
Additional Parcels Y/N No
Virtual Tour https://youtu.be/eCccscD0_R4
Building Area Units Square Feet
Standard Status Active
Year Built Source Other
Virtual Tour https://youtu.be/U1rFx6qTTJk

Interior Features

Interior Amenities High Speed Internet,Auto Garage Door Remote(s),Built-In Appliances,Ceiling Fan(s),Central Vacuum,In-law Capability,Upgraded Insulation,Work Bench
Basement Separate Entrance,Full,Finished,Sump Pump
Total Fireplaces 2
Fireplace Features Gas,Wood Burning Stove
Kitchen Level Main
Air Conditioning Y/N No
Heating Y/N Yes
Window Features Window Coverings,Skylight(s)
Fireplace Y/N Yes
Above Grade Finished Area 3045
Half Baths 1
Laundry Features Laundry Room,Main Level
Total Bedrooms 4
Below Grade Finished Area 1465
Main Level Bathrooms 1
Below Grade Finished Area Unit Type Square Feet
Below Grade Finished Area Source LBO Provided
Above Grade Finished Area Source LBO Provided
Above Grade Finished Area Unit Type Square Feet
Total Baths 4

Exterior Features

Exterior Amenities Canopy,Landscaped,Lawn Sprinkler System,Lighting,Privacy
Parking Features Attached Garage,Concrete,Inside Entry
Lot 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
Water Source Drilled Well
Total Parking 17
Inclusions Dishwasher,Dryer,Microwave,Pool Equipment,Range Hood,Refrigerator,Stove,Washer,Window Coverings,Mini Fridge,Custom Bedroom Frame & Mattress,All Light Fixtures,Exterior Camera's,Smart Thermostat,( woo
Lot Size Area 0.99
Foundation Details Concrete Block
Spa Yes
Building Area Total 4510
Lot Dimensions 72.15 x
Lot Size Acres 0.99
Frontage Length 72.15
Frontage Type East
Lot Size Source GeoWarehouse
Waterfront Y/N No
Covered Spaces 2
Other Equipment Pool Equipment
Crops Included Y/N No
Horse Y/N No

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No Strata Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in L8B 0Z9

Price
AVG $1.75M
$2.15M
Taxes
AVG $8,081
$10,226
Year Built
AVG 1985
1985

Your Agent

Leo Puskar

Salesperson

289-700-4471


Listing provided by Leo Puskar, Salesperson, REMAX Escarpment Realty, Inc.

Listed By
RE/MAX Escarpment Golfi Realty Inc.