Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

495 Chequessett Neck Rd Wellfleet. MA 02667

$2,950,000

Single Family

6 Bedrooms

1.5 Bathrooms

1,906 sq ft

2 Parking Spots

2.43 Acres

Built in 1770

Exceptional & very rare opportunity to own a direct waterfront property on Wellfleet Harbor! This 2.43-acre bucolic property includes a private 219 feet stretch of sandy beach and home is deeded to the mean low. Dip your toes in the water and breath in the fresh ocean air at this breathtaking property and enjoy everything that Outer Cape has to offer. The home is a quintessential beach cottage with a red cedar shingle roof (2011), wide pine floors, a 2-car garage and plenty of outdoor space for summer fun. This charming home has a passing 6 bedroom design septic. Sit and relax in the great room, added to the original home in 1989, and enjoy the panoramic view of the ocean view. The Chequessett Yacht and Golf Club is around the corner and discover Great Island Nature Preserve just 1.5 from the home. Downtown Wellfleet is just a short drive and offers amazing restaurants, shops & galleries. Come get lost in the romance of this location and make this extraordinary property your own!

This listing has been viewed 30 times in the past 191 days

Last Updated: October 7th, 2024 at 7:26pm

Walk/jog Trails

Golf

General Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Property TypeResidential

Property Sub TypeResidential

Price$2,950,000

Price per sqft$1,547.74

MLS #73185657

Handicap Access / FeaturesYes

List Date2023-12-06

List Price$2,950,000

Special Listing ConditionsNo

Specific Zoning CodeR30

StateMassachusetts

Street NameChequessett Neck Rd

Style

TownWellfleet

CityWellfleet

Zip Code02667

CountyBarnstable

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces2

Energy FeaturesNo

Heating Y/NNo

Heating System

Heat Zones0

Attached/DetachedNo

Sold Date

Green Energy Efficient

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourcePublic Records

Building Area Total1906

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces2

Listing Service

UnparsedAddress495 Chequessett Neck Rd, Wellfleet MA 02667

Zoning

Interior Features for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Master BathNo

* Approx. Living Area Total1,906 sq ft

Living Area Includes BasementNo

* Living Area Source1

Bedrooms6

* # Fireplaces3

Bathrooms (Total)1.5

Full Baths1

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area DisclosureBuyer must verify all measurements, no central hea

Living Area Includes BasementNo

Door FeaturesNo

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate

Well Fleet Harbor

Exterior Features for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

* Approximate Lot Size2.43 acres

Covered Parking Spaces2

Lot FeaturesFlood Plain, Marsh, Sloped

* Parking Spaces2

* Sewer Utilities

* Water Utilities

* Year Built1770

Year Built Details

Year Built SourcePublic Records

Year Built Effective

Construction MaterialsNo

Exterior Features

Foundation Area

Foundation MaterialsConcrete Perimeter,Brick/Mortar

Approx. Street Frontage

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)105,851 Sqft

Disclosures for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Buyer Agent Compensation2

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 DisclosureBuyer must verify all measurements, no central hea

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation1

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

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$3,999,000

Lifestyle Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features0 To 1/10 Mile To Beach, Access, Beach Front, Beach Ownership(private), Direct Access, Frontage, Harbor, Ocean, Private, Waterfront

Location information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Elementary School

Middle School

High School

Neighborhood/Sub-DivisionWell Fleet Harbor

Neighborhood (WPL, not MLS)

Marketing History for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

MLSPIN_MARKET_TIME_BROKER246

MLSPIN_MARKET_TIME_PROPERTY246

PurchaseContractDate

Agent Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Agent NameNicole DeFrancesco

Agent MLS IDA8001196

Agent Phone #774-271-1844

Agent Phone Area

Office NameSilverstone Capeside Realty Group

Office Phone774-271-1844

Office Phone Area

Office MLS IDAN6701

Buyer Agent MLS ID

Buyer Office MLS ID

Team MembersCN254977

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 18176.96

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Nicole DeFrancesco

Silverstone Capeside Realty Group

Agent Phone

(774) 271-1844

Office Phone

(774) 271-1844

Text Agent Call Agent Call Office

Array
(
    [id] => 482635
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73185657
    [mls_id_num] => 73185657
    [parent] => 0
    [pic_numb] => 39
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 9
    [location4_id] => 406
    [location5_id] => 730
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Barnstable
    [location4_name] => Wellfleet
    [location5_name] => Well Fleet Harbor
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 2950000
    [price_unit] => 260
    [price_si] => 2950000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 6
    [bedrooms_max] => 0
    [rooms] => 9
    [rooms_max] => 0
    [bathrooms] => 1.5
    [bathrooms_max] => 0
    [living_area] => 1906
    [living_area_unit] => 1
    [living_area_si] => 177.258
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 2.43
    [lot_area_unit] => 1
    [lot_area_si] => 0.22599
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 41.93128100
    [googlemap_ln] => -70.04666200
    [geopoints] => �������������Q�n1?74�D@
    [finalized] => 1
    [add_date] => 2024-05-17 10:37:58
    [last_finalize_date] => 2024-10-07 19:26:49
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 1770
    [zip_id] => 5575
    [zip_name] => 02667
    [last_modified_time_stamp] => 2024-10-09 12:05:01
    [post_code] => 
    [meta_description] => 6 Bedrooms Bedrooms 9 Rooms Rooms With 1.5 Bathrooms Bathrooms Residential For Sale Chequessett Neck Rd In 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667
    [meta_description_manual] => 0
    [meta_keywords] => 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667, 6 Bedrooms Bedrooms, 9 Rooms Rooms,1.5 BathroomsBathrooms,Residential,For Sale,Chequessett Neck Rd,73185657
    [meta_keywords_manual] => 0
    [street_no] => 495
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Exceptional & very rare opportunity to own a direct waterfront property on Wellfleet Harbor! This 2.43-acre bucolic property includes a private 219 feet stretch of sandy beach and home is deeded to  the  mean low. Dip your toes in the water and breath in the fresh ocean air at this breathtaking property and enjoy everything that Outer Cape has to offer. The home is a quintessential beach cottage with a red cedar shingle roof (2011), wide pine floors, a 2-car garage and plenty of outdoor space for summer fun. This charming home has a passing 6 bedroom design septic. Sit and relax in the great room, added to the original home in 1989, and enjoy the panoramic view of the ocean view. The Chequessett Yacht and Golf Club is around the corner and discover Great Island Nature Preserve just 1.5 from the home. Downtown Wellfleet is just a short drive and offers amazing restaurants, shops & galleries. Come get lost in the romance of this location and make this extraordinary property your own!\n Property Type Residential Listing Type For Sale Ref ID 58aab453b0c7029f1aa10ac0d71e18b7 Full Bathrooms 1 Full Bathrooms one Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 02667 Office Name Silverstone Capeside Realty Group Agent MLSID A8001196 Office Phone 774-271-1844 Agent Phone 774-271-1844 ParkingTotal 2 ParkingTotal two UnparsedAddress 495 Chequessett Neck Rd, Wellfleet MA 02667 OpenParkingYN 1 OpenParkingYN one  495 chequessett neck rd wellfleet massachusetts 02667 
    [location_text] => 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667
    [field_42] => Chequessett Neck Rd
    [field_312] => Residential For Sale - 9 Rooms - 6 Bedrooms - 1.5 Bathrooms - Price $2
    [field_313] => Residential For Sale
    [field_308] => Exceptional & very rare opportunity to own a direct waterfront property on Wellfleet Harbor! This 2.43-acre bucolic property includes a private 219 feet stretch of sandy beach and home is deeded to  the  mean low. Dip your toes in the water and breath in the fresh ocean air at this breathtaking property and enjoy everything that Outer Cape has to offer. The home is a quintessential beach cottage with a red cedar shingle roof (2011), wide pine floors, a 2-car garage and plenty of outdoor space for summer fun. This charming home has a passing 6 bedroom design septic. Sit and relax in the great room, added to the original home in 1989, and enjoy the panoramic view of the ocean view. The Chequessett Yacht and Golf Club is around the corner and discover Great Island Nature Preserve just 1.5 from the home. Downtown Wellfleet is just a short drive and offers amazing restaurants, shops & galleries. Come get lost in the romance of this location and make this extraordinary property your own!
    [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] => ,99,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 1
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,47,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,0,4,17,
    [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] => ,20,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,11,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,34,33,15,18,35,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] => 58aab453b0c7029f1aa10ac0d71e18b7
    [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 - 9 Rooms - 6 Bedrooms - 1.5 Bathrooms - Price $2"},"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 - 9 Rooms - 6 Bedrooms - 1.5 Bathrooms - Price $2"},"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":"495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667"}
    [alias] => Single-Family-495-Chequessett-Neck-Rd-Wellfleet-Massachusetts-02667-73185657-USD2-950-000
    [source] => mls
    [last_sync_date] => 2024-10-07 19:26:15
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => Silverstone Capeside Realty Group
    [field_2112] => Nicole DeFrancesco
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => A8001196
    [field_3001] => AN6701
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 246
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-08-10 07:05:00
    [f_3102_options] => ,29,19,13,11,16,3,17,13,3,6,22,31,
    [f_3102] => 1
    [field_3103] => 2
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 495 Chequessett Neck Rd
    [field_3171] => 774-271-1844
    [field_3172] => 774-271-1844
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 1
    [field_3177] => 0
    [field_3180] => 
    [field_3181] => 
    [field_3191] => 
    [field_3192] => 2
    [field_3212] => 0
    [field_3217] => 
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 2
    [f_3238_options] => ,2,
    [f_3238] => 1
    [field_3240] => 495 Chequessett Neck Rd, Wellfleet MA 02667
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 2
    [field_3186] => 
    [field_3301] => 1
    [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] => 53
    [visit_time] => 29
    [visit_date] => 2024-11-22 04:48:14
    [vids_numb] => 0
    [f_3002_options] => ,12,3,5,6,
    [f_3002] => 1
    [f_3003_options] => ,40,74,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,1,3,11,
    [f_3006] => 1
    [f_3007_options] => ,1,2,
    [f_3007] => 1
    [f_3008_options] => ,9,
    [f_3008] => 1
    [f_3009_options] => ,0,2,
    [f_3009] => 1
    [f_3010_options] => ,224,
    [f_3010] => 1
    [field_3011] => 2652400
    [field_3011_si] => 2652400
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 39
    [field_3019] => 2023-12-06 23:14:38
    [field_3020] => 12
    [field_3021] => Accompanied Showings,Appointment Required,Sign,Acc
    [field_3022] => 
    [field_3023] => 18461
    [field_3023_si] => 18461
    [field_3023_unit] => 260
    [field_3024] => 2023
    [f_3025_options] => ,5,6,
    [f_3025] => 1
    [field_3027] => 11
    [field_3028] => 8
    [field_3029] => 0
    [field_3032] => R30
    [field_3039] => Use GPS.
    [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] => 1547.74
    [field_3069_si] => 1547.74
    [field_3069_unit] => 260
    [field_3079] => 2024-08-06 15:07:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 495
    [field_3096] => 
    [field_3097] => CN254977
    [field_3098] => 1
    [field_3105] => 
    [field_3109] => 3
    [field_3112] => 0
    [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] => Buyer must verify all measurements, no central hea
    [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] => 1
    [field_3183] => 1906
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,0,6,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,24,
    [f_3190] => 1
    [field_3193] => 2
    [field_3194] => 
    [f_3195_options] => ,19,
    [f_3195] => 1
    [f_3196_options] => ,40,
    [f_3196] => 1
    [field_3197] => 
    [f_3198_options] => ,5,
    [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,Brick/Mortar
    [field_3210] => 
    [field_3211] => 2
    [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] => 2023-12-06
    [field_3224] => 
    [f_3225_options] => ,18,22,3,
    [f_3225] => 1
    [field_3226_si] => 9844.143
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 3999000
    [field_3231_si] => 3999000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Showing by appointment only.
    [field_3237] => 
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => Approximate,Unknown/Mixed
    [field_3244] => 
    [field_3245] => Public Records
    [field_3246] => 
    [field_3248] => 2023-12-06 23:10: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] => AN6701
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 246
    [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] => 1
    [field_3285] => 0
    [field_3285_si] => 0
    [field_3285_unit] => 260
    [field_3286] => 
    [field_3287] => 
    [field_3288] => 
    [field_3289] => 
    [field_3290] => 1547.74
    [field_3290_si] => 1547.74
    [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] => [{"id":"CN254977","name":"John Tamoosh","phone":"5
    [f_3304_options] => ,22,
    [f_3304] => 1
    [f_3305_options] => ,12,
    [f_3305] => 1
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 105851
)

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] => 1
        )

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

[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° 57' 12'' 
        )

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => Silverstone Capeside Realty Group
        )

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

[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] => 1547.74
            [unit_id] => 260
            [value] => $1,548
            [price_only] => $1,548
        )

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

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

[field_3075] => Array
        (
            [field_id] => 3075
            [type] => datetime
            [name] => ModificationTimestamp
            [value] => 10/08/2024 07:05: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] => 495
        )

[field_3097] => Array
        (
            [field_id] => 3097
            [type] => text
            [name] => TEAM_MEMBER
            [value] => CN254977
        )

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

[f_3102] => Array
        (
            [field_id] => 3102
            [type] => feature
            [name] => Waterfront
            [values] => Array
                (
                    [0] => Direct Access
                    [1] => Frontage
                    [2] => Harbor
                    [3] => Ocean
                    [4] => Access
                    [5] => Private
                    [6] => Beach Front
                    [7] => 0 To 1/10 Mile To Beach
                    [8] => Waterfront
                    [9] => Beach Ownership(private)
                )

)

[field_3103] => Array
        (
            [field_id] => 3103
            [type] => select
            [name] => WATERFRONT_FLAG
            [value] => 1
        )

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

[field_3112] => Array
        (
            [field_id] => 3112
            [type] => number
            [name] => HEAT_ZONES
            [value] => 0
        )

[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_3156] => Array
        (
            [field_id] => 3156
            [type] => text
            [name] => SQUARE_FEET_DISCLOSURES
            [value] => Buyer must verify all measurements, no central hea
        )

[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] => 774-271-1844
        )

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 774-271-1844
        )

[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_3182] => Array
        (
            [field_id] => 3182
            [type] => select
            [name] => BuildingAreaSource
            [value] => Public Records
        )

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

[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
        )

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Walk/jog Trails
                    [1] => Golf
                )

)

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

)

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

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

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

)

[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,Brick/Mortar
        )

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

[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_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] => 06/12/2023
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => Sloped
                    [1] => Flood Plain
                    [2] => Marsh
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 105,851 Sqft
            [raw] => 105851
            [unit_id] => 1
        )

[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] => 3999000
            [unit_id] => 260
            [value] => $3,999,000
            [price_only] => $3,999,000
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Showing by appointment only.
        )

[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] => 495 Chequessett Neck Rd, Wellfleet MA 02667
        )

[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] => Approximate,Unknown/Mixed
        )

[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] => 06/12/2023 23:10: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] => AN6701
        )

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

[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_3284] => Array
        (
            [field_id] => 3284
            [type] => number
            [name] => MLSPIN_OH_FLAG
            [value] => 1
        )

[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] => 1547.74
            [unit_id] => 260
            [value] => $1,548
            [price_only] => $1,548
        )

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

[field_3303] => Array
        (
            [field_id] => 3303
            [type] => text
            [name] => Co Agent Info
            [value] => [{"id":"CN254977","name":"John Tamoosh","phone":"5
        )

[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

37 More Photos

Active

495 Chequessett Neck Rd Wellfleet. MA 02667

$2,950,000

General Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Interior Features for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Exterior Features for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Disclosures for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Financial Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Lifestyle Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Location information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Marketing History for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Agent Information for 495 Chequessett Neck Rd, Wellfleet, Massachusetts 02667

Payment Calculator

Exclusive Listing Agent

Nicole DeFrancesco

Silverstone Capeside Realty Group