749 S Main Street, Centerville, MA 02632
OFF MARKET

749 S Main Street
Centerville, MA 02632

Centerville
  • 10 Beds
  • 7 Baths
  • 8,834 sqft (on 1.79 acres)

$7,452,700

Trulia Estimate
as of Jun 4, 2026
Est. Refi. Payment $41,352/mo*
Refinance Your Home

$7,452,700

Trulia Estimate
as of Jun 4, 2026
Est. Refi. Payment $41,352/mo*
Refinance Your Home
10 Beds
7 Baths
8,834 sqft
(on 1.79 acres)

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

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. This property was Mrs. Quinn's personal estate, 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 8 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. A brand new sea wall and elevated back yard were installed summer 2024.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from June 13, 2025

Home Highlights

Parking
Garage
Outdoor
Patio, Pool
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 749 S Main Street

Interior Features

Interior Details
Basement: Interior EntryNumber of Rooms: 16Types of Rooms: Master Bedroom
Beds & Baths
Number of Bedrooms: 10Number of Bathrooms: 8Number of Bathrooms (full): 6Number of Bathrooms (half): 2
Dimensions and Layout
Living Area: 8834 Square Feet
Appliances & Utilities
Appliances: Gas Water Heater
Heating & Cooling
Heating: Hot WaterHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Hot Water
Fireplace & Spa
Number of Fireplaces: 8Spa: HeatedHas a Fireplace
Windows, Doors, Floors & Walls
Flooring: Hardwood, Tile
Levels, Entrance, & Accessibility
Stories: 2Floors: Hardwood, Tile
View
Has a View

Exterior Features

Exterior Home Features
Roof: Asphalt ShinglePatio / Porch: PatioOther Structures: Pool House, OutbuildingExterior: Outdoor Shower, GardenFoundation: Concrete PerimeterGardenHas a Private Pool
Parking & Garage
Number of Garage Spaces: 4Number of Covered Spaces: 4No CarportHas a GarageNo Attached GarageHas Open ParkingParking Spaces: 6Parking: Garage, Open
Pool
Pool: Gunite, In Ground, HeatedPool
Frontage
WaterfrontWaterfront: Deep Water Access, Salt, River FrontRoad Frontage: PublicOn Waterfront
Water & Sewer
Sewer: Private SewerWater Body: Centerville River

Days on Market

Cumulative Days on Market: 583

Property Information

Year Built
Year Built: 1924Year Renovated: 2021
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Tudor
Building
Construction Materials: StuccoNot a New ConstructionNot Attached PropertyDoes Not Include Home Warranty
Property Information
Condition: Updated/Remodeled, ActualParcel Number: 185012001

Price & Status

Price
List Price: $7,250,000

Active Status

MLS Status: Closed

Location

Direction & Address
City: Centerville
School Information
Elementary School District: BarnstableJr High / Middle School District: BarnstableHigh School District: Barnstable

Building

Building Area
Building Area: 8834 Square Feet

HOA

No HOA

Lot Information

Lot Area: 1.79 Acres

Listing Info

Special Conditions: None

Offer

Listing Terms: Conventional

Miscellaneous

BasementMls Number: 22303969Water ViewWater View: RiversShowing Requirements: Appointment Required, Call Listing Agent
Last check for updates: about 1 hour ago
Listed by The Cape House Team, (508) 737-1248
William Raveis Real Estate & Home Services
Bought with: John J Hopkins, (508) 320-9461, Frank A Sullivan Real Estate
Source: CCIMLS, MLS#22303969

Price History for 749 S Main Street

DatePriceEventSource
06/12/2025$6,500,000Sold
CCIMLS #22303969
04/22/2025$7,250,000PendingCCIMLS #22303969
02/17/2025$7,250,000PriceChange
CCIMLS #22303969
09/09/2024$8,500,000PriceChange
CCIMLS #22303969
12/14/2023$9,900,000PriceChange
CCIMLS #22303969
09/15/2023$11,000,000Listed For SaleCCIMLS #22303969

Market trends in Barnstable

Last updated April 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$680K
$5.83KMoM
Sale-to-List Price
98.3%
0.6%MoM
Price per sq ft
$418
$3MoM
Available listings
322
87MoM
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax$54,720
Assessment$6,763,900
Home facts updated by county records

Comparable Sales for 749 S Main Street

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
749 S Main St, Barnstable, MA
0.00
Single-Family Home
$6,500,000
06/12/25
10
7
8,834
162 Starboard Lane, Osterville, MA
0.46
Single-Family Home
$2,210,000
10/08/25
4
3.5
3,510
162 Starboard Ln, Barnstable, MA
0.47
Single-Family Home
$2,210,000
10/08/25
4
3.5
2,710
12 S Cedar Rd, Barnstable, MA
0.25
Single-Family Home
$1,700,000
03/18/26
3
2.5
2,168
12 S Cedar Road, Centerville, MA
0.25
Single-Family Home
$1,700,000
03/18/26
3
2.5
2,168
436 S Main St, Barnstable, MA
0.59
Single-Family Home
$1,525,000
12/05/25
7
8
3,072
436 S Main Street, Centerville, MA
0.59
Single-Family Home
$1,525,000
12/05/25
7
8
3,072
818 South Main Street, Centerville, MA
0.17
Single-Family Home
$1,925,000
06/01/26
3
2.5
2,338

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 749 S Main Street.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

Neighborhood Overview

Centerville
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about Centerville

At least 56 Trulia users voted on each feature.

  • 97 % Say car is needed

  • 91 % Say yards are well-kept

  • 87 % Say it's dog friendly

  • 80 % Say there's holiday spirit

  • 79 % Say parking is easy

  • 75 % Say there's wildlife

  • 69 % Say people would walk alone at night

  • 68 % Say they plan to stay for at least 5 years

  • 66 % Say kids play outside

  • 59 % Say neighbors are friendly

  • 58 % Say it's quiet

  • 37 % Say it's walkable to grocery stores

  • 36 % Say there are community events

  • 35 % Say there are sidewalks

  • 29 % Say it's walkable to restaurants

  • 28 % Say streets are well-lit

Sourced by Trulia users. Learn more about our methodology.
  • Josi.usa
    "Great , everyone is very welcome here and we are all very grateful for all the work everybody does to keep the community safe "
    0
    Flag
  • Trulia User
    "Neighbor get togethers over the summer. Everyone walks through the neighborhood every evening. There are many events in nearby downtown Hyannis. "
    0
    Flag
  • Trulia User
    "Amazing community that is close to plenty of restaurants and shopping centers. Very safe and friendly neighbors"
    0
    Flag
  • Trulia User
    "There really isn't any community events in the neighborhood that I have ever heard of... People in the neighborhood seem nice, but not very sociable..."
    0
    Flag
  • Trulia User
    "In Centerville we are far away from everything, Not too much public transportation in this area... We need more public transportation in this area of Cape Cod...."
    0
    Flag
  • Trulia User
    "Great kid and dog friendly neighborhood. Best for Trick or treating. Friendly neighbors. Nice area for walking dogs."
    0
    Flag
  • Trulia User
    "I am not down town - quiet safe neighborhood near police station. Very quiet and neighbors very friendly."
    0
    Flag
  • Trulia User
    "West Barnstable is a beautiful area with lots of trees and wooden homes. There is a Main Street with a cute market, coffee store, pottery shop and other art galleries that’s very enjoyable for an afternoon walk."
    0
    Flag
  • Sophia S.
    "New England suburban type of houses, friendly neighbors, beautiful scenery and plants, near Major areas on the cape"
    2
    Flag
  • Barnstable
    "It’s mostly an older neighborhood but as the elderly are passing on it’s become filled with younger families. We love it here. "
    0
    Flag
  • Boardleyamanda
    "In Centerville, I appreciate the Slow traffic, sidewalks along the busier roads, many others walking and clean/safe area. "
    0
    Flag
  • Boardleyamanda
    "Quiet streets with sidewalks for busier sections. Friendly people with dogs on leash. Many of the same people walk every day making it feel like a community."
    0
    Flag
  • Carol A.
    "We are close to everything but not so close that you can't relax and have privacy. You can get to what you need of you have a car. "
    0
    Flag
  • Kfpiculell
    "Great sense of community. Lots of families, young and old. Tennis club, beach club. Playground. Walking distance to beaches, no car needed. "
    1
    Flag
  • Nfegela234
    "Long commute, but only because of school choice and because we work in different towns. Other wise the traffic is moderate but nothing too bad. "
    1
    Flag
  • Nfegela234
    "There are many summer people in our neighborhood so it gets pretty quiet in the winter, but In the summer there are neighborhood kids who play outside together and everyone is really friendly"
    0
    Flag
  • Abur8704
    "Halloween, Christmas events, main street open streets, the schools also have great events like family movie nights, Christmas parties, ice cream socials "
    2
    Flag
  • Dmsocea
    "Jusr visiting relatives, very nice area, homes and yards are well kept, traffic is not too bad, I’d move here if circumstances were in line for that."
    0
    Flag
  • David
    "Craigville Beach and Centerville are quaint Cape Cod towns."
    0
    Flag
  • Chathambeachlover
    "Used to live in the area! Convenient to all! Cannot beat this location or new construction at this price! Our dream home!!!!"
    0
    Flag
  • ccbednark
    "I live and work here and have my whole life. I know all my neighbors, shopping is only 2 miles away for groceries. The mall is 2.5 miles from here. Beaches are within 2-3 miles away. We have a fresh water pond across the street. The public beach is 1.5 miles away and there is boat access there. It is a very desirable neighborhood."
    0
    Flag
  • Donna S.
    "Fantastic area for visitors and residents alike. Gorgeous beaches, restaurants, shops and golf. Endless fun."
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature

Homes for sale near 749 S Main Street

Skip to last item
Skip to first item

Off Market Homes Near 749 S Main Street

Skip to last item
Skip to first item
All data relating to real estate for sale on this page comes from the Broker Reciprocity (BR) of the Cape Cod & Islands Multiple Listing Service, Inc. Detailed information about real estate listings held by brokerage firms other than CC&I Assoc. of REALTORS®, Inc. includes the name of the listing company. Neither the listing company nor CC&I Assoc. of REALTORS®, Inc. shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. The Broker providing this data believes it to be correct, but advises interested parties to confirm any item before relying on it in a purchase decision. This site was last updated 2022-04-05 08:58:10 PDT. All properties are subject to prior sale, changes, or withdrawal. Copyright 2022© Cape Cod & Islands Multiple Listing Service, Inc. All rights reserved.

Homes for rent near 749 S Main Street

Skip to last item
  • Results are loading
Skip to first item
749 S Main Street, Centerville, MA 02632 is a 10 bedroom, 8 bathroom, 8,834 sqft single-family home built in 1924. 749 S Main Street is located in Centerville, Centerville. This property is not currently available for sale. 749 S Main Street was last sold on Jun 12, 2025 for $6,500,000 (10% lower than the asking price of $7,250,000). The current Trulia Estimate for 749 S Main Street is $7,452,700.