$4,250,000
PENDING

79 Cedar Tree Neck Rd Marstons Mills, MA 02648

Estimated payment $26,437/month

Total Views 712
3 Beds
5.5 Baths
4,093 Sq Ft
$1,038 Price per Sq Ft

Highlights

  • Property is near a marina
  • Heated Spa
  • Wood Flooring
  • West Villages Elementary School Rated A-
  • Waterfront
  • 1 Fireplace

About This Home

Set on coveted Prince Cove, this exceptional waterfront home features a private deep-water dock and spectacular views. Thoughtful upgrades abound throughout the residence, with unsurpassed attention to quality and detail. The open floor plan is flooded with natural light and ideal for entertaining with seamless access to outdoor living spaces. Three well-appointed bedrooms, including a luxurious primary suite, provide refined accommodations. Set on just over an acre and located in close proximity to everything the area has to offer, this magnificent waterfront home is ready to be enjoyed.

Listing Agent

Paul Grover

Berkshire Hathaway HomeServices Robert Paul Properties License #125463

Berkshire Hathaway HomeServices Robert Paul Properties

Co-Listing Agent

Matthew De Groot

Berkshire Hathaway HomeServices Robert Paul Properties License #9575319

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $31,761

Year Built

  • Built in 1999 | Remodeled

Lot Details

  • 1.04 Acre Lot
  • Waterfront
  • Near Conservation Area
  • Property is zoned RF

Parking

  • 2 Car Attached Garage
  • Open Parking

Home Design

  • Poured Concrete
  • Asphalt Roof
  • Shingle Siding

Interior Spaces

  • 4,093 Sq Ft Home
  • 2-Story Property
  • 1 Fireplace

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms

Finished Basement

  • Partial Basement
  • Interior Basement Entry

Outdoor Features

  • Heated Spa
  • Property is near a marina

Location

  • Property is near a golf course

Utilities

  • Central Air
  • Heating Available
  • Gas Water Heater
  • Septic Tank

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 075014

Home Details

Home Type

Single Family

Est. Annual Taxes

$31,761

Year Built

Built in 1999 | Remodeled

Lot Details

0

Parking

2

Listing Details

  • Has Basement: Finished, Partial, Interior Entry
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 1.04
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Water Body Name: Prince Cove
  • Co List Office Mls Id: CENCOM3
  • Co List Office Phone: 508-748-2400
  • Directions: Route 28 to Prince Avenue to Cedar Tree Neck Road, #79 on left.
  • Carport Y N: No
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Special Features: None
  • Stories: 2

Interior Features

  • Appliances: Gas Water Heater
  • Total Bedrooms: 3
  • Spa Features: Heated
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Hardwood, Tile

Exterior Features

  • Lot Features: Conservation Area, School, Major Highway, Near Golf Course, Marina, South of Route 28
  • Pool Private: No
  • Waterfront: Yes
  • Home Warranty: No
  • Construction Type: Shingle Siding
  • Foundation Details: Poured
  • Property Condition: Updated/Remodeled, Actual
  • Roof: Asphalt

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Open Parking: Yes
  • Total Parking Spaces: 4

Utilities

  • Sewer: Septic Tank
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Junior High Dist: Barnstable

Lot Info

  • Zoning: RF
  • Land Lease: No
  • Lot Size Sq Ft: 45302
  • Parcel #: 075014
  • ResoLotSizeUnits: Acres

Building Info

  • Year Built: 1999

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 31761
  • Tax Book Number: 30543

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

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,594 $4,028,900 $2,204,400 $1,824,500
2024 $30,389 $3,891,100 $2,204,400 $1,686,700
2023 $28,987 $3,475,700 $2,004,000 $1,471,700
2022 $22,699 $2,354,700 $1,128,200 $1,226,500
2021 $23,428 $2,233,400 $1,098,500 $1,134,900
2020 $23,086 $2,106,400 $1,099,800 $1,006,600
2019 $20,624 $1,828,400 $951,400 $877,000
2018 $1,127 $1,768,700 $1,001,500 $767,200
2017 $18,665 $1,734,700 $1,001,500 $733,200
2016 $21,639 $1,985,200 $1,252,000 $733,200
2015 $21,136 $1,948,000 $1,241,000 $707,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/26/2025 05/26/25 Pending -- -- --
05/24/2025 05/24/25 For Sale $4,250,000 +88.9% $1,038 / Sq Ft
06/08/2017 06/08/17 Sold $2,250,000 -13.4% $563 / Sq Ft
05/08/2017 05/08/17 Pending -- -- --
07/25/2016 07/25/16 For Sale $2,597,800 -- $649 / Sq Ft
Source: Cape Cod & Islands Association of REALTORS®

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- None Available
Not Resolvable $2,250,000 --
Deed $2,950,000 --
Deed $380,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $1,000,000 Purchase Money Mortgage
Previous Owner $1,200,000 No Value Available
Previous Owner $1,000,000 No Value Available
Previous Owner $1,200,000 No Value Available
Source: Public Records

Source: Cape Cod & Islands Association of REALTORS®

MLS Number: 22502554

Cape Cod & Islands Association of REALTORS®

APN: MMIL-000075-000000-000014