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 54%
$32.50 /mo
$390 billed annualy
MONTHLY
$69 /mo
billed monthly
7 day free trial. Cancel anytime
Copied
Photo
Photo
Photo
Photo
Photo
See all photos

$4,695,000

For Sale - Active
24 Herkimer Rd, Scarsdale, NY 10583
7 Beds
7.0 Baths
7,947 Square Feet
0.54 Acres Lot
Built in 2014
For Sale - Active
Units n/a
Checked: 2 hours ago
Updated: Apr 24, 2025 at 05:18AM

Investment Summary


Monthly Cash Flow
-$25,545
Cap Rate
-0.3%
Cash-on-Cash Return
-28.4%
Debt Coverage Ratio
-0.04
Internal Rate of Return (5 years)
-23.3%

Property Description


0.54 Acres Lot
Built in 2014
For Sale - Active
Units n/a

Embrace Scarsdale luxury living in this completely turnkey seven-bedroom, six-and-a-half-bathroom showplace featuring expansive designer interiors, exceptional outdoor space and breathtaking views of Quaker Ridge Golf Club, one of the most prestigious golf courses in the world. Built in 2015, this colonial-inspired residence offers 8,000 square feet of living space filled with 9-foot-tall ceilings, custom millwork, hardwood floors and large Pella windows. The classic center-hall layout makes a gracious first impression with a dramatic curved staircase, coat closets and a chic powder room. Relax in the large living room while French doors open to a paneled library, perfect for working from home. Plan your next dinner party in the exquisite formal dining room topped by stunning beamed ceilings. A convenient butler’s pantry leads to the stunning kitchen, where custom cabinetry boasts stone countertops, tile backsplashes, under-cabinet lighting and a fleet of upscale stainless-steel appliances. The massive center island is perfect for meal prep and casual dining under beautiful pendant lighting, while the adjacent breakfast area is wrapped in leafy golf course views. Ahead, the sprawling family room is sure to be a favorite gathering spot thanks to its bold coffered ceilings and gas fireplace. Step out to the impressive double-height cedar deck with wire railing for al fresco entertaining overlooking the golf course and professional landscaping by the renowned Rivi Oren. Below, the 18-foot by 50-foot saltwater pool boasts an electronic pool cover. The adjacent summer kitchen features a built-in grill and bar area with an outdoor TV perfect for barbecues and gameday gatherings. The home’s luxurious accommodations begin on the first floor with a convenient bedroom and full bathroom perfect for staff or guests. The adjacent mudroom ensures organized arrivals and departures with large closets and custom bench seating, drawers and cubbies. Sleep soundly in the upper-level owner’s suite, where a king-size bedroom features soaring tray ceilings, two massive walk-in closets and triple exposures framing treetop views. The exquisite spa bathroom offers a freestanding soaking tub, an oversized walk-in rain shower, separate vanities and a private water closet surrounded in rich marble. Two well-appointed secondary suites on this level include roomy closets and private baths, and two more bedrooms share a convenient Jack-and-Jill bathroom. Fun and games await on the walkout lower level, featuring a sprawling rec room and space for a home theater. A gym, a second office, and another bedroom and bathroom complete the thoughtful and incredibly flexible layout. This home’s extensive upgrades include a new furnace and hot water tank, eight-zone central heat, a whole house generator, a central vacuum, professional waterproofing and a GAF Timberline Lifetime Architectural Shingle roof. A large motor court and heated three-car garage add plenty of off-street parking, while the cedar shingle facade trimmed with shutters adds exceptional curb appeal to this move-in ready Scarsdale beauty. Situated on a peaceful loop abutting Quaker Ridge Golf Club, this special home is ideally located near Quaker Ridge Elementary and other top-rated Scarsdale schools, golf courses, houses of worship, and local shopping. Parkways and the Scarsdale, Mamaroneck and Larchmont Metro-North stations are all just minutes away.

Build Your Team


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

Agents

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

Find an Agent

Lenders

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

Find a Lender

Property Managers

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

Find a Property Manager

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: Attached
  • Details: Attached
  • Garage Spaces: 3
  • Spaces Total: 0

Bedroom Information

  • # of Bedrooms: 7

Bathroom Information

  • # of Baths (Full): 6
  • # of Baths (Partial): 1
  • # of Baths (Total): 7.0

Interior Features

  • # of Rooms: 13
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Finished, Full, Walk-Out Access
  • 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: 55500123.01.65A
  • Lot Size: 23522 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Colonial
  • Year Built: 2014

Tax Information

  • Annual Tax: $79,471

Utilities

  • Water & Sewer: Public
  • Heating: Radiant Floor
  • Cooling: Central Air

Location

  • County: Westchester

Listing Details


Listed by:
Heather D. Harrison
Compass Greater NY, LLC
(914) 725-7737

Source:
OneKey MLS
MLS#: 800914
OneKey MLS

Investment Summary


Monthly Cash Flow
-$25,545
Cap Rate
-0.3%
Cash-on-Cash Return
-28.4%
Debt Coverage Ratio
-0.04
Internal Rate of Return (5 years)
-23.3%

Purchase Details

Find an Agent

Purchase price:
$4,695,000
Amount financed:
-$3,756,000
Down payment:
$939,000
Closing costs:
$140,850
Rehab costs:
$0
Initial cash invested:
$1,079,850
Square feet:
7,947
Cost per square foot:
$591
Monthly rent per square foot:
$1.02

Financing Details

Find a Lender

Loan amount:
$3,756,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.810%
Principal & interest:
$24,511
Property tax:
$6,623
Insurance:
$567
Private mortgage insurance (PMI):
$0
Monthly payment:
$31,701

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$8,100 $97,200
Vacancy loss: (6%)
6% -$486 -$5,832
Operating income:
$7,614 $91,368

Operating Expenses


% Rent Monthly Yearly
Property taxes: (82%)
82%-$6,623-$79,471
Insurance: (7%)
7%-$567-$6,804
Property management: (8%)
8%-$648-$7,776
Repairs & maintenance: (5%)
5%-$405-$4,860
Capital expenditures: (5%)
5%-$405-$4,860
HOA fees: (0%)
0%$0$0
Total operating expenses: (107%)
107%-$8,648-$103,771

Cash Flow


Monthly Yearly
Net operating income:
-$1,034 -$12,408
Mortgage payments:
-$24,511 -$294,132
Cash flow:
$25,545 $306,540