Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Withdrawn

151 Irving Ave Barnstable. MA 02647

$3,995,000

Single Family

6 Bedrooms

5.5 Bathrooms

3,754 sq ft

4 Parking Spots

0 Acres

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 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.

This listing has been viewed 24 times in the past 213 days

Last Updated: October 7th, 2024 at 8:50pm

Highway Access

House Of Worship

Shopping

Golf

Public Transportation

Marina

General Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Property TypeResidential

Property Sub TypeResidential

Price$3,995,000

Price per sqft$1,064.20

MLS #73213254

Handicap Access / FeaturesYes

List Date2024-02-27

List Price$3,995,000

Special Listing ConditionsNo

Specific Zoning Coderesidentia

StateMassachusetts

Street NameIrving Ave

Style

TownBarnstable

CityBarnstable

Zip Code02647

CountyBarnstable

StatusWithdrawn

MLS Status

AssociationNo

Covered Parking Spaces1

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones

Attached/DetachedYes

Sold Date

Green Energy Efficient

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourceAppraiser

Building Area Total3754

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces1

Listing Service

UnparsedAddress151 Irving Ave, Barnstable MA 02647

Zoning

Interior Features for 151 Irving Ave, Barnstable, Massachusetts 02647

Master BathYes

* Approx. Living Area Total3,754 sq ft

Living Area Includes BasementNo

* Living Area Source7

Bedrooms6

* # Fireplaces1

Bathrooms (Total)5.5

Full Baths5

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area Disclosure

Living Area Includes BasementNo

Door FeaturesStorm Door(s)

ElectricYes

Electric$0

MLS Area (Major)Hyannisport

OffMarketDate04/09/2024

Exterior Features for 151 Irving Ave, Barnstable, Massachusetts 02647

* Approximate Lot Size0 acres

Covered Parking Spaces1

Lot FeaturesNo

* Parking Spaces4

* Sewer Utilities

* Water Utilities

* Year Built1955

Year Built Details

Year Built SourcePublic Records

Year Built Effective

Construction MaterialsBlock

Exterior Features

Foundation Area

Foundation MaterialsConcrete Perimeter,Block

Approx. Street Frontage

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)0.58 Sqft

Disclosures for 151 Irving Ave, Barnstable, Massachusetts 02647

Buyer Agent Compensation2.5

Contingency

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ONNet Sale Price

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintUnknown

Living Area Disclosure

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation0

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Association Fee$0

Association Fee Frequency

Associaton Fee IncludesNo

AssociationNo

Assessed Value

Real Estate Tax$0

Tax Year

MLSPIN_SOLD_PRICE_PER_SQFT$0

OriginalListPrice$4,250,000

Lifestyle Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features1/10 To 3/10 To Beach, Association), Beach Front, Beach Ownership(public, Harbor, Sound, Walk To

Location information for 151 Irving Ave, Barnstable, Massachusetts 02647

Elementary School

Middle School

High School

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)

Marketing History for 151 Irving Ave, Barnstable, Massachusetts 02647

MLSPIN_MARKET_TIME_BROKER190

MLSPIN_MARKET_TIME_PROPERTY190

PurchaseContractDate

Agent Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Agent NameDana Delorey

Agent MLS IDCN253207

Agent Phone #617-834-9289

Agent Phone Area

Office NameMildred Linnell Real Estate

Office Phone508-775-0709

Office Phone Area

Office MLS IDAN7941

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 24615.92

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Dana Delorey

Mildred Linnell Real Estate

Agent Phone

(617) 834-9289

Office Phone

(508) 775-0709

Text Agent Call Agent Call Office

Array
(
    [id] => 309261
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73213254
    [mls_id_num] => 73213254
    [parent] => 0
    [pic_numb] => 14
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 9
    [location4_id] => 17
    [location5_id] => 0
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Barnstable
    [location4_name] => Barnstable
    [location5_name] => 
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 3995000
    [price_unit] => 260
    [price_si] => 3995000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 6
    [bedrooms_max] => 0
    [rooms] => 13
    [rooms_max] => 0
    [bathrooms] => 5.5
    [bathrooms_max] => 0
    [living_area] => 3754
    [living_area_unit] => 1
    [living_area_si] => 349.122
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 0
    [lot_area_unit] => 1
    [lot_area_si] => 0
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 41.63043100
    [googlemap_ln] => -70.30149300
    [geopoints] => �������D�K�K�Q�:�����D@
    [finalized] => 1
    [add_date] => 2024-04-27 10:46:05
    [last_finalize_date] => 2024-10-07 20:50:42
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 1955
    [zip_id] => 4223
    [zip_name] => 02647
    [last_modified_time_stamp] => 2024-10-11 19:50:45
    [post_code] => 
    [meta_description] => 6 Bedrooms Bedrooms 13 Rooms Rooms With 5.5 Bathrooms Bathrooms Residential For Sale Irving Ave In 151 Irving Ave, Barnstable, Massachusetts 02647
    [meta_description_manual] => 0
    [meta_keywords] => 151 Irving Ave, Barnstable, Massachusetts 02647, 6 Bedrooms Bedrooms, 13 Rooms Rooms,5.5 BathroomsBathrooms,Residential,For Sale,Irving Ave,73213254
    [meta_keywords_manual] => 0
    [street_no] => 151
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property 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.\n Property Type Residential Listing Type For Sale Ref ID 2912a42310b483e36afbbd30068f710b Full Bathrooms 5 Full Bathrooms five Status Withdrawn Property Category Residential Property Type Single Family C_Style Detached Zipcode 02647 Office Name Mildred Linnell Real Estate Agent MLSID CN253207 Office Phone 508-775-0709 Agent Phone 617-834-9289 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 4 ParkingTotal four UnparsedAddress 151 Irving Ave, Barnstable MA 02647 OpenParkingYN 1 OpenParkingYN one  151 irving ave barnstable massachusetts 02647 
    [location_text] => 151 Irving Ave, Barnstable, Massachusetts 02647
    [field_42] => Irving Ave
    [field_312] => Residential For Sale - 13 Rooms - 6 Bedrooms - 5.5 Bathrooms - Price $
    [field_313] => Residential For Sale
    [field_308] => 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.
    [field_7] => 0
    [n_103] => 
    [n_103_distance] => 
    [n_103_distance_by] => 
    [n_105] => 
    [n_105_distance] => 
    [n_105_distance_by] => 
    [n_107] => 
    [n_107_distance] => 
    [n_107_distance_by] => 
    [n_108] => 
    [n_108_distance] => 
    [n_108_distance_by] => 
    [n_109] => 
    [n_109_distance] => 
    [n_109_distance_by] => 
    [f_130_options] => ,28,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 1
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,16,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,10,
    [f_137] => 1
    [f_138_options] => 
    [f_138] => 
    [f_139_options] => 
    [f_139] => 
    [f_140_options] => ,6,
    [f_140] => 1
    [f_141_options] => 
    [f_141] => 
    [f_144_options] => ,5,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,19,15,25,18,16,
    [f_150] => 1
    [f_151_options] => 
    [f_151] => 
    [f_152_options] => 
    [f_152] => 
    [f_156_options] => 
    [f_156] => 
    [f_157_options] => 
    [f_157] => 
    [f_159_options] => 
    [f_159] => 
    [f_161_options] => 
    [f_161] => 
    [f_163_options] => 
    [f_163] => 
    [f_165_options] => 
    [f_165] => 
    [f_166_options] => 
    [f_166] => 
    [ref_id] => 2912a42310b483e36afbbd30068f710b
    [field_54] => 
    [half_bathrooms] => 1
    [half_bathrooms_max] => 0
    [field_55] => 0
    [rendered] => {"rendered":{"313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 13 Rooms - 6 Bedrooms - 5.5 Bathrooms - Price $"},"3":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"2":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"materials":{"field_313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"field_312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 13 Rooms - 6 Bedrooms - 5.5 Bathrooms - Price $"},"property_type":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"listing":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"field_55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"location_text":"151 Irving Ave, Barnstable, Massachusetts 02647"}
    [alias] => Single-Family-151-Irving-Ave-Barnstable-Massachusetts-02647-73213254-USD3-995-000
    [source] => mls
    [last_sync_date] => 2024-10-07 20:50:22
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 14
    [field_2111] => Mildred Linnell Real Estate
    [field_2112] => Dana Delorey
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => CN253207
    [field_3001] => AN7941
    [listing_status] => 14
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 190
    [field_3072] => 0
    [field_3074] => Hyannisport
    [field_3075] => 2024-09-04 13:14:00
    [f_3102_options] => ,19,11,14,15,20,23,39,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 151 Irving Ave
    [field_3171] => 508-775-0709
    [field_3172] => 617-834-9289
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 5
    [field_3176] => 5
    [field_3177] => 0
    [field_3180] => 
    [field_3181] => 0
    [field_3191] => 0
    [field_3192] => 4
    [field_3212] => 0
    [field_3217] => 0
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 2
    [f_3238_options] => ,2,
    [f_3238] => 1
    [field_3240] => 151 Irving Ave, Barnstable MA 02647
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 2.5
    [field_3186] => 
    [field_3301] => 0
    [field_3306] => 0
    [field_3306_si] => 0
    [field_3306_unit] => 260
    [fly_field] => 
    [fly_value] => 
    [field_3120] => 
    [field_3055] => 
    [field_3056] => 0
    [field_3056_si] => 0
    [field_3056_unit] => 260
    [field_3311] => 
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 59
    [visit_time] => 23
    [visit_date] => 2024-11-23 06:45:50
    [vids_numb] => 0
    [f_3002_options] => ,12,4,
    [f_3002] => 1
    [f_3003_options] => ,40,0,37,2,4,1,7,8,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,4,0,17,
    [f_3006] => 1
    [f_3007_options] => ,29,
    [f_3007] => 1
    [f_3008_options] => ,9,
    [f_3008] => 1
    [f_3009_options] => ,18,4,
    [f_3009] => 1
    [f_3010_options] => ,224,
    [f_3010] => 1
    [field_3011] => 122800
    [field_3011_si] => 122800
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 14
    [field_3019] => 2024-05-31 18:06:34
    [field_3020] => 12
    [field_3021] => Call List Agent,Appointment Required
    [field_3022] => 
    [field_3023] => 84250
    [field_3023_si] => 84250
    [field_3023_unit] => 260
    [field_3024] => 2024
    [f_3025_options] => ,5,
    [f_3025] => 1
    [field_3027] => 34
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => residentia
    [field_3039] => Scudder Ave to left on Irving Ave
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 1
    [field_3060] => 
    [field_3069] => 1064.2
    [field_3069_si] => 1064.2
    [field_3069_unit] => 260
    [field_3079] => 2024-09-04 13:14:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 151
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 0
    [field_3105] => 
    [field_3109] => 1
    [field_3112] => 
    [field_3113] => 
    [field_3114] => 
    [field_3115] => 
    [field_3116] => 
    [field_3118] => 0
    [field_3118_si] => 0
    [field_3118_unit] => 260
    [field_3119] => 
    [field_3121] => 
    [field_3122] => 
    [field_3123] => 
    [f_3125_options] => ,0,
    [f_3125] => 1
    [field_3126] => 
    [field_3131] => 
    [field_3134] => 0
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => 
    [f_3166_options] => ,94,
    [f_3166] => 1
    [field_3168] => 0
    [field_3168_si] => 0
    [field_3168_unit] => 260
    [field_3178] => 0
    [field_3179] => 
    [field_3182] => 7
    [field_3183] => 3754
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,11,5,6,2,3,16,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,4,
    [f_3190] => 1
    [field_3193] => 1
    [field_3194] => 
    [f_3195_options] => ,19,
    [f_3195] => 1
    [f_3196_options] => ,40,
    [f_3196] => 1
    [field_3197] => 
    [f_3198_options] => ,1,
    [f_3198] => 1
    [field_3199] => 
    [field_3200] => 0
    [field_3200_si] => 0
    [field_3200_unit] => 260
    [field_3201] => 
    [field_3202] => 
    [field_3203] => 
    [field_3204] => 
    [field_3205] => 1900-01-01
    [field_3206] => 0
    [f_3207_options] => ,10,
    [f_3207] => 1
    [field_3208] => 0
    [field_3209] => Concrete Perimeter,Block
    [field_3210] => 
    [field_3211] => 1
    [field_3213] => 
    [field_3214] => 
    [field_3215] => 
    [field_3216] => 0
    [field_3216_si] => 0
    [field_3216_unit] => 260
    [field_3218] => 
    [field_3220] => 0
    [field_3220_si] => 0
    [field_3220_unit] => 260
    [field_3221] => 
    [field_3222] => Exclusive Right To Sell
    [field_3223] => 2024-02-27
    [field_3224] => 
    [f_3225_options] => ,27,
    [f_3225] => 1
    [field_3226_si] => 0.05394
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 2024-09-04
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 4250000
    [field_3231_si] => 4250000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => 
    [field_3237] => 
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => Actual
    [field_3244] => 
    [field_3245] => Public Records
    [field_3246] => 
    [field_3248] => 2024-03-18 00:44:00
    [field_3249] => 
    [field_3250] => 
    [field_3251] => 
    [field_3252] => 
    [field_3253] => 
    [field_3254] => 
    [field_3255] => 
    [field_3256] => 
    [field_3257] => 
    [field_3258] => 
    [field_3259] => 
    [field_3260] => N
    [field_3261] => 
    [field_3262] => 
    [field_3263] => 
    [field_3264] => 
    [field_3265] => 0
    [field_3265_si] => 0
    [field_3265_unit] => 260
    [field_3266] => 0
    [field_3266_si] => 0
    [field_3266_unit] => 260
    [field_3267] => 
    [field_3268] => 
    [field_3269] => 
    [field_3270] => 
    [field_3271] => 
    [field_3272] => Unknown
    [field_3273] => 
    [field_3274] => 
    [field_3275] => 
    [field_3276] => 
    [field_3277] => AN7941
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 190
    [field_3281] => 0
    [field_3281_si] => 0
    [field_3281_unit] => 260
    [field_3282] => 0
    [field_3282_si] => 0
    [field_3282_unit] => 260
    [field_3283] => 
    [field_3284] => 
    [field_3285] => 0
    [field_3285_si] => 0
    [field_3285_unit] => 260
    [field_3286] => 
    [field_3287] => 
    [field_3288] => 
    [field_3289] => 
    [field_3290] => 1064.2
    [field_3290_si] => 1064.2
    [field_3290_unit] => 260
    [field_3291] => 
    [field_3292] => 0
    [field_3292_si] => 0
    [field_3292_unit] => 260
    [field_3293] => 0
    [field_3293_si] => 0
    [field_3293_unit] => 260
    [field_3294] => 
    [field_3295] => 1
    [field_3297] => 
    [field_3303] => 
    [f_3304_options] => ,22,
    [f_3304] => 1
    [f_3305_options] => ,12,
    [f_3305] => 1
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 0.58
)

Array
(
    [property_type] => Array
        (
            [field_id] => 3
            [type] => property_types
            [name] => Property Type
            [value] => Residential
        )

[field_3236] => Array
        (
            [field_id] => 3236
            [type] => select
            [name] => PropertySubType
            [value] => Single Family Residence
        )

[listing] => Array
        (
            [field_id] => 2
            [type] => listings
            [name] => Listing Type
            [value] => For Sale
        )

[field_3176] => Array
        (
            [field_id] => 3176
            [type] => number
            [name] => Full Bathrooms
            [value] => 5
        )

[field_3175] => Array
        (
            [field_id] => 3175
            [type] => select
            [name] => Status
            [value] => Withdrawn
        )

[field_3299] => Array
        (
            [field_id] => 3299
            [type] => select
            [name] => Property Category
            [value] => Residential
        )

[field_3298] => Array
        (
            [field_id] => 3298
            [type] => select
            [name] => Property Type
            [value] => Single Family
        )

[field_3300] => Array
        (
            [field_id] => 3300
            [type] => select
            [name] => C_Style
            [value] => Detached
        )

[f_131] => Array
        (
            [field_id] => 131
            [type] => feature
            [name] => Swimming Pool
            [values] => Array
                (
                    [0] => No
                )

)

[f_140] => Array
        (
            [field_id] => 140
            [type] => feature
            [name] => Pet Policy
            [values] => Array
                (
                    [0] => No
                )

)

[field_55] => Array
        (
            [field_id] => 55
            [type] => number
            [name] => Floor Number
            [value] => 0
        )

[googlemap_ln] => Array
        (
            [field_id] => 51
            [type] => text
            [name] => Longitude
            [value] => W71° 41' 54.6'' 
        )

[googlemap_lt] => Array
        (
            [field_id] => 52
            [type] => text
            [name] => Latitude
            [value] => N41° 37' 49.6'' 
        )

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => Mildred Linnell Real Estate
        )

[field_3000] => Array
        (
            [field_id] => 3000
            [type] => text
            [name] => Agent MLSID
            [value] => CN253207
        )

[field_3045] => Array
        (
            [field_id] => 3045
            [type] => price
            [name] => HOA_FEE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3046] => Array
        (
            [field_id] => 3046
            [type] => feature
            [name] => ASSC_FEE_INCLUDES
            [values] => Array
                (
                    [0] => No
                )

)

[field_3056] => Array
        (
            [field_id] => 3056
            [type] => price
            [name] => ClosePrice
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3058] => Array
        (
            [field_id] => 3058
            [type] => select
            [name] => COMP_BASED_ON
            [value] => Net Sale Price
        )

[field_3069] => Array
        (
            [field_id] => 3069
            [type] => price
            [name] => LIST_PRICE_PER_SQFT
            [raw] => 1064.2
            [unit_id] => 260
            [value] => $1,064
            [price_only] => $1,064
        )

[field_3071] => Array
        (
            [field_id] => 3071
            [type] => number
            [name] => MARKET_TIME_BROKER
            [value] => 190
        )

[field_3072] => Array
        (
            [field_id] => 3072
            [type] => number
            [name] => MARKET_TIME_BROKER_PREV
            [value] => 0
        )

[field_3074] => Array
        (
            [field_id] => 3074
            [type] => text
            [name] => AREA
            [value] => Hyannisport
        )

[field_3075] => Array
        (
            [field_id] => 3075
            [type] => datetime
            [name] => ModificationTimestamp
            [value] => 04/09/2024 13:14:00
        )

[field_3094] => Array
        (
            [field_id] => 3094
            [type] => price
            [name] => SOLD_PRICE_PER_SQFT
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3095] => Array
        (
            [field_id] => 3095
            [type] => number
            [name] => STREET_NUM
            [value] => 151
        )

[field_3098] => Array
        (
            [field_id] => 3098
            [type] => text
            [name] => TransactionBrokerCompensation
            [value] => 0
        )

[f_3102] => Array
        (
            [field_id] => 3102
            [type] => feature
            [name] => Waterfront
            [values] => 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)
                )

)

[field_3109] => Array
        (
            [field_id] => 3109
            [type] => number
            [name] => FIRE_PLACES
            [value] => 1
        )

[field_3118] => Array
        (
            [field_id] => 3118
            [type] => price
            [name] => NOI
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3125] => Array
        (
            [field_id] => 3125
            [type] => feature
            [name] => ROAD_TYPE
            [values] => Array
                (
                    [0] => Public
                )

)

[field_3134] => Array
        (
            [field_id] => 3134
            [type] => select
            [name] => SQUARE_FEET_INCL_BASE
            [value] => No
        )

[field_3164] => Array
        (
            [field_id] => 3164
            [type] => boolean
            [name] => AvailableNow
            [value] => No
        )

[f_3166] => Array
        (
            [field_id] => 3166
            [type] => feature
            [name] => RENT_FEE_INCLUDES
            [values] => Array
                (
                    [0] => No
                )

)

[field_3168] => Array
        (
            [field_id] => 3168
            [type] => price
            [name] => SEC_DEPOSIT
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3171] => Array
        (
            [field_id] => 3171
            [type] => text
            [name] => Office Phone
            [value] => 508-775-0709
        )

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 617-834-9289
        )

[field_3177] => Array
        (
            [field_id] => 3177
            [type] => select
            [name] => AccessibilityFeatures
            [value] => No
        )

[field_3178] => Array
        (
            [field_id] => 3178
            [type] => boolean
            [name] => AdditionalParcelsYN
            [value] => No
        )

[field_3181] => Array
        (
            [field_id] => 3181
            [type] => select
            [name] => AttachedGarageYN
            [value] => 1
        )

[field_3182] => Array
        (
            [field_id] => 3182
            [type] => select
            [name] => BuildingAreaSource
            [value] => Appraiser
        )

[field_3183] => Array
        (
            [field_id] => 3183
            [type] => number
            [name] => BuildingAreaTotal
            [value] => 3754
        )

[field_3184] => Array
        (
            [field_id] => 3184
            [type] => select
            [name] => BuildingAreaUnits
            [value] => Square Feet
        )

[field_3185] => Array
        (
            [field_id] => 3185
            [type] => text
            [name] => BuyerAgencyCompensation
            [value] => 2.5
        )

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Highway Access
                    [1] => House Of Worship
                    [2] => Shopping
                    [3] => Golf
                    [4] => Public Transportation
                    [5] => Marina
                )

)

[field_3189] => Array
        (
            [field_id] => 3189
            [type] => price
            [name] => ConcessionsAmount
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3190] => Array
        (
            [field_id] => 3190
            [type] => feature
            [name] => ConstructionMaterials
            [values] => Array
                (
                    [0] => Block
                )

)

[field_3191] => Array
        (
            [field_id] => 3191
            [type] => select
            [name] => CoolingYN
            [value] => 1
        )

[field_3192] => Array
        (
            [field_id] => 3192
            [type] => number
            [name] => ParkingTotal
            [value] => 4
        )

[field_3193] => Array
        (
            [field_id] => 3193
            [type] => number
            [name] => CoveredSpaces
            [value] => 1
        )

[f_3195] => Array
        (
            [field_id] => 3195
            [type] => feature
            [name] => CurrentFinancing
            [values] => Array
                (
                    [0] => No
                )

)

[f_3196] => Array
        (
            [field_id] => 3196
            [type] => feature
            [name] => DocumentsAvailable
            [values] => Array
                (
                    [0] => No
                )

)

[f_3198] => Array
        (
            [field_id] => 3198
            [type] => feature
            [name] => DoorFeatures
            [values] => Array
                (
                    [0] => Storm Door(s)
                )

)

[field_3200] => Array
        (
            [field_id] => 3200
            [type] => price
            [name] => ElectricExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3205] => Array
        (
            [field_id] => 3205
            [type] => date
            [name] => ExpirationDate
            [value] => 01/01/1900
        )

[field_3206] => Array
        (
            [field_id] => 3206
            [type] => select
            [name] => FarmLandAreaUnits
            [value] => Square Feet
        )

[f_3207] => Array
        (
            [field_id] => 3207
            [type] => feature
            [name] => FinancialDataSource
            [values] => Array
                (
                    [0] => No
                )

)

[field_3208] => Array
        (
            [field_id] => 3208
            [type] => select
            [name] => FireplaceYN
            [value] => 1
        )

[field_3209] => Array
        (
            [field_id] => 3209
            [type] => text
            [name] => FoundationDetails
            [value] => Concrete Perimeter,Block
        )

[field_3211] => Array
        (
            [field_id] => 3211
            [type] => number
            [name] => GarageSpaces
            [value] => 1
        )

[field_3212] => Array
        (
            [field_id] => 3212
            [type] => select
            [name] => GarageYN
            [value] => 1
        )

[field_3216] => Array
        (
            [field_id] => 3216
            [type] => price
            [name] => GrossIncome
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3217] => Array
        (
            [field_id] => 3217
            [type] => select
            [name] => HeatingYN
            [value] => 1
        )

[field_3220] => Array
        (
            [field_id] => 3220
            [type] => price
            [name] => InsuranceExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3222] => Array
        (
            [field_id] => 3222
            [type] => text
            [name] => ListingAgreement
            [value] => Exclusive Right To Sell
        )

[field_3223] => Array
        (
            [field_id] => 3223
            [type] => date
            [name] => ListingContractDate
            [value] => 27/02/2024
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => No
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 0.58 Sqft
            [raw] => 0.58
            [unit_id] => 1
        )

[field_3229] => Array
        (
            [field_id] => 3229
            [type] => date
            [name] => OffMarketDate
            [value] => 04/09/2024
        )

[field_3230] => Array
        (
            [field_id] => 3230
            [type] => price
            [name] => OperatingExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3231] => Array
        (
            [field_id] => 3231
            [type] => price
            [name] => OriginalListPrice
            [raw] => 4250000
            [unit_id] => 260
            [value] => $4,250,000
            [price_only] => $4,250,000
        )

[f_3238] => Array
        (
            [field_id] => 3238
            [type] => feature
            [name] => SpecialListingConditions
            [values] => Array
                (
                    [0] => No
                )

)

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 151 Irving Ave, Barnstable MA 02647
        )

[field_3241] => Array
        (
            [field_id] => 3241
            [type] => price
            [name] => WaterSewerExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3243] => Array
        (
            [field_id] => 3243
            [type] => text
            [name] => YearBuiltDetails
            [value] => Actual
        )

[field_3245] => Array
        (
            [field_id] => 3245
            [type] => text
            [name] => YearBuiltSource
            [value] => Public Records
        )

[f_3247] => Array
        (
            [field_id] => 3247
            [type] => feature
            [name] => BusinessType
            [values] => Array
                (
                    [0] => No
                )

)

[field_3248] => Array
        (
            [field_id] => 3248
            [type] => datetime
            [name] => OriginalEntryTimestamp
            [value] => 18/03/2024 00:44:00
        )

[field_3260] => Array
        (
            [field_id] => 3260
            [type] => text
            [name] => MLSPIN_DISCLOSURE
            [value] => N
        )

[field_3265] => Array
        (
            [field_id] => 3265
            [type] => price
            [name] => MLSPIN_GRE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3266] => Array
        (
            [field_id] => 3266
            [type] => price
            [name] => MLSPIN_HTE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3272] => Array
        (
            [field_id] => 3272
            [type] => text
            [name] => MLSPIN_LEAD_PAINT
            [value] => Unknown
        )

[field_3277] => Array
        (
            [field_id] => 3277
            [type] => text
            [name] => MLSPIN_MAIN_LO
            [value] => AN7941
        )

[field_3280] => Array
        (
            [field_id] => 3280
            [type] => number
            [name] => MLSPIN_MARKET_TIME_PROPERTY
            [value] => 190
        )

[field_3281] => Array
        (
            [field_id] => 3281
            [type] => price
            [name] => MLSPIN_MGF
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3282] => Array
        (
            [field_id] => 3282
            [type] => price
            [name] => MLSPIN_MSE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3285] => Array
        (
            [field_id] => 3285
            [type] => price
            [name] => MLSPIN_OPTIONAL_FEE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3290] => Array
        (
            [field_id] => 3290
            [type] => price
            [name] => MLSPIN_PRICE_PER_SQFT
            [raw] => 1064.2
            [unit_id] => 260
            [value] => $1,064
            [price_only] => $1,064
        )

[field_3292] => Array
        (
            [field_id] => 3292
            [type] => price
            [name] => MLSPIN_RFS
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3293] => Array
        (
            [field_id] => 3293
            [type] => price
            [name] => MLSPIN_RME
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3295] => Array
        (
            [field_id] => 3295
            [type] => select
            [name] => MLSPIN_WATERVIEW_FLAG
            [value] => Yes
        )

[field_3296] => Array
        (
            [field_id] => 3296
            [type] => select
            [name] => OpenParkingYN
            [value] => 1
        )

[field_3301] => Array
        (
            [field_id] => 3301
            [type] => select
            [name] => RoomMasterBathroomFeatures
            [value] => Yes
        )

[f_3304] => Array
        (
            [field_id] => 3304
            [type] => feature
            [name] => AssociationAmenities
            [values] => Array
                (
                    [0] => No
                )

)

[f_3305] => Array
        (
            [field_id] => 3305
            [type] => feature
            [name] => TenantPays
            [values] => Array
                (
                    [0] => No
                )

)

[field_3306] => Array
        (
            [field_id] => 3306
            [type] => price
            [name] => GrossScheduledIncome
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

)

EXIT

12 More Photos

Withdrawn

151 Irving Ave Barnstable. MA 02647

$3,995,000

General Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Interior Features for 151 Irving Ave, Barnstable, Massachusetts 02647

Exterior Features for 151 Irving Ave, Barnstable, Massachusetts 02647

Disclosures for 151 Irving Ave, Barnstable, Massachusetts 02647

Financial Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Lifestyle Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Location information for 151 Irving Ave, Barnstable, Massachusetts 02647

Marketing History for 151 Irving Ave, Barnstable, Massachusetts 02647

Agent Information for 151 Irving Ave, Barnstable, Massachusetts 02647

Payment Calculator

Exclusive Listing Agent

Dana Delorey

Mildred Linnell Real Estate