NOT LISTED FOR SALE

17 Sgt Roode Ln Middleton, MA 01949

Estimated Value: $1,355,000 - $1,464,372

4 Beds
3.5 Baths
4,438 Sq Ft
$322/Sq Ft Est. Value

Last Sold August 31, 2023

Last sale price $1,250,000 $282 Per Sq Ft

Est. 14% increase in value since last sale

Current estimated payment $8,704/month

12 Days on Market

Highlights

  • Medical Services
  • In Ground Pool
  • Landscaped Professionally
  • Masconomet Regional Middle School Rated A-
  • Colonial Architecture
  • Family Room with Fireplace

About This Home

As of August 2023

Impressive 4+ bedroom Colonial with in-law suite over the garage. Go directly from your 4-car garage to the Great Room with cathedral ceiling, fieldstone fireplace and light-filled all-season sunroom. The oversized kitchen offers large center island, granite countertops, stainless appliances, and new gas range. Sliders open to the patio with built-in Jenn-Air grill. A formal living room and dining room complete the 1st floor. Primary bedroom with a cathedral ceiling, walk-in closet and en-suite bath with tiled shower and jacuzzi tub plus 3 more nice sized bedrooms and full bath are on the 2nd floor. Take advantage of extra space in the partially finished lower level. A finished suite (with full bath and kitchenette) over the garage is ideal for home office, guest room or extended family. Enjoy “staycations” in the backyard oasis with a well-watered, manicured lawn and resort-like patio, heated Gunite pool with waterfall and pool house. You will want to stay forever!

Last Agent to Sell the Property

Sheri Trocchi

J. Barrett & Company Listed on: 05/31/2023

Last Buyer's Agent

Marc Ouellet

Lamacchia Realty, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,844

Year Built

  • Built in 1994

Lot Details

  • 0.92 Acre Lot
  • Near Conservation Area
  • Fenced Yard
  • Landscaped Professionally
  • Sprinkler System
  • Property is zoned R1B

Parking

  • 4 Car Attached Garage
  • Parking Storage or Cabinetry
  • Heated Garage
  • Garage Door Opener
  • Driveway
  • Open Parking
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Frame Construction
  • Shingle Roof
  • Radon Mitigation System
  • Concrete Perimeter Foundation

Interior Spaces

  • 4,438 Sq Ft Home
  • Central Vacuum
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Insulated Windows
  • Insulated Doors
  • Family Room with Fireplace
  • 2 Fireplaces
  • Dining Area
  • Bonus Room
  • Sun or Florida Room
  • Home Security System
  • Attic

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Trash Compactor

Flooring

  • Wood
  • Wall to Wall Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Soaking Tub
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry on main level
  • Washer and Electric Dryer Hookup

Basement

  • Partial Basement
  • Garage Access
  • Sump Pump

Outdoor Features

  • In Ground Pool
  • Patio
  • Outdoor Storage

Schools

  • Fuller/Howe Elementary School
  • Masconomet Middle School
  • Masconomet High School

Utilities

  • Forced Air Heating and Cooling System
  • 2 Cooling Zones
  • 3 Heating Zones
  • Heating System Uses Natural Gas
  • 200+ Amp Service
  • Private Water Source
  • Water Heater
  • Private Sewer

Additional Features

  • Energy-Efficient Thermostat
  • Property is near schools

Community Details

Overview

  • No Home Owners Association

Amenities

  • Medical Services
  • Shops

Recreation

  • Park
  • Jogging Path

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,844

Year Built

Built in 1994

Lot Details

0

Parking

4

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Colonial
  • Year Built: 1994
  • Buyer Agency: 2
  • Transaction Broker: 1
  • Year Built Details: Actual
  • SUB AGENCY OFFERED: No
  • Compensation Based On: Gross/Full Sale Price
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: Other
  • Special Features: VirtualTour

Interior Features

  • Flooring: Tile, Hardwood, Flooring - Stone/Ceramic Tile, Flooring - Wall to Wall Carpet, Laminate
  • Interior Amenities: Cathedral Ceiling(s), Ceiling Fan(s), Walk-In Closet(s), Dining Area, Bathroom - 3/4, Bathroom - With Shower Stall, Sun Room, Bonus Room, Kitchen, Bathroom, Central Vacuum, Walk-up Attic
  • Door Features: Insulated Doors
  • Fireplace Features: Family Room
  • Fireplace YN: Yes
  • Fireplaces: 2
  • Appliances: Water Heater, Range, Oven, Dishwasher, Trash Compactor, Microwave, Refrigerator
  • Total Bedrooms: 4
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Ceiling Fan(s), Closet, Flooring - Hardwood
  • Room Bedroom2 Area: 120
  • Room Bedroom3 Features: Ceiling Fan(s), Closet, Flooring - Hardwood
  • Room Bedroom3 Area: 165
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Area: 195
  • Room Bedroom4 Level: Third
  • Room Bedroom4 Features: Ceiling Fan(s), Closet, Flooring - Hardwood
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bathrooms: 4
  • Total Bathrooms: 3.5
  • Room Master Bedroom Features: Cathedral Ceiling(s), Ceiling Fan(s), Walk-In Closet(s), Flooring - Hardwood, Recessed Lighting
  • Room Master Bedroom Level: Second
  • Room Master Bedroom Area: 260
  • Master Bathroom Features: Yes
  • Bathroom 1 Features: Bathroom - Half
  • Bathroom 1 Level: First
  • Bathroom 2 Level: Second
  • Bathroom 2 Features: Bathroom - Half, Bathroom - With Shower Stall
  • Bathroom 3 Features: Bathroom - Half, Bathroom - Tiled With Tub & Shower, Jacuzzi / Whirlpool Soaking Tub
  • Bathroom 3 Level: Second
  • Room Dining Room Features: Flooring - Hardwood
  • Room Dining Room Level: First
  • Room Dining Room Area: 182
  • Room Family Room Level: First
  • Room Family Room Features: Cathedral Ceiling(s), Ceiling Fan(s), Flooring - Hardwood
  • Room Family Room Area: 360
  • Room Kitchen Level: First
  • Room Kitchen Features: Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Kitchen Island, Recessed Lighting
  • Room Kitchen Area: 390
  • Laundry Features: Electric Dryer Hookup, Washer Hookup, First Floor
  • Room Living Room Level: First
  • Room Living Room Area: 234
  • Room Living Room Features: Flooring - Hardwood
  • Basement: Partial, Garage Access, Sump Pump, Radon Remediation System
  • Living Area: 4438
  • Spa YN: No
  • Window Features: Insulated Windows
  • MAIN LO: C95243
  • LIST PRICE PER Sq Ft: 304.19
  • PRICE PER Sq Ft: 281.66
  • MAIN SO: C95006
  • Insulation: Full

Exterior Features

  • Exterior Features: Patio, Pool - Inground, Storage, Professional Landscaping, Sprinkler System, Fenced Yard
  • Construction Materials: Frame
  • Fencing: Fenced
  • Foundation Details: Concrete Perimeter
  • Home Warranty YN: No
  • Patio And Porch Features: Patio
  • Pool Features: In Ground
  • Pool Private YN: Yes
  • Road Frontage Type: Public
  • Roof: Shingle
  • Waterfront YN: No
  • Waterview Flag: No

Garage/Parking

  • Garage Spaces: 4
  • Attached Garage YN: Yes
  • Carport Y N: No
  • Covered Parking Spaces: 4
  • Garage YN: Yes
  • Open Parking YN: Yes
  • Parking Features: Attached, Garage Door Opener, Heated Garage, Storage, Paved Drive, Off Street, Paved
  • Total Parking Spaces: 8

Utilities

  • Sewer: Private Sewer
  • Utilities: for Gas Range, for Gas Oven, Washer Hookup
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Cooling Y N: Yes
  • Electric: 200+ Amp Service
  • Heating YN: Yes
  • Security Features: Security System
  • Water Source: Public, Private
  • HEAT ZONES: 3
  • COOLING ZONES: 2

Condo/Co-op/Association

  • Association YN: No
  • Community Features: Shopping, Park, Walk/Jog Trails, Medical Facility, Conservation Area, Highway Access, House of Worship, Public School
  • Senior Community YN: No

Lot Info

  • Zoning: R1B
  • Farm Land Area Units: Square Feet
  • Lot Size Acres: 0.92
  • Lot Size Area: 0.92
  • Lot Size Sq Ft: 40162
  • Lot Size Units: Acres
  • Property Attached YN: No
  • PAGE: 472
  • ResoLotSizeUnits: Acres

Green Features

  • Green Energy Efficient: Thermostat

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 12844
  • Tax Book Number: 39279

Multi Family

  • Basement Included Sq Ft: Yes

MLS Schools

  • High School: Masconomet
  • Elementary School: Fuller/Howe
  • Middle Or Junior School: Masconomet

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 31, 2023
Closed on
Aug 31, 2023
Sold by
Linardos Joanne
Bought by
Connelly James M and Connelly Melissa L
Seller's Agent
Sheri Trocchi
J. Barrett & Company
Buyer's Agent
Marc Ouellet
Lamacchia Realty, Inc.
List Price
$1,350,000
Sold Price
$1,250,000
Premium/Discount to List
-$100,000
-7.41%
Views
230
Current Estimated Value
$1,427,843

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$177,843
Avg. Annual Appreciation
6.54%
Original Mortgage
$900,000
Outstanding Balance
$880,259
Interest Rate
6.78%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$547,584

Purchase Details

Closed on
Nov 12, 2020
Sold by
Flannery James T
Bought by
Flannery Joanne

Purchase Details

Listed on
Jun 10, 2016
Closed on
Aug 19, 2016
Sold by
Tremblay Ronald S
Bought by
Flannery James T and Linardos Joanne
Seller's Agent
Eric Cudmore
Century 21 North East
Buyer's Agent
Eric Cudmore
Century 21 North East
List Price
$899,999
Sold Price
$875,000
Premium/Discount to List
-$24,999
-2.78%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.50%

Purchase Details

Listed on
Jun 10, 2016
Closed on
Aug 12, 2016
Sold by
Tremblay Ronald S and Tremblay Patricia L
Bought by
Tremblay Ronald S
Seller's Agent
Eric Cudmore
Century 21 North East
Buyer's Agent
Eric Cudmore
Century 21 North East
List Price
$899,999
Sold Price
$875,000
Premium/Discount to List
-$24,999
-2.78%

Purchase Details

Closed on
Nov 17, 1993
Sold by
Fieldstone Place Corp
Bought by
Tremblay Ronald S and Tremblay Patricia
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Connelly James M $1,250,000 None Available
Connelly James M $1,250,000 None Available
Flannery Joanne $375,000 None Available
Flannery Joanne $375,000 None Available
Flannery James T $875,000 --
Flannery James T $875,000 --
Tremblay Ronald S -- --
Tremblay Ronald S -- --
Tremblay Ronald S $102,000 --
Tremblay Ronald S $102,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Connelly James M $900,000
Closed Connelly James M $900,000
Previous Owner Tremblay Ronald S $200,000
Previous Owner Tremblay Ronald S $83,000
Previous Owner Tremblay Ronald S $30,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/31/2023 08/31/23 Sold $1,250,000 -7.4% $282 / Sq Ft
06/13/2023 06/13/23 Pending -- -- --
05/31/2023 05/31/23 For Sale $1,350,000 +54.3% $304 / Sq Ft
08/18/2016 08/18/16 Sold $875,000 -2.8% $228 / Sq Ft View Prior Sale
06/18/2016 06/18/16 Pending -- -- --
06/10/2016 06/10/16 For Sale $899,999 -- $234 / Sq Ft
Source: MLS Property Information Network (MLS PIN)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $13,873 $1,166,800 $430,100 $736,700
2024 $13,455 $1,141,200 $402,100 $739,100
2023 $12,844 $998,000 $440,100 $557,900
2022 $11,433 $862,900 $348,100 $514,800
2021 $11,356 $827,700 $330,100 $497,600
2020 $11,480 $842,900 $340,100 $502,800
2019 $11,126 $812,700 $324,100 $488,600
2018 $11,088 $794,300 $318,100 $476,200
2017 $9,946 $713,000 $272,100 $440,900
2016 $9,599 $691,100 $256,100 $435,000
2015 $9,454 $686,100 $252,100 $434,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 73117807

MLS Property Information Network (MLS PIN)

APN: MIDD-000028-000000-000018P