NOT LISTED FOR SALE

Estimated Value: $2,170,000 - $2,585,000

4 Beds
3.5 Baths
5,236 Sq Ft
$462/Sq Ft Est. Value

Sale Details

Date Sold: January 17, 2024

Last sale price $2,100,000 $401 Per Sq Ft

Est. 15% increase in value since last sale

Current estimated payment $14,928 / mo

4 Days on Market

Highlights

  • Community Beach Access
  • Lake Front
  • Wood Flooring
  • West Villages Elementary School Rated A-
  • Tennis Courts
  • 2 Fireplaces

About This Home

As of January 2024

Exquisite private waterfront oasis. Hamblin Pond features over 300 acres of connecting freshwater between Hamblin Pond, Middle Pond and Mystic Lake. Enjoy magnificent sunsets over your private level yard. Prepare to be enchanted by this 4+-bedroom, 3.5 bath home boasting high ceilings, incredible views & private water frontage. The first floor awaits your personal decorating. Primary bedroom features new flooring, sitting room with fireplace, stunning water views plus large bath and walk-in closet. First floor flexible floor plan offers sunroom, family room with fireplace & kitchen overlooking the water. Formal living, featuring third wood burning fireplace & dining room are freshly painted with new flooring & a grand foyer with elegant bridal staircase.
Renovated second floor showcases another primary en- suite & 2 bedrooms with shared bath plus space currently used as an exercise area. Second staircase to large bonus room with new cabinet, stone countertop, & dishwasher..
Mature plantings in level yard provide a haven for outdoor enthusiasts, bocce court, space for canoes, kayaks, paddle boards, gardens. For the car enthusiast, three-car side entrance garage.

Last Agent to Sell the Property

Ginny Guimond

William Raveis Real Estate & Home Services License #121190 Listed on: 11/06/2023

Last Buyer's Agent

Shaelyn Hegarty

Frank A Sullivan Real Estate License #9552710

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

  • $15,041

Year Built

  • Built in 1987

Lot Details

  • 1.04 Acre Lot
  • Lake Front
  • Level Lot
  • Garden

HOA Fees

  • $29 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Pitched Roof
  • Asphalt Roof
  • Shingle Siding
  • Clapboard
  • Stone

Interior Spaces

  • 5,236 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • 2 Fireplaces
  • Basement Fills Entire Space Under The House

Kitchen

  • Built-In Oven
  • Gas Range
  • Microwave

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms

Outdoor Features

  • Tennis Courts
  • Patio

Utilities

  • Central Air
  • Heating Available
  • Water Heater

Listing and Financial Details

  • Assessor Parcel Number 079-045

Community Details

Overview

  • Indian Lakes Subdivision

Amenities

  • Common Area

Recreation

  • Community Beach Access

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,041

Year Built

Built in 1987

Lot Details

1.04 Acres

HOA Fees

$29 per month

Parking

3

Listing Details

  • Has Basement: Full
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 1.04
  • Water Body Name: Hamblin Pond,Fresh
  • Subdivision Name: Indian Lakes
  • Directions: Rt 149 to Mistic Drive, Indian Lakes.
  • Garage Yn: Yes
  • FeedTypes: BBO
  • CCIMLS2_General Property Info:Water Access Type: Private
  • CCIMLS2_General Property Info:Membership Required: No
  • CCIMLS2_Other Room 2:Level3: First Floor
  • CCIMLS2_Legal and Taxes:Flood Ins Required: No
  • CCIMLS2_General Property Info:Mi to Beach Comments: Beachfront Plus Neighborhood Association Beach
  • CCIMLS2_Other Room 4:Level5: Second Floor
  • CCIMLS2_Status Change Info:Sold PriceSqFt: 401.07
  • CCIMLS2_Photo Rights:I own the photos or have the right to use: Yes
  • CCIMLS2_Convenient To:Convenient to Water Body 22: Loop Beach
  • CCIMLS2_Heating:Heating: Forced Air
  • CCIMLS2_General Property Info:Water Body View: Hamblin Pond
  • CCIMLS2_General Property Info:Assoc Fee Year: 2023
  • CCIMLS2_General Property Info:Year Renovated: 2023
  • CCIMLS2_Convenient To:Convenient to Water Body 12: Hamblin Pond
  • CCIMLS2_Contract Info:List PriceSqFt: 420.17
  • CCIMLS2_General Property Info:Miles to Beach: 0 - .1
  • CCIMLS2_General Property Info:Region: Mid-Cape
  • CCIMLS2_General Property Info:Golf Course Front: No
  • CCIMLS2_Other Room 3:Room Type3: Exercise Room
  • CCIMLS2_Status Change Info:Estimated Selling Date: 2024-01-12
  • CCIMLS2_Other Room 1:Level2: First Floor
  • CCIMLS2_General Property Info:Renovated: Yes
  • CCIMLS2_General Property Info:Separate Living Qtrs: No
  • CCIMLS2_Legal and Taxes:Lead Base Paint: Unknown
  • CCIMLS2_General Property Info:Irregular: Yes
  • CCIMLS2_Status Change Info:Terms2: Conventional
  • CCIMLS2_Other Room 1:Room Type: Family Room
  • CCIMLS2_Status Change Info:SPLP _percent_: 0.95
  • CCIMLS2_Status Change Info:SPAV: 1.11
  • CCIMLS2_Other Room 3:Level4: First Floor
  • CCIMLS2_Legal and Taxes:Building Assessments: 1137100
  • CCIMLS2_Foyer:Foyer: Foyer,Closet,Cathedral Ceiling
  • CCIMLS2_General Property Info:Year Round: Yes
  • CCIMLS2_General Property Info:Waterview Type: Lake/Pond
  • CCIMLS2_Other Room 2:Room Type2: Sun Room
  • CCIMLS2_Legal and Taxes:Nitrogen Sensitive Area: Yes
  • CCIMLS2_Foundation Details:Foundation Details: Concrete Perimeter,Poured
  • CCIMLS2_General Property Info:Golf Course View: No
  • CCIMLS2_Legal and Taxes:Mass Use Code: 101 - Residential, single family
  • CCIMLS2_Other Room 4:Room Type4: Entertainment
  • CCIMLS2_Legal and Taxes:Title Reference - Page: 0189
  • CCIMLS2_Legal and Taxes:Land Assessments: 635500
  • CCIMLS2_Legal and Taxes:Title Reference - Book: 16921
  • CCIMLS2_Legal and Taxes:FEMA Flood Zone: X
  • CCIMLS2_Foyer:Foyer Level: First Floor
  • CCIMLS2_Convenient To:Convenient To: Bike Path,Conservation Area,Marina,Shopping,Golf Course,House of Worship,Major Highway,Medical Facility,School
  • CCIMLS2_BuyerOfficeKeyNumeric: 20161230165618549659000000
  • CCIMLS2_BuyerAgentKeyNumeric: 20180126140915074273000000
  • CCIMLS2_ListOfficeKeyNumeric: 20161230165657186342000000
  • CCIMLS2_ListAgentKeyNumeric: 20161230202616512789000000
  • CCIMLS2_Architectural Style:Architectural Style: Cape Cod
  • CCIMLS2_General Property Info:School District: Barnstable
  • Special Features: None
  • Stories: 2

Interior Features

  • Appliances: Countertop Range, Microwave, Gas Range, Refrigerator, Wall/Oven Cook Top, Natural Gas, Water Heater
  • Total Bedrooms: 4
  • Interior Amenities: Pantry, Wet Bar
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Fireplaces: 2
  • Flooring: Hardwood, Wood, Tile
  • CCIMLS2_Bedroom 4:Bedroom 4: Bedroom 4,Closet,View,Shared Full Bath
  • CCIMLS2_Kitchen:Kitchen Level: First Floor
  • CCIMLS2_LivingDining Combo:LivingDining Combo: No
  • CCIMLS2_Living Room:Living Room: Living Room
  • CCIMLS2_Bedroom 2:Flooring2: Wood
  • CCIMLS2_Bedroom 4:Flooring4: Wood
  • CCIMLS2_Primary Bedroom:Primary Bedroom: Primary Bedroom,Bay/Bow Windows,Closet,Office/Sitting Area,Private Full Bath,View,Walk-in Closet
  • CCIMLS2_Living Room:Fireplace18: Wood Burning
  • CCIMLS2_Sep Living Qtrs Info:Baths - Total3: 0
  • CCIMLS2_Primary Bedroom:Primary Bedroom Level: First Floor
  • CCIMLS2_Dining Room:Flooring8: Wood
  • CCIMLS2_Bedroom 3:Flooring3: Wood
  • CCIMLS2_Laundry Room:Laundry Room Level: Second Floor
  • CCIMLS2_Bedroom 3:Bedroom 3 Level: Second Floor
  • CCIMLS2_Baths Per Level:Baths - Level 1: 2
  • CCIMLS2_Baths Per Level:Baths - Level 2: 2
  • CCIMLS2_Kitchen:Kitchen: Kitchen,Pantry,Eat-in Kitchen,Breakfast Nook,Bay/Bow Windows,View
  • CCIMLS2_Dining Room:Dining Room Level: First Floor
  • CCIMLS2_Bedroom 2:Bedroom 2: Bedroom 2,Private Full Bath,View
  • CCIMLS2_Primary Bedroom:Flooring: Wood
  • CCIMLS2_Bedroom 2:Bedroom 2 Level: Second Floor
  • CCIMLS2_Dining Room:Dining Room: Dining Room
  • CCIMLS2_Bedroom 4:Bedroom 4 Level: Second Floor
  • CCIMLS2_Laundry Room:Laundry Room: Laundry Room
  • CCIMLS2_Primary Bedroom:Fireplace12: Wood Burning
  • CCIMLS2_Living Room:Living Room Level: First Floor
  • CCIMLS2_Living Room:Flooring7: Wood
  • CCIMLS2_General Property Info:Basement: Yes
  • CCIMLS2_Bedroom 3:Bedroom 3: Bedroom 3,Closet,View,Shared Full Bath

Exterior Features

  • Exterior Features: Garden, Underground Sprinkler System
  • Lot Features: Level, Pond on Lot
  • Waterfront Features: Waterview, Waterfront, Lake/Pond
  • Waterfront: Yes
  • Construction Type: Clapboard, Shingle Siding, Stone
  • Patio And Porch Features: Patio
  • Roof: Asphalt, Pitched
  • CCIMLS2_General Property Info:Private Pool: No

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Parking Features: Direct Access, Garage Door Opener
  • Total Parking Spaces: 6

Utilities

  • Cooling: Central Air
  • Heating: Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Beach Access, Tennis Court(s), Common Area
  • Association Fee: 350
  • Association Fee Frequency: Annually
  • Association: Yes

Lot Info

  • Lot Size Sq Ft: 45302
  • Parcel #: 079-045
  • Zoning Description: RF

Building Info

  • Year Built: 1987

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 15041

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

Closed on
Jan 17, 2023
Sold by
Pokrovskaya Nadezhda
Bought by
Current Estimated Value
$2,419,791

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,470,000
Interest Rate
7.03%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Mar 31, 2021
Sold by
Maffei Susan
Bought by
Pokrovakaya Nadezhda

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,060,800
Interest Rate
2.8%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Sep 30, 1997
Sold by
Somario Joseph and Somario Pearl M
Bought by
Maffei Susan

Purchase Details

Closed on
Sep 15, 1995
Sold by
Maffei John J and Maffei Susan
Bought by
Somario Joseph and Somario Pearl M
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Marstons Mills, MA

See All Agents

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
$2,100,000 None Available
Pokrovakaya Nadezhda $1,300,000 None Available
Maffei Susan $503,000 --
Somario Joseph $490,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 $1,185,600
Previous Owner Makris David P $1,470,000
Previous Owner Pokrovakaya Nadezhda $1,060,800
Previous Owner Maffei Susan $335,000
Previous Owner Maffei John $160,000
Closed Maffei Susan $348,000
Previous Owner Maffei Susan $355,500
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
01/17/2024 01/17/24 Sold $2,100,000 -4.5% $401 / Sq Ft
11/10/2023 11/10/23 Pending -- -- --
11/06/2023 11/06/23 For Sale $2,200,000 -- $420 / 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 $18,579 $2,296,500 $707,700 $1,588,800
2024 $15,151 $1,940,000 $539,500 $1,400,500
2023 $15,744 $1,887,800 $635,500 $1,252,300
2022 $13,526 $1,403,100 $358,000 $1,045,100
2021 $13,402 $1,277,600 $381,800 $895,800
2020 $14,157 $1,291,700 $406,600 $885,100
2019 $13,242 $1,173,900 $381,300 $792,600
2018 $12,487 $1,112,900 $441,400 $671,500
2017 $11,557 $1,074,100 $441,400 $632,700
2016 $11,829 $1,085,200 $452,500 $632,700
2015 $10,786 $994,100 $422,900 $571,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Cape Cod & Islands Association of REALTORS®

MLS Number: 22304898

Cape Cod & Islands Association of REALTORS®

APN: MMIL-000079-000000-000045

Your Personal Tour Guide

Ask me questions while you tour the home.