195 Route 149 #E, Marstons Mills, MA 02648
Property image
Property image
OFF MARKET

$743,700

Trulia Estimate
  • 3 Beds
  • 3 Baths
  • 2,019 sqft

195 Route 149 #E, Marstons Mills, MA 02648

Marstons Mills
Est. Refi. Payment $4,439/mo*
Refinance Your Home
Currently Off Market - Sold Mar 3, 2020 for $475,000

Home Value

Trulia Estimate
$744K
Since last month
Increased$6K (+0.8%)
Since last year
Increased$37K (+5.3%)
Since last sale
Increased$269K (+56.6%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +5% in the last 10 years
MonthEstimated value
2026
September 2026$744K
August 2026$738K
July 2026$738K
June 2026$752K
May 2026$731K
April 2026$721K
March 2026$729K
February 2026$696K
January 2026$711K
2025

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
3040 Falmouth Road UNIT H, Osterville, MA
0.81
Condo
$327,000
01/28/26
2
1
594
105 Parker Road UNIT B, Osterville, MA
2.60
Condo
$535,000
08/19/26
2
2.5
1,954
920 Main St #2-1, Barnstable, MA
2.33
Condo
$600,000
04/17/26
2
2
1,150
920 Main Street Unit 1 Building 2, Osterville, MA
2.35
Condo
$600,000
04/17/26
2
2
1,150
39 Tower Hill Road APT 16D, Osterville, MA
2.42
Condo
$700,000
09/08/26
2
2
1,260
39 Tower Hill Road APT 18A, Osterville, MA
2.49
Condo
$600,000
04/08/26
2
2
1,278
39 Tower Hill Road #1C, Osterville, MA
2.49
Condo
$545,000
12/11/25
2
2
1,131
39 Tower Hill Rd #1C, Barnstable, MA
2.49
Condo
$545,000
12/11/25
2
2
1,131
39 Tower Hill Road APT 15B, Osterville, MA
2.49
Condo
$719,000
06/22/26
2
2
1,260

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
195 Route 149 #G, Marstons Mills, MA 02648
0.00
$874,900
3
3.5
2,814
Off Market
330 Cotuit Road, Marstons Mills, MA 02648
0.05
$591,900
4
1
1,520
Off Market
401 Cotuit Road, Marstons Mills, MA 02648
0.09
$928,500
3
3
2,043
Off Market
766 Mistic Drive, Marstons Mills, MA 02648
0.11
$1,552,100
3
3.5
2,900
Off Market
400 Route 149 Road, Marstons Mills, MA 02648
0.08
$631,900
3
2
1,172
Off Market
766 Mistic Dr, Barnstable, MA 02630
0.12
-
3
3.5
2,960
Off Market
34 Mistic Drive, Marstons Mills, MA 02648
0.11
$1,275,000
4
3.5
4,056
Recently Sold
34 Mistic Dr, Barnstable, MA 02630
0.11
$1,275,000
4
3.5
4,056
Recently Sold
420 Cotuit Road, Marstons Mills, MA 02648
0.12
$848,600
3
2
1,827
Off Market
697 Mistic Dr, Barnstable, MA 02630
0.25
$1,063,100
3
2.5
2,200
Off Market
697 MISTIC Drive, Marstons Mills, MA 02648
0.26
$1,087,500
3
2.5
2,192
Off Market

Local Information

  • Map ViewExplore the area around 195 Route 149 #E.
  • Schools2 Elementary Schools2 Middle Schools1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Condo
Built in 2002
2,019 sqft
$368/sqft
1 Car Garage

About this House

Welcome to Herring Run Place ~ A beautifully designed private community consisting of nine freestanding condominiums built by Bayside Homes. Truly the best of both worlds offering the look and feel of a single family home ~ Unit E has been impeccably maintained and improved. Starting from the covered front porch and into the spacious living room with gas fireplace, crown molding and gleaming wood floors that extend into the gorgeous, tastefully designed newer kitchen with many special features and high quality appliances. Inviting three season sunroom overlooking patio area and pretty yard can be accessed from both the kitchen and master bedroom. Laundry and 1 & 1/2 baths complete the first floor. Upstairs there are 3 nicely appointed rooms and a bath. Lower level is beautifully finished into a media room (TV and Sound System included), sitting/exercise area and 1/2 bath. Other recent improvements include Kohler Whole House Gas Generator, On Demand Tankless Hot Water Heater and Roof. Picture Perfect Setting just a short stroll to the Village where you find the Post Office, Market, Library, Restaurant and Shops. Very Nice!
195 Route 149 #E, Marstons Mills, MA 02648 is a 3 bedroom, 4 bathroom, 2,019 sqft condo in Marstons Mills, built in 2002. It last sold for $475,000 on Mar 3, 2020 (5% below the $499,000 asking price). This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $743,700, with a rent estimate of $3,845/month.
Last check for updates: about 2 hours ago
Listed by Stacey Harrison, (508) 776-1791
Unique Properties R E
Bought with: Robert Melville, (508) 364-8200, Cape Cod Real Estate Group
Source: CCIMLS, MLS#21902010

Home Details for 195 Route 149 #E

Interior Features

Interior Details
Basement: Finished,FullNumber of Rooms: 6
Beds & Baths
Number of Bedrooms: 3Number of Bathrooms: 4Number of Bathrooms (full): 2Number of Bathrooms (half): 2
Appliances & Utilities
Appliances: Natural Gas, Tankless Water Heater
Heating & Cooling
Heating: Natural GasHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Natural Gas
Fireplace & Spa
Number of Fireplaces: 1
Windows, Doors, Floors & Walls
Flooring: Hardwood, Tile, Carpet
Levels, Entrance, & Accessibility
Stories: 2Floors: Hardwood, Tile, Carpet

Exterior Features

Exterior Home Features
Roof: Asphalt PitchedPatio / Porch: Patio
Parking & Garage
Number of Garage Spaces: 1Has a GarageHas an Attached GarageHas Open ParkingParking Spaces: 1Parking: Direct Access,Garage Door Opener,Driveway,Paved
Frontage
Not on Waterfront

Days on Market

Cumulative Days on Market: 286

Property Information

Year Built
Year Built: 2002
Property Type / Style
Property Type: ResidentialProperty Subtype: Condominium
Building
Construction Materials: Shingle Siding
Property Information
Parcel Number: 7818040E

Price & Status

Price
List Price: $499,000

Active Status

MLS Status: Closed

Location

Direction & Address
City: Marstons Mills

Building

Building Area
Building Area: 2019 Square Feet

Community

Units in Building: 9

HOA

Has an HOA

Listing Info

Special Conditions: None

Business

Business Information
Ownership: Condo

Miscellaneous

BasementMls Number: 21902010Showing Requirements: Appointment Required, Call Listing Agent

Additional Information

HOA Amenities: Pets Allowed,Road Maintenance,Snow Removal

Price and Tax history

DateEventPrice
Mar 3, 2020
Source: CCIMLS #21902010
Sold
$475,000
Jul 23, 2012
Source: CCIMLS #21100172
Sold
$470,000

Market trends in Barnstable

Last updated August 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$682K
$3.33KMoM
Sale-to-List Price
98.5%
0.3%MoM
Price per sq ft
$464
$3MoM
Available listings
309
37MoM

Around this home

Neighborhood Overview

Marstons Mills
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about Marstons Mills

At least 42 Trulia users voted on each feature.

  • 96 % Say car is needed

  • 96 % Say yards are well-kept

  • 94 % Say parking is easy

  • 88 % Say it's dog friendly

  • 82 % Say there's holiday spirit

  • 76 % Say people would walk alone at night

  • 75 % Say it's quiet

  • 71 % Say there's wildlife

  • 64 % Say kids play outside

  • 63 % Say neighbors are friendly

  • 60 % Say they plan to stay for at least 5 years

  • 47 % Say there are community events

  • 23 % Say it's walkable to grocery stores

  • 19 % Say there are sidewalks

  • 16 % Say streets are well-lit

Sourced by Trulia users. Learn more about our methodology.
  • Trulia User
    "Beautiful, calm safe feeling and friendly; access to multiple lovely venues and water activities, lush green landscaping everywhere"
    3
    Flag
  • Trulia User
    "perfect location. right near the highway. close to hyannis and mashpee. minutes from the beach. golf course 1 mile away. "
    0
    Flag
  • Trulia User
    "Most months easy to get around. But from Memorial Day through Labor Day you need to triple your time to get anywhere at any time. "
    0
    Flag
  • Ron.thalheimer
    "Many dogs in the neighborhood. People always walking them up and down the street. Most people pick up after their dogs but not all.. most dogs are friendly. Good neighborhood for dogs and dog owners. Would encourage all folks to look at the neighborhood."
    4
    Flag
  • Tish V.
    "Private community that holds meetings I have never gone too.... so I guess tight-nit. Everyone’s friendly and waves when drive. Unless you’re driving over 25mph then they shake their fist at you. "
    5
    Flag
  • Kathleenecolweb
    "summer annual get together local library events great location, close to other well known areas and great boat ramp for boating"
    1
    Flag
  • Afiguerido
    "Lots of privacy and people that live here have owned the same property for years. The town is like a family "
    2
    Flag
  • Chris P.
    "I’ve lived on cape cod my entire life and have lived Marstons Mills for the past 11 years. Great neighborhood and perfectly situated between Hyannis and Mashpee."
    1
    Flag
  • arlynschneider
    "Stable, pretty, year-round area. Every home is different. Active neighborhood association. Very friendly and impeccably maintained area. Pond and common space. Safe and pet-friendly. Gorgeous views of bogs."
    0
    Flag

LGBTQ Local Legal Protections

All data relating to real estate for sale on this page comes from the Broker Reciprocity (BR) of the Cape Cod & Islands Multiple Listing Service, Inc. Detailed information about real estate listings held by brokerage firms other than CC&I Assoc. of REALTORS®, Inc. includes the name of the listing company. Neither the listing company nor CC&I Assoc. of REALTORS®, Inc. shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. The Broker providing this data believes it to be correct, but advises interested parties to confirm any item before relying on it in a purchase decision. This site was last updated 2026-09-23 10:33:16 PDT. All properties are subject to prior sale, changes, or withdrawal. Copyright 2026© Cape Cod & Islands Multiple Listing Service, Inc. All rights reserved.

Frequently asked questions about 195 Route 149 #E

  • What is 195 Route 149 #E estimated to be worth?
    Trulia's estimated value for 195 Route 149 #E in Marstons Mills, MA is $743,700.
  • What is the price history for 195 Route 149 #E?
    195 Route 149 #E in Marstons Mills, MA last sold for $475,000 in March 2020.
  • Is Marstons Mills a buyer's or seller's market?
    Marstons Mills is currently a balanced market, based on recent for-sale activity.
  • What's the median sale price in Marstons Mills?
    The median sale price in Marstons Mills is $682K. That is down $3.33K from the prior month.
  • Does 195 Route 149 #E have air conditioning?
    Yes, 195 Route 149 #E in Marstons Mills, MA has air conditioning.

Explore by feature - Pet Friendly

12 pet-friendly rentals in Marstons Mills, MA

Explore by feature - Garage

11 rentals with a garage in Marstons Mills, MA

Explore by feature - Air Conditioning

38 rentals with air conditioning in Marstons Mills, MA

Explore by feature - Pool

8 rentals with a pool in Marstons Mills, MA

Explore by feature - Washer/dryer

49 rentals with a washer/dryer in Marstons Mills, MA

Explore by feature - Outdoor Space

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 195 Route 149 #E

Skip to last item
Skip to first item

Homes for sale near 195 Route 149 #E

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item