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
Level up your investing with Pro
Explore exclusive tools and resources to start, grow, or optimize your portfolio.
10+ investment analysis calculators
$1,000+/yr savings on landlord software
Lawyer-reviewed lease forms (annual only)
Unlimited access to the Forums

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

$2,499,000

Sale Pending
249 Little Neck Rd, Centerport, NY 11721
5 Beds
5 Baths
4,900 Square Feet
1.06 Acres Lot
Built in 2004
Sale Pending
1 Units
Checked: 4 days ago
Updated: Sep 05, 2025 at 10:17AM

Investment Summary


Monthly Cash Flow
-$9,191
Cap Rate
1.7%
Cash-on-Cash Return
-19.2%
Debt Coverage Ratio
0.27
Internal Rate of Return (5 years)
-14.5%

Property Description


1.06 Acres Lot
Built in 2004
Sale Pending
1 Units

Introducing an exquisite waterfront masterpiece nestled along the prestigious Vanderbilt Peninsula, featuring a private beach and direct water access with private mooring. This is a rare opportunity to claim a slice of the North Shore’s illustrious Gold Coast. Each evening, you will be treated to spectacular sunsets that paint the skyline. Situated majestically on a hill, this home offers an exceptional level of privacy coupled with sweeping panoramic water views. As you enter, you are greeted by a grand two-story foyer that sets the tone for the elegance within. The stunning living room showcases dramatic architectural windows specifically designed to frame the picturesque water views, highlighted by soaring ceilings that create a bright and airy feeling. Sliding glass doors invite you out to an elevated deck, perfect for al fresco dining or simply soaking in the breathtaking surroundings. The living room also features a charming wood-burning fireplace adorned with a blue stone hearth, providing warmth and sophistication. The designer kitchen has been thoughtfully renovated to include stylish white shaker cabinets, luxurious quartz countertops, and a generously-sized center island ideal for both cooking and entertaining. It boasts high-end stainless steel appliances, including a double oven and a wine chiller. The main level also incorporates a formal dining room that creates an inviting atmosphere for hosting gatherings, a home office with elegant glass sliders for privacy, a casual den for lounging, and a convenient powder room for guests. On the upper level, the primary en-suite serves as a private retreat, featuring its own balcony for morning coffee or sunset views. The en-suite bathroom provides indulgence with a soaking tub, a glass-enclosed shower, and a custom walk-in closet designed for optimal organization and ease. Complementing the primary suite are two additional junior en-suites, each with generous closet space, ensuring comfort and privacy for family or guests. A well-placed laundry room is also conveniently located on this level. Venture down to the lower level, where another inviting living room awaits, complete with a wood-burning fireplace and glass doors that lead to a covered blue stone patio, perfect for relaxing outdoors while enjoying the serene atmosphere. This level also includes two additional bedrooms and a full bathroom, perfect for accommodating visitors or family. A practical mudroom with easy access to the driveway enhances the home's functionality. Additional features include central air conditioning, radiant heat, gleaming hardwood floors throughout and exquisite craftsmanship. The whole house generator ensures uninterrupted comfort. The home is located in Harborfields School District. Don’t miss your chance to own this one-of-a-kind waterfront retreat.

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: Private
  • Details: Driveway
  • Garage Spaces: 0
  • Spaces Total: 9

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Full): 4
  • # of Baths (Partial): 1
  • # of Baths (Total): 5.0

Interior Features

  • # of Rooms: 12
  • Basement: Yes
  • Basement Description: Finished, Storage Space, Walk-Out Access
  • Fireplace: Yes

Land Information

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

Lot Information

  • Parcel ID: 0400048.0001.00001.000
  • Lot Size: 46174 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Traditional
  • Year Built: 2004

Tax Information

  • Annual Tax: $40,637

Utilities

  • Water & Sewer: Public
  • Heating: Hot Water, Oil, Radiant, Radiant Floor
  • Cooling: Central Air, Ductless

Location

  • County: Suffolk

Listing Details


Listed by:
Jamie Pastorelli CBR
Signature Premier Properties
(516) 238-3958

Source:
OneKey MLS
MLS#: 846675
OneKey MLS

Investment Summary


Monthly Cash Flow
-$9,191
Cap Rate
1.7%
Cash-on-Cash Return
-19.2%
Debt Coverage Ratio
0.27
Internal Rate of Return (5 years)
-14.5%

Purchase Details

Find an Agent

Purchase price:
$2,499,000
Amount financed:
-$1,999,200
Down payment:
$499,800
Closing costs:
$74,970
Rehab costs:
$0
Initial cash invested:
$574,770
Square feet:
4,900
Cost per square foot:
$510
Monthly rent per square foot:
$2.02

Financing Details

Find a Lender

Loan amount:
$1,999,200
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.500%
Principal & interest:
$12,636
Property tax:
$3,386
Insurance:
$693
Private mortgage insurance (PMI):
$0
Monthly payment:
$16,715

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$9,900 $118,800
Vacancy loss: (6%)
6% -$594 -$7,128
Operating income:
$9,306 $111,672

Operating Expenses


% Rent Monthly Yearly
Property taxes: (34%)
34%-$3,386-$40,637
Insurance: (7%)
7%-$693-$8,316
Property management: (8%)
8%-$792-$9,504
Repairs & maintenance: (5%)
5%-$495-$5,940
Capital expenditures: (5%)
5%-$495-$5,940
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (59%)
59%-$5,861-$70,337

Cash Flow


Monthly Yearly
Net operating income:
$3,445 $41,340
Mortgage payments:
-$12,636 -$151,632
Cash flow:
-$9,191 -$110,292