Wendy Willis
Keller Williams Realty Evolution
(978) 997-7748
114 Total Sales
3 in Ipswich
$870K - $900K Price Range
154 Argilla Rd Ipswich, MA 01938
Ipswich AreaEstimated Value: $3,585,222
4
Beds
4.5
Baths
4,008
Sq Ft
$895/Sq Ft
Est. Value
Highlights
- Marina
- Medical Services
- Solar Power System
- Community Stables
- Property is near a beach
- Scenic Views
About This Home
As of March 2026Welcome to 154 Argilla Road, an incredible contemporary home designed by Finne architects in Seattle, WA. Panoramic views, incredible privacy and state-of-the-art systems. Located on Argilla road, a scenic byway to Crane Beach. This property boasts almost 4,008 sqft of light-filled living space with 4 bedrooms, 5 bathrooms, home gym, tower viewing room and 24 acres with two marsh islands. The exterior offers plenty of space to entertain or unwind, with ample distance between neighbors and access to the Great Marsh. There is a barn for storage and fantastic hardscaping and drought-resistant plantings. Ideally situated near the famous Crane Beach and Russell Orchards, and just a few miles from downtown Ipswich, where you’ll find many restaurants, local shops, and the commuter rail, this property is a remarkable inside and out. A complete sanctuary to watch the most incredible sunsets.
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $32,205
Year Built
- Built in 2012 | Remodeled
Lot Details
- 24.1 Acre Lot
- Property fronts a marsh
- Stone Wall
- Landscaped Professionally
- Level Lot
- Sprinkler System
- Cleared Lot
- Fruit Trees
- Marsh on Lot
- Drought Tolerant Landscaping
- Property is zoned RRA
Parking
- 2 Car Attached Garage
- Parking Storage or Cabinetry
- Heated Garage
- Workshop in Garage
- Garage Door Opener
- Stone Driveway
- Shared Driveway
- Unpaved Parking
- 10 Open Parking Spaces
- Off-Street Parking
Home Design
- Contemporary Architecture
- Frame Construction
- Metal Roof
- Radon Mitigation System
- Concrete Perimeter Foundation
Interior Spaces
- 4,008 Sq Ft Home
- Open Floorplan
- Wet Bar
- Wired For Sound
- Vaulted Ceiling
- Recessed Lighting
- Decorative Lighting
- Picture Window
- Window Screens
- Pocket Doors
- French Doors
- Insulated Doors
- Mud Room
- Living Room with Fireplace
- Home Office
- Sun or Florida Room
- Screened Porch
- Scenic Vista Views
Kitchen
- Breakfast Bar
- Oven
- Cooktop
- ENERGY STAR Qualified Refrigerator
- Freezer
- ENERGY STAR Qualified Dishwasher
- Stainless Steel Appliances
- Kitchen Island
Flooring
- Wood
- Wall to Wall Carpet
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Primary bedroom located on second floor
- Custom Closet System
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
- Bathtub with Shower
- Separate Shower
Laundry
- Laundry on upper level
- ENERGY STAR Qualified Dryer
- ENERGY STAR Qualified Washer
- Sink Near Laundry
Finished Basement
- Basement Fills Entire Space Under The House
- Interior and Exterior Basement Entry
Eco-Friendly Details
- Solar Power System
- Solar Assisted Cooling System
- Active Solar Heating System
- Water Recycling
Outdoor Features
- Outdoor Shower
- Property is near a beach
- Bulkhead
- Patio
- Exterior Lighting
- Outdoor Storage
Schools
- Winthrop Elementary School
- Ipswich Middle School
- Ipswich High School
Utilities
- Forced Air Heating and Cooling System
- 7 Cooling Zones
- 7 Heating Zones
- Radiant Heating System
- Geothermal Heating and Cooling
- Generator Hookup
- Power Generator
- Cistern
- Private Water Source
- Electric Water Heater
- Private Sewer
Additional Features
- Property is near golf course, public transit, and schools
- Farm
Listing and Financial Details
- Assessor Parcel Number M:055 B:0010 L:0,1952668
Community Details
Overview
- No Home Owners Association
- Near Conservation Area
Amenities
- Medical Services
- Shops
- Coin Laundry
Recreation
- Marina
- Tennis Courts
- Community Pool
- Park
- Community Stables
- Jogging Path
- Bike Trail
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Dec 8, 2025
Closed on
Mar 2, 2026
Sold by
Fields Ashley
Bought by
Seller's Agent
Binni Hackett
Compass
Buyer's Agent
Binni Hackett
Compass
List Price
$3,850,000
Sold Price
$3,650,000
Premium/Discount to List
-$200,000
-5.19%
Views
198
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$64,778
Avg. Annual Appreciation
-3.32%
Purchase Details
Closed on
May 13, 2021
Sold by
Hertz Frank and Hertz Kathryn V
Bought by
King Ashley
Purchase Details
Closed on
Jan 23, 2009
Sold by
Labor In Vain Nt and Hezzey
Bought by
Hertz Frank
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Ipswich, MA
-
Wendy Willis
-
Davis McVay
Davis McVay
Responds QuicklyKeller Williams Realty Evolution
(978) 547-7210
16 Total Sales
1 in Ipswich
$862,000 Price
-
Beverlee Vidoli
Beverlee Vidoli
RE/MAX Realty Experts
(781) 537-0770
129 Total Sales
1 in Ipswich
$1,000,000 Price
-
Laurie Cappuccio
Laurie Cappuccio
Classified Realty Group
(978) 705-5656
80 Total Sales
1 in Ipswich
$949,000 Price
-
George Needham
George Needham
GLN & Company, LLC
(978) 736-2304
24 Total Sales
2 in Ipswich
$639K - $675K Price Range
-
Jon Growitz
Jon Growitz
Gibson Sotheby's International Realty
(781) 604-1127
64 Total Sales
2 in Ipswich
$515K - $785K Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $3,650,000 | -- | ||
| King Ashley | $3,250,000 | None Available | |
| Hertz Frank | $950,000 | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $2,000,000 | ||
| Closed | Hertz Frank M | $500,000 | |
| Previous Owner | Hertz Frank M | $300,000 | |
| Previous Owner | Hertz Frank M | $150,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 03/04/2026 03/04/26 | Sold | $3,650,000 | -5.2% | $911 / Sq Ft |
| 01/23/2026 01/23/26 | Pending | -- | -- | -- |
| 12/08/2025 12/08/25 | For Sale | $3,850,000 | -- | $961 / Sq Ft |
Source: MLS Property Information Network (MLS PIN)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $32,205 | $2,888,300 | $1,397,100 | $1,491,200 |
| 2024 | $35,079 | $3,082,500 | $1,059,400 | $2,023,100 |
| 2023 | $34,330 | $2,807,000 | $896,000 | $1,911,000 |
| 2022 | $25,739 | $2,001,500 | $745,700 | $1,255,800 |
| 2021 | $22,430 | $1,696,700 | $721,800 | $974,900 |
| 2020 | $22,295 | $1,590,200 | $673,800 | $916,400 |
| 2019 | $22,406 | $1,590,200 | $673,800 | $916,400 |
| 2018 | $21,635 | $1,519,300 | $656,400 | $862,900 |
| 2017 | $21,045 | $1,483,100 | $656,400 | $826,700 |
| 2016 | $21,626 | $1,456,300 | $634,600 | $821,700 |
| 2015 | $19,887 | $1,472,000 | $634,600 | $837,400 |
Source: Public Records
Agents Affiliated with this Home
-
Binni Hackett
Seller's Agent in 2026
Binni Hackett
Compass
(978) 314-8103
112 Total Sales
-
Char Glessner
Seller Co-Listing Agent in 2026
Char Glessner
Compass
(978) 778-8391
21 Total Sales
Map
Source: MLS Property Information Network (MLS PIN)
MLS Number: 73460664
APN: IPSW-000055-000010
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc. The property listing data and information, and the Images, are for the personal, non-commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing or leasing. MLS Property Information Network, Inc. and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information, or as to the accuracy of any of the Images, set forth herein.
Nearby Homes
- 193-195 Argilla Rd
- 158 Argilla Rd
- 6 Northgate Rd
- 30 Labor in Vain Rd
- 16 Nabbys Point Rd
- 100 Choate St
- 25 Poplar St Unit 5A
- 57 East St
- 6 Essex Rd Unit 15
- 6 Essex Rd Unit 8
- 48 County St
- 0 Belcher St
- 24 Fellows Rd Unit 3
- 53 N Main St Unit 5
- 40 N Main St Unit 3
- 4 Kimball St
- 13 Estes St
- 50 Market St Unit 5
- 12 Capeview Rd
- 8-10 Hammatt St
- 142 Argilla Rd
- 142 Argilla Rd Unit 1
- 142 Argilla Rd
- 146 Argilla Rd
- 138 Argilla Rd
- 161 Argilla Rd
- 155 Argilla Rd
- 173 Argilla Rd
- 134 Argilla Rd
- 187 Argilla Rd
- 171 Argilla Rd
- 143 Argilla Rd
- 130 Argilla Rd
- 193 Argilla Rd
- 128 Argilla Rd
- 158 Argilla Rd
- 141 Argilla Rd
- 183 Argilla Rd
- 126 Argilla Rd
- 199 Argilla Rd
Your Personal Tour Guide
Ask me questions while you tour the home.