NOT LISTED FOR SALE

195 Route 149 Unit G Barnstable, MA 02648

Marstons Mills Neighborhood
4 Beds
3.5 Baths
2,040 Sq Ft
2003 Built

Sale Details

Date Sold: June 27, 2014

Last sale price $490,000 $240 Per Sq Ft

71 Days on Market

Highlights

  • Medical Services
  • Deck
  • Main Floor Primary Bedroom
  • West Villages Elementary School Rated A-
  • Wood Flooring
  • 1 Car Attached Garage

About This Home

As of June 2014

This beautifully decorated Bayside built free standing condo, in the heart of the village, is spacious and elegant. This home offers a warm and inviting flexible floor plan. The kitchen with granite countertops, subzero refrigerator, and SS appliances is open to a bright, sunny dining area with access to deck. The living room offers picturesque windows and gorgeous fireplace perfectly suited for a cozy night by the fire or entertaining. The 1st floor master bedroom has private bathroom and deck. The spacious 2nd floor has 2 bedrooms, a full bath & den. Beautifully finished lower level with a light filled bedroom, private bath & family room offers plenty of space for guests. All minutes to beaches, shopping & restaurants Osterville or Mashpee Commons has to offer. Buyers are to verify all information, sq. footage & taxes as they may vary.

Last Agent to Sell the Property

Jillian Jones

Kinlin Grover Real Estate License #9520311 Listed on: 03/24/2014

Last Buyer's Agent

Colleen Riley

Unique Real Estate

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $3,384

Year Built

  • Built in 2003

Lot Details

  • Property fronts a private road
  • No Common Walls
  • Street terminates at a dead end

Parking

  • 1 Car Attached Garage
  • Guest Parking
  • Open Parking

Home Design

  • Entry on the 1st floor
  • Pitched Roof
  • Asphalt Roof
  • Shingle Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,040 Sq Ft Home
  • 2-Story Property
  • Built-In Features
  • Gas Fireplace
  • French Doors
  • Living Room
  • Finished Basement
  • Interior Basement Entry
  • Breakfast Bar
  • Laundry Room

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom

Additional Features

  • Deck
  • Property is near golf course and shops

Listing and Financial Details

  • Assessor Parcel Number 07801840G

Community Details

Overview

  • Property has a Home Owners Association
  • Near Conservation Area

Amenities

  • Medical Services
  • Common Area

Recreation

  • Snow Removal

Pet Policy

  • Pets Allowed

Property Details

Home Type

Condominium

Est. Annual Taxes

$3,384

Year Built

Built in 2003

Lot Details

0 Sq Ft Lot

Parking

1

Listing Details

  • Has Basement: Finished, Interior Entry
  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Road Frontage Type: Private Road, Dead End Street
  • Road Surface Type: Paved
  • Ownership: Condo
  • Directions: From Route 28 turn onto Route 149 and take a left at the entrance of the Marstons Mills Post Office. Herring Run Place will be on your right. 195G is third on the left.
  • Building Name: Herring Run
  • Carport Y N: No
  • Entry Level: 1
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Kitchen Level: First
  • Special Features: None
  • Stories: 2

Interior Features

  • Appliances: Security System
  • Total Bedrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Door Features: French Doors
  • Entry Location: First Floor
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Wood, Carpet, Tile
  • Room Bedroom3 Features: Bedroom 3, Walk-In Closet(s), Built-in Features
  • Room Bedroom4 Level: Basement
  • Living Room Living Room Level: First
  • Kitchen Description: Countertop(s): Granite,Flooring: Wood
  • Bedroom 2 Description: Flooring: Carpet
  • Room Bedroom4 Features: Bedroom 4, Closet
  • Master Bedroom Master Bedroom Level: First
  • Primary Bedroom Description: Flooring: Wood,Door(s): French
  • Bedroom 3 Description: Flooring: Carpet
  • Room Bedroom3 Level: Second
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Bedroom 2, Closet
  • Master Bedroom Features: Deck, Closet, Built-in Features
  • Room Kitchen Features: Kitchen, Upgraded Cabinets, Breakfast Bar, Deck
  • Living Room Features: Living Room
  • Bedroom 4 Description: Flooring: Carpet
  • Master Bathroom Features: Private Full Bath

Exterior Features

  • Lot Features: Conservation Area, School, Medical Facility, Major Highway, Near Golf Course, Shopping, In Town Location
  • Pool Private: No
  • Waterfront: No
  • Home Warranty: No
  • Common Walls: No Common Walls
  • Construction Type: Shingle Siding
  • Foundation Details: Concrete Perimeter
  • Patio And Porch Features: Deck
  • Property Condition: Approximate
  • Roof: Asphalt, Pitched

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 1
  • Open Parking: Yes
  • Parking Features: Guest

Utilities

  • Laundry Features: Laundry Room, In Basement

Condo/Co-op/Association

  • Amenities: Common Area, Snow Removal, Road Maintenance
  • Association: Yes

Lot Info

  • Zoning: Split Mmvd, Rf
  • Land Lease: No
  • Parcel #: 07801840G

Rental Info

  • PetsAllowed: Yes

Building Info

  • Year Built: 2003

Tax Info

  • Tax Year: 2013
  • Tax Annual Amount: 3384
  • Tax Book Number: 19096
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

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
06/27/2014 06/27/14 Sold $490,000 -8.4% $240 / Sq Ft
06/04/2014 06/04/14 Pending -- -- --
03/24/2014 03/24/14 For Sale $535,000 -- $262 / Sq Ft
Source: Cape Cod & Islands Association of REALTORS®

Agents Affiliated with this Home

  • J

    Seller's Agent in 2014

    Jillian Jones

    Kinlin Grover Real Estate

  • C

    Buyer's Agent in 2014

    Colleen Riley

    Unique Real Estate

See All Agents

Map

Source: Cape Cod & Islands Association of REALTORS®

MLS Number: 21401890

Cape Cod & Islands Association of REALTORS®
Massachusetts Barnstable County Barnstable 02648 Marstons Mills

195 Route 149 Unit G, Barnstable, MA

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Cape Cod & Islands Association of REALTORS® 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. All properties are subject to prior sale, changes, or withdrawal. Copyright 2026 © Cape Cod & Islands Multiple Listing Service, Inc. All rights reserved.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.