BMN Boston

Get our mobile app!

Download on the App Store

4 Farnham Circle, Andover MA 01810

Andover, MA 01810
$1,099,000
Est. $7,064/month
4
Beds
3.5
Baths
4,401
Sq Ft
$250
Price/Sq Ft
0.77
Acres
1995
Year Built
39
Days on Market
Closed Listed May 7, 2015 • MLS# 71832081 Copied!

About this home

EXCEPTIONAL HOME LOCATED IN A SPECTACULAR CUL DE SAC. This home has a large eat in kitchen with gas cooktop on a large center island, HW floors, double sink, SS appliances and desk area with French doors leading out to a deck and brick patio area. Step up to the light and bright family room with cathedral ceiling, gas fireplace with marble surround and large picture window. Game room large enough for a pool table. Formal foyer, dining room and living room have HW flooring and gorgeous detail with wainscoting and dentil molding. Private office with tray ceiling and French doors. Upstairs has four good size bedrooms. One bedroom with shared Jack 'n' Jill bath. Guest bedroom with its own private full bath. Master bedroom has 2 walk-in closets, cathedral ceiling and private bath with step up Jacuzzi style tub, double sinks and shower. Lower level has a great exercise or playroom. Located near the Andover Country Club area but with a touch more privacy. Conveniently near highways and town.

View in the App

Save this property, schedule tours instantly, and get alerts when the price drops

Scan to download BMN Boston app Scan with phone
Get the full experience in the BMN Boston app

Public Records

Current Owner

Owner QIAO DONGMING
Mailing Address 4 FARNHAM CI, ANDOVER, MA, 01810

Land Use

Use Code 101
Description Single Family
Zoning SRB
Style COLONIAL

Tax Information

Assessed Value $1,816,200

Assessment History

Year Land Building Total Change
FY2025 $681,200 $1,135,000 $1,816,200

Sale History

Date Price Book/Page
Aug 6, 2015 $1,099,000 14332/70

Building Permit History

Issued Type / Work Status Value
Apr 6, 2026 Building Permit
101-ONE FAMILY
[B-26-442]
Permit #271314
Data: Town of Andover

Municipal Context: ANDOVER

Match: geocode_proximity (89.7% confidence) · Data as of Jun 1, 2026

Property Overview

Property Type
Single Family Residence
Listing Type
For Sale
Year Built
1995
Bedrooms
4
Full Bathrooms
3
Half Bathrooms
1
Living Area
4,401 sq ft
Total Rooms
10

Sale Statistics

Sale Overview
Original List Price: $1,199,000
Final Sale Price: $1,099,000
Difference: $100,000 (-8.3%)
Performance Metrics
91.7%
List to Sale Ratio
Sold below asking price
39
Days on Market
Average time
Price per Square Foot Analysis
Original $/sq ft: $272
Sale $/sq ft: $250
This property sold for $250 per square foot
Sale Summary

This property sold for 8.3% below the original asking price.

The property spent 39 days on market before selling.

Facts & Features

3 Car Garage
Central AC

Home Facts

Type Residential
Style Single Family Residence
Year Built 1995
Living Area 4,401 sq ft
Lot Size 0.77 acres
Bedrooms 4
Full Baths 3
Half Baths 1
Total Rooms 10

Interior

Heating Baseboard, Natural Gas
Cooling Central Air
Flooring Wood, Tile, Carpet, Flooring - Hardwood, Flooring - Wall To Wall Carpet, Flooring - Stone/ceramic Tile
Appliances Water Heater, Oven, Dishwasher, Disposal, Trash Compactor, Microwave, Range, Refrigerator, Washer, Dryer
Fireplace Family Room, Living Room
Fireplaces 2
Basement Full, Partially Finished, Interior Entry, Garage Access, Concrete
Laundry Flooring - Stone/ceramic Tile, Second Floor, Washer Hookup
Features Wainscoting, Cathedral Ceiling(s), Recessed Lighting, Bathroom - 3/4, Closet, Entrance Foyer, Media Room, Office, Bathroom, Play Room, Walk-up Attic

Exterior

Construction Frame
Architecture Colonial
Roof Shingle
Features Deck, Rain Gutters, Professional Landscaping, Sprinkler System, Decorative Lighting, Screens, Fenced Yard, Garden
Pool None
Spa None
Fencing Fenced
Patio/Porch Deck

Parking

Garage Spaces 3
Has Garage Yes
Features Under, Garage Door Opener, Paved Drive, Off Street, Paved
Total Spaces 9

Utilities

Electric Circuit Breakers
Water Public
Sewer Private Sewer
Gas None
Other For Gas Range, For Electric Oven, Washer Hookup

Financial

Annual Tax $15,687
Assessed Value $1,047,900

Interior Features

Flooring: Wood, Tile, Carpet, Flooring - Hardwood, Flooring - Wall to Wall Carpet, Flooring - Stone/Ceramic Tile
Appliances: Water Heater, Oven, Dishwasher, Disposal, Trash Compactor, Microwave, Range, Refrigerator, Washer, Dryer
Interior Features: Wainscoting, Cathedral Ceiling(s), Recessed Lighting, Bathroom - 3/4, Closet, Entrance Foyer, Media Room, Office, Bathroom, Play Room, Walk-up Attic
Windows: Insulated Windows, Screens
Basement: Full, Partially Finished, Interior Entry, Garage Access, Concrete
Laundry: Flooring - Stone/Ceramic Tile, Second Floor, Washer Hookup
Security: Security System

Construction & Materials

Style: Colonial
Year Built: 1995
Structure Type:
Exterior Materials: Frame
Roof: Shingle
Foundation: Concrete Perimeter

Heating, Cooling & Utilities

Heating: Baseboard, Natural Gas
Heating Zones: 3
Cooling: Central Air
Cooling Zones: 3
Hot Water:
Water Source: Public
Sewer: Private Sewer
Energy Features:

Exterior & Lot

Exterior Features: Deck, Rain Gutters, Professional Landscaping, Sprinkler System, Decorative Lighting, Screens, Fenced Yard, Garden
Patio & Porch: Deck
Fencing: Fenced
Other Structures:
Lot Features: Cul-De-Sac, Wooded
Road Surface: Paved

Parking & Garage

Garage Spaces: 3
Garage Type: Attached
Total Parking Spaces: 9
Parking Features: Under, Garage Door Opener, Paved Drive, Off Street, Paved

Special Features

Fireplaces: 2
Fireplace Type: Family Room, Living Room
Community Amenities: Public Transportation, Shopping, Park, Walk/Jog Trails, Golf, Medical Facility, Conservation Area, Highway Access, House of Worship, Private School, Public School, University

Location

Loading map...

Neighborhood

4 Farnham Circle, Andover MA 01810

Andover, MA 01810

Walkability

Loading Walk Score...

Nearby Schools

School District
Andover School District local
A+
School Safety 2024-25
0.4% Low
0.4% Suspensions 0.1% In-School
5.1% below state avg
E

Elementary Schools

10 schools
Saint Augustine School
1.4 mi
Grades PK-08
Anderson School
2.6 mi
Grades PK-07
The Pike School Inc
2.8 mi
Grades PK-09
Andover School of Montessori
3.6 mi
Grades PK-08
Melmark New England School
4.3 mi
Grades PK-12
Shawsheen School
0.5 mi
85 students Diverse
Grades PK
A
West Elementary School
0.5 mi | #138 of 824 | Score: 57.4
Improved 139 spots from last year
-0.8 below state avg
605 students Diverse
Rising School
Grades K-05
A+
Henry C Sanborn Elementary School
1.8 mi | #27 of 824 | Score: 64.1
Improved 14 spots from last year
+5.9 above state avg
332 students Diverse
Strong Attendance
Grades K-05
A+
High Plain Elementary School
2.3 mi | #49 of 824 | Score: 62.4
Improved 50 spots from last year
+4.2 above state avg
505 students Diverse
Rising School Diverse Student Body
Grades K-05
A+
South Elementary School
2.8 mi | #58 of 824 | Score: 61.7
Dropped 8 spots from last year
+3.5 above state avg
438 students Diverse
Strong Attendance
Grades K-05
M

Middle Schools

3 schools
A
Andover West Middle School
0.8 mi | #49 of 352 | Score: 57.0
Dropped 33 spots from last year
-1.2 below state avg
508 students Diverse
Grades 06-08
A
Doherty Middle School
1.6 mi | #41 of 352 | Score: 58.5
Improved 13 spots from last year
+0.3 above state avg
493 students Moderate
Strong Attendance
Grades 06-08
A
Wood Hill Middle School
2.7 mi | #69 of 352 | Score: 53.8
Dropped 38 spots from last year
-4.5 below state avg
317 students Diverse
Diverse Student Body Strong Attendance
Grades 06-08
H

High Schools

3 schools
A+
Andover High School
0.7 mi | #24 of 346 | Score: 72.8
Improved 10 spots from last year
+14.6 above state avg
1,609 students Diverse
20 sports • 2,968 athletes
Strong AP Program High Graduation Rate College Ready Curriculum Strong Athletics
Grades 09-12
Phillips Academy
2.0 mi
Grades 09-12
B+
Greater Lawrence Regional Vocational Technical School
2.8 mi | #140 of 346 | Score: 56.5
Improved 48 spots from last year
-1.7 below state avg
1,837 students Moderate
High Graduation Rate Rising School Career Tech Programs College Ready Curriculum
Grades 09-12
Learn about these ratings

Monthly Payment Calculator

Monthly Payment
$0
Principal, interest, taxes & insurance
Loan Amount
$0
After down payment
Total Interest
$0
Over life of loan
Total Cost
$0
Including down payment
%
Down: $0
%

Monthly Payment Breakdown

Principal & Interest $0
Property Tax $1,307
Homeowners Insurance $200
PMI (if <20% down) $0

Loan Summary

Total of 360 payments $0
Total principal paid $0
Total interest paid $0

Rate Impact

-0.5% Rate
$0/mo
Save $0/mo
Current Rate
$0/mo
+0.5% Rate
$0/mo
Cost $0/mo

Payment Over Time

Interest
Principal
Year 1
95% Interest
Year 15
50/50
Year 30
95% Principal
* Estimates only. Actual payments may vary. Consult with a lender for accurate figures.

Property History

Market Insights

40.6%
Price Range
47
Total Days on Market

Property Timeline

Current Active Listing - MLS #73528815
Full transaction history available when tracking began
🏡
Currently Listed
Jun 3, 2026
$1,849,000
MLS #73528815 - Active
Sold
Aug 6, 2015
$1,099,000
Property sold
Days on Market: 47
🏠
Listed for Sale
May 7, 2015
$1,099,000
Original listing
Agent: The Lucci Witte Team Office: William Raveis R.E. & Home Services

Price & Status History

Date Event Price Change
Jun 3, 2026 Sold $1,849,000
May 7, 2015 New Listing Added $1,099,000

Market Statistics

Days on Market
39 days
Price per Sq Ft
$250

Tax History

Year Taxes Assessment
2015 $15,687 $1,047,900

Financial Details

Annual Property Tax
$15,687
Tax Year 2015
Assessed Value
$1,047,900

Listing Information

Listing Agent The Lucci Witte Team
Listing Office William Raveis R.E. & Home Services
Agent MLS ID TM309944
Office MLS ID AN0949
Listing Data Updated Aug 6, 2015 3:46 PM EDT
Listing information is deemed reliable but not guaranteed. Data provided by MLS Property Information Network, Inc. All information should be independently verified.

Comparable Properties

Customize Comparable Search

Finding comparable properties...

Market Analytics for Andover, MA

Real-time market trends and pricing data for this area

4 Farnham Circle, Andover MA 01810 - Photo 1 4 Farnham Circle, Andover MA 01810 - Photo 2 4 Farnham Circle, Andover MA 01810 - Photo 3 4 Farnham Circle, Andover MA 01810 - Photo 4 4 Farnham Circle, Andover MA 01810 - Photo 5 4 Farnham Circle, Andover MA 01810 - Photo 6 4 Farnham Circle, Andover MA 01810 - Photo 7 4 Farnham Circle, Andover MA 01810 - Photo 8 4 Farnham Circle, Andover MA 01810 - Photo 9 4 Farnham Circle, Andover MA 01810 - Photo 10 4 Farnham Circle, Andover MA 01810 - Photo 11 4 Farnham Circle, Andover MA 01810 - Photo 12 4 Farnham Circle, Andover MA 01810 - Photo 13 4 Farnham Circle, Andover MA 01810 - Photo 14 4 Farnham Circle, Andover MA 01810 - Photo 15 4 Farnham Circle, Andover MA 01810 - Photo 16 4 Farnham Circle, Andover MA 01810 - Photo 17 4 Farnham Circle, Andover MA 01810 - Photo 18 4 Farnham Circle, Andover MA 01810 - Photo 19 4 Farnham Circle, Andover MA 01810 - Photo 20 4 Farnham Circle, Andover MA 01810 - Photo 21 4 Farnham Circle, Andover MA 01810 - Photo 22 4 Farnham Circle, Andover MA 01810 - Photo 23 4 Farnham Circle, Andover MA 01810 - Photo 24 4 Farnham Circle, Andover MA 01810 - Photo 25 4 Farnham Circle, Andover MA 01810 - Photo 26 4 Farnham Circle, Andover MA 01810 - Photo 27 4 Farnham Circle, Andover MA 01810 - Photo 28 4 Farnham Circle, Andover MA 01810 - Photo 29 4 Farnham Circle, Andover MA 01810 - Photo 30
BMN Boston Real Estate

BMN Boston Real Estate

Douglas Elliman

Your message will be sent to BMN Boston Real Estate.

Schedule a Tour