Barnstable County and Barnstable Town City property record for 174 Walnut St, Marstons Mills, MA 02648
| Property Type | Single Family Home |
|---|---|
| Details | 3 bd · 2.5 ba · 2,305 sqft · built 2005 |
| Lot Size | 1 acres (43,560 sqft) |
| Owner | 2 Trust Names on Record |
| Last Sale | $250,000 (Apr 2005) |
| Tax Bill | $6,254 (2025) |
| Deeds & Mortgages | Nov 2018 Transfer Sep 2017 Line of Credit |
| Flood Zone | Zone X (minimal risk) |
| APN | CENT M:150 L:017001 |
| Primary APN | CENT M:150 L:017001 |
|---|---|
| Alternative APN |
|
| Bedrooms | 3 Beds |
|---|---|
| Full Baths | 2.5 Baths |
| Half Baths | 1 Half Bath |
| Total Rooms | 7 Rooms |
| Stories | 2 Stories |
| Building Area | 2,305 sqft Living Area |
| Gross Area | 4,833 sqft |
| Year Built | Built 2005 |
|---|---|
| Effective Year Built | Effective 2005 |
| Architectural Style | Colonial |
| Exterior Material | Wood Siding |
| Roof Type | Gable |
| Roof Material | Asphalt |
| Lot Area | 43,560 sqft (1 acres) |
| Cooling System | HVAC |
|---|---|
| Heating System | Forced Air with A/C |
| Heating Fuel | Gas |
| Account Number | 86614 |
|---|---|
| Street Address | 174 WALNUT ST |
| City | MARSTONS MILLS |
| State | MA |
| Zip | 02648 |
| Property Category | Residential |
| Property Type | Residential > Single Family > Home |
| Local Zoning Code | 1 |
| Legal Subdivision | JOHN A & JOAN E AALTO |
| Legal Lot Number | 17001 |
| Jurisdiction | BARNSTABLE MA |
| Township / Civil Division | BARNSTABLE TOWN |
| Census Block Group | 2 |
| Census Block | 2000 |
| Census Tract | 13100 |
Source: Barnstable County and Barnstable Town City records, as of April 14, 2026
Owner names and exact recorded amounts shown locked on this page are available instantly with a free trial.
| Owner of Record | 2 Trust Names on Record |
|---|---|
| Mailing Address | 174 WALNUT ST, HYANNIS, MA 02601-5772 |
| Occupancy | Owner Occupied |
| Owner Type | Individual |
| Vesting | Trust |
| Date | Document |
|---|---|
| Nov 8, 2018 | Quit Claim Deed, Transfer Quitclaim |
| Sep 6, 2017 | Deed of Trust, Mortgage · Line of Credit CAPE COD CO-OP BK |
| Deed Names | 2 Names on Deed |
|---|---|
| Last Sale | Apr 20, 2005 · Amount on Record |
| Deed Sale | Apr 20, 2005 · Amount on Record |
| Deed Document Number | 2005152609 |
| Deed Book / Page | 19741 / 160 |
| Record Updated | Jun 8, 2026 |
| Document Type | Quit Claim Deed |
|---|---|
| Jurisdiction | BARNSTABLE MA |
| Recording Date | Nov 8, 2018 |
| Property Address | 174 WALNUT ST, MARSTONS MILLS, MA 02648 |
| Document Number | 31650-322 |
| Book / Page | 031650 / 000322 |
| Instrument Date | Nov 7, 2018 |
| Instrument | 55612 |
| Transaction Type | Transfer |
| Record Updated | Nov 28, 2018 |
| Tax | $0.00 |
|---|---|
| Additional |
|
| Name | Verified Name |
|---|
| Name | Verified Name |
|---|---|
| Address | 174 WALNUT ST HYANNIS MA 02601, HYANNIS, MA 02601 |
| Document Type | Deed of Trust |
|---|---|
| Jurisdiction | BARNSTABLE MA |
| Property Address | 174 WALNUT ST, MARSTONS MILLS, MA 02648 |
| Document Number | 30756-14 |
| Book / Page | 030756 / 000014 |
| Instrument Date | Sep 6, 2017 |
| Transaction Type | Mortgage |
| Record Updated | Oct 4, 2017 |
| Name | Verified Name |
|---|
| Document Number | 30756-14 |
|---|---|
| Date | Sep 11, 2017 |
| Book Page | 030756/000014 |
| Instrument | 46032 |
| Name | CAPE COD CO-OP BK |
|---|---|
| Type | Bank |
| Type | Line of Credit |
|---|---|
| Amount | Amount Recorded |
| Term | 360 Months |
| Due | Sep 10, 2047 |
| Rate Type | Adjustable Rate |
|---|
Source: Barnstable County and Barnstable Town City assessment roll, as of April 14, 2026
| Type | Name |
|---|---|
| State | Massachusetts |
| County | Barnstable County |
| Municipality | Barnstable Town City |
| Unified School District | Barnstable School District (PK - 12) |
| Year | Tax Bill | Assessed Value |
|---|---|---|
| 2025 | $6,254.00 (+9.18%) | $773,000 (+5.4%) Land $176,300 Building $596,700 |
| 2024 | $5,728.00 (+6.79%) | $733,400 (+14.02%) Land $176,300 Building $557,100 |
| 2023 | $5,364.00 | $643,200 Land $160,300 Building $482,900 |
Assessed value is set for property tax purposes and is not a market price estimate.
Source: FEMA National Flood Hazard Layer, effective October 1, 2026 · OpenFEMA NFIP redacted claims and policies, as of September 2026
| FEMA Flood Zone | Zone X minimal risk |
|---|---|
| Flood Insurance Requirement | Not required lenders may require it |
| Nearby Flood Policies | 3 in force |
Values are read at the parcel center point; flood claims are located to the census block group, not this parcel; lenders make the official flood determination.
Source: USDA Forest Service Wildfire Risk to Communities (2nd edition), as of 2024
| Wildfire Risk | Low lower than 94% of the US · lower than 88% of Massachusetts |
|---|---|
| Wildfire Likelihood | Under 0.01% annual chance |
| Exposure | Direct burnable vegetation |
Values cover an area roughly 900 ft across, not the parcel itself; insurers use their own ratings.
Source: EPA Safe Drinking Water Information System, as of September 2026
| Water System | CENTERVILLE OSTERVILLE MARSTONS MILLS WD serves 50,000 people · EPA ID MA4020002 |
|---|---|
| Water Source | Groundwater |
| Last State Inspection | Jun 2025 |
| Lead | 2 ppb (2026) action level 15 ppb |
| Water Quality | None last 10 years |
|---|---|
| Treatment and Procedure | None last 10 years |
| Monitoring and Reporting | 31 last 3 years |
Results are for the whole water system, not water tested at this address; lead at the tap also depends on the building's own pipes. This system sells water to local utilities; the supplier billing this address may be one of them.
Source: FCC Broadband Data Collection, based on 89 locations within half a mile, as of December 31, 2025
| Provider | Max Down / Up (Mbps) |
|---|---|
| Xfinity Cable | 2,000 / 250 |
5G (outdoors only) and 4G LTE
Search by:
By searching, you agree to: Terms • Privacy • Disclosures