Skip main navigation
Off market
  • $3,698,300

    15 Trevino Cir, Andover, MA 01810

    4beds
    6,834sqft
    SingleFamily
    Built in 2018
    0.6 Acres Lot
    $3,698,300 Zestimate®
    $541/sqft
    $9,003 Estimated rent

    Home value

    $3,698,300

    $3.40M - $4.03M

    $9,003/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $9,003/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $9,003/mo

    Rent Zestimate®

    Refinance and save

    $18,655/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $18,655/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    LIVE MAGNIFICENTLY at The Andover Country Club! One of the town's most prestigious streets! This opportunity is rare! No need to wait a few years to build this exquisite type of a home! Like new, hardly lived in since 2018, spectacular contemporary colonial is available right now! Nestled at the very end of the cul de sac, surrounded by nature & framed by the 6th & 7th holes of the golf course is the hallmark of fine living by builder Yvon Cormier. Builder's Highest standards combined with owners extensive upgrades of open floor plan, soaring high ceilings, spectacular moldings, custom built ins, oversized windows, 1st floor master bedroom & private bath, private home office, 1st & 2nd floor laundry, closets with customized systems galore, walk in pantry, heated driveway & front walkway, back up generator, virtual golf simulator, grand paver patio with custom built fireplace. Luxury with comfort! Neighbor of the Country Club, Community, Convenience, Class & Fun is here!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
    Features
    • Flooring: Tile, Carpet, Concrete, Hardwood
    • Basement: Unfinished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 6,834 sqft

    Property

    Parking
    • Total spaces: 4
    • Parking features: Garage - Attached
    Features
    • Exterior features: Cement / Concrete
    Lot
    • Size: 0.60 Acres
    Details
    • Parcel number: ANDOM00087B00033L00000

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Frame
    • Roof: Asphalt
    Condition
    • Year built: 2018

    Community & neighborhood

    Location
    • Region: Andover

    Other

    Other facts
    • Amenities: Swimming Pool, Golf Course, Highway Access, Public School, Tennis Court, Walk/Jog Trails, Conservation Area
    • Construction: Frame, Stone/Concrete
    • Electric Feature: Circuit Breakers
    • Energy Features: Insulated Windows, Insulated Doors, Prog. Thermostat, Backup Generator
    • Flooring: Tile, Wall To Wall Carpet, Hardwood
    • Master Bath: Yes
    • Roof Material: Asphalt/Fiberglass Shingles
    • Year Round: Yes
    • Utility Connections: For Gas Range
    • Appliances: Range, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer, Vent Hood, Wall Oven, Refrigerator - Wine Storage
    • Bed2 Dscrp: Flooring - Hardwood, Bathroom - Full, Closet, Window(s) - Picture, Crown Molding
    • Bed2 Level: Second Floor
    • Bed3 Level: Second Floor
    • Bed4 Level: Second Floor
    • Bth1 Level: First Floor
    • Insulation Feature: Full
    • Kit Dscrp: Pantry, Flooring - Hardwood, Countertops - Stone/Granite/Solid, Closet/Cabinets - Custom Built, Kitchen Island, Stainless Steel Appliances, Open Floor Plan, Recessed Lighting, Wine Chiller, Gas Stove, Lighting - Pendant, Crown Molding
    • Kit Level: First Floor
    • Mbr Dscrp: Flooring - Hardwood, Bathroom - Full, Closet - Walk-In, Recessed Lighting, Closet/Cabinets - Custom Built, Window(s) - Picture, Crown Molding
    • Heating: Gas, Forced Air
    • Garage Parking: Attached, Garage Door Opener, Insulated
    • Bed3 Dscrp: Closet, Flooring - Hardwood, Window(s) - Picture, Crown Molding
    • Din Level: First Floor
    • Cooling: Central Air
    • Mbr Level: First Floor
    • Style: Colonial, Contemporary
    • Bth2 Dscrp: Bathroom - Full, Flooring - Marble
    • Fam Dscrp: Flooring - Hardwood, Recessed Lighting, French Doors, Fireplace, Closet/Cabinets - Custom Built, Ceiling - Beamed
    • Fam Level: First Floor
    • Bed4 Dscrp: Closet, Flooring - Hardwood, Window(s) - Picture
    • Bth3 Level: Second Floor
    • Din Dscrp: Flooring - Hardwood, Balcony / Deck, Slider, Recessed Lighting, Crown Molding, Tray Ceiling
    • Bth2 Level: First Floor
    • Bth3 Dscrp: Bathroom - Full, Flooring - Marble, Recessed Lighting
    • Bth1 Dscrp: Bathroom - Half, Flooring - Marble
    • Exterior: Fiber Cement Siding
    • Basement Feature: Full, Partially Finished, Walk Out, Interior Access, Concrete Floor, Exterior Access
    • Exterior Features: Deck, Patio, Gutters, Professional Landscaping, Sprinkler System, Decorative Lighting, Screens
    • Foundation: Poured Concrete
    • Laundry Dscrp: Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Laundry Sink
    • Laundry Level: First Floor
    • Road Type: Public, Paved, Publicly Maint., Cul-De-Sac
    • Lot Description: Easements, Wooded
    • Sf Type: Detached

    Price history

    DateEventPrice
    4/9/2021Sold$2,700,000-5.3%$395/sqft
    Source: Public Record Report a problem
    10/29/2020Listed for sale$2,850,000+9.6%$417/sqft
    Source: Coldwell Banker Realty - Andover #72750342 Report a problem
    3/1/2018Sold$2,600,000$380/sqft
    Source: Public Record Report a problem
    3/14/2017Listing removed$2,600,000$380/sqft
    Source: Cormier Properties #72118879 Report a problem
    3/7/2017Pending sale$2,600,000$380/sqft
    Source: Cormier Properties #72118879 Report a problem
    2/14/2017Listed for sale$2,600,000$380/sqft
    Source: Cormier Properties #72118879 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$43,855 $3,404,900
    2024$43,855 +7.1%$3,404,900 +13.5%
    2023$40,962 $2,998,700
    2022$40,962 +8.6%$2,998,700 +21.6%
    2021$37,714 +2.7%$2,466,600 +0.8%
    2020$36,728 +47%$2,446,900 +49.6%
    2019$24,980 +52.8%$1,635,900 +56.5%
    2018$16,353 +54.8%$1,045,600 +50.3%
    2017$10,561 +2.4%$695,700
    2016$10,310 -1%$695,700
    2015$10,415 +0.5%$695,700 +1.9%
    2014$10,366 +4.6%$682,900
    2013$9,909 +2.5%$682,900
    2012$9,663 -4.4%$682,900 -4.6%
    2011$10,110 +17.9%$716,000 +10.1%
    2010$8,577 +8.5%$650,300
    2009$7,908 +4%$650,300
    2008$7,602 +3.9%$650,300
    2007$7,316 +8.6%$650,300 +10.1%
    2006$6,735 +42.6%$590,800 +44%
    2005$4,723 +0.4%$410,300
    2004$4,706 -1.4%$410,300
    2003$4,772 +54.4%$410,300 +98%
    2001$3,091 +1.8%$207,200
    2000$3,035 +311.2%$207,200 +334.4%
    1997$738 $47,700

    Find assessor info on the county website

    Neighborhood: 01810

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: West Elementary
    • Middle: West Middle
    • High: A.H.S.

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $3,698,300
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $3,698,300