NOT LISTED FOR SALE

40 Duncan Dr North Andover, MA 01845

Estimated Value: $1,265,000 - $1,547,000

4 Beds
2.5 Baths
2,710 Sq Ft
$525/Sq Ft Est. Value

Last Sold November 30, 2023

Last sale price $1,325,000 $489 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $8,501/month

4 Days on Market

Highlights

  • Community Stables
  • Barn or Stable
  • 12.54 Acre Lot
  • North Andover High School Rated A-
  • Scenic Views
  • Custom Closet System

About This Home

As of November 2023

This property has the character and seclusion of a rural property, but less than 30 minutes to Boston. Perfect for a training and boarding business or ride your personal horses year round. 12 stalls, 12’ center Isle, ATTACHED 60 X 90 indoor arena, 200 X70 Outdoor Dressage Arena. 5 fenced paddocks. Lush meadows and fields for heavenly turnout. This quaint 1717 antique farmhouse includes four bedrooms, 2.5 baths and an updated kitchen. You must see this! PLEASE DO NOT ENTER DRIVEWAY WITHOUT APPT.

Last Agent to Sell the Property

Gerri Bernstein

Equine Homes Real Estate, LLC Listed on: 09/25/2023

Last Buyer's Agent

Valerie Previte

Classified Realty Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,452

Year Built

  • Built in 1711 | Remodeled

Lot Details

  • 12.54 Acre Lot
  • Property fronts a marsh
  • Fenced
  • Landscaped Professionally
  • Level Lot
  • Cleared Lot
  • Wooded Lot
  • Marsh on Lot
  • Property is zoned R1

Parking

  • 3 Car Detached Garage
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Antique Architecture
  • Farmhouse Style Home
  • Stone Foundation
  • Frame Construction
  • Blown-In Insulation
  • Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,710 Sq Ft Home
  • Skylights
  • 1 Fireplace
  • Insulated Windows
  • Entryway
  • Home Office
  • Sun or Florida Room
  • Scenic Vista Views
  • Storm Doors

Kitchen

  • ENERGY STAR Qualified Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Pine Flooring
  • Wall to Wall Carpet
  • Ceramic Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary bedroom located on second floor
  • Custom Closet System
  • Walk-In Closet
  • Bathtub with Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Basement

  • Partial Basement
  • Block Basement Construction
  • Crawl Space

Outdoor Features

  • Bulkhead
  • Enclosed Patio or Porch

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Paddocks
  • Barn or Stable

Utilities

  • Window Unit Cooling System
  • 2 Heating Zones
  • Heating System Uses Oil
  • Baseboard Heating
  • 200+ Amp Service
  • Natural Gas Connected
  • Water Treatment System
  • Private Water Source
  • Private Sewer
  • High Speed Internet

Additional Features

  • Property is near schools
  • Farm

Listing and Financial Details

  • Tax Block 0056
  • Assessor Parcel Number 104.B00560000.0,2070836

Community Details

Overview

  • No Home Owners Association
  • Near Conservation Area

Amenities

  • Shops

Recreation

  • Community Stables
  • Jogging Path

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,452

Year Built

Built in 1711 | Remodeled

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Farm
  • Architectural Style: Colonial, Antique, Farmhouse
  • Year Built: 1711
  • Year Built Details: Approximate
  • SUB AGENCY OFFERED: No
  • Year Round: Yes
  • Compensation Based On: Gross/Full Sale Price
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Wood, Tile, Vinyl, Carpet, Pine, Flooring - Wood
  • Interior Amenities: Sun Room, Entry Hall, Home Office-Separate Entry, Internet Available - Broadband
  • Door Features: Storm Door(s)
  • Fireplace YN: Yes
  • Fireplaces: 1
  • Appliances: Refrigerator,Washer,Dryer,Water Treatment,ENERGY STAR Qualified Dishwasher, Utility Connections for Gas Range, Utility Connections for Electric Oven, Utility Connections for Electric Dryer
  • Total Bedrooms: 4
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Flooring - Wall to Wall Carpet
  • Room Bedroom3 Features: Flooring - Wood
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Level: Second
  • Room Bedroom4 Features: Flooring - Wall to Wall Carpet
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bathrooms: 3
  • Room Master Bedroom Features: Bathroom - Full, Walk-In Closet(s), Closet/Cabinets - Custom Built
  • Room Master Bedroom Level: Second
  • Master Bathroom Features: Yes
  • Bathroom 1 Features: Bathroom - Half
  • Bathroom 1 Level: First
  • Bathroom 2 Level: Second
  • Bathroom 2 Features: Bathroom - Full, Bathroom - With Tub, Flooring - Vinyl
  • Bathroom 3 Features: Bathroom - Full, Bathroom - With Tub & Shower, Remodeled
  • Bathroom 3 Level: Second
  • Room Dining Room Features: Flooring - Wood
  • Room Dining Room Level: Main,First
  • Room Family Room Level: Main,First
  • Room Family Room Features: Flooring - Wood
  • Room Kitchen Level: Main,First
  • Room Kitchen Features: Skylight, Flooring - Stone/Ceramic Tile, Pantry, Kitchen Island, Remodeled
  • Laundry Features: Flooring - Wood, First Floor
  • Room Living Room Level: Main,First
  • Room Living Room Features: Closet/Cabinets - Custom Built, Flooring - Wood
  • Room Office Level: Second
  • Basement: Partial, Crawl Space, Bulkhead, Concrete
  • Living Area: 2710
  • Spa YN: No
  • Window Features: Insulated Windows
  • MAIN LO: K95330
  • MAIN SO: M59500
  • Insulation: Blown In

Exterior Features

  • Exterior Features: Porch, Porch - Enclosed, Patio, Barn/Stable, Paddock, Professional Landscaping, Horses Permitted
  • Construction Materials: Frame, Other
  • Fencing: Fenced/Enclosed
  • Foundation Details: Concrete Perimeter, Stone
  • Home Warranty YN: No
  • Horse YN: Yes
  • Other Structures: Barn/Stable
  • Patio And Porch Features: Porch, Porch - Enclosed, Patio
  • Road Frontage Type: Public
  • Roof: Shingle
  • View: Scenic View(s)
  • View YN: Yes
  • Waterfront YN: No
  • Waterview Flag: Yes

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage YN: No
  • Carport Y N: No
  • Covered Parking Spaces: 3
  • Garage YN: Yes
  • Parking Features: Detached, Off Street
  • Total Parking Spaces: 12

Utilities

  • Sewer: Private Sewer
  • Utilities: for Gas Range, for Electric Oven, for Electric Dryer
  • Cooling: Window Unit(s)
  • Heating: Baseboard, Oil, Electric
  • Cooling Y N: Yes
  • Electric: 200+ Amp Service
  • Heating YN: Yes
  • Water Source: Private
  • HEAT ZONES: 2

Condo/Co-op/Association

  • Association YN: No
  • Community Features: Shopping, Walk/Jog Trails, Stable(s), Conservation Area, Highway Access, House of Worship, Private School, Public School
  • Senior Community YN: No

Lot Info

  • Parcel Number: 104.B00560000.0,2070836
  • Zoning: R1
  • Farm Land Area Units: Square Feet
  • Horse Amenities: Paddocks
  • Lot Features: Wooded, Cleared, Farm, Gentle Sloping, Level, Marsh
  • Lot Size Acres: 12.54
  • Lot Size Sq Ft: 546242
  • Lot Size Units: Acres
  • ResoLotSizeUnits: Acres

Green Features

  • Green Energy Efficient: Other (See Remarks)

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 11452
  • Tax Block: 0056
  • Tax Lot: 0000.0

Multi Family

  • Basement Included Sq Ft: No
  • Waterview: Marsh

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 25, 2023
Closed on
Nov 30, 2023
Sold by
Karen A Mello Ret and Mello
Bought by
Town-Long Stables Llc
Seller's Agent
Gerri Bernstein
Equine Homes Real Estate, LLC
Buyer's Agent
Valerie Previte
Classified Realty Group
List Price
$1,325,000
Sold Price
$1,325,000
Views
76
Current Estimated Value
$1,423,524

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$98,524
Avg. Annual Appreciation
3.69%
Original Mortgage
$993,750
Outstanding Balance
$976,015
Interest Rate
7.63%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$447,509

Purchase Details

Closed on
Aug 3, 2023
Sold by
Mello Karen A
Bought by
Karen A Mello Ret and Mello

Purchase Details

Closed on
May 10, 2023
Sold by
Jackson Shelley L
Bought by
Mello Karen A

Purchase Details

Closed on
Mar 4, 2013
Sold by
Mello Karen A and Jackson Shelley M
Bought by
Mello Karen A and Jackson Shelley M

Purchase Details

Closed on
Aug 30, 2012
Sold by
Mckew Rt and Mckew
Bought by
Mello Karen A and Jackson Shelley L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$320,000
Interest Rate
4%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 16, 2006
Sold by
Mckew Howard J and Mckew Joyce C
Bought by
Mckew Rt and Mckew Joyce C

Purchase Details

Closed on
Jan 31, 1996
Sold by
Love Martha A
Bought by
Mckew Howard J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$203,150
Interest Rate
7.25%
Mortgage Type
Purchase Money Mortgage
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
Town-Long Stables Llc $1,325,000 None Available
Karen A Mello Ret -- None Available
Mello Karen A -- None Available
Mello Karen A -- --
Mello Karen A $770,000 --
Mckew Rt -- --
Mckew Howard J $321,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Town-Long Stables Llc $993,750
Previous Owner Mckew Howard J $320,000
Previous Owner Mckew Howard J $203,150
Closed Mckew Howard J $53,650
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/30/2023 11/30/23 Sold $1,325,000 0.0% $489 / Sq Ft
09/30/2023 09/30/23 Pending -- -- --
09/25/2023 09/25/23 For Sale $1,325,000 -- $489 / 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 $12,066 $1,071,600 $552,300 $519,300
2024 $11,229 $1,012,500 $530,500 $482,000
2023 $10,628 $868,300 $435,600 $432,700
2022 $10,648 $787,000 $402,900 $384,100
2021 $10,463 $738,400 $376,800 $361,600
2020 $10,146 $738,400 $376,800 $361,600
2019 $9,902 $738,400 $376,800 $361,600
2018 $10,729 $738,400 $376,800 $361,600
2017 $10,469 $733,100 $294,600 $438,500
2016 $10,075 $706,000 $290,700 $415,300
2015 $9,903 $688,200 $287,400 $400,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 73163290

MLS Property Information Network (MLS PIN)

APN: NAND-000104B-000056