Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Closed

151 Pimlico Pond Rd, Mashpee MA 02649

$1,195,000

Estimated $7,937/month Calculator

Single Family

5 Bedrooms

Baths

3758

Total Parking: 9 (3 Garage)

79,995 (1.84)

Built in 1997

Welcome to your exquisite Cape Cod dream home, situated on almost 2 private acres. This luxurious 5BR/4.5BA property is comprised of three separate living spaces. The main house features a stunning open concept floor plan with high-end finishes throughout. The first floor level offers a spacious living room, dining area, gourmet kitchen, office and first floor primary bedroom. The lower level has a family/media room with high ceilings, laundry room, storage AND a 1BR/1BA guest quarters with a private entrance and second kitchen. The detached 3-car garage has a legal 1BR/1BA apartment, fully permitted and completed in 2022. The spectacularly landscaped grounds and large yard with back deck, pergola and patio completing the outdoor living space. Don't miss your chance to experience the epitome of quintessential Cape Cod living. 151 and 161 Pimlico Pond Road being sold together. Note: All information provided is deemed reliable, but is not guaranteed and should be independently verified.

This home has been viewed 36 times

Last Checked: May 10th, 2024 at 5:53pm (Source: MLS PIN #73083327)

Garage Parking

Air Conditioning

General Information for 151 Pimlico Pond Rd, Mashpee MA 02649

Listing ID73083327

Property TypeSingle Family / Detached

Price$1,195,000 ($317.99/SqFt)

StyleColonial

CityMashpee

CountyBarnstable

Neighborhood(s)

Garage Parking3

ZoningR5

Year Built1997

Year Built SourcePublic Records

Year Built DetailsActual

Interior Features for 151 Pimlico Pond Rd, Mashpee MA 02649

Approximate Living Area Total3758

Living Area Includes BasementYes

Rooms6

Bedrooms5

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric220 Volts

Exterior Features for 151 Pimlico Pond Rd, Mashpee MA 02649

Approximate Lot Size (Acres)1.84

Approximate Lot Size (Square Feet)79995

Total Parking9 (3 Garage)

Garage Parking3

WaterPublic

SewerInspection Required For Sale

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction MaterialsFrame

Road Frontage Type

Patio & Porch

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections

Water Views

Water Views Features

Waterfront FeaturesRiver

Pool Features

Horse AmenitiesRiver

Disclosures for 151 Pimlico Pond Rd, Mashpee MA 02649

Lead Paint

UFFI

Living Area Includes BasementYes

Living Area Disclosure

Building Area SourcePublic Records

Special Listing Conditions

ExclusionsTv On The Deck And Garage Tv

Buyer Agent Compensation2.5%

Facilitator Compensation2.5%

Compensation Based OnNet Sale Price

Financial Information for 151 Pimlico Pond Rd, Mashpee MA 02649

Association Fee

Association Fee Frequency

Association Fee Includes

Real Estate Tax6880

Tax Year2022

Assessed Value$883,500

Location Information for 151 Pimlico Pond Rd, Mashpee MA 02649

Neighborhood(s)

Area AmenitiesWalk/jog Trails

Contact Information for 151 Pimlico Pond Rd, Mashpee MA 02649

Agent

Name: Livia Freitas Monteforte

Office

Name: Compass

Phone: 508-206-8726

Payment Calculator

, Interest

Property Taxes 573.33

Principal & Interest 7363.21

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Compass

Livia Freitas Monteforte

Agent Phone

Office Phone

(508) 206-8726

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 1.84 acres (79,995 SqFt)
    [add_date] => 2024-05-10 17:53:55
    [address] => Pimlico Pond Rd
    [agent] => Array
        (
            [address] => 29 South Street, Unit B South
            [city] => Mashpee
            [id] => A9501656
            [name] => Livia Freitas Monteforte
            [national_association] => 448003385
            [office] => AN6584
            [state] => MA
            [zip] => 02649
        )

[apod_available] => Array
        (
        )

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

[approx_living_area_total] => 3758
    [approx_lot_size_acres] => 1.84
    [approx_lot_size_sqft] => 79995
    [assessed_value] => $883,500
    [association] => 
    [association_fee] => Array
        (
        )

[association_fee_frequency] => Array
        (
        )

[association_fee_includes] => Array
        (
        )

[association_required] => Array
        (
        )

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

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

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

[building_management] => Array
        (
        )

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

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

[cap_rate] => 
    [city] => Mashpee
    [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] => Welcome to your exquisite Cape Cod dream home, situated on almost 2 private acres. This luxurious 5BR/4.5BA property is comprised of three separate living spaces. The main house features a stunning open concept floor plan with high-end finishes throughout. The first floor level offers a spacious living room, dining area, gourmet kitchen, office and first floor primary bedroom. The lower level has a family/media room with high ceilings, laundry room, storage AND a 1BR/1BA guest quarters with a private entrance and second kitchen. The detached 3-car garage has a legal 1BR/1BA apartment, fully permitted and completed in 2022. The spectacularly landscaped grounds and large yard with back deck, pergola and patio completing the outdoor living space. Don't miss your chance to experience the epitome of quintessential Cape Cod living. 151 and 161 Pimlico Pond Road being sold together. Note: All information provided is deemed reliable, but is not guaranteed and should be independently verified.
    [disclosures] => 
    [documents_available] => Array
        (
        )

[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] => Tv On The Deck And Garage Tv
        )

[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] => 3
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

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

[high_school] => 
    [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-10 17:53:55
    [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] => 
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => 
    [mls_id] => 73083327
    [neighborhoods] => 
    [net_income_calc] => -6880
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => AN6584
            [name] => Compass
            [phone] => 508-206-8726
        )

[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] => Allowed
        )

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

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

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

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

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

[rooms] => 6
    [schools] => 
    [senior_community] => 
    [sewer] => Array
        (
            [0] => Inspection Required For Sale
        )

[sewer_expense] => Array
        (
        )

[short_sale] => Array
        (
        )

[special_listing_conditions] => Array
        (
        )

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

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

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

[subagent_compensation] => 
    [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] => 
    [tax_year] => 2022
    [team] => 
    [team_agents] => Array
        (
        )

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => 
    [total_gross_expense] => 6880
    [total_gross_income] => 0
    [total_parking] => 9 (3 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] => 
    [units_owner_occupied] => 
    [unparsed] => 151 Pimlico Pond Rd, Mashpee MA 02649
    [utilities] => Array
        (
        )

[view] => Array
        (
        )

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

[water_expense] => Array
        (
        )

[water_views] => Array
        (
        )

[water_views_features] => Array
        (
        )

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

[raw] => 
)

EXIT

39 More Photos