Back to Search
ActiveCondo

$2,395,000

40 Sherburne Commons Ln Unit 23, Nantucket 02554

Beds3
Baths3
Sqft2,405
DOM92
No Photos Available

AddressIntel AI Briefing

Priced nearly in line with neighborhood comps, this offers a balanced entry point for an interior refresh targeting turnkey buyers. Rapid execution of interior improvements could yield a margin if delivered before seasonal buying peaks. Inferred from pricing and time on market rather than from any inspection.

Property Permit History

No permit history found directly associated with this property's address.

Recent Neighborhood Remodeling (Nantucket)

Parcel & Zoning Info

APN--
Official Lot Sqft--
Zoning Code--
SB 9 StatusBlocked

Hazard Snapshot

Flood Zone

None
No data available.

Fire Severity

None
Not in a mapped state fire severity zone.

Liquefaction

No data
Seismic data unavailable.

Fault Zone

No data
Seismic data unavailable.

Not a substitute for a Natural Hazard Disclosure (NHD) report. Zones reflect available GIS data and may not cover all localities. Liquefaction and fault flags: modified from California Geological Survey, Web Service of Official Maps of Alquist-Priolo Earthquake Fault Zones and Web Service of Official Maps of Seismic Hazard Zones (2025).

Proprietary Intelligence

Market Heat Index

0/100

Based on recent sales velocity and local demand in 02554.

Flippability Score

65/100

Measures neighborhood renovation density vs. recent permits on this property.

Bidding War Prob.

0%

Likelihood of multiple offers based on local list-to-sale ratios and DOM.

Proforma ROI Calculator

Back-of-the-napkin deal analysis across development strategies.

Median of 4 recent condo sales in Nantucket (02554): $359/sqft, plus 5% because new houses sold at a median 1.07x their comps across 239 real rebuilds. Sized within 50% of the 3,600 sqft build, because smaller houses sell for more per foot and pricing a rebuild off them overstates resale.

Commission, transfer tax and closing. Deducted from resale before profit, so the ROI below is net of the exit rather than gross.

Interest on the purchase price for the whole project plus half the build budget, since construction draws ramp up. The default is 7% over 33 months, the median purchase-to-sale time of 239 real Peninsula and South Bay rebuilds. Set the rate to 0 for a cash purchase, or use your own lender's terms.

Hard Costs$1,980,000
New Build3,600 sqft
Total Capital Required$4,550,000
Estimated Resale (ARV)$1,357,200
Cost of Sale (5%)-$67,860
Carry (33mo @ 7%)-$668,456
Net Proceeds$620,884

Projected Profit

-$3,929,116
-86.4% ROI

Warning: Project is mathematically underwater.

Recent Comparables (Nantucket 02554)

Sized to the modelled 3,600 sqft build: sales within 50% of it. Smaller houses sell for more per foot, so pricing a rebuild off them overstates resale.

171 Hummock Pond Rd

Sold
$20,000
Sold: 2025-10-29
Lot: -
Sqft: 1940
$/Sqft: $10

3 Yawkey Way # A

Sold
$1,425,000
Sold: 2025-09-19
Lot: -
Sqft: 1981
$/Sqft: $719

6 Daffodil Ln # A

Sold
$1,829,150
Sold: 2025-09-03
Lot: -
Sqft: 2640
$/Sqft: $693

8 Union St

Sold
$50,000
Sold: 2025-01-10
Lot: -
Sqft: 1935
$/Sqft: $26