99 Sunset Rock Rd, Andover, MA, 01810
About This Home
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.
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- Year built: 2026
Materials
- Foundation: Concrete Perimeter
- Roof: Shingle,Rubber,Metal
- Construction materials: Conventional (2x4-2x6)
Type & Style
- Home type: SingleFamily
- Architectural style: Farmhouse
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Water Heater,Range,Oven,Dishwasher,Disposal,Microwave,Refrigerator,Freezer,ENERGY STAR Qualified Refrigerator,ENERGY STAR Qualified Dishwasher,Range Hood,Plumbed For Ice Maker
- Laundry features: Electric Dryer Hookup,Washer Hookup
Basement
- Has basement: Yes
- Basement: Full,Finished,Garage Access
Bedroom2
- Level: Second
Bedroom3
- Level: Second
Bedroom4
- Level: Second
Bedrooms & Bathrooms
- Bedrooms: 5
- Bathrooms: 7
- Full bathrooms: 5
- 1/2 bathrooms: 2
Family Room
- Level: First
Features
- Media Room,Wet Bar,Wired for Sound
- Door features: Insulated Doors
- Window features: Insulated Windows
- Flooring: Tile,Hardwood
- Number of fireplaces: 2
- Fireplace: Yes
- Finished area below ground: 2,603
- Finished area above ground: 5,208
Heating & Cooling
- Heating features: Central,Forced Air,Propane,ENERGY STAR Qualified Equipment
- Cooling features: Central Air,ENERGY STAR Qualified Equipment
Interior Area
- Total structure area: 7,811
- Total interior livable area: 7,811 sqft
Kitchen
- Level: First
- Area: 600
Living Room
- Level: First
- Area: 936
Master Bedroom
- Level: First
Property
Details
- Parcel number: 1841731
- Zoning: SRC
Features
- Patio & porch: Deck - Composite,Patio
- Exterior features: Deck - Composite,Patio,Rain Gutters,Professional Landscaping,Sprinkler System
Lot
- Lot size: 1.37 Acres
- Features: Cleared,Gentle Sloping
Parking
- Total spaces: 10
- Parking features: Attached
- Has garage: Yes
- Attached garage spaces: 3
- Covered spaces: 3
- Uncovered spaces: 7
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Inland Flooding
- Ice Storm
- Tsunami
How This Home’s Risks Compare
FEMA Declared Disasters Across Massachusetts Counties
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $24,777 | $297,324 |
| Home Insurance * | $1,179 | $14,148 |
| Property Taxes | $5,224 | $62,688 |
| Electricity | $1,540 | $18,483 |
| Total | $32,720 | $392,640 |
Income You'd Need if You Spent...
Massachusetts FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-05-01 | Listed for sale | $4,900,000 |
| 2026-04-29 | Listing removed | $5,400,000 |
| 2026-04-28 | Listed for sale | $5,400,000 |
| 2022-10-14 | Sold | $800,000 |
| 2022-08-07 | Pending sale | $790,000 |
| 2022-08-07 | Contingent | $790,000 |
| 2022-08-03 | Price change | $790,000 |
| 2022-06-04 | Pending sale | $709,900 |
| 2022-06-04 | Contingent | $709,900 |
| 2022-06-01 | Listed for sale | $709,900 |
View on Zillow