NOT LISTED FOR SALE

40 Bear Hill Rd Windham, NH 03087

Estimated Value: $1,303,000 - $1,505,000

4 Beds
3.5 Baths
4,222 Sq Ft
$334/Sq Ft Est. Value

Last Sold February 23, 2024

Last sale price $1,375,000 $326 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $9,278/month

6 Days on Market

Highlights

  • Colonial Architecture
  • Deck
  • Wooded Lot
  • Golden Brook Elementary School Rated A-
  • Multiple Fireplaces
  • Wood Flooring

About This Home

As of February 2024

SOPHISTICATION AND DISTINCTION | perfectly situated on a private wooded lot! Architectural elegance, style, attention to detail, are hallmarks of this exquisitely designed home! The home features a well appointed gourmet kitchen with large island and dry bar / beverage fridge - providing the perfect space for entertaining family and friends! The first floor also features gleaming hardwood floors, Anderson windows, extensive millwork and a grand family room with fireplace leading to a beautiful four season room. Second Floor with hardwood throughout offers three large bedrooms, an opulent primary suite as well as a 2nd floor laundry. Finished third floor welcomes you to a fantastic recreation room/family room with either a spare bedroom or office. As you continue to explore you will be pleasantly surprised by a finished lower level with a dedicated home theatre and bath! So much to offer to include an automatic generator! This house will surely exceed your expectations! Showings begin Saturday 1/27/24

Last Agent to Sell the Property

Shannon DiPietro

DiPietro Group Real Estate License #049965 Listed on: 01/23/2024

Last Buyer's Agent

Kristyn Nelson

Nelson Real Estate NH, LLC License #067753

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,089

Year Built

  • Built in 2006

Lot Details

  • 1.17 Acre Lot
  • Landscaped
  • Level Lot
  • Irrigation
  • Wooded Lot
  • Property is zoned RD

Parking

  • 3 Car Garage

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Wood Frame Construction
  • Shingle Roof
  • Vinyl Siding
  • Stone Exterior Construction
  • Radon Mitigation System

Interior Spaces

  • 2-Story Property
  • Central Vacuum
  • Wired For Sound
  • Ceiling Fan
  • Multiple Fireplaces
  • Gas Fireplace
  • Dining Area
  • Laundry on upper level

Kitchen

  • Double Oven
  • Gas Cooktop
  • Down Draft Cooktop
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Whirlpool Bathtub

Partially Finished Basement

  • Basement Fills Entire Space Under The House
  • Walk-Up Access

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Porch

Schools

  • Golden Brook Elementary School
  • Windham Middle School
  • Windham High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • 200+ Amp Service
  • Power Generator
  • Private Water Source
  • Drilled Well
  • Tankless Water Heater
  • Liquid Propane Gas Water Heater
  • Septic Tank
  • Private Sewer
  • Leach Field
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Audio Equipment. Negotiable: Curtains & Drapes, Tools, TVs, TVs with wall brackets, Washer, Dryer
  • Legal Lot and Block 288 / E

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,089

Year Built

Built in 2006

Lot Details

0

Parking

3

Listing Details

  • Status Detail: Closed
  • Style: Colonial
  • Assessment Amount: 713000
  • Assessment Year: 2022
  • Construction: Existing
  • Items Excluded: Audio Equipment. Negotiable: Curtains & Drapes, Tools, TVs, TVs with wall brackets, Washer, Dryer
  • Total Stories: 2
  • Price Per Sq Ft: 373.44
  • Property Class: Residential
  • Property Type: Single Family
  • Year Built: 2006
  • Remarks Public: SOPHISTICATION AND DISTINCTION | perfectly situated on a private wooded lot! Architectural elegance, style, attention to detail, are hallmarks of this exquisitely designed home! The home features a well appointed gourmet kitchen with large island and dry bar / beverage fridge - providing the perfect space for entertaining family and friends! The first floor also features gleaming hardwood floors, Anderson windows, extensive millwork and a grand family room with fireplace leading to a beautiful four season room. Second Floor with hardwood throughout offers three large bedrooms, an opulent primary suite as well as a 2nd floor laundry. Finished third floor welcomes you to a fantastic recreation room/family room with either a spare bedroom or office. As you continue to explore you will be pleasantly surprised by a finished lower level with a dedicated home theatre and bath! So much to offer to include an automatic generator! This house will surely exceed your expectations! Showings begin Saturday 1/27/24
  • List Agent: 7521
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances: Cooktop - Down-Draft, Cooktop - Gas, Dishwasher, Microwave, Mini Fridge, Oven - Double, Range - Electric, Refrigerator, Wine Cooler
  • Equipment: Irrigation System, Radon Mitigation, Security System, Smoke Detectr-Hard Wired
  • Features Interior: Central Vacuum, Ceiling Fan, Dining Area, Fireplace - Gas, Fireplaces - 2, Home Theatre Wiring, Kitchen Island, Primary BR w/ BA, Whirlpool Tub, Laundry - 2nd Floor
  • Total Bedrooms: 4
  • Flooring: Carpet, Hardwood
  • Total Bathrooms: 4
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Full Bathrooms: 2
  • Basement: Yes
  • Basement Access Type: Walk-up
  • Basement Description: Bulkhead, Full, Partially Finished
  • Level 1: Level 1: Bath - 1/2, Level 1: Dining Room, Level 1: Family Room, Level 1: Foyer, Level 1: Kitchen - Eat-in, Level 1: Living Room, Level 1: Office/Study, Level 1: Sunroom
  • Level 2: Level 2: Bedroom, Level 2: Bath - Full, Level 2: Laundry Room, Level 2: Primary Bdm Ste
  • Level 3: Level 3: Bonus Room, Level 3: Great Room
  • Basement Level Rooms: Level B: Bath - 3/4, Level B: Media Room, Level B: Mudroom
  • Room 1: Dining Room, 15 x 10, On Level: 1
  • Room 2: Living Room, 15 x 12, On Level: 1
  • Room 3: Foyer, 13 x 13, On Level: 1
  • Room 4: Kitchen - Eat-in, 13 x 26, On Level: 1
  • Room 5: 1, 13 x 12
  • Room 6: Sunroom, 11 x 14, On Level: 1
  • Room 7: Family Room, 23 x 15, On Level: 1
  • Room 8: Primary BR Suite, 18 x 14, On Level: 2
  • Room 9: Bedroom, 11 x 12, On Level: 2
  • Room 10: 2, 15 x 12
  • Room 11: Bedroom, 13 x 12, On Level: 2
  • Room 12: Laundry Room, 10 x 7, On Level: 2
  • Room 13: Bonus Room, 17 x 12, On Level: 3
  • Room 14: Great Room, 17 x 25, On Level: 3
  • Room 15: Media Room, 11 x 24, On Level: Basement
  • Room 16: Mudroom, 13 x 18, On Level: Basement
  • Room 17: Bath - 3/4, On Level: Basement
  • Room 18: Bath - Full, On Level: 2
  • Room 19: Bath - Full, On Level: 2
  • Room 20: Bath - 1/2, On Level: 1
  • Sq Ft - Apx Finished AG: 3682
  • Sq Ft - Apx Finished BG: 540
  • Sq Ft - Apx Total: 5222
  • Sq Ft - Apx Total Finished: 4222
  • Sq Ft - Apx Unfinished BG: 1000

Exterior Features

  • Construction: Wood Frame
  • Driveway: Paved
  • Exterior: Stone, Vinyl
  • Foundation: Concrete
  • Road Frontage: Yes
  • Roads: Paved, Public
  • Roof: Shingle - Asphalt
  • Features Exterior: Deck, Porch

Garage/Parking

  • Garage Capacity: 3
  • Garage Type: Under
  • Garage: Yes

Utilities

  • Cable Company: Xfinity
  • Electric: 200 Amp, Generator
  • Sewer: 1500+ Gallon, Leach Field, Private, Septic
  • Water: Drilled Well, Private
  • Water Heater: Gas - LP/Bottle, Tankless
  • Heating Fuel: Gas - LP/Bottle
  • Heating: Forced Air, Multi Zone
  • Cooling: Central AC, Multi Zone
  • Electric Company: Eversource
  • Phone Company: Xfinity
  • Utilities: Cable, Internet - Cable

Schools

  • School District: Windham
  • Elementary School: Golden Brook Elementary School
  • Middle School: Windham Middle School
  • High School: Windham High School
  • Elementary School: Golden Brook Elementary School
  • High School: Windham High School

Lot Info

  • Map: 20
  • Lot: 288
  • Lot Sq Ft: 50965
  • Lot Acres: 1.17
  • Lot Description: Landscaped, Level, Wooded
  • Surveyed: Unknown
  • Zoning: RD
  • Deed Book: 6173
  • Deed Page: 726
  • Deed Recorded Type: Warranty

Tax Info

  • Tax Gross Amount: 14089
  • Tax Year: 2022

MLS Schools

  • School District: Windham
  • School Middle Jr: Windham Middle School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 23, 2024
Closed on
Feb 23, 2024
Sold by
Barakat Ahmad and Barakat Randa
Bought by
Stern Gregory A and Stern Caitlin E
Seller's Agent
Shannon DiPietro
DiPietro Group Real Estate
Buyer's Agent
Kristyn Nelson
Nelson Real Estate NH, LLC
List Price
$1,239,000
Sold Price
$1,375,000
Premium/Discount to List
$136,000
10.98%
Views
55
Current Estimated Value
$1,447,052

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$72,052
Avg. Annual Appreciation
3.59%
Original Mortgage
$600,000
Outstanding Balance
$592,368
Interest Rate
6.66%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$854,684

Purchase Details

Listed on
Aug 20, 2020
Closed on
Sep 30, 2020
Sold by
Bubb Stephen M and Bubb Nicole E
Bought by
Barakat Ahmad and Barakat Randa
Seller's Agent
Shannon DiPietro
DiPietro Group Real Estate
Buyer's Agent
Julia Martinage
Redfin Corporation
List Price
$785,000
Sold Price
$804,000
Premium/Discount to List
$19,000
2.42%

Home Financials for this Owner

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

Purchase Details

Listed on
Oct 4, 2013
Closed on
Jan 3, 2014
Sold by
Kelleher Timothy L and Kelleher Jessica L
Bought by
Bubb Stephen M and Connolly Nicole E
Seller's Agent
Shannon DiPietro
DiPietro Group Real Estate
Buyer's Agent
Michelle Kelley
Jill & Co. Realty Group - Real Broker NH, LLC
List Price
$650,000
Sold Price
$637,500
Premium/Discount to List
-$12,500
-1.92%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.49%
Original Mortgage
$510,000
Interest Rate
4.24%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 14, 2007
Sold by
Tls Landholdings Llc
Bought by
Kelleher Timothy L and Kelleher Jessica L
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
Stern Gregory A $1,375,000 None Available
Stern Gregory A $1,375,000 None Available
Barakat Ahmad $805,000 None Available
Barakat Ahmad $805,000 None Available
Bubb Stephen M $637,500 --
Bubb Stephen M $637,500 --
Kelleher Timothy L $190,000 --
Kelleher Timothy L $190,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Stern Gregory A $600,000
Closed Stern Gregory A $600,000
Previous Owner Bubb Stephen M $497,210
Previous Owner Kelleher Timothy L $510,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/23/2024 02/23/24 Sold $1,375,000 +11.0% $326 / Sq Ft
01/29/2024 01/29/24 Pending -- -- --
01/23/2024 01/23/24 For Sale $1,239,000 +54.1% $293 / Sq Ft
09/30/2020 09/30/20 Sold $804,000 +2.4% $208 / Sq Ft
08/24/2020 08/24/20 Pending -- -- --
08/20/2020 08/20/20 For Sale $785,000 +23.1% $203 / Sq Ft
12/27/2013 12/27/13 Sold $637,500 -1.9% $160 / Sq Ft
10/31/2013 10/31/13 Pending -- -- --
10/04/2013 10/04/13 For Sale $650,000 -- $163 / Sq Ft
Source: PrimeMLS

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
2024 $16,274 $718,800 $211,600 $507,200
2023 $15,258 $713,000 $211,600 $501,400
2022 $14,089 $713,000 $211,600 $501,400
2021 $13,101 $703,600 $211,600 $492,000
2020 $13,601 $711,000 $211,600 $499,400
2019 $13,268 $588,400 $193,500 $394,900
2018 $13,704 $588,400 $193,500 $394,900
2017 $11,886 $588,400 $193,500 $394,900
2016 $12,839 $588,400 $193,500 $394,900
2015 $12,780 $588,400 $193,500 $394,900
2014 $11,582 $482,600 $191,000 $291,600
2013 $11,942 $506,000 $191,000 $315,000
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: PrimeMLS

MLS Number: 4982944

PrimeMLS

APN: WNDM-000020-E000000-000288