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

$8,895,000

For Sale - Active
40 Piping Rock Rd, Locust Valley, NY 11560
5 Beds
10 Baths
19,900 Square Feet
5.23 Acres Lot
Built in 1925
For Sale - Active
1 Units
Checked: 19 hours ago
Updated: Jul 17, 2025 at 10:39AM

Investment Summary


Monthly Cash Flow
-$50,340
Cap Rate
-0.7%
Cash-on-Cash Return
-29.5%
Debt Coverage Ratio
-0.12
Internal Rate of Return (5 years)
-24.4%

Property Description


5.23 Acres Lot
Built in 1925
For Sale - Active
1 Units

A Sanctuary of Sophistication, Sustainability And Serenity 40 Piping Rock Road in Matinecock- Tucked behind a gated entry and embraced by over seven acres of lush, verdant grounds in the heart of the Village of Matinecock, 40 Piping Rock Road is more than a home—it’s a restorative retreat. Originally built in 1925 and thoughtfully renovated in 2008, this timeless Colonial estate blends historic grandeur with modern wellness-focused living. Every inch of this distinguished residence invites balance and harmony. Breathe deeply in light-filled living spaces designed for both elegant entertaining and quiet reflection. The gracious floor plan features a formal living room and dining room, a spacious family room with a striking fireplace, and a beautifully appointed eat-in kitchen with marble countertops, a walk-in pantry, and seamless flow to the gardens—perfect for farm-to-table living. The main house offers five tranquil bedrooms, each with en-suite full bathrooms, and additional three half baths. A finished lower level adds space for play and peace alike, with a media room, playroom, custom wine cellar, and ample storage. Two charming guest cottages extend the lifestyle: one featuring a one-bedroom suite above a two-car garage, and another with two bedrooms and a state-of-the-art gym, each with its own garage and private entrance—perfect for guests, staff, or creative studios. Outside, nature becomes part of everyday life. Dine alfresco surrounded by mature trees and curated gardens. Harvest your own vegetables from the built-in garden, relax in the newly constructed greenhouse equipped with a space for meditation and hot yoga, or take a mindful morning swim in the heated saltwater gunite pool. A tennis/sport court and expansive lawn add to the estate’s recreational appeal. This home is equipped with radiant heat, a full-property generator, and eco-conscious systems to support sustainable living, nearby to town, restaurants, and the LIRR. Close to country clubs, yacht clubs, and Locust Valley schools, this is a rare opportunity to live luxuriously—with intention.

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

  • Description: Detached, Private
  • Garage Spaces: 5
  • Spaces Total: 0

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Full): 7
  • # of Baths (Partial): 3
  • # of Baths (Total): 10.0

Interior Features

  • # of Rooms: 16
  • # of Stories: 2
  • Attic: Yes
  • Basement: Yes
  • Basement Description: Full
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Wood
  • Pool: Yes

Land Information

  • Land Use: Residential
  • Land Use Subtype: Single Family Residential

Lot Information

  • Parcel ID: 23043000042
  • Lot Size: 227819 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Colonial, Estate
  • Year Built: 1925

Tax Information

  • Annual Tax: $123,954

Utilities

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

Location

  • County: Nassau

Listing Details


Listed by:
Lindsey D. Barnett
Compass Greater NY LLC
(516) 972-4261

Source:
OneKey MLS
MLS#: 848722
OneKey MLS

Investment Summary


Monthly Cash Flow
-$50,340
Cap Rate
-0.7%
Cash-on-Cash Return
-29.5%
Debt Coverage Ratio
-0.12
Internal Rate of Return (5 years)
-24.4%

Purchase Details

Find an Agent

Purchase price:
$8,895,000
Amount financed:
-$7,116,000
Down payment:
$1,779,000
Closing costs:
$266,850
Rehab costs:
$0
Initial cash invested:
$2,045,850
Square feet:
19,900
Cost per square foot:
$447
Monthly rent per square foot:
$0.36

Financing Details

Find a Lender

Loan amount:
$7,116,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.500%
Principal & interest:
$44,978
Property tax:
$10,330
Insurance:
$504
Private mortgage insurance (PMI):
$0
Monthly payment:
$55,812

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$7,200 $86,400
Vacancy loss: (6%)
6% -$432 -$5,184
Operating income:
$6,768 $81,216

Operating Expenses


% Rent Monthly Yearly
Property taxes: (143%)
143%-$10,330-$123,954
Insurance: (7%)
7%-$504-$6,048
Property management: (8%)
8%-$576-$6,912
Repairs & maintenance: (5%)
5%-$360-$4,320
Capital expenditures: (5%)
5%-$360-$4,320
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (168%)
168%-$12,130-$145,554

Cash Flow


Monthly Yearly
Net operating income:
-$5,362 -$64,344
Mortgage payments:
-$44,978 -$539,736
Cash flow:
$50,340 $604,080