NOT LISTED FOR SALE

15 Sheffield St Windham, NH 03087

Estimated Value: $1,374,000 - $1,664,000

4 Beds
3.5 Baths
3,544 Sq Ft
$418/Sq Ft Est. Value

Last Sold March 26, 2021

Last sale price $1,030,000 $291 Per Sq Ft

Est. 44% increase in value since last sale

Current estimated payment $9,344/month

10 Days on Market

Highlights

  • In Ground Pool
  • 5.2 Acre Lot
  • Deck
  • Golden Brook Elementary School Rated A
  • Colonial Architecture
  • Multiple Fireplaces

About This Home

As of March 2021

Welcome to your DREAM HOME with an OUTDOOR OASIS that will make you never want to leave home! This home features over 4,500 sq ft of living with 4 beds and 3.5 baths set on a private 5.2 acre lot in a desirable cul-de-sac neighborhood. Come home to be greeted by your circular driveway and stunning farmer’s porch with fieldstone. Step inside this luxury home to a grand two story entrance open to the dining room and office with fireplace. The new gourmet kitchen is straight out of a magazine with high end cabinets, quartz countertops, Wolf/Jenn Air appliances, and ship lap ceiling. The stunning kitchen is open concept to the dining area and leads into a family room with a wood burning fireplace and sunroom that leads out to a deck. The first floor also features a separate laundry space and a newly renovated ½ bath. Upstairs features a newly renovated bathroom with 3 generous sized bedrooms and master with a large walk in closet and master bath with jacuzzi. The basement is partially finished with a ¾ bath and large game room leading out to your paradise in the backyard. Lounge on your oversized patio or enjoy the heated gunite pool with waterfall. Stay warm by your stone fireplace and enjoy your built in grille and fridge. Additional features include 3 car garage with epoxy floor, central vac, irrigation, auto generator, shed and much more. Less than 1 mile to town center and close proximity to Rt 93. Delayed showing until Open House Feb 27th 1pm-3pm & Feb 28th 10am-12pm

Last Agent to Sell the Property

Angela Dowd

Keller Williams Gateway Realty/Salem License #073371 Listed on: 02/20/2021

Keller Williams Gateway Realty/Salem

Last Buyer's Agent

Shannon DiPietro

DiPietro Group Real Estate License #049965

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,040

Year Built

  • Built in 2003

Lot Details

  • 5.2 Acre Lot
  • Property is Fully Fenced
  • Landscaped
  • Lot Sloped Up
  • Irrigation
  • Wooded Lot
  • Property is zoned RDA

Parking

  • 3 Car Garage
  • Automatic Garage Door Opener
  • Circular Driveway

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Wood Frame Construction
  • Architectural Shingle Roof

Interior Spaces

  • 2-Story Property
  • Central Vacuum
  • Ceiling Fan
  • Multiple Fireplaces
  • Dining Area
  • Fire and Smoke Detector
  • Kitchen Island
  • Attic

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Whirlpool Bathtub

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Interior and Exterior Basement Entry
  • Natural lighting in basement

Outdoor Features

  • In Ground Pool
  • Deck
  • Covered Patio or Porch

Utilities

  • Forced Air Heating System
  • Heating System Uses Gas
  • 200+ Amp Service
  • Tankless Water Heater
  • Private Sewer
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Washer and Dryer
  • Legal Lot and Block 2562 / C

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,040

Year Built

Built in 2003

Lot Details

0

Parking

3

Listing Details

  • Status Detail: Closed
  • Style: Colonial
  • Directions: North Lowell Road to Camelot to Sheffield, #15 on left. Follow GPS.
  • Flood Zone: Unknown
  • Units per Building: 1
  • Construction: Existing
  • Items Excluded: Washer and Dryer
  • Total Stories: 2
  • Price Per Sq Ft: 290.63
  • Property Class: Residential
  • Property Type: Single Family
  • Year Built: 2003
  • L A1 M M S I Memberkey: 619065
  • List Agent: 282394
  • L O1 Homesnapcom: Yes
  • L O1 M M S I Officekey: 73301
  • S A1 M M S I Memberkey: 392507
  • S O1 Homesnapcom: Yes
  • S O1 M M S I Officekey: 70181
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Equipment: Central Vacuum, Irrigation System, Smoke Detector
  • Features Interior: Attic, Ceiling Fan, Dining Area, Fireplaces - 2, Kitchen Island, Laundry Hook-ups, Master BR w/ BA, Walk-in Closet, Whirlpool Tub, Laundry - 1st Floor
  • Total Bedrooms: 4
  • Flooring: Ceramic Tile, Hardwood
  • Total Bathrooms: 4
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Full Bathrooms: 2
  • Basement: Yes
  • Basement Access Type: Walkout
  • Basement Description: Daylight, Finished, Walkout, Interior Access, Exterior Access
  • Sq Ft - Apx Finished AG: 3544
  • Sq Ft - Apx Finished BG: 1000
  • Sq Ft - Apx Total: 4544
  • Sq Ft - Apx Total Finished: 4544

Exterior Features

  • Construction: Wood Frame
  • Driveway: Circular, Paved
  • Foundation: Concrete
  • Road Frontage: Yes
  • Roads: Paved, Public
  • Roof: Shingle - Architectural
  • Features Exterior: Deck, Fence - Full, Patio, Pool - In Ground, Porch - Covered

Garage/Parking

  • Garage Capacity: 3
  • Parking: Driveway, Garage
  • Garage Type: Under
  • Garage: Yes
  • Garage Description: Auto Open

Utilities

  • Electric: 200 Amp
  • Sewer: Private
  • Water: Community
  • Water Heater: Tankless
  • Heating Fuel: Gas - LP/Bottle
  • Heating: Forced Air
  • Cooling: Central AC
  • Utilities: Cable - At Site

Lot Info

  • Map: 11
  • Lot: 2562
  • Lot Sq Ft: 226512
  • Lot Acres: 5.2
  • Lot Description: Landscaped, Subdivision, Wooded
  • Surveyed: Unknown
  • Zoning: RDA
  • Deed Book: 6017
  • Deed Page: 0769
  • Deed Recorded Type: Warranty

Tax Info

  • Tax Gross Amount: 15040
  • Tax Year: 2020

MLS Schools

  • School District: Windham

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 20, 2021
Closed on
Mar 26, 2021
Sold by
Rodger David and Rodger Lisa L
Bought by
Patel Dev and Patel Meshwa
Seller's Agent
Angela Dowd
Keller Williams Gateway Realty/Salem
Buyer's Agent
Shannon DiPietro
DiPietro Group Real Estate
List Price
$950,000
Sold Price
$1,030,000
Premium/Discount to List
$80,000
8.42%
Current Estimated Value
$1,479,921

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$449,921
Avg. Annual Appreciation
7.78%
Original Mortgage
$724,500
Outstanding Balance
$651,261
Interest Rate
2.73%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$828,660

Purchase Details

Listed on
May 9, 2019
Closed on
Jul 12, 2019
Sold by
Gaiero Darren T and Gaiero Deanna R
Bought by
Rodger David and Rodger Lisa L
Seller's Agent
The Gagnon Lindquist Team
RE/MAX Innovative Properties
Buyer's Agent
Angela Dowd
Keller Williams Gateway Realty/Salem
List Price
$819,900
Sold Price
$825,000
Premium/Discount to List
$5,100
0.62%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.86%
Original Mortgage
$701,250
Interest Rate
3.9%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Nov 13, 2002
Sold by
Mpg Windham Llc
Bought by
Gaiero Darren T and Gaiero Deanna R

Purchase Details

Closed on
Sep 19, 2001
Sold by
Aladdin Dev Corp
Bought by
Unknown
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Patel Dev $1,030,000 None Available
Rodger David $825,000 --
Gaiero Darren T $172,500 --
Unknown $159,900 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Patel Dev $724,500
Previous Owner Rodger David $701,250
Previous Owner Unknown $283,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/26/2021 03/26/21 Sold $1,030,000 +8.4% $291 / Sq Ft
03/02/2021 03/02/21 Pending -- -- --
02/20/2021 02/20/21 For Sale $950,000 +15.2% $268 / Sq Ft
07/12/2019 07/12/19 Sold $825,000 +0.6% $233 / Sq Ft View Prior Sale
05/11/2019 05/11/19 Pending -- -- --
05/09/2019 05/09/19 For Sale $819,900 -- $231 / Sq Ft
Source: PrimeMLS

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
2024 $17,883 $789,900 $278,900 $511,000
2023 $16,904 $789,900 $278,900 $511,000
2022 $15,608 $789,900 $278,900 $511,000
2021 $14,639 $786,200 $278,900 $507,300
2020 $15,040 $786,200 $278,900 $507,300
2019 $13,650 $605,300 $229,800 $375,500
2018 $11,737 $605,300 $229,800 $375,500
2017 $12,227 $605,300 $229,800 $375,500
2016 $13,208 $605,300 $229,800 $375,500
2015 $13,386 $616,300 $229,800 $386,500
2014 $13,601 $566,700 $242,000 $324,700
2013 $13,941 $590,700 $242,000 $348,700
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: PrimeMLS

MLS Number: 4848062

PrimeMLS

APN: WNDM-000011-C000000-002562