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

$4,500,000

For Sale - Active
2 Aspen Pl, Great Neck, NY 11021
7 Beds
7 Baths
6,850 Square Feet
0.78 Acres Lot
Built in 1923
For Sale - Active
1 Units
Checked: 19 hours ago
Updated: Jun 07, 2025 at 03:05AM

Investment Summary


Monthly Cash Flow
-$20,180
Cap Rate
0.7%
Cash-on-Cash Return
-23.4%
Debt Coverage Ratio
0.11
Internal Rate of Return (5 years)
-18.6%

Property Description


0.78 Acres Lot
Built in 1923
For Sale - Active
1 Units

Experience the pinnacle of luxury living in this magnificent 7-bedroom, 6.5-bath expanded ranch, perfectly situated on a sprawling 0.76-acre lot in the prestigious Village of Great Neck Estates. Designed for both comfort and grand entertaining, this home features an open-concept layout with soaring vaulted ceilings, hardwood flooring, and multiple stone fireplaces. The sun-drenched living room flows seamlessly into the elegant formal dining room, while the expansive eat-in kitchen completes with high-end appliances, a charming breakfast nook, and an adjacent den serves as the heart of the home. A spectacular sunroom spans the width of the house, offering stunning views of the resort-like backyard with its patio, built-in BBQ station. The first-floor primary suite is a private retreat, featuring French doors that open to the luxurious gunite pool with spa, a fireplace, a spa-like en-suite bath with a Jacuzzi tub and steam shower, a dressing room, and dual walk-in closets. Three additional bedrooms and two baths complete the first floor. Upstairs, a dramatic loft design enhances the airy feel, with two wings offering two en-suite bedrooms, and a versatile sitting area. Additional highlights include an attached two-car garage with direct kitchen access, a full-house generator, central and ductless AC, gas heating and cooking, and a partial basement with an additional laundry room and storage. The circular Belgian block driveway provides convenience and elegance. Located just a block from the private Village Park, residents enjoy exclusive access to an Olympic-size pool, kiddie pool, tennis courts, marina, sports fields, and playgrounds. With zoning for Saddle Rock Elementary and the option of North or South Middle/High School, this home offers the ultimate in luxury, convenience, and lifestyle. A rare opportunity to own a true masterpiece the prestigious Village of Great Neck Estates with Private Police force.

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: Garage
  • Garage Spaces: 2
  • 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: 1
  • Basement: Yes
  • Basement Description: Partial, Unfinished
  • 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: 02338000005
  • Lot Size: 33794 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Exp Ranch
  • Year Built: 1923

Tax Information

  • Annual Tax: $52,744

Utilities

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

Location

  • County: Nassau

Listing Details


Listed by:
Peter Rosenblum
LAFFEY REAL ESTATE
(212) 777-7770

Source:
OneKey MLS
MLS#: 830812
OneKey MLS

Investment Summary


Monthly Cash Flow
-$20,180
Cap Rate
0.7%
Cash-on-Cash Return
-23.4%
Debt Coverage Ratio
0.11
Internal Rate of Return (5 years)
-18.6%

Purchase Details

Find an Agent

Purchase price:
$4,500,000
Amount financed:
-$3,600,000
Down payment:
$900,000
Closing costs:
$135,000
Rehab costs:
$0
Initial cash invested:
$1,035,000
Square feet:
6,850
Cost per square foot:
$657
Monthly rent per square foot:
$1.47

Financing Details

Find a Lender

Loan amount:
$3,600,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.500%
Principal & interest:
$22,754
Property tax:
$4,395
Insurance:
$707
Private mortgage insurance (PMI):
$0
Monthly payment:
$27,856

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$10,100 $121,200
Vacancy loss: (6%)
6% -$606 -$7,272
Operating income:
$9,494 $113,928

Operating Expenses


% Rent Monthly Yearly
Property taxes: (44%)
44%-$4,395-$52,745
Insurance: (7%)
7%-$707-$8,484
Property management: (8%)
8%-$808-$9,696
Repairs & maintenance: (5%)
5%-$505-$6,060
Capital expenditures: (5%)
5%-$505-$6,060
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (69%)
69%-$6,920-$83,045

Cash Flow


Monthly Yearly
Net operating income:
$2,574 $30,888
Mortgage payments:
-$22,754 -$273,048
Cash flow:
$20,180 $242,160