78 Terrace Drive, Hamilton, ON

Dundas, Hamilton · MLS® X12993368

$1,950,000
For Sale
Listed 95 days ago
Request a showing
◎ Directions
5Bedrooms
7Bathrooms
2Garage · 10 parking
3500-5000Sq Ft

About this home

In the picturesque Dundas community of Pleasant Valley sits this extraordinary custom residence offering an elevated standard of living defined by impeccable craftsmanship and timeless design. Built by McConnell Homes, this distinguished all-brick two-storey spans over 4,500+ sqft above grade, plus 2,200+ sqft of exquisitely finished living space below. A grand double-door entry introduces an opulent Bisazza Italian stone foyer, setting the tone for the elegance that unfolds throughout. A sweeping staircase, adorned with luxurious Stark wool carpeting, anchors the home with architectural grace. The principal living spaces are thoughtfully designed for both grand entertaining and intimate gatherings, featuring wire-brushed hardwood floors and an effortless flow from formal living and dining areas into the heart of the home. The chef-inspired kitchen is a culinary showpiece, appointed with premium KitchenAid appliances, bespoke cabinetry, and generous prep space. The adjoining great room is equally captivating, highlighted by a striking imported Bisazza fireplace and seamless access to a private, resort-style backyard. Upstairs, natural light pours through a dramatic skylight, illuminating a spa-inspired ensuite featuring a jacuzzi tub, separate shower, dual walk-in closets, a private office, and a secluded terrace overlooking the gardens. Three additional bedrooms and two beautifully appointed bathrooms complete the upper level. The lower level is an entertainer's dream, with a richly finished family room, fireplace, granite flooring, wet bar, private theatre, kitchenette, and guest suite with ensuite bath. Walk-out to the multi-tiered interlock patio, covered in-ground concrete pool, and dedicated pool lounge - an outdoor retreat surrounded by mature landscaping, set on an oversized double lot. The property offers dual driveways from both Turnbull and Terrace, and a double garage with interior access-an exceptional offering of sophistication, comfort, and prestige.

Key facts

Property type
Detached, 2-Storey
MLS®
X12993368
Bedrooms
5 (4 + 1)
Bathrooms
7 (4 half)
Size
3500-5000
Lot
75 × 150 ft
Cross streets
Turnbull Rd
Parking
2 garage · 10 parking (attached)
Driveway
Inside Entry, Circular Drive, Private Double
Basement
Finished with Walk-Out, Full
Kitchens
2 (1 + 1)
Heating
Forced Air
A/C
Central Air
Exterior
Brick
Foundation
Poured Concrete
Roof
Asphalt Shingle
Sewer
Sewer
Pool
Inground
Property tax
$11,407 / 2025
Days on market
95
Listing brokerage
RE/MAX ESCARPMENT REALTY INC.

Rooms

Furnace RoomBasement3.18 × 2.31 m
BathroomBasement1.60 × 1.30 m

2 Pc Bath

Bedroom 5Basement4.19 × 3.68 m
BathroomUpper2.77 × 2.34 m

4 Pc Bath

BathroomBasement2.08 × 1.50 m

4 Pc Ensuite

Primary BedroomUpper8.71 × 5.54 m
OtherMain5.16 × 4.04 m
OfficeMain3.61 × 3.51 m
BathroomMain2.01 × 1.09 m

2 Pc Bath

OtherBasement3.51 × 2.62 m
BathroomUpper3.73 × 2.18 m

3 Pc Bath

BathroomMain1.63 × 1.52 m

2 Pc Bath

OtherUpper3.81 × 2.92 m

Walk-In Closet(s)

KitchenBasement6.05 × 1.91 m
Bedroom 2Upper5.21 × 3.76 m
BathroomUpper5.23 × 3.63 m

4 Pc Ensuite

Dining RoomMain4.67 × 4.24 m
OtherBasement2.24 × 1.30 m
OtherBasement5.13 × 3.15 m
Bedroom 4Upper4.27 × 4.27 m
Family RoomMain7.92 × 6.17 m
Media RoomBasement7.82 × 5.05 m
Utility RoomBasement3.15 × 2.13 m
Living RoomMain6.27 × 4.57 m
OfficeUpper4.42 × 2.72 m
OtherBasement1.80 × 1.50 m

Walk-In Closet(s)

Cold Room/CantinaBasement4.62 × 0.89 m
Family RoomBasement6.73 × 5.13 m
FoyerMain7.52 × 4.57 m
KitchenMain4.65 × 4.45 m
Bedroom 3Upper3.86 × 3.76 m
OtherMain2.54 × 1.60 m
OtherBasement3.66 × 1.80 m

B/I Bar

LaundryMain3.48 × 2.31 m
Moe’s TakeTeam Asgarian · Broker
Below the wider set
$2.52Mest. value

Listed at $1,950,000, this home is tracking about 22% below a wider set of listings, though close matches were thin, so it is worth confirming with a precise CMA rather than reading it as a clear deal. The number above is my independent estimate of value, not the asking price.

There are only a few closely comparable homes right here, so this is a broad read from wider listings in the area. Ask me for a precise CMA before relying on it.

Based on 17 similar homes nearby, adjusted for size, beds, and baths.Median of 17 comparable active listings, adjusted for size, beds, and baths. The city (MPAC) assessment points to about $1.96M, lower than the comparables and worth a second look.

How I got there

Here is the exact math behind the estimate. I start from the closest comparable listing and adjust for the real differences (size, beds, baths) to land on a like-for-like value for this home.

  • Closest comparable, listed at $2.35M
  • Bedrooms −$30K
  • Bathrooms +$45K
  • Adjusts to $2.37M

That comparable adjusts to $2.37M; the $2.52M estimate above is the median of all 17 comparables, which is steadier than any single home.This uses comparable active listings, not sold prices. Lot, condition, and finishes are my in-person call, and I can run a full CMA with recent solds.

On location, it is moderately walkable, so some daily errands are within reach and for the rest you will likely drive. TURNBULL opposite KINGS GATE is about a 2-minute walk away.

List price
$1.95MGreat deal$2.85MOverpriced

Total price vs nearby homes. Fair value about $2.52M, median of 17 comparables.

What the listing highlightsThese are claims from the listing. The only way to know for sure is to see it in person, and I am happy to book you a private showing.

  • Pool: lifestyle appeal, but adds maintenance, insurance, and resale is mixed.
  • Premium lot / gardens: lot size and privacy hold value and cannot be changed, verify frontage, depth, and any easements.
  • Hardwood floors: quality hardwood is durable and broadly desirable.
  • Weigh carefully
  • Value driver
  • Lifestyle
Comparable listingsCurrently listed nearby in Dundas · asking prices
$1.98Mavg asking

The closest active listings by size, beds, and price, so you can see what this home is up against.

3 Ancaster Street$1.25M39 Winegarden Trail$1.60M2 Anslow Court$3.10M

The 3 closest active listings nearby.

See all comparable homes
1.95MThis home1.25M1.60M3.10MThis home vs active comparables
Live market pulseActive comparables in Dundas · median list $1.45M
$459this home / sqft
17active listings nearby
95days on market

This home lists 26% below the area average of $617/sqft.

93 days longer than the Hamilton average (2 days).

View comparable listings
This home
Below area avgAbove area avg

Price per square foot vs the area average.

Neighbourhood & location

Dundas, Hamilton, ON

CommuteTime from this home to where you spend your day

Enter a workplace or destination and we’ll show the door-to-door time by car, transit and bike.

Getting around

35/ 100

Somewhat WalkableA walkability read built from the amenities around this home: how close the nearest transit stop is, and how many grocery, dining, park, and pharmacy destinations fall within a 15-minute walk. It is a guide, not a guarantee. Places data from Google.

Some errands on foot, but most trips need a car.

🚉 Nearest transit: TURNBULL opposite KINGS GATE, about 168 m away

20+ transit stops4 dining12 parks1 pharmacies

Within a 15-minute (1.5 km) walk.

Nearby neighbourhoods

How asking prices compare in the closest areas to this home. Longer bars mean a pricier market.

Ancaster
$1.23M
Westdale
$1.39M
Rural Flamborough
$1.15M
Gibson
$670K
Waterdown
$1.37M

Typical asking price of active listings of the same type, per area (outliers removed). Hamilton.

Get the full neighbourhood report (schools, parks, transit & safety) →

Affordability & Mortgage

Affordability
$8,887/mo
$373KIncome needed
5.2×Price ÷ income
$2,051Weekly cost
20% down4.79%25-yr amortization

Income needed assumes a ~32% GDS ratio; weekly is mortgage principal & interest only. Price ÷ income is the home price over the income needed. Fixed reference assumptions so listings compare on equal footing, not a lending decision.

90%mortgage
Mortgage $8,887Property tax $951Total carry $9,838

Calculate and customize your mortgage and other expenses

Adjust the down payment, rate, and amortization, and add property tax, condo fees, and heating to see your true monthly cost.

Your numbers

$
20.0%
$
%

Homes over $1.5M can't be insured, so 20% down or more is required.

4.14%
%
Live rate from Ratehub.ca

Conventional (20%+ down). Best insured 5-year fixed 3.99% via Ratehub.ca (as of July 17, 2026); conventional rates run a little higher.

years
years (your rate-locked period)
$8,325per month

Mortgage amount $1,560,000 · 4.14% over 25 years

$390,000Down payment (20.0%)
$1,560,000Loan before insurance
$0CMHC premium
$9,275Total monthly cost

Total monthly cost

Mortgage payment (monthly equivalent)
$8,325
Property tax
$951
Condo / maintenance fees
$0
Heating
$0
Estimated monthly cost
$9,275

Add your own property tax, condo fees, and heating on the left for a sharper total.

One-time closing costs

Ontario land transfer tax
$35,475
Estimated closing costs
$35,475

Plus your down payment of $390,000. Legal fees, title insurance, and adjustments are extra and vary by deal.

Mortgage stress test

6.14%Qualifying rate
$10,111/monthPayment at the qualifying rate

Lenders qualify you at the greater of your rate plus 2% or 5.25%. You do not pay this rate. It just shows you could still handle payments if rates rose, so aim to stay comfortable at this higher number.

Over the full 25 years

$937,422Total interest paid
$2,497,422Total of all payments
Principal $1,560,000 Interest $937,422
YearPrincipalInterestBalance
1$36,545$63,351$1,523,455
2$38,074$61,823$1,485,381
3$39,667$60,230$1,445,714
4$41,326$58,571$1,404,388
5$43,054$56,842$1,361,334
6$44,855$55,042$1,316,478
7$46,732$53,165$1,269,747
8$48,686$51,211$1,221,060
9$50,723$49,174$1,170,338
10$52,844$47,052$1,117,493
11$55,055$44,842$1,062,439
12$57,358$42,539$1,005,081
13$59,757$40,140$945,324
14$62,256$37,640$883,068
15$64,860$35,036$818,207
16$67,573$32,323$750,634
17$70,400$29,497$680,234
18$73,345$26,552$606,889
19$76,413$23,484$530,476
20$79,609$20,288$450,868
21$82,939$16,958$367,929
22$86,408$13,489$281,521
23$90,022$9,875$191,499
24$93,788$6,109$97,711
25$97,711$2,186$0

At the end of your 5-year term

Total paid over the term
$499,484
Principal paid down
$198,666
Interest paid
$300,818
Balance remaining
$1,361,334

Talk to Team Asgarian about your options

Rates and programs change often. We will connect you with a trusted mortgage professional and build a plan that fits your budget and goals.

Let's connect

Estimates only, not a mortgage quote or pre-approval. Figures use Canadian semi-annual compounding, current minimum down-payment rules, CMHC premium tiers, and Ontario (plus Toronto, when selected) land transfer tax. Actual rates, taxes, insurance, and closing costs vary by lender and property. Confirm every number with your mortgage professional.

Investor snapshot

Rental yield
Estimate$7,350/mo
$88,200Gross annual rent
3.4%Est. cap rate

Income potential: the basement has a separate entrance, which often supports a rentable in-law or second suite. That can lift real rent well above the figure above and help carry the mortgage. Ask us about permitted use in this area.

Thinking of this home as an investment? We will pull real comparable rents and run the full numbers with you.

Talk about the numbers

Estimates only. Rent is modelled on above-grade size and local norms, so a finished basement or second suite (a separate entrance often means one) can push real rent well above this. Taxes, fees, and vacancy vary by property, and cap rate is before financing. A starting point, not a final number, let us run the real ones with you.

4.5%
Gross yield
− Property tax $11,407− Insurance $1,400− Vacancy & upkeep $9,702Net operating income $65,691

All information deemed reliable but not guaranteed. For personal, non-commercial use only. Listing courtesy of RE/MAX ESCARPMENT REALTY INC.. MLS®/PropTx.

CallRequest a showing