Skip to content
Skip to content
TopHapOpen in map
CondominiumResidential

247 N Main St

ANDOVER, MA 01810
13.13 ac
Lot SizeThe size of the land the home sits on, from county records.
1965
Year BuiltThe year the home was originally built, according to county records.
2
StoriesHow many floors the home has above ground.
Built 196512 units1,340–1,340 ft²
$4.8M
All units combinedThe sum of our current value estimates for every unit in the building — roughly what the whole building's homes are worth together.
$412K
Median unit valueThe middle unit value in this building by our estimate: half the units are worth more, half less.
$307
Median $/ft²The middle price per square foot across the building's units, by our current estimates. Useful for comparing units of different sizes.

-27.7%vs the Andover ZIP median sale $/ft² ($425)

Sales Performance

—
Median sale (12 mo)The middle sale price among this building's units that sold in the last 12 months, from recorded deeds.
—
1-yr changeHow the building's median sale price over the last 12 months compares with the 12 months before that.
0
Sales (12 mo)Units in this building that sold in the last 12 months, from recorded arms-length deeds.
0.0%
Turnover (12 mo)The share of units that changed hands in the last 12 months. Around 4–6% a year is typical; much higher can signal investor churn or a wave of exits.
This building's own appreciationThe building's own appreciation: for every unit that sold twice (held over a year), we compute its yearly price change between the two sales and take the middle value. This is the cleanest read on how this specific building performs, because it compares each unit to itself.
+3.9%per yeartypical hold 7.3 yrsfrom 14 same-unit resales
Median sale price (yearly, all time)Every recorded arms-length sale in the building since records begin, grouped by year: the bars count sales and the line tracks the median price paid.MedianSales
19881992199820022009201920222024
Sale price per ft² (yearly, all time)The middle price per square foot across the building's units, by our current estimates. Useful for comparing units of different sizes.$/ft²
19881992199820022009201920222024

27 arms-length sales on record for this building.

Unit Mix & Floor PlansThe building's recurring floor plans, found by grouping units with identical beds, baths and square footage in county records. Larger groups are the building's standard layouts; leftover units have one-off sizes.

Every unit: size vs estimated valueEvery unit in the building as one dot: across is its size, up is our current value estimate, and color is its bedroom count. Vertical columns of dots are recurring floor plans; the height spread within a column shows how much floor, view and condition move prices for the same layout.
$327K$358K$390K$422K1,340 ft²1,340 ft²1,340 ft²1,340 ft²1,340 ft²1,340 ft²
2 bd
2 bed
12 units
Recurring floor plansThe building's recurring floor plans, found by grouping units with identical beds, baths and square footage in county records. Larger groups are the building's standard layouts; leftover units have one-off sizes.
2 bd · 2 ba · 1,340 ft²
12 units

Value DistributionHow the building's units spread across value ranges by our current estimates. A wide spread usually means big differences in size, floor or view.

$327K–$327K
1 unit
$385K–$385K
1 unit
$394K–$398K
2 units
$399K–$399K
1 unit
$410K–$422K
7 units

Ownership & Financing

Owner-occupiedThe share of units where the owner lives in the unit, per county records. The rest are second homes or rentals.92%
Company-ownedUnits owned through an LLC, trust, or other company — a rough proxy for investor ownership.0%
Typical owner tenureThe middle number of years since each unit last changed hands — how long the current owners have been in place.5.5 yrs
Cash purchases (5 yrs)The share of purchases in the last 5 years with no mortgage recorded. High cash share is common in second-home and investor buildings.33%
Avg. loan-to-valueAverage current loan balance against unit value across the building. Low numbers mean owners hold lots of equity — a sign of financial stability.39%
Median owner equityThe middle dollar amount of equity (value minus loans) unit owners hold in this building.$405,197
Median tax billThe middle annual property tax bill among the building's units.$4,144
Pre-foreclosure noticesUnits with an active pre-foreclosure or foreclosure notice on file.0

Recent SalesThe latest recorded arms-length sales in the building, newest first.

Unit 4Oct 29, 2024$310,000Unit 4Oct 20, 2023$310,000Unit 2Oct 10, 2023$315,000Unit 5Nov 1, 2022$275,000Unit 3Mar 2, 2022$317,500Unit 12Feb 11, 2022$315,000Unit 8Aug 30, 2021$288,000Unit 7Jan 20, 2021$272,500Unit 7Aug 24, 2020$200,000Unit 9Sep 6, 2019$234,500

Values are TopHap estimates, not appraisals. Sales, ownership and tax figures come from recorded county documents via ATTOM and can lag by several weeks.

Climate Risk

Projected Flood DepthHow deep a serious flood is expected to get here at some point in the next 30 years. Shown in inches.197 in
30-Year Flood ChanceThe chance of at least one serious flood here in the next 30 years, not in any single year.51%
FEMA Flood ZoneFEMA's flood zone for this address. Zones starting with A or V are high risk, and lenders usually require flood insurance there.1 percent flood zone

Scores 0–100; higher = greater projected risk.

Property Facts

Property TypeThe broad category the county puts this property in, such as residential or commercial.Condominium
StyleThe architectural style of the home, such as ranch or colonial.Condo/Apartment
CountyESSEX
ConstructionThe main material the home's frame and walls are built from.Frame (Unspecified)
RoofThe main material covering the roof, such as asphalt shingle or tile.Asphalt
HeatingThe type of heating system in the home.Hot Water
PoolWhether the property has a pool, and what kind, such as in-ground.No

Assigned SchoolsThe public schools this address is zoned for. Boundaries change, so confirm with the district before you count on it.

M
West Middle SchoolA+
Middle · Grades 6–8 · 0.6 mi
H
Andover High SchoolA
High · Grades 9–12 · 0.8 mi
E
West Elementary SchoolA-
Elementary · Grades KG–5 · 1.4 mi

District: Andover School District

Neighborhood · ZIP 01810These are comparison scores, not percentages. 100 equals the national average, so 150 means about 50% above average.

CrimeLocal crime compared with the rest of the country, where 100 is average. It reflects things like population density, income, and how crime gets reported.41
Air pollutionOverall air pollution compared with the rest of the country, where 100 is average. Lower is cleaner.99
EarthquakeEarthquake risk and likely building damage compared with the rest of the country, where 100 is average. Scores can run far above 100.90

Index scale: 100 = US average (tick). Lower is better.

Homes occupiedThe share of homes here that someone lives in. The rest sit empty, including vacation and for-sale homes.96%
Bachelor's or higherThe share of adults 25 and older whose highest degree is a bachelor's degree.35%
Poverty rateThe share of people whose household income falls below the federal poverty line, which varies by family size.3.0%
UnemploymentThe share of men 16 and older who are out of work and actively looking. Only men are counted in this figure.1.4%
PopulationHow many people live in this area.37,155
DensityPeople per square mile. Higher numbers mean a more crowded, urban area.1,160 / mi²
Median incomeThe middle household income here — half of households earn more, half earn less.$155,617
Average incomeThe average household income. It runs higher than the median when a few high earners pull it up.$207,356
Average tempThe average temperature here across a full year.48°F
Annual precipHow much rain and melted snow falls here in a typical year.46 in
SunshineThe share of daylight hours that get direct sun in a typical year, counting cloud cover.58%

All UnitsEvery property record the county has at this street address, such as the units in a condo building. Prices shown are our estimates, not asking prices.

247 N Main St # 1
2 bd · 2 ba · 1,340 ft²
$394K
247 N Main St
2 bd · 2 ba · 1,340 ft²
$385K
247 N Main St # 3
2 bd · 2 ba · 1,340 ft²
$415K
247 N Main St
2 bd · 2 ba · 1,340 ft²
$327K
247 N Main St # 5
2 bd · 2 ba · 1,340 ft²
$398K
247 N Main St # 6
2 bd · 2 ba · 1,340 ft²
$410K
247 N Main St
2 bd · 2 ba · 1,340 ft²
$422K
247 N Main St # 8
2 bd · 2 ba · 1,340 ft²
$413K
247 N Main St # 9
2 bd · 2 ba · 1,340 ft²
$399K
247 N Main St # 10
2 bd · 2 ba · 1,340 ft²
$420K
247 N Main St # 11
2 bd · 2 ba · 1,340 ft²
$414K
247 N Main St # 12
2 bd · 2 ba · 1,340 ft²
$414K

Data by ATTOM. Valuations are automated estimates, not appraisals. Photos from Google Street View and may not depict the current property state.

About 247 N Main St

How many units are in 247 N Main St, Andover, MA?

247 N Main St, Andover, MA has 12 residential units across built in 1965, according to county assessor records.

What is a unit at 247 N Main St, Andover, MA worth?

The median TopHap Estimate across the 12 units at 247 N Main St, Andover, MA is $411,523. That works out to $307 per square foot. Units run from 1,340 to 1,340 square feet. Estimates are modelled from recorded sales and assessments, not appraisals.

Is 247 N Main St, Andover, MA expensive for Andover?

Units at 247 N Main St, Andover, MA carry a median of $307 per square foot, 28% below the Andover median of $425 per square foot.

How often do units sell at 247 N Main St, Andover, MA?

0 units at 247 N Main St, Andover, MA sold in the last 12 months, out of 27 recorded arms-length sales all time. That is a turnover rate of 0.0% of the building per year.

Have units at 247 N Main St, Andover, MA appreciated?

Across 14 repeat sales of the same unit, 247 N Main St, Andover, MA returned a median 3.9% per year. Because each pair is the same unit bought and sold, the figure is not distorted by which units traded. The median owner held for 7.3 years.

What floor plans does 247 N Main St, Andover, MA have?

The most common plan at 247 N Main St, Andover, MA is a 2-bedroom of 1,340 square feet, repeated 12 times, with a median estimate of $411,523. TopHap identifies 1 recurring plans in the building.

More homes on N Main St

Closest homes

More homes in Andover 01810

Assigned schools

Explore the area

See this home in context

Open 247 N Main St on TopHap’s interactive map to compare it against every sale nearby, overlay school zones and flood risk, and run a CMA.

Open in map
A flyover of TopHap's photorealistic 3D map, with recorded sale prices pinned to homes
Search any address, city, zip, or county…3D$1.9M$6.25MOpen in map