Listing Tools

YOUR PERSONAL TOUR AWAITS - SHOWN BY APPOINTMENT ONLY! Forget everything you thought you knew about suburban living-45 Seven Sister Road in Haverhill's premier Overlook neighborhood is here to completely rewrite your homeownership wishlist. Spanning roughly 4,500 square feet across 11 meticulously designed rooms, this 5-bedroom, 4.5-bath colonial masterpiece sits on a lush 0.92-acre lot, delivering that rare, magical blend of North Shore warmth, serene privacy, and modern luxury-complete with views of the Merrimack River.Step inside to a light-drenched interior featuring a dramatic, two-story Great Room anchored by a stately fireplace and soaring windows. The open-concept flow leads straight to the gourmet kitchen-a culinary dream outfitted with granite countertops, custom cabinetry, stainless appliances, a sunlit breakfast nook, and a center island built for morning espresso or evening wine pours. Elegant formal dining sits just off the kitchen, ready for grand dinner parties.A rare main-level primary suite serves as your private sanctuary, featuring a spa-like bath with a jetted tub and a massive walk-in closet. Upstairs offers exceptional versatility with additional spacious bedrooms-including a second-floor suite ideal for guests or a dedicated home office. Everyday practicality shines with a dedicated mudroom, pantry, laundry room, and lower-level bonus space primed for a future gym, media lounge, or rec room.Outdoors, an oversized, maintenance-free deck and patio extend your living space into a private, tree-lined haven kept vibrant by an 11-zone irrigation system. Modern essentials like central AC, natural gas forced-air heat, 200+ amp electrical service, and an attached two-car garage ensure total comfort and efficiency.Location-wise, you hit the jackpot! Enjoy scenic river vistas right from home, while sitting just minutes from local marinas, golf courses, Haverhill's vibrant downtown dining, the MBTA rail straight into Boston, & a short, scenic drive to Newburyport & Plum Island. Bring your vision, pack your bags, and get ready to fall in love!

More Info

Basic Information

  • Bedrooms4
  • Mls StatusNew
  • Bathroom5
  • Parcel Number M:0478 B:0001 L:0009,4231498
  • Road Frontage DescriptionPaved

Basic Information

  • List Price$1,199,900
  • MLS Number73579974
  • Modification Date09/19/2026
  • Property SubTypeSingle Family Residence

Building

  • Attached Garage YN Yes
  • Basement
    • Finished
    • Full
    • Interior Entry
    • Radon Remediation System
    • Unfinished
    • Walk-Out Access
  • Building Area Units Square Feet
  • Construction Materials Frame
  • FireplaceYes
  • Fireplace Features Family Room
  • Fireplaces Total 1
  • FoundationConcrete Perimeter
  • Garage Spaces2
  • Patio And Porch Features Deck, Deck - Composite, Patio, Covered
  • Property StyleColonial
  • Rooms11
  • Utilities For Gas Range, Washer Hookup
  • Year Built2005
  • Year Built Details Approximate
  • Year Built Source Public Records

Amenities

  • Amenities
    • Golf
    • Highway Access
    • House of Worship
    • Laundromat
    • Marina
    • Medical Facility
    • Private School
    • Public School
    • Public Transportation
    • Shopping
    • T-Station
    • Walk/Jog Trails
  • Appliances IncludedTankless Water Heater, Range, Dishwasher, Microwave, Refrigerator

Tax Information

  • Tax Assessed Value $947,700
  • Tax Year 2026
  • Taxes$10,055

Rooms

  • Bathroom 1 Main, First,13 x 11
  • Bathroom 2 Main, First,8 x 4
  • Bathroom 3 Second,9 x 6
  • Bathrooms Total Decimal 4.5
  • Bedroom 2 Second,16 x 12
  • Bedroom 3 Second,16 x 12
  • Bedroom 4 Second,10 x 16
  • Bedroom 5 Basement,19 x 12
  • Dining Room Main, First,14 x 12
  • Family Room Main, First,15 x 16
  • Full Bath4
  • Half Baths1
  • Kitchen Main, First,17 x 16
  • Main Level Bathrooms 2
  • Main Level Bedrooms 1
  • Master Bedroom Main, First,19

Exterior

  • Exterior Features
    • Covered Patio/Deck
    • Deck
    • Deck - Composite
    • Patio
    • Professional Landscaping
    • Rain Gutters
    • Sprinkler System
    • Stone Wall
  • RoofShingle

Property Information

  • Square Feet4,516
  • Building Area Source Public Records
  • Living Area 4,516
  • Lot Size Square Feet 40,097
  • Lot Size Units Acres

Other

  • Date Listed09/19/2026
  • Farm Land Area Units Square Feet

Parking

  • Parking Spaces6
  • Covered Spaces 2
  • Garage YN Yes
  • Open Parking YN Yes
  • Parking Features Attached, Garage Door Opener, Paved Drive, Off Street, Paved

Location

  • SubdivisionOverlook
  • Address45 Seven Sister Road
  • Building Number45
  • CountyEssex
  • StateMA
  • StreetSeven Sister Road
  • TownHaverhill
  • Zip01830

Property

  • Acreage0.92

Interior

  • Flooring
    • Carpet
    • Flooring - Engineered Hardwood
    • Flooring - Hardwood
    • Flooring - Stone/Ceramic Tile
    • Hardwood
    • Tile
  • Interior Features
    • Bathroom
    • Bathroom - 3/4
    • Bathroom - Full
    • Bathroom - With Shower Stall
    • Breakfast Bar / Nook
    • Central Vacuum
    • Countertops - Stone/Granite/Solid
    • Dining Area
    • Media Room
    • Recessed Lighting
    • Slider
    • Study

Utilities

  • Cooling Central Air
  • Cooling YN Yes
  • Electric Circuit Breakers,200+ Amp Service
  • Heat SystemYes
  • Heating Forced Air, Natural Gas
  • Sewer Public Sewer
  • Water Source Public

Map Location

Listed by Robert Del Greco of Compass

The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. (MLSPIN) from third party sources, including sellers, lessors and public records, and were compiled by MLSPIN. The property listing data and information, and the Images, are for the personal, non-commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing or leasing. MLSPIN and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information, or as to the accuracy of any of the Images, set forth herein.

I agree to receive marketing and customer service calls and text messages from In Realty Inc. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.