Address
24 John Martin Crescent, Flamborough, ON
Price
$ 2,150,000
Property Attributes
- ID#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
Taxes
Year Built
In The Neighbourhood
Freelton
$ 1,449,000
- Type
- Single Family
- Size
- 2,531 SqFt
- Rooms
- 4 Beds + 2.5 Baths
Coldwell Banker-Burnhill Realty
Waterdown
$ 1,699,000
- Type
- Single Family
- Size
- 2,556 SqFt
- Rooms
- 4 Beds + 3.5 Baths
RE/MAX Escarpment Realty Inc.
Hamilton
$ 1,749,900
- Type
- Single Family
- Size
- 3,934 SqFt
- Rooms
- 4 Beds + 2.5 Baths
Keller Williams Complete Realty
Puslinch
$ 1,899,900
- Type
- Single Family
- Size
- 2,868 SqFt
- Rooms
- 5 Beds + 3 Baths
RE/MAX Escarpment Realty Inc.
Hamilton
$ 2,499,000
- Type
- Single Family
- Size
- 5,422 SqFt
- Rooms
- 4 Beds + 2.5 Baths
RE/MAX Escarpment Realty Inc.
Open House
Carlisle
$ 1,279,900
- Type
- Single Family
- Size
- 2,361 SqFt
- Rooms
- 3 Beds + 2.5 Baths
RE/MAX Escarpment Realty Inc.
Flamborough
$ 1,695,000
- Type
- Single Family
- Size
- 2,794 SqFt
- Rooms
- 4 Beds + 4 Baths
RE/MAX TWIN CITY FAISAL SUSIWALA REALTY
Hamilton
$ 710,000
- Type
- Single Family
- Size
- 966 SqFt
- Rooms
- 2 Beds + 1 Baths
ROYAL LEPAGE SIGNATURE REALTY
Hamilton
$ 929,900
- Type
- Single Family
- Size
- 1,579 SqFt
- Rooms
- 3 Beds + 2 Baths
Re/Max Twin City Realty Inc
Freelton
$ 1,999,900
- Type
- Single Family
- Size
- 6,182 SqFt
- Rooms
- 4 Beds + 0 Baths
RE/MAX Escarpment Realty Inc.
Puslinch
$ 2,249,999
- Type
- Single Family
- Size
- 3,524 SqFt
- Rooms
- 6 Beds + 4.5 Baths
RE/MAX Escarpment Realty Inc.
Flamborough
$ 3,000
- Type
- Single Family
- Size
- 1,343 SqFt
- Rooms
- 3 Beds + 2 Baths
RE/MAX Escarpment Golfi Realty Inc.
Carlisle
$ 1,999,900
- Type
- Single Family
- Size
- 3,496 SqFt
- Rooms
- 6 Beds + 5 Baths
RE/MAX Escarpment Realty Inc.
Toronto Real Estate Board (TRREB); All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested
The information on this system is from sources deemed reliable, but should not be relied upon without independent verification. All data contained in the system is property of REALTORS ® Association of Hamilton-Burlington © 2018 or the originating source board/association.