247 No Main St sits in Andover, near the intersection of Route 28 and North School Street. The building is close to the Merrimack River, providing a nice natural element. This low-rise structure has 1 story and contains 35 condominium units. Built in 1965, it offers a cozy layout typical for its time.
Units range from 1,290 to 1,390 square feet, with each featuring 2 bedrooms. Prices start at $310,000, with the average closed price also at $310,000. Properties in this building generally stay on the market for about 56 days. There is a sense of community here among the residents.
The building includes several amenities that cater to active lifestyles. An in-ground pool invites relaxation, while a tennis court provides space for sporty fun. A picnic area with an in-ground barbecue pit encourages gatherings. Nearby, Washington Park adds to the green space and recreational opportunities.
Dining options are within walking distance. Restaurants like Grassfields Food & Spirits, Karma, and Thai Sweet Basil are nearby, making meals out simple. Public transportation options connect residents to Boston. This blend of convenience makes the location practical for commuters and visitors alike.
Units likely feature large balconies and floor-to-ceiling windows, enhancing the living experience. These elements invite natural light and outdoor enjoyment. With golf, parks, and public transportation nearby, the building supports both leisure and daily convenience. The overall feel is welcoming and friendly.
247 No Main St sits in Andover, near the intersection of Route 28 and North School Street. The building is close to the Merrimack River, providing a nice natural element. This low-rise structure has 1 story and contains 35 condominium units. Built in 1965, it offers a cozy layout typical for its time.
Units range from 1,290 to 1,390 square feet, with each featuring 2 bedrooms. Prices start at $310,000, with the average closed price also at $310,000. Properties in this building generally stay on the market for about 56 days. There is a sense of community here among the residents.
The building includes several amenities that cater to active lifestyles. An in-ground pool invites relaxation, while a tennis court provides space for sporty fun. A picnic area with an in-ground barbecue pit encourages gatherings. Nearby, Washington Park adds to the green space and recreational opportunities.
Dining options are within walking distance. Restaurants like Grassfields Food & Spirits, Karma, and Thai Sweet Basil are nearby, making meals out simple. Public transportation options connect residents to Boston. This blend of convenience makes the location practical for commuters and visitors alike.
Units likely feature large balconies and floor-to-ceiling windows, enhancing the living experience. These elements invite natural light and outdoor enjoyment. With golf, parks, and public transportation nearby, the building supports both leisure and daily convenience. The overall feel is welcoming and friendly.
Description
247 No Main St sits in Andover, near the intersection of Route 28 and North School Street. The building is close to the Merrimack River, providing a nice natural element. This low-rise structure has 1 story and contains 35 condominium units. Built in 1965, it offers a cozy layout typical for its time.
Units range from 1,290 to 1,390 square feet, with each featuring 2 bedrooms. Prices start at $310,000, with the average closed price also at $310,000. Properties in this building generally stay on the market for about 56 days. There is a sense of community here among the residents.
The building includes several amenities that cater to active lifestyles. An in-ground pool invites relaxation, while a tennis court provides space for sporty fun. A picnic area with an in-ground barbecue pit encourages gatherings. Nearby, Washington Park adds to the green space and recreational opportunities.
Dining options are within walking distance. Restaurants like Grassfields Food & Spirits, Karma, and Thai Sweet Basil are nearby, making meals out simple. Public transportation options connect residents to Boston. This blend of convenience makes the location practical for commuters and visitors alike.
Units likely feature large balconies and floor-to-ceiling windows, enhancing the living experience. These elements invite natural light and outdoor enjoyment. With golf, parks, and public transportation nearby, the building supports both leisure and daily convenience. The overall feel is welcoming and friendly.
247 No Main St Market Stats Last 12 months
Avg. Listed Price$329,000
Avg. Sale Price$310,000
Year over year list price0.00%
Year over year sale price0.80%
Total Listings1 Listed
Total sold1 Sold
Average Days on Market56 days
Average HOA fees per sqft$2 /monthly
Market Stats
Year over year list price0.00%
Year over year sale price0.80%
Total Listings1 Listed
Total sold1 Sold
Average Days on Market56 days
Average HOA fees per sqft$2 /monthly
Glen Gardens Estate Availability & Demand
Unit Availability
-
High availability buildings list units frequently.
Unit Availability helps to understand how often units in a particular building are listed for sale as compared with the neighborhood average. Units are rarely listed in buildings with low availability.
Unit Demand
-
Units in high-demand buildings sell quicker.
Unit Demand is a measure of quickly units in a particular building sell as compared with other buildings in the neighborhood. Units in high-demand buildings sell more quickly.
One of the standout features of living here is the abundance of amenities that come with it. Imagine waking up on a sunny Saturday and hitting the tennis courts for a friendly match or taking a refreshing dip in the pool to cool off from the summer heat. For those who enjoy the outdoors, the nearby park offers a peaceful setting for strolls or weekend picnics. You can also enjoy proximity to public transportation and highway access, making commuting a breeze!
Amenities Description
One of the standout features of living here is the abundance of amenities that come with it. Imagine waking up on a sunny Saturday and hitting the tennis courts for a friendly match or taking a refreshing dip in the pool to cool off from the summer heat. For those who enjoy the outdoors, the nearby park offers a peaceful setting for strolls or weekend picnics. You can also enjoy proximity to public transportation and highway access, making commuting a breeze!
Parking
Locker
Concierge
Elevator(s)
Central AC
Pool
Fitness Center
-
Visitors Parking
Amenities
Pool
Tennis Court(s)
Policies
In terms of rules, the building maintains a warm and welcoming atmosphere without overly restrictive policies, which is appealing if you're looking to settle in comfortably.
Pet Allowed
BBQ Permitted
Sublet Allowed
Short-term Rental Allowed
Compare with Buildings in the Neighbourhood (Last 12 Months)
Compare building's average price/sq. ft. and HOA fees/sq. ft. to buildings nearby
Building Name
Avg price per square foot
AVG HOA FEE per square foot (Monthly)
247 No Main St
-
$2 /sqft.
257 N Main St
$323/sqft.
$2 /sqft.
Washington Park Condominiums
$323/sqft.
$2 /sqft.
237 N Main St
$315/sqft.
$2 /sqft.
40 Washington Park
$380/sqft.
$2 /sqft.
Washington Park Condominiums
$433/sqft.
$2 /sqft.
Nearby Schools
247 No Main St is located in a school-accessible area of , Andover. Nearby schools within a 2-mile radius simplify daily schedules. Families benefit from convenient education access. This location promotes a balanced and family-friendly lifestyle.
Andover West Middle School
A-
Public|Grades 6–8
70 Shawsheen Rd|0.6 miles away
Shawsheen School
--
Public|Grades PK–PK
18 Magnolia Ave|0.77 miles away
Andover High School
A-
Public|Grades 9–12
80 Shawsheen Rd|0.78 miles away
Doherty Middle School
B-
Public|Grades 6–8
50 Bartlet St|1.02 miles away
West Elementary School
A-
Public|Grades KG–5
58 Beacon St|1.3 miles away
Franklin
B+
Public|Grades 1–5
2 Cypress Ter|1.56 miles away
Schools
What to know about schools
Description
247 No Main St is located in a school-accessible area of , Andover. Nearby schools within a 2-mile radius simplify daily schedules. Families benefit from convenient education access. This location promotes a balanced and family-friendly lifestyle.
Andover West Middle School
A-
Public|Grades 6–8
70 Shawsheen Rd|Less than 1 Mile Away
Shawsheen School
--
Public|Grades PK–PK
18 Magnolia Ave|Less than 1 Mile Away
Andover High School
A-
Public|Grades 9–12
80 Shawsheen Rd|Less than 1 Mile Away
Doherty Middle School
B-
Public|Grades 6–8
50 Bartlet St|1.02 Miles Away
West Elementary School
A-
Public|Grades KG–5
58 Beacon St|1.30 Miles Away
Franklin
B+
Public|Grades 1–5
2 Cypress Ter|1.56 Miles Away
Phillips Academy
--
Private|Grades 9–12
180 Main St|1.62 Miles Away
Lawrence High School
D
Public|Grades 9–12
70-71 N Parish Rd|1.62 Miles Away
Frost Elementary School
C-
Public|Grades KG–4
33 Hamlet St|1.66 Miles Away
Frost Middle School
B-
Public|Grades 5–8
33 Hamlet St|1.66 Miles Away
Community Day Charter Public School - R. Kingman Webster
A
Public|Grades PK–8
50 Pleasant St|1.73 Miles Away
South Lawrence East Elementary School
D
Public|Grades 1–5
165 Crawford St|1.96 Miles Away
Spark Academy
C
Public|Grades 6–8
165 Crawford St|1.96 Miles Away
Atkinson
C-
Public|Grades 1–5
111 Phillips Brook...|1.99 Miles Away
Transit
Located in , 247 No Main St is surrounded by 50+ public transit options within 2 miles. Residents enjoy easy access to well-connected transit routes serving key areas of Andover. Reliable public transportation simplifies commuting and enhances everyday mobility. This accessible setting promotes a connected and efficient urban lifestyle.
160 Winthrop Avenue
1.47 miles away|29 min walk
206 N Main Street
0.2 miles away|4 min walk
287 N Main Street
0.35 miles away|7 min walk
44 School Street
1.02 miles away|20 min walk
727 Waverly Road
1.16 miles away|23 min walk
Andover
0.59 miles away|12 min walk
Transit
What to know about transit
Description
Located in , 247 No Main St is surrounded by 50+ public transit options within 2 miles. Residents enjoy easy access to well-connected transit routes serving key areas of Andover. Reliable public transportation simplifies commuting and enhances everyday mobility. This accessible setting promotes a connected and efficient urban lifestyle.
HelloCondo Is The #1 Condo Search Platform And Real Estate Recommendation Engine. Search, Find And Buy The Perfect Condo And Get Matched With The Best Agents. Finding A Condo Has Never Been So Easy.
