EXTRAORDINARY NEW PRICE! Absolutely stunning contemp on 2A in a cul de sac n'hood w/long drv, terraced lawn, stonewalls, bluestone patios, waterfall & mature trees. Orig structure was completely renovated inside & out w/grt new addtns in 2006. 11 rms, 3 fnshed lvls, ovr 4400sf-it's really better than new! Fab new sun rm w/tiered decks, new master suite, 4.5 new Waterworks baths, LL bonus ste, 4C tandem gar & magnificent setting! Abuts conserv lnd w/walking & horseback riding trails.
Single-familyProperty Type
2006Year Built
2.03 acresLot Size
$400Est. Price/Sq.Ft.
4 garage spacesParking
Listed by Brigitte Senkler• Coldwell Banker Residential Brokerage - Concord
9 RM CONTEMP BY CHRIS HART ON 2AC SCENIC LOT. UNIQUE BUT PR ACTICAL FLRPLN, CURVED WALL IN LR & LL OFFICE/PLAYRM, WHITE CORIAN KIT, 3BR, 2.5BA, SITTING RM ON 2ND LVL, WALLS OF GLASS, SKYLITES, SCREEN PORCH, DECK, LOVELY LANDSCAPING.
Year
Property tax
Land + Additions
Assessment*
2025
$20,632 (+2.5%)
$545,000 + $1,020,400
$1,565,400
2024
$20,123 (+7.4%)
$501,400 + $1,008,200
$1,509,600
2023
$18,730 (−5.1%)
$501,200 + $822,500
$1,323,700
2022
$19,736 (+1.4%)
$435,800 + $760,300
$1,196,100
2021
$19,473 (−3.8%)
$435,800 + $760,300
$1,196,100
2020
$20,238 (+2.1%)
$370,500 + $731,800
$1,102,300
2019
$19,817 (+4.9%)
$370,500 + $713,000
$1,083,500
2018
$18,888 (+5.2%)
$370,500 + $669,000
$1,039,500
2017
$17,960 (+2.4%)
$370,500 + $648,800
$1,019,300
2016
$17,532 (+8.3%)
$370,500 + $648,800
$1,019,300
2015
$16,182 (+1.9%)
$353,000 + $498,700
$851,700
2014
$15,876 (+7.4%)
$353,000 + $498,700
$851,700
2013
$14,782 (+0.7%)
$353,000 + $483,100
$836,100
2012
$14,682 (+1.4%)
$370,500 + $486,100
$856,600
2011
$14,477 (+6.7%)
$392,200 + $505,300
$897,500
2010
$13,572 (+14.5%)
$414,000 + $514,300
$928,300
2009
$11,857
$435,800 + $408,700
$844,500
Tax history for 174 Sunset Rd
Year
Property tax
Land + Additions
Assessment*
2025
$20,632 (+2.5%)
$545,000 + $1,020,400
$1,565,400
2024
$20,123 (+7.4%)
$501,400 + $1,008,200
$1,509,600
2023
$18,730 (−5.1%)
$501,200 + $822,500
$1,323,700
2022
$19,736 (+1.4%)
$435,800 + $760,300
$1,196,100
2021
$19,473 (−3.8%)
$435,800 + $760,300
$1,196,100
2020
$20,238 (+2.1%)
$370,500 + $731,800
$1,102,300
2019
$19,817 (+4.9%)
$370,500 + $713,000
$1,083,500
2018
$18,888 (+5.2%)
$370,500 + $669,000
$1,039,500
2017
$17,960 (+2.4%)
$370,500 + $648,800
$1,019,300
2016
$17,532 (+8.3%)
$370,500 + $648,800
$1,019,300
2015
$16,182 (+1.9%)
$353,000 + $498,700
$851,700
2014
$15,876 (+7.4%)
$353,000 + $498,700
$851,700
2013
$14,782 (+0.7%)
$353,000 + $483,100
$836,100
2012
$14,682 (+1.4%)
$370,500 + $486,100
$856,600
2011
$14,477 (+6.7%)
$392,200 + $505,300
$897,500
2010
$13,572 (+14.5%)
$414,000 + $514,300
$928,300
2009
$11,857
$435,800 + $408,700
$844,500
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
4
Baths
4.5
Stories
2
Lot width
—
Lot depth
—
Lot size
2.03 Acres
Year renovated
—
Sq. Ft.
4,146
Year built
1982
Style
Single Family Residential
County
Middlesex County
APN
3218007S
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 30, 2026.
Property details
Parking
Parking Information
Has Garage
Has Open Parking
# of Garage Spaces: 4
# of Covered Spaces: 4
Parking Spaces: 10
AttachedGarageYN: Yes
Parking Features: Attached, Garage Door Opener, Heated Garage, Paved Drive, Off Street