NOT LISTED FOR SALE

152 Algonquin Ave Mashpee, MA 02649

Mashpee Area

Estimated Value: $793,000 - $938,443

3 Beds
3 Baths
3,040 Sq Ft
$281/Sq Ft Est. Value

Sale Details

Date Sold: December 19, 2025

Last sale price $799,000 $263 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $5,166 / mo

123 Days on Market

Highlights

  • Community Beach Access
  • Lake Front
  • Wood Flooring
  • Mashpee High School Rated A-
  • Deck
  • 2 Fireplaces

About This Home

As of December 2025

This beautifully appointed waterfront residence offers refined coastal living on the shores of scenic Cataquin Pond. This turnkey custom-built home spans 3,040 square feet set on .31Acres. Enter to an expansive and light-filled main level with a flowing open layout ideal for both relaxed daily living and elevated entertaining. The main living area is anchored by a gas fireplace, framed by oversized windows that capture water views. The kitchen, dining, and living spaces are seamlessly integrated, encouraging connection. The home offers 3 generous 2nd floor bedrooms, including a serene primary ensuite designed as a private retreat. The finished walk-out lower level with high coffered ceilings adds significant versatility, featuring a full bath, wet bar, spacious family room, and flexible living space with its own private entrance, ideal for hosting friends and family. The attached 2-car garage offers added convenience and storage, completing the picture of a home designed for ease, elegance, and enjoyment. This is a rare opportunity to own a waterfront property w/ membership to John's Pond Association where comfort, quality, and natural beauty converge. Passing TitleV in hand.

Last Agent to Sell the Property

Megan Zottoli

Weichert, Realtors-Donahue Partners Listed on: 06/23/2025

Last Buyer's Agent

Gina Palanza

Keller Williams Realty License #9587655

Keller Williams Realty

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,300

Year Built

  • Built in 1999

Lot Details

  • 13,504 Sq Ft Lot
  • Lake Front

Parking

  • 2 Car Attached Garage
  • Off-Street Parking

Home Design

  • Asphalt Roof
  • Shingle Siding

Interior Spaces

  • 3,040 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • 2 Fireplaces
  • Finished Basement
  • Basement Fills Entire Space Under The House
  • Washer
  • Property Views

Kitchen

  • Gas Range
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3 Full Bathrooms

Outdoor Features

  • Deck
  • Porch

Utilities

  • Heating Available
  • Water Heater

Community Details

  • Community Beach Access

Listing and Financial Details

  • Assessor Parcel Number 65-132-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,300

Year Built

Built in 1999

Lot Details

0.31 Acres

Parking

2

Listing Details

  • Has Basement: Finished, Full
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.31
  • Water Body Name: Cataquin Pond,Fresh
  • Directions: 151 to Algonquin. Home on Left.
  • Garage Yn: Yes
  • FeedTypes: BBO
  • CCIMLS2_General Property Info:Water Access Type: Private
  • CCIMLS2_Other Room 2:Level3: Basement
  • CCIMLS2_Legal and Taxes:Flood Ins Required: No
  • CCIMLS2_Status Change Info:Sold PriceSqFt: 262.83
  • CCIMLS2_Photo Rights:I own the photos or have the right to use: Yes
  • CCIMLS2_Convenient To:Convenient to Water Body 22: Cataquin Pond
  • CCIMLS2_Heating:Heating: Hot Water
  • CCIMLS2_General Property Info:Water Body View: Cataquin Pond
  • CCIMLS2_Convenient To:Convenient to Water Body 12: John's Pond
  • CCIMLS2_Contract Info:List PriceSqFt: 262.83
  • CCIMLS2_General Property Info:Miles to Beach: .1 - .3
  • CCIMLS2_General Property Info:Region: Upper Cape
  • CCIMLS2_General Property Info:Golf Course Front: No
  • CCIMLS2_Status Change Info:Estimated Selling Date: 2025-12-19
  • CCIMLS2_Other Room 1:Level2: Basement
  • CCIMLS2_General Property Info:Renovated: No
  • CCIMLS2_Legal and Taxes:Lead Base Paint: Unknown
  • CCIMLS2_Status Change Info:Terms2: Conventional
  • CCIMLS2_Other Room 1:Room Type: Family Room
  • CCIMLS2_Status Change Info:SPLP _percent_: 1
  • CCIMLS2_Status Change Info:SPAV: 0.97
  • CCIMLS2_Legal and Taxes:Building Assessments: 620500
  • CCIMLS2_Foyer:Foyer: Foyer
  • CCIMLS2_General Property Info:Year Round: Yes
  • CCIMLS2_General Property Info:Waterview Type: Lake/Pond
  • CCIMLS2_Other Room 2:Room Type2: 2nd Kitchen
  • CCIMLS2_Legal and Taxes:Nitrogen Sensitive Area: Yes
  • CCIMLS2_Foundation Details:Foundation Details: Poured
  • CCIMLS2_General Property Info:Golf Course View: No
  • CCIMLS2_Legal and Taxes:Mass Use Code: 101 - Residential, single family
  • CCIMLS2_Legal and Taxes:Title Reference - Page: 1
  • CCIMLS2_Legal and Taxes:Land Assessments: 205100
  • CCIMLS2_Legal and Taxes:Title Reference - Book: D1524719
  • CCIMLS2_Legal and Taxes:FEMA Flood Zone: X
  • CCIMLS2_Foyer:Foyer Level: First Floor
  • CCIMLS2_Convenient To:Convenient To: Conservation Area,Horse Trail,Marina,Public Tennis,Shopping,Golf Course,House of Worship,Major Highway
  • CCIMLS2_BuyerOfficeKeyNumeric: 20161230165658798349000000
  • CCIMLS2_BuyerAgentKeyNumeric: 20161230202950663497000000
  • CCIMLS2_ListOfficeKeyNumeric: 20161230165624763569000000
  • CCIMLS2_ListAgentKeyNumeric: 20260818210908386468000000
  • CCIMLS2_Architectural Style:Architectural Style: Contemporary
  • CCIMLS2_General Property Info:School District: Mashpee
  • Special Features: VirtualTour
  • Stories: 1

Interior Features

  • Appliances: Dishwasher, Gas Range, Refrigerator, Washer, Natural Gas, Water Heater
  • Total Bedrooms: 3
  • Interior Amenities: Recessed Lighting, Wet Bar
  • Full Bathrooms: 3
  • Fireplaces: 2
  • Flooring: Hardwood, Tile, Carpet
  • CCIMLS2_Kitchen:Kitchen Level: First Floor
  • CCIMLS2_Kitchen:Stove9: Gas
  • CCIMLS2_Kitchen:Countertops10: Granite
  • CCIMLS2_Living Room:Living Room: Recessed Lighting,View,Living Room
  • CCIMLS2_Primary Bedroom:Primary Bedroom: Primary Bedroom,Ceiling Fan,Closet,Private Full Bath,View,Walk-in Closet
  • CCIMLS2_Living Room:Fireplace18: Gas
  • CCIMLS2_Sep Living Qtrs Info:Baths - Total3: 0
  • CCIMLS2_Primary Bedroom:Primary Bedroom Level: Second Floor
  • CCIMLS2_Dining Room:Special Door Access8: Sliding
  • CCIMLS2_Baths Per Level:Baths - Level 1: 1
  • CCIMLS2_Baths Per Level:Baths - Level 2: 1
  • CCIMLS2_Kitchen:Kitchen: Kitchen,Recessed Lighting
  • CCIMLS2_Dining Room:Dining Room Level: First Floor
  • CCIMLS2_Bedroom 2:Bedroom 2: Bedroom 2,Closet,View,Shared Full Bath
  • CCIMLS2_Dining Room:Dining Room: View,Dining Room
  • CCIMLS2_Laundry Room:Laundry Room: Laundry Room
  • CCIMLS2_Baths Per Level:Basement Baths: 1
  • CCIMLS2_Living Room:Living Room Level: First Floor
  • CCIMLS2_General Property Info:Basement: Yes
  • CCIMLS2_Bedroom 3:Bedroom 3: Bedroom 3,Closet,View

Exterior Features

  • Exterior Features: None
  • Lot Features: Views
  • Waterfront Features: Waterview, Waterfront, Lake/Pond
  • Waterfront: Yes
  • Construction Type: Shingle Siding
  • Patio And Porch Features: Deck, Porch
  • Roof: Asphalt
  • CCIMLS2_General Property Info:Private Pool: No

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Parking Features: Off Street
  • Total Parking Spaces: 2

Utilities

  • Heating: Natural Gas
  • Heating Yn: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Beach Access

Lot Info

  • Lot Size Sq Ft: 13504
  • Parcel #: 65-132-0
  • Zoning Description: R3

Building Info

  • Year Built: 1999

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 5300

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
Jun 23, 2025
Closed on
Dec 19, 2025
Sold by
Noe Michael
Bought by
Seller's Agent
Megan Zottoli
Weichert, Realtors-Donahue Partners
Buyer's Agent
Gina Palanza
Keller Williams Realty
List Price
$850,000
Sold Price
$799,000
Premium/Discount to List
-$51,000
-6%
Current Estimated Value
$853,861

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$54,861
Avg. Annual Appreciation
9.80%
Original Mortgage
$639,200
Outstanding Balance
$635,520
Interest Rate
6.26%
Mortgage Type
New Conventional
Estimated Equity
$218,341

Purchase Details

Closed on
Jun 11, 2025
Sold by
Stern Steven and Stern Kathleen A
Bought by
Noe Michael

Purchase Details

Listed on
Jun 16, 2015
Closed on
Aug 10, 2015
Sold by
Luff Terence and Luff Suzanne
Bought by
Stern Steven and Stern Kathleen A
Seller's Agent
Patricia Holmes
Cape Coastal Sotheby's International Realty
Buyer's Agent
Patricia Holmes
Cape Coastal Sotheby's International Realty
List Price
$395,000
Sold Price
$395,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.21%

Purchase Details

Closed on
Jun 6, 2011
Sold by
Luff Terence
Bought by
Luff Terence and Luff Suzanne

Purchase Details

Closed on
Jul 1, 2009
Sold by
Vida 3 Re T and Luff
Bought by
Luff Terence

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$258,750
Interest Rate
4.86%

Purchase Details

Closed on
Oct 16, 2008
Sold by
Vida T 1 and Luff
Bought by
Vida 3 Rt and Luff
Source: Public Records

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
$799,000 --
Noe Michael $640,000 None Available
Stern Steven $395,000 --
Luff Terence -- --
Luff Terence -- --
Vida 3 Rt -- --
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 $639,200
Previous Owner -- $258,750
Previous Owner Luff Terry $99,000
Previous Owner Luff Terry $322,700
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
12/19/2025 12/19/25 Sold $799,000 -6.0% $263 / Sq Ft
10/24/2025 10/24/25 Pending -- -- --
06/23/2025 06/23/25 For Sale $850,000 -- $280 / Sq Ft
Source: Cape Cod & Islands Association of REALTORS®

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 $5,465 $825,600 $205,100 $620,500
2024 $4,540 $706,100 $186,500 $519,600
2023 $4,233 $603,800 $177,600 $426,200
2022 $4,003 $490,000 $137,100 $352,900
2021 $3,918 $432,000 $123,500 $308,500
2020 $3,811 $419,300 $118,800 $300,500
2019 $3,627 $400,800 $118,800 $282,000
2018 $3,423 $383,800 $118,800 $265,000
2017 $3,297 $358,800 $118,800 $240,000
2016 $3,137 $339,500 $118,800 $220,700
2015 $2,648 $290,700 $118,800 $171,900
2014 $2,556 $272,200 $100,800 $171,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Cape Cod & Islands Association of REALTORS®

MLS Number: 22503067

Cape Cod & Islands Association of REALTORS®

APN: MASH-000065-000132

Your Personal Tour Guide

Ask me questions while you tour the home.