Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Canceled

195 Route 149 # G, Barnstable MA 02648

$799,000

Estimated $5,222/month Calculator

Single Family

3 Bedrooms

Baths

2814

Total Parking: 4 (1 Garage)

0 (0.00)

Built in 2003

Herring Run Place is tucked off the Road in a quiet neighborhood in the heart of Marstons Mills with 9 uniquely designed single family homes on a private road. You'll fall in love with this custom dream home that draws you in though the front porch to the bright and open living room with warm wood floors and a gas fireplace. The living room flows into the kitchen with custom cherry cabinets, granite counters, Sub Zero refrigerator, gas stove and spacious dining area. The 1st floor family room with full bath could serve as a primary bedroom. There's also a mudroom and half bath on the 1st floor. Upstairs hosts 3 bedrooms and a full bath. The lower level is tastefully finished with plenty of room for family and friends to visit, full bath, laundry, fitness area and space for a home office. The exterior is complimented with a mahogany deck and lush green lawn. Exclusive use of the land transfers with the property. Please see exclusive use map. Walk to the Morning Glory Cafe, Post Offic

This home has been viewed 48 times

Last Checked: May 7th, 2024 at 1:51am (Source: MLS PIN #73060413)

Garage Parking

Air Conditioning

Waterview

General Information for 195 Route 149 # G, Barnstable MA 02648

Listing ID73060413

Property TypeSingle Family / Detached

Price$799,000 ($283.94/SqFt)

StyleColonial

CityBarnstable

CountyBarnstable

MLS AreaMarstons Mills

Neighborhood(s)

Garage Parking1

Zoning101

Association0

Year Built2003

Year Built SourcePublic Records

Year Built DetailsActual

Interior Features for 195 Route 149 # G, Barnstable MA 02648

Approximate Living Area Total2814

Living Area Includes BasementYes

Rooms7

Bedrooms3

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric220 Volts

Exterior Features for 195 Route 149 # G, Barnstable MA 02648

Approximate Lot Size (Acres)0

Approximate Lot Size (Square Feet)0

Total Parking4 (1 Garage)

Garage Parking1

WaterPublic

SewerPrivate Sewer

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction MaterialsFrame

Road Frontage Type

Patio & Porch

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections

Water ViewsNo

Water Views Features

Waterfront FeaturesRiver

Pool Features

Horse AmenitiesRiver

Disclosures for 195 Route 149 # G, Barnstable MA 02648

Lead Paint

UFFI

Living Area Includes BasementYes

Living Area Disclosure

Building Area SourcePublic Records

Special Listing Conditions

ExclusionsPersonal Belongings

Buyer Agent Compensation2.5%

Facilitator Compensation2.5%

Sub-Agent Compensation2.5%

Compensation Based OnNet Sale Price

Financial Information for 195 Route 149 # G, Barnstable MA 02648

Association0

Association Fee

Association Fee FrequencyAnnually

Association Fee Includes

Real Estate Tax3580

Tax Year2023

Assessed Value$547,700

Location Information for 195 Route 149 # G, Barnstable MA 02648

Middle SchoolBarnstable

High SchoolBarnstable

Neighborhood(s)

MLS AreaMarstons Mills

Area AmenitiesWalk/jog Trails

Contact Information for 195 Route 149 # G, Barnstable MA 02648

Agent

Name: Colleen Riley

Office

Name: Sotheby's International Realty

Phone: 508-428-9115

Payment Calculator

, Interest

Property Taxes 298.33

Principal & Interest 4923.18

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Sotheby's International Realty

Colleen Riley

Agent Phone

Office Phone

(508) 428-9115

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 0 acres (0 SqFt)
    [add_date] => 2024-05-07 01:51:52
    [address] => Route 149
    [agent] => Array
        (
            [address] => 447 Bay Lane
            [city] => Barnstable
            [id] => A9501589
            [name] => Colleen Riley
            [national_association] => 448000713
            [office] => AN0730
            [state] => MA
            [zip] => 02632
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
            [0] => Range
        )

[approx_living_area_total] => 2814
    [approx_lot_size_acres] => 0
    [approx_lot_size_sqft] => 0
    [assessed_value] => $547,700
    [association] => 0
    [association_fee] => Array
        (
        )

[association_fee_frequency] => Array
        (
            [0] => Annually
        )

[association_fee_includes] => Array
        (
        )

[association_required] => Array
        (
        )

[available_date] => 
    [available_now] => 0
    [basement] => Array
        (
            [0] => Full
        )

[bathrooms] => 
    [bedrooms] => 3
    [building_amenities] => Array
        (
        )

[building_area_source] => Array
        (
            [0] => Public Records
        )

[building_management] => Array
        (
        )

[building_debug] => 
    [building_id] => 
    [building_parent] => 0
    [building_name] => Herring Run Place
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 2.5%
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

[c_type] => Array
        (
            [0] => Single Family
        )

[cap_rate] => 
    [city] => Barnstable
    [community_features] => Array
        (
            [0] => Walk/jog Trails
        )

[compensation_based_on] => Array
        (
            [0] => Net Sale Price
        )

[complex_complete] => Array
        (
        )

[construction_materials] => Array
        (
            [0] => Frame
        )

[construction_status] => 
    [cooling] => Array
        (
            [0] => 1
            [1] => Split
        )

[cooperating_agent_commission] => Array
        (
        )

[county] => Barnstable
    [cultivation_acres] => 
    [date_available_note] => 
    [deposit_amount] => Array
        (
        )

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => Herring Run Place is tucked off the Road in a quiet neighborhood in the heart of Marstons Mills with 9 uniquely designed single family homes on a private road. You'll fall in love with this custom dream home that draws you in though the front porch to the bright and open living room with warm wood floors and a gas fireplace. The living room flows into the kitchen with custom cherry cabinets, granite counters, Sub Zero refrigerator, gas stove and spacious dining area. The 1st floor family room with full bath could serve as a primary bedroom. There's also a mudroom and half bath on the 1st floor. Upstairs hosts 3 bedrooms and a full bath.  The lower level is tastefully finished with plenty of room for family and friends to visit, full bath, laundry, fitness area and space for a home office. The exterior is complimented with a mahogany deck and  lush green lawn.  Exclusive use of the land transfers with the property. Please see exclusive use map. Walk to the Morning Glory Cafe, Post Offic
    [disclosures] => 
    [documents_available] => Array
        (
            [0] => Perc Test
        )

[electric] => Array
        (
            [0] => 220 Volts
        )

[electric_expense] => Array
        (
        )

[elementary_school] => 
    [en_suite_bath] => Array
        (
            [0] => Yes
        )

[energy_features] => 
    [entry_level] => Array
        (
        )

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
            [0] => Personal Belongings
        )

[exterior_features] => Array
        (
            [0] => Porch
        )

[facilitator_compensation] => 2.5%
    [fee_paid_by_tennant] => 
    [financial_data_source] => Array
        (
        )

[fireplaces] => Array
        (
        )

[first_month_required] => Array
        (
        )

[floor_number] => 0
    [flooring] => Array
        (
            [0] => Tile
        )

[for_sale_by_owner] => 
    [foundation_area] => 
    [foundation_materials] => Array
        (
        )

[frontage_length] => 
    [full_baths] => 
    [garage_parking] => 1
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

[half_baths] => 
    [handicap_access] => 
    [heating] => 
    [heating_expense] => Array
        (
        )

[high_school] => Barnstable
    [horse_features] => Array
        (
            [0] => River
        )

[horse_permitted] => 
    [hot_water] => Array
        (
        )

[id] => 
    [insurance_expense] => Array
        (
        )

[insurance_required] => Array
        (
        )

[interior_features] => Array
        (
            [0] => French Doors
        )

[last_month_required] => Array
        (
        )

[last_sync_date] => 2024-05-07 01:51:52
    [laundry_features] => Array
        (
        )

[lead_paint] => Array
        (
        )

[lease_term] => Array
        (
        )

[levels_in_unit] => 
    [living_area] => 
    [living_area_disclosure] => Array
        (
        )

[living_area_includes_basement] => Array
        (
            [0] => Yes
        )

[lot_features] => Array
        (
            [0] => Gentle Sloping
        )

[management_expense] => Array
        (
        )

[middle_school] => Barnstable
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => Marstons Mills
    [mls_id] => 73060413
    [neighborhoods] => 
    [net_income_calc] => -3580
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => AN0730
            [name] => Sotheby's International Realty
            [phone] => 508-428-9115
        )

[operating_expense] => Array
        (
        )

[optional_fee_includes] => Array
        (
        )

[optional_price] => 0
    [outdoor_space_available] => Array
        (
        )

[owner_occupancy_source] => 
    [parking_features] => Array
        (
            [0] => 1
        )

[pasture_area] => 
    [patio_and_porch] => Array
        (
        )

[perc_test] => Array
        (
        )

[perc_test_date] => 
    [pet_policy] => Array
        (
            [0] => Not Allowed
        )

[phone] => 
    [pool_features] => Array
        (
        )

[price] => 799000
    [price_per_sqft] => 283.94
    [price_per_unit] => 799000
    [private_pool] => 
    [property_sub_type] => Array
        (
            [0] => Single Family Residence
        )

[real_estate_tax] => 3580
    [references_required] => Array
        (
        )

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
            [0] => Asphalt/fiberglass Shingles
        )

[rooms] => 7
    [schools] => 
    [senior_community] => 
    [sewer] => Array
        (
            [0] => Private Sewer
        )

[sewer_expense] => Array
        (
        )

[short_sale] => Array
        (
        )

[special_listing_conditions] => Array
        (
        )

[state] => Massachusetts
    [state_code] => MA
    [status] => Array
        (
            [0] => Canceled
        )

[street_number] => 195
    [structure_type] => Array
        (
        )

[style] => Array
        (
            [0] => Colonial
        )

[subagent_compensation] => 2.5%
    [tag_accessible_features] => 
    [tag_air_conditioning] => 1
    [tag_association_pool] => 
    [tag_beach_access] => 
    [tag_beach_front] => 
    [tag_elevator] => 
    [tag_equestrian] => 
    [tag_garage_parking] => 1
    [tag_generator] => 
    [tag_green_features] => 
    [tag_laundry] => 
    [tag_lead_paint_free] => 
    [tag_loft] => 
    [tag_pet_friendly] => 
    [tag_pre_construction] => 
    [tag_private_outdoor_space] => 
    [tag_private_pool] => 
    [tag_professional_management] => 
    [tag_recently_renovated] => 
    [tag_senior_community] => 
    [tag_townhouse] => 
    [tag_waterfront] => 
    [tag_waterview] => 1
    [tax_year] => 2023
    [team] => 
    [team_agents] => Array
        (
        )

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => 
    [total_gross_expense] => 3580
    [total_gross_income] => 0
    [total_parking] => 4 (1 Garage)
    [trash_expense] => Array
        (
        )

[travel_routes] => 
    [uffi] => Array
        (
        )

[unit_1_bathrooms] => 
    [unit_1_bedrooms] => 
    [unit_1_floor] => 
    [unit_1_lease] => Array
        (
        )

[unit_1_levels] => 
    [unit_1_rent] => Array
        (
        )

[unit_2_bathrooms] => 
    [unit_2_bedrooms] => 
    [unit_2_floor] => 
    [unit_2_lease] => Array
        (
        )

[unit_2_levels] => 
    [unit_2_rent] => Array
        (
        )

[unit_3_bathrooms] => 
    [unit_3_bedrooms] => 
    [unit_3_floor] => 
    [unit_3_lease] => Array
        (
        )

[unit_3_levels] => 
    [unit_3_rent] => Array
        (
        )

[unit_4_bathrooms] => 
    [unit_4_bedrooms] => 
    [unit_4_floor] => 
    [unit_4_lease] => Array
        (
        )

[unit_4_levels] => 
    [unit_4_rent] => Array
        (
        )

[unit_level] => 
    [unit_number] => G
    [units_owner_occupied] => 
    [unparsed] => 195 Route 149 # G, Barnstable MA 02648
    [utilities] => Array
        (
        )

[view] => Array
        (
        )

[water] => Array
        (
            [0] => Public
        )

[water_expense] => Array
        (
        )

[water_views] => Array
        (
            [0] => No
        )

[water_views_features] => Array
        (
        )

[waterfront] => 
    [waterfront_features] => Array
        (
            [0] => River
        )

[raw] => 
)

EXIT

32 More Photos