Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$2,895,000

For Sale - Active
226 Dunrobin Rd, Mashpee, MA 02649
5 Beds
5 Baths
4,208 Square Feet
0.45 Acres Lot
Built in 2025
For Sale - Active
Units n/a
Checked: 24 hours ago
Updated: Sep 07, 2025 at 06:30PM

Investment Summary


Monthly Cash Flow
-$12,692
Cap Rate
0.4%
Cash-on-Cash Return
-22.9%
Debt Coverage Ratio
0.07
Internal Rate of Return (5 years)
-18.1%

Property Description


0.45 Acres Lot
Built in 2025
For Sale - Active
Units n/a

NEW CONSTRUCTION: Truly remarkable new construction situated at the end of a cul-de sac on one of the last remaining golf front lots at Willowbend. Majestically set on a gentle slope, this spectacular gambrel offers everything you could want in a summer or year round home! Soaring ceilings, a high-end chef's kitchen, walls of glass, a first floor primary suite, spacious first floor office/den, an outdoor covered patio with built in grill and outdoor fireplace with huge backyard calling out for a pool (upgrade option) are just some of the lovely features of this home. On the second floor, 4 guest bedrooms and 3 full baths offer plenty of space for guests. Additionally, there is an unfinished bonus room over the garage which would add another 495 sq. ft. of living space (upgrade option). This house is a must see!

Build Your Team


Quickly find investor-friendly professionals who can help you succeed in real estate investing at any stage of the investing journey.

Avatar
Avatar
Avatar

Agents

Match with investor-friendly agents who can help you find, analyze, and close your next deal

Find an Agent
Avatar
Avatar
Avatar

Lenders

Get the best funding…find investor-friendly lenders who specialize in your deal strategy

Find a Lender
Avatar
Avatar
Avatar

Property Managers

Transition to passive investing. Find a trusted property management partnership that lasts.

Find a Property Manager
Avatar
Avatar
Avatar

Tax Pros & Accountants

Taxes and financial reporting made easy—find experts to create tax savings strategies, file taxes, and more

Find a Tax Pro

Location


Property Details


Parking

  • Details: Attached
  • Garage Spaces: 2
  • Spaces Total: 4

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Full): 4
  • # of Baths (Total): 5.0

Interior Features

  • # of Rooms: 9
  • Basement: Yes
  • Basement Description: Full
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter
  • Roof Material: Shingle

HOA

  • Has HOA: Yes
  • HOA Fee: $4,000/annually

Land Information

  • Land Use: Residential
  • Land Use Subtype: Condominium Unit

Lot Information

  • Parcel ID: MASHM:55B:27L:17
  • Lot Size: 19645 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Contemporary
  • Year Built: 2025

Tax Information

  • Annual Tax: $2,123

Utilities

  • Water & Sewer: Public
  • Heating: Natural Gas, Forced Air
  • Cooling: Central Air

Location

  • County: Barnstable

Investment Summary


Monthly Cash Flow
-$12,692
Cap Rate
0.4%
Cash-on-Cash Return
-22.9%
Debt Coverage Ratio
0.07
Internal Rate of Return (5 years)
-18.1%

Purchase Details

Find an Agent

Purchase price:
$2,895,000
Amount financed:
-$2,316,000
Down payment:
$579,000
Closing costs:
$86,850
Rehab costs:
$0
Initial cash invested:
$665,850
Square feet:
4,208
Cost per square foot:
$688
Monthly rent per square foot:
$0.52

Financing Details

Find a Lender

Loan amount:
$2,316,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$13,700
Property tax:
$177
Insurance:
$154
Private mortgage insurance (PMI):
$0
Monthly payment:
$14,031

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$2,200 $26,400
Vacancy loss: (6%)
6% -$132 -$1,584
Operating income:
$2,068 $24,816

Operating Expenses


% Rent Monthly Yearly
Property taxes: (8%)
8%-$177-$2,123
Insurance: (7%)
7%-$154-$1,848
Property management: (8%)
8%-$176-$2,112
Repairs & maintenance: (5%)
5%-$110-$1,320
Capital expenditures: (5%)
5%-$110-$1,320
HOA fees: (15%)
15%-$333-$3,996
Total operating expenses: (48%)
48%-$1,060-$12,719

Cash Flow


Monthly Yearly
Net operating income:
$1,008 $12,096
Mortgage payments:
-$13,700 -$164,400
Cash flow:
-$12,692 -$152,304