Welcome to your exquisite Cape Cod dream home, situated on almost 2 private acres. This luxurious 5BR/4.5BA property is comprised of three separate living spaces. The main house features a stunning open concept floor plan with high-end finishes throughout. The first floor level offers a spacious living room, dining area, gourmet kitchen, office and first floor primary bedroom. The lower level has a family/media room with high ceilings, laundry room, storage AND a 1BR/1BA guest quarters with a private entrance and second kitchen. The detached 3-car garage has a legal 1BR/1BA apartment, fully permitted and completed in 2022. The spectacularly landscaped grounds and large yard with back deck, pergola and patio completing the outdoor living space. The property also offers seasonal peeks of water views of Mashpee Wakeby Lake. Don't miss your chance to experience the epitome of quintessential Cape Cod living. 151 and 161 Pimlico Pond Road being sold together. Note: All information provided is deemed reliable, but is not guaranteed and should be independently verified.
Sold for $1,125,000
Street View
$1,125,000
151 Pimlico Pond Road, Mashpee, MA 02649
5beds
3,758sqft
Single Family Residence
Built in 1997
1.84 Acres Lot
$1,199,800 Zestimate®
$299/sqft
$5,548 Estimated rent
Home value
$1,199,800
$1.12M - $1.31M
$5,548/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$5,548/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$5,548/mo
Rent Zestimate®
Refinance and save
$6,706/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$6,706/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: September 09, 2024 at 11:10pm
Listed by:
Livia A Freitas Monteforte 508-274-6185,
Compass Massachusetts, LLC
Bought with:
Tia Lilly, 9535706
Property Cape Cod
Source: CCIMLS,MLS#: 22300684
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 2
Primary bedroom
- Level: First
Bedroom 2
- Level: Second
Bedroom 3
- Level: Second
Bedroom 4
- Level: Basement
Dining room
- Level: First
Kitchen
- Level: First
Living room
- Level: First
Heating
- Forced Air, Hot Water
Cooling
- None
Appliances
- Included: Gas Water Heater
- Laundry: In Basement
Features
- Interior Balcony
- Flooring: Hardwood, Carpet, Tile, Vinyl
- Basement: Finished,Interior Entry,Full
- Number of fireplaces: 2
Interior area
- Total structure area: 3,758
- Total interior livable area: 3,758 sqft
Property
Parking
- Total spaces: 6
- Parking features: Garage, Open
- Garage spaces: 3
- Has uncovered spaces: Yes
Features
- Stories: 3
- Entry location: First Floor
- Exterior features: Private Yard, Garden
- Fencing: Fenced
Lot
- Size: 1.84 Acres
- Features: Conservation Area, School, Medical Facility, Major Highway, House of Worship, Shopping, Level
Details
- Parcel number: 21340
- On leased land: Yes
- Zoning: R5
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Clapboard, Shingle Siding
- Foundation: Poured
- Roof: Asphalt, Pitched
Condition
- Updated/Remodeled, Actual, Approximate
- New construction: No
- Year built: 1997
- Major remodel year: 202
Details
- Warranty included: Yes
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & neighborhood
Location
- Region: Mashpee
Other
Other facts
- Listing terms: Conventional
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 5/18/2023 | Sold | $1,125,000-5.9%$299/sqft |
Source:  CCIMLS #22300684 Report a problem | ||
| 3/8/2023 | Pending sale | $1,195,000$318/sqft |
Source: CCIMLS #22300684 Report a problem | ||
| 3/8/2023 | Contingent | $1,195,000$318/sqft |
Source: MLS PIN #73083327 Report a problem | ||
| 3/3/2023 | Listed for sale | $1,195,000+285.5%$318/sqft |
Source: MLS PIN #73083327 Report a problem | ||
| 4/17/2014 | Sold | $310,000+0.7%$82/sqft |
Source: Agent Provided Report a problem | ||
| 1/24/2014 | Listed for sale | $307,850-3.1%$82/sqft |
Source: REALHome Services and Solutions #71579303 Report a problem | ||
| 11/17/2013 | Listing removed | $317,850$85/sqft |
Source: REALHome Services and Solutions #71579303 Report a problem | ||
| 11/9/2013 | Price change | $317,850-3.1%$85/sqft |
Source: REALHome Services and Solutions #71579303 Report a problem | ||
| 9/7/2013 | Listed for sale | $327,850+61.5%$87/sqft |
Source: Hubzu #71579303 Report a problem | ||
| 11/29/2012 | Listing removed | $203,000$54/sqft |
Source: REALHome Services and Solutions Report a problem | ||
| 11/22/2012 | Price change | $203,000+2%$54/sqft |
Source: REALHome Services and Solutions Report a problem | ||
| 11/10/2012 | Price change | $199,000+0.5%$53/sqft |
Source: REALHome Services and Solutions Report a problem | ||
| 11/2/2012 | Price change | $198,000-6.6%$53/sqft |
Source: REALHome Services and Solutions Report a problem | ||
| 10/25/2012 | Price change | $212,000+9.8%$56/sqft |
Source: REALHome Services and Solutions Report a problem | ||
| 10/18/2012 | Price change | $193,000-1%$51/sqft |
Source: REALHome Services and Solutions Report a problem | ||
| 10/9/2012 | Price change | $195,000-1%$52/sqft |
Source: REALHome Services and Solutions Report a problem | ||
| 9/29/2012 | Price change | $197,000-7.1%$52/sqft |
Source: REALHome Services and Solutions??? Report a problem | ||
| 9/21/2012 | Price change | $212,000+7.6%$56/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 9/13/2012 | Price change | $197,000-2%$52/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 9/5/2012 | Listed for sale | $201,000-16.9%$53/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 8/31/2012 | Sold | $242,000+22.2%$64/sqft |
Source: Public Record Report a problem | ||
| 8/28/2012 | Price change | $198,000-0.5%$53/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 8/18/2012 | Price change | $199,000-0.5%$53/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 8/10/2012 | Price change | $200,000+3.6%$53/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 8/8/2012 | Price change | $193,000+0.5%$51/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 8/2/2012 | Price change | $192,000-2.5%$51/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
| 7/25/2012 | Listed for sale | $197,000$52/sqft |
Source: Altisource Portfolio Solutions Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,403 +8.2% | $816,100 +5% |
| 2024 | $4,995 +8.7% | $776,900 +18.5% |
| 2023 | $4,594 +3.5% | $655,400 +20.6% |
| 2022 | $4,440 +2.1% | $543,400 +13.3% |
| 2021 | $4,349 +2.7% | $479,500 +2.9% |
| 2020 | $4,234 +5.1% | $465,800 +4.6% |
| 2019 | $4,029 +5.2% | $445,200 +3.7% |
| 2018 | $3,830 +13.1% | $429,400 +16.5% |
| 2017 | $3,387 +8.3% | $368,600 +8.9% |
| 2016 | $3,128 +4.2% | $338,500 +2.7% |
| 2015 | $3,002 +5% | $329,500 +8.2% |
| 2014 | $2,859 +2.8% | $304,500 +1.6% |
| 2013 | $2,780 +0.4% | $299,600 -3.1% |
| 2012 | $2,770 +0.7% | $309,200 -0.8% |
| 2011 | $2,751 +10% | $311,600 -2.9% |
| 2010 | $2,500 -5.8% | $320,900 -15.4% |
| 2009 | $2,653 +4.3% | $379,500 -1.8% |
| 2008 | $2,543 +7.3% | $386,400 -4.8% |
| 2007 | $2,370 -23.2% | $405,800 -12.1% |
| 2006 | $3,085 +6% | $461,900 +3% |
| 2005 | $2,911 +3.2% | $448,500 +54.9% |
| 2004 | $2,821 +12.8% | $289,600 +10.1% |
| 2003 | $2,501 +11% | $263,000 +58.4% |
| 2001 | $2,254 | $166,000 |
Find assessor info on the county website
Neighborhood: 02649
Nearby schools
GreatSchools rating
- 5/10Quashnet SchoolGrades: 3-6Distance: 4 mi
- 5/10Mashpee High SchoolGrades: 7-12Distance: 4.7 mi
Schools provided by the listing agent
- District: Mashpee
Source: CCIMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,199,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,199,800
- Massachusetts
- Barnstable County
- Mashpee
- 02649
- 151 Pimlico Pond Road