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

195 Route 149 #E
Marstons Mills, MA 02648

Marstons Mills
  • 3 Beds
  • 3 Baths
  • 2,019 sqft

$713,400

Trulia Estimate
as of Aug 8, 2026
Est. Refi. Payment $4,102/mo*
Refinance Your Home

$713,400

Trulia Estimate
as of Aug 8, 2026
Est. Refi. Payment $4,102/mo*
Refinance Your Home
3 Beds
3 Baths
2,019 sqft

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

Property Type
Condo
Year Built
2002
Living Area
2,019 sqft
Price/Sqft
$353
Parking
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). It is currently off market. The Trulia Estimate is $713,400, with a rent estimate of $3,911/month.

Home Details for 195 Route 149 #E

Interior Features

Interior Details
Basement: Finished,Interior Entry,FullNumber of Rooms: 6
Beds & Baths
Number of Bedrooms: 3Number of Bathrooms: 4Number of Bathrooms (full): 2Number of Bathrooms (half): 2Number of Bathrooms (main level): 2
Dimensions and Layout
Living Area: 2019 Square Feet
Appliances & Utilities
Appliances: Gas Water Heater
Heating & Cooling
Heating: Forced AirHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Number of Fireplaces: 1Has a Fireplace
Windows, Doors, Floors & Walls
Flooring: Carpet, Tile, HardwoodCommon Walls: No Common Walls
Levels, Entrance, & Accessibility
Stories: 2Floors: Carpet, Tile, Hardwood

Exterior Features

Exterior Home Features
Roof: Asphalt PitchedExterior: Private YardFoundation: PouredNo Private Pool
Parking & Garage
Number of Garage Spaces: 1Number of Covered Spaces: 1No CarportHas a GarageHas an Attached GarageHas Open ParkingParking Spaces: 1Parking: Garage Attached, Open
Frontage
Road Frontage: Private Road, Dead End StreetRoad Surface Type: PavedNot on Waterfront
Water & Sewer
Sewer: Septic Tank, Private Sewer
Finished Area
Finished Area (below surface): 750 Square Feet

Days on Market

Cumulative Days on Market: 286

Property Information

Year Built
Year Built: 2002
Property Type / Style
Property Type: ResidentialProperty Subtype: CondominiumStructure Type: OtherArchitecture: Other
Building
Building Name: Herring RunConstruction Materials: Shingle SidingNot a New ConstructionNot Attached PropertyDoes Not Include Home Warranty
Property Information
Condition: ApproximateParcel Number: 7818040E

Price & Status

Price
List Price: $499,000

Active Status

MLS Status: Closed

Location

Direction & Address
City: Marstons Mills
School Information
Elementary School District: BarnstableJr High / Middle School District: BarnstableHigh School District: Barnstable

Building

Building Area
Building Area: 2019 Square Feet

Community

Units in Building: 9

HOA

Has an HOA

Listing Info

Special Conditions: None

Offer

Listing Terms: Conventional

Business

Business Information
Ownership: Condo

Miscellaneous

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

Additional Information

HOA Amenities: Road Maintenance, Snow Removal
Last check for updates: about 6 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

Price History for 195 Route 149 #E

DatePriceEventSource
03/03/2020$475,000Sold
CCIMLS #21902010
07/23/2012$470,000Sold
CCIMLS #21100172

Market trends in Barnstable

Last updated June 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$702K
$29.31KMoM
Sale-to-List Price
98.2%
0.1%MoM
Price per sq ft
$442
$11MoM
Available listings
366
23MoM
Skip to last item
  • Results are loading
Skip to first item

Comparable Sales for 195 Route 149 #E

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
3040 Falmouth Road UNIT H, Osterville, MA
0.89
Condo
$327,000
01/28/26
2
1
594
39 Blossom Avenue APT 4, Osterville, MA
2.23
Condo
$568,000
04/09/26
2
2
1,320
920 Main St #2-1, Barnstable, MA
2.23
Condo
$600,000
04/17/26
2
2
1,150
920 Main Street Unit 1 Building 2, Osterville, MA
2.24
Condo
$600,000
04/17/26
2
2
1,150
39 Tower Hill Road APT 18A, Osterville, MA
2.33
Condo
$600,000
04/08/26
2
2
1,278
39 Tower Hill Road APT 15B, Osterville, MA
2.33
Condo
$719,000
06/22/26
2
2
1,260
39 Tower Hill Road #1C, Osterville, MA
2.39
Condo
$545,000
12/11/25
2
2
1,131
39 Tower Hill Rd #1C, Barnstable, MA
2.40
Condo
$545,000
12/11/25
2
2
1,131
675 Main St #C1, Barnstable, MA
2.58
Condo
$765,000
10/17/25
2
2.5
1,812
35 Santuit Pond Road UNIT 4C, Mashpee, MA
2.47
Condo
$400,000
05/29/26
2
1.5
1,331

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 195 Route 149 #E.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

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

  • 74 % 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. "
    4
    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."
    0
    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

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature - Pet Friendly

8 pet-friendly rentals in Marstons Mills, MA

Explore by feature - Garage

9 rentals with a garage in Marstons Mills, MA

Explore by feature - Air Conditioning

22 rentals with air conditioning in Marstons Mills, MA

Explore by feature - Pool

6 rentals with a pool in Marstons Mills, MA

Explore by feature - Washer/dryer

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

Homes for sale near 195 Route 149 #E

Skip to last item
Skip to first item

Off Market Homes Near 195 Route 149 #E

Skip to last item
Skip to first item

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 $713,400.
  • 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 $702K. That is up $29.31K from the prior month.
  • Does 195 Route 149 #E have air conditioning?
    Yes, 195 Route 149 #E in Marstons Mills, MA has air conditioning.
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 2022-04-05 08:58:10 PDT. All properties are subject to prior sale, changes, or withdrawal. Copyright 2022© Cape Cod & Islands Multiple Listing Service, Inc. All rights reserved.