174 Sunset Rd

4,431 Sq. Ft.
$234 / Sq. Ft.
4,431
Sq. Ft.
$234
per Sq. Ft.

Description

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.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.

Listing Agents

  1. Sharon Mendosa

    Sharon Mendosa

    Alternative Listing Agent

    P: (978)-580-0386

  2. Listed by Brigitte Senkler • Coldwell Banker Realty - Concord

Property Details for 174 Sunset Road

Town
Carlisle
Area
MA-Carlisle
Architectural Style
Contemporary
Style
Contemporary
Garage Spaces
4
Open Parking Spaces
10.00
Parking Spaces Total
10
LISTING CLOSED: 05/14/2008 12:00 AM

Property Details for 174 Sunset Road

StatusSold
MLS #70661982
Days on Market173
Taxes$1,203 / year
HOA Fees-
Property TypeSingle Family
MLS TypeSingle Family / Detached
Year Built2006
CountyMiddlesex County

Location

Listing Courtesy of Coldwell Banker Realty - Concord, Brigitte Senkler

Sold By Coldwell Banker Realty - Newton, Deborah Stein

Add your commute

Building Information for 174 Sunset Road

Stories-Year Built2006Building Size-Lot Size2.03 AC / 88,426 SF

Payment Calculator

$5,273 per month

30 year fixed, 6.36% Interest

Principal and Interest

$5,172

Property Taxes

$100

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 174 Sunset Road

General Details
Property Details
  • Building Area Units: Square Feet
  • Community Features: Walk/Jog Trails
  • Current Financing: Conv. Fixed
  • Living Area: 4431.0
  • Color: Grey
  • SqFt with Basement: Yes
  • Property Attached: No
  • Single Family Type: Detached
  • Waterfront: No
  • Year Built Details: Approximate
  • Year Built Source: Owner
Location/School
  • Grade School: Carlisle Complx
  • High School: Conc/Carl Reg
  • Middle School: Carlisle Complx
Features
Interior Features
  • Appliances: Oven, Dishwasher, Trash Compactor, Countertop Range, Refrigerator, Tankless Water Heater
  • Basement Features: Full, Partially Finished, Walk Out, Interior Access, Sump Pump
  • Num of Baths: 5.0
  • Num of Full Baths: 4
  • Num of Half Baths: 1
  • Bathrooms Total Decimal: 4.50
  • Bathrooms Total Integer: 5
  • FireplaceFeatures: Family Room
  • FireplaceYN: Yes
  • Fireplaces: 1
  • Flooring: Wood, Tile, Marble, Flooring - Stone/Ceramic Tile, Flooring - Hardwood
  • Interior Features: Cathedral Ceiling(s), Ceiling Fan(s), Ceiling - Cathedral, Dining Area, Bathroom - Full, Sun Room, Kitchen, Loft, Office, Sitting Room, Bathroom, Central Vacuum
  • Interior Features: Central Vacuum, Security System
  • Laundry Features: Second Floor
  • Primary Bath: Yes
  • Window Features: Skylight
Exterior Features
  • Construction: Frame
  • Exterior Features: Balcony / Deck, Professional Landscaping, Sprinkler System, Decorative Lighting
  • Exterior Features: Professional Landscaping, Sprinkler System, Decorative Lighting, Deck, Patio
  • Lot Description: Cul-De-Sac, Wooded
  • Patio And Porch Features: Deck, Patio
  • Roof Material: Shingle
Parking Features
  • Attached Garage: Yes
  • Carport: No
  • Covered Spaces: 4.00
  • Garage: Yes
  • Garage Parking: Attached, Garage Door Opener, Heated, Paved Drive, Off-Street
  • Open Parking: Yes
  • Parking Features: Attached, Garage Door Opener, Heated, Paved Drive, Off-Street
  • Parking Features: Heated, Off-Street
Utilities
  • Cooling: Central Air
  • Cooling: Yes
  • Electric: 200+ Amp Service
  • Heating: Baseboard, Natural Gas
  • Heating: Yes
  • Sewer: Private Sewerage
  • Water: Private, Private Water
Room Information
Primary Bedroom
  • Room Primary Bedroom Area: 486.0
  • Room Primary Bedroom Features: Bathroom - Full,Walk-In Closet(s),Flooring - Hardwood,Countertops - Stone/Granite/Solid
  • Room Primary Bedroom Length: 18.0
  • Primary Bedroom Level: Second Floor
  • Room Primary Bedroom Width: 27.0
Bedroom 2
  • Bedroom2 Area: 224.0
  • Bedroom2 Features: Flooring - Hardwood
  • Bedroom2 Length: 14.0
  • Bedroom2 Level: Second
  • Bedroom2 Width: 16.0
Bedroom 3
  • Bedroom3 Area: 143.0
  • Bedroom3 Features: Flooring - Hardwood
  • Bedroom3 Length: 11.0
  • Bedroom3 Level: Second
  • Bedroom3 Width: 13.0
Bedroom 4
  • Bedroom4 Area: 156.0
  • Bedroom4 Features: Flooring - Hardwood
  • Bedroom4 Length: 12.0
  • Bedroom4 Level: Second
  • Bedroom4 Width: 13.0
Bathroom 1
  • Bathroom1 Area: 32.0
  • Bathroom1 Features: Bathroom - Half
  • Bathroom1 Length: 4.0
  • Bathroom1 Level: First
  • Bathroom1 Width: 8.0
Bathroom 2
  • Bathroom2 Area: 56.0
  • Bathroom2 Features: Bathroom - Full
  • Bathroom2 Length: 8.0
  • Bathroom2 Level: Second
  • Bathroom2 Width: 7.0
Bathroom 3
  • Bathroom3 Area: 64.0
  • Bathroom3 Features: Bathroom - Full
  • Bathroom3 Length: 8.0
  • Bathroom3 Level: Second
  • Bathroom3 Width: 8.0
Family Room
  • Family Room Area: 416.0
  • Family Room Features: Flooring - Hardwood
  • Family Room Length: 26.0
  • Family Room Level: First
  • Family Room Width: 16.0
Kitchen
  • Kitchen Area: 196.0
  • Kitchen Length: 14.0
  • Kitchen Level: First
  • Kitchen Width: 14.0
Living Room
  • Room Living Room Area: 312.0
  • Room Living Room Features: Flooring - Hardwood
  • Room Living Room Length: 24.0
  • Room Living Room Level: First
  • Room Living Room Width: 13.0
Other Room 1
  • Room Office Area: 273.0
  • Room Office Features: Flooring - Hardwood
  • Room Office Length: 21.0
  • Room Office Level: Basement
  • Room Office Width: 13.0
Property Information
Property Info
  • UFFI: Unknown
  • Year Round: Yes
  • Farm Land Area Units: Square Feet
  • Lot Size Units: Acres
  • Road Frontage Type: Public
  • Road Surface Type: Paved
Tax Information
  • Tax ID: 433158
  • Assessments: $936,100
  • Book: 176
  • Tax Year: 2008
  • Zoning: res
Building / Association Information
Living Characteristics
  • Beds Total: 4
Other Building Characteristics
  • Foundation: Concrete Perimeter
  • Foundation Area: 0.0
  • Heat Zones: 4
Complex & Association Information
  • Association Security: Security System
Market and Agent Information
Sale Info
  • Buyer Broker Comp: 2.0
  • Other Agent Compensation: 2.0

Property History for 174 Sunset Road

DateEvent & SourcePriceAppreciation
May 14, 2008

Sold (Public Record)

Public Record #238436938

$1,038,000

+34.7% / yr

May 14, 2008

Sold

MLS PIN #70661982

$1,038,000
Mar 31, 2008

Contingent

MLS PIN #70661982

DateEvent & SourcePrice
05/14/2008

Sold (Public Record)

Public Record #238436938

$1,038,000

+34.7% / yr

05/14/2008

Sold

MLS PIN #70661982

$1,038,000
03/31/2008

Contingent

MLS PIN #70661982

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 174 Sunset Road

Taxable ValueLand$545,000Additions$1,020,400Total$1,565,400
Tax Record2025$20,632 ($1,719 / month)
Home Facts
Beds4Baths4.5Total Finished SqFt4,146 SqFtAbove Grade Finished SqFt4,146 SqFtUnfinished Basement SqFt603 SqFtStories2Lot Size88,427 SqFtStyleSingle Family ResidenceYear Built1982ZoningBCountyMIDDLESEXAPNCARL M:0027 B:007G L:22Fireplace TypeHas Fireplace

Schools near 174 Sunset Road

This home is within Concord-Carlisle School District.
Rating
School
Type
Grades
Distance
Public - PK to 8
Public - 9 to 12
Rating
School
Distance
Carlisle School
PublicPK to 8

Concord Carlisle High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Nearby off-market homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Realty - Concord, Brigitte Senkler

The property listing data and information, or the images, set forth herein were provided to MLS Property Information Network, Inc., Martha's Vineyard MLS, CCIMLS, Link MLS, and Berkshire County Board of REALTORS from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc., Martha's Vineyard MLS, CCIMLS, Link MLS, and Berkshire County Board of REALTORS. 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. MLS Property Information Network, Inc., Martha's Vineyard MLS, CCIMLS, Link MLS, and Berkshire County Board of REALTORS 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.