Free account required
Unlock the full potential of your property search with a free account! Here's what you'll gain immediate access to:
- Exclusive Access to Every Listing
- Personalized Search Experience
- Favorite Properties at Your Fingertips
- Stay Ahead with Email Alerts





$2,150,000
24 JOHN MARTIN Crescent
Flamborough, Ontario, Ontario, L8B0Z9
MLS® Number: 40722090
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.
Building information
Type
*****
Appliances
*****
Architectural Style
*****
Basement Development
*****
Basement Type
*****
Constructed Date
*****
Construction Style Attachment
*****
Cooling Type
*****
Exterior Finish
*****
Fireplace Fuel
*****
Fireplace Present
*****
FireplaceTotal
*****
Fireplace Type
*****
Fire Protection
*****
Fixture
*****
Foundation Type
*****
Half Bath Total
*****
Heating Fuel
*****
Heating Type
*****
Size Interior
*****
Stories Total
*****
Utility Water
*****
Land information
Access Type
*****
Amenities
*****
Landscape Features
*****
Sewer
*****
Size Frontage
*****
Size Irregular
*****
Size Total
*****
Rooms
Main level
Foyer
*****
Living room
*****
Dining room
*****
Family room
*****
Breakfast
*****
Kitchen
*****
2pc Bathroom
*****
Laundry room
*****
Basement
Recreation room
*****
Utility room
*****
3pc Bathroom
*****
Bedroom
*****
Office
*****
Storage
*****
Second level
Bedroom
*****
Full bathroom
*****
Bedroom
*****
Primary Bedroom
*****
4pc Bathroom
*****
Main level
Foyer
*****
Living room
*****
Dining room
*****
Family room
*****
Breakfast
*****
Kitchen
*****
2pc Bathroom
*****
Laundry room
*****
Basement
Recreation room
*****
Utility room
*****
3pc Bathroom
*****
Bedroom
*****
Office
*****
Storage
*****
Second level
Bedroom
*****
Full bathroom
*****
Bedroom
*****
Primary Bedroom
*****
4pc Bathroom
*****
Main level
Foyer
*****
Living room
*****
Dining room
*****
Family room
*****
Breakfast
*****
Kitchen
*****
2pc Bathroom
*****
Laundry room
*****
Basement
Recreation room
*****
Utility room
*****
3pc Bathroom
*****
Bedroom
*****
Courtesy of RE/MAX Escarpment Golfi Realty Inc.
Book a Showing for this property
Please note that filling out this form you'll be registered and your phone number without the +1 part will be used as a password.