24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620

As a Sales Representative, I am able to help Buyers find the right home in Niagara-on-the-Lake or anywhere else for that matter! The home does not have to be listed by me in order for me to sell it, so if you find homes on the MLS and you want to see them, just let me know and I will make the arrangements and act as your Realtor – in your best interest!

Forgot password Extend Verify Contact

24 RED HAVEN Drive
105 - St. Davids Niagara-on-the-Lake L0S 1P0

$1,299,000
Single Family beds: 4 baths: 4.0 2,986 sq. ft. built: 2007

Main Photo: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 1: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 2: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 3: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 4: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 5: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 6: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 7: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 8: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 9: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 10: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 11: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 12: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 13: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 14: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 15: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 16: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 17: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 18: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 19: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 20: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 21: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 22: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 23: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 24: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 25: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 26: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 27: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 28: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 29: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 30: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 31: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 32: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 33: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 34: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 35: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 36: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 37: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 38: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 39: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 40: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 41: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 42: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 43: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Photo 44: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
Status:
Active
Prop. Type:
Single Family
MLS® Num:
40829620
Bedrooms:
4
Bathrooms:
4
Year Built:
2007
Inspired by the signature elegance of interior designer Jillian Harris, this extraordinary open-concept residence redefines luxury living in the heart of Wine Country. A one-owner custom masterpiece designed by an award-winning architect, this exceptional residence has been impeccably transformed through extensive, high-end renovations completed in 2026. From the moment you enter, soaring 18-foot ceilings and the grand open-to-below design create a breathtaking sense of scale and light, extending seamlessly from the front to the back of the home. A dramatic central catwalk overlooks the expansive living space, while refined designer finishes, rich hardwood flooring, elegant porcelain tile, and a thoughtfully curated open-concept layout deliver a sophisticated yet welcoming atmosphere. At the heart of the home, the chef-inspired kitchen is designed to impress, featuring a massive statement island, stunning quartz countertops, premium finishes, and exceptional space for entertaining and everyday living. Offering 4 spacious bedrooms and 3.5 beautifully appointed bathrooms, this residence perfectly balances luxury, comfort, and functionality. The upper-level primary retreat is a private sanctuary complete with a spa-inspired ensuite and an oversized walk-in closet spacious enough to accommodate a private office. Positioned across the catwalk, two additional bedrooms provide an ideal layout for family privacy and comfort. The fully finished basement further expands the living space with additional bedrooms and versatile areas perfect for guests, recreation, or multi-generational living. Step outside to your own private backyard oasis, where an expansive deck creates the ultimate setting for seamless indoor-outdoor living and entertaining. Completing this remarkable property is an oversized 3-car garage complementing the striking Hollywood-inspired exterior with exceptional curb appeal. This is a rare opportunity to own a truly turnkey luxury home. (id:2493)
Property Type:
Single Family
Common Interest:
Freehold
Property Attached:
No
Total Living Area:
2,986 sq. ft.
Finished Area Above Grade:
2,249 sq. ft.
Zoning:
R1
Taxes:
$6,866.8 / -
Community:
105 - St. Davids
Exterior Features:
Stucco, Other
Structure Type:
House
Appliances Included:
Washer, Refrigerator, Dishwasher, Stove, Dryer
Bedrooms:
4
Bedrooms Above Grade:
3
Bedrooms Below Grade:
1
Bathrooms:
4.0
Half Bathrooms:
1
Cooling:
Central air conditioning
Fireplace:
Yes
Fireplaces:
1
Heating:
Forced air, Natural gas
# Storeys:
2.0
Water:
Municipal water
Sewer:
Municipal sewage system
Basement:
Finished, Full
Lot Frontage:
69'
Parking:
Attached Garage
Total Parking Spaces:
7
Floor
Type
Size
Other
Main level
Laundry room
10'1" × 6'7"
-
Main level
Dining room
15'2" × 13'10"
-
Main level
Kitchen
13'9" × 10'4"
-
Main level
Living room
16'11" × 15'1"
-
Main level
Foyer
15'1" × 9'7"
-
Second level
Bedroom
13'6" × 9'6"
-
Second level
Bedroom
11'1" × 9'7"
-
Second level
Primary Bedroom
17'8" × 12'4"
-
Basement
Storage
9' × 5'4"
-
Basement
Utility room
7'8" × 7'7"
-
Basement
Bedroom
16'5" × 11'10"
-
Basement
Family room
35' × 13'6"
-
Floor
Ensuite
Pieces
Other
Main level
No
5
Main level
No
2
Second level
No
4
Basement
No
3
  • Photo 1: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 1 of 44
  • Photo 2: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 2 of 44
  • Photo 3: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 3 of 44
  • Photo 4: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 4 of 44
  • Photo 5: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 5 of 44
  • Photo 6: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 6 of 44
  • Photo 7: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 7 of 44
  • Photo 8: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 8 of 44
  • Photo 9: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 9 of 44
  • Photo 10: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 10 of 44
  • Photo 11: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 11 of 44
  • Photo 12: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 12 of 44
  • Photo 13: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 13 of 44
  • Photo 14: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 14 of 44
  • Photo 15: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 15 of 44
  • Photo 16: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 16 of 44
  • Photo 17: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 17 of 44
  • Photo 18: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 18 of 44
  • Photo 19: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 19 of 44
  • Photo 20: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 20 of 44
  • Photo 21: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 21 of 44
  • Photo 22: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 22 of 44
  • Photo 23: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 23 of 44
  • Photo 24: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 24 of 44
  • Photo 25: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 25 of 44
  • Photo 26: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 26 of 44
  • Photo 27: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 27 of 44
  • Photo 28: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 28 of 44
  • Photo 29: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 29 of 44
  • Photo 30: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 30 of 44
  • Photo 31: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 31 of 44
  • Photo 32: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 32 of 44
  • Photo 33: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 33 of 44
  • Photo 34: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 34 of 44
  • Photo 35: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 35 of 44
  • Photo 36: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 36 of 44
  • Photo 37: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 37 of 44
  • Photo 38: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 38 of 44
  • Photo 39: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 39 of 44
  • Photo 40: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 40 of 44
  • Photo 41: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 41 of 44
  • Photo 42: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 42 of 44
  • Photo 43: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 43 of 44
  • Photo 44: 24 RED HAVEN Drive in Niagara-on-the-Lake: Single Family for sale : MLS®# 40829620
    Photo 44 of 44

Video Tour Website

Listed by RE/MAX Niagara Realty Ltd.
Data was last updated June 10, 2026 at 02:15 PM (UTC)
Area Statistics
Listings on market:
53
Avg list price:
$1,149,900
Min list price:
$399,900
Max list price:
$3,500,000
Avg days on market:
58
Min days on market:
2
Max days on market:
439
Avg price per sq.ft.:
$426.62
These statistics are generated based on the current listing's property type and located in 105 - St. Davids. Average values are derived using median calculations. This data is not produced by the MLS® system.
powered by myRealPage.com