Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1221 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1221 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1221 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

789 Main Street
Centerville, MA 02632
Robert Kinlin with Berkshire Hathaway HomeServices Robert Paul Properties, original listing - (508) 420-1414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,200,000
Beds: 7
Baths: Full: 6, ½: 1
Status: Active
SqFt: 7413 Square Feet
Agency: Berkshire Hathaway HomeServices Robert Paul Properties
Agency Phone: (508) 420-1414

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1870
Notes: Experience unparalleled coastal living at this extraordinary waterfront estate, where breathtaking views of the Centerville River and Nantucket Sound meet timeless luxury. Boasting 200 feet of pristine waterfrontage, this remarkable property includes a private deepwater dock, a charming waterside boathouse, and a serene coastal setting that spans nearly an acre. Elevated to maximize wide ocean vistas, and entirely out of the flood zone, the grounds are adorned with lush landscaping and manicured lawns, creating a stunning backdrop for this exclusive retreat.<br /> The five-bedroom main residence offers 5,600 square feet of light-filled living space, featuring a versatile multi-level floor plan designed to embrace its spectacular surroundings. Highlights include a spacious living room, family room, sunroom, and a chef's kitchen with a dining area, breakfast nook, and cozy sitting space—each with access to expansive multi-tiered decks overlooking the water. Most rooms showcase mesmerizing water views, while the third-floor widow's walk reveals the most dramatic oceanfront panorama.<br /> Enhancing the estate is a thoughtfully designed two-bedroom guest house spanning 1,794 square feet. Complete with a large bonus room and a private balcony overlooking the water, it provides an ideal space for hosting family and friends. Additional amenities include a three-car garage, a main house generator, hurricane shutters, and a separate 0.38-acre parcel featuring a private white sand beach on Nantucket Sound. This rare offering seamlessly blends coastal elegance with modern convenience, capturing the essence of true seaside living. With its panoramic vistas and unparalleled amenities, this property represents a once-in-a-lifetime opportunity to own a piece of Cape Cod paradise.
MlsNumber: --
ListingId: 22500241


Listing Provided By: Berkshire Hathaway HomeServices Robert Paul Properties, original listing
Phone: (508) 420-1414
Office Phone: (508) 420-1414
Agent Name: Robert Kinlin
Disclaimer: Copyright © 2025 Cape Cod & Islands Association of REALTORS&#174;, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1221 AND i.igate IN ('usahud','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Dennis Murphy
Dennis Murphy
ASCIIWeichert Realtors - Donohue Partners
Call Today!: (508) 294-3126

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App