Welcome to this beautifully updated 5-bedroom, 4-bath home on a 2.47-acre city lot in a highly sought-after neighborhood and top-rated school district. Offering the perfect combination of privacy, space and convenience, this property features a fully fenced backyard with mature trees and serene pond views. The beautifully finished lower-level adds exceptional living space with in-floor heat, ideal for a family room, recreation area, or a guest suite. Recent major updates include a new roof, windows, furnace, air conditioning, carpet and more, providing peace of mind for years to come. An oversized 4-car garage offers ample room for vehicles, toys, and storage, while the energy-efficient dual fuel heating system helps maximize comfort and reduce utility costs. Acreage, modern updates, pond views, privacy, and an unbeatable location make this one-of-a-kind property a rare opportunity!
26 days
|
1,843
|
77
|
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Melissa Tyler651-308-2622,
Edina Realty, Inc.
Source: NorthstarMLS as distributed by MLS GRID,MLS#: 7118270
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 4
Full bathrooms: 2
3/4 bathrooms: 2
Bedroom
Level: Upper
Area: 195 Square Feet
Dimensions: 15 x 13
Bedroom 2
Level: Upper
Area: 132 Square Feet
Dimensions: 12 x 11
Bedroom 3
Level: Upper
Area: 143 Square Feet
Dimensions: 13 x 11
Bedroom 4
Level: Main
Area: 120 Square Feet
Dimensions: 12 x 10
Bedroom 5
Level: Lower
Area: 110 Square Feet
Dimensions: 10 x 11
Bonus room
Level: Lower
Area: 99 Square Feet
Dimensions: 9 x 11
Dining room
Level: Main
Area: 182 Square Feet
Dimensions: 13 x 14
Family room
Level: Lower
Area: 416 Square Feet
Dimensions: 13 x 32
Kitchen
Level: Main
Area: 169 Square Feet
Dimensions: 13 x 13
Living room
Level: Main
Area: 280 Square Feet
Dimensions: 20 x 14
Office
Level: Main
Area: 110 Square Feet
Dimensions: 10 x 11
Heating
Forced Air, In-Floor Heating
Cooling
Central Air
Appliances
Included: Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Water Softener Owned
Laundry: Electric Dryer Hookup, Gas Dryer Hookup, Washer Hookup
Features
Basement: Finished,Storage Space,Walk-Out Access
Number of fireplaces: 1
Fireplace features: Gas
Interior area
Total structure area: 3,505
Total interior livable area: 3,345 sqft
Finished area above ground: 2,185
Finished area below ground: 1,160
Property
Parking
Total spaces: 4
Parking features: Attached, Concrete, Electric, Floor Drain, Garage, Garage Door Opener, Heated Garage, Insulated Garage, Other
Attached garage spaces: 4
Has uncovered spaces: Yes
Accessibility
Accessibility features: None
Features
Levels: Modified Two Story
Stories: 2
Patio & porch: Deck, Front Porch, Patio
Fencing: Full
Waterfront features: Pond
Lot
Size: 2.47 Acres
Dimensions: 125 x 553 x 309 x 486
Features: Irregular Lot, Tree Coverage - Heavy
Details
Foundation area: 1320
Parcel number: 143224410016
Zoning description: Residential-Single Family
Construction
Type & style
Home type: SingleFamily
Property subtype: Single Family
Materials
Roof: Age 8 Years or Less
Condition
New construction: No
Year built: 2005
Utilities & green energy
Gas: Natural Gas
Sewer: City Sewer/Connected
Water: City Water/Connected
Community & HOA
Community
Subdivision: Constance Corners
HOA
Has HOA: No
Location
Region: Andover
Financial & listing details
Price per square foot: $169/sqft
Tax assessed value: $560,600
Annual tax amount: $5,880
Date on market: 7/29/2026
Cumulative days on market: 25 days
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
8/20/2026
Price change
$565,000-1.7%$169/sqft
Source: NorthstarMLS as distributed by MLS GRID #7118270Report a problem
7/29/2026
Listed for sale
$575,000-3.4%$172/sqft
Source: NorthstarMLS as distributed by MLS GRID #7118270Report a problem
7/29/2026
Listing removed
$595,000$178/sqft
Source: NorthstarMLS as distributed by MLS GRID #7030293Report a problem
7/16/2026
Price change
$595,000-3.3%$178/sqft
Source: NorthstarMLS as distributed by MLS GRID #7030293Report a problem
7/9/2026
Listed for sale
$615,000+35.8%$184/sqft
Source: NorthstarMLS as distributed by MLS GRID #7030293Report a problem