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
Copied
Photo
Photo
Photo
See all photos

$4,495,000

For Sale - Active
4 Middle Hollow Rd, Huntington, NY 11743
5 Beds
7.0 Baths
6,700 Square Feet
0.00 Acres Lot
Built in 2025
For Sale - Active
Units n/a
Checked: 5 hours ago
Updated: May 01, 2025 at 03:26AM

Investment Summary


Monthly Cash Flow
-$19,814
Cap Rate
0.8%
Cash-on-Cash Return
-23.0%
Debt Coverage Ratio
0.13
Internal Rate of Return (5 years)
-18.2%

Property Description


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

Welcome to this extraordinary Brand-New Construction Hampton-Style Colonial Home, nestled on two flat, beautifully landscaped acres in the prestigious Village of Lloyd Harbor! Construction has just begun, and the target completion date is the end of August, in time for the school year. Boasting over 6700+ sq ft of luxurious living space-plus an additional 4500 sq ft walk-out basement with 10' ceilings and separate egress-this home delivers space, sophistication, and timeless design at every turn. Designed for both comfort and grandeur, the home features 10-foot ceilings on the main floor and 9-foot ceilings upstairs, creating an airy, open atmosphere. The show stopping designer kitchen includes an oversized island, quartzite countertops, Sub-Zero/Wolf appliances, butler's pantry, and an impressive Sub/Zero wine cooler-ideal for hosting and everyday living. Every one of the 5 spacious bedrooms comes with its own en-suite bathroom and walk-in closet, including a stunning primary suite with three oversized walk-ins and a luxurious spa bathroom featuring radiant heated floors, a glass-enclosed shower, and a private toilet room.The home also includes a versatile 700 sq ft bonus room, perfect for a home office, gym, playroom, or media space-tailor it to suit your lifestyle. Exceptional features include: Linear Natural Gas Fireplace, Marvin Windows, Hideaway central Vacuum system, Whole-House Audio & Security system, Two Staircases to the basement, Large Mudroom with Custom Built-Ins, 3-Car Garage, Nearly 60 Foot covered Front Porch, Full property sprinkler system Outside, enjoy the gigantic backyard, complete with professional landscape plans and over 150 mature tress and plantings, offering a private, park-like setting. Located within the award - winning Cold Spring Harbor School District, this home also features the newest septic system, 1 1/2" main water line, and every modern convenience for today's discerning buyer. This is more than a home- it's a sanctuary of syle, space, and sophistication in one of Long Island's most exclusive communities.

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: Private, Driveway
  • Details: Attached, Driveway, Garage Door Opener
  • Garage Spaces: 3
  • Spaces Total: 0

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Full): 5
  • # of Baths (Total): 7.0

Interior Features

  • # of Rooms: 11
  • Basement: Yes
  • Basement Description: Full, Unfinished, Walk-Out Access
  • Fireplace: Yes

Land Information

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

Lot Information

  • Parcel ID: 0403013.0004.00038.000
  • Lot Size: 0 sqft

Property Information

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

Tax Information

  • Annual Tax: $16,357

Utilities

  • Water & Sewer: Public
  • Heating: Forced Air, Hot Water
  • Cooling: Central Air, ENERGY STAR Qualified Equipment

Location

  • County: Suffolk

Listing Details


Listed by:
Donna L. Silber
Keystone Realty USA Corp
(631) 261-2800

Source:
OneKey MLS
MLS#: 848903
OneKey MLS

Investment Summary


Monthly Cash Flow
-$19,814
Cap Rate
0.8%
Cash-on-Cash Return
-23.0%
Debt Coverage Ratio
0.13
Internal Rate of Return (5 years)
-18.2%

Purchase Details

Find an Agent

Purchase price:
$4,495,000
Amount financed:
-$3,596,000
Down payment:
$899,000
Closing costs:
$134,850
Rehab costs:
$0
Initial cash invested:
$1,033,850
Square feet:
6,700
Cost per square foot:
$671
Monthly rent per square foot:
$0.93

Financing Details

Find a Lender

Loan amount:
$3,596,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.500%
Principal & interest:
$22,729
Property tax:
$1,363
Insurance:
$434
Private mortgage insurance (PMI):
$0
Monthly payment:
$24,526

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$6,200 $74,400
Vacancy loss: (6%)
6% -$372 -$4,464
Operating income:
$5,828 $69,936

Operating Expenses


% Rent Monthly Yearly
Property taxes: (22%)
22%-$1,363-$16,357
Insurance: (7%)
7%-$434-$5,208
Property management: (8%)
8%-$496-$5,952
Repairs & maintenance: (5%)
5%-$310-$3,720
Capital expenditures: (5%)
5%-$310-$3,720
HOA fees: (0%)
0%$0$0
Total operating expenses: (47%)
47%-$2,913-$34,957

Cash Flow


Monthly Yearly
Net operating income:
$2,915 $34,980
Mortgage payments:
-$22,729 -$272,748
Cash flow:
$19,814 $237,768