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','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;

2 S Precinct Road
Centerville, MA 02632

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1104
Agency: Startpoint Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1978
Notes: This great three-bedroom, two-bath, two-car garage home is in the quiet, secluded neighborhood of Pineridge. Yet it is close to everything you'd want from the Cape: shopping, restaurants, beaches, culture, and recreation. The wider-than-usual lots in this section allow privacy between each home. <br /> <br /> The living room is striking, with cathedral ceilings, a working fireplace, and incredible light from the southeast-facing windows.<br /> <br /> The primary bedroom has an en-suite bath, double sinks, and a new shower. The two other bedrooms are large enough for queen-sized beds, as shown in the photos. <br /> <br /> The renovation is complete, with new floors throughout the home, new tile and vanities in the baths, new soft-close kitchen cabinets that offer exceptional storage, a built-in six-foot pantry buffet, quartz countertops, and appliances. The deck off the kitchen is a great place to entertain family and friends. The enormous walk-out basement is ready for your ideas and plans. It would be a fantastic place for a new office with great light from a bank of windows. A new asphalt driveway leads up to the enormous two-car garage. This great three-bedroom, two-bath, two-car garage home is in the quiet, secluded neighborhood of Pineridge. Yet it is close to everything you'd want from the Cape: shopping, restaurants, beaches, culture, and recreation. The wider-than-usual lots in this section allow privacy between each home. <br /> <br /> The living room is striking, with cathedral ceilings, a working fireplace, and incredible light from the southeast-facing windows.<br /> <br /> The primary bedroom has an en-suite bath, double sinks, and a new shower. The two other bedrooms are large enough for queen-sized beds, as shown in the photos. <br /> <br /> The renovation is complete, with new floors throughout the home, new tile and vanities in the baths, new soft-close kitchen cabinets that offer exceptional storage, a built-in six-foot pantry buffet, quartz countertops, and appliances. The deck off the kitchen is a great place to entertain family and friends. The enormous walk-out basement is ready for your ideas and plans. It would be a fantastic place for a new office with great light from a bank of windows. A new asphalt driveway leads up to the enormous two-car garage. <br /> <br /> The mature landscaping and trees add character to the home. There is a bank of forsythia that surrounds the house on the back and the right side.<br /> <br /> There are new appliances, a new Navien tankless water heater, a new front entry, new blinds, new lighting, inside and out. Other features include an automatic attic thermostat/fan for cooling and a gas line in the kitchen for conversion to a gas stove.<br /> <br /> Lumbert Pond Conservation Area is less than a mile away and is great for nature walks. There's an entry to the conservation area about 1/3 mile away. Dowses and Craigville Beaches are less than four miles away, or about ten minutes' drive.<br /> <br /> The seller has tested the septic and installed a new D box. We are waiting for the final inspection and finishing of the job. The home is not scheduled for municipal sewer in the next thirty years, according to the town of Barnstable Comprehensive Wastewater Management Plan map. (see map in photos)<br /> <br /> All you have to do is move in!<br /> <br /> More photos coming.
MlsNumber: 22401317


Listing Provided By: Startpoint Realty, original listing
Name: Startpoint Realty
Phone: (978) 422-3999
Office Name: Startpoint Realty
Office Phone: (978) 422-3999
Agent Name: John Stringfellow
Disclaimer: Copyright © 2024 Cape Cod & Islands Association of REALTORS ®, 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','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;
Dennis Reardon
ASCIICape and Islands Realty Advisors
Call Today!: (508) 274-2805

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App