Overview Property Details Payment Calculator Walkability

Withdrawn

151 Irving Ave, Barnstable MA 02647

$3,995,000

Estimated $31,636.75/month Calculator

Single Family

6 Bedrooms

5 Full, 1 Half Baths

3,754 SqFt

Total Parking: 5 (1 Garage)

1 SqFt

Built in 1955

Wonderful home in the heart of Hyannis Port Village. Located within the Hyannis Port Civic Association. A short distance to the Post Office , Beach and Yacht Club. Beautiful Views of Nantucket Sound from the newly renovated 1200 blue stone terrace. First floor primary suite ...

This home has been viewed 60 times

Last Checked: October 7th, 2024 at 8:50pm (Source: MLS PIN #73213254)

Garage Parking

Air Conditioning

Waterview

General Information for 151 Irving Ave, Barnstable MA 02647

Listing ID73213254

Property TypeSingle Family / Detached

Price$3,995,000 ($1064.2/SqFt)

StyleCape

CityBarnstable

CountyBarnstable

MLS AreaHyannisport

Neighborhood(s)

Garage Parking1 / Detached

Zoningresidentia

AssociationNo

Year Built1955

Year Built SourcePublic Records

Year Renovated

Year Built DetailsActual

Handicap Access / FeaturesNo

Energy FeaturesNo

Interior Features for 151 Irving Ave, Barnstable MA 02647

Approximate Living Area Total3,754 SqFt

Living Area Includes BasementNo

Rooms13

Bedrooms6

Full Baths5

Half Baths1

Primary En Suite BathroomYes

BasementPartial

HeatingYes / Baseboard

CoolingYes / Window Unit(s)

Fireplaces1

AppliancesRange, Refrigerator, Dishwasher, Microwave, Washer, Dryer, Oven, Electric Water Heater

FlooringTile, Wood, Carpet

ElectricNo

Exterior Features for 151 Irving Ave, Barnstable MA 02647

Approximate Lot Size (Acres)0

Approximate Lot Size (Square Feet)1 SqFt

Total Parking5 (1 Garage)

Garage Parking1 / Detached

WaterPublic

SewerPrivate Sewer

Lot FeaturesNo

Parking FeaturesPaved Drive, Paved, Off Street, Attached, Shared Driveway

Exterior FeaturesSprinkler System, Patio

Foundation Area

Foundation MaterialsConcrete Perimeter,Block

Construction MaterialsBlock

Approximate Street Frontage

Road Frontage Type

Patio & Porch

Roof MaterialShingle

Utility Connections

Water ViewsYes

Water Views FeaturesSound, Harbor

WaterfrontNo

Waterfront FeaturesHarbor, Sound, Walk To, Beach Front, 1/10 To 3/10 To Beach, Beach Ownership(public, Association)

Private PoolNo

Pool FeaturesNo

Horse PermittedNo

Horse AmenitiesHarbor, Sound, Walk To, Beach Front, 1/10 To 3/10 To Beach, Beach Ownership(public, Association)

Disclosures for 151 Irving Ave, Barnstable MA 02647

Lead Paint

UFFI

Living Area Includes BasementNo

Living Area Disclosure

Building Area SourceAppraiser

Senior CommunityNo

Special Listing Conditions

For Sale By OwnerNo

Exclusions

Disclosures

Title 5

Buyer Agent Compensation2.5

Facilitator Compensation

Sub-Agent Compensation

Compensation Based OnNet Sale Price

Financial Information for 151 Irving Ave, Barnstable MA 02647

AssociationNo

Association Fee$0

Association Fee Frequency

Association Fee IncludesNo

Real Estate Tax$84,250

Tax Year2024

Assessed Value$122,800

Location Information for 151 Irving Ave, Barnstable MA 02647

Elementary School

Middle School

High School

Neighborhood(s)

MLS AreaHyannisport

Area AmenitiesHighway Access, House Of Worship, Shopping, Golf, Public Transportation, Marina

Contact Information for 151 Irving Ave, Barnstable MA 02647

Agent

Name: Dana Delorey

MLS ID: CN253207

Office ID: AN7941

National Association ID: 448011640

Address: 124 Longwood Avenue

City: Hyannis

State: MA

Zip: 02647

Office

Name: Mildred Linnell Real Estate

MLS Office ID: AN7941

Phone: 508-775-0709

Payment Calculator

$31,636.75 per month

30 Years Fixed, 6.75% Interest

Property Taxes $7,020.83

Principal & Interest $24,615.92

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Mildred Linnell Real Estate

Dana Delorey

Agent Phone

Office Phone

(508) 775-0709

Text Agent Call Agent Call Office

Array
(
    [acres] => 
    [add_date] => 2024-04-27 10:46:05
    [address] => Irving Ave
    [agent] => Array
        (
            [address] => 124 Longwood Avenue
            [city] => Hyannis
            [id] => CN253207
            [name] => Dana Delorey
            [national_association] => 448011640
            [office] => AN7941
            [state] => MA
            [zip] => 02647
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
            [0] => Range
            [1] => Refrigerator
            [2] => Dishwasher
            [3] => Microwave
            [4] => Washer
            [5] => Dryer
            [6] => Oven
            [7] => Electric Water Heater
        )

[approx_living_area_total] => 3,754 SqFt
    [approx_lot_size_acres] => 0
    [approx_lot_size_sqft] => 1 SqFt
    [assessed_value] => $122,800
    [association] => No
    [association_fee] => Array
        (
            [0] => $0
        )

[association_fee_frequency] => Array
        (
        )

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

[association_required] => Array
        (
        )

[available_date] => 
    [available_now] => Yes
    [basement] => Array
        (
            [0] => Partial
        )

[bathrooms] => 5 Full, 1 Half
    [bedrooms] => 6
    [building_amenities] => Array
        (
            [0] => No
        )

[building_area_source] => Array
        (
            [0] => Appraiser
        )

[building_management] => Array
        (
        )

[building_debug] => 151 Irving Ave Barnstable
    [building_id] => 
    [building_name] => 
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 2.5
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

[c_type] => Single Family
    [cap_rate] => -2.11%
    [city] => Barnstable
    [community_features] => Array
        (
            [0] => Highway Access
            [1] => House Of Worship
            [2] => Shopping
            [3] => Golf
            [4] => Public Transportation
            [5] => Marina
        )

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

[complex_complete] => Array
        (
        )

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

[construction_status] => 
    [cooling] => Yes / Window Unit(s)
    [cooperating_agent_commission] => Array
        (
        )

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

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => Wonderful home in the heart of Hyannis Port Village. Located within the Hyannis Port Civic Association. A short distance to the Post Office , Beach and Yacht Club. Beautiful Views of Nantucket Sound from the newly renovated 1200 blue stone terrace. First floor primary suite with views of harbor and Nantucket Sound. Large closets  for plenty of storage. There is a two Bedroom in-law/ au pair suite attached to the rear of the home with a separate entrance. The Living room has a working wood fireplace with views. The Kitchen has been updated in 2021 with stainless appliance and marble counter tops.Move in for the summer relax and enjoy all that Hyannis Port has to offer.
    [disclosures] => 
    [documents_available] => Array
        (
            [0] => No
        )

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

[electric_expense] => Array
        (
            [0] => $0
        )

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

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

[entry_level] => Array
        (
        )

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
        )

[exterior_features] => Array
        (
            [0] => Sprinkler System
            [1] => Patio
        )

[facilitator_compensation] => 
    [fee_paid_by_tennant] => Contact Agent
    [financial_data_source] => Array
        (
            [0] => No
        )

[fireplaces] => Array
        (
            [0] => 1
        )

[first_month_required] => Array
        (
        )

[floor_number] => 0
    [flooring] => Array
        (
            [0] => Tile
            [1] => Wood
            [2] => Carpet
        )

[for_sale_by_owner] => No
    [foundation_area] => 
    [foundation_materials] => Array
        (
            [0] => Concrete Perimeter,Block
        )

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

[gas_expense] => Array
        (
            [0] => $0
        )

[gross_income] => Array
        (
            [0] => $0
        )

[half_baths] => 1
    [handicap_access] => No
    [heating] => Yes / Baseboard
    [heating_expense] => Array
        (
            [0] => $0
        )

[high_school] => 
    [horse_features] => Array
        (
            [0] => Harbor
            [1] => Sound
            [2] => Walk To
            [3] => Beach Front
            [4] => 1/10 To 3/10 To Beach
            [5] => Beach Ownership(public
            [6] => Association)
        )

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

[id] => 309261
    [insurance_expense] => Array
        (
            [0] => $0
        )

[insurance_required] => Array
        (
        )

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

[last_month_required] => Array
        (
        )

[last_sync_date] => 2024-10-07 20:50:22
    [laundry_features] => Array
        (
        )

[lead_paint] => Array
        (
        )

[lease_term] => 
    [levels_in_unit] => 1
    [living_area] => 3,754 Sq. Ft.
    [living_area_disclosure] => Array
        (
        )

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

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

[management_expense] => Array
        (
            [0] => $0
        )

[middle_school] => 
    [miscellaneuos_expense] => Array
        (
            [0] => $0
        )

[mls_area] => Hyannisport
    [mls_id] => 73213254
    [neighborhoods] => Array
        (
        )

[net_income_calc] => -84250
    [net_operating_income] => Array
        (
            [0] => $0
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 1
    [office] => Array
        (
            [id] => AN7941
            [name] => Mildred Linnell Real Estate
            [phone] => 508-775-0709
        )

[operating_expense] => Array
        (
            [0] => $0
        )

[optional_fee_includes] => Array
        (
        )

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

[owner_occupancy_source] => 
    [parking_features] => Array
        (
            [0] => Paved Drive
            [1] => Paved
            [2] => Off Street
            [3] => Attached
            [4] => Shared Driveway
        )

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

[perc_test] => Array
        (
        )

[perc_test_date] => Unknown
    [pet_policy] => Array
        (
            [0] => No
        )

[phone] => 617-834-9289
    [pool_features] => Array
        (
            [0] => No
        )

[price] => $3,995,000
    [price_per_sqft] => 1064.2
    [price_per_unit] => 3995000
    [private_pool] => No
    [property_sub_type] => Array
        (
            [0] => Single Family Residence
        )

[real_estate_tax] => $84,250
    [references_required] => Array
        (
        )

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

[repair_maintenance_expense] => Array
        (
            [0] => $0
        )

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
            [0] => Shingle
        )

[rooms] => 13
    [senior_community] => No
    [sewer] => Array
        (
            [0] => Private Sewer
        )

[sewer_expense] => Array
        (
            [0] => $0
        )

[short_sale] => 
    [special_listing_conditions] => Array
        (
        )

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

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

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

[subagent_compensation] => 
    [tag_accessible_features] => 
    [tag_air_conditioning] => 1
    [tag_association_pool] => 
    [tag_beach_access] => 
    [tag_beach_front] => 1
    [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] => 2024
    [team] => Array
        (
        )

[terms] => Array
        (
        )

[timber_acres] => None
    [title_5] => 
    [total_gross_expense] => 84250
    [total_gross_income] => 0
    [total_parking] => 5 (1 Garage)
    [trash_expense] => Array
        (
            [0] => $0
        )

[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] => Array
        (
            [0] => 151 Irving Ave, Barnstable MA 02647
        )

[utilities] => Array
        (
        )

[view] => Array
        (
        )

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

[water_expense] => Array
        (
            [0] => $0
        )

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

[water_views_features] => Array
        (
            [0] => Sound
            [1] => Harbor
        )

[waterfront] => No
    [waterfront_features] => Array
        (
            [0] => Harbor
            [1] => Sound
            [2] => Walk To
            [3] => Beach Front
            [4] => 1/10 To 3/10 To Beach
            [5] => Beach Ownership(public
            [6] => Association)
        )

[year_built] => 1955
    [year_built_details] => Actual
    [year_built_source] => Public Records
    [year_renovated] => 
    [zip] => 02647
    [zoning] => residentia
    [zoning_details] => 
    [media] => Array
        (
            [0] => Array
                (
                    [id] => 37200345
                    [name] => MLS1.jpg
                    [type] => gallery
                    [category] => image
                    [url] => https://www.bostonrealestate.com/wp-content/uploads/WPL/309261/MLS1.jpg
                    [index] => 1
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:29
                    [modified] => 2024-10-07 20:50:29
                )

[1] => Array
                (
                    [id] => 37201658
                    [name] => MLS2.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=2
                    [index] => 2
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[2] => Array
                (
                    [id] => 37201659
                    [name] => MLS3.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=3
                    [index] => 3
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[3] => Array
                (
                    [id] => 37201660
                    [name] => MLS4.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=4
                    [index] => 4
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[4] => Array
                (
                    [id] => 37201661
                    [name] => MLS5.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=5
                    [index] => 5
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[5] => Array
                (
                    [id] => 37201662
                    [name] => MLS6.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=6
                    [index] => 6
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[6] => Array
                (
                    [id] => 37201663
                    [name] => MLS7.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=7
                    [index] => 7
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[7] => Array
                (
                    [id] => 37201664
                    [name] => MLS8.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=8
                    [index] => 8
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[8] => Array
                (
                    [id] => 37201665
                    [name] => MLS9.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=9
                    [index] => 9
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[9] => Array
                (
                    [id] => 37201666
                    [name] => MLS10.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=10
                    [index] => 10
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[10] => Array
                (
                    [id] => 37201667
                    [name] => MLS11.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=11
                    [index] => 11
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[11] => Array
                (
                    [id] => 37201668
                    [name] => MLS12.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=12
                    [index] => 12
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[12] => Array
                (
                    [id] => 37201669
                    [name] => MLS13.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=13
                    [index] => 13
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

[13] => Array
                (
                    [id] => 37201670
                    [name] => MLS14.jpg
                    [type] => gallery
                    [category] => external
                    [url] => https://media.mlspin.com/photo.aspx?mls=73213254&w=1024&h=768&n=14
                    [index] => 14
                    [enabled] => 1
                    [created] => 2024-10-07 20:50:42
                    [modified] => 2024-10-07 20:50:42
                )

)

)

EXIT