
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.
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
Parking
Interior Specifications
Climate & Utilities
Building & Exterior
Property & Lot
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
Living Room
Lvl First24 x 39
Kitchen
Lvl First24 x 25
Family Room
Lvl FirstPrimary Bedroom
Lvl FirstBedroom 2
Lvl SecondBedroom 3
Lvl SecondBedroom 4
Lvl SecondProperty History
$4,900,000
May 1, 2026
MLS® 73511215
$5,400,000
Apr 29, 2026
MLS® 73508209
$5,400,000
Apr 28, 2026
MLS® 73508209
Listing Agent: Brette L'Italien
Listing Office: William Raveis R.E. & Home Services
MLS® Number: 73511215








