Exquisite Custom-Built Home with Walkout Basement & Inground Pool, set on a picturesque quarter-acre lot! This exceptional residence offers nearly 5,000 sq. ft. of luxurious living space, including a fully finished walkout basement. From the moment you step inside, the craftsmanship is unmistakable, with soaring ceilings, French doors, crown moulding, elegant wainscoting, and gleaming hardwood floors defining the main level. Just off the foyer, a private home office provides the perfect space for work or study. The grand two-storey living and dining area showcases a cast stone fireplace with floor-to-ceiling mantle, creating an impressive focal point. The adjacent chef’s kitchen is both stylish and functional, with granite countertops, a tile backsplash, gas range, abundant cabinetry, island seating and a bright breakfast area with sliding doors to the upper deck. A cozy family room, powder room, laundry area, and mudroom with access to the triple-car garage complete the main floor. Upstairs, the primary suite is a true retreat, complete with a private balcony overlooking the backyard, a walk-in closet, and a spa-like 5-piece ensuite with double vanity, soaker tub, and glass shower. The three additional bedrooms include one with a private ensuite and walk-in closet, and two more joined by a Jack-and-Jill bathroom—all overlooking the stunning great room below. The fully finished walkout basement offers excellent in-law suite potential, complete with a kitchenette/wet bar, large recreation room, bedroom with ensuite and walk-in closet, home gym or den, and a powder room. Outside, you'll find a private backyard oasis with a glass-paneled deck, lower patio, and inground pool surrounded by beautifully landscaped gardens. This remarkable property offers the perfect blend of elegance, space, and resort-style living.
Property Type:
Residential
Property SubType:
Single Family Residence
Year built:
2011
(Age: 14)
Listing General Location:
660 - New Hamburg, 6 - Wilmot Township
Bedrooms:
5
Bathrooms:
6.0
(Full:4/Half:2)
Lot Size:
11,326 sq. ft.1,052 m2
Lot Details:
74 x 195
Lot Depth:
195'59.4 m
Lot Frontage:
74'22.6 m
Frontage Type:
North
Kitchens:
1
Home Style:
Two Story
County Or Parish:
Waterloo
Property Attached:
Detached
Features:
Attached Garage: Yes, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
Construction:
Brick, Stone, Vinyl Siding, Wood Siding
Basement:
Walk-Out Access, Full, Finished, Sump Pump
Foundation:
Poured Concrete
Roof:
Asphalt Shing
Year Roof Replaced:
2011
Number of Buildings:
1
Total Floor Area:
4,889 sq. ft.454 m2
# Main Level Bathrooms:
1
Finished Area Above Grade:
3,594 sq. ft.334 m2
Finished Area Below Grade:
1,295 sq. ft.120 m2
Fireplace:
true
Fireplaces:
2
Fireplace Details:
Gas
Laundry Features:
In-Suite, Main Level
Water Supply:
Municipal
Pool:
In Ground, Outdoor Pool
Winterized:
Fully Winterized
Sewer:
Sewer (Municipal)
Cooling:
Central Air
Heating:
Forced Air, Natural Gas
Age Electric:
2011
Age Furnace:
2011
Age Plumbing:
2011
Age Tank:
2011
Dishwasher,Dryer,Gas Stove,Microwave,Pool Equipment,Refrigerator,Washer,Dishwasher, Dryer, Gas Stove, Microwave, Pool Equipment, Refrigerator, Washer
Water Softener, Dishwasher, Dryer, Gas Stove, Microwave, Refrigerator, Washer
Nil
Auto Garage Door Remote(s), Central Vacuum, In-law Capability
Landscaped
Deck
false
No
Waterloo St / Hostetler Rd
No
HST Applicable To Sale Price:
No
Features:
Attached Garage: Yes, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
Condo Corporation:
No
Zoning:
A
Other Equipment:
Pool Equipment
Total Acres:
0.26
Fencing:
Full
Exposure / Faces:
South
Lot Site Features:
Urban, Irregular Lot, Ample Parking, Near Golf Course, Landscaped, Place of Worship, Playground Nearby, School Bus Route, Schools
Features:
Attached Garage: Yes, Crops Included: No, Garage: Yes, Common Elements Fee: No, New Construction: No
Data was last updated December 8, 2025 at 05:50 PM (UTC)
Area Statistics
Listings on market:
26
Avg list price:
$879,950
Min list price:
$449,999
Max list price:
$2,550,000
Avg days on market:
48
Min days on market:
4
Max days on market:
433
Avg price per sq.ft.:
$360.21
These statistics are generated based on the current listing's property type
and located in
660 - New Hamburg. Average values are
derived using median calculations. This data is not produced by the MLS® system.