Back to Search
Active
157 Days on market
99 Sunset Rock Rd Andover — Photo 1 of 42

99 Sunset Rock Rd Andover — Photo 1 of 42

$4,900,000

Investment Analysis — 99 Sunset Rock Rd

Andover, MA 01810

Based on HUD Small Area Fair Market Rent for Lawrence, MA-NH HUD Metro FMR Area, a 5-bedroom in 01810 carries an estimated $3,890/mo in gross rent — about a -0.48% cap rate and $-23,323/yr in estimated NOI at the $4,900,000 list price. Adjust every assumption in the calculator below.

View Standard Listing

Beds

5

Baths

6

SqFt

7,811

Style

Single Family

Built

2026

This impressive new construction home ideally located on Sunset Rock Road offers 5 bedrooms, 5 en-suite baths, and 2 half baths. Designed for both luxury and functionality, it features two primary suites, including a private retreat accessed via a sunlit glass-link hallway. Spanning 7,811 sqft, the home showcases a custom kitchen with Wolf and Sub-Zero appliances, Calacatta Monalisa quartz countertops, a walk-in pantry, and seamless flow to the main living areas. Two fireplaces add warmth and architectural appeal, while dual laundry rooms provide convenience. The finished lower level is ideal for entertaining with a theater and wet bar, plus additional unfinished space for a gym or customization. Set on a premier lot, the outdoor space is perfect for relaxation or entertaining. Elevated, private and far from cookie-cutter. This home offers striking curb appeal, with final landscaping set to take it completely over the top.

ADU Potential

Massachusetts allows one accessory dwelling unit by right in single-family zoning districts statewide (M.G.L. c. 40A §3; 760 CMR 71.00, effective Feb 2025). Estimated maximum ADU size for this property: 900 sq ft (the lesser of 900 sq ft or half the 7,811 sq ft principal dwelling). Lot size: 59,794 sq ft.

Based on listing data, which indicates the property type — not the zoning district. Local dimensional, septic (Title 5), and historic-district requirements still apply. Not legal advice — verify with the municipality.

Estimates — not financial advice

These figures are illustrative estimates for informational purposes only — not an appraisal, valuation, or guarantee of rent, income, or returns, and not financial, tax, or investment advice. Rent is either the figure reported on the MLS listing — in-place rent that may differ from market and is not verified against the actual leases — or, where the listing reports none, an estimate from HUD Small Area Fair Market Rents, a government benchmark that may differ from actual market rent. Each figure is labelled with its source. Cap rate, NOI, and returns depend on the assumptions shown, which you can change. MLS and other third-party data may be inaccurate or out of date. Verify all figures independently and consult your own financial, tax, and legal advisors before making any investment decision.

Property Details

Financials

Original Price$4,900,000
Annual Taxes--

Parking

Garage3
Off-Street10

Interior Specifications

Total Rooms22
Fireplaces2
FlooringTile, Hardwood
BasementFull, Finished, Garage Access

Climate & Utilities

HeatingCentral, Forced Air, Propane, ENERGY STAR Qualified Equipment
CoolingCentral Air, ENERGY STAR Qualified Equipment
WaterPublic
SewerPublic Sewer

Building & Exterior

ConstructionConventional (2x4-2x6)
RoofShingle, Rubber, Metal
FoundationConcrete Perimeter
ZoningSRC

Property & Lot

Acres1.37
SqFt Lot59,794
Lot FeaturesCleared, Gentle Sloping

Amenities & Appliances

Water Heater • Range • Oven • Dishwasher • Disposal • Microwave • Refrigerator • Freezer • ENERGY STAR Qualified Refrigerator • ENERGY STAR Qualified Dishwasher • Range Hood • Plumbed For Ice Maker

Geography

Floorplan Breakdown

Structural Layout

Second
Bedroom 2Bedroom 3Bedroom 4
First
Living RoomKitchenFamily RoomPrimary Bedroom
Living Room
Lvl First

24 x 39

Kitchen
Lvl First

24 x 25

Family Room
Lvl First
Primary Bedroom
Lvl First
Bedroom 2
Lvl Second
Bedroom 3
Lvl Second
Bedroom 4
Lvl Second

Property History

Listed
$4,900,000

May 1, 2026

MLS® 73511215

Terminated
$5,400,000

Apr 29, 2026

MLS® 73508209

Listed
$5,400,000

Apr 28, 2026

MLS® 73508209

Listing Provided By

Listing Agent: Brette L'Italien

Listing Office: William Raveis R.E. & Home Services

MLS® Number: 73511215