Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

749 S Main St Barnstable. MA 02632

$8,500,000

Single Family

10 Bedrooms

7 Bathrooms

8,834 sq ft

6 Parking Spots

1.79 Acres

Built in 1924

Before Cape Cod was a popular vacation destination, Helen J. Quinn, heiress to the Grand Union grocery chain, purchased almost 20 acres of land by the Centerville River. Several homes for her family and even a huge kennel for her dogs were built, but the most magnificent of all was Mrs. Quinn's personal estate, at 749 S Main St., later dubbed 'Sandcastle' for its sandy English stucco exterior. Brilliantly designed for hosting family or guests, the layout is timeless, with formal spaces on the entry side of the property and sunny, glassed-in rooms the length of the water side, offering 180 degree views of Craigville River and Nantucket Sound. With 9 bedrooms in the main house and a full, 1400-sq ft apartment above the separate 4 bay carriage house, there's space for everyone. A deep water dock connected to ''the best boathouse on the river,'' makes day trips to Nantucket possible, or store a launch to zip across the river for sunbathing on the white sands of Long Beach.

This listing has been viewed 4 times in the past 23 days

Last Updated: October 8th, 2024 at 6:28am

General Information for 749 S Main St, Barnstable, Massachusetts 02632

Property TypeResidential

Property Sub TypeResidential

Price$8,500,000

Price per sqft$962.19

MLS #73163694

Handicap Access / FeaturesNo

List Date2023-09-26

List Price$8,500,000

Special Listing ConditionsNo

Specific Zoning CodeRD

StateMassachusetts

Street NameS Main St

Style

TownBarnstable

CityBarnstable

Zip Code02632

CountyBarnstable

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces4

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones

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 SourceOther

Building Area Total8834

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces4

Listing Service

UnparsedAddress749 S Main St, Barnstable MA 02632

Zoning

Interior Features for 749 S Main St, Barnstable, Massachusetts 02632

Master BathYes

* Approx. Living Area Total8,834 sq ft

Living Area Includes BasementNo

* Living Area Source0

Bedrooms10

* # Fireplaces8

Bathrooms (Total)7

Full Baths6

* # Half Baths2

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area Disclosure

Living Area Includes BasementNo

Door FeaturesNo

ElectricYes

Electric$0

MLS Area (Major)Centerville

OffMarketDate

Exterior Features for 749 S Main St, Barnstable, Massachusetts 02632

* Approximate Lot Size1.79 acres

Covered Parking Spaces4

Lot FeaturesNo

* Parking Spaces6

* Sewer Utilities

* Water Utilities

* Year Built1924

Year Built Details

Year Built SourcePublic Records

Year Built Effective

Construction MaterialsNo

Exterior Features

Foundation Area

Foundation MaterialsConcrete Perimeter

Approx. Street Frontage

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)77,972 Sqft

Disclosures for 749 S Main St, Barnstable, Massachusetts 02632

Buyer Agent Compensation

Contingency

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ON

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintUnknown

Living Area Disclosure

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation

TransactionBrokerCompensationType

BuyerAgencyCompensationType

Financial Information for 749 S Main St, Barnstable, Massachusetts 02632

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$11,000,000

Lifestyle Information for 749 S Main St, Barnstable, Massachusetts 02632

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesPool - Inground Heated

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features1/10 To 3/10 To Beach, Beach Front, Beach Ownership(public), River, Sound, Waterfront

Location information for 749 S Main St, Barnstable, Massachusetts 02632

Elementary School

Middle School

High School

Neighborhood/Sub-Division

Neighborhood (WPL, not MLS)

Marketing History for 749 S Main St, Barnstable, Massachusetts 02632

MLSPIN_MARKET_TIME_BROKER353

MLSPIN_MARKET_TIME_PROPERTY353

PurchaseContractDate

Agent Information for 749 S Main St, Barnstable, Massachusetts 02632

Agent NameKatie Clancy

Agent MLS IDA9503244

Agent Phone #508-737-1248

Agent Phone Area

Office NameWilliam Raveis Real Estate & Homes Services

Office Phone774-994-8082

Office Phone Area

Office MLS IDAN0910

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 52374.3

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Katie Clancy

William Raveis Real Estate & Homes Services

Agent Phone

(508) 737-1248

Office Phone

(774) 994-8082

Text Agent Call Agent Call Office

Array
(
    [id] => 533260
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73163694
    [mls_id_num] => 73163694
    [parent] => 0
    [pic_numb] => 42
    [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] => 8500000
    [price_unit] => 260
    [price_si] => 8500000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 10
    [bedrooms_max] => 0
    [rooms] => 16
    [rooms_max] => 0
    [bathrooms] => 7
    [bathrooms_max] => 0
    [living_area] => 8834
    [living_area_unit] => 1
    [living_area_si] => 821.562
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 1.79
    [lot_area_unit] => 1
    [lot_area_si] => 0.16647
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 41.63593900
    [googlemap_ln] => -70.35450500
    [geopoints] => �������/Q�5��Q���rf�D@
    [finalized] => 1
    [add_date] => 2024-10-08 06:28:17
    [last_finalize_date] => 2024-10-08 06:28:45
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 1924
    [zip_id] => 798
    [zip_name] => 02632
    [last_modified_time_stamp] => 2024-10-09 16:34:04
    [post_code] => 
    [meta_description] => 10 Bedrooms Bedrooms 16 Rooms Rooms With 7 Bathrooms Bathrooms Residential For Sale S Main St In 749 S Main St, Barnstable, Massachusetts 02632
    [meta_description_manual] => 0
    [meta_keywords] => 749 S Main St, Barnstable, Massachusetts 02632, 10 Bedrooms Bedrooms, 16 Rooms Rooms,7 BathroomsBathrooms,Residential,For Sale,S Main St,73163694
    [meta_keywords_manual] => 0
    [street_no] => 749
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Before Cape Cod was a popular vacation destination, Helen J. Quinn, heiress to the Grand Union grocery chain, purchased almost 20 acres of land by the Centerville River. Several homes for her family and even a huge kennel for her dogs were built, but the most magnificent of all was Mrs. Quinn’s personal estate, at 749 S Main St., later dubbed ‘Sandcastle’ for its sandy English stucco exterior. Brilliantly designed for hosting family or guests, the layout is timeless, with formal spaces on the entry side of the property and sunny, glassed-in rooms the length of the water side, offering 180 degree views of Craigville River and Nantucket Sound. With 9 bedrooms in the main house and a full, 1400-sq ft apartment above the separate 4 bay carriage house, there’s space for everyone. A deep water dock connected to ”the best boathouse on the river,” makes day trips to Nantucket possible, or store a launch to zip across the river for sunbathing on the white sands of Long Beach.\n Property Type Residential Listing Type For Sale Ref ID cd646d69351b5011a727a2893a6e88de Full Bathrooms 6 Full Bathrooms six Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 02632 Office Name William Raveis Real Estate & Homes Services Agent MLSID A9503244 Office Phone 774-994-8082 Agent Phone 508-737-1248 CoolingYN 1 CoolingYN one ParkingTotal 6 ParkingTotal six UnparsedAddress 749 S Main St, Barnstable MA 02632  749 main st barnstable massachusetts 02632 
    [location_text] => 749 S Main St, Barnstable, Massachusetts 02632
    [field_42] => S Main St
    [field_312] => Residential For Sale - 16 Rooms - 10 Bedrooms - 7 Bathrooms - Price $8
    [field_313] => Residential For Sale
    [field_308] => Before Cape Cod was a popular vacation destination, Helen J. Quinn, heiress to the Grand Union grocery chain, purchased almost 20 acres of land by the Centerville River. Several homes for her family and even a huge kennel for her dogs were built, but the most magnificent of all was Mrs. Quinn's personal estate, at 749 S Main St., later dubbed 'Sandcastle' for its sandy English stucco exterior. Brilliantly designed for hosting family or guests, the layout is timeless, with formal spaces on the entry side of the property and sunny, glassed-in rooms the length of the water side, offering 180 degree views of Craigville River and Nantucket Sound. With 9 bedrooms in the main house and a full, 1400-sq ft apartment above the separate 4 bay carriage house, there's space for everyone. A deep water dock connected to ''the best boathouse on the river,'' makes day trips to Nantucket possible, or store a launch to zip across the river for sunbathing on the white sands of Long Beach.
    [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] => ,17,29,
    [f_130] => 1
    [f_131_options] => ,5,
    [f_131] => 1
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,11,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,11,18,15,
    [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] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,34,
    [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] => cd646d69351b5011a727a2893a6e88de
    [field_54] => 
    [half_bathrooms] => 2
    [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 - 16 Rooms - 10 Bedrooms - 7 Bathrooms - Price $8"},"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 - 16 Rooms - 10 Bedrooms - 7 Bathrooms - Price $8"},"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":"749 S Main St, Barnstable, Massachusetts 02632"}
    [alias] => Single-Family-749-S-Main-St-Barnstable-Massachusetts-02632-73163694-USD8-500-000
    [source] => mls
    [last_sync_date] => 2024-10-08 06:28:17
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => William Raveis Real Estate & Homes Services
    [field_2112] => Katie Clancy
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => A9503244
    [field_3001] => AN0910
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 353
    [field_3072] => 0
    [field_3074] => Centerville
    [field_3075] => 2024-09-14 07:05:00
    [f_3102_options] => ,29,19,0,14,20,21,
    [f_3102] => 1
    [field_3103] => 2
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 749 S Main St
    [field_3171] => 774-994-8082
    [field_3172] => 508-737-1248
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 6
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 
    [field_3191] => 0
    [field_3192] => 6
    [field_3212] => 0
    [field_3217] => 0
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 0
    [field_3235] => 
    [field_3236] => 2
    [f_3238_options] => ,2,
    [f_3238] => 1
    [field_3240] => 749 S Main St, Barnstable MA 02632
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 
    [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] => 9
    [visit_time] => 3
    [visit_date] => 2024-10-23 17:25:48
    [vids_numb] => 0
    [f_3002_options] => ,1,4,
    [f_3002] => 1
    [f_3003_options] => ,30,74,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,4,0,
    [f_3006] => 1
    [f_3007_options] => ,29,
    [f_3007] => 1
    [f_3008_options] => ,0,
    [f_3008] => 1
    [f_3009_options] => ,18,26,31,32,
    [f_3009] => 1
    [f_3010_options] => ,224,
    [f_3010] => 1
    [field_3011] => 6049900
    [field_3011_si] => 6049900
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 42
    [field_3019] => 2023-09-26 20:50:50
    [field_3020] => 12
    [field_3021] => Accompanied Showings,Appointment Required,Call Or 
    [field_3022] => 
    [field_3023] => 50456
    [field_3023_si] => 50456
    [field_3023_unit] => 260
    [field_3024] => 2023
    [f_3025_options] => ,31,
    [f_3025] => 1
    [field_3027] => 
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => RD
    [field_3039] => GPS directions are reliable.
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 
    [field_3060] => 
    [field_3069] => 962.19
    [field_3069_si] => 962.19
    [field_3069_unit] => 260
    [field_3079] => 2024-09-10 13:00:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 749
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 
    [field_3105] => 
    [field_3109] => 8
    [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] => 0
    [field_3183] => 8834
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,22,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,24,
    [f_3190] => 1
    [field_3193] => 4
    [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
    [field_3210] => 
    [field_3211] => 4
    [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-09-26
    [field_3224] => 
    [f_3225_options] => ,27,
    [f_3225] => 1
    [field_3226_si] => 7251.396
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 11000000
    [field_3231_si] => 11000000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => Brand new sea wall by Beacon Marine construction c
    [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] => 2023-09-26 20:51: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] => M59500
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 353
    [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] => 962.19
    [field_3290_si] => 962.19
    [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] => 77972
)

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

[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] => Pool - Inground Heated
                )

)

[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° 38' 43.8'' 
        )

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

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => William Raveis Real Estate & Homes Services
        )

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

[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_3069] => Array
        (
            [field_id] => 3069
            [type] => price
            [name] => LIST_PRICE_PER_SQFT
            [raw] => 962.19
            [unit_id] => 260
            [value] => $962
            [price_only] => $962
        )

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

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

[field_3075] => Array
        (
            [field_id] => 3075
            [type] => datetime
            [name] => ModificationTimestamp
            [value] => 14/09/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] => 749
        )

[f_3102] => Array
        (
            [field_id] => 3102
            [type] => feature
            [name] => Waterfront
            [values] => Array
                (
                    [0] => River
                    [1] => Sound
                    [2] => Beach Front
                    [3] => 1/10 To 3/10 To Beach
                    [4] => Beach Ownership(public)
                    [5] => Waterfront
                )

)

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

[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] => 774-994-8082
        )

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 508-737-1248
        )

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

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

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

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

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => No
                )

)

[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_3191] => Array
        (
            [field_id] => 3191
            [type] => select
            [name] => CoolingYN
            [value] => 1
        )

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

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

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

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

[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] => 26/09/2023
        )

[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] => 77,972 Sqft
            [raw] => 77972
            [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] => 11000000
            [unit_id] => 260
            [value] => $11,000,000
            [price_only] => $11,000,000
        )

[field_3233] => Array
        (
            [field_id] => 3233
            [type] => select
            [name] => PoolPrivateYN
            [value] => 1
        )

[field_3234] => Array
        (
            [field_id] => 3234
            [type] => textarea
            [name] => PrivateOfficeRemarks
            [value] => Brand new sea wall by Beacon Marine construction c
        )

[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] => 749 S Main St, Barnstable MA 02632
        )

[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] => 26/09/2023 20:51: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] => M59500
        )

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

[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] => 962.19
            [unit_id] => 260
            [value] => $962
            [price_only] => $962
        )

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

40 More Photos

Active

749 S Main St Barnstable. MA 02632

$8,500,000

General Information for 749 S Main St, Barnstable, Massachusetts 02632

Interior Features for 749 S Main St, Barnstable, Massachusetts 02632

Exterior Features for 749 S Main St, Barnstable, Massachusetts 02632

Disclosures for 749 S Main St, Barnstable, Massachusetts 02632

Financial Information for 749 S Main St, Barnstable, Massachusetts 02632

Lifestyle Information for 749 S Main St, Barnstable, Massachusetts 02632

Location information for 749 S Main St, Barnstable, Massachusetts 02632

Marketing History for 749 S Main St, Barnstable, Massachusetts 02632

Agent Information for 749 S Main St, Barnstable, Massachusetts 02632

Payment Calculator

Exclusive Listing Agent

Katie Clancy

William Raveis Real Estate & Homes Services